ill make u ur server for free

06/18/2010 10:37 CyberServer#16
really nice to have u as a helper here :P
06/18/2010 16:05 ~Sword~Stalker~.#17
thank you Sord for making my server but am i really have to open the Account server , msg server & NPC server 24/7 ?? lol
06/18/2010 18:38 drukkie#18
Quote:
Originally Posted by 22663934 View Post
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 :D
so what ever you want it to be online you leave the things on:)
06/18/2010 18:49 ~Sword~Stalker~[PM]#19
ya drukkie good work , lol
06/18/2010 19:24 drukkie#20
Quote:
Originally Posted by ~Sword~Stalker~[PM] View Post
ya drukkie good work , lol
lol... that wasnt so hard to know... other questions i cant awnser:P
06/18/2010 20:35 seraf2#21
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
06/18/2010 22:37 ~Sword~Stalker~[PM]#22
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. :)
06/19/2010 16:01 seraf2#23
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 [Only registered and activated users can see links. Click Here To Register...]

thanks
06/19/2010 17:23 ~Sword~Stalker~[PM]#24
pets and eggs are invisible cuz u didnt make there shape lol
06/19/2010 17:39 ~Sword~Stalker~[PM]#25
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
06/20/2010 07:13 ChaoseOnline#26
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 [Only registered and activated users can see links. Click Here To Register...] it would be the same for my Yahoo Messanger.
06/20/2010 12:32 ~Sword~Stalker~[PM]#27
im sorry but i just answer questions on hamashi ArabUnionGames from Null - 10

i dont add e-mail

and sure ill help u ^^
06/20/2010 19:46 ChaoseOnline#28
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.
06/21/2010 15:07 ~Sword~Stalker~[PM]#29
W0W u have lots of questions :D god help u with them :)
06/21/2010 15:46 XxRealTheWarxX#30
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