• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[SQL] Config for sql (Help)

krille09

Belden
Joined
Aug 15, 2007
Messages
4,894
Reaction score
55
Location
Stockholm, Sweden
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?
 
Back
Top