Avatar billede winpower Nybegynder
16. juli 2004 - 10:02 Der er 6 kommentarer

Kan ikke opdatere data i database

Jeg er ikke så skrap til mysql men jeg har fået lavet et felt i en database og jeg har også fået lavet feltet på den phpside som det skal, jeg kan også læse data i feltet på phpsiden hvis jeg skriver det i feltet i myphpadmin men hvis jeg retter det på siden som jeg skal vil den ikke rette det i databasen......

Det forstår jeg ikke!!!

Jeg er som sagt ret ny til mysql så det er nok der fejlen er men hvad kan det være?

Nogle der kan hjælpe?
Avatar billede erikjacobsen Ekspert
16. juli 2004 - 10:03 #1
Du kan jo vise os din kode.
Avatar billede winpower Nybegynder
16. juli 2004 - 10:20 #2
kommer her:

<?php

if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {
    die ("You can't access this file directly...");
}

require_once("mainfile.php");
$module_name = basename(dirname(__FILE__));
get_lang($module_name);
$userpage = 1;

include("modules/$module_name/navbar.php");

function userCheck($username, $user_email) {
    global $stop, $user_prefix, $db;
    if ((!$user_email) || ($user_email=="") || (!eregi("^[_\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\.)+[a-z]{2,6}$",$user_email))) $stop = "<center>"._ERRORINVEMAIL."</center><br>";
    if (strrpos($user_email,' ') > 0) $stop = "<center>"._ERROREMAILSPACES."</center>";
    if ((!$username) || ($username=="") || (ereg("[^a-zA-Z0-9_-]",$username))) $stop = "<center>"._ERRORINVNICK."</center><br>";
    if (strlen($username) > 25) $stop = "<center>"._NICK2LONG."</center>";
    if (eregi("^((root)|(adm)|(linux)|(webmaster)|(admin)|(god)|(administrator)|(administrador)|(nobody)|(anonymous)|(anonimo)|(anónimo)|(operator))$",$username)) $stop = "<center>"._NAMERESERVED."";
    if (strrpos($username,' ') > 0) $stop = "<center>"._NICKNOSPACES."</center>";
    if ($db->sql_numrows($db->sql_query("SELECT username FROM ".$user_prefix."_users WHERE username='$username'")) > 0) $stop = "<center>"._NICKTAKEN."</center><br>";
    if ($db->sql_numrows($db->sql_query("SELECT username FROM ".$user_prefix."_users_temp WHERE username='$username'")) > 0) $stop = "<center>"._NICKTAKEN."</center><br>";
    if ($db->sql_numrows($db->sql_query("SELECT user_email FROM ".$user_prefix."_users WHERE user_email='$user_email'")) > 0) $stop = "<center>"._EMAILREGISTERED."</center><br>";
    if ($db->sql_numrows($db->sql_query("SELECT user_email FROM ".$user_prefix."_users_temp WHERE user_email='$user_email'")) > 0) $stop = "<center>"._EMAILREGISTERED."</center><br>";
//    if ($db->sql_numrows($db->sql_query("SELECT idnr FROM ".$user_prefix."_users WHERE idnr='$idnr'")) > 0) $stop = "<center>"._IDNRREGISTERED."</center><br>";
//    if ($db->sql_numrows($db->sql_query("SELECT idnr FROM ".$user_prefix."_users_temp WHERE idnr='$idnr'")) > 0) $stop = "<center>"._IDNRREGISTERED."</center><br>";
    return($stop);
}

function makePass() {
    $cons = "bcdfghjklmnpqrstvwxyz";
    $vocs = "aeiou";
    for ($x=0; $x < 6; $x++) {
    mt_srand ((double) microtime() * 1000000);
    $con[$x] = substr($cons, mt_rand(0, strlen($cons)-1), 1);
    $voc[$x] = substr($vocs, mt_rand(0, strlen($vocs)-1), 1);
    }
    $makepass = $con[0] . $voc[0] .$con[2] . $con[1] . $voc[1] . $con[3] . $voc[3] . $con[4];
    return($makepass);
}

function confirmNewUser($username, $user_email, $user_password, $user_password2, $random_num, $gfx_check) {
    global $stop, $EditedMessage, $sitename, $module_name, $minpass;
    include("header.php");
    include("config.php");
    filter_text($username);
    $username = $EditedMessage;
    $user_viewemail = "0";
    userCheck($username, $user_email);
    if (!$stop) {
    $datekey = date("F j");
    $rcode = hexdec(md5($_SERVER[HTTP_USER_AGENT] . $sitekey . $_POST[random_num] . $datekey));
    $code = substr($rcode, 2, 6);
    if (extension_loaded("gd") AND $code != $gfx_check AND ($gfx_chk == 3 OR $gfx_chk == 4 OR $gfx_chk == 6 OR $gfx_chk == 7)) {
        title(""._NEWUSERERROR."");
        OpenTable();
        echo "<center><b>"._SECCODEINCOR."</b><br><br>"
        .""._GOBACK."</center>";
        CloseTable();
        include("footer.php");
        die();
    }
    if ($user_password == "" AND $user_password2 == "") {
        $user_password = makepass();
    } elseif ($user_password != $user_password2) {
        title(""._NEWUSERERROR."");
        OpenTable();
        echo "<center><b>"._PASSDIFFERENT."</b><br><br>"._GOBACK."</center>";
        CloseTable();
        include("footer.php");
        die();
    } elseif ($user_password == $user_password2 AND strlen($user_password) < $minpass) {
        title(""._NEWUSERERROR."");
        OpenTable();
        echo "<center>"._YOUPASSMUSTBE." <b>$minpass</b> "._CHARLONG."<br><br>"._GOBACK."</center>";
        CloseTable();
        include("footer.php");
        die();
    }
    title("$sitename: "._USERREGLOGIN."");
    OpenTable();
    echo "<center><b>"._USERFINALSTEP."</b><br><br>$username, "._USERCHECKDATA."</center><br><br>"
        ."<table align='center' border='0'>"
        ."<tr><td><b>"._UUSERNAME.":</b> $username<br></td></tr>"
          ."<tr><td><b>"._IDNR.":</b> $user_idnr<br></td></tr>"
        ."<tr><td><b>"._EMAIL.":</b> $user_email</td></tr></table><br><br>"
        ."<center><b>"._NOTE."</b> "._YOUWILLRECEIVE."";
    echo "<form action=\"modules.php?name=$module_name\" method=\"post\">"
        ."<input type=\"hidden\" name=\"random_num\" value=\"$random_num\">"
        ."<input type=\"hidden\" name=\"gfx_check\" value=\"$gfx_check\">"
        ."<input type=\"hidden\" name=\"username\" value=\"$username\">"
        ."<input type=\"hidden\" name=\"user_email\" value=\"$user_email\">"
        ."<input type=\"hidden\" name=\"user_password\" value=\"$user_password\">"
        ."<input type=\"hidden\" name=\"op\" value=\"finish\"><br><br>"
        ."<input type=\"submit\" value=\""._FINISH."\"> &nbsp;&nbsp;"._GOBACK."</form></center>";
    CloseTable();
    } else {
    OpenTable();
    echo "<center><font class=\"title\"><b>Registration Error!</b></font><br><br>";
    echo "<font class=\"content\">$stop<br>"._GOBACK."</font></center>";
    CloseTable();
    }
    include("footer.php");
}

function finishNewUser($username, $user_email, $user_password, $random_num, $gfx_check) {
    global $stop, $EditedMessage, $adminmail, $sitename, $Default_Theme, $user_prefix, $db, $storyhome, $module_name, $nukeurl;
    include("header.php");
    include("config.php");
    userCheck($username, $user_email);
    $user_regdate = date("M d, Y");
    if (!isset($stop)) {
    $datekey = date("F j");
    $rcode = hexdec(md5($_SERVER[HTTP_USER_AGENT] . $sitekey . $random_num . $datekey));
    $code = substr($rcode, 2, 6);
    if (extension_loaded("gd") AND $code != $gfx_check AND ($gfx_chk == 3 OR $gfx_chk == 4 OR $gfx_chk == 6 OR $gfx_chk == 7)) {
        Header("Location: modules.php?name=$module_name");
        die();
    }
        mt_srand ((double)microtime()*1000000);
        $maxran = 1000000;
        $check_num = mt_rand(0, $maxran);
    $check_num = md5($check_num);
    $time = time();
    $finishlink = "$nukeurl/modules.php?name=$module_name&op=activate&username=$username&check_num=$check_num";
    $new_password = md5($user_password);
    $username = check_html($username, nohtml);
    $user_email = check_html($user_email, nohtml);
    $result = $db->sql_query("INSERT INTO ".$user_prefix."_users_temp (user_id, username, user_email, user_password, user_regdate, check_num, time) VALUES (NULL, '$username', '$user_email', '$new_password', '$user_regdate', '$check_num', '$time')");
    if(!$result) {
        echo ""._ERROR."<br>";
    } else {
        $message = ""._WELCOMETO." $sitename!\n\n"._YOUUSEDEMAIL." ($user_email) "._TOREGISTER." $sitename.\n\n "._TOFINISHUSER."\n\n $finishlink\n\n "._FOLLOWINGMEM."\n\n"._UNICKNAME." $username\n"._UPASSWORD." $user_password";
        $subject = ""._ACTIVATIONSUB."";
        $from = "$adminmail";
        mail($user_email, $subject, $message, "From: $from\nX-Mailer: PHP/" . phpversion());
        title("$sitename: "._USERREGLOGIN."");
        OpenTable();
        echo "<center><b>"._ACCOUNTCREATED."</b><br><br>";
        echo ""._YOUAREREGISTERED.""
            ."<br><br>"
        .""._FINISHUSERCONF."<br><br>"
        .""._THANKSUSER." $sitename!</center>";
        CloseTable();
    }
    } else {
    echo "$stop";
    }
    include("footer.php");
}

