$chng_user = stripslashes(check_html($chng_user, "nohtml"));


      $result = $db->sql_query("SELECT user_id, username, name, user_website, user_email, femail, user_icq, user_aim, user_yim, user_msnm, user_from, user_occ, user_interests, user_viewemail, user_avatar, user_sig, user_password, newsletter, goff from " . $user_prefix . "_users where username='$chng_user'");


      $numrows = $db->sql_numrows($result);


      if($numrows > 0) {


         $row = $db->sql_fetchrow($result);


         $chng_uid = intval($row['user_id']);


         $chng_uname = filter($row['username'], "nohtml");


         $chng_name = filter($row['name'], "nohtml");


         $chng_url = filter($row['user_website'], "nohtml");


         $chng_email = filter($row['user_email'], "nohtml");


         $chng_femail = filter($row['femail'], "nohtml");


         $chng_user_icq = filter($row['user_icq'], "nohtml");


         $chng_user_aim = filter($row['user_aim'], "nohtml");


         $chng_user_yim = filter($row['user_yim'], "nohtml");


         $chng_user_msnm = filter($row['user_msnm'], "nohtml");


         $chng_user_from = filter($row['user_from'], "nohtml");


         $chng_user_occ = filter($row['user_occ'], "nohtml");


         $chng_user_intrest = filter($row['user_interests'], "nohtml");


         $chng_user_viewemail = filter($row['user_viewemail'], "nohtml");


         $chng_avatar = filter($row['user_avatar'], "nohtml");


         $chng_user_sig = filter($row['user_sig']);


         $chng_pass = filter($row['user_password'], "nohtml");


         $chng_newsletter = intval($row['newsletter']);


         $chng_goff = intval($row['goff']);


         OpenTable();


         echo "<center><font class=\"option\"><b>" . _USERUPDATE . ": <i>$chng_user</i></b></font></center>"

         if ($chng_user_viewemail ==1) {


            echo "<td><input type=\"checkbox\" name=\"chng_user_viewemail\" value=\"1\" checked> " . _ALLOWUSERS . "</td></tr>";


         } else {


            echo "<td><input type=\"checkbox\" name=\"chng_user_viewemail\" value=\"1\"> " . _ALLOWUSERS . "</td></tr>";


         }


         if ($chng_goff == 1) {


            echo "<tr><td>Guild Officer</td><td><input type=\"radio\" name=\"chng_goff\" value=\"1\" checked>" . _YES . "&nbsp;&nbsp;"


            ."<input type=\"radio\" name=\"chng_goff\" value=\"0\">" . _NO . "</td></tr>";


         } elseif ($chng_goff == 0) {


            echo "<tr><td>Guild Officer</td><td><input type=\"radio\" name=\"chng_goff\" value=\"1\">" . _YES . "&nbsp;&nbsp;"


            ."<input type=\"radio\" name=\"chng_goff\" value=\"0\" checked>" . _NO . "</td></tr>";


         }


         echo "<tr><td>" . _SIGNATURE . "</td>"

   function updateUser($chng_goff, $chng_uid, $chng_uname, $chng_name, $chng_url, $chng_email, $chng_femail, $chng_user_icq, $chng_user_aim, $chng_user_yim, $chng_user_msnm, $chng_user_from, $chng_user_occ, $chng_user_intrest, $chng_user_viewemail, $chng_avatar, $chng_user_sig, $chng_pass, $chng_pass2, $chng_newsletter, $subscription, $subscription_expire, $reason) {


      global $user_prefix, $db, $prefix, $nukeurl, $sitename, $adminmail, $subscription_url, $admin_file;


      $chng_uid = intval($chng_uid);


      $chng_uname = filter($chng_uname, "nohtml", 1);


      $chng_name = filter($chng_name, "nohtml", 1);


      $chng_url = filter($chng_url, "nohtml", 1);


      $chng_email = filter($chng_email, "nohtml", 1);


      $chng_femail = filter($chng_femail, "nohtml", 1);


      $chng_user_icq = filter($chng_user_icq, "nohtml", 1);


      $chng_user_aim = filter($chng_user_aim, "nohtml", 1);


      $chng_user_yim = filter($chng_user_yim, "nohtml", 1);


      $chng_user_msnm = filter($chng_user_msnm, "nohtml", 1);


      $chng_user_from = filter($chng_user_from, "nohtml", 1);


      $chng_user_occ = filter($chng_user_occ, "nohtml", 1);


      $chng_user_intrest = filter($chng_user_intrest, "nohtml", 1);


      $chng_user_viewemail = intval($chng_user_viewemail);


      $chng_avatar = filter($chng_user_avatar, "nohtml", 1);


      $chng_user_sig = filter($chng_user_sig, "", 1);


      $chng_pass = filter($chng_pass, "nohtml", 1);


      $chng_pass2 = filter($chng_pass2, "nohtml", 1);


      $chng_newsletter = intval($chng_newsletter);


      $chng_goff = intval($chng_goff);


      $tmp = 0;


      if (!empty($chng_pass2)) {


         if($chng_pass != $chng_pass2) {


            include("header.php");


            GraphicAdmin();


            OpenTable();


            echo "<center><font class=\"title\"><b>" . _USERADMIN . "</b></font></center>";


            CloseTable();


            echo "<br>";


            OpenTable();


            echo "<center>" . _PASSWDNOMATCH . "<br><br>"


            ."" . _GOBACK . "</center>";


            CloseTable();


            include("footer.php");


            exit;


         }


         $tmp = 1;


      }


      if ($tmp == 0) {


         $db->sql_query("update " . $user_prefix . "_users set username='$chng_uname', name='$chng_name', user_email='$chng_email', femail='$chng_femail', user_website='$chng_url', user_icq='$chng_user_icq', user_aim='$chng_user_aim', user_yim='$chng_user_yim', user_msnm='$chng_user_msnm', user_from='$chng_user_from', user_occ='$chng_user_occ', user_interests='$chng_user_intrest', user_viewemail='$chng_user_viewemail', user_avatar='$chng_avatar', user_sig='$chng_user_sig', newsletter='$chng_newsletter', goff='$chng_goff' where user_id='$chng_uid'");


      }


      if ($tmp == 1) {


         $cpass = md5($chng_pass);


         $db->sql_query("update " . $user_prefix . "_users set username='$chng_uname', name='$chng_name', user_email='$chng_email', femail='$chng_femail', user_website='$chng_url', user_icq='$chng_user_icq', user_aim='$chng_user_aim', user_yim='$chng_user_yim', user_msnm='$chng_user_msnm', user_from='$chng_user_from', user_occ='$chng_user_occ', user_interests='$chng_user_intrest', user_viewemail='$chng_user_viewemail', user_avatar='$chng_avatar', user_sig='$chng_user_sig', user_password='$cpass', newsletter='$chng_newsletter', goff='$chng_goff' where user_id='$chng_uid'");