Dvrstle Posted November 22, 2012 Group: Members Topic Count: 125 Topics Per Day: 0.03 Content Count: 361 Reputation: 10 Joined: 12/30/11 Last Seen: January 3, 2016 Share Posted November 22, 2012 i want to roll back one account only. . . . how can i do this on phpmyadmin ??? Quote Link to comment Share on other sites More sharing options...
0 jackel2013 Posted September 6, 2017 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 38 Reputation: 0 Joined: 11/18/12 Last Seen: November 23, 2022 Share Posted September 6, 2017 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. Quote Link to comment Share on other sites More sharing options...
0 Chaos92 Posted September 6, 2017 Group: Members Topic Count: 49 Topics Per Day: 0.01 Content Count: 1550 Reputation: 239 Joined: 08/03/12 Last Seen: 10 hours ago Share Posted September 6, 2017 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 Quote Link to comment Share on other sites More sharing options...
0 Chaos92 Posted September 6, 2017 Group: Members Topic Count: 49 Topics Per Day: 0.01 Content Count: 1550 Reputation: 239 Joined: 08/03/12 Last Seen: 10 hours ago Share Posted September 6, 2017 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. Quote Link to comment Share on other sites More sharing options...
Rayhan Posted November 22, 2012 Group: Members Topic Count: 18 Topics Per Day: 0.00 Content Count: 102 Reputation: 1 Joined: 11/06/12 Last Seen: May 8, 2013 Share Posted November 22, 2012 Make sure you have a backup and just take out that one account and update your database to match your backup. Quote Link to comment Share on other sites More sharing options...
Dvrstle Posted November 22, 2012 Group: Members Topic Count: 125 Topics Per Day: 0.03 Content Count: 361 Reputation: 10 Joined: 12/30/11 Last Seen: January 3, 2016 Author Share Posted November 22, 2012 xD not that easy. . . i know that it is the one that i should do . . but how? Quote Link to comment Share on other sites More sharing options...
Rayhan Posted November 22, 2012 Group: Members Topic Count: 18 Topics Per Day: 0.00 Content Count: 102 Reputation: 1 Joined: 11/06/12 Last Seen: May 8, 2013 Share Posted November 22, 2012 locate your backup, search the account ID and update your database to match your backup, in char , skill, guild, party etc. Quote Link to comment Share on other sites More sharing options...
Dvrstle Posted November 22, 2012 Group: Members Topic Count: 125 Topics Per Day: 0.03 Content Count: 361 Reputation: 10 Joined: 12/30/11 Last Seen: January 3, 2016 Author Share Posted November 22, 2012 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 Quote Link to comment Share on other sites More sharing options...
Rayhan Posted November 22, 2012 Group: Members Topic Count: 18 Topics Per Day: 0.00 Content Count: 102 Reputation: 1 Joined: 11/06/12 Last Seen: May 8, 2013 Share Posted November 22, 2012 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. Quote Link to comment Share on other sites More sharing options...
KeyWorld Posted November 22, 2012 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 379 Reputation: 304 Joined: 11/10/11 Last Seen: December 2, 2014 Share Posted November 22, 2012 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. 2 Quote Link to comment Share on other sites More sharing options...
Dvrstle Posted November 22, 2012 Group: Members Topic Count: 125 Topics Per Day: 0.03 Content Count: 361 Reputation: 10 Joined: 12/30/11 Last Seen: January 3, 2016 Author Share Posted November 22, 2012 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 Quote Link to comment Share on other sites More sharing options...
Rayhan Posted November 22, 2012 Group: Members Topic Count: 18 Topics Per Day: 0.00 Content Count: 102 Reputation: 1 Joined: 11/06/12 Last Seen: May 8, 2013 Share Posted November 22, 2012 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. Quote Link to comment Share on other sites More sharing options...
Rayan Posted November 22, 2012 Group: Members Topic Count: 34 Topics Per Day: 0.01 Content Count: 188 Reputation: 16 Joined: 06/12/12 Last Seen: September 1, 2016 Share Posted November 22, 2012 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..... Quote Link to comment Share on other sites More sharing options...
Question
Dvrstle
i want to roll back one account only. . . . how can i do this on phpmyadmin ???
Link to comment
Share on other sites
12 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.