Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Eudemons Online > EO PServer Hosting > EO PServer Guides & Releases
You last visited: Today at 07:16

  • Please register to post and access all features, it's quick, easy and FREE!


[RELEASE] Boss Drop and Spawn - fast custom way!

Reply
 
Old   #1
 
elite*gold: 50
Join Date: Oct 2008
Posts: 555
Received Thanks: 1,104
[RELEASE] Boss Drop and Spawn - fast custom way!

This time will present queries to change totally Boss Drops under private servers into your own Custom one

Lets start from explanation of Bosses and ID's inside DB of them:

Code:
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'
Now what we only need to do is Edit our dropitemrule so these Bosses will be dropping this what we wish them to:

MistyMarch - Elfencity

Example of drop chosen by me here:
(rebornsphere +3 and luckypotion +3 + 500eocards)


Code:
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

Example of drop chosen by me here:
(2700eocards + 500eocards + all super gems + SUPER weapons 125lvl + ExpballpackB + SuperMoonBox)


Code:
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;

[I]Example of drop chosen by me here:

IcyLand

(all super gems + 10000expball + unix30* + unix23*)

Code:
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

(all super gems + 10000expball(demons-online special item!) + unix30* + unix23*)

Code:
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

CROWNS(girl hairs + swalloow doublet + devil/angel wings + swallow doublet + supermoonbox + elven dance suit + lightshadow + potencypotion+3)

Code:
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;


DarkMarch

(expball packb + specialexpball10k(demons-online special item!) + 10xexppotion(demons-online special item!) + unix30*)

Code:
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 CHNCE OF DROP!!! Which in this case of Bosses is very important!

MONSTERTYPE part:

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;

And Dropitemrule Chance of dropping part:

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;

About Drops this is ALL !!


Now if anyone wish to chance Boss time of Spawn here it is:

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;

720 - means 720 seconds necessary for each Boss to be born!
You all can change this number in the way you all wish to

Regards



SoulNecturn is offline  
Thanks
45 Users
Old 07/14/2009, 20:30   #2
 
elite*gold: 20
Join Date: Nov 2008
Posts: 1,408
Received Thanks: 400
Talking

what happened to u guys...???lots of releases lately...keep up....


rexes13 is offline  
Old 07/15/2009, 00:06   #3
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,694
Soulerman please do me a favour edit your post and replace scripts as per below. Yours just look messy so I cleaned them and made it so they are alot faster too. (If you run scripts remotely having multiple queries really drags it on you...)


But again thanks for making a contribution



Script 1:

Code:
update cq_dropitemrule set 
item0=1020140,
item1=1020140,
item2=1020140,
item3=1020140,
item4=1020140,
item5=1020140,
item6=1020140,
item7=1020140,
item8=1020140,
item9=1020140,
item10=1033133,
item11=1033133,
item12=1033143,
item13=1033143,
item14=1020140
where
group_id >= 2001 and group_id <= 2003 or
group_id >= 2011 and group_id <= 2013 or
group_id >= 2021 and group_id <= 2023 or
group_id >= 2031 and group_id <= 2033 or
group_id >= 2041 and group_id <= 2043 or
group_id >= 2051 and group_id <= 2053 or
group_id >= 2051 and group_id <= 2053;



Script 2:

Code:
update cq_dropitemrule 
set 
item0=1020140,
item1=1020140,
item2=1020160,
item3=1020160,
item4=1038170,
item5=1038230,
item6=1038260,
item7=1038290,
item8=420244,
item9=420234,
item10=440244,
item11=490244,
item12=724041,
item13=724041,
item14=820300 
where 
group_id >= 3001 and group_id <= 3003 or
group_id >= 3011 and group_id <= 3013 or
group_id >= 3021 and group_id <= 3023 or
group_id >= 3031 and group_id <= 3033 or
group_id >= 3041 and group_id <= 3043;

Script 3:

