[Help]Almost got it!

12/09/2010 04:18 Ct42#1
Okay this is my first attempt ever at adding the Flying Dragon mount. I made a Query for it but it had an error at the cq_itemtype.
I used this release: [Only registered and activated users can see links. Click Here To Register...]
I used this as a guide to make the Query: [Only registered and activated users can see links. Click Here To Register...]
Could someone please possibly tell me what to fix and how to fix it. Still new to the Query but Im giving it my all.
Here is what i got when i entered it in:
[SQL] delete from cq_action where id >= 727440 and id <= 728445;
Affected rows: 0
Time: 0.000ms

[SQL]

insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(728440,728441,728444,508,0,'1 0 52'),
(728441,728442,0,502,729442,''),
(728442,728443,0,501,1081110,''),
(728443,728445,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1081110,0,0,729442,0,0'),
(728444,0,0,126,0,'Please~make~a~space~in~your~eud emon~bags!'),
(728445,0,0,126,0,'Congratz!~You!~got~your~eudemon ~egg!');
Affected rows: 6
Time: 0.000ms

[SQL]


delete from cq_itemtype where id >= 729442 and id <= 729442;
Affected rows: 0
Time: 0.000ms

[SQL]
delete from cq_itemtype where id >= 1081110 and id <= 1081110;
Affected rows: 1
Time: 0.000ms

[SQL]
delete from cq_itemtype where id >= 1071110 and id <= 1071112;
Affected rows: 3
Time: 0.000ms

[SQL]
delete from cq_itemtype where id >= 1079110 and id <= 1079112;
Affected rows: 3
Time: 0.000ms

[SQL]

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
('729442', 'GreenDragon', '28', '3000000', '(Action ID)', '0000', '1', '1', '00', '00000', '1081110', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1081110', 'GreenDragon', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071110', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071110', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071111', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071111', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071112', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071112', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079110', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079110', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079111', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079111', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079112', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079112', '7', '1', '00', '11', '21', '31', '41', '51');
[Err] 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'unt_limit,gem1,hitrate,monster_type,able_mask,exp _ type,emoney,

(Zip file bellow is my query)
12/09/2010 15:12 King_Arthur#2
You have a space between the 'o' and 'u' in "amount_limit"
12/09/2010 16:03 Ct42#3
I'll have to fix that when I get home....cant believe I missed that, I was searching the entire query for the issue..
12/09/2010 18:21 alxandr2#4
good work ty
12/09/2010 19:15 Ct42#5
Okay so i fixed that and i still get this:

Affected rows: 0
Time: 0.000ms

[SQL]
delete from cq_itemtype where id >= 1081110 and id <= 1081110;
Affected rows: 0
Time: 0.000ms

[SQL]
delete from cq_itemtype where id >= 1071110 and id <= 1071112;
Affected rows: 0
Time: 0.000ms

[SQL]
delete from cq_itemtype where id >= 1079110 and id <= 1079112;
Affected rows: 0
Time: 0.000ms

[SQL]

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
('729442', 'GreenDragon', '28', '3000000', '20000500', '0000', '1', '1', '00', '00000', '1081110', '0', '0', '250000', '00', '00', '00', '00', '00'),
('1081110', 'GreenDragon', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071110', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071110', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071111', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071111', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071112', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071112', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079110', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079110', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079111', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079111', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079112', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079112', '7', '1', '00', '11', '21', '31', '41', '51');
[Err] 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '4,official5)
values
('729442', 'GreenDragon', '28', '3000000
and my MySQL i got from the revo database, it didnt fix my problem. Any ideas now?

this is the query:

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
('729442', 'GreenDragon', '28', '3000000', '20000500', '0000', '1', '1', '00', '00000', '1081110', '0', '0', '250000', '00', '00', '00', '00', '00'),
('1081110', 'GreenDragon', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1071110', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071110', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071111', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071111', '7', '1', '00', '11', '21', '31', '41', '51'),
('1071112', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0071112', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079110', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079110', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079111', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079111', '7', '1', '00', '11', '21', '31', '41', '51'),
('1079112', 'GreenDragon', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '0079112', '7', '1', '00', '11', '21', '31', '41', '51');


delete from cq_eudemon_rbn_type where id >= 1071110 and id <= 1071112;
delete from cq_eudemon_rbn_type where id >= 1079110 and id <= 1079112;
12/09/2010 21:33 ~*Kronic*~#6
Space between 'official 4'
12/10/2010 00:25 Ct42#7
I've tried both, having a space and not and I still got the same error...ill try again when I get home, I'm a snowboard instructor, I work till 9 (3 and a half hours from now)