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`;