function activate($username, $check_num) {
    global $db, $user_prefix, $module_name, $language;
    $past = time()-86400;
    $db->sql_query("DELETE FROM ".$user_prefix."_users_temp WHERE time < $past");
    $sql = "SELECT * FROM ".$user_prefix."_users_temp WHERE username='$username' AND check_num='$check_num'";
    $result = $db->sql_query($sql);
    if ($db->sql_numrows($result) == 1) {
    $row = $db->sql_fetchrow($result);
    if ($check_num == $row[check_num]) {
        $db->sql_query("INSERT INTO ".$user_prefix."_users (user_id, username, user_email, user_password, user_avatar, user_regdate, user_lang) VALUES (NULL, '$row[username]', '$row[user_email]', '$row[user_password]', 'gallery/blank.gif', '$row[user_regdate]', '$language')");
        $db->sql_query("DELETE FROM ".$user_prefix."_users_temp WHERE username='$username' AND check_num='$check_num'");
        include("header.php");
        title(""._ACTIVATIONYES."");
        OpenTable();
        echo "<center><b>$row[username]:</b> "._ACTMSG."</center>";
        CloseTable();
        include("footer.php");
        die();
    } else {
        include("header.php");
        title(""._ACTIVATIONERROR."");
        OpenTable();
        echo "<center>"._ACTERROR1."</center>";
        CloseTable();
        include("footer.php");
        die();
    }
    } else {
    include("header.php");
    title(""._ACTIVATIONERROR."");
    OpenTable();
    echo "<center>"._ACTERROR2."</center>";
    CloseTable();
    include("footer.php");
    die();
    }

}

function userinfo($username, $bypass=0, $hid=0, $url=0) {
    global $user, $cookie, $sitename, $prefix, $user_prefix, $db, $admin, $broadcast_msg, $my_headlines, $module_name, $subscription_url;
    $sql = "SELECT * FROM ".$user_prefix."_users WHERE username='$username'";
    $result = $db->sql_query($sql);
    $num = $db->sql_numrows($result);
    $userinfo = $db->sql_fetchrow($result);
    if(!$bypass) cookiedecode($user);
    include("header.php");
    OpenTable();
    echo "<center>";
    if(($username == $cookie[1]) AND ($userinfo[user_password] == $cookie[2])) {
    echo "<font class=\"option\">$username, "._WELCOMETO." $sitename!</font><br><br>";
    echo "<font class=\"content\">"._THISISYOURPAGE."</font></center><br><br>";
    nav(1);
    echo "<br><br>";
    } else {
    echo "<font class=\"title\">"._PERSONALINFO.": $username</font></center><br><br>";
    }
    if ($userinfo[user_website]) {
    if (!eregi("http://", $userinfo[user_website])) {
        $userinfo[user_website] = "http://$userinfo[user_website]";
    }
    }
    if(($num == 1) && ($userinfo[user_website] || $userinfo[user_idnr] || $userinfo[femail] || $userinfo[bio] || $userinfo[user_avatar] || $userinfo[user_icq] || $userinfo[user_aim] || $userinfo[user_yim] || $userinfo[user_msnm] || $userinfo[user_location] || $userinfo[user_occ] || $userinfo[user_interests] || $userinfo[user_sig])) {
    echo "<center><font class=\"content\">";
    if (ereg("(http)", $userinfo[user_avatar])) { echo "<img src=\"$userinfo[user_avatar]\"><br>\n"; } elseif ($userinfo[user_avatar]) { echo "<img src=\"modules/Forums/images/avatars/$userinfo[user_avatar]\"><br>\n"; }
    if ($userinfo[user_website] != "http://" AND $userinfo[user_website] != "") { echo ""._MYHOMEPAGE." <a href=\"$userinfo[user_website]\" target=\"new\">$userinfo[user_website]</a><br>\n"; }
    if ($userinfo[femail]) { echo ""._MYEMAIL." <a href=\"mailto:$userinfo[femail]\">$userinfo[femail]</a><br>\n"; }
    if ($userinfo[user_idnr]) echo ""._IDNR.": $userinfo[user_idnr]<br>\n";
    if ($userinfo[user_icq]) echo ""._ICQ.": $userinfo[user_icq]<br>\n";
    if ($userinfo[user_aim]) echo ""._AIM.": $userinfo[user_aim]<br>\n";
    if ($userinfo[user_yim]) echo ""._YIM.": $userinfo[user_yim]<br>\n";
    if ($userinfo[user_msnm]) echo ""._MSNM.": $userinfo[user_msnm]<br>\n";
    if ($userinfo[user_from]) echo ""._LOCATION.": $userinfo[user_from]<br>\n";
    if ($userinfo[user_occ]) echo ""._OCCUPATION.": $userinfo[user_occ]<br>\n";
    if ($userinfo[user_interests]) echo ""._INTERESTS.": $userinfo[user_interests]<br>\n";
    $userinfo[user_sig] = nl2br($userinfo[user_sig]);
    if ($userinfo[user_sig]) echo "<br><b>"._SIGNATURE.":</b><br>$userinfo[user_sig]<br>\n";
    if ($userinfo[bio]) { echo "<br><b>"._EXTRAINFO.":</b><br>$userinfo[bio]<br>\n"; }
    $sql2 = "SELECT uname FROM ".$prefix."_session WHERE uname='$username'";
    $result2 = $db->sql_query($sql2);
    $row2 = $db->sql_fetchrow($result2);
    $username_pm = $username;
    $username_online = $row2[uname];
    if ($username_online == "") {
        $online = _OFFLINE;
    } else {
        $online = _ONLINE;
    }
    echo ""._USERSTATUS.": <b>$online</b><br>\n";
    if (($userinfo[newsletter] == 1) AND ($username == $cookie[1]) AND ($userinfo[user_password] == $cookie[2]) OR (is_admin($admin) AND ($userinfo[newsletter] == 1))) {
        echo "<i>"._SUBSCRIBED."</i><br>";
    } elseif (($userinfo[newsletter] == 0) AND ($username == $cookie[1]) AND ($userinfo[user_password] == $cookie[2]) OR (is_admin($admin) AND ($userinfo[newsletter] == 0))) {
        echo "<i>"._NOTSUBSCRIBED."</i><br>";
    }
    if (is_user($user) AND $cookie[1] == "$username" OR is_admin($admin)) {
        $numpoints = $db->sql_fetchrow($db->sql_query("SELECT points FROM ".$user_prefix."_users WHERE username='$cookie[1]'"));
        echo ""._YOUHAVEPOINTS." <b>$numpoints[points]</b><br>";
        if (paid()) {
            $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_subscriptions WHERE userid='$cookie[0]'"));
            if ($subscription_url != "") {
                $content = "<br><center>"._YOUARE." <a href='$subscription_url'>"._SUBSCRIBER."</a> "._OF." $sitename<br>";
            } else {
                $content = "<br><center>"._YOUARE." "._SUBSCRIBER." "._OF." $sitename<br>";
            }
            $diff = $row[subscription_expire]-time();
            $yearDiff = floor($diff/60/60/24/365);
            $diff -= $yearDiff*60*60*24*365;
            if ($yearDiff < 1) {
                $diff = $row[subscription_expire]-time();
            }
            $daysDiff = floor($diff/60/60/24);
            $diff -= $daysDiff*60*60*24;
            $hrsDiff = floor($diff/60/60);
            $diff -= $hrsDiff*60*60;
            $minsDiff = floor($diff/60);
            $diff -= $minsDiff*60;
            $secsDiff = $diff;
            if ($yearDiff < 1) {
                $rest = "$daysDiff "._SBDAYS.", $hrsDiff "._SBHOURS.", $minsDiff "._SBMINUTES.", $secsDiff "._SBSECONDS."";
            } elseif ($yearDiff == 1) {
                $rest = "$yearDiff "._SBYEAR.", $daysDiff "._SBDAYS.", $hrsDiff "._SBHOURS.", $minsDiff "._SBMINUTES.", $secsDiff "._SBSECONDS."";
            } elseif ($yearDiff > 1) {
                $rest = "$yearDiff "._SBYEARS.", $daysDiff "._SBDAYS.", $hrsDiff "._SBHOURS.", $minsDiff "._SBMINUTES.", $secsDiff "._SBSECONDS."";
            }
            $content .= "<b>"._SUBEXPIREIN."<br><font color='#FF0000'>$rest</font></b></center>";
        } else {
            if ($subscription_url != "") {
                $content .= "<br><center>"._NOTSUB." $sitename. "._SUBFROM." <a href='$subscription_url'>"._HERE."</a> "._NOW."";
            } else {
                $content .= "<br><center>"._NOTSUB." $sitename.";
            }
        }
        echo "$content<br><br>";
        if (is_admin($admin)) {
            $subnum = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_subscriptions WHERE userid='$userinfo[user_id]'"));
            if ($subnum != 0) {
                echo "<center><b>"._ADMSUB."</b></center><br>";
                $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_subscriptions WHERE userid='$userinfo[user_id]'"));
                $diff = $row[subscription_expire]-time();
                $yearDiff = floor($diff/60/60/24/365);
                $diff -= $yearDiff*60*60*24*365;
                if ($yearDiff < 1) {
                    $diff = $row[subscription_expire]-time();
                }
                $daysDiff = floor($diff/60/60/24);
                $diff -= $daysDiff*60*60*24;
                $hrsDiff = floor($diff/60/60);
                $diff -= $hrsDiff*60*60;
                $minsDiff = floor($diff/60);
                $diff -= $minsDiff*60;
                $secsDiff = $diff;
                if ($yearDiff < 1) {
                    $rest = "$daysDiff "._SBDAYS.", $hrsDiff "._SBHOURS.", $minsDiff "._SBMINUTES.", $secsDiff "._SBSECONDS."";
                } elseif ($yearDiff == 1) {
                    $rest = "$yearDiff "._SBYEAR.", $daysDiff "._SBDAYS.", $hrsDiff "._SBHOURS.", $minsDiff "._SBMINUTES.", $secsDiff "._SBSECONDS."";
                } elseif ($yearDiff > 1) {
                    $rest = "$yearDiff "._SBYEARS.", $daysDiff "._SBDAYS.", $hrsDiff "._SBHOURS.", $minsDiff "._SBMINUTES.", $secsDiff "._SBSECONDS."";
                }
                $content = "<b>"._ADMSUBEXPIREIN."<br><font color='#FF0000'>$rest</font></b></center><br><br>";
                echo "$content";
            } else {
                echo "<center><b>"._ADMNOTSUB."</b></center><br><br>";
            }
        }
    }
    if (is_active("Journal") AND $cookie[1] != $username) {
        $sql3 = "SELECT jid FROM ".$prefix."_journal WHERE aid='$username' AND status='yes' ORDER BY pdate,jid DESC LIMIT 0,1";
        $result3 = $db->sql_query($sql3);
        $row3 = $db->sql_fetchrow($result3);
        $jid = $row3[jid];
        if ($jid != "" AND isset($jid)) {
        echo "[ <a href=\"modules.php?name=Journal&amp;file=search&amp;bywhat=aid&amp;forwhat=$username\">"._READMYJOURNAL."</a> ]<br>";
        }
    }
    if (is_admin($admin)) {
        echo "[ <a href=\"admin.php?op=modifyUser&chng_uid=$userinfo[user_id]\">"._EDITUSER."</a> ]<br>";
    }
    if (((is_user($user) AND $cookie[1] != $username) OR is_admin($admin)) AND is_active("Private_Messages")) { echo "<br>[ <a href=\"modules.php?name=Private_Messages&amp;mode=post&amp;u=$userinfo[user_id]\">"._USENDPRIVATEMSG." $username_pm</a> ]<br>\n"; }
    echo "</center></font>";
    } else {
    echo "<center>"._NOINFOFOR." $username</center>";
    }
    CloseTable();
    if ($my_headlines == 1 AND ($username == $cookie[1]) AND ($userinfo[user_password] == $cookie[2])) {
    echo "<br>";
    OpenTable();
    echo "<center><b>"._MYHEADLINES."</b><br><br>"
    .""._SELECTASITE."<br><br>"
    ."<form action=\"modules.php?name=$module_name\" method=\"post\">"
    ."<input type=\"hidden\" name=\"op\" value=\"userinfo\">"
    ."<input type=\"hidden\" name=\"username\" value=\"$username\">"
    ."<input type=\"hidden\" name=\"bypass\" value=\"$bypass\">"
    ."<input type=\"hidden\" name=\"url\" value=\"0\">"
    ."<select name=\"hid\" onChange='submit()'>\n"
    ."<option value=\"0\">"._SELECTASITE2."</option>";
    $sql4 = "SELECT hid, sitename FROM ".$prefix."_headlines ORDER BY sitename";
    $headl = $db->sql_query($sql4);
    while($row4 = $db->sql_fetchrow($headl)) {
    $nhid = $row4[hid];
    $hsitename = $row4[sitename];
    if ($hid == $nhid ) {
        $sel = "selected";
    } else {
        $sel = "";
    }
    echo "<option value=\"$nhid\" $sel>$hsitename</option>\n";
    }
    echo "</select></form>"
    .""._ORTYPEURL."<br><br>"
    ."<form action=\"modules.php?name=$module_name\" method=\"post\">"
    ."<input type=\"hidden\" name=\"op\" value=\"userinfo\">"
    ."<input type=\"hidden\" name=\"username\" value=\"$username\">"
    ."<input type=\"hidden\" name=\"bypass\" value=\"$bypass\">"
    ."<input type=\"hidden\" name=\"hid\" value=\"0\">"
    ."<input type=\"text\" name=\"url\" size=\"40\" maxlength=\"200\" value=\"http://\">&nbsp;&nbsp;"
    ."<input type=\"submit\" value=\""._GO."\"></form>"
    ."</center><br>";
    if ($hid != 0 OR ($hid == 0 AND $url != "0" AND $url != "http://") AND $url != "") {
    if ($hid != 0) {
            $sql5 = "SELECT sitename, headlinesurl FROM ".$prefix."_headlines WHERE hid='$hid'";
        $result5 = $db->sql_query($sql5);
        $row5 = $db->sql_fetchrow($result5);
        $nsitename = $row5[sitename];
        $url = $row5[headlinesurl];
        $title = $nsitename;
        $siteurl = eregi_replace("http://", "", $url);
        $siteurl = explode("/", $siteurl);
    } else {
        if (!ereg("http://", $url)) {
        $url = "http://$url";
        }
        $siteurl = eregi_replace("http://", "", $url);
        $siteurl = explode("/", $siteurl);
        $title = "http://$siteurl[0]";
    }
    $rdf = parse_url($url);
    $fp = fsockopen($rdf['host'], 80, $errno, $errstr, 15);
    if (!$fp) {
            $content = "<center><font class=\"content\">"._RSSPROBLEM."</font></center>";
    }
    if ($fp) {
            fputs($fp, "GET " . $rdf['path'] . "?" . $rdf['query'] . " HTTP/1.0\r\n");
            fputs($fp, "HOST: " . $rdf['host'] . "\r\n\r\n");
            $string    = "";
            while(!feof($fp)) {
        $pagetext = fgets($fp,300);
        $string .= chop($pagetext);
        }
        fputs($fp,"Connection: close\r\n\r\n");
        fclose($fp);
        $items = explode("</item>",$string);
        $content = "<font class=\"content\">";
        for ($i=0;$i<10;$i++) {
        $link = ereg_replace(".*<link>","",$items[$i]);
        $link = ereg_replace("</link>.*","",$link);
        $title2 = ereg_replace(".*<title>","",$items[$i]);
        $title2 = ereg_replace("</title>.*","",$title2);
        if ($items[$i] == "" AND $cont != 1) {
                $content = "<center>"._RSSPROBLEM."</center>";
        } else {
                if (strcmp($link,$title2) AND $items[$i] != "") {
                $cont = 1;
            $content .= "<img src=\"images/arrow.gif\" border=\"0\" hspace=\"5\"><a href=\"$link\" target=\"new\">$title2</a><br>\n";
            }
        }
        }
    }
    if ($content != "") {
        OpenTable2();
        echo "<center><b>"._HEADLINESFROM." <a href=\"http://$siteurl[0]\" target=\"new\">$title</a></b></center><br>";
        echo "$content";
        CloseTable2();
    } elseif (($cont == 0) OR ($content == "")) {
        OpenTable2();
        echo "<center>"._RSSPROBLEM."</center><br>";
        CloseTable2();
    }
    echo "<br>";
    }
    CloseTable();
    }
    if ($broadcast_msg == 1 AND ($username == $cookie[1]) AND ($userinfo[user_password] == $cookie[2])) {
    echo "<br>";
    OpenTable();
    echo "<center><b>"._BROADCAST."</b><br><br>"._BROADCASTTEXT."<br><br>"
        ."<form action=\"modules.php?name=$module_name\" method=\"post\">"
        ."<input type=\"hidden\" name=\"who\" value=\"$username\">"
        ."<input type=\"hidden\" name=\"op\" value=\"broadcast\">"
        ."<input type=\"text\" size=\"60\" maxlength=\"255\" name=\"the_message\">&nbsp;&nbsp;<input type=\"submit\" value=\""._SEND."\">"
        ."</form></center>";
    CloseTable();
    }
    if (is_active("Private_Messages") AND ($username == $cookie[1]) AND ($userinfo[user_password] == $cookie[2])) {
    echo "<br>";
    OpenTable();
    echo "<center><b>"._PRIVATEMESSAGES."</b><br><br>";
    $numrow = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_bbprivmsgs WHERE privmsgs_to_userid='$userinfo[user_id]' AND (privmsgs_type='1' OR privmsgs_type='5' OR privmsgs_type='0')"));
    if (is_active("Members_List")) {
        $mem_list = "<a href=\"modules.php?name=Members_List\">"._BROWSEUSERS."</a>";
    } else {
        $mem_list = "";
    }
    if (is_active("Search")) {
        $mod_search = "<a href=\"modules.php?name=Search&amp;type=users\">"._SEARCHUSERS."</a>";
    } else {
        $mod_search = "";
    }
    if ($mem_list != "" AND $mod_search != "") { $a = " | "; } else { $a = ""; }
    if ($mem_list != "" OR $mod_search != "") {
        $links = "[ $mem_list $a $mod_search ]";
    } elseif ($mem_list == "" AND $mod_search == "") {
        $links = "";
    }
    echo ""._YOUHAVE." <a href=\"modules.php?name=Private_Messages\"><b>$numrow</b></a> "._PRIVATEMSG."<br><br>"
        ."<form action=\"modules.php?name=Private_Messages\" method=\"post\">"
        .""._USENDPRIVATEMSG.": <input type=\"text\" name=\"pm_username\" size=\"20\">&nbsp;&nbsp;$links"
        ."<input type=\"hidden\" name=\"send\" value=\"1\">"
        ."</form></center>";
    CloseTable();
    }
    if ($articlecomm == 1) {
    echo "<br>";
    OpenTable();
    echo "<b>"._LAST10COMMENTS." $userinfo[username]:</b><br>";
    $sql6 = "SELECT tid, sid, subject FROM ".$prefix."_comments WHERE name='$userinfo[username]' ORDER BY tid DESC LIMIT 0,10";
    $result6 = $db->sql_query($sql6);
    while($row6 = $db->sql_fetchrow($result6)) {
        $tid = $row6[tid];
        $sid = $row6[sid];
        $subject = $row6[subject];
            echo "<li><a href=\"modules.php?name=News&file=article&thold=-1&mode=flat&order=0&sid=$sid#$tid\">$subject</a><br>";
    }
    CloseTable();
    }
    echo "<br>";
    OpenTable();
    echo "<b>"._LAST10SUBMISSIONS." $userinfo[username]:</b><br>";
    $sql7 = "SELECT sid, title FROM ".$prefix."_stories WHERE informant='$userinfo[username]' ORDER BY sid DESC LIMIT 0,10";
    $result7 = $db->sql_query($sql7);
    while($row7 = $db->sql_fetchrow($result7)) {
    $sid = $row7[sid];
    $title = $row7[title];
        echo "<li><a href=\"modules.php?name=News&file=article&sid=$sid\">$title</a><br>";
    }
    CloseTable();
    include("footer.php");
}

