$query = $database->prepare ('UPDATE forumLinks (active, confirmationCode) SET active=1, time=:time WHERE confirmationCode=:confirmationCode;');
                            $query->bindValue (':confirmationCode', $confirmationCode);
                            $query->bindValue (':time', time ());
                            $query->execute ();