How to reset players in your database

Tutorial explaining how to reset your server without losing the players.

1 - Running commands via SQL:

• To get started, you must access your database through your https://seuip/phpmyadmin, log into your administrative account. In the table to your left you will see the following infos:

• Access your database, I will use otservbrglobal as an example.

• Access the SQL button to be able to run the codes:

2 - Understanding each function and customizing the codes:

Here are the UPDATES, ie the commands to update player information:

UPDATE players SET level=2;            - Sets the level of all your players.
UPDATE players SET vocation=0;         - Defines the vocation of all your players.
UPDATE players SET health=155;         - The life of all your players.
UPDATE players SET healthmax=155;      - The maximum life of all your players.
UPDATE players SET experience=100;     - Sets the initial exp of all your players.
UPDATE players SET exptoday=0;         - Sets the daily exp of all your players.
UPDATE players SET lookbody=94;        - Sets the outfit color.
UPDATE players SET lookfeet=78;        - Sets the outfit color.
UPDATE players SET lookhead=78;        - Sets the outfit color.
UPDATE players SET looklegs=0;         - Sets the outfit color.
UPDATE players SET looktype=129;       - Defines the outfit.
UPDATE players SET lookaddons=0;       - Resets addons.
UPDATE players SET maglevel=0;         - Sets the magic level of all players.
UPDATE players SET mana=60;            - The mana of all players.
UPDATE players SET manamax=60;         - The maximum mana of all players.
UPDATE players SET manaspent=0;        - Defines how much mana your players have already spent.
UPDATE players SET soul=100;           - Sets the Soul of all players.
UPDATE players SET town_id=1;          - The city your player will be born in, IDs range from 1 to 23.
UPDATE players SET posx=32069;         - Defines the position on the X axis from where your players will log in for the first time.
UPDATE players SET posy=31901;         - Defines the position on the Y axis from where your players will log in for the first time.
UPDATE players SET posz=6;             - Defines the position on the Z axis from where your players will log in for the first time.
UPDATE players SET cap=410;            - Sets the total amount of cap without items.
UPDATE players SET sex=0;              - Sets the gender of your players.
UPDATE players SET skull=0;            - Sets the frags of your players.
UPDATE players SET skulltime=0;        - Set the time to expire the frags.
UPDATE players SET blessings=0;        - Defines if your players will start with bless.
UPDATE players SET blessings1=1;       - Bless 1.
UPDATE players SET blessings2=1;       - Bless 2.
UPDATE players SET blessings3=1;       - Bless 3.
UPDATE players SET blessings4=1;       - Bless 4.
UPDATE players SET blessings5=1;       - Bless 5.
UPDATE players SET blessings6=1;       - Bless 6.
UPDATE players SET blessings7=0;       - Bless 7.
UPDATE players SET blessings8=0;       - Bless 8.
UPDATE players SET balance=0;          - Defines the amount of money your players will have in the bank.
UPDATE players SET bonusrerollcount=0;    - Sets the bonus of rotating Prey.
UPDATE players SET quick_loot_fallback=0; - Resets your players' loot settings.
UPDATE players SET offlinetraining_time=43200; - Defines the time the player will have to train Offline.
UPDATE players SET stamina=2520;          - Sets player's stamina in minutes.
UPDATE players SET skill_fist=10;         - Sets the player's first skill.
UPDATE players SET skill_fist_tries=0;    - Sets the player's first skill.
UPDATE players SET skill_club=10;         - Defines the player's skill club.
UPDATE players SET skill_club_tries=0;    - Defines the player's skill club.
UPDATE players SET skill_sword=10;        - Sets the player's sword skill.
UPDATE players SET skill_sword_tries=0;   - Sets the player's sword skill.
UPDATE players SET skill_axe=10;          - Sets the player's ax skill.
UPDATE players SET skill_axe_tries=0;     - Sets the player's ax skill.
UPDATE players SET skill_dist=10;         - Sets the player's skill distance.
UPDATE players SET skill_dist_tries=0;    - Sets the player's skill distance.
UPDATE players SET skill_shielding=0;     - Sets the player's shield skill.
UPDATE players SET skill_shielding_tries=0; - Sets the player's shield skill.
UPDATE players SET skill_fishing=10;      - Sets the player's fishing skill.
UPDATE players SET skill_fishing_tries=0; - Sets the player's fishing skill.
UPDATE players SET prey_stamina_1=0;      - Sets players' Stamina.
UPDATE players SET prey_stamina_2=0;      - Sets players' Stamina.
UPDATE players SET prey_stamina_3=0;      - Sets players' Stamina.
UPDATE players SET prey_column=1;         - Sets column prey = 1 by default. 
UPDATE players SET xpboost_stamina=0;     - Sets the player's expboost reset.
UPDATE players SET xpboost_value=0;       - Sets the player's expboost reset.
UPDATE players SET marriage_status=0;     - Defines if the player is married.
UPDATE players SET marriage_spouse=-1;    - Defines if the player has already married.
UPDATE players SET loyalty_ranking=0;     - Sets the player's Loyalty points.
UPDATE players SET bonus_rerolls=0;       - Defines if the player has already run the prey.
UPDATE players SET critical=0;            - Resets each player's crit.
UPDATE players SET charmpoints=0;         - Resets Charmpoints.
UPDATE players SET spells=0;              - Resets the player's spells.
UPDATE players SET bestiarykills=0;       - Resets players' Bestiary.
UPDATE players SET autoloot=0;            - Resets players' autoloot. 

Here are the DELETES, that is, the commands to delete the information of the players:

DELETE FROM player_storage;            - Removes all storage
DELETE FROM player_items;              - Removes all items from players.
DELETE FROM player_depotitems;         - Removes all items from players' depot(DP).
DELETE FROM player_stash;              - Removes all items from Supply Stash
DELETE FROM player_rewards;            - Removes all rewards.
DELETE FROM player_inboxitems;         - Removes all inbox items.
DELETE FROM player_hirelings;          - Removes hirelings from houses
DELETE FROM player_deaths;             - Removes player deaths.
DELETE FROM coins_transactions;        - Removes the history of coins transactions.
DELETE FROM house_lists;               - Removes the owners of the houses.
DELETE FROM houses;                    - Remove items from houses.
DELETE FROM accounts WHERE coins > 0;  - Removes player coins. 

Credits:

• dracoalv.