error in my sql??

[Crazy123456]

hey guys im trying to add some new euds and its not reading my cq_action :S if u guys can find anything wrong in my query please feel free to edit

delete from cq_action where id >= 7297290 and id <= 7297295;
insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(7297290,7267291,7267294,508,0,'1 0 52'),
(7297291,7297292,0,502,729420,''),
(7297292,7297293,0,501,1081760,''),
(7297293,7297295,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1082960,0,0,729452,0,0'),
(7297294,0,0,126,0,'Please~make~one~space~in~your~ eudemon~bag~free!'),
(7297295,0,0,126,0,'Congratz!~You!~got~your~eudemo n~egg!');

and heres a cq_action thats actually working

7294590: [7294591,7294594]. type[508], data[0], param:[1 0 52].[2:48]

7294591: [7294592,0]. type[502], data[729423], param:[].[2:48]

7294592: [7294593,0]. type[501], data[1081630], param:[].[2:48]

7294593: [7294595,0]. type[1085], data[0], param:[gmlog/action_log 380,[PM][1],0,0,1081630,0,0,729423,0,0].[2:48]

7294595: [0,0]. type[126], data[0], param:[Congratulations!~You~have~obtained~an~Eudemon~egg!].[2:48]

[KiiDxLaggy]

When you ran the query, there is no duplicate entries right?

EDIT::: Try this query

delete from cq_action where id >= 7297290 and id <= 7267291;
delete from cq_action where id >= 7297291 and id <= 7267292;
delete from cq_action where id >= 7297292 and id <= 7267293;
delete from cq_action where id >= 7297293 and id <= 7267294;
delete from cq_action where id >= 7297294 and id <= 0;
delete from cq_action where id >= 7297295 and id <= 0;

insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(7297290,7267291,7267294,508,0,'1 0 52'),
(7297291,7297292,0,502,729420,''),
(7297292,7297293,0,501,1081760,''),
(7297293,7297295,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1082960,0,0,729452,0,0'),
(7297294,0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
(7297295,0,0,126,0,'Congratz!~You!~got~your~eudemon~egg!');

Note: this query was off the top of my head, so it may be slightly wrong hope i helped

[Crazy123456]

ofcourse it didnt duplicate i delete the action ids before and always check if the ids already in use

[KiiDxLaggy]

Originally Posted by Crazy123456

ofcourse it didnt duplicate i delete the action ids before and always check if the ids already in use

Please try running the query in my post above, and try again. Just to make sure because you may have typed it wrong? im not too sure, just trying to help

[Crazy123456]

no thanks i didnt type it wrong im not using someone else query to delete my ids just incase also ur typing up alot of work doing it that way u can just do this

delete from cq_action where id >= 7297290 and id <= 7297295;

[KiiDxLaggy]

Okay, sorry I couldn't help

EDIT::

Actually i looked at your query again, and i don't know if this would effect it ( im kinda new ) but if you look you typed

delete from cq_action where id >= 7297290 and id <= 7297295;
insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(7297290,7267291,7267294,508,0,'1 0 52'),
(7297291,7297292,0,502,729420,''),
(7297292,7297293,0,501,1081760,''),
(7297293,7297295,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,1082960,0,0,729452,0,0'),
(7297294,0,0,126,0,'Please~make~one~space~in~your~(SPACE NOT NEEDED)eudemon~bag~free!'),
(7297295,0,0,126,0,'Congratz!~You!~got~your~eudemo(space not needed)n~egg!');

[Crazy123456]

thanks anyways atleast ur trying

[KiiDxLaggy]

Read my post above this one.


EDIT: Do you have MSN? I can try to help more on there :\

[PraDevil[ELITE]]

delete from cq_action where id >= 7297290 and id <= 7297295;
insert into cq_action (id,id_next,id_nextfail,type,data,param)
values
(7297290,7267291,7267294,508,0,'1 0 52'),
(7297291,7297292,0,502,729420,''),
(7297292,7297293,0,501,1081760,''),
(7297293,7297295,0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,[COLOR="Red"]1081760[/COLOR],0,0,[COLOR="Red"]729420[/COLOR],0,0'),
(7297294,0,0,126,0,'Please~make~one~space~in~[COLOR="Red"](space not needed)[/COLOR]your~eudemo[COLOR="Red"](space not needed)[/COLOR]n~bag~free!'),
(7297295,0,0,126,0,'Congratz!~You!~got~your~eudemon~egg!');

[Crazy123456]

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
('729452', 'ElementalTiger', '28', '3000000', '7297290', '0000', '1', '1', '00', '00000', '1082960', '0', '0', '30000', '00', '00', '00', '00', '00'),
('1082960', 'ElementalTiger', '40', '0000000', '0000000', '0000', '1', '1', '00', '00000', '0000000', '0', '0', '00', '00', '00', '00', '00', '00'),
('1072960', 'ElementalTiger', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '72960', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072961', 'ElementalTiger', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '72961', '7', '1', '00', '11', '21', '31', '41', '51'),
('1072962', 'ElementalTiger', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '72962', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076960', 'ElementalTiger', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '76960', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076961', 'ElementalTiger', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '76961', '7', '1', '00', '11', '21', '31', '41', '51'),
('1076962', 'ElementalTiger', '00', '0000250', '0000000', '3000', '1', '1', '32', '10000', '76962', '7', '1', '00', '11', '21', '31', '41', '51');

this may be the problem ? hmmm

[KiiDxLaggy]

yes but there is an error in those codes, you put spaces were spaces arent needed, read my post above and then look at yours.

[chathouse]

~(SPACE NOT NEEDED) is a example

[B][COLOR="Navy"]Differences[/COLOR][/B]

[COLOR="SeaGreen"][B]TRUE[/B][/COLOR]

[COLOR="SeaGreen"](7297294,0,0,126,0,'Please~make~one~space~in~[COLOR="Navy"]your~eudemon[/COLOR]~bag~free!'),
(7297295,0,0,126,0,'Congratz!~You!~got~your~[COLOR="Navy"]eudemon[/COLOR]~egg!');[/COLOR]

[B][COLOR="Red"]FALSE[/COLOR][/B]

[COLOR="Red"](7297294,0,0,126,0,'Please~make~one~space~in~[COLOR="Navy"]your~ eudemon[/COLOR]~bag~free!'),
(7297295,0,0,126,0,'Congratz!~You!~got~your~[COLOR="Navy"]eudemo n[/COLOR]~egg!');[/COLOR]

There must be no spaces in param.

[Crazy123456]

no i checked eveywhere theres no spaces its the the quote thing is being dumb!

[PraDevil[ELITE]]

your itemtype.dat problem..maybe duplicate id or eudemon bag id dont have a monopoly

[Crazy123456]

not client sided its DB sided my client is set up fine i work with client for DB nvm ill just use the 180.... query the eud works fine i just cant get it from inventory to my bag