bury
Active Member
- Joined
- Jul 27, 2008
- Messages
- 421
- Solutions
- 7
- Reaction score
- 25
I couldn't find any tutorial of this.
I just want to have my database like if everybody starts from 0 but without removing anything, just editing. players will have their account already created on the database.
For example,
player that is level 338, elite knight, ml 6, skills 100/100, that has completed lot of quests, need:
>>>>> level 8 , knight , hp/mp that a knight level 8 has (knight sample), ml 0, skills 10/10 (all), remove all storages. Remove all their set and put the set of the samples too.
Also remove the house owner/tiles (I think this is just truncating the table) and set same x,y,z position for all players. I know to do this by editing handly the tables, but I dont know to do it with a sql code for ALL characters. Also removing vip days and premium points from the accounts table, and I think that's all.
I've saved my currently db if any problem appears.
I'm using 10.1.26-MariaDB- / TFS 0.4 / Tibia 8.6
Thanks you!
I just want to have my database like if everybody starts from 0 but without removing anything, just editing. players will have their account already created on the database.
For example,
player that is level 338, elite knight, ml 6, skills 100/100, that has completed lot of quests, need:
>>>>> level 8 , knight , hp/mp that a knight level 8 has (knight sample), ml 0, skills 10/10 (all), remove all storages. Remove all their set and put the set of the samples too.
Also remove the house owner/tiles (I think this is just truncating the table) and set same x,y,z position for all players. I know to do this by editing handly the tables, but I dont know to do it with a sql code for ALL characters. Also removing vip days and premium points from the accounts table, and I think that's all.
I've saved my currently db if any problem appears.
I'm using 10.1.26-MariaDB- / TFS 0.4 / Tibia 8.6
Thanks you!