Help! Gold drop

12/04/2009 23:54 Gracek33#1
Hi. Im making new pserver and need some help. I get base and client where every mob drops 300 eps card. I want change that...
BUT when i erase ep card id and give my id items (super items, stones) what mobs/bosses will drop, they drop only gold. Why???

I used this guides and make same things
[Only registered and activated users can see links. Click Here To Register...]
and
[Only registered and activated users can see links. Click Here To Register...]

I have one more ask, how can i add +12/+9 super/elite items drop?

Please help me!
12/05/2009 01:34 .Ash#2
to add +12 or +9, go to cq_item and find magic3 and make it +12 or +9 eudemon_attack1,2,3,4 for elements and make 1024 for warghostexp for fsoul 8.

OR

run this query

Code:
update cq_item set magic3=12 where id=YOURCHARACTERID;
update cq_item set eudemon_attack1=12 where id=YOURCHARACTERID;
update cq_item set eudemon_attack2=12 where id=YOURCHARACTERID;
update cq_item set eudemon_attack3=12 where id=YOURCHARACTERID;
update cq_item set eudemon_attack4=12 where id=YOURCHARACTERID;
update cq_item set gem1=18 where id=YOURCHARACTERID;
update cq_item set gem2=18 where id=YOURCHARACTERID;
update cq_item set special_effect=12 where id=YOURCHARACTERID;
update cq_item set warghostexp= 1024 where id=YOURCHARACTERID;
This one gives all the stuff

magic3 = the actual bonus
eudemon_attack1,2,3,4 = Elements
gem1= first gem(18 is for super amber)
gem2= second gem
special effect= name says it xD
warghostexp= fsoul
12/05/2009 01:41 Gracek33#3
thx very much :)
now need only solve Gold problem :/
12/05/2009 01:54 .Ash#4
Quote:
Originally Posted by Gracek33 View Post
Hi. Im making new pserver and need some help. I get base and client where every mob drops 300 eps card. I want change that...
BUT when i erase ep card id and give my id items (super items, stones) what mobs/bosses will drop, they drop only gold. Why???

I used this guides and make same things
[Only registered and activated users can see links. Click Here To Register...]
and
[Only registered and activated users can see links. Click Here To Register...]

I have one more ask, how can i add +12/+9 super/elite items drop?

Please help me!
get the id for the card and check it in cq_action. once you go that, near it, it should say emoney +=300, Change that. But make sure you have it sort descend.
12/05/2009 02:29 Gracek33#5
I dont want mobs drop any ep card but this info will help in future :)

i have one more problem:
when i compose pets they get 1-2 and when i give more in script they get high star mark or star mark increase with stars (1* - 50 star mark, 2* - 70 star mark, 10* - 1200 star mark)...
How fix that??

The news is that boss now drop what i want so its solved.
Now need only compose.

btw. items +12 where are they? They will appear in game or on me...cuz i dont see them
and how make bosses will drop more that one item??
12/05/2009 13:24 .Ash#6
Quote:
Originally Posted by Gracek33 View Post
I dont want mobs drop any ep card but this info will help in future :)

i have one more problem:
when i compose pets they get 1-2 and when i give more in script they get high star mark or star mark increase with stars (1* - 50 star mark, 2* - 70 star mark, 10* - 1200 star mark)...
How fix that??

The news is that boss now drop what i want so its solved.
Now need only compose.

btw. items +12 where are they? They will appear in game or on me...cuz i dont see them
and how make bosses will drop more that one item??
put your character id where i said "where id=CHARACTERID;" And to make bosses drop, i think you have to make a action id and insert that id into cq_monstertype.

But if you want like +255, Try these codes. i forgot which one it is..

Code:
/awarditem 729012
/awarditem 729004

Also, im 100% sure of the composing problem, So im not going to state anything im not sure of.
And make sure you got a Msgserver that doesnt have chksum, if you need one, Use this one. and read the thread also. [Only registered and activated users can see links. Click Here To Register...]
12/05/2009 14:41 Gracek33#7
Why bosses drop only one item and how can i change that?

...Now pets get +5-7 star mark...
btw. i use:

Update cq_eudemon_rbn_rqr set min=15;
Update cq_eudemon_rbn_rqr set max=50;
12/05/2009 15:51 PraDevil[ELITE]#8
Quote:
Originally Posted by Gracek33 View Post
Why bosses drop only one item and how can i change that?
for example red is is the boss id also all at the same line..u will see 2002,2003 and others id

Code:
[COLOR="Red"]2001[/COLOR], 'GreenDevilLvl16'
2002, 'GreenDevilLvl17'
2003, 'GreenDevilLvl18'
2011, 'EyeballLvl21'
2012, 'EyeballLvl22'
2013, 'EyeballLvl23'
ok now i show u how its work..i take a misty marsh and the boss drop for greendevil boss level 16,17 and 18..

Code:
update cq_dropitemrule set [COLOR="Lime"]item0[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item1[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item2[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item3[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item4[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item5[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item6[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item7[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item8[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item9[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item10[/COLOR]=[COLOR="DarkOrange"]1033133[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item11[/COLOR]=[COLOR="DarkOrange"]1033133[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item12[/COLOR]=[COLOR="DarkOrange"]1033143[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item13[/COLOR]=[COLOR="DarkOrange"]1033143[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];
update cq_dropitemrule set [COLOR="Lime"]item14[/COLOR]=[COLOR="DarkOrange"]1020140[/COLOR] where group_id >= [COLOR="Red"]2001[/COLOR] and group_id <= [COLOR="Red"]2003[/COLOR];

meanings:

Green =item list for your drop if u put 0 to all this will make boss drop nothing
Orange =put the item id u want to make a boss drop..for example put 1037160 for redstone also this is the item id u want..u can chose what u want here..but some id cannot use remember just put their id
Reds=Boss id.. ">=" this mean up than the id and "<=" is lower than the id
12/05/2009 19:42 .Ash#9
Sorry dude i cant help much because i dont have access to any DB currently. My navicat is messed up..
12/05/2009 22:34 Gracek33#10
Man you help me a lot, thx :)

You both help me a lot, if i will have more problems i will write here :)
12/05/2009 23:06 PraDevil[ELITE]#11
here we call a forums
12/06/2009 00:56 Gracek33#12
Next problem:
When i hatched eudemon egg, I want give eud-crystal and i cant, but when i buy it from shopping mall i can, How can i fix that?

And copmose problem isnt solved
12/06/2009 01:37 PraDevil[ELITE]#13
cq_action..check it..it will show u code if u are PM then delete it and make sure u remember all that line then add it again..
12/06/2009 14:16 Gracek33#14
I dont know which code i need delete and copy... Can you help me?

And one more thing: how can i change/delete GMs message??
And why my legion gone when i restart my server?


Compose is working already:
[Only registered and activated users can see links. Click Here To Register...]



I wanted new pets and items and i download DB and patch from:
[Only registered and activated users can see links. Click Here To Register...]
and i dont know what i can do now with them. Help plzz!

Anyone can help me plzz??