How to rollback an account

[Dvrstle]

i want to roll back one account only. . . . how can i do this on phpmyadmin ???

[Rayhan]

Make sure you have a backup and just take out that one account and update your database to match your backup.

[Dvrstle]

xD not that easy. . . i know that it is the one that i should do . . but how?

[Rayhan]

locate your backup, search the account ID and update your database to match your backup, in char , skill, guild, party etc.

[Dvrstle]

i want to roll back one account only. . . . how can i do this on phpmyadmin ???

the account of 2000111 storage items, inventory and cart tnx

[Rayhan]

just search your phpMyAdmin database to match the account ID and change the values withing the feilds, its a longer process for just one account but it wouldnt take long.

Or simply do a search for the account ID and delete it all then import your backup with the only one account.

[KeyWorld]

Do you have a backup ?...

If yes, just get all data related to the account_id, get all char_id from the acccount, get all data related to this char_id.

Just import the file with all the data you extract and that's all.

But you have to know, a rollback for only one character is not a good idea.

[Dvrstle]

its for 1 account sir

i really need your help because vote 4 points became buggy on my server. . . a player's points became twice his points after voting. . . and then all his storage items became white herbs, anodyne etc. . .xD

[Rayhan]

Like i said, delete all his data from the dabase (phpMyAdmin) and import his data back in from your backup file.

Simple process, wouldnt take more than 20 minutes max.

[Rayan]

firstly stop the voting systems dude , then check for the script coz its cozing errors and if you don't have the backup of the sql database then IT CANNOT BE SOLVED, yea if the player gives out the screen shot of the items it have then you can give him items back.....

[jackel2013]

Can I have a question too..how can I backup the ro account created in MySQL?don't have an idea how to do it.

[Chaos92]

1. get your rollback backup.

2. backup your current database.

Quote

the account of 2000111 storage items, inventory and cart tnx

3.search in storage,cart inventory, inventory ,guild storage, etc that needed only for accountid 2000111 and all charid for accountid 2000111

4. remove current data accountid 2000111 and replace it with the rollback you needed

[Chaos92]

14 hours ago, jackel2013 said:

Can I have a question too..how can I backup the ro account created in MySQL?don't have an idea how to do it.

mysqldump, or in phpmyadmin got export section.