[help]sql err

04/18/2011 03:13 wolfvb#1
i have err in the sql i make are any one know why
the sql in attach files can any one help me
:(:(:(
04/18/2011 03:22 ~WARNING~#2
post the error message. we can't help if you just post the query

~For people who do NOT want to download the file, simple click the spoiler~
Spoiler
04/18/2011 03:42 Eurion#3
I've gone through and fixed the sql errors that I could see right off. You had a few that had spaces where there shouldn't be spaces.

New Code:
Spoiler
Code:
delete from cq_action where id >= 1082010 and id <= 1082015;

insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
('1082010','728441','728444','508','0','1 0 52'),
('1082011','728442','0','502','729989',''),
('1082012','728443','0','501','1082240',''),
('1082013','728445,'0','1085','0','gmlog/action_log 380,%user_name[%user_id],0,0,1082240,0,0,729989,0,0'),
('1082014','0','0','126','0','Please~make~a~space~in~your~eud emon~bags!'),
('1082015','0','0',126','0','Congratz!~You!~got~your~CuddlyDragon~egg!');


delete from cq_itemtype where id >= 729989 and id <= 729989;
delete from cq_itemtype where id >= 1082240 and id <= 1082240;
delete from cq_itemtype where id >= 1072240 and id <= 1072242;
delete from cq_itemtype where id >= 1076240 and id <= 1076242;

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
('729989', 'CuddlyDragon', '28', '3000000', '8151350', '0000', '1', '1', '00', '00000', '1082240', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1082240', 'CuddlyDragon', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1072240', 'CuddlyDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072241', 'CuddlyDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072242', 'CuddlyDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071122', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076240', 'CuddlyDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079120', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076241', 'CuddlyDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079121', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076242', 'CuddlyDragon', '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 >= 1072240 and id <= 1072242;
delete from cq_eudemon_rbn_type where id >= 1076240 and id <= 1076242;


insert into cq_eudemon_rbn_type (`id`, `life`, `phy_atk`, `phy_def`, `mgc_atk`, `mgc_def`)
values
('1072240', '0', '1', '1', '0', '0'),
('1072241', '0', '1', '1', '0', '0'),
('1072242', '0', '1', '1', '0', '0'),
('1076240', '0', '1', '1', '0', '0'),
('1076241', '0', '1', '1', '0', '0'),
('1076242', '0', '1', '1', '0', '0');


delete from cq_grade where id >= 1072240 and id <= 1072242;
delete from cq_grade where id >= 1076240 and id <= 1076242;

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
('1072240', '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'),
('1072241', '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'),
('1072242', '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'),
('1076240', '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'),
('1076241', '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'),
('1076242', '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 >= 1072240 and id <= 1072242;
delete from cq_monstertype where id >= 1076240 and id <= 1076242;

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
('1072240', 'CuddlyDragon', '1', '963', '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'),
('1072241', 'CuddlyDragon', '1', '963', '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'),
('1072242', 'CuddlyDragon', '1', '963', '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'),
('1076240', 'CuddlyDragon', '1', '963', '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'),
('1076241', 'CuddlyDragon', '1', '963', '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'),
('1076242', 'CuddlyDragon', '1', '963', '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');
04/18/2011 05:56 wolfvb#4
thanks man you are the best
04/18/2011 06:06 Eurion#5
You're welcome.