function main($user) {
    global $stop, $module_name, $redirect, $mode, $t, $f, $gfx_chk;
    if(!is_user($user)) {
    include("header.php");
    if ($stop) {
        OpenTable();
        echo "<center><font class=\"title\"><b>"._LOGININCOR."</b></font></center>\n";
        CloseTable();
        echo "<br>\n";
    } else {
        OpenTable();
        echo "<center><font class=\"title\"><b>"._USERREGLOGIN."</b></font></center>\n";
        CloseTable();
        echo "<br>\n";
    }
    if (!is_user($user)) {
        OpenTable();
        mt_srand ((double)microtime()*1000000);
        $maxran = 1000000;
        $random_num = mt_rand(0, $maxran);
        echo "<form action=\"modules.php?name=$module_name\" method=\"post\">\n"
        ."<b>"._USERLOGIN."</b><br><br>\n"
        ."<table border=\"0\"><tr><td>\n"
        .""._NICKNAME.":</td><td><input type=\"text\" name=\"username\" size=\"15\" maxlength=\"25\"></td></tr>\n"
        ."<tr><td>"._PASSWORD.":</td><td><input type=\"password\" name=\"user_password\" size=\"15\" maxlength=\"20\"></td></tr>\n";
        if (extension_loaded("gd") AND ($gfx_chk == 2 OR $gfx_chk == 4 OR $gfx_chk == 5 OR $gfx_chk == 7)) {
        echo "<tr><td colspan='2'>"._SECURITYCODE.": <img src='modules.php?name=$module_name&op=gfx&random_num=$random_num' border='1' alt='"._SECURITYCODE."' title='"._SECURITYCODE."'></td></tr>\n"
            ."<tr><td colspan='2'>"._TYPESECCODE.": <input type=\"text\" NAME=\"gfx_check\" SIZE=\"7\" MAXLENGTH=\"6\"></td></tr>\n"
            ."<input type=\"hidden\" name=\"random_num\" value=\"$random_num\">\n";
        }
        echo "</table><input type=\"hidden\" name=\"redirect\" value=$redirect>\n"
        ."<input type=\"hidden\" name=\"mode\" value=$mode>\n"
        ."<input type=\"hidden\" name=\"f\" value=$f>\n"
        ."<input type=\"hidden\" name=\"t\" value=$t>\n"
        ."<input type=\"hidden\" name=\"op\" value=\"login\">\n"
        ."<input type=\"submit\" value=\""._LOGIN."\"></form><br>\n\n"
        ."<center><font class=\"content\">[ <a href=\"modules.php?name=$module_name&amp;op=pass_lost\">"._PASSWORDLOST."</a> | <a href=\"modules.php?name=$module_name&amp;op=new_user\">"._REGNEWUSER."</a> ]</font></center>\n";
        CloseTable();
    }
    include("footer.php");
    } elseif (is_user($user)) {
        global $cookie;
        cookiedecode($user);
        userinfo($cookie[1]);
    }
}

