error in my sql??

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

Quote:

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

Quote:

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]

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

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

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

Quote:

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 :confused:

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

Quote:

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

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!');

thanks anyways atleast ur trying

Read my post above this one.


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

Quote:

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

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.

~(SPACE NOT NEEDED) is a example

There must be no spaces in param.

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

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

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