[Help]Almost got it!

[Ct42]

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:
I used this as a guide to make the Query:
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)

[King_Arthur]

You have a space between the 'o' and 'u' in "amount_limit"

[Ct42]

I'll have to fix that when I get home....cant believe I missed that, I was searching the entire query for the issue..

[alxandr2]

good work ty

[Ct42]

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;

[~*Kronic*~]

Space between 'official 4'

[Ct42]

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)