[GIFT]Fix the Jabberwock on Candy DB

Page 1 of 2

03/12/2010 22:52 PraDevil[ELITE]#1

here i want to release something that need to fix the candy database..Jabberwock are not avaiable to use..so here are query to fix that thing lol..please at least try to learn it..it have a connection to client..so u can search it..

Code:

delete from cq_itemtype where id >= 729413 and id <= 729414;
delete from cq_itemtype where id >= 1081880 and id <= 1081880;
delete from cq_itemtype where id >= 1081890 and id <= 1081890;
delete from cq_itemtype where id >= 1071880 and id <= 1071882;
delete from cq_itemtype where id >= 1079880 and id <= 1079882;
delete from cq_itemtype where id >= 1071890 and id <= 1071892;
delete from cq_itemtype where id >= 1079890 and id <= 1079892;

insert into cq_itemtype (id, name, req_profession, level, req_level, req_sex, req_force, req_dex, req_health, req_soul, monopoly, weight, price, id_action, attack_max, attack_min, defense, magic_atk_min, dodge, life, mana, amount, amount_limit, ident, gem1, gem2, magic1, magic2, magic3, magic_atk_max, magic_def, atk_range, atk_speed, hitrate, monster_type, target, able_mask, exp_type, emoney, official1, official2, official3, official4, official5, official6, official7, official8, official9, official10, official11, soul_value) 
values 
(729413, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 3000000, 4602580, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1081880, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1081880, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1071880, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71880, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(1071881, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71881, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(1071882, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71882, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(1079880, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79880, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(1079881, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79881, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(1079882, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79882, 0, 7, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(729414, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 3000000, 4602590, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1081890, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1081890, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1071890, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71890, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(1071891, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71891, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(1071892, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71892, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(1079890, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79890, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(1079891, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79891, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0),
(1079892, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 3000, 0, 0, 1, 1, 0, 32, 0, 0, 0, 0, 0, 0, 0, 0, 0, 79892, 0, 6, 1, 0, 11, 21, 31, 41, 51, 0, 0, 0, 0, 0, 0, 0);

delete from cq_eudemon_rbn_type where id >= 1071880 and id <= 1071882;
delete from cq_eudemon_rbn_type where id >= 1079880 and id <= 1079882;
delete from cq_eudemon_rbn_type where id >= 1071890 and id <= 1071892;
delete from cq_eudemon_rbn_type where id >= 1079890 and id <= 1079892;

insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) 
values 
(1071880,0,0,1,0,0),
(1071881,0,0,1,0,0),
(1071882,0,0,1,0,0),
(1079880,0,0,1,0,0),
(1079881,0,0,1,0,0),
(1079882,0,0,1,0,0),
(1071890,0,0,1,0,0),
(1071891,0,0,1,0,0),
(1071892,0,0,1,0,0),
(1079890,0,0,1,0,0),
(1079891,0,0,1,0,0),
(1079892,0,0,1,0,0);

delete from cq_grade where id >= 1071880 and id <=1071882;
delete from cq_grade where id >= 1079880 and id <=1079882;
delete from cq_grade where id >= 1071890 and id <=1071892;
delete from cq_grade where id >= 1079890 and id <=1079892;

insert into cq_grade (id, life_a, life_b, life_c, life_grow_a, life_grow_b, life_grow_c, phy_min_a, phy_min_b, phy_min_c, phy_min_grow_a, phy_min_grow_b, phy_min_grow_c, phy_max_a, phy_max_b, phy_max_c, phy_max_grow_a, phy_max_grow_b, phy_max_grow_c, phy_def_a, phy_def_b, phy_def_c, phy_def_grow_a, phy_def_grow_b, phy_def_grow_c, mgc_min_a, mgc_min_b, mgc_min_c, mgc_min_grow_a, mgc_min_grow_b, mgc_min_grow_c, mgc_max_a, mgc_max_b, mgc_max_c, mgc_max_grow_a, mgc_max_grow_b, mgc_max_grow_c, mgc_def_a, mgc_def_b, mgc_def_c, mgc_def_grow_a, mgc_def_grow_b, mgc_def_grow_c, luck_a, luck_b, luck_c, dmg_type, rarity, metempsychosis, reborn_limit, rbn_rqr_type, auto_trade_type) 
values
(1071880, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 0, 150, 0, 2320, 0, 0),
(1071881, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 0, 150, 0, 2320, 0, 0),
(1071882, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 0, 150, 0, 2320, 0, 0),
(1079880, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 100, 150, 0, 2320, 0, 0),
(1079881, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 100, 150, 0, 2320, 0, 0),
(1079882, 20, 290, 1, 2500, 6250, 106, 16, 95, 12, 8800, 22000, 32, 24, 99, 13, 13200, 33000, 9, 15, 99, 21, 11000, 27500, 467, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 56, 37, 5000, 12500, 355, 50, 100, 200, 100, 150, 0, 2320, 0, 0),
(1071890, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 0, 150, 0, 2320, 0, 0),
(1071891, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 0, 150, 0, 2320, 0, 0),
(1071892, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 0, 150, 0, 2320, 0, 0),
(1079890, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 100, 150, 0, 2320, 0, 0),
(1079891, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 100, 150, 0, 2320, 0, 0),
(1079892, 20, 290, 1, 2500, 6250, 53, 1, 10, 925, 1000, 2500, 8888, 2, 20, 231, 2000, 5000, 1666, 15, 99, 10, 11000, 27500, 467, 9, 66, 23, 6400, 16000, 84, 13, 99, 10, 9600, 24000, 25, 11, 56, 37, 5000, 12500, 177, 50, 100, 200, 100, 150, 0, 2320, 0, 0);

delete from cq_monstertype where id >= 71880 and id <= 71882;
delete from cq_monstertype where id >= 79880 and id <= 79882;
delete from cq_monstertype where id >= 71890 and id <= 71892;
delete from cq_monstertype where id >= 79890 and id <= 79892;

insert into cq_monstertype (id, name, type, lookface, length, fat, life, mana, attack_max, attack_min, defence, dexterity, dodge, helmet_type, armor_type, weaponr_type, weaponl_type, attack_range, view_range, escape_life, attack_speed, move_speed, level, attack_user, drop_money_min, drop_money_max, size_add, action, run_speed, drop_armet, drop_necklace, drop_armor, drop_ring, drop_weapon, drop_shield, drop_shoes, drop_money_chance, drop_item_chance, magic_type, magic_def, magic_hitrate, atk_hitrate, ai_type, defence2, explode_item_chance1, explode_item_chance2, explode_item_chance3, drop_item_rule, profession, magic1, magic2, magic3, frequency, extra_battlelev, extra_exp, extra_damage, earth_def, water_def, fire_def, wind_def, drop_egg_coe, drop_weapon_coe, drop_armet_coe, drop_armor_coe, drop_necklace_coe, drop_bracelet_coe, drop_shoes_coe, drop_stone_coe, drop_gem_coe, drop_explode_coe, drop_special_coe, special_type, drop_deltalev_coe) 
values 
(71880,'BaneJabberwock',1,880,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,880,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(71881,'BaneJabberwock',1,881,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,881,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(71882,'BaneJabberwock',1,882,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,882,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(79880,'BaneJabberwock',1,880,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,880,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(79881,'BaneJabberwock',1,881,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,881,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(79882,'BaneJabberwock',1,882,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,882,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(71890,'DreadJabberwock',1,890,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,890,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(71891,'DreadJabberwock',1,891,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,891,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(71892,'DreadJabberwock',1,892,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,892,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(79890,'DreadJabberwock',1,890,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,890,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(79891,'DreadJabberwock',1,891,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,891,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0),
(79892,'DreadJabberwock',1,892,0,0,0,0,0,0,0,0,0,0,0,0,0,3,15,0,1000,0,1,32775,0,0,3,0,0,99,99,99,99,99,99,99,50000,100000,0,0,0,75,1,10000,0,0,0,0,892,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,0);

03/12/2010 23:48 ~WARNING~#2

Thanks :D

03/12/2010 23:59 zspider#3

pradevil i think u need to give them cq_action lines too

03/13/2010 00:37 Knight^Hawk#4

here is the cq_action i dont have a query builder so ya. i would like one tho if any1 has one xD

Code:

7294130	7294131	7294134	508	0	1 0 52
7294131	7294132	0	501	1081880	
7294132	7294133	0	502	729413	
7294133	7294135	0	1085	0	gmlog/action_log 380,%user_name[%user_id],0,0,1081880,0,0,729413,0,0
7294134	0	0	126	0	Please~make~one~space~in~your~eudemon~bag~free!
7294135	0	0	126	0	Congratulations!~You~have~obtained~a~BaneJabberwock~egg!
7294140	7294141	7294144	508	0	1 0 52
7294141	7294142	0	501	1081890	
7294142	7294143	0	502	729414	
7294143	7294145	0	1085	0	gmlog/action_log 380,%user_name[%user_id],0,0,1081890,0,0,729414,0,0
7294144	0	0	126	0	Please~make~one~space~in~your~eudemon~bag~free!
7294145	0	0	126	0	Congratulations!~You~have~obtained~a~DreadJabberwock~egg!

03/13/2010 00:56 PraDevil[ELITE]#5

Quote:

Originally Posted by zspider

pradevil i think u need to give them cq_action lines too

the cq_action for this pet is ok in candy db..so we dont need to change it..

03/13/2010 01:49 zspider#6

Quote:

Originally Posted by PraDevil

the cq_action for this pet is ok in candy db..so we dont need to change it..

maybe in yours coz i searched for the id in candy DB Cq_action but i didn't find it

03/13/2010 01:51 zspider#7

Quote:

Originally Posted by Knight^Hawk

here is the cq_action i dont have a query builder so ya. i would like one tho if any1 has one xD

Code:

7294130	7294131	7294134	508	0	1 0 52
7294131	7294132	0	501	1081880	
7294132	7294133	0	502	729413	
7294133	7294135	0	1085	0	gmlog/action_log 380,%user_name[%user_id],0,0,1081880,0,0,729413,0,0
7294134	0	0	126	0	Please~make~one~space~in~your~eudemon~bag~free!
7294135	0	0	126	0	Congratulations!~You~have~obtained~a~BaneJabberwock~egg!
7294140	7294141	7294144	508	0	1 0 52
7294141	7294142	0	501	1081890	
7294142	7294143	0	502	729414	
7294143	7294145	0	1085	0	gmlog/action_log 380,%user_name[%user_id],0,0,1081890,0,0,729414,0,0
7294144	0	0	126	0	Please~make~one~space~in~your~eudemon~bag~free!
7294145	0	0	126	0	Congratulations!~You~have~obtained~a~DreadJabberwock~egg!

NO one use this with pradevil Release if u do u will get the same problem no thing will fix

EDIT : Sorry for double posts

03/13/2010 02:37 Knight^Hawk#8

works for my server lol

03/13/2010 03:23 King_Arthur#9

Quote:

Originally Posted by Knight^Hawk

here is the cq_action i dont have a query builder so ya. i would like one tho if any1 has one xD

Code:

7294130	7294131	7294134	508	0	1 0 52
7294131	7294132	0	501	1081880	
7294132	7294133	0	502	729413	
7294133	7294135	0	1085	0	gmlog/action_log 380,%user_name[%user_id],0,0,1081880,0,0,729413,0,0
7294134	0	0	126	0	Please~make~one~space~in~your~eudemon~bag~free!
7294135	0	0	126	0	Congratulations!~You~have~obtained~a~BaneJabberwock~egg!
7294140	7294141	7294144	508	0	1 0 52
7294141	7294142	0	501	1081890	
7294142	7294143	0	502	729414	
7294143	7294145	0	1085	0	gmlog/action_log 380,%user_name[%user_id],0,0,1081890,0,0,729414,0,0
7294144	0	0	126	0	Please~make~one~space~in~your~eudemon~bag~free!
7294145	0	0	126	0	Congratulations!~You~have~obtained~a~DreadJabberwock~egg!

Query-fied:

Code:

delete from cq_action where id >= 7294130 and id <= 7294145;

insert into cq_action values
(7294130,7294131,7294134,508,0,'1 0 52'),
(7294131,7294132,0,501,1081880,''),
(7294132,7294133,0,502,729413,''),
(7294133,7294135,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081880,0,0,729413,0,0'),
(7294134,0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
(7294135,0,0,126,0,'Congratulations!~You~have~obtained~a~BaneJabberwock~egg!'),
(7294140,7294141,7294144,508,0,'1 0 52'),
(7294141,7294142,0,501,1081890,''),
(7294142,7294143,0,502,729414,''),
(7294143,7294145,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081890,0,0,729414,0,0'),
(7294144,0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
(7294145,0,0,126,0,'Congratulations!~You~have~obtained~a~DreadJabberwock~egg!');

03/13/2010 03:53 zspider#10

lol guys the red id that what i mean :)

Quote:

Originally Posted by PraDevil

Code:

(729413, 'BaneJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 3000000, [COLOR="Red"]4602580[/COLOR], 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1081880, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(729414, 'DreadJabberwock', 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 3000000, [COLOR="Red"]4602590[/COLOR], 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1081890, 0, 0, 0, 29, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),

Quote:

Originally Posted by King_Arthur

Query-fied:

Code:

delete from cq_action where id >= [COLOR="Red"]7294130[/COLOR] and id <= [COLOR="Red"]7294145[/COLOR];

insert into cq_action values
([COLOR="Red"]7294130[/COLOR],7294131,7294134,508,0,'1 0 52'),
(7294131,7294132,0,501,1081880,''),
(7294132,7294133,0,502,729413,''),
(7294133,7294135,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081880,0,0,729413,0,0'),
(7294134,0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
(7294135,0,0,126,0,'Congratulations!~You~have~obtained~a~BaneJabberwock~egg!'),
([COLOR="Red"]7294140[/COLOR],7294141,7294144,508,0,'1 0 52'),
(7294141,7294142,0,501,1081890,''),
(7294142,7294143,0,502,729414,''),
(7294143,7294145,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081890,0,0,729414,0,0'),
(7294144,0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
(7294145,0,0,126,0,'Congratulations!~You~have~obtained~a~DreadJabberwock~egg!');

03/13/2010 04:04 King_Arthur#11

Quote:

Originally Posted by zspider

lol guys the red id that what i mean :)

Didn't really look over the other stuff sorry :o

Condensed and corrected cq_itemtype:

Code:

delete from cq_itemtype where id = 729413 or id = 729414;

insert into cq_itemtype 
(id,name,monopoly,price,id_action,amount,amount_limit,monster_type,emoney)
values
(729413,'BaneJabberwock',28,3000000,7294130,1,1,1081880,29),
(729414,'DreadJabberwock',28,3000000,7294140,1,1,1081890,29);

03/13/2010 05:27 PraDevil[ELITE]#12

King_Arthur..:) i think better put a long query so other people can easily learn it by looking the cq_itemtype column..hehe..anyways..that can be use too..thanks..

03/13/2010 06:10 King_Arthur#13

Quote:

Originally Posted by PraDevil

King_Arthur..:) i think better put a long query so other people can easily learn it by looking the cq_itemtype column..hehe..anyways..that can be use too..thanks..

All I did was adapt your cq_itemtype on these two items for the cq_action posted later in the thread. I did not suggest in any way that you should change your queries to look like mine. I simply showed what was changed in this query instead of showing all the things you don't have to change for this item.

03/13/2010 12:36 zspider#14

Quote:
Originally Posted by King_Arthur
Didn't really look over the other stuff sorry :o

Condensed and corrected cq_itemtype:
Code:
delete from cq_itemtype where id = 729413 or id = 729414;

insert into cq_itemtype 
(id,name,monopoly,price,id_action,amount,amount_limit,monster_type,emoney)
values
(729413,'BaneJabberwock',28,3000000,7294130,1,1,1081880,29),
(729414,'DreadJabberwock',28,3000000,7294140,1,1,1081890,29);

lol bro it's nothing i just show them some thing no more

03/14/2010 11:46 Saraiyu#15

All y'all hating so much on somebody who is only trying to help, you know, PraDevil could have not bothered releasing this fix at all, instead of criticizing all the faults, how about thanking the poster, and praising the positive portions of the script? What is with you people and your negative seeking? your negative comments are why people sit on helpful scripts, because nobody wants to release a helpful script if they get flamed for it!

PraDevil, keep up the good work, pm me if you can help fix the flowers/3xp pot.... Thanks for the awesome Jabber fix!

Page 1 of 2