Trying To Modify Your_Account index.php Please Help

New Member Joined: Mar 01, 2005 Posts: 3

In side Your Account I am trying to add button to go to sql database and pull UserID, car, cup, bush, cts with out editing the car, I have gotten that to work!!! ***however when I try to create function to update the sql it goes back to the man Your Account ok, but no changes were made.

Code: Function league this works but maybe I did it wrong

Code:

function league() {


    global $prefix, $db, $user, $userinfo, $car, $cookie, $module_name, $bgcolor2, $bgcolor3;


    cookiedecode($user);


    getusrinfo($user);


    if ((is_user($user)) AND (strtolower($userinfo['username']) == strtolower($cookie[1])) AND ($userinfo['user_password'] == $cookie[2])) {


   include("header.php");


   OpenTable();


   echo "<center><font class=\"title\"><b>"._LEAGUE."</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();


   echo "<table class=forumline cellpadding=\"3\" border=\"0\" width='100%'>"


       ."<form name=\"Register\" action=\"modules.php?name=$module_name\" method=\"post\">"


       ."<tr><td bgcolor='$bgcolor2'><b>"._USRNICKNAME."</b>:</td><td bgcolor='$bgcolor3'><b>$userinfo[username]</b></td></tr>"


       ."<tr><td bgcolor='$bgcolor2'><b>"._LEAGUENUM."</b>:</td><td bgcolor='$bgcolor3'><b>$userinfo[car]</b></td></tr>"


       ."<tr><td bgcolor='$bgcolor2'><b>"._SUSER."</b>:<br>"._REQUIRED."</td><td bgcolor='$bgcolor3'>"


       ."<input type=\"text\" name=\"suser\" value=\"$userinfo[suser]\" size=\"50\" maxlength=\"60\"></td></tr>";


      echo "<tr><td bgcolor='$bgcolor2'><b>"._CUP."</b></td><td bgcolor='$bgcolor3'>";


   if ($userinfo[cup] == 1) {


       echo "<input type=\"radio\" name=\"cup\" value=\"1\" checked>"._YES." &nbsp;"


      ."<input type=\"radio\" name=\"cup\" value=\"0\">"._NO."";


   } elseif ($userinfo[cup] == 0) {


       echo "<input type=\"radio\" name=\"cup\" value=\"1\">"._YES." &nbsp;"


      ."<input type=\"radio\" name=\"cup\" value=\"0\" checked>"._NO."";


   }


       echo "<tr><td bgcolor='$bgcolor2'><b>"._BUSH."</b></td><td bgcolor='$bgcolor3'>";


   if ($userinfo[bush] == 1) {


       echo "<input type=\"radio\" name=\"bush\" value=\"1\" checked>"._YES." &nbsp;"


      ."<input type=\"radio\" name=\"bush\" value=\"0\">"._NO."";


   } elseif ($userinfo[bush] == 0) {


       echo "<input type=\"radio\" name=\"bush\" value=\"1\">"._YES." &nbsp;"


      ."<input type=\"radio\" name=\"bush\" value=\"0\" checked>"._NO."";


   }


        echo "<tr><td bgcolor='$bgcolor2'><b>"._CTS."</b></td><td bgcolor='$bgcolor3'>";


   if ($userinfo[cts] == 1) {


       echo "<input type=\"radio\" name=\"cts\" value=\"1\" checked>"._YES." &nbsp;"


      ."<input type=\"radio\" name=\"cts\" value=\"0\">"._NO."";


   } elseif ($userinfo[cts] == 0) {


       echo "<input type=\"radio\" name=\"cts\" value=\"1\">"._YES." &nbsp;"


      ."<input type=\"radio\" name=\"cts\" value=\"0\" checked>"._NO."";


   }


    echo "<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=\"saveleague\">"


       ."<input class=button type=\"submit\" value=\""._SAVECHANGES."\">"


       ."</form></td></tr>";


    CloseTable();


   include("footer.php");


    } else {


   main($user);


    }


}

This is the part that fails with no errors
Function saveleague

Code:

function saveleague($suser, $cup, $cts, $bush, $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 = intval($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_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);


    $suer = check_html($suser);


    //$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);


      $cup = intval($cup);


      $bush = intval($bush);


      $cts = intval($cts);


   //   $user_notify_pm = intval($user_notify_pm);


   //   $user_popup_pm = intval($user_popup_pm);


   //   $user_allowbbcode = intval($user_allowbbcode);


   //   $user_allowhtml = intval($user_allowhtml);


   //   $user_allowsmile = intval($user_allowsmile);


    //    $user_id = intval($user_id);


      $db->sql_query("UPDATE ".$user_prefix."_users SET suser='$suser', cup='$cup', bush='$bush', cts='$cts' WHERE user_id='$user_id'");


      $sql = "SELECT user_id, suser, cup, bush, cts 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[suser],$userinfo[cup],$userinfo[bush],$userinfo[cts]);


   //   } else {


   //       echo "<center>"._SOMETHINGWRONG."</center><br>";


   //   }


   //   $db->sql_query("UNLOCK TABLES");


   //    } else {


   //   $db->sql_query("UPDATE ".$user_prefix."_users SET suser='$suser', cup='$cup', bush='$bush', cts='$cts' WHERE user_id='$user_id'");


   //    }


   //    Header("Location: modules.php?name=$module_name");


   //}


    //}


}

Can Someone help i have spent hours searching for answers and reading php-nuke manual and tring differnt things, I am just not understanding how to update the sql

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

A blank page usually records an error in your Server error log. Look there first. Then, referring to this code,

Code:

$db->sql_query("UPDATE ".$user_prefix."_users SET suser='$suser', cup='$cup', bush='$bush', cts='$cts' WHERE user_id='$user_id'");

Add this code afterwards to try to see what may be happening

Code:

die("MySQL said: ".mysql_error());

Posted: Wed Mar 02, 2005 7:14 pm

tried that, since i only want to chage 3 things is there an easier way?? It still go back to the index of the test_Account main page i am working on. Still no blank error page.

Posted: Wed Mar 02, 2005 7:55 pm

fixed it, thanks the problem was in the league function commented

// ."<input type=\"hidden\" name=\"username\" value=\"$userinfo[username]\">"
works perfect.