boss drop

10/19/2011 21:44 Helpplease#1

looking for good query boss drop like 1 million eps to 4 million eps ...
Thanks

10/19/2011 22:08 Thorlon#2

Don't be lazy , ether make one yourself or use the search button. :)

10/19/2011 22:09 Helpplease#3

im not lazy i just dont know how?
if you can teach me i would be glad
Thanks :)

10/19/2011 22:12 Thorlon#4

I'm sorry for that, im not good with querys but im sure someone will help and i will have a quick search to see if there is a post on it :)
-----------------------------------
Edit:

I have found this:

Code:

UPDATE cq_dropitemrule SET item0=ID, item1=ID, item3=ID, item4=ID, item5=ID, item6=ID, item7=ID, item8=ID, item9=ID, item10=ID, item11=ID, item12=ID, item12=ID, item13=ID, item14=ID where group_id=MONSTER ID;

and this: [Only registered and activated users can see links. Click Here To Register...]

Good luck :)

10/19/2011 22:27 Silvalite110#5

Yes - that code should work and the guide looks good. Good Luck :)

10/19/2011 22:34 Helpplease#6

Quote:
Originally Posted by Thorlon
I'm sorry for that, im not good with querys but im sure someone will help and i will have a quick search to see if there is a post on it :)
-----------------------------------
Edit:

I have found this:
Code:
UPDATE cq_dropitemrule SET item0=ID, item1=ID, item3=ID, item4=ID, item5=ID, item6=ID, item7=ID, item8=ID, item9=ID, item10=ID, item11=ID, item12=ID, item12=ID, item13=ID, item14=ID where group_id=MONSTER ID;
and this: [Only registered and activated users can see links. Click Here To Register...]

Good luck :)

Thanks for that useful post but i need the ID for the EPs drop

10/19/2011 22:38 WolvesMaster#7

Code:

[B]update cq_dropitemrule set item0=[COLOR=Red]729022[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item1=[COLOR=Red]723008[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item2=[COLOR=Red]729027[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item3=[COLOR=Red]724041[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item4=[COLOR=Red]729022[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item5=[COLOR=Red]723008[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item6=[COLOR=Red]729027[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item7=[COLOR=Red]724041[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item8=[COLOR=Red]729022[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item9=[COLOR=Red]723008[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item10=[COLOR=Red]729027[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item11=[COLOR=Red]724041[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item12=[COLOR=Red]729022[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item13=[COLOR=Red]723008[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item14=[COLOR=Red]729027[/COLOR] where group_id >= 3001 and group_id <= 3003;
  
  
update cq_dropitemrule set item0=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item1=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item2=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item3=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item4=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item5=[COLOR=Red]72404[/COLOR][COLOR=Red]1[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item6=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item7=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item8=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item9=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item10=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item11=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item12=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item13=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item14=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
  
update cq_dropitemrule set item0=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item1=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item2=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item3=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item4=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item5=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item6=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item7=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item8=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item9=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item10=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item11=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item12=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item13=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item14=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
  
update cq_dropitemrule set item0=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item1=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item2=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item3=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item4=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item5=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item6=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item7=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item8=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item9=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item10=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item11=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item12=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item13=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item14=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
  
update cq_dropitemrule set item0=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item1=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item2=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item3=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item4=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item5=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item6=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item7=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item8=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item9=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item10=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item11=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item12=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item13=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item14=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
[/B]

change these Red IDs to what item you want to drop just write the ID then run it in Navicat

10/19/2011 23:13 Thorlon#8

Quote:

Originally Posted by WolvesMaster

Code:

[B]update cq_dropitemrule set item0=[COLOR=Red]729022[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item1=[COLOR=Red]723008[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item2=[COLOR=Red]729027[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item3=[COLOR=Red]724041[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item4=[COLOR=Red]729022[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item5=[COLOR=Red]723008[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item6=[COLOR=Red]729027[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item7=[COLOR=Red]724041[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item8=[COLOR=Red]729022[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item9=[COLOR=Red]723008[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item10=[COLOR=Red]729027[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item11=[COLOR=Red]724041[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item12=[COLOR=Red]729022[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item13=[COLOR=Red]723008[/COLOR] where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item14=[COLOR=Red]729027[/COLOR] where group_id >= 3001 and group_id <= 3003;
  
  
update cq_dropitemrule set item0=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item1=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item2=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item3=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item4=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item5=[COLOR=Red]72404[/COLOR][COLOR=Red]1[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item6=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item7=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item8=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item9=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item10=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item11=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item12=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item13=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item14=[COLOR=Red]724041[/COLOR] where group_id >= 3011 and group_id <= 3013;
  
update cq_dropitemrule set item0=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item1=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item2=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item3=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item4=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item5=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item6=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item7=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item8=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item9=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item10=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item11=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item12=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item13=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item14=[COLOR=Red]724041[/COLOR] where group_id >= 3021 and group_id <= 3023;
  
update cq_dropitemrule set item0=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item1=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item2=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item3=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item4=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item5=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item6=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item7=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item8=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item9=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item10=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item11=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item12=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item13=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item14=[COLOR=Red]724041[/COLOR] where group_id >= 3031 and group_id <= 3033;
  
update cq_dropitemrule set item0=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item1=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item2=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item3=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item4=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item5=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item6=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item7=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item8=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item9=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item10=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item11=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item12=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item13=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item14=[COLOR=Red]724041[/COLOR] where group_id >= 3041 and group_id <= 3043;
[/B]

change these Red IDs to what item you want to drop just write the ID then run it in Navicat

He means the number "724041" lol

10/20/2011 02:58 Marcus*#9

or it thats all confusing for you heres a more detailed guide [Only registered and activated users can see links. Click Here To Register...]

10/20/2011 09:47 idlemonkey#10

hmm i think he means this [Only registered and activated users can see links. Click Here To Register...]
example:

Code:

INSERT INTO `cq_action` VALUES ('9999000001', '9999000002', '0000', '1001', '0', 'e_money += 5000000');
INSERT INTO `cq_action` VALUES ('9999000002', '0', '0000', '1010', '2005', 'you got 50000000 EPs from ThisguysBoss youre rich now!');

if you make one string like explained here for your selected monster then it will drop eps and say in the system you killed soandso and recieved suchandsuch eps or whatever you want it to say

just make one string with your info for whatever monster you are trying to make drop eps and probably change the action numbers as you probably have them used
dont forget to add the action id to your boss in cq_monstertype

10/21/2011 19:15 ~Sword~Stalker~.#11

>>> this

or u can go to [Only registered and activated users can see links. Click Here To Register...]

10/22/2011 03:28 Marcus*#12

Quote:

Originally Posted by Marcus*

or it thats all confusing for you heres a more detailed guide [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by ~Sword~Stalker~.

>>> this

or u can go to [Only registered and activated users can see links. Click Here To Register...]

already posted that one lol

10/22/2011 09:41 ~Sword~Stalker~.#13

emm yes marcus , im sorry i thought u were posting the ''all things guide'' thread's link .