How to rollback whole server accounts?

[BabaVoss]

good day guys, can anyone help me how to roll back a server for a 1 week. there was a bug on an npc, everybody bought an item for free. and theres a lot who have bought already. i wanted to do a 1 week rollback. can anyone help pls? thanks

[Chaos92]

4 hours ago, BabaVoss said:

good day guys, can anyone help me how to roll back a server for a 1 week. there was a bug on an npc, everybody bought an item for free. and theres a lot who have bought already. i wanted to do a 1 week rollback. can anyone help pls? thanks

Do you have database backups ? If yes, then just use the backups from a week ago.

If not, then you might need to prepare for next time, maybe.

[BabaVoss]

1 hour ago, Chaos92 said:

Do you have database backups ? If yes, then just use the backups from a week ago.

If not, then you might need to prepare for next time, maybe.

im sorry i dont think i do have db backup for the last week. but im using myphpadmin sql, does it have back up logs?

[Chaos92]

5 hours ago, BabaVoss said:

im sorry i dont think i do have db backup for the last week. but im using myphpadmin sql, does it have back up logs?

if u didnt have it, then its not possible then. except u can rollback your server or pc to last week for example u have system restore, etc.

Edited June 12, 2023 by Chaos92
additional info

[valesti]

Technically possible, but boring.
In the database you will find a table called picklog with the date and time of obtaining that item. There will be described the type if it was dropped by monster, NPC, or by some command.

Filter exploit dates and times, and the type of (monster, npc, command). Get account ids and delete the items in table inventory, cart_inventory, storage, guild_storage.

It won't be 100% accurate, but it will give you a north to adjust.

 

Sorry for my English. I hope you understand.

[Chaos92]

18 hours ago, valesti said:

Technically possible, but boring.
In the database you will find a table called picklog with the date and time of obtaining that item. There will be described the type if it was dropped by monster, NPC, or by some command.

Filter exploit dates and times, and the type of (monster, npc, command). Get account ids and delete the items in table inventory, cart_inventory, storage, guild_storage.

It won't be 100% accurate, but it will give you a north to adjust.

 

Sorry for my English. I hope you understand.

this can be done but really need to go through a lot especially for servers with quite a lot of players + timeframe too long.