function gfx($random_num) {
    global $prefix, $db, $module_name;
    require("config.php");
    $datekey = date("F j");
    $rcode = hexdec(md5($_SERVER[HTTP_USER_AGENT] . $sitekey . $random_num . $datekey));
    $code = substr($rcode, 2, 6);
    $image = ImageCreateFromJPEG("modules/$module_name/images/code_bg.jpg");
    $text_color = ImageColorAllocate($image, 80, 80, 80);
    Header("Content-type: image/jpeg");
    ImageString ($image, 5, 12, 2, $code, $text_color);
    ImageJPEG($image, '', 75);
    ImageDestroy($image);
    die();
}

function new_user() {
    global $my_headlines, $module_name, $db, $gfx_chk;
    if (!is_user($user)) {
    mt_srand ((double)microtime()*1000000);
    $maxran = 1000000;
    $random_num = mt_rand(0, $maxran);
    include("header.php");
    OpenTable();
    echo "<center><font class=\"title\"><b>"._USERREGLOGIN."</b></font></center>\n";
    CloseTable();
    echo "<br>\n";
    OpenTable();
    echo "<form action=\"modules.php?name=$module_name\" method=\"post\">\n"
            ."<b>"._REGNEWUSER."</b> ("._ALLREQUIRED.")<br><br>\n"
        ."<table cellpadding=\"0\" cellspacing=\"10\" border=\"0\">\n"
        ."<tr><td>"._IDNR.":</td><td><input type=\"text\" name=\"user_idnr\" size=\"30\" maxlength=\"10\"></td></tr>\n"
        ."<tr><td>"._NICKNAME.":</td><td><input type=\"text\" name=\"username\" size=\"30\" maxlength=\"25\"></td></tr>\n"
        ."<tr><td>"._EMAIL.":</td><td><input type=\"text\" name=\"user_email\" size=\"30\" maxlength=\"255\"></td></tr>\n"
        ."<tr><td>"._PASSWORD.":</td><td><input type=\"password\" name=\"user_password\" size=\"11\" maxlength=\"40\"></td></tr>\n"
        ."<tr><td>"._RETYPEPASSWORD.":</td><td><input type=\"password\" name=\"user_password2\" size=\"11\" maxlength=\"40\"><br><font class=\"tiny\">("._BLANKFORAUTO.")</font></td></tr>\n";
    if (extension_loaded("gd") AND ($gfx_chk == 3 OR $gfx_chk == 4 OR $gfx_chk == 6 OR $gfx_chk == 7)) {
        echo "<tr><td>"._SECURITYCODE.":</td><td><img src='modules.php?name=$module_name&op=gfx&random_num=$random_num' border='1' alt='"._SECURITYCODE."' title='"._SECURITYCODE."'></td></tr>\n"
            ."<tr><td>"._TYPESECCODE.":</td><td><input type=\"text\" NAME=\"gfx_check\" SIZE=\"7\" MAXLENGTH=\"6\"></td></tr>\n"
            ."<input type=\"hidden\" name=\"random_num\" value=\"$random_num\">\n";
    }
    echo "<tr><td colspan='2'>\n"
        ."<input type=\"hidden\" name=\"op\" value=\"new user\">\n"
            ."<input type=\"submit\" value=\""._NEWUSER."\">\n"
            ."</td></tr></table>\n"
        ."</form>\n"
        ."<br>\n"
            .""._YOUWILLRECEIVE."<br><br>\n"
            .""._COOKIEWARNING."<br>\n"
            .""._ASREGUSER."<br>\n"
        ."<ul>\n"
            ."<li>"._ASREG1."\n"
            ."<li>"._ASREG2."\n"
            ."<li>"._ASREG3."\n"
            ."<li>"._ASREG4."\n"
            ."<li>"._ASREG5."\n"
            ."<li>"._ASREG6."\n";
    $handle=opendir('themes');
        while ($file = readdir($handle)) {
        if ((!ereg("[.]",$file) AND file_exists("themes/$file/theme.php"))) {
        $thmcount++;
        }
    }
    closedir($handle);
        if ($thmcount > 1) {
        echo "<li>"._ASREG6."\n";
    }
    $sql = "SELECT custom_title FROM ".$prefix."_modules WHERE active='1' AND view='1' AND inmenu='1'";
    $result = $db->sql_query($sql);
    while ($row = $db->sql_fetchrow($result)) {
        $custom_title = $row[custom_title];
        if ($custom_title != "") {
        echo "<li>"._ACCESSTO." $custom_title\n";
        }
    }
    $sql = "SELECT title FROM ".$prefix."_blocks WHERE active='1' AND view='1'";
    $result = $db->sql_query($sql);
    while ($row = $db->sql_fetchrow($result)) {
        $b_title = $row[title];
        if ($b_title != "") {
        echo "<li>"._ACCESSTO." $b_title\n";
        }
    }
    if (is_active("Journal")) {
        echo "<li>"._CREATEJOURNAL."\n";
    }
    if ($my_headlines == 1) {
        echo "<li>"._READHEADLINES."\n";
    }
        echo "<li>"._ASREG7."\n"
        ."</ul>\n"
            .""._REGISTERNOW."<br>\n"
            .""._WEDONTGIVE."<br><br>\n"
        ."<center><font class=\"content\">[ <a href=\"modules.php?name=$module_name\">"._USERLOGIN."</a> | <a href=\"modules.php?name=$module_name&amp;op=pass_lost\">"._PASSWORDLOST."</a> ]</font></center>\n";
    CloseTable();
    include("footer.php");
    } elseif (is_user($user)) {
    global $cookie;
    cookiedecode($user);
    userinfo($cookie[1]);
    }
}

function pass_lost() {
    global $user, $module_name;
    if (!is_user($user)) {
    include("header.php");
    OpenTable();
    echo "<center><font class=\"title\"><b>"._USERREGLOGIN."</b></font></center>\n";
    CloseTable();
    echo "<br>\n";
    OpenTable();
    echo "<b>"._PASSWORDLOST."</b><br><br>\n"
            .""._NOPROBLEM."<br><br>\n"
        ."<form action=\"modules.php?name=$module_name\" method=\"post\">\n"
        ."<table border=\"0\"><tr><td>\n"
            .""._NICKNAME.":</td><td><input type=\"text\" name=\"username\" size=\"15\" maxlength=\"25\"></td></tr>\n"
            ."<tr><td>"._CONFIRMATIONCODE.":</td><td><input type=\"text\" name=\"code\" size=\"11\" maxlength=\"10\"></td></tr></table><br>\n"
            ."<input type=\"hidden\" name=\"op\" value=\"mailpasswd\">\n"
            ."<input type=\"submit\" value=\""._SENDPASSWORD."\"></form><br>\n"
        ."<center><font class=\"content\">[ <a href=\"modules.php?name=$module_name\">"._USERLOGIN."</a> | <a href=\"modules.php?name=$module_name&amp;op=new_user\">"._REGNEWUSER."</a> ]</font></center>\n";
    CloseTable();
    include("footer.php");
    } elseif(is_user($user)) {
    global $cookie;
    cookiedecode($user);
    userinfo($cookie[1]);
    }
}

function logout() {
    global $prefix, $db, $user, $cookie, $redirect;
    cookiedecode($user);
    $r_uid = $cookie[0];
    $r_username = $cookie[1];
    setcookie("user");
    $db->sql_query("DELETE FROM ".$prefix."_session WHERE uname='$r_username'");
    $db->sql_query("DELETE FROM ".$prefix."_bbsessions WHERE session_user_id='$r_uid'");
    $user = "";
    include("header.php");
    OpenTable();
    if ($redirect != "") {
        echo "<META HTTP-EQUIV=\"refresh\" content=\"3;URL=modules.php?name=$redirect\">";
    } else {
        echo "<META HTTP-EQUIV=\"refresh\" content=\"3;URL=index.php\">";
    }
    echo "<center><font class=\"option\"><b>"._YOUARELOGGEDOUT."</b></font></center>";
    CloseTable();
    include("footer.php");
}

