Help! Gold drop

Gracek33 · 12/04/2009, 23:54

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

and

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

Please help me!

.Ash · 12/05/2009, 01:34

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

Gracek33 · 12/05/2009, 01:41

thx very much

now need only solve Gold problem :/

.Ash · 12/05/2009, 01:54

Quote:

Originally Posted by Gracek33

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

and

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.

Gracek33 · 12/05/2009, 02:29

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??

.Ash · 12/05/2009, 13:24

Quote:

Originally Posted by Gracek33

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.

Gracek33 · 12/05/2009, 14:41

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;

PraDevil[ELITE] · 12/05/2009, 15:51

Quote:

Originally Posted by Gracek33

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

Spoiler

Reds=Boss id.. ">=" this mean up than the id and "<=" is lower than the id

.Ash · 12/05/2009, 19:42

Sorry dude i cant help much because i dont have access to any DB currently. My navicat is messed up..

Gracek33 · 12/05/2009, 22:34

Man you help me a lot, thx

You both help me a lot, if i will have more problems i will write here

PraDevil[ELITE] · 12/05/2009, 23:06

here we call a forums

Gracek33 · 12/06/2009, 00:56

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

PraDevil[ELITE] · 12/06/2009, 01:37

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..

Gracek33 · 12/06/2009, 14:16

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:

I wanted new pets and items and i download DB and patch from:

and i dont know what i can do now with them. Help plzz!

Anyone can help me plzz??