You last visited: Today at 00:22
Advertisement
[GIFT]Fix the Jabberwock on Candy DB
Discussion on [GIFT]Fix the Jabberwock on Candy DB within the EO PServer Hosting forum part of the Eudemons Online category.
03/12/2010, 22:52
#1
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
[GIFT]Fix the Jabberwock on Candy DB
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
#2
elite*gold: 5
Join Date: Feb 2010
Posts: 1,040
Received Thanks: 442
Thanks
03/12/2010, 23:59
#3
elite*gold: 0
Join Date: Sep 2009
Posts: 416
Received Thanks: 131
pradevil i think u need to give them cq_action lines too
03/13/2010, 00:37
#4
elite*gold: 0
Join Date: Dec 2009
Posts: 375
Received Thanks: 149
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
#5
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
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
#6
elite*gold: 0
Join Date: Sep 2009
Posts: 416
Received Thanks: 131
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
#7
elite*gold: 0
Join Date: Sep 2009
Posts: 416
Received Thanks: 131
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
#8
elite*gold: 0
Join Date: Dec 2009
Posts: 375
Received Thanks: 149
works for my server lol
03/13/2010, 03:23
#9
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 896
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
#10
elite*gold: 0
Join Date: Sep 2009
Posts: 416
Received Thanks: 131
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
#11
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 896
Quote:
Originally Posted by
zspider
lol guys the red id that what i mean
Didn't really look over the other stuff sorry
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
#12
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
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
#13
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 896
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
#14
elite*gold: 0
Join Date: Sep 2009
Posts: 416
Received Thanks: 131
Quote:
Originally Posted by
King_Arthur
Didn't really look over the other stuff sorry
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
#15
elite*gold: 0
Join Date: Sep 2009
Posts: 29
Received Thanks: 3
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!
How can u change Welcome to candy or Eo
05/17/2010 - EO PServer Hosting - 6 Replies
Easy go To gile stReS in the ini file
change it to what u want
congz
Candy db HELP
03/01/2010 - EO PServer Hosting - 25 Replies
i recently downloaded the candy db set everything up and the msg server wont connect to the account server. acct server loads up just fine.
its got my and account databases
msg errors
connect to account server again
[HELP] Doubts candy Db
02/23/2010 - EO PServer Hosting - 1 Replies
How do I configure Candy Db to other people besides logarem GM
He is locked and so the GM can log on to serve not know in what setting I have mecher to change it if someone can tell me thank
Need Team Eo Candy
02/01/2009 - EO PServer Hosting - 1 Replies
hello
i need PM can fix big and make patch and can do AutoPatch work and need 2 GM work in Live Support
http://eocandy.com/
to Contact
[email protected]
or Send Message to [email protected]
how to add new gift and modify the gift appear chance
07/03/2008 - EO PServer Hosting - 3 Replies
now i will show you how to add a new gift in you db and the cilent
first you need to add a new line in cq_talenttype like this
53 3 TownGift 0 0 0 1 1 0 0 0 0 1000 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1000 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1
190 190 Potency+1 0 0 2 1 1 0 0 1 0 1000 65530 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
191 190 Potency+2 0 0 2 1 1 0 0 2 0 1000 65530 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0...
All times are GMT +2. The time now is 00:24 .
![[GIFT]Fix the Jabberwock on Candy DB](https://www.elitepvpers.com/forum/iconimages/eo-pserver-hosting/gift-fix-jabberwock-candy-db_ltr.gif){kind=small}
![PraDevil[ELITE]'s Avatar](https://www.elitepvpers.com/forum/customavatars/avatar1857785_25.gif){kind=avatar}
![PraDevil[ELITE] is offline](images/elitepvpers/statusicon/user_offline.gif){kind=small}