function mail_password($username, $code) {
    global $sitename, $adminmail, $nukeurl, $user_prefix, $db, $module_name;
    $sql = "SELECT user_email, user_password FROM ".$user_prefix."_users WHERE username='$username'";
    $result = $db->sql_query($sql);
    if(!$result) {
    include("header.php");
    OpenTable();
    echo "<center>"._SORRYNOUSERINFO."</center>";
    CloseTable();
    include("footer.php");
    } else {
    $host_name = $_SERVER["REMOTE_ADDR"];
    $row = $db->sql_fetchrow($result);
    $user_email = $row[user_email];
    $user_password = $row[user_password];
    $areyou = substr($user_password, 0, 10);
    if ($areyou==$code) {
        $newpass=makepass();
        $message = ""._USERACCOUNT." '$username' "._AT." $sitename "._HASTHISEMAIL."  "._AWEBUSERFROM." $host_name "._HASREQUESTED."\n\n"._YOURNEWPASSWORD." $newpass\n\n "._YOUCANCHANGE." $nukeurl/modules.php?name=$module_name\n\n"._IFYOUDIDNOTASK."";
        $subject = ""._USERPASSWORD4." $username";
        mail($user_email, $subject, $message, "From: $adminmail\nX-Mailer: PHP/" . phpversion());
        /* Next step: add the new password to the database */
        $cryptpass = md5($newpass);
        $query = "UPDATE ".$user_prefix."_users SET user_password='$cryptpass' WHERE username='$username'";
        if (!$db->sql_query($query)) {
            echo ""._UPDATEFAILED."";
        }
        include ("header.php");
        OpenTable();
        echo "<center>"._PASSWORD4." $username "._MAILED."<br><br>"._GOBACK."</center>";
        CloseTable();
        include ("footer.php");
    /* If no Code, send it */
    } else {
        $sql = "SELECT user_email, user_password FROM ".$user_prefix."_users WHERE username='$username'";
        $result = $db->sql_query($sql);
        if(!$result) {
        include ("header.php");
        OpenTable();
            echo "<center>"._SORRYNOUSERINFO."</center>";
        CloseTable();
        include ("footer.php");
        } else {
            $host_name = $_SERVER["REMOTE_ADDR"];
        $row = $db->sql_fetchrow($result);
            $user_email = $row[user_email];
        $user_password = $row[user_password];
            $areyou = substr($user_password, 0, 10);
            $message = ""._USERACCOUNT." '$username' "._AT." $sitename "._HASTHISEMAIL." "._AWEBUSERFROM." $host_name "._CODEREQUESTED."\n\n"._YOURCODEIS." $areyou \n\n"._WITHTHISCODE." $nukeurl/modules.php?name=$module_name&op=pass_lost\n"._IFYOUDIDNOTASK2."";
        $subject=""._CODEFOR." $username";
        mail($user_email, $subject, $message, "From: $adminmail\nX-Mailer: PHP/" . phpversion());
        include ("header.php");
        OpenTable();
        echo "<center>"._CODEFOR." $username "._MAILED."<br><br>"._GOBACK."</center>";
        CloseTable();
        include ("footer.php");
            }
    }
    }
}

function docookie($setuid, $setusername, $setpass, $setstorynum, $setumode, $setuorder, $setthold, $setnoscore, $setublockon, $settheme, $setcommentmax) {
    $info = base64_encode("$setuid:$setusername:$setpass:$setstorynum:$setumode:$setuorder:$setthold:$setnoscore:$setublockon:$settheme:$setcommentmax");
    setcookie("user","$info",time()+2592000);
}

function login($username, $user_password, $redirect, $mode, $f, $t, $random_num, $gfx_check) {
    global $setinfo, $user_prefix, $db, $module_name, $pm_login, $prefix;
    include("config.php");
    $sql = "SELECT user_password, user_id, storynum, umode, uorder, thold, noscore, ublockon, theme, commentmax FROM ".$user_prefix."_users WHERE username='$username'";
    $result = $db->sql_query($sql);
    $setinfo = $db->sql_fetchrow($result);
    $forward = ereg_replace("redirect=", "", "$redirect");
    if (ereg("privmsg", $forward)) {
        $pm_login = "active";
    }
    if (($db->sql_numrows($result)==1) AND ($setinfo[user_id] != 1) AND ($setinfo[user_password] != "")) {
    $dbpass=$setinfo[user_password];
    $non_crypt_pass = $user_password;
      $old_crypt_pass = crypt($user_password,substr($dbpass,0,2));
    $new_pass = md5($user_password);
    if (($dbpass == $non_crypt_pass) OR ($dbpass == $old_crypt_pass)) {
        $db->sql_query("UPDATE ".$user_prefix."_users SET user_password='$new_pass' WHERE username='$username'");
        $sql = "SELECT user_password FROM ".$user_prefix."_users WHERE username='$username'";
        $result = $db->sql_query($sql);
        $row = $db->sql_fetchrow($result);
        $dbpass = $row[user_password];
    }
    if ($dbpass != $new_pass) {
            Header("Location: modules.php?name=$module_name&stop=1");
            return;
    }
    $datekey = date("F j");
    $rcode = hexdec(md5($_SERVER[HTTP_USER_AGENT] . $sitekey . $random_num . $datekey));
    $code = substr($rcode, 2, 6);
    if (extension_loaded("gd") AND $code != $gfx_check AND ($gfx_chk == 2 OR $gfx_chk == 4 OR $gfx_chk == 5 OR $gfx_chk == 7)) {
        Header("Location: modules.php?name=$module_name&stop=1");
        die();
    } else {
        docookie($setinfo[user_id], $username, $new_pass, $setinfo[storynum], $setinfo[umode], $setinfo[uorder], $setinfo[thold], $setinfo[noscore], $setinfo[ublockon], $setinfo[theme], $setinfo[commentmax]);
        $uname = $_SERVER["REMOTE_ADDR"];
        $db->sql_query("DELETE FROM ".$prefix."_session WHERE uname='$uname' AND guest='1'");
    }
    if ($pm_login != "") {
            Header("Location: modules.php?name=Private_Messages&file=index&folder=inbox");
        exit;
    }
        if ($redirect == "" ) {
            Header("Location: modules.php?name=Your_Account&op=userinfo&bypass=1&username=$username");
        } else if ($mode == "") {
            Header("Location: modules.php?name=Forums&file=$forward");
        } else if ($t !="")  {
            Header("Location: modules.php?name=Forums&file=$forward&mode=$mode&t=$t");
        } else {
            Header("Location: modules.php?name=Forums&file=$forward&mode=$mode&f=$f");
    }
    } else {
    Header("Location: modules.php?name=$module_name&stop=1");
    }
}

function edituser() {
    global $user, $userinfo, $user_idnr, $cookie, $module_name, $bgcolor2, $bgcolor3;
    getusrinfo($user);
    if (($userinfo[username] != $cookie[1]) AND ($userinfo[user_password] != $cookie[2])) {
    include("header.php");
    OpenTable();
    echo "<center><font class=\"title\"><b>"._PERSONALINFO."</b></font></center>";
    CloseTable();
    echo "<br>";
    OpenTable();
    nav();
    CloseTable();
    echo "<br>";
    if (!eregi("http://",$userinfo[user_website])) {
        $userinfo[user_website] = "http://$userinfo[user_website]";
    }
    OpenTable();
    $userinfo[user_avatar] = ereg_replace("gallery/","",$userinfo[user_avatar]);
    echo "<table cellpadding=\"3\" border=\"0\" width='100%'><tr><td bgcolor='$bgcolor2'>"
        ."<form name=\"Register\" action=\"modules.php?name=$module_name\" method=\"post\">"
        ."<b>"._USRNICKNAME."</b>:</td><td bgcolor='$bgcolor3'><b>$userinfo[username]</b></td></tr><tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._IDNR."</b>:<br>"._OPTIONAL."</td><td bgcolor='$bgcolor3'>"
        ."<input type=\"text\" name=\"user_idnr\" value=\"$userinfo[user_idnr]\" size=\"50\" maxlength=\"10\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._UREALNAME."</b>:<br>"._OPTIONAL."</td><td bgcolor='$bgcolor3'>"
        ."<input type=\"text\" name=\"realname\" value=\"$userinfo[name]\" size=\"50\" maxlength=\"60\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._UREALEMAIL.":</b><br>"._REQUIRED."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_email\" value=\"$userinfo[user_email]\" size=\"50\" maxlength=\"255\"><br>"._EMAILNOTPUBLIC."</td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._UFAKEMAIL.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"femail\" value=\"$userinfo[femail]\" size=\"50\" maxlength=\"255\"><br>"._EMAILPUBLIC."</td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YOURHOMEPAGE.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_website\" value=\"$userinfo[user_website]\" size=\"50\" maxlength=\"255\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YOURAVATAR.":</b><br>"._OPTIONAL."</td><td bgcolor='$bgcolor3'>[ <a href=\"modules.php?name=$module_name&amp;op=avatarlist\">"._LIST."</a> ]&nbsp;&nbsp;"
        ."<select name=\"user_avatar\" onChange=\"showimage()\">"
        ."<option value=\"$userinfo[user_avatar]\">$userinfo[user_avatar]</option>";
    $direktori = "modules/Forums/images/avatars/gallery";
    $handle=opendir($direktori);
    while ($file = readdir($handle)) {
        $filelist[] = $file;
    }
    asort($filelist);
    while (list ($key, $file) = each ($filelist)) {
        ereg(".gif|.jpg",$file);
        if ($file == "." || $file == "..") {
        $a=1;
        } else {
        echo "<option value=\"$file\">$file</option>";
        }
    }
    echo "</select>&nbsp;&nbsp;<img src=\"modules/Forums/images/avatars/gallery/$userinfo[user_avatar]\" name=\"avatar\" width=\"32\" height=\"32\" alt=\"\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._IDNR.":</b><br>"._REQUIRED."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_idnr\" value=\"$userinfo[user_idnr]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YICQ.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_icq\" value=\"$userinfo[user_icq]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YAIM.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_aim\" value=\"$userinfo[user_aim]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YYIM.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_yim\" value=\"$userinfo[user_yim]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YMSNM.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_msnm\" value=\"$userinfo[user_msnm]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YLOCATION.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_from\" value=\"$userinfo[user_from]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YOCCUPATION.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_occ\" value=\"$userinfo[user_occ]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YINTERESTS.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_interests\" value=\"$userinfo[user_interests]\" size=\"30\" maxlength=\"100\"></td></tr>";
    echo "<tr><td bgcolor='$bgcolor2'><b>"._RECEIVENEWSLETTER."</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[newsletter] == 1) {
        echo "<input type=\"radio\" name=\"newsletter\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"newsletter\" value=\"0\">"._NO."";
    } elseif ($userinfo[newsletter] == 0) {
        echo "<input type=\"radio\" name=\"newsletter\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"newsletter\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._ALWAYSSHOWEMAIL.":</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_viewemail] == 1) {
        echo "<input type=\"radio\" name=\"user_viewemail\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_viewemail\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_viewemail] == 0) {
        echo "<input type=\"radio\" name=\"user_viewemail\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_viewemail\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._HIDEONLINE.":</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_allow_viewonline] == 1) {
        echo "<input type=\"radio\" name=\"user_allow_viewonline\" value=\"0\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allow_viewonline\" value=\"1\" checked>"._NO."";
    } elseif ($userinfo[user_allow_viewonline] == 0) {
        echo "<input type=\"radio\" name=\"user_allow_viewonline\" value=\"0\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allow_viewonline\" value=\"1\">"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._REPLYNOTIFY.":</b><br>"._REPLYNOTIFYMSG."</td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_notify] == 1) {
        echo "<input type=\"radio\" name=\"user_notify\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_notify\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_notify] == 0) {
        echo "<input type=\"radio\" name=\"user_notify\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_notify\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._PMNOTIFY.":</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_notify_pm] == 1) {
        echo "<input type=\"radio\" name=\"user_notify_pm\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_notify_pm\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_notify_pm] == 0) {
        echo "<input type=\"radio\" name=\"user_notify_pm\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_notify_pm\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._POPPM.":</b><br>"._POPPMMSG."</td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_popup_pm] == 1) {
        echo "<input type=\"radio\" name=\"user_popup_pm\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_popup_pm\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_popup_pm] == 0) {
        echo "<input type=\"radio\" name=\"user_popup_pm\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_popup_pm\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._ATTACHSIG.":</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_attachsig] == 1) {
        echo "<input type=\"radio\" name=\"user_attachsig\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_attachsig\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_attachsig] == 0) {
        echo "<input type=\"radio\" name=\"user_attachsig\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_attachsig\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._ALLOWBBCODE."</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_allowbbcode] == 1) {
        echo "<input type=\"radio\" name=\"user_allowbbcode\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowbbcode\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_allowbbcode] == 0) {
        echo "<input type=\"radio\" name=\"user_allowbbcode\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowbbcode\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._ALLOWHTMLCODE."</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_allowhtml] == 1) {
        echo "<input type=\"radio\" name=\"user_allowhtml\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowhtml\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_allowhtml] == 0) {
        echo "<input type=\"radio\" name=\"user_allowhtml\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowhtml\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._ALLOWSMILIES."</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_allowsmile] == 1) {
        echo "<input type=\"radio\" name=\"user_allowsmile\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowsmile\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_allowsmile] == 0) {
        echo "<input type=\"radio\" name=\"user_allowsmile\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowsmile\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._FORUMSTIME."</b></td><td bgcolor='$bgcolor3'>";
    echo "<select name='user_timezone'>";
    for ($i=-12; $i<13; $i++) {
        if ($i == 0) {
        $dummy = "GMT";
        } else {
        if (!ereg("-", $i)) {
            $i = "+$i";
        }
        $dummy = "GMT $i "._HOURS."";
        }
        if ($userinfo[user_timezone] == $i) {
            echo "<option name=\"user_timezone\" value=\"$i\" selected>$dummy</option>";
        } else {
        echo "<option name=\"user_timezone\" value=\"$i\">$dummy</option>";
        }

    }
    echo "</select>";
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._FORUMSDATE.":</b><br>"._FORUMSDATEMSG."</b></td><td bgcolor='$bgcolor3'>";
    echo "<input size='15' maxlength='14' type=\"text\" name=\"user_dateformat\" value=\"$userinfo[user_dateformat]\">";
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._SIGNATURE.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><textarea wrap=\"virtual\" cols=\"50\" rows=\"5\" name=\"user_sig\">$userinfo[user_sig]</textarea><br>"._255CHARMAX."</td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._EXTRAINFO.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><textarea wrap=\"virtual\" cols=\"50\" rows=\"5\" name=\"bio\">$userinfo[bio]</textarea><br>"._CANKNOWABOUT."</td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._PASSWORD."</b>:</td><br>"
        ."<td bgcolor='$bgcolor3'><input type=\"password\" name=\"user_password\" size=\"22\" maxlength=\"20\">&nbsp;&nbsp;&nbsp;<input type=\"password\" name=\"vpass\" size=\"22\" maxlength=\"20\"><br>"._TYPENEWPASSWORD."</td></tr>"
        ."<tr><td bgcolor='$bgcolor3' colspan='2' align='center'>"
        ."<input type=\"hidden\" name=\"username\" value=\"$userinfo[username]\">"
        ."<input type=\"hidden\" name=\"user_id\" value=\"$userinfo[user_id]\">"
        ."<input type=\"hidden\" name=\"op\" value=\"saveuser\">"
        ."<input type=\"submit\" value=\""._SAVECHANGES."\">"
        ."</form></td></tr></table>";
    CloseTable();
    include("footer.php");
    } else {
    main($user);
    }
}

