UPDATE `players`
SET
`health` = 185,
`healthmax` = 185,
`mana` = 90,
`manamax` = 90,
`cap` = 470,
`level` = 8,
`experience` = 4200,
`maglevel` = 30,
`soul` = 100,
`manaspent` = 0,
`lookaddons` = 0,
`posx` = 0,
`posy` = 0,
`posz` = 0,
`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`= 5 OR `vocation`= 2 OR `vocation`= 6;
UPDATE `players`
SET
`health` = 185,
`healthmax` = 185,
`mana` = 35,
`manamax` = 35,
`cap` = 470,
`level` = 8,
`experience` = 4200,
`maglevel` = 5,
`soul` = 100,
`manaspent` = 0,
`lookaddons` = 0,
`posx` = 0,
`posy` = 0,
`posz` = 0,
`conditions` = '',
`skull` = 0,
`skulltime` = 0,
`blessings` = 0,
`stamina` = 2520,
`skill_fist` = 10,
`skill_club` = 10,
`skill_sword` = 10,
`skill_axe` = 10,
`skill_dist` = 30,
`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`= 7;
UPDATE `players`
SET
`health` = 185,
`healthmax` = 185,
`mana` = 35,
`manamax` = 35,
`cap` = 470,
`level` = 8,
`experience` = 4200,
`maglevel` = 2,
`soul` = 100,
`manaspent` = 0,
`lookaddons` = 0,
`posx` = 0,
`posy` = 0,
`posz` = 0,
`conditions` = '',
`skull` = 0,
`skulltime` = 0,
`blessings` = 0,
`stamina` = 2520,
`skill_fist` = 10,
`skill_club` = 30,
`skill_sword` = 30,
`skill_axe` = 30,
`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` = 4 OR `vocation`= 8;
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`;