|
|
Joined: Feb 2003
Posts: 196
Member
|
Member
Joined: Feb 2003
Posts: 196 |
recently i experienced problems with my forum, some of the users got deleted.
Of course they were not happy, so they registered their username again. Now is tehre a way I can increase their post count to what they were. i.e. an SQL command of some sort?
thanks
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
UPDATE w3t_Users SET U_Totalposts = xxxx WHERE U_Username = 'yyyy' Put the new count where i have xxxx and use their username where I have yyyy.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 87
Joined: December 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|