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