VIP Map vendor and Boss Drop not works

[corey88]

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?

[XxFearReaperXx]

can you show me the sql you used?

[corey88]

yes, look at this.
some friends had the same problem.

[XxFearReaperXx]

you dont have any dropitem rule for EPs in the sql

[alaaemad]

Try to use the sql

[corey88]

I used this, but the vendor does not work.

[XxFearReaperXx]

lol maybe you should start actually reading the scripts before you use them. too many people just find one and run it and it screws thier whole game up and expect every one else to fix it for them. take a week bud and learn a little bit of coding on a test server then work on a main one trust me it helps thats how i started out

[magewarior2]

what is in the script?

 Spoiler

First you set to all rows to a drop to every common monster (ids 1020140-1020150)

after this all "bosses" get changed....

after this all rate`s are settled on 2590000...

for a bosses I suggest => "10000000"

update cq_dropitemrule set item0=1020150;
update cq_dropitemrule set item1=1020150;
update cq_dropitemrule set item2=1020150;
update cq_dropitemrule set item3=1020150;
update cq_dropitemrule set item4=1020150;
update cq_dropitemrule set item5=1020150;
update cq_dropitemrule set item6=1020150;
update cq_dropitemrule set item7=1020150;
update cq_dropitemrule set item8=1020140;
update cq_dropitemrule set item9=1020140;
update cq_dropitemrule set item10=1020140;
update cq_dropitemrule set item11=1020140;
update cq_dropitemrule set item12=1020140;
update cq_dropitemrule set item13=1020140;
update cq_dropitemrule set item14=1020140;

update cq_dropitemrule set item0=1020140 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item1=1020140 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item2=1020140 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item3=1020140 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item4=1020140 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item5=1020140 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item6=1020140 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item7=1020140 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item8=1020140 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item9=1020140 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item10=724043 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item11=724043 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item12=724043 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item13=724043 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item14=1020140 where group_id >= 2001 and group_id <= 2003;


update cq_dropitemrule set item0=1020140 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item1=1020140 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item2=1020140 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item3=1020140 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item4=1020140 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item5=1020140 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item6=1020140 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item7=1020140 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item8=1020140 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item9=1020140 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item10=724043 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item11=724043 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item12=724043 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item13=724043 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item14=1020140 where group_id >= 2011 and group_id <= 2013;


update cq_dropitemrule set item0=1020140 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item1=1020140 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item2=1020140 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item3=1020140 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item4=1020140 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item5=1020140 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item6=1020140 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item7=1020140 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item8=1020140 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item9=1020140 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item10=724043 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item11=724043 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item12=724043 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item13=724043 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item14=1020140 where group_id >= 2021 and group_id <= 2023;

update cq_dropitemrule set item0=1020140 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item1=1020140 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item2=1020140 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item3=1020140 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item4=1020140 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item5=1020140 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item6=1020140 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item7=1020140 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item8=1020140 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item9=1020140 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item10=724043 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item11=724043 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item12=724043 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item13=724043 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item14=1020140 where group_id >= 2031 and group_id <= 2033;

update cq_dropitemrule set item0=1020140 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item1=1020140 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item2=1020140 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item3=1020140 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item4=1020140 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item5=1020140 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item6=1020140 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item7=1020140 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item8=1020140 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item9=1020140 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item10=724043 where group_id >= 2011 and group_id <= 2043;
update cq_dropitemrule set item11=724043 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item12=724043 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item13=724043 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item14=1020140 where group_id >= 2041 and group_id <= 2043;

update cq_dropitemrule set item0=1020140 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item1=1020140 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item2=1020140 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item3=1020140 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item4=1020140 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item5=1020140 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item6=1020140 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item7=1020140 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item8=1020140 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item9=1020140 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item10=724043 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item11=724043 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item12=724043 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item13=724043 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item14=1020140 where group_id >= 2051 and group_id <= 2053

update cq_dropitemrule set item0=1020140 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item1=1020140 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item2=1020160 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item3=1020160 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item4=1038170 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item5=1038230 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item6=1038260 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item7=1038290 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item8=420244 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item9=420234 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item10=440244 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item11=490244 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item12=724041 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item13=724041 where group_id >= 3001 and group_id <= 3003;
update cq_dropitemrule set item14=820300 where group_id >= 3001 and group_id <= 3003;


update cq_dropitemrule set item0=1020140 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item1=1020140 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item2=1020160 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item3=1020160 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item4=1038170 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item5=1038230 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item6=1038260 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item7=1038290 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item8=420244 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item9=420234 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item10=440244 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item11=490244 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item12=724041 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item13=724041 where group_id >= 3011 and group_id <= 3013;
update cq_dropitemrule set item14=820300 where group_id >= 3011 and group_id <= 3013;

update cq_dropitemrule set item0=1020140 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item1=1020140 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item2=1020160 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item3=1020160 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item4=1038170 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item5=1038230 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item6=1038260 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item7=1038290 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item8=420244 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item9=420234 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item10=440244 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item11=490244 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item12=724041 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item13=724041 where group_id >= 3021 and group_id <= 3023;
update cq_dropitemrule set item14=820300 where group_id >= 3021 and group_id <= 3023;

update cq_dropitemrule set item0=1020140 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item1=1020140 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item2=1020160 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item3=1020160 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item4=1038170 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item5=1038230 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item6=1038260 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item7=1038290 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item8=420244 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item9=420234 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item10=440244 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item11=490244 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item12=724041 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item13=724041 where group_id >= 3031 and group_id <= 3033;
update cq_dropitemrule set item14=820300 where group_id >= 3031 and group_id <= 3033;

update cq_dropitemrule set item0=1020140 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item1=1020140 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item2=1020160 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item3=1020160 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item4=1038170 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item5=1038230 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item6=1038260 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item7=1038290 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item8=420244 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item9=420234 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item10=440244 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item11=490244 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item12=724041 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item13=724041 where group_id >= 3041 and group_id <= 3043;
update cq_dropitemrule set item14=820300 where group_id >= 3041 and group_id <= 3043;

update cq_dropitemrule set item0=1038170 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item1=1038230 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item2=1038260 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item3=1038290 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item4=728998 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item5=728998 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item6=728998 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item7=728998 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item8=728998 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item9=813002 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item10=813002 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item11=813002 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item12=813002 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item13=813000 where group_id >= 4011 and group_id <= 4013;
update cq_dropitemrule set item14=813000 where group_id >= 4011 and group_id <= 4013;

update cq_dropitemrule set item0=1038170 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item1=1038230 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item2=1038260 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item3=1038290 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item4=728998 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item5=728998 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item6=728998 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item7=728998 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item8=728998 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item9=813002 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item10=813002 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item11=813002 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item12=813002 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item13=813000 where group_id >= 4021 and group_id <= 4023;
update cq_dropitemrule set item14=813000 where group_id >= 4021 and group_id <= 4023;

update cq_dropitemrule set item0=1038170 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item1=1038230 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item2=1038260 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item3=1038290 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item4=728998 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item5=728998 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item6=728998 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item7=728998 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item8=728998 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item9=813002 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item10=813002 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item11=813002 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item12=813002 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item13=813000 where group_id >= 4031 and group_id <= 4033;
update cq_dropitemrule set item14=813000 where group_id >= 4031 and group_id <= 4033;

update cq_dropitemrule set item0=1038170 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item1=1038230 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item2=1038260 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item3=1038290 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item4=728998 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item5=728998 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item6=728998 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item7=728998 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item8=728998 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item9=813002 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item10=813002 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item11=813002 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item12=813002 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item13=813000 where group_id >= 4041 and group_id <= 4043;
update cq_dropitemrule set item14=813000 where group_id >= 4041 and group_id <= 4043;

update cq_dropitemrule set item0=1038170 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item1=1038230 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item2=1038260 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item3=1038290 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item4=728998 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item5=728998 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item6=728998 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item7=728998 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item8=728998 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item9=813002 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item10=813002 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item11=813002 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item12=813002 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item13=813000 where group_id >= 5011 and group_id <= 5013;
update cq_dropitemrule set item14=813000 where group_id >= 5011 and group_id <= 5013;

update cq_dropitemrule set item0=1038170 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item1=1038230 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item2=1038260 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item3=1038290 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item4=728998 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item5=728998 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item6=728998 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item7=728998 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item8=728998 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item9=813002 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item10=813002 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item11=813002 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item12=813002 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item13=813000 where group_id >= 5021 and group_id <= 5023;
update cq_dropitemrule set item14=813000 where group_id >= 5021 and group_id <= 5023;

update cq_dropitemrule set item0=1038170 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item1=1038230 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item2=1038260 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item3=1038290 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item4=728998 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item5=728998 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item6=728998 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item7=728998 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item8=728998 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item9=813002 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item10=813002 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item11=813002 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item12=813002 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item13=813000 where group_id >= 5031 and group_id <= 5033;
update cq_dropitemrule set item14=813000 where group_id >= 5031 and group_id <= 5033;

update cq_dropitemrule set item0=725544 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item1=725545 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item2=725547 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item3=725548 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item4=725549 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item5=190650 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item6=190630 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item7=192300 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item8=192320 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item9=190650 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item10=190630 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item11=820300 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item12=190060 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item13=1033152 where group_id >= 6011 and group_id <= 6013;
update cq_dropitemrule set item14=190040 where group_id >= 6011 and group_id <= 6013;

update cq_dropitemrule set item0=725544 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item1=725545 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item2=725547 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item3=725548 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item4=725549 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item5=190650 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item6=190630 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item7=192300 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item8=192320 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item9=190650 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item10=190630 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item11=820300 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item12=190060 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item13=1033152 where group_id >= 6021 and group_id <= 6023;
update cq_dropitemrule set item14=190040 where group_id >= 6021 and group_id <= 6023;

update cq_dropitemrule set item0=725544 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item1=725545 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item2=725547 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item3=725548 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item4=725549 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item5=190650 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item6=190630 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item7=192300 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item8=192320 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item9=190650 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item10=190630 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item11=820300 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item12=190060 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item13=1033152 where group_id >= 6031 and group_id <= 6033;
update cq_dropitemrule set item14=190040 where group_id >= 6031 and group_id <= 6033;

update cq_dropitemrule set item0=728999 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item1=728999 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item2=728999 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item3=728999 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item4=728999 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item5=724041 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item6=724041 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item7=724041 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item8=724041 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item9=724041 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item10=724041 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item11=810014 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item12=810014 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item13=813002 where group_id >= 7011 and group_id <= 7013;
update cq_dropitemrule set item14=813002 where group_id >= 7011 and group_id <= 7013;

update cq_dropitemrule set item0=728999 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item1=728999 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item2=728999 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item3=728999 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item4=728999 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item5=724041 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item6=724041 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item7=724041 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item8=724041 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item9=724041 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item10=724041 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item11=810014 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item12=810014 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item13=813002 where group_id >= 7021 and group_id <= 7023;
update cq_dropitemrule set item14=813002 where group_id >= 7021 and group_id <= 7023;

update cq_dropitemrule set item0=728999 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item1=728999 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item2=728999 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item3=728999 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item4=728999 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item5=724041 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item6=724041 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item7=724041 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item8=724041 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item9=724041 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item10=724041 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item11=810014 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item12=810014 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item13=813002 where group_id >= 7031 and group_id <= 7033;
update cq_dropitemrule set item14=813002 where group_id >= 7031 and group_id <= 7033;

update cq_dropitemrule set item0=728999 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item1=728999 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item2=728999 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item3=728999 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item4=728999 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item5=724041 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item6=724041 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item7=724041 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item8=724041 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item9=724041 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item10=724041 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item11=810014 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item12=810014 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item13=813002 where group_id >= 7041 and group_id <= 7043;
update cq_dropitemrule set item14=813002 where group_id >= 7041 and group_id <= 7043;

UPDATE CQ_DROPITEMRULE SET CHANCE=2590000;

after that it sets the drop_item_chance to 100000 (cq_monstertype)

UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 2001 and id <= 2003;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 2011 and id <= 2013;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 2021 and id <= 2023;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 2031 and id <= 2033;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 2041 and id <= 2043;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 2051 and id <= 2053;

UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 3001 and id <= 3003;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 3011 and id <= 3013;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 3021 and id <= 3023;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 3031 and id <= 3033;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 3041 and id <= 3043;

UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 4011 and id <= 4013;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 4021 and id <= 4023;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 4031 and id <= 4033;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 4041 and id <= 4043;

UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 5011 and id <= 5013;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 5021 and id <= 5023;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 5031 and id <= 5033;

UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 6011 and id <= 6013;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 6021 and id <= 6023;


UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 6031 and id <= 6033;

UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 7011 and id <= 7013;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 7021 and id <= 7023;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 7031 and id <= 7033;
UPDATE cq_monstertype SET drop_item_chance=100000 where id >= 7041 and id <= 7043;

again the drop chance is changed...

UPDATE CQ_DROPITEMRULE SET CHANCE=2590000 where group_id >= 2001 and group_id <= 2003;
UPDATE CQ_DROPITEMRULE SET CHANCE=2590000 where group_id >= 2011 and group_id <= 2013;
UPDATE CQ_DROPITEMRULE SET CHANCE=2590000 where group_id >= 2021 and group_id <= 2023;
UPDATE CQ_DROPITEMRULE SET CHANCE=2590000 where group_id >= 2031 and group_id <= 2033;
UPDATE CQ_DROPITEMRULE SET CHANCE=2590000 where group_id >= 2041 and group_id <= 2043;
UPDATE CQ_DROPITEMRULE SET CHANCE=2590000 where group_id >= 2051 and group_id <= 2053;

UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 3001 and group_id <= 3003;
UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 3011 and group_id <= 3013;
UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 3021 and group_id <= 3023;
UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 3031 and group_id <= 3033;
UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 3041 and group_id <= 3043;

UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 4011 and group_id <= 4013;
UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 4021 and group_id <= 4023;
UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 4031 and group_id <= 4033;
UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 4041 and group_id <= 4043;


UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 5011 and group_id <= 5013;
UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 5021 and group_id <= 5023;
UPDATE CQ_DROPITEMRULE SET CHANCE=2090000 where group_id >= 5031 and group_id <= 5033;

UPDATE CQ_DROPITEMRULE SET CHANCE=1250000 where group_id >= 6011 and group_id <= 6013;
UPDATE CQ_DROPITEMRULE SET CHANCE=1250000 where group_id >= 6021 and group_id <= 6023;
UPDATE CQ_DROPITEMRULE SET CHANCE=1250000 where group_id >= 6031 and group_id <= 6033;

UPDATE CQ_DROPITEMRULE SET CHANCE=4090000 where group_id >= 7011 and group_id <= 7013;
UPDATE CQ_DROPITEMRULE SET CHANCE=4090000 where group_id >= 7021 and group_id <= 7023;
UPDATE CQ_DROPITEMRULE SET CHANCE=4090000 where group_id >= 7031 and group_id <= 7033;
UPDATE CQ_DROPITEMRULE SET CHANCE=4090000 where group_id >= 7041 and group_id <= 7043;

after that it sets the rest seconds to 720 (spawning)

what is 12 minute`s?

