Need Help (sql most likely)

[Guest monitorize]

so TEN got hacked by ikon a while ago and stuff and he ran a sql command changing everyones username and email to ran by ikonroi

here is how the posts look like  on index

but then when i click on the forum it shows the username

 

 

what would the sql command be to refresh this and fix it?

[Lock Down]

That is because it is probably not the display name but member_display_names.

 

try this

update ipb_members set members_display_name = COALESCE((select starter_name from ipb_topics where member_id=starter_id group by starter_id),members_display_name)

or this

update members set members_display_name = COALESCE((select starter_name from topics where member_id=starter_id group by starter_id),members_display_name)

[cyimking]

What;s the domain?

[Guest monitorize]

What;s the domain?

 at the moment you will probably be getting 403 error i will disable the security asap

Edited September 1, 2013 by monitorize

[Phun]

If he ran a command to change all display names to the same name it will most likely be un-doable to revert that unless you have a backup.

[Lock Down]

Any names can be fixed that have posted without a backup but the emails will definitely need the backup of the members table to be restored.

   

 

 

BE SURE TO EXPORT THE MEMBERS TABLE FIRST!!!!!!!  OR  backup the database...

update ipb_members set name = COALESCE((select starter_name from ipb_topics where member_id=starter_id group by starter_id),name)

Edited July 20, 2013 by Lock Down

[Guest monitorize]

If he ran a command to change all display names to the same name it will most likely be un-doable to revert that unless you have a backup.

but we were still able to log in as our names so such as monitorize and pass *******

Any names can be fixed that have posted without a backup but the emails will definitely need the backup of the members table to be restored.

   

 

 

BE SURE TO EXPORT THE MEMBERS TABLE FIRST!!!!!!!  OR  backup the database...

update ipb_members set name = COALESCE((select starter_name from ipb_topics where member_id=starter_id group by starter_id),name)

this didnt work sadly still the same usernames;/

[Guest monitorize]

That is because it is probably not the display name but member_display_names.

 

try this

update ipb_members set members_display_name = COALESCE((select starter_name from ipb_topics where member_id=starter_id group by starter_id),members_display_name)

or this

update members set members_display_name = COALESCE((select starter_name from topics where member_id=starter_id group by starter_id),members_display_name)

thanks that worked now i need to figure out emails hopefully thats fixable

[Lock Down]

You are welcome. 

 

Phun is correct the only way to get the emails back is with a backup of the good member table or force to users to enter them again.

[Guest monitorize]

You are welcome. 

 

Phun is correct the only way to get the emails back is with a backup of the good member table or force to users to enter them again.

ok thank you everyone for the help. now i got to get the site back up running. By any chance do you know the sql command to change all emails? i would like to change everyones email to [email protected]  thank you.

[Lock Down]

Sure try this

update members set email = 'reset@whensigned'orupdate ipb_members set email = 'reset@whensigned'

[Guest monitorize]

Sure try this

update members set email = 'reset@whensigned'orupdate ipb_members set email = 'reset@whensigned'

thank you soo much.

[Tony]

The question(s) in this support topic have been answered and the owner has been able to solve the problem. Because of this, the support topic has been closed and moved.If you have other questions, please open a new topic.