Code:
update cq_dropitemrule
set 
item0=1038170,
item1=1038230,
item2=1038260,
item3=1038290,
item4=728998,
item5=728998,
item6=728998,
item7=728998,
item8=728998,
item9=813002,
item10=813002,
item11=813002,
item12=813002,
item13=813000,
item14=813000
where 
group_id >= 4011 and group_id <= 4013 or
group_id >= 4021 and group_id <= 4023 or
group_id >= 4031 and group_id <= 4033 or
group_id >= 4041 and group_id <= 4043;

Script 4:

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

Script 5:

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

Script 6:

Code:
update cq_dropitemrule 
set 
item0=728999,
item1=728999,
item2=728999,
item3=728999,
item4=728999,
item5=724041,
item6=724041,
item7=724041,
item8=724041,
item9=724041,
item10=724041,
item11=810014,
item12=810014,
item13=813002,
item14=813002 
where 
group_id >= 7011 and group_id <= 7013 or
group_id >= 7021 and group_id <= 7023 or
group_id >= 7031 and group_id <= 7033 or
group_id >= 7041 and group_id <= 7043;
Script 7:

Code:
UPDATE cq_monstertype 
SET 
drop_item_chance=100000 
where 
id >= 2001 and id <= 2003 or
id >= 2011 and id <= 2013 or
id >= 2021 and id <= 2023 or
id >= 2031 and id <= 2033 or
id >= 2041 and id <= 2043 or
id >= 2051 and id <= 2053 or
id >= 3001 and id <= 3003 or
id >= 3011 and id <= 3013 or
id >= 3021 and id <= 3023 or
id >= 3031 and id <= 3033 or
id >= 3041 and id <= 3043 or
id >= 4011 and id <= 4013 or
id >= 4021 and id <= 4023 or
id >= 4031 and id <= 4033 or
id >= 4041 and id <= 4043 or
id >= 5011 and id <= 5013 or
id >= 5021 and id <= 5023 or
id >= 5031 and id <= 5033 or
id >= 6011 and id <= 6013 or
id >= 6021 and id <= 6023 or
id >= 6031 and id <= 6033 or
id >= 7011 and id <= 7013 or
id >= 7021 and id <= 7023 or
id >= 7031 and id <= 7033 or
id >= 7041 and id <= 7043;

Script 8:

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

UPDATE CQ_DROPITEMRULE 
SET 
CHANCE=2090000 
where 
group_id >= 3001 and group_id <= 3003 or
group_id >= 3011 and group_id <= 3013 or
group_id >= 3021 and group_id <= 3023 or
group_id >= 3031 and group_id <= 3033 or
group_id >= 3041 and group_id <= 3043 or
group_id >= 4011 and group_id <= 4013 or
group_id >= 4021 and group_id <= 4023 or
group_id >= 4031 and group_id <= 4033 or
group_id >= 4041 and group_id <= 4043 or
group_id >= 5011 and group_id <= 5013 or
group_id >= 5021 and group_id <= 5023 or
group_id >= 5031 and group_id <= 5033;

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

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

Script 9:

Code:
UPDATE cq_generator 
SET 
rest_secs=720 
where 
npctype >= 2001 and npctype <= 2003 or
npctype >= 2011 and npctype <= 2013 or
npctype >= 2021 and npctype <= 2023 or
npctype >= 2031 and npctype <= 2033 or
npctype >= 2041 and npctype <= 2043 or
npctype >= 2051 and npctype <= 2053 or
npctype >= 3001 and npctype <= 3003 or
npctype >= 3011 and npctype <= 3013 or
npctype >= 3021 and npctype <= 3023 or
npctype >= 3031 and npctype <= 3033 or
npctype >= 3041 and npctype <= 3043 or
npctype >= 4011 and npctype <= 4013 or
npctype >= 4021 and npctype <= 4023 or
npctype >= 4031 and npctype <= 4033 or
npctype >= 4041 and npctype <= 4043 or
npctype >= 5011 and npctype <= 5013 or
npctype >= 5021 and npctype <= 5023 or
npctype >= 5031 and npctype <= 5033 or
npctype >= 6011 and npctype <= 6013 or
npctype >= 6021 and npctype <= 6023 or
npctype >= 6031 and npctype <= 6033 or
npctype >= 7011 and npctype <= 7013 or
npctype >= 7021 and npctype <= 7023 or
npctype >= 7031 and npctype <= 7033 or
npctype >= 7041 and npctype <= 7043;
funhacker is offline  
Thanks
10 Users
Old 07/15/2009, 00:19   #4
 
