GameServer stopped getting new data @DB

08/09/2014 22:37 khaledlollol#1

Hey there i was wondering if there is something that causes Gameserver to stop getting new Values from database
It seems that everything i do @ database isn't loaded @ GS after restart
Like lets say i added a drop to a MOB [[TG]]
[Only registered and activated users can see links. Click Here To Register...]
As you see it should drop 2 items each time this mob is killed but it doesn't
I also added an item to NPC and nope GS doesn't read these new added values.
I am not sure it's the GS but it seems so
If you know what may cause suck thing maybe you can tell me.

08/10/2014 20:01 Anonymous-6723#2

That's why you have DROPAMOUNTMin and DROPAMOUNTMax meaning.. how many items you want ? You want two? Well Min = 2, Max = 2, DropRatio as you setted it to 1 (100%) and should work. It's not gameserver related but the way you do it. Which mob is that anyway?

08/10/2014 21:26 khaledlollol#3

Quote:

Originally Posted by Zed*

That's why you have DROPAMOUNTMin and DROPAMOUNTMax meaning.. how many items you want ? You want two? Well Min = 2, Max = 2, DropRatio as you setted it to 1 (100%) and should work. It's not gameserver related but the way you do it. Which mob is that anyway?

Haven't you notice 'MOB_CH_TIGERWOMAN' ? !!!!
And it's added two times not because i want 2 just thought maybe something was wrong when i added it the first time so i re added it but its the same + i am sure there's something wrong because what i ever i do @ DB seems not to be changed ingame

08/11/2014 07:33 Snow*#4

Duplicated rows, try to delete them and re add.
You wont be able to delete them at the table so this will do just fine.
(I'm very newbie when it comes to SQL query's)

Code:

DELETE FROM SRO_VT_SHARD.dbo._RefMonster_AssignedItemDrop where RefMonsterID = '1954'

So when you finish add the row then make sure it's add and restart your GS.

08/11/2014 08:56 Zodiao#5

It happened before..
That's because you are using way too high level character.
try using newly created character for this, and check the rates(If they are actually fixed)

08/11/2014 13:56 khaledlollol#6

Quote:

Originally Posted by Sir*EviL

It happened before..
That's because you are using way too high level character.
try using newly created character for this, and check the rates(If they are actually fixed)

You don't get it it's not only the drop which is not working
It's Everything
Everything stopped at a point and not changing mobs spawn time the drops the npcs all