function saveuser($realname, $user_email, $femail, $user_website, $user_avatar, $user_icq, $user_idnr, $user_aim, $user_yim, $user_msnm, $user_from, $user_occ, $user_interests, $newsletter, $user_viewemail, $user_allow_viewonline, $user_notify, $user_notify_pm, $user_popup_pm, $user_attachsig, $user_allowbbcode, $user_allowhtml, $user_allowsmile, $user_timezone, $user_dateformat, $user_sig, $bio, $user_password, $vpass, $username, $user_id) {
    global $user, $cookie, $userinfo, $EditedMessage, $user_prefix, $db, $module_name, $minpass;
    cookiedecode($user);
    $check = $cookie[1];
    $check2 = $cookie[2];
    $sql = "SELECT user_id, user_password FROM ".$user_prefix."_users WHERE username='$check'";
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);
    $vuid = $row[user_id];
    $ccpass = $row[user_password];
    $user_sig = htmlspecialchars($user_sig);
    $user_email = check_html($user_email, nohtml);
    $femail = check_html($femail, nohtml);
    $user_website = check_html($user_website, nohtml);
    $bio = check_html($bio, nohtml);
    $user_avatar = check_html($user_avatar, nohtml);
    $user_idnr = check_html($user_idnr, nohtml);
    $user_icq = check_html($user_icq, nohtml);
    $user_aim = check_html($user_aim, nohtml);
    $user_yim = check_html($user_yim, nohtml);
    $user_msnm = check_html($user_msnm, nohtml);
    $user_occ = check_html($user_occ, nohtml);
    $user_from = check_html($user_from, nohtml);
    $user_interests = check_html($user_interests, nohtml);
    $realname = check_html($realname, nohtml);
    $user_avatar = "$user_avatar";
    if (($user_id == $vuid) AND ($check2 == $ccpass)) {
    if (!eregi("http://", $user_website)) {
        $user_website = "http://$user_website";
    }
    if ((isset($user_password)) && ("$user_password" != "$vpass")) {
        echo "<center>"._PASSDIFFERENT."</center>";
    } elseif (($user_password != "") && (strlen($user_password) < $minpass)) {
        echo "<center>"._YOUPASSMUSTBE." <b>$minpass</b> "._CHARLONG."</center>";
    } else {
        if ($bio) { filter_text($bio); $bio = $EditedMessage; $bio = FixQuotes($bio); }
        if ($user_password != "") {
        cookiedecode($user);
        $db->sql_query("LOCK TABLES ".$user_prefix."_users WRITE");
        $user_password = md5($user_password);
        $db->sql_query("UPDATE ".$user_prefix."_users SET name='$realname', user_email='$user_email', femail='$femail', user_website='$user_website', user_password='$user_password', bio='$bio', user_avatar='$user_avatar', user_icq='$user_icq', user_idnr='$user_idnr', user_occ='$user_occ', user_from='$user_from', user_interests='$user_interests', user_sig='$user_sig', user_aim='$user_aim', user_yim='$user_yim', user_msnm='$user_msnm', newsletter='$newsletter', user_viewemail='$user_viewemail', user_allow_viewonline='$user_allow_viewonline', user_notify='$user_notify', user_notify_pm='$user_notify_pm', user_popup_pm='$user_popup_pm', user_attachsig='$user_attachsig', user_allowbbcode='$user_allowbbcode', user_allowhtml='$user_allowhtml', user_allowsmile='$user_allowsmile', user_timezone='$user_timezone', user_dateformat='$user_dateformat' WHERE user_id='$user_id'");

        $sql = "SELECT user_id, username, user_password, storynum, umode, uorder, thold, noscore, ublockon, theme FROM ".$user_prefix."_users WHERE username='$username' AND user_password='$user_password'";
        $result = $db->sql_query($sql);
        if ($db->sql_numrows($result) == 1) {
            $userinfo = $db->sql_fetchrow($result);
            docookie($userinfo[user_id],$userinfo[username],$userinfo[user_password],$userinfo[user_idnr],$userinfo[storynum],$userinfo[umode],$userinfo[uorder],$userinfo[thold],$userinfo[noscore],$userinfo[ublockon],$userinfo[theme],$userinfo[commentmax]);
        } else {
            echo "<center>"._SOMETHINGWRONG."</center><br>";
        }
        $db->sql_query("UNLOCK TABLES");
        } else {
        $db->sql_query("UPDATE ".$user_prefix."_users SET name='$realname', user_email='$user_email', femail='$femail', user_website='$user_website', bio='$bio', user_avatar='$user_avatar', user_icq='$user_icq', user_idnr='$user_idnr', user_occ='$user_occ', user_from='$user_from', user_interests='$user_interests', user_sig='$user_sig', user_aim='$user_aim', user_yim='$user_yim', user_msnm='$user_msnm', newsletter='$newsletter', user_viewemail='$user_viewemail', user_allow_viewonline='$user_allow_viewonline', user_notify='$user_notify', user_notify_pm='$user_notify_pm', user_popup_pm='$user_popup_pm', user_attachsig='$user_attachsig', user_allowbbcode='$user_allowbbcode', user_allowhtml='$user_allowhtml', user_allowsmile='$user_allowsmile', user_timezone='$user_timezone', user_dateformat='$user_dateformat' WHERE user_id='$user_id'");
        }
        Header("Location: modules.php?name=$module_name");
    }
    }
}

function edithome() {
    global $user, $userinfo, $Default_Theme, $cookie, $broadcast_msg, $user_news, $storyhome, $module_name;
    getusrinfo($user);
    if (($userinfo[username] != $cookie[1]) AND ($userinfo[user_password] != $cookie[2])) {
    include ("header.php");
    OpenTable();
    echo "<center><font class=\"title\"><b>"._HOMECONFIG."</b></font></center>";
    CloseTable();
    echo "<br>";
    OpenTable();
    nav();
    CloseTable();
    echo "<br>";
    if($userinfo[theme]=="") {
        $userinfo[theme] = "$Default_Theme";
    }
    OpenTable();
    echo "<form action=\"modules.php?name=$module_name\" method=\"post\">";
    if ($user_news == 1) {
    echo "<b>"._NEWSINHOME."</b> "._MAX127." "
        ."<input type=\"text\" name=\"storynum\" size=\"4\" maxlength=\"3\" value=\"$userinfo[storynum]\">"
        ."<br><br>";
    } else {
    echo "<input type=\"hidden\" name=\"storynum\" value=\"$storyhome\">";
    }
    if ($userinfo[ublockon]==1) {
        $sel = "checked";
    }
    if ($broadcast_msg == 1) {
    if ($userinfo[broadcast] == 1) {
        $sel1 = "checked";
        $sel2 = "";
    } elseif ($userinfo[broadcast] == 0) {
        $sel1 = "";
        $sel2 = "checked";
    }
    echo "<b>"._MESSAGEACTIVATE."</b> <input type=\"radio\" name=\"broadcast\" value=\"1\" $sel1> "._YES." &nbsp;&nbsp;<input type=\"radio\" name=\"broadcast\" value=\"0\" $sel2>"._NO."<br><br>";
    } else {
    echo "<input type=\"hidden\" name=\"broadcast\" value=\"1\">";
    }
    echo "<input type=\"checkbox\" name=\"ublockon\" $sel>"
    ." <b>"._ACTIVATEPERSONAL."</b>"
    ."<br>"._CHECKTHISOPTION.""
    ."<br>"._YOUCANUSEHTML."<br>"
    ."<textarea cols=\"55\" rows=\"5\" name=\"ublock\">$userinfo[ublock]</textarea>"
    ."<br><br>"
    ."<input type=\"hidden\" name=\"username\" value=\"$userinfo[username]\">"
    ."<input type=\"hidden\" name=\"user_id\" value=\"$userinfo[user_id]\">"
    ."<input type=\"hidden\" name=\"op\" value=\"savehome\">"
    ."<input type=\"submit\" value=\""._SAVECHANGES."\">"
    ."</form>";
    CloseTable();
    include ("footer.php");
    } else {
    main($user);
    }
}