elite*gold: 50
Join Date: Oct 2008
Posts: 555
Received Thanks: 1,104
Funhacker

scripts are like this because they were mention to be like this...

On this that I posted - maybe there are many queries but thats the point. For everyone to have clean view into this and change it into their own needs...

For example:

1) They can edit each Boss separately - not group of them (which your "cleaned" one limit to)

2) IF someone will run it via remote ... well I am sure he/she wont have trouble if he/she will do it separately - not all at once (thats why this is not the 1 big code, but splited into each map and each certain action that must be done... right?)

3) Why I like this dump way? Simply, mostly I am making all these queries by hand very fast(basing on ideas from my head etc so I used to this heh) and in this way when I going back to this after months I am able to do edits much faster then in the "cleaned" way you suggested here. (and if I have lots to edit I just make one separate "update" query that will do whole job for me


So I wanna leave it in my form as I decided to release in beginning (as myself more cleaned to see what is what).
Regards


SoulNecturn is offline  
Thanks
2 Users
Old 07/15/2009, 04:59   #5
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,694
Quote:
Originally Posted by Soulerman View Post
Funhacker

scripts are like this because they were mention to be like this...

On this that I posted - maybe there are many queries but thats the point. For everyone to have clean view into this and change it into their own needs...

For example:

1) They can edit each Boss separately - not group of them (which your "cleaned" one limit to)

2) IF someone will run it via remote ... well I am sure he/she wont have trouble if he/she will do it separately - not all at once (thats why this is not the 1 big code, but splited into each map and each certain action that must be done... right?)

3) Why I like this dump way? Simply, mostly I am making all these queries by hand very fast(basing on ideas from my head etc so I used to this heh) and in this way when I going back to this after months I am able to do edits much faster then in the "cleaned" way you suggested here. (and if I have lots to edit I just make one separate "update" query that will do whole job for me


So I wanna leave it in my form as I decided to release in beginning (as myself more cleaned to see what is what).
Regards
so basicaly you're saying you don't want it this way because you can't read my scripts.
funhacker is offline  
Old 07/15/2009, 05:26   #6
 
elite*gold: 0
Join Date: Sep 2008
Posts: 979
Received Thanks: 642
Wink

okay, let's get some points stated :

Code:
1) They can edit each Boss separately - not group of them (which your "cleaned" one limit to)
1 - Your version :
Quote:
update cq_dropitemrule set item0=1020140 where group_id >= 2001 and group_id <= 2003;
You are saying that your one does not limit to exact monster, and his limit to groups.
your translation to english :
Quote:
set item0 to 1020140 where monsters group_id = 2001
2 -His version :
Quote:
update cq_dropitemrule set item0=1020140, blah, blah where
group_id >= 2001 and group_id <= 2003 or blah or blah
His one determines items per a number of groups, which shortens it by a big way - his one can be simply edited for every monster to have particular items - while, the benift is good when it comes to your code - you made for all monsters same items!!!
Conclusion : not a big deal to change per-monster-drop in funhacker's queries
His translation to english :
Quote:
set item0 to 1020140 where group_id = 2001 AND group_id = xxx
-----------------------------------
Quote:
2) IF someone will run it via remote ... well I am sure he/she wont have trouble if he/she will do it separately - not all at once (thats why this is not the 1 big code, but split-ed into each map and each certain action that must be done... right?)
that would spread MUCH TIME on it, i would spend about a FULL HOUR to run all those remotely via navicat , while funhacker's one would take 10-15 minutes
-----------------------------------
Quote:
3) Why I like this dump way? Simply, mostly I am making all these queries by hand very fast(basing on ideas from my head etc so I used to this heh) and in this way when I going back to this after months I am able to do edits much faster then in the "cleaned" way you suggested here. (and if I have lots to edit I just make one separate "update" query that will do whole job for me
Techinically, you are saying his way is "bad" because you can not read it good because , it requires mind working
-----------------------------------
Conclusion : funhacker's way is better .
No flame - I'm answering your points.
Necron33 is offline  
Old 07/15/2009, 09:17   #7
 
elite*gold: 50
Join Date: Oct 2008
Posts: 555
Received Thanks: 1,104
LOL

1) Yes I "cant ready your query" ... LOL this one was funny :/ One thing I dont understand is this explanation Necron made about my explanation heh

