Boss Id :-
Quote:
2001, 'GreenDevilLvl16'
2002, 'GreenDevilLvl17'
2003, 'GreenDevilLvl18'
2011, 'EyeballLvl21'
2012, 'EyeballLvl22'
2013, 'EyeballLvl23'
2021, 'BansheeLvl26'
2022, 'BansheeLvl27'
2023, 'BansheeLvl28'
2031, 'SatyrLvl28'
2032, 'SatyrLvl29'
2033, 'SatyrLvl30'
2041, 'OgreLvl31'
2042, 'OgreLvl32'
2043, 'OgreLvl33'
2051, 'OrcLvl33'
2052, 'OrcLvl34'
2053, 'OrcLvl35'
3001, 'BigFangLvl36'
3002, 'BigFangLvl37'
3003, 'BigFangLvl38'
3011, 'GolemLvl41'
3012, 'GolemLvl42'
3013, 'GolemLvl43'
3021, 'LizardLvl46'
3022, 'LizardLvl47'
3023, 'LizardLvl48'
3031, 'GhostKnightLv51'
3032, 'GhostKnightLv52'
3033, 'GhostKnightLv53'
3041, 'WyvernLvl53'
3042, 'WyvernLvl54'
3043, 'WyvernLvl55'
4011, 'DwarfApeLvl76'
4012, 'DwarfApeLvl77'
4013, 'DwarfApeLvl78'
4022, 'IceDemonLvl82'
4023, 'IceDemonLvl83'
4031, 'YetiLvl86'
4032, 'YetiLvl87'
4033, 'YetiLvl88'
4041, 'OrcLvl91'
4042, 'OrcLvl92'
4043, 'OrcLvl93'
5011, 'FishDemonLvl71'
5012, 'FishDemonLvl72'
5013, 'FishDemonLvl73'
5021, 'DinothereLvl76'
5022, 'DinothereLvl77'
5023, 'DinothereLvl78'
5031, 'AxDemonLvl81'
5032, 'AxDemonLvl82'
5033, 'AxDemonLvl83'
6011, 'WormanLvl86'
6012, 'WormanLvl87'
6013, 'WormanLvl88'
6021, 'FourTeethLvl91'
6022, 'FourTeethLvl92'
6023, 'FourTeethLvl93'
6031, 'FireGenasiLvl96'
6032, 'FireGenasiLvl97'
6033, 'FireGenasiLvl98'
7011, 'TroglodyteLvl56'
7012, 'TroglodyteLvl57'
7013, 'TroglodyteLvl58'
7021, 'GhostLvl61'
7022, 'GhostLvl62'
7023, 'GhostLvl63'
7031, 'DeadKnightLvl66'
7032, 'DeadKnightLvl67'
7033, 'DeadKnightLvl68'
7041, 'WarlockLvl71'
7042, 'WarlockLvl72'
7043, 'WarlockLvl73'
MistyMarsh:
Quote:
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=1033133 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item11=1033133 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item12=1033143 where group_id >= 2001 and group_id <= 2003;
update cq_dropitemrule set item13=1033143 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=1033133 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item11=1033133 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item12=1033143 where group_id >= 2011 and group_id <= 2013;
update cq_dropitemrule set item13=1033143 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=1033133 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item11=1033133 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item12=1033143 where group_id >= 2021 and group_id <= 2023;
update cq_dropitemrule set item13=1033143 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=1033133 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item11=1033133 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item12=1033143 where group_id >= 2031 and group_id <= 2033;
update cq_dropitemrule set item13=1033143 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=1033133 where group_id >= 2011 and group_id <= 2043;
update cq_dropitemrule set item11=1033133 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item12=1033143 where group_id >= 2041 and group_id <= 2043;
update cq_dropitemrule set item13=1033143 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=1033133 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item11=1033133 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item12=1033143 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item13=1033143 where group_id >= 2051 and group_id <= 2053;
update cq_dropitemrule set item14=1020140 where group_id >= 2051 and group_id <= 2053;
GobiDesert:
Quote:
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;
IcyLand:
Quote:
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;
Island:
Quote:
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;
Volcano:
Quote:
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;
DarkMarsh:
Quote:
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;
NOW time to adjust CHANCE OF DROP!!! Which in this case of Bosses is very important!
Monstertype part:
Quote:
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;
And Dropitemrule Chance of dropping part:
Quote:
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;
Boss time of Spawn:
Quote:
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;