Cq-Dromitemrule

02/12/2010 20:44 catface2345#1

Anybody know what group_id,ruleid is for thanks

02/12/2010 21:23 magewarior2#2

The group ID is the monster ...

the ruleId i did forgotn, but i when i get it back ill tell ya ;)

02/12/2010 21:46 catface2345#3

ok, um does the dropitem ID matter, i just set this up and monster still dosnt drop anything any ideas>?

02/13/2010 06:50 ~WARNING~#4

You must change the drop rate of that item

02/13/2010 07:10 catface2345#5

how?

02/13/2010 08:42 javairc#6

u can use this for change drop monster

Code:

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

UPDATE CQ_DROPITEMRULE SET CHANCE=0;

p/s: change 0 to what item ID u want drop from monster. Use this [Only registered and activated users can see links. Click Here To Register...]

02/13/2010 12:08 magewarior2#7

Quote:

Originally Posted by javairc

u can use this for change drop monster

Code:

[COLOR="Red"]update cq_dropitemrule set item0=0;
update cq_dropitemrule set item1=0;
update cq_dropitemrule set item2=0;
update cq_dropitemrule set item3=0;
update cq_dropitemrule set item4=0;
update cq_dropitemrule set item5=0;
update cq_dropitemrule set item6=0;
update cq_dropitemrule set item7=0;
update cq_dropitemrule set item8=0;
update cq_dropitemrule set item9=0;
update cq_dropitemrule set item10=0;
update cq_dropitemrule set item11=0;
update cq_dropitemrule set item12=0;
update cq_dropitemrule set item13=0;
update cq_dropitemrule set item14=0;[/COLOR]

[COLOR="red"]This are your items you like to drop, but this will add it to ALL the monsters .... also bosse, ass normal monsters.
[/COLOR]
[COLOR="Lime"]UPDATE CQ_DROPITEMRULE SET CHANCE=0;[/COLOR]

this is the chance they drop some items.

a boss have normally the chance of 10000000.
p/s: change 0 to what item ID u want drop from monster. Use this [Only registered and activated users can see links. Click Here To Register...]

to make it a little easy'er for bosses only you can run this script.

example.

Code:

UPDATE CQ_DROPITEMRULE SET CHANCE= '10000000' where id >= 1001 and id <= 1003;

Download the script here.
[Only registered and activated users can see links. Click Here To Register...]

do you want to be sure your dropitem rule rate is fully changed, download this.

Example

Code:

UPDATE CQ_DROPITEMRULE SET CHANCE= '10000000' where id >= 1001 and id <= 1003
[COLOR="Lime"]UPDATE CQ_MONSTERTYPE SET drop_item_chance= '10000' where id >= 1001 and id <= 1003;[/COLOR]

download the script here.
[Only registered and activated users can see links. Click Here To Register...]

Code:

UPDATE CQ_MONSTERTYPE SET [COLOR="Lime"]drop_item_chance= '10000' [/COLOR]where id >= 1001 and id <= 1003;

This is the chance what the bosses drop.

here you go a very fast guide :bandit: good luck !

02/13/2010 15:56 catface2345#8

alright much aprricated, but why whne running a query do we need two Id not 1 and what ruleid again?

02/13/2010 19:42 magewarior2#9

if you make ruleid "1" it wont be a problem i think

02/13/2010 19:46 catface2345#10

02/14/2010 12:37 apoxdeath#11

dude if u wanted to no that all you had to do was ask me, lol chat with me more :P

02/15/2010 04:31 chathouse#12

Quote:
Originally Posted by magewarior2
to make it a little easy'er for bosses only you can run this script.

example.
Code:
UPDATE CQ_DROPITEMRULE SET CHANCE= '10000000' where id >= 1001 and id <= 1003;
......

the text was shortened by me

can I adjust that also here the monsters these 1,5,10,20 .... ep packs to drop?