Divvy
05-18-2010, 12:08 AM
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:
UPDATE vns_thread SET postuserid = REPLACE (postuserid,'68','104002')
But I am afraid If he found for example a postuserid like 1687 and he replaces with 11040027. 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:
UPDATE vns_post SET userid = REPLACE (userid,'0','104002')
But I am afraid If he found for example a userid like 101 and he replaces with 11040021. 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!
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:
UPDATE vns_thread SET postuserid = REPLACE (postuserid,'68','104002')
But I am afraid If he found for example a postuserid like 1687 and he replaces with 11040027. 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:
UPDATE vns_post SET userid = REPLACE (userid,'0','104002')
But I am afraid If he found for example a userid like 101 and he replaces with 11040021. 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!