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'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:
[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
[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
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
VIP Map vendor and Boss Drop not works 03/04/2011 - EO PServer Hosting - 7 Replies Hello, guys!
I have a problem with two things :
Vip Map Vendor, not works!
i right click him and nothing do.
and Boss Drop not works, i'v been used one query i found here, but on the game de Drop is null.
Can someone help-me?
can someone post a way to set the drop of the boss? 04/25/2010 - Eudemons Online - 3 Replies good come here to ask any of you who already has more experience you can help me in one doubts that the case would set the drop of the iten boss every boss and the boss just in case one xpball by drop to maintain on the server power control if possible help will be very grateful right now ^^ :D
Boss monsters only drop 1 items 01/16/2010 - Dekaron Private Server - 2 Replies If I make more set index inside monster.csv the monster won't drop any items. But if i make 1 set index the monster will drop the item. Why it won't allow to drop more than 1 items in each kill.
Boss perfect drop 07/10/2008 - EO Exploits, Hacks, Tools & Macros - 14 Replies could samebody tell how to get best drop on a boss
i can't get right at all lately .... yesterday night at 92 96 97 lvl bosses droped 1 vios or yellow .... no red ... please explain somebodu who realy knows ... time ... level to KO .... eudemons
thanks in advance