krille09
Belden
Code:
# --- SQL QUERIES
# --- SETUP CONFIG
SET @lvl = 8;
SET @positionx = 1000;
SET @positiony = 1000;
SET @positionz = 7;
# --- END CONFIG
# --- DO NOT TOUCH
UPDATE `players` SET `posx` = @positionx, `posy` = @positiony, `posz` = @positionz;
UPDATE `players` /* Sorcerers and Druids */
SET `health` = @lvl * 5 + 145, `healthmax` = @lvl * 5 + 145, mana = @lvl * 30 - 205, manamax = @lvl * 30 - 205
WHERE `vocation` = "1" OR `vocation` = "5" OR `vocation` = "2" OR `vocation` = "6";
UPDATE `players` /* Paladins */
SET `health` = @lvl * 10 + 105, `healthmax` = @lvl * 10 + 105, mana = @lvl * 15 - 85, manamax = @lvl * 15 - 85
WHERE `vocation` = "3" OR `vocation` = "7";
UPDATE `players` /* Knights */
SET `health` = @lvl * 15 + 65, `healthmax` = @lvl * 15 + 65, mana = @lvl * 5 - 5, manamax = @lvl * 5 - 5
WHERE `vocation` = "4" OR `vocation` = "8";
# --- Credits
/* krille09 for config */
/* chojrak for Temple Updater */
/* Pyromental for Sorcerer, Druid, Paladin and Knight updater */
I'm trying to fix this, but would this work?