[help]sql err

wolfvb · 04/18/2011, 03:13

i have err in the sql i make are any one know why
the sql in attach files can any one help me

~WARNING~ · 04/18/2011, 03:22

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

Eurion · 04/18/2011, 03:42

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');

wolfvb · 04/18/2011, 05:56

thanks man you are the best

Eurion · 04/18/2011, 06:06

You're welcome.