You last visited: Today at 05:38
Advertisement
[help]sql err
Discussion on [help]sql err within the EO PServer Hosting forum part of the Eudemons Online category.
04/18/2011, 03:13
#1
elite*gold: 0
Join Date: Nov 2010
Posts: 238
Received Thanks: 218
[help]sql err
i have err in the sql i make are any one know why
the sql in attach files can any one help me
Attached Files
SQl.txt
(7.4 KB, 4 views)
04/18/2011, 03:22
#2
elite*gold: 5
Join Date: Feb 2010
Posts: 1,040
Received Thanks: 442
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~
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~eu d emon~bags!'),
(1082015,0,0,126,0,'Congratz!~You!~got~your~Cuddly Dragon~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,amo unt_limit,gem1,hitrate,monster_type,able_mask,exp_ type,emoney,official1,official2,official3,official 4,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, 03:42
#3
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 926
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:
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
#4
elite*gold: 0
Join Date: Nov 2010
Posts: 238
Received Thanks: 218
thanks man you are the best
04/18/2011, 06:06
#5
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 926
You're welcome.
All times are GMT +1. The time now is 05:38 .