Post Count Error

Client Joined: Feb 19, 2005 Posts: 34

Hi guys,
For some reason when edit any part of a users profile, their post count goes to 0. It's easy enough to fix every time, but it's just annoying. Can you help me?

-Jess

Posted: Tue Sep 27, 2005 12:25 pm

What version of Nuke and where are you editing users from, the forum or the users admin link?

Posted: Tue Sep 27, 2005 2:31 pm

Nuke 7.5 and I'm editing the users from the forum. Thanks!

Posted: Tue Sep 27, 2005 2:42 pm

The only line in the forum's admin section for user management that alters the users table does not change their number of posts unless your file has been modified.

Code:

                        $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_interests = '" . str_replace("\'", "''", $interests) . "', 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_rank = $user_rank" . $avatar_sql . "


                                WHERE user_id = $user_id";

Posted: Tue Sep 27, 2005 4:35 pm

Hmm...that's odd, because I haven't done anything that would edit their post count... Confused

Posted: Tue Sep 27, 2005 5:10 pm

Does the same thing happen if you edit them through nuke's users admin section?

Posted: Wed Sep 28, 2005 8:45 pm

Ah, no it doesn't. So, I can just keep using that if I can't figure out the other. Very Happy