2) You dont like my release? - make your own about the same I prefer my version and few lines of queries here in my opinion are better...

ehhh


And sorry guys no offense but ehhh nah this time I wont be explaining my points Since for someone I see my query will take hour (LOL you still have 486???? hhhe)

Anyway yes I still believe in my points and still I am able to move under these codes more smoothly in your... This option that funhacker present is good - never said is bad ... but lets members of this Community choose

Ok like I wrote it point 2
SoulNecturn is offline  
Thanks
1 User
Old 07/15/2009, 19:05   #8
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,694
Quote:
Originally Posted by Soulerman View Post
LOL


And sorry guys no offense but ehhh nah this time I wont be explaining my points Since for someone I see my query will take hour (LOL you still have 486???? hhhe)
I dont understand this... what do you mean "you still have 486" ?
funhacker is offline  
Old 01/14/2010, 10:43   #9
 
elite*gold: 0
Join Date: Aug 2009
Posts: 345
Received Thanks: 114
[QUOTE=Soulerman;2556871]
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;
Soulerman...
this code can make easy drop....??
matrix89 is offline  
Old 01/14/2010, 20:40   #10
 
elite*gold: 0
Join Date: Jan 2009
Posts: 68
Received Thanks: 12
Quote:
Soulerman...
this code can make easy drop....??
but this code is easy to drop but increase but as drops. least reduce the more likely she is to drop

example:

4090000 if you put 6090000 will be easy

4090000 if you put 1090000 will be medium

4090000 if you put 490000 will be difficult



good luck friend
luzia is offline  
Thanks
3 Users
Old 01/15/2010, 00:49   #11
 
elite*gold: 0
Join Date: Aug 2009
Posts: 345
Received Thanks: 114
Quote:
Originally Posted by luzia View Post
but this code is easy to drop but increase but as drops. least reduce the more likely she is to drop

example:

4090000 if you put 6090000 will be easy

4090000 if you put 1090000 will be medium

4090000 if you put 490000 will be difficult



good luck friend
ok..i will try it...
Thanx..
matrix89 is offline  
Old 11/06/2017, 15:43   #12
 
elite*gold: 0
Join Date: Dec 2009
Posts: 155
Received Thanks: 5
clear.


reloaded90 is offline  
Reply



« [Release] Darkblade EO Database + Client | [RELEASE] Profession 6 Class changer »

Similar Threads
Spawn Coor for boss and mini boss.
Behemoth Boss LVL 71: 500,772 Dark Marsh Ice Demon Boss (Forgot the lvl): 344, 621 Icyland FourTeeth Boss LVL 93: 1107, 962 Volcano Green...
62 Replies - EO Guides & Templates
How do you make boss spawn super fast with csv?
ive tried changing the tick to 0.0001 but it doesnt even seem nearly as fast as the one the chinese farmers use... nevermind. i found out how
8 Replies - Dekaron
boss fast spawn- important
hi i saw some1 spawns 3 mobs per sec how can i make Esimed spawn Death Severe Anger faster then 1 per sec? here is what i did and it is not...
4 Replies - Dekaron



All times are GMT +2. The time now is 07:16.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.