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"
Code:
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)
Code:
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...
Code:
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?
Code:
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;