function chgtheme() {
    global $user, $userinfo, $Default_Theme, $cookie, $module_name;
    getusrinfo($user);
    if (($userinfo[username] != $cookie[1]) AND ($userinfo[user_password] != $cookie[2])) {
    include ("header.php");
    OpenTable();
    echo "<center><font class=\"title\"><b>"._THEMESELECTION."</b></font></center>";
    CloseTable();
    echo "<br>";
    OpenTable();
    nav();
    CloseTable();
    echo "<br>";
    OpenTable();
    echo "<center>"
    ."<form action=\"modules.php?name=$module_name\" method=\"post\">"
    ."<b>"._SELECTTHEME."</b><br>"
    ."<select name=\"theme\">";
    $handle=opendir('themes');
    while ($file = readdir($handle)) {
    if ( (!ereg("[.]",$file) AND file_exists("themes/$file/theme.php")) ) {
        $themelist .= "$file ";
    }
    }
    closedir($handle);
    $themelist = explode(" ", $themelist);
    sort($themelist);
    for ($i=0; $i < sizeof($themelist); $i++) {
        if($themelist[$i]!="") {
            echo "<option value=\"$themelist[$i]\" ";
        if((($userinfo[theme]=="") && ($themelist[$i]=="$Default_Theme")) || ($userinfo[theme]==$themelist[$i])) echo "selected";
        echo ">$themelist[$i]\n";
    }
    }
    if($userinfo[theme]=="") $userinfo[theme] = "$Default_Theme";
    echo "</select><br>"
    .""._THEMETEXT1."<br>"
    .""._THEMETEXT2."<br>"
    .""._THEMETEXT3."<br><br>"
    ."<input type=\"hidden\" name=\"user_id\" value=\"$userinfo[user_id]\">"
    ."<input type=\"hidden\" name=\"op\" value=\"savetheme\">"
    ."<input type=\"submit\" value=\""._SAVECHANGES."\">"
    ."</form>";
    CloseTable();
    include ("footer.php");
    } else {
    main($user);
    }
}


function savehome($user_id, $username, $storynum, $ublockon, $ublock, $broadcast) {
    global $user, $cookie, $userinfo, $user_prefix, $db, $module_name;
    cookiedecode($user);
    $check = $cookie[1];
    $check2 = $cookie[2];
    $sql = "SELECT user_id, user_password FROM ".$user_prefix."_users WHERE username='$check'";
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);
    $vuid = $row[user_id];
    $ccpass = $row[user_password];
    if (($user_id == $vuid) AND ($check2 == $ccpass)) {
    if(isset($ublockon)) $ublockon=1; else $ublockon=0;
    $ublock = FixQuotes($ublock);
    $db->sql_query("UPDATE ".$user_prefix."_users SET storynum='$storynum', ublockon='$ublockon', ublock='$ublock', broadcast='$broadcast' WHERE user_id='$user_id'");
    getusrinfo($user);
    docookie($userinfo[user_id],$userinfo[username],$userinfo[user_password],$userinfo[storynum],$userinfo[umode],$userinfo[uorder],$userinfo[thold],$userinfo[noscore],$userinfo[ublockon],$userinfo[theme],$userinfo[commentmax]);
    Header("Location: modules.php?name=$module_name");
    }
}

function savetheme($user_id, $theme) {
    global $user, $cookie, $userinfo, $user_prefix, $db, $module_name;
    cookiedecode($user);
    $check = $cookie[1];
    $check2 = $cookie[2];
    $theme_error = "";
    $sql = "SELECT user_id, user_password FROM ".$user_prefix."_users WHERE username='$check'";
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);
    $vuid = $row[user_id];
    $ccpass = $row[user_password];
    if (($user_id == $vuid) AND ($check2 == $ccpass)) {
    $db->sql_query("UPDATE ".$user_prefix."_users SET user_style='$theme_id' WHERE user_id='$user_id'");
    $db->sql_query("UPDATE ".$user_prefix."_users SET theme='$theme' WHERE user_id='$user_id'");
    getusrinfo($user);
    docookie($userinfo[user_id],$userinfo[username],$userinfo[user_password],$userinfo[storynum],$userinfo[umode],$userinfo[uorder],$userinfo[thold],$userinfo[noscore],$userinfo[ublockon],$userinfo[theme],$userinfo[commentmax]);
    Header("Location: modules.php?name=$module_name&theme=$theme");
    }
}

function editcomm() {
    global $user, $userinfo, $cookie, $module_name;
    getusrinfo($user);
    if (($userinfo[username] != $cookie[1]) AND ($userinfo[user_password] != $cookie[2])) {
    include ("header.php");
    OpenTable();
    echo "<center><font class=\"title\"><b>"._COMMENTSCONFIG."</b></font></center>";
    CloseTable();
    echo "<br>";
    OpenTable();
    nav();
    CloseTable();
    echo "<br>";
    OpenTable();
    echo "<table cellpadding=\"8\" border=\"0\"><tr><td>"
    ."<form action=\"modules.php?name=$module_name\" method=\"post\">"
    ."<b>"._DISPLAYMODE."</b>"
    ."<select name=\"umode\">";
    ?>
    <option value="nocomments" <?php if ($userinfo[umode] == 'nocomments') { echo "selected"; } ?>><?php echo _NOCOMMENTS ?>
    <option value="nested" <?php if ($userinfo[umode] == 'nested') { echo "selected"; } ?>><?php echo _NESTED ?>
    <option value="flat" <?php if ($userinfo[umode] == 'flat') { echo "selected"; } ?>><?php echo _FLAT ?>
    <option value="thread" <?php if (!isset($userinfo[umode]) || ($userinfo[umode]=="") || $userinfo[umode]=='thread') { echo "selected"; } ?>><?php echo _THREAD ?>
    </select>
    <br><br>
    <b><?php echo _SORTORDER ?></b>
    <select name="uorder">
    <option value="0" <?php if (!$userinfo[uorder]) { echo "selected"; } ?>><?php echo _OLDEST ?>
    <option value="1" <?php if ($userinfo[uorder]==1) { echo "selected"; } ?>><?php echo _NEWEST ?>
    <option value="2" <?php if ($userinfo[uorder]==2) { echo "selected"; } ?>><?php echo _HIGHEST ?>
    </select>
    <br><br>
    <b><?php echo _THRESHOLD ?></b>
    <?php echo _COMMENTSWILLIGNORED ?><br>
    <select name="thold">
    <option value="-1" <?php if ($userinfo[thold]==-1) { echo "selected"; } ?>>-1: <?php echo _UNCUT ?>
    <option value="0" <?php if ($userinfo[thold]==0) { echo "selected"; } ?>>0: <?php echo _EVERYTHING ?>
    <option value="1" <?php if ($userinfo[thold]==1) { echo "selected"; } ?>>1: <?php echo _FILTERMOSTANON ?>
    <option value="2" <?php if ($userinfo[thold]==2) { echo "selected"; } ?>>2: <?php echo _USCORE ?> +2
    <option value="3" <?php if ($userinfo[thold]==3) { echo "selected"; } ?>>3: <?php echo _USCORE ?> +3
    <option value="4" <?php if ($userinfo[thold]==4) { echo "selected"; } ?>>4: <?php echo _USCORE ?> +4
    <option value="5" <?php if ($userinfo[thold]==5) { echo "selected"; } ?>>5: <?php echo _USCORE ?> +5
    </select><br>
    <i><?php echo _SCORENOTE ?></i>
    <br><br>
    <INPUT type="checkbox" name="noscore" <?php if ($userinfo[noscore]==1) { echo "checked"; } ?>><b> <?php echo _NOSCORES ?></b> <?php echo _HIDDESCORES ?>
    <br><br>
    <b><?php echo _MAXCOMMENT ?></b> <?php echo _TRUNCATES ?><br>
    <input type="text" name="commentmax" value="<?php echo $userinfo[commentmax] ?>" size=11 maxlength=11> <?php echo _BYTESNOTE ?>
    <br><br>
    <input type="hidden" name="username" value="<?php echo"$userinfo[username]"; ?>">
    <input type="hidden" name="user_id" value="<?php echo"$userinfo[user_id]"; ?>">
    <input type="hidden" name="op" value="savecomm">
    <input type="submit" value="<?php echo _SAVECHANGES ?>">
    </form></td></tr></table>
    <?php
    CloseTable();
    echo "<br><br>";
    include ("footer.php");
    } else {
    main($user);
    }
}

