hi guys,
my forum was recently hacked and he delete an important member from my forum.
the old posts of that deleted member are now posted as a guest.
my question:
He registered again in my forum, Is possible to join the old posts and threads at the new registration? He are using the same nickname.
some important info:
user nickname:
S1LV3R
old userid:
68
new userid:
104002
I was looking at the database and found out that:
Threads start by him:
Table:
vns_thread
postusername:
S1LV3R
postuserid:
68
I was thinking to make something like that:
Code:
UPDATE vns_thread SET postuserid = REPLACE (postuserid,'68','104002')
But I am afraid If he found for example a postuserid like 1
687 and he replaces with 1
1040027. It is possible to make that change to all threads that have S1LV3R as postusername? If yes, how? And this idea will be work? Or do you have any better idea to make this possible?
Posts write by him:
username:
S1LV3R
userid:
0
I was thinking to make something like that:
Code:
UPDATE vns_post SET userid = REPLACE (userid,'0','104002')
But I am afraid If he found for example a userid like 1
01 and he replaces with 1
1040021. It is possible to make that change to all threads that have S1LV3R as username? If yes, how? And this idea will be work? Or do you have any better idea to make this possible?
Please help...
Thank you!