Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Eudemons Online > EO PServer Hosting
You last visited: Today at 10:33

  • Please register to post and access all features, it's quick, easy and FREE!

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.

Closed Thread
 
Old   #1
 
PraDevil[ELITE]'s Avatar
 
elite*gold: 0
Join Date: Nov 2009
Posts: 1,490
Received Thanks: 909
[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);
PraDevil[ELITE] is offline  
Thanks
11 Users
Old 03/12/2010, 23:48   #2
 
~WARNING~'s Avatar
 
elite*gold: 5
Join Date: Feb 2010
Posts: 1,040
Received Thanks: 441
Thanks
~WARNING~ is offline  
Old 03/12/2010, 23:59   #3
 
zspider's Avatar
 
elite*gold: 0
Join Date: Sep 2009
Posts: 416
Received Thanks: 131
pradevil i think u need to give them cq_action lines too
zspider is offline  
Old 03/13/2010, 00:37   #4
 
elite*gold: 0
Join Date: Dec 2009
Posts: 375
Received Thanks: 146
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!
Knight^Hawk is offline  
Old 03/13/2010, 00:56   #5
 
PraDevil[ELITE]'s Avatar
 
elite*gold: 0
Join Date: Nov 2009
Posts: 1,490
Received Thanks: 909
Quote:
Originally Posted by zspider View Post
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..
PraDevil[ELITE] is offline  
Thanks
1 User
Old 03/13/2010, 01:49   #6
 
zspider's Avatar
 
elite*gold: 0
Join Date: Sep 2009
Posts: 416
Received Thanks: 131
Quote:
Originally Posted by PraDevil View Post
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
zspider is offline  
Old 03/13/2010, 01:51   #7
 
zspider's Avatar
 
elite*gold: 0
Join Date: Sep 2009
Posts: 416
Received Thanks: 131
Quote:
Originally Posted by Knight^Hawk View Post
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
zspider is offline  
Old 03/13/2010, 02:37   #8
 
elite*gold: 0
Join Date: Dec 2009
Posts: 375
Received Thanks: 146
works for my server lol
Knight^Hawk is offline  
Old 03/13/2010, 03:23   #9
 
King_Arthur's Avatar
 
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 895
Quote:
Originally Posted by Knight^Hawk View Post
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!');
King_Arthur is offline  
Thanks
3 Users
Old 03/13/2010, 03:53   #10
 
zspider's Avatar
 
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 View Post
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 View Post
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!');
zspider is offline  
Old 03/13/2010, 04:04   #11
 
King_Arthur's Avatar
 
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 895
Quote:
Originally Posted by zspider View Post
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);
King_Arthur is offline  
Old 03/13/2010, 05:27   #12
 
PraDevil[ELITE]'s Avatar
 
elite*gold: 0
Join Date: Nov 2009
Posts: 1,490
Received Thanks: 909
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..
PraDevil[ELITE] is offline  
Thanks
1 User
Old 03/13/2010, 06:10   #13
 
King_Arthur's Avatar
 
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 895
Quote:
Originally Posted by PraDevil View Post
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.
King_Arthur is offline  
Old 03/13/2010, 12:36   #14
 
zspider's Avatar
 
elite*gold: 0
Join Date: Sep 2009
Posts: 416
Received Thanks: 131
Quote:
Originally Posted by King_Arthur View Post
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
zspider is offline  
Old 03/14/2010, 11:46   #15
 
Saraiyu's Avatar
 
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!


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


Similar Threads Similar Threads
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 +1. The time now is 10:33.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.