[Guide]how to make pet sql

[seraf2]

sample SQL, the id i used are sample id and might be already in use in your server

 Spoiler

delete from cq_action where id >= 727440 and id <= 728445;

insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(728440,728441,728444,508,0,'1 0 52'),
(728441,728442,0,502,(Egg ID),''),
(728442,728443,0,501,(Bag ID),''),
(728443,728445,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,(Bag ID),0,0,(Egg ID),0,0'),
(728444,0,0,126,0,'Please~make~a~space~in~your~eud emon~bags!'),
(728445,0,0,126,0,'Congratz!~You!~got~your~eudemon ~egg!');


delete from cq_itemtype where id >= (Egg ID) and id <= (Egg ID);
delete from cq_itemtype where id >= (bag ID) and id <= (Bag ID);
delete from cq_itemtype where id >= 1071120 and id <= 1071122;
delete from cq_itemtype where id >= 1079120 and id <= 1079122;

insert into cq_itemtype (id,name,monopoly,price,id_action,dodge,amount,amo unt_limit,gem1,hitrate,monster_type,able_mask,exp_ type,emoney,official1,official2,official3,official 4,official5)
values
('(Egg ID)', '(pet name)', '28', '3000000', '(Action ID)', '0000', '1', '1', '00', '00000', '(Bag ID)', '0', '0', '30000', '00', '00', '00', '00', '00'),
('(Bag ID)', '(pet name)', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071120', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071121', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071122', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071122', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079120', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079121', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079122', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079122', '7', '1', '00', '11', '21', '31', '41', '51');


delete from cq_eudemon_rbn_type where id >= 1071120 and id <= 1071122;
delete from cq_eudemon_rbn_type where id >= 1079120 and id <= 1079122;


insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071120', '0', '1', '1', '0', '0'),
('1071121', '0', '1', '1', '0', '0'),
('1071122', '0', '1', '1', '0', '0'),
('1079120', '0', '1', '1', '0', '0'),
('1079121', '0', '1', '1', '0', '0'),
('1079122', '0', '1', '1', '0', '0');


delete from cq_grade where id >= 1071120 and id <=1071122;
delete from cq_grade where id >= 1079120 and id <=1079122;

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
(1071120, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1071121, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1071122, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1079120, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0),
(1079121, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0),
(1079122, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0);

delete from cq_monstertype where id >= 71120 and id <= 71122;
delete from cq_monstertype where id >= 79120 and id <= 79122;

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
(71120, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71121, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71122, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79120, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79121, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79122, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

i know some will find that hard to understand so now ill go through each bit one by one

cq_action

ok where it writes delete from cq_action where id >= 727440 and id <= 728445; go into your database then go into cq_action then type in the id e.g. 727440-727445, if they are taken/used then search for another id like 727430-727435.

now you have your id all you do is change the id on the rest of the sql so it corresponds.

 Spoiler

(728440,728441,728444,508,0,'1 0 52'),
(728441,728442,0,502,(Egg ID),''),
(728442,728443,0,501,(Bag ID),''),
(728443,728445,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,(Bag ID),0,0,(Egg ID),0,0'),
(728444,0,0,126,0,'Please~make~a~space~in~your~eudemon~ba gs!'),
(728445,0,0,126,0,'Congratz!~You!~got~your~eudemon~egg!') ;

cq_itemtype

ok this is alot easier so just follow simple steps

 Spoiler

delete from cq_itemtype where id >= (Egg ID) and id <= (Egg ID);
delete from cq_itemtype where id >= (bag ID) and id <= (Bag ID);
delete from cq_itemtype where id >= 1071120 and id <= 1071122;
delete from cq_itemtype where id >= 1079120 and id <= 1079122;

insert into cq_itemtype (id,name,monopoly,price,id_action,dodge,amount,amo unt_limit,gem1,hitrate,monster_type,able_mask,exp_ type,emoney,official1,official2,official3,official 4,official5)
values
('(Egg ID)', '(pet name)', '28', '3000000', '(Action ID)', '0000', '1', '1', '00', '00000', '(Bag ID)', '0', '0', '30000', '00', '00', '00', '00', '00'),
('(Bag ID)', '(pet name)', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071120', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071121', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071122', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071122', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079120', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079121', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079122', '(pet name)', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079122', '7', '1', '00', '11', '21', '31', '41', '51');

• the red ID's are the pet id, they are given with pet release
• the green is the pet ID, but just without 10 in front you start with 00

cq_eudemon_rbn_type
ok the next one cq_eudemon_rbn_type is easy all you do is put in the pet id again

 Spoiler

delete from cq_eudemon_rbn_type where id >= 1071120 and id <= 1071122;
delete from cq_eudemon_rbn_type where id >=1079120 and id <= 1079122;


insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1071120', '0', '1', '1', '0', '0'),
('1071121', '0', '1', '1', '0', '0'),
('1071122', '0', '1', '1', '0', '0'),
('1079120', '0', '1', '1', '0', '0'),
('1079121', '0', '1', '1', '0', '0'),
('1079122', '0', '1', '1', '0', '0');

• red ID input your pet ID

cq_grade

 Spoiler

delete from cq_grade where id >= 1071120 and id <= 1071122;
delete from cq_grade where id >=1079120 and id <= 1079122;

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
(1071120, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1071121, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1071122, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 000, 320, 0, 2320, 0, 0),
(1079120, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0),
(1079121, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0),
(1079122, 20, 290, 1, 2000, 5000, 166, 16, 99, 21, 8320, 20800, 308, 24, 99, 26, 12480, 31200, 91, 9, 73, 36, 7200, 18000, 714, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 47, 57, 4000, 10000, 694, 50, 100, 200, 100, 320, 0, 2320, 0, 0);

• again replace the red ID for pet ID

cq_monstertype

 Spoiler

delete from cq_monstertype where id >= 71120 and id <= 71122;
delete from cq_monstertype where id >= 79120 and id <= 79122;

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
(71120, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71121, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71122, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79120, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79121, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79122, '(pet name)', 1, 566, 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, 566, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

• ok blue is the pet ID without 10 in the front
• e.g. pet ID is 1079122 then blue ID is 79122
• green is the lookface you need to change that to the pet lookface you are adding

ok i hope this guide helps, have fun on elitepvpers

[DEADP00L]

Seraf good guide but there is an easier way..excel is your friend trust me

[zspider]

nice work but you forgot to change lookface on cq_monstertype

[PraDevil[ELITE]]

just getting on people client and make sql? wtf!

[Nukleuz]

at least he tried to help

[PraDevil[ELITE]]

@nukleus: yes its help people hehe..just wait your client being stolen and u will know what i mean
@seraf2: ty for da guide..

[Nukleuz]

actually it doest matter .. we all here steal TQ/Netdragon work. did we make the c3/.dds ourself ? i dont think so.. to prevent ur client to be easily rip off.. just make whole long code for the setting so quite hard for newbie to stole it.

[funhacker]

As deadpool said excel is awesome for when making any SQL script.

But also with MySQL if you are using ALL fields within a table you do not need to name them all you have to do is write "values" after the table name for example

insert into cq_action
values
(1,2,3,120,0,'Param'),
(2,3,1,120,0,'Param'),
(3,1,2,120,0,'Param');

[seraf2]

thanks guys

about excel i dont know how to do on excel but ill love to learn.
notpad is easy as well just do ctrl H then replace ids with new ids and stuff

[DEADP00L]

seraf hit me on MsN i will teamview you and show you exactly how to use excel for what you want to do. With excel you can hit ctrl+c then paste it right into the database directly.



anyone other than Seraf adds me and i wont be a nice person

[seraf2]

bro i tryed to use excel and it is easy XD all you do is drag down codes and ctrl c XD
thanks deadpool and funhacker for the idea and small guide

[T.h.u.n.d.e.r]

guys sry about this question cuz iam still learning about that ! What about the id action thats i must put in the iteamtype.dat what i mean that how do i know it ?? also this

"[COLOR="Black"](Egg ID)', '(pet name)', '28', '3000000', '(Egg ID)', '0000', '1', '1', '00', '00000', '(Bag ID)', '0', '0', '30000', '00', '00', '00', '00', '00'),[/COLOR]"

line its mean thats the egg id is the id action while i saw in many sqls for diffrent pets thats the id action diffrent than the egg id ! cuz the proplems thats i get is from the iteamtype.dat i think its the id action point ! any idea about that =/

[seraf2]

bro im not to sure what u mean?

[zspider]

Originally Posted by seraf2

insert into cq_action (id,id_next,id_nextfail,type,data,param) 
values 
([COLOR="Red"]728440[/COLOR],728441,728444,508,0,'1 0 52'),

insert into cq_itemtype (id,name,monopoly,price,id_action,dodge,amount,amount_limit,gem1,hitrate,monster_type,able_mask,exp_type,emoney,official1,official2,official3,official4,official5) 
values
('(Egg ID)',  '(pet name)',   '28', '3000000', '[COLOR="Red"](Action ID)[/COLOR]', '0000', '1', '1', '00', '00000', '(Bag ID)', '0', '0', '30000', '00', '00', '00', '00', '00'),

he mean u must edit ur post and change it to look like this it's action ID not egg ID

[T.h.u.n.d.e.r]

thats what i mean