UPDATE cq_generator SET rest_secs=720 where npctype >= 2001 and npctype <= 2003;
UPDATE cq_generator SET rest_secs=720 where npctype >= 2011 and npctype <= 2013;
UPDATE cq_generator SET rest_secs=720 where npctype >= 2021 and npctype <= 2023;
UPDATE cq_generator SET rest_secs=720 where npctype >= 2031 and npctype <= 2033;
UPDATE cq_generator SET rest_secs=720 where npctype >= 2041 and npctype <= 2043;
UPDATE cq_generator SET rest_secs=720 where npctype >= 2051 and npctype <= 2053;

UPDATE cq_generator SET rest_secs=720 where npctype >= 3001 and npctype <= 3003;
UPDATE cq_generator SET rest_secs=720 where npctype >= 3011 and npctype <= 3013;
UPDATE cq_generator SET rest_secs=720 where npctype >= 3021 and npctype <= 3023;
UPDATE cq_generator SET rest_secs=720 where npctype >= 3031 and npctype <= 3033;
UPDATE cq_generator SET rest_secs=720 where npctype >= 3041 and npctype <= 3043;

UPDATE cq_generator SET rest_secs=720 where npctype >= 4011 and npctype <= 4013;
UPDATE cq_generator SET rest_secs=720 where npctype >= 4021 and npctype <= 4023;
UPDATE cq_generator SET rest_secs=720 where npctype >= 4031 and npctype <= 4033;
UPDATE cq_generator SET rest_secs=720 where npctype >= 4041 and npctype <= 4043;

UPDATE cq_generator SET rest_secs=720 where npctype >= 5011 and npctype <= 5013;
UPDATE cq_generator SET rest_secs=720 where npctype >= 5021 and npctype <= 5023;
UPDATE cq_generator SET rest_secs=720 where npctype >= 5031 and npctype <= 5033;

UPDATE cq_generator SET rest_secs=720 where npctype >= 6011 and npctype <= 6013;
UPDATE cq_generator SET rest_secs=720 where npctype >= 6021 and npctype <= 6023;
UPDATE cq_generator SET rest_secs=720 where npctype >= 6031 and npctype <= 6033;

UPDATE cq_generator SET rest_secs=720 where npctype >= 7011 and npctype <= 7013;
UPDATE cq_generator SET rest_secs=720 where npctype >= 7021 and npctype <= 7023;
UPDATE cq_generator SET rest_secs=720 where npctype >= 7031 and npctype <= 7033;
UPDATE cq_generator SET rest_secs=720 where npctype >= 7041 and npctype <= 7043;

Why I think it is not working ....


I think you have no item with the ID "1020140"?


I`m just guessing so do not blame me if I am wrong....

my thought:

using this script just ruins your server..