[HELP]Gold Drop Problem

hiderian · 02/02/2013, 08:54

All monsters drop same amount like 1000000 rupee.
For example, Butkadah should drop 3996612R(gold_min) to 6661021R(gold_max) according to SQL table but it drops 1000000R anytime. How can I solve it? Please someone help me. Thank you.

hiderian · 02/04/2013, 13:09

I still can't solve this... Please help me

Also, I'll receive a lot of JP when I killed monsters. Even if my level is around 30, my JLv can be 50. It's very strange...

So, how can I setup Gold and JP option?

Anyway, I've never changed Gold Drop rate in SQL.
Then, in my GameServer is...

Code:

S game.exp_rate:500
S game.item_drop_rate:10
S game.gold_drop_rate:10
S game.chaos_drop_rate:5

c1ph3r · 02/04/2013, 13:35

Quote:
Originally Posted by hiderian
I still can't solve this... Please help me
Also, I'll receive a lot of JP when I killed monsters. Even if my level is around 30, my JLv can be 50. It's very strange...

So, how can I setup Gold and JP option?

Anyway, I've never changed Gold Drop rate in SQL.
Then, in my GameServer is...
Code:
[B]S game.exp_rate:500[/B] JP Problem
S game.item_drop_rate:10
S game.gold_drop_rate:10
S game.chaos_drop_rate:5

There are two possibilities to change golddrop gameserver.opt or sql! There is no other way!

hiderian · 02/04/2013, 14:14

Quote:

Originally Posted by c1ph3r

There are two possibilities to change golddrop gameserver.opt or sql! There is no other way!

I could solve the JP problem but I still have gold problem...

Code:

UPDATE dbo.MonsterResource
set gold=gold*2,
gold2=gold2*2

However it doesn't work...
Msg 207, Level 16, State 1, Line 2
Invalid column name 'gold'.
Msg 207, Level 16, State 1, Line 2
Invalid column name 'gold2'.

I have "gold_min" "gold_max" "gold_min_2" and "gold_max_2" in SQL, so I've tried to change value like this

Code:

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_min] = [gold_min] * 2
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_max] = [gold_max] * 2
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_min_2] = [gold_min_2] * 2
GO

UPDATE [Arcadia].[dbo].[MonsterResource]
SET [gold_max_2] = [gold_max_2] * 2
GO

However, the all monsters where is in the Secret Dongeon drop same amount like 950000R. Then, all boss such as Butkadah drops 1000000R everytime. It shold drop [gold_min]3996612 to [gold_max]6661021 or [gold_min_2]2385810 to [gold_max_2]3976351 according to SQL table.

I guess all monsters who drop over 1000000R drop 950000R to 1000000R evry time.

But anyways, thank you very much for your advice.

~~marekrndr~~ · 02/04/2013, 14:36

Isn't a million rups the maximum anything can drop? 0o

hiderian · 02/04/2013, 15:21

Quote:

Originally Posted by marekrndr

Isn't a million rups the maximum anything can drop? 0o

Nobody drops 1000000 rupeesin the monsterresource like this.

Code:

gold_min  gold_max
172545	287576
941325	1568875
116410	194017
177500	295833
968355	1613924
116410	194017
177500	295833
968355	1613924
116410	194017
540568	900947
119659	199432
182454	304091
995384	1658973
119659	199432
555657	926094
123050	205083
187624	312707
1023588	1705981
571401	952336
555657	926094
126299	210499
192579	320965
1050618	1751030
126299	210499
555657	926094
616011	1026686
202272	337121
1103501	1839169
98202	163671
142970	238283
137409	229015
98725	164542
143731	239552
138140	230234
99144	165239
144340	240567
138726	231210
99667	166111
145101	241836
139457	232429
100085	166808
145710	242851
140043	233405
100608	167680
146472	244120
140774	234624
101026	168377
147081	245135
141360	235600
101549	169248
147842	246403
142092	236819
101967	169946
148451	247419
142677	237795
102490	170817
149212	248687
143409	239014
103431	172386
150583	250971
144726	241209
103850	173083
151192	251986
145311	242185
104373	173954
151953	253255
146043	243404
104791	174652
152562	254270
146628	244380
105314	175523
153323	255539
147360	245599
105732	176220
153932	256554
147945	246575
106255	177092
154694	257823
148677	247794
106673	177789
155303	258838
149262	248770
107196	178661
156064	260107
149994	249989
737162	1228603
770874	1284789
3996612	6661021
737162	1228603
770874	1284789
3996612	6661021 <--- Butkadah

It's impossible to drop 1000000 rupees everytime from all monsters.

~~marekrndr~~ · 02/04/2013, 16:07

I'm still standing by my statement.. Not giving a phook what's in your MonsterResource.

Galatheas · 02/04/2013, 17:05

Quote:
Originally Posted by hiderian
Code:
3996612	6661021 <--- Butkadah
It's impossible to drop 1000000 rupees everytime from all monsters.

Quote:

Originally Posted by =hiderian

S game.gold_drop_rate:10

3.996.612 x 10 = ????????????

hiderian · 02/04/2013, 18:07

Quote:

Originally Posted by Galatheas

3.996.612 x 10 = ????????????

If "S game.gold_drop_rate:10" works correctly, Butkadah shold drops over 30M. However, it drops same amount anytime even if I changed S game.gold_drop_rate:10 to 100 or 1000. It won't drop like 30M...

Also, "SET [gold_min] = [gold_min] * value" and "SET [gold_max] = [gold_max] * value" won't work for me...

~~marekrndr~~ · 02/05/2013, 04:01

I'm saying 1mil is max ermargerd 0.0

hiderian · 02/05/2013, 06:00

Quote:

Originally Posted by marekrndr

I'm saying 1mil is max ermargerd 0.0

So is it possible to change maximum?

c1ph3r · 02/05/2013, 09:56

Where is the need to drop more than 1kkk R per Mob? This is bullshit! It's possible to change via .lua...

hiderian · 02/05/2013, 10:21

Quote:

Originally Posted by c1ph3r

Where is the need to drop more than 1kkk R per Mob? This is bullshit! It's possible to change via .lua...

Which lua file is it? I can't findout about it...

c1ph3r · 02/05/2013, 12:59

Quote:

Originally Posted by hiderian

Which lua file is it? I can't findout about it...

you can use every .lua...script_on_dead...but that means a single script for each mob. It's easier to lower the prices...

If you don't understand what i'm telling you simply...give it up!

~~marekrndr~~ · 02/05/2013, 13:40

Quote:

Originally Posted by hiderian

So is it possible to change maximum?

Ok I'll try this language :

me no see ever mob drop over 1 mil rupie, not sure it ist el possibro, k thx helf meay