+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: Episode 2 Releases (https://lckb.dev/forum/forumdisplay.php?fid=186)
+----- Forum: Server Side (https://lckb.dev/forum/forumdisplay.php?fid=143)
+----- Thread: SQL-Codes that can help (/showthread.php?tid=1691)
- Gothic - 03-19-2013
In this Thread i will add much SQL Codes for update / fix Items for help you.
##################
#Caribbean C2 Cover#
##################
####################################################
#Caribbean C2 Cover #
####################################################
# Titan
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9061;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9062;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9063;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9064;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9065;
# Knight
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9066;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9067;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9068;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9069;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9070;
# Healer
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9071;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9072;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9073;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9074;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9075;
# Mage
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9076;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9077;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9078;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9079;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9080;
# Rogue
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9081;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9082;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9083;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9084;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9085;
# Sorcerer
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9086;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9087;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9088;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9089;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9090;
# Night Shadow
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9091;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9092;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9093;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9094;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9095;
# Packs
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9096;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9097;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9098;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9099;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9100;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9101;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9102;
#################
#Russian C2 Cover #
#################
####################################################
#Russian C2 Cover #
####################################################
# Titan
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9216;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9217;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9218;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9219;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9220;
# Knight
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9221;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9222;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9223;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9224;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9225;
# Healer
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9226;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9227;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9228;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9229;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9230;
# Mage
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9231;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9232;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9233;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9234;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9235;
# Rogue
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9236;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9237;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9238;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9239;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9240;
# Sorcerer
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9241;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9242;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9243;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9244;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9245;
# Night Shadow
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9246;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9247;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9248;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9249;
UPDATE t_item SET a_num_4 = 30 WHERE a_index = 9250;
####################################################
- Janebug - 03-23-2013
2
Nice help but FYI
time is set as folllows
a_num_4 = 24 -> 1 Day
a_num_4 = 168 -> 7 Days
a_num_4 = 720 -> 30 Days
- dethunter12 - 03-23-2013
thanks very helpfull anyone know how to make the coustume have seal?