TFS 1.X+ Reset accounts and characters with SQL Query

[TMS]

Hi OtLand!

Is there any way or query(ies) to reset all the characters in the database?
I want to reset the accounts of my server, but I don't want to delete the characters, I only want them to start at level 8 again with default skills and everything fresh new. Obviously clearing storages, player inventory, houses, depots, tiles, etc! (I tried some query to reset all characters to level 8 but mana and hp points for each vocation varies, so I got into a problem there).

Somebody knows a way and is willing to help me out? (i've found many related threads but they seem outdated!)
Thanks!!!

 

[Evil Puncker]

but mana and hp points for each vocation varies

shouldn't a lvl 8 all have same values despite the vocation?

lvl 8
hp 185
mana 90 (or 40 if you want old values)
cap 470

ignore my post if your server have custom vocations lol

 

[Error 502]

Hi OtLand!

Is there any way or query(ies) to reset all the characters in the database?
I want to reset the accounts of my server, but I don't want to delete the characters, I only want them to start at level 8 again with default skills and everything fresh new. Obviously clearing storages, player inventory, houses, depots, tiles, etc! (I tried some query to reset all characters to level 8 but mana and hp points for each vocation varies, so I got into a problem there).

Somebody knows a way and is willing to help me out? (i've found many related threads but they seem outdated!)
Thanks!!!

UPDATE `players`
SET
`health` = 250,
`healthmax` = 250,
`mana` =  250,
`manamax` = 250,
`cap` = 250,
`level` = 2,
`experience` = 101,
`looktype` = 2,
`vocation` = 1,
`maglevel` = 115,
`soul` = 100,
`manaspent` = 0,
`lookaddons` = 0,
`posx` = 305,
`posy` = 50,
`posz` = 5,
`conditions` = '',
`skull` = 0,
`skulltime` = 0,
`blessings` = 0,
`stamina` = 2520,
`skill_fist` = 10,
`skill_club` = 10,
`skill_sword` = 10,
`skill_axe` = 10,
`skill_dist` = 10,
`skill_shielding` = 10,
`skill_fishing` = 10,
`skill_fist_tries` = 0,
`skill_club_tries` = 0,
`skill_sword_tries` = 0,
`skill_axe_tries` = 0,
`skill_dist_tries` = 0,
`skill_shielding_tries` = 0,
`skill_fishing_tries` = 0,
`lastlogin` = 0
WHERE `vocation` = 1 OR `vocation` = 52 OR `vocation` = 53 OR `vocation` = 54 OR `vocation` = 55 OR `vocation` = 56 OR `vocation` = 57 OR `vocation` = 58 OR `vocation` = 59 OR `vocation` = 60 OR `vocation` = 61 OR `vocation` = 62 OR `vocation` = 547 OR `vocation` = 548 OR `vocation` = 549 OR `vocation` = 550 OR `vocation` = 551 OR `vocation` = 552 OR `vocation` = 553;
UPDATE `players`
SET
`health` = 250,
`healthmax` = 250,
`mana` =  250,
`manamax` = 250,
`cap` = 250,
`level` = 2,
`experience` = 101,
`looktype` = 22,
`vocation` = 3,
`maglevel` = 115,
`soul` = 100,
`manaspent` = 0,
`lookaddons` = 0,
`posx` = 305,
`posy` = 50,
`posz` = 5,
`conditions` = '',
`skull` = 0,
`skulltime` = 0,
`blessings` = 0,
`stamina` = 2520,
`skill_fist` = 10,
`skill_club` = 10,
`skill_sword` = 10,
`skill_axe` = 10,
`skill_dist` = 10,
`skill_shielding` = 10,
`skill_fishing` = 10,
`skill_fist_tries` = 0,
`skill_club_tries` = 0,
`skill_sword_tries` = 0,
`skill_axe_tries` = 0,
`skill_dist_tries` = 0,
`skill_shielding_tries` = 0,
`skill_fishing_tries` = 0,
`lastlogin` = 0
WHERE `vocation` = 3 OR `vocation` = 63 OR `vocation` = 64 OR `vocation` = 65 OR `vocation` = 66 OR `vocation` = 67 OR `vocation` = 68 OR `vocation` = 69 OR `vocation` = 70 OR `vocation` = 71 OR `vocation` = 72 OR `vocation` = 73 OR `vocation` = 554 OR `vocation` = 555 OR `vocation` = 556 OR `vocation` = 557 OR `vocation` = 558 OR `vocation` = 559 OR `vocation` = 560;

UPDATE `accounts` SET `premium_points` = 0;
UPDATE `accounts` SET `premium_ends_at` = 0;
DELETE FROM `player_depotlockeritems`;
DELETE FROM `account_ban_history`;
DELETE FROM `account_bans`;
DELETE FROM `house_lists`;
DELETE FROM `houses`;
DELETE FROM `market_history`;
DELETE FROM `market_offers`;
DELETE FROM `player_deaths`;
DELETE FROM `player_depotitems`;
DELETE FROM `player_inboxitems`;
DELETE FROM `player_items`;
DELETE FROM `player_spells`;
DELETE FROM `player_storage`;
DELETE FROM `players_online`;
DELETE FROM `tile_store`;