function savecomm($user_id, $username, $umode, $uorder, $thold, $noscore, $commentmax) {
    global $user, $cookie, $userinfo, $user_prefix, $db, $module_name;
    cookiedecode($user);
    $check = $cookie[1];
    $check2 = $cookie[2];
    $sql = "SELECT user_id, user_password FROM ".$user_prefix."_users WHERE username='$check'";
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);
    $vuid = $row[user_id];
    $ccpass = $row[user_password];
    if (($user_id == $vuid) AND ($check2 == $ccpass)) {
    if(isset($noscore)) $noscore=1; else $noscore=0;
    $db->sql_query("UPDATE ".$user_prefix."_users SET umode='$umode', uorder='$uorder', thold='$thold', nosco
Avatar billede winpower Nybegynder
16. juli 2004 - 10:20 #3
det er user_idnr der driller
Avatar billede erikjacobsen Ekspert
16. juli 2004 - 10:29 #4
Principielt vil jeg gerne hjælpe dig, men med over 1000 liniers kode i een fil
har jeg altså ikke evner og kræfter til at grave mig ind til dit problem.

Min anbefaling er at du glemmer databaseproblemet, og får struktureret dit
script bedre - evt blot i en række include-filer. Det vil også være en
hjælp til dig selv.

Hvis du så kan pege på det sted dit problem er, så kan jeg hjælpe dig.
Avatar billede dmdisco Nybegynder
16. juli 2004 - 10:31 #5
meget svært at gennemskue men har du smidt en "or die(mysql_error())" ind hvis det er en hel update kald den er gal med ellers så tjek om feltnavnet er stavet rigtigt
Avatar billede winpower Nybegynder
16. juli 2004 - 10:32 #6
Jeg er sikker på det er i dette område:

function edituser() {
    global $user, $userinfo, $user_idnr, $cookie, $module_name, $bgcolor2, $bgcolor3;
    getusrinfo($user);
    if (($userinfo[username] != $cookie[1]) AND ($userinfo[user_password] != $cookie[2])) {
    include("header.php");
    OpenTable();
    echo "<center><font class=\"title\"><b>"._PERSONALINFO."</b></font></center>";
    CloseTable();
    echo "<br>";
    OpenTable();
    nav();
    CloseTable();
    echo "<br>";
    if (!eregi("http://",$userinfo[user_website])) {
        $userinfo[user_website] = "http://$userinfo[user_website]";
    }
    OpenTable();
    $userinfo[user_avatar] = ereg_replace("gallery/","",$userinfo[user_avatar]);
    echo "<table cellpadding=\"3\" border=\"0\" width='100%'><tr><td bgcolor='$bgcolor2'>"
        ."<form name=\"Register\" action=\"modules.php?name=$module_name\" method=\"post\">"
        ."<b>"._USRNICKNAME."</b>:</td><td bgcolor='$bgcolor3'><b>$userinfo[username]</b></td></tr><tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._IDNR."</b>:<br>"._OPTIONAL."</td><td bgcolor='$bgcolor3'>"
        ."<input type=\"text\" name=\"user_idnr\" value=\"$userinfo[user_idnr]\" size=\"50\" maxlength=\"10\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._UREALNAME."</b>:<br>"._OPTIONAL."</td><td bgcolor='$bgcolor3'>"
        ."<input type=\"text\" name=\"realname\" value=\"$userinfo[name]\" size=\"50\" maxlength=\"60\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._UREALEMAIL.":</b><br>"._REQUIRED."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_email\" value=\"$userinfo[user_email]\" size=\"50\" maxlength=\"255\"><br>"._EMAILNOTPUBLIC."</td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._UFAKEMAIL.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"femail\" value=\"$userinfo[femail]\" size=\"50\" maxlength=\"255\"><br>"._EMAILPUBLIC."</td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YOURHOMEPAGE.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_website\" value=\"$userinfo[user_website]\" size=\"50\" maxlength=\"255\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YOURAVATAR.":</b><br>"._OPTIONAL."</td><td bgcolor='$bgcolor3'>[ <a href=\"modules.php?name=$module_name&amp;op=avatarlist\">"._LIST."</a> ]&nbsp;&nbsp;"
        ."<select name=\"user_avatar\" onChange=\"showimage()\">"
        ."<option value=\"$userinfo[user_avatar]\">$userinfo[user_avatar]</option>";
    $direktori = "modules/Forums/images/avatars/gallery";
    $handle=opendir($direktori);
    while ($file = readdir($handle)) {
        $filelist[] = $file;
    }
    asort($filelist);
    while (list ($key, $file) = each ($filelist)) {
        ereg(".gif|.jpg",$file);
        if ($file == "." || $file == "..") {
        $a=1;
        } else {
        echo "<option value=\"$file\">$file</option>";
        }
    }
    echo "</select>&nbsp;&nbsp;<img src=\"modules/Forums/images/avatars/gallery/$userinfo[user_avatar]\" name=\"avatar\" width=\"32\" height=\"32\" alt=\"\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._IDNR.":</b><br>"._REQUIRED."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_idnr\" value=\"$userinfo[user_idnr]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YICQ.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_icq\" value=\"$userinfo[user_icq]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YAIM.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_aim\" value=\"$userinfo[user_aim]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YYIM.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_yim\" value=\"$userinfo[user_yim]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YMSNM.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_msnm\" value=\"$userinfo[user_msnm]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YLOCATION.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_from\" value=\"$userinfo[user_from]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YOCCUPATION.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_occ\" value=\"$userinfo[user_occ]\" size=\"30\" maxlength=\"100\"></td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._YINTERESTS.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><input type=\"text\" name=\"user_interests\" value=\"$userinfo[user_interests]\" size=\"30\" maxlength=\"100\"></td></tr>";
    echo "<tr><td bgcolor='$bgcolor2'><b>"._RECEIVENEWSLETTER."</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[newsletter] == 1) {
        echo "<input type=\"radio\" name=\"newsletter\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"newsletter\" value=\"0\">"._NO."";
    } elseif ($userinfo[newsletter] == 0) {
        echo "<input type=\"radio\" name=\"newsletter\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"newsletter\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._ALWAYSSHOWEMAIL.":</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_viewemail] == 1) {
        echo "<input type=\"radio\" name=\"user_viewemail\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_viewemail\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_viewemail] == 0) {
        echo "<input type=\"radio\" name=\"user_viewemail\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_viewemail\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._HIDEONLINE.":</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_allow_viewonline] == 1) {
        echo "<input type=\"radio\" name=\"user_allow_viewonline\" value=\"0\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allow_viewonline\" value=\"1\" checked>"._NO."";
    } elseif ($userinfo[user_allow_viewonline] == 0) {
        echo "<input type=\"radio\" name=\"user_allow_viewonline\" value=\"0\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allow_viewonline\" value=\"1\">"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._REPLYNOTIFY.":</b><br>"._REPLYNOTIFYMSG."</td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_notify] == 1) {
        echo "<input type=\"radio\" name=\"user_notify\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_notify\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_notify] == 0) {
        echo "<input type=\"radio\" name=\"user_notify\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_notify\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._PMNOTIFY.":</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_notify_pm] == 1) {
        echo "<input type=\"radio\" name=\"user_notify_pm\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_notify_pm\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_notify_pm] == 0) {
        echo "<input type=\"radio\" name=\"user_notify_pm\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_notify_pm\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._POPPM.":</b><br>"._POPPMMSG."</td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_popup_pm] == 1) {
        echo "<input type=\"radio\" name=\"user_popup_pm\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_popup_pm\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_popup_pm] == 0) {
        echo "<input type=\"radio\" name=\"user_popup_pm\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_popup_pm\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._ATTACHSIG.":</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_attachsig] == 1) {
        echo "<input type=\"radio\" name=\"user_attachsig\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_attachsig\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_attachsig] == 0) {
        echo "<input type=\"radio\" name=\"user_attachsig\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_attachsig\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._ALLOWBBCODE."</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_allowbbcode] == 1) {
        echo "<input type=\"radio\" name=\"user_allowbbcode\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowbbcode\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_allowbbcode] == 0) {
        echo "<input type=\"radio\" name=\"user_allowbbcode\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowbbcode\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._ALLOWHTMLCODE."</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_allowhtml] == 1) {
        echo "<input type=\"radio\" name=\"user_allowhtml\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowhtml\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_allowhtml] == 0) {
        echo "<input type=\"radio\" name=\"user_allowhtml\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowhtml\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._ALLOWSMILIES."</b></td><td bgcolor='$bgcolor3'>";
    if ($userinfo[user_allowsmile] == 1) {
        echo "<input type=\"radio\" name=\"user_allowsmile\" value=\"1\" checked>"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowsmile\" value=\"0\">"._NO."";
    } elseif ($userinfo[user_allowsmile] == 0) {
        echo "<input type=\"radio\" name=\"user_allowsmile\" value=\"1\">"._YES." &nbsp;"
        ."<input type=\"radio\" name=\"user_allowsmile\" value=\"0\" checked>"._NO."";
    }
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._FORUMSTIME."</b></td><td bgcolor='$bgcolor3'>";
    echo "<select name='user_timezone'>";
    for ($i=-12; $i<13; $i++) {
        if ($i == 0) {
        $dummy = "GMT";
        } else {
        if (!ereg("-", $i)) {
            $i = "+$i";
        }
        $dummy = "GMT $i "._HOURS."";
        }
        if ($userinfo[user_timezone] == $i) {
            echo "<option name=\"user_timezone\" value=\"$i\" selected>$dummy</option>";
        } else {
        echo "<option name=\"user_timezone\" value=\"$i\">$dummy</option>";
        }

    }
    echo "</select>";
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._FORUMSDATE.":</b><br>"._FORUMSDATEMSG."</b></td><td bgcolor='$bgcolor3'>";
    echo "<input size='15' maxlength='14' type=\"text\" name=\"user_dateformat\" value=\"$userinfo[user_dateformat]\">";
    echo "</td></tr>";

    echo "<tr><td bgcolor='$bgcolor2'><b>"._SIGNATURE.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><textarea wrap=\"virtual\" cols=\"50\" rows=\"5\" name=\"user_sig\">$userinfo[user_sig]</textarea><br>"._255CHARMAX."</td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._EXTRAINFO.":</b><br>"._OPTIONAL."</td>"
        ."<td bgcolor='$bgcolor3'><textarea wrap=\"virtual\" cols=\"50\" rows=\"5\" name=\"bio\">$userinfo[bio]</textarea><br>"._CANKNOWABOUT."</td></tr>"
        ."<tr><td bgcolor='$bgcolor2'><b>"._PASSWORD."</b>:</td><br>"
        ."<td bgcolor='$bgcolor3'><input type=\"password\" name=\"user_password\" size=\"22\" maxlength=\"20\">&nbsp;&nbsp;&nbsp;<input type=\"password\" name=\"vpass\" size=\"22\" maxlength=\"20\"><br>"._TYPENEWPASSWORD."</td></tr>"
        ."<tr><td bgcolor='$bgcolor3' colspan='2' align='center'>"
        ."<input type=\"hidden\" name=\"username\" value=\"$userinfo[username]\">"
        ."<input type=\"hidden\" name=\"user_id\" value=\"$userinfo[user_id]\">"
        ."<input type=\"hidden\" name=\"op\" value=\"saveuser\">"
        ."<input type=\"submit\" value=\""._SAVECHANGES."\">"
        ."</form></td></tr></table>";
    CloseTable();
    include("footer.php");
    } else {
    main($user);
    }
}
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester