I imported 12000 members from my old Classic board and it seem some did not move over.

They have had to register again but lost their post count.

Can I bump that figure somehow?

Regards,
Tony S.
www.chevyforums.org
"The largest online Chevrolet enthusiast community in the world"

UPDATE w3t_Users SET U_Totalposts = XXX WHERE U_Username = 'WHOEVER'

where:
XXX = total number of posts
WHOEVER = user's display name

or:

UPDATE w3t_Users SET U_Totalposts = U_Totalposts + YYY WHERE U_Username = 'WHOEVER'

where:
YYY = number to add to total number of posts

Don't forget the WHERE clause, or you'll change everyone's post count.

Thanks Dave..

Worked like a charm.

Regards,
Tony S.
www.chevyforums.org
"The largest online Chevrolet enthusiast community in the world"

Under the catagory of people are never satisfied.


How would I modify the registration date?

Regards,
Tony S.
www.chevyforums.org
"The largest online Chevrolet enthusiast community in the world"

The query is simple

UPDATE w3t_Users
SET U_Registered = 'xxxxx'
WHERE U_Username = 'yyyyy'

Now the trick is that the xxxxx (date) above needs to be in a numerical epoch format.

epoch format is basically the number of seconds since Jan 1, 1970 GMT.

Because I've had to do some fooling with threads dates and times... I wrote a little script which will convert a real date and time to epoch format...... and convert an epoch format to a human readable format.

You can use it at http://www.joshuapettit.com/time.php

Hope that helps.

Josh
Measurection.com Admin | ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire.

I've used this little script for a while when I've needed to modify things.

If you want it for yourself, I finally posted it here at threadsdev.com.

Josh
Measurection.com Admin | ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire.

Or you could do it this way:

UPDATE w3t_Users
SET U_Registered=UNIX_TIMESTAMP('2002-11-27 23:35:00')
WHERE U_Username='whomever'

UPDATE w3t_Users
SET U_Registered=UNIX_TIMESTAMP('2002-11-27')
WHERE U_Username='whomever'

The second example sets the time of day to 00:00:00.

I had the same problem crossgrading. i had hundreds of users just 'disappear'.

I had them re-register and updated their post totals and reg date.

// Change post totals
UPDATE w3t_Users SET U_Totalposts='###' WHERE U_Username='username'

// Change registration date
UPDATE w3t_Users SET U_Registered=UNIX_TIMESTAMP('2002-12-25 12:00:00') WHERE U_Username='username'

BUT

If you are going to upgrade to 6.2 BEWARE. The username is no longer part of the search processes, it's been changed to a posterid number instead.

So that means that any posts that were created by your 'lost users' before they re-registered, will now show as Anonymous (or blank) when you upgrade.

To avoid this, you will need to do a manual update for each user that re-registered.

First you will need to find out what the user number (U_Number) is for your re-registered user in the w3t_users table.

Then you will do this query...

UPDATE w3t_Posts SET B_PosterID='usernumber' WHERE B_Username='username'

I'm still trying to figure out why those 'lost users' got lost in the first place. I've spent so many hours trying to fix the 'flawless conversion'

GOOD LUCK