ill make u ur server for free

CyberServer · 06/18/2010, 10:37

really nice to have u as a helper here :P

~Sword~Stalker~. · 06/18/2010, 16:05

thank you Sord for making my server but am i really have to open the Account server , msg server & NPC server 24/7 ?? lol

drukkie · 06/18/2010, 18:38

Quote:

Originally Posted by 22663934

thank you Sord for making my server but am i really have to open the Account server , msg server & NPC server 24/7 ?? lol

if you dont leave that open your server will not be online

so what ever you want it to be online you leave the things on

~~~Sword~Stalker~[PM]~~ · 06/18/2010, 18:49

ya drukkie good work , lol

drukkie · 06/18/2010, 19:24

Quote:

Originally Posted by ~Sword~Stalker~[PM]

ya drukkie good work , lol

lol... that wasnt so hard to know... other questions i cant awnser:P

seraf2 · 06/18/2010, 20:35

sword i need help putting in new pets i mean i need to learn how to put into item dat and make a sql of it

~~~Sword~Stalker~[PM]~~ · 06/18/2010, 22:37

most of the times u find the sql files with the pet u add

to add pets and mounts[ ill put it here after 10 min.

seraf2 · 06/19/2010, 16:01

bro i now added fish and stuff but when i summon i cant see my pets and also egg is invisable

bro can u make a sql for

thanks

~~~Sword~Stalker~[PM]~~ · 06/19/2010, 17:23

pets and eggs are invisible cuz u didnt make there shape lol

~~~Sword~Stalker~[PM]~~ · 06/19/2010, 17:39

Code:

delete from cq_action where id >= 7295390 and id <= 7295395;

insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(7295390,7295391,7295394,508,0,'1 0 52'),
(7295391,7295392,0,502,729434,''),
(7295392,7295393,0,501,1081600,''),
(7295393,7295395,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081600,0,0,729434,0,0'),
(7295394,0,0,126,0,'Please~make~one~space~in~your~ eudemon~bag~free!'),
(7295395,0,0,126,0,'Congratulations!~You~have~obta ined~an~Virgo~egg!');


delete from cq_action where id >= 7295490 and id <= 7295495;

insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(7295490,7295491,7295494,508,0,'1 0 52'),
(7295491,7295492,0,502,729435,''),
(7295492,7295493,0,501,1081610,''),
(7295493,7295495,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081610,0,0,729435,0,0'),
(7295494,0,0,126,0,'Please~make~one~space~in~your~ eudemon~bag~free!'),
(7295495,0,0,126,0,'Congratulations!~You~have~obta ined~an~Virgin~egg!');



delete from cq_eudemon_rbn_type where id >= 1071600 and id <= 1071612;
delete from cq_eudemon_rbn_type where id >= 1079600 and id <= 1079612;

INSERT INTO `cq_eudemon_rbn_type` (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) VALUES
(1071600, 1, 1, 1, 1, 1),
(1071601, 1, 1, 1, 1, 1),
(1071602, 1, 1, 1, 1, 1),
(1079600, 1, 1, 1, 1, 1),
(1079601, 1, 1, 1, 1, 1),
(1079602, 1, 1, 1, 1, 1);

INSERT INTO `cq_eudemon_rbn_type` (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) VALUES
(1071610, 1, 1, 1, 1, 1),
(1071611, 1, 1, 1, 1, 1),
(1071612, 1, 1, 1, 1, 1),
(1079610, 1, 1, 1, 1, 1),
(1079611, 1, 1, 1, 1, 1),
(1079612, 1, 1, 1, 1, 1);







delete from cq_itemtype where id >= 729434 and id <= 729434;
delete from cq_itemtype where id >= 1081600 and id <= 1081600;
delete from cq_itemtype where id >= 1071600 and id <= 1071602;
delete from cq_itemtype where id >= 1079600 and id <= 1079602;

insert into cq_itemtype (id,name,monopoly,price,id_action,attack_max,attac k_min,defense,dodge,life,gem1,magic_def,atk_range, hitrate,monster_type,able_mask,exp_type, emoney,official2)
values
(729434,'Sagittarius BlizzardBag',28,0,7295390,0,0,0,0,0,0,0 ,0,0,1081600,0,0,22000000,0),
(1081600,'Sagittarius Blizzard',4,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0),
(1071600,'Sagittarius Blizzard',0,250,0,0,0,0,0,0,32,0,1,900 0,71600,7,1,0,21),
(1071601,'Sagittarius Blizzard',0,250,0,0,0,0,0,0,32,0,1,900 0,71601,7,1,0,21),
(1071602,'Sagittarius Blizzard',0,250,0,0,0,0,0,0,32,0,1,900 0,71602,7,1,0,21),
(1079600,'Sagittarius Blizzard',0,250,0,0,0,0,0,0,32,0,1,900 0,79600,7,1,0,21),
(1079601,'Sagittarius Blizzard',0,250,0,0,0,0,0,0,32,0,1,900 0,79601,7,1,0,21),
(1079602,'Sagittarius Blizzard',0,250,0,0,0,0,0,0,32,0,1,900 0,79602,7,1,0,21);


delete from cq_itemtype where id >= 729435 and id <= 729435;
delete from cq_itemtype where id >= 1081610 and id <= 1081610;
delete from cq_itemtype where id >= 1071610 and id <= 1071612;
delete from cq_itemtype where id >= 1079610 and id <= 1079612;

insert into cq_itemtype (id,name,monopoly,price,id_action,attack_max,attac k_min,defense,dodge,life,gem1,magic_def,atk_range, hitrate,monster_type,able_mask,exp_type, emoney,official2)
values
(729435,'Sagittarius BlizzardBag',28,0,7295490,0,0,0,0,0,0, 0,0,0,1081610,0,0,22000000,0),
(1081610,'Sagittarius BlizzardEgg',4,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0),
(1071610,'Sagittarius Blizzard',0,250,0,0,0,0,0,0,32,0,1,90 00,71610,7,1,0,21),
(1071611,'Sagittarius Blizzard',0,250,0,0,0,0,0,0,32,0,1,90 00,71611,7,1,0,21),
(1071612,'Sagittarius Blizzard',0,250,0,0,0,0,0,0,32,0,1,90 00,71612,7,1,0,21),
(1079610,'Sagittarius Thunder',0,250,0,0,0,0,0,0,32,0,1,90 00,79610,7,1,0,21),
(1079611,'Sagittariu  Thunder',0,250,0,0,0,0,0,0,32,0,1,90 00,79611,7,1,0,21),
(1079612,'Sagittarius Thunder',0,250,0,0,0,0,0,0,32,0,1,90 00,79612,7,1,0,21);


delete from cq_monstertype where id >= 71600 and id <= 71602;
delete from cq_monstertype where id >= 79600 and id <= 79602;

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

(71600, 'Sagittarius Thunder', 0001, 0940, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 940, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71601, 'Sagittarius Blizzard', 0001, 0941, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 941, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71602, 'Sagittarius thunder', 0001, 0942, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 942, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79600, 'Sagittarius Blizzard', 0001, 0940, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 940, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79601, 'Sagittarius Blizzard', 0001, 0941, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 941, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79602, 'Sagittarius thunder', 0001, 0942, 0, 100, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0003, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0002, 10000, 0000, 0000, 0000, 0000, 942, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);


delete from cq_monstertype where id >= 71610 and id <= 71612;
delete from cq_monstertype where id >= 79610 and id <= 79612;

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
(71610, 'VirginBeast', 0001, 0945, 0, 0, 00, 00, 0000, 0001, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0000, 32774, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 945, 0000000000, 0000000001, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71611, 'VirginBeast', 0001, 0946, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 946, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71612, 'VirginBeast', 0001, 0947, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 947, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79610, 'VirginBeast', 0001, 0945, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 945, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79611, 'VirginBeast', 0001, 0946, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 946, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79612, 'VirginBeast', 0001, 0947, 0, 0, 00, 00, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0007, 0015, 0000, 1000, 0000, 0001, 32775, 1000, 0000, 0007, 0000, 0000, 099, 099, 099, 099, 099, 099, 099, 0000, 0000, 5000, 0000, 0075, 0075, 0001, 10000, 0000, 0000, 0000, 0000, 947, 0000000000, 0000000000, 0000000000, 0000000000, 0, 0, 0, 0, 0, 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);






delete from cq_grade where id >= 1071600 and id <=1071602;
delete from cq_grade where id >= 1079600 and id <=1079602;

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
(1071600, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1071601, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1071602, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),

(1079600, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1079601, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1079602, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0);



delete from cq_grade where id >= 1071610 and id <=1071612;
delete from cq_grade where id >= 1079610 and id <=1079612;

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
(1071610, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1071611, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1071612, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),

(1079610, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1079611, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0),
(1079612, 20, 367, 1, 2900, 7250, 93, 2, 20, 231, 4000, 8000, 877, 3, 30, 102, 7000, 19500, 223, 9, 99, 64, 7000, 17000, 350, 11, 86, 13, 6400, 17000, 424, 17, 99, 11, 8600, 27500, 155, 11, 56, 37, 6000, 15500, 197, 50, 131, 200, 0, 500, 0, 99999, 1, 0);



delete from cq_dyna_rank_type where id >= 1160010 and id <=1160040;
delete from cq_dyna_rank_type where id >= 2160010 and id <=2160040;

insert into cq_dyna_rank_type (type,rank_number)
values
(1160010,120),
(1160011,120),
(1160012,120),
(1160013,120),
(1160014,120),
(1160015,120),
(1160016,120),
(1160020,120),
(1160021,120),
(1160022,120),
(1160023,120),
(1160024,120),
(1160025,120),
(1160026,120),
(1160040,120),
(2160010,120),
(2160011,120),
(2160012,120),
(2160013,120),
(2160014,120),
(2160015,120),
(2160016,120),
(2160020,120),
(2160021,120),
(2160022,120),
(2160023,120),
(2160024,120),
(2160025,120),
(2160026,120),
(2160040,120);


delete from cq_dyna_rank_type where id >= 1161010 and id <=1161040;
delete from cq_dyna_rank_type where id >= 2161010 and id <=2161040;

insert into cq_dyna_rank_type (type,rank_number)
values
(1161010,120),
(1161011,120),
(1161012,120),
(1161013,120),
(1161014,120),
(1161015,120),
(1161016,120),
(1161020,120),
(1161021,120),
(1161022,120),
(1161023,120),
(1161024,120),
(1161025,120),
(1161026,120),
(1161040,120),
(2161010,120),
(2161011,120),
(2161012,120),
(2161013,120),
(2161014,120),
(2161015,120),
(2161016,120),
(2161020,120),
(2161021,120),
(2161022,120),
(2161023,120),
(2161024,120),
(2161025,120),
(2161026,120),
(2161040,120);

im not sure of that this sql file will work i made it fast but try it

ChaoseOnline · 06/20/2010, 07:13

ok i dont know if your too buissy for this but i only have a couple of things i need done i know alot about this server stuff but not on some parts What do you use for a Messenger yahoo or MSN. My server isent going to be out for at least another month so i got all the time i need. Just need a Messanger Email. I was also wondering if your could answer some questions so i can learn more about the data base. thank you and have a nice day. BTW my MSN is

it would be the same for my Yahoo Messanger.

~~~Sword~Stalker~[PM]~~ · 06/20/2010, 12:32

im sorry but i just answer questions on hamashi ArabUnionGames from Null - 10

i dont add e-mail

and sure ill help u ^^

ChaoseOnline · 06/20/2010, 19:46

well this is what i need help with. i need help with editing teleporters. like i want to take old market and replace lost land in the teleporter i dont know where to go for it. and for some reson in revilustion eo client the old market isent in cq_map. and was wondering if i have to throw the old market into cq_map. where do i go to take out the ep cards my server is going to be different so i dont want the ep cards and bags in the server. is there a way to put the stacks of clovers and stacks of unios in the ep shop. the only thing i want someone to do for me is replacing some of the pets with new pets that i just got. i think thats about it.

~~~Sword~Stalker~[PM]~~ · 06/21/2010, 15:07

W0W u have lots of questions

*** help u with them

XxRealTheWarxX · 06/21/2010, 15:46

i dont know u can help or not .. but i need all help ..

i mean .. from the start after downloading until its finish ..

i just dont understand english much