[Help] Can some check this query and let me no what i did wrong

08/01/2010 21:58 dominicsott2003#1
This is a query i maid for a new pet and i am trying to figure if I did it right can someone experience in this area let me no if it is right please.

HTML Code:
delete from cq_action where id >= 20000500 and id <= 20000505;

INSERT INTO `cq_action` VALUES (20000500, 20000501, 20000504, 0508, 0, '1 0 52');
INSERT INTO `cq_action` VALUES (20000501, 20000502, 0000, 0502, 729443, '');
INSERT INTO `cq_action` VALUES (20000502, 20000503, 0000, 0501, 1081120, '');
INSERT INTO `cq_action` VALUES (20000503, 20000505, 0000, 1085, 0, 'gmlog/action_log 380,%user_name[%user_id],0,0,1081120,0,0,729443,0,0');
INSERT INTO `cq_action` VALUES (20000504, 0000, 0000, 0126, 0, 'Please~make~a~space~in~your~eudemon~bags!');
INSERT INTO `cq_action` VALUES (20000505, 0000, 0000, 0126, 0, 'Congratz!~You!~got~your~eudemon~egg!');

delete from cq_itemtype where id >= 729442 and id <= 729442;
delete from cq_itemtype where id >= 1081110 and id <= 1081110;
delete from cq_itemtype where id >= 1071110 and id <= 1071112;
delete from cq_itemtype where id >= 1079110 and id <= 1079112;

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
('729442',  'DeathDragon',   '28', '0000000', '20000500', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00000', '00', '00', '00', '00', '00'),
('1081110', 'DeathDragon',   '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071110', 'DeathDragon',   '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0071690', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071111', 'DeathDragon',   '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0071691', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071112', 'DeathDragon',   '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0071692', '0', '0', '00', '00', '00', '00', '00', '00'),
('1079110', 'DeathDragon',   '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0079690', '0', '0', '00', '00', '00', '00', '00', '00'),
('1079111', 'DeathDragon',   '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0079691', '0', '0', '00', '00', '00', '00', '00', '00'),
('1079112', 'DeathDragon',   '28', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0079692', '0', '0', '00', '00', '00', '00', '00', '00');


delete from cq_eudemon_rbn_type where id >= 1071110 and id <= 1071112;
delete from cq_eudemon_rbn_type where id >= 1079110 and id <= 1079112;


insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`) 
values 
('1071110', '0', '1', '1', '0', '0'),
('1071111', '0', '1', '1', '0', '0'),
('1071112', '0', '1', '1', '0', '0'),
('1079110', '0', '1', '1', '0', '0'),
('1079111', '0', '1', '1', '0', '0'),
('1079112', '0', '1', '1', '0', '0');


delete from cq_grade where id >= 1071110 and id <=1071112;
delete from cq_grade where id >= 1079110 and id <=1079112;

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
(1071110, 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),
(1071111, 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),
(1071112, 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),
(1079110, 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),
(1079111, 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),
(1079112, 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 >= 71110 and id <= 71112;
delete from cq_monstertype where id >= 79110 and id <= 79112;

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 
(71110, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71111, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(71112, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79110, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79111, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(79112, 'DeathDragon', 1, 491, 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, 530, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 491, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
I would really appreciate it if you could
08/01/2010 23:55 C0D3R4ID3R#2
Hey bro it pretty much looks ok the only thing you have missed is the ' before and after each code

INSERT INTO `cq_action` VALUES (20000500, 20000501, 20000504, 0508, 0, '1 0 52');

works ok with

INSERT INTO `cq_action` VALUES ('20000500', '20000501', '20000504', '0508', '0', '1 0 52');

try adding ' to the whole script and see how you go

NEO[PM]
08/02/2010 02:57 dominicsott2003#3
k thanks alot
an to all the rest if these work right i add them to the flying dragon mounts for everyone
08/04/2010 10:42 seraf2#4
if u need help making sqls just check my guide its quite detailed