Codezwiz >> Forums >> BBtoNuke Mods Help >> New Rank mod problem

Register

I have the new rank mod installed and it worked up until a little while ago. Here are the problems I am having.

1. Updating the rank in the admin portion of the forums, specifically the user management, does not update the database. I can change the the rank in the drop down menu, and when I click on update, the page refreshes the way it is supposed to, but when I return to the user, the rank has not updated.

2. If I don't assign any special rank to the first rank, and try and assign a second rank, the first rank disappears. The only way a rank will show up when using the second rank is if BOTH ranks are special ranks.

Has anyone run into this, and can anyone possilby take a look at the problem and recommend a fix?

Site is here: [ Register or login to view links on this board. ]

Sounds like in the update sql your missing something try editing something else in there account and see if that holds when you come back to the page.

Register

Good catch. I tried updating simple stuff like the location and that doesn't work either. Any suggestions?

Edit: The other portions of the site seem to be working fine. And if the changes are updated manually into the database via phpmyadmin everything works. I just seem to have lost the ability to update the database through the admin_users.php file.

Attach the admin_users.php. So the user profile works ok then?

Register

Originally posted by Telli @ Wed Dec 08, 2004 6:47 pm:

Attach the admin_users.php. So the user profile works ok then?

Sure does. Works with no problem.

Here is the attached admin_users.php

Try this one...

Register

Loaded it, now the "Something is wrong in the Big Querie!" text appears at the top of the page. No change in saving obviously.

Ok do you still have these mods installed?

user_from_flag = '$user_flag', user_interests = '" . str_replace("\'", "''", $interests) . "', user_response = '" . str_replace("\'", "''", $auto_response) . "', user_response_bbcode_uid = '$auto_response_bbcode_uid', user_response_on ='$auto_response_on', user_allow_response ='$allow_response'

Try this one and see what error it returns.

Register

Yea, both the flag and auto response mods are still there and working.

Both the rank2 and rank files are there. What's wierd is they used to work, and I modified my own account using the admin_user.php file in the forum admin when I set each up. Now, for some reason they don't work.

This is the error:

Something is wrong in the Big Querie!You have an error in your SQL syntax near 'WHERE user_id = 2' at line 1

Here's the line of text, I think:

$sql = "UPDATE " . USERS_TABLE . " SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) . "', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_from_flag = '$user_flag', user_interests = '" . str_replace("\'", "''", $interests) . "', user_response = '" . str_replace("\'", "''", $auto_response) . "', user_response_bbcode_uid = '$auto_response_bbcode_uid', user_response_on ='$auto_response_on', user_allow_response ='$allow_response', user_sig = '" . str_replace("\'", "''", $signature) . "', user_viewemail ='$viewemail', user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile ='$allowsmilies', user_allowhtml ='$allowhtml', user_allowavatar ='$user_allowavatar', user_allowbbcode ='$allowbbcode', user_allow_viewonline ='$allowviewonline', user_notify ='$notifyreply', user_allow_pm ='$user_allowpm', user_notify_pm ='$notifypm', user_popup_pm ='$popuppm', user_lang ='" . str_replace("\'", "''", $user_lang) . "', user_style ='$user_style', user_timezone ='$user_timezone', user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active ='$user_status', user_rank2 ='$user_rank2', user_rank='$user_rank', " . $avatar_sql . " WHERE user_id = $user_id";
if (!$result = $db->sql_query($sql)) {
echo "Something is wrong in the Big Querie!";
die(mysql_error());
}