Need info about item drops

[shadowtwinz]

I've been trying to find mob drop grade and item drop groups, sadly I dont have enough IT skills to do that myself so I'm asking if anyone could help me.
I need to find EP 4.5 or ep 5 (Vanilla) Monsters that drop worship-heroic 1-15 pvp items Dread - legendary 20-30 items Item groups and monsters that drop this item group also drop rates.
The main reason why im doing this because there is not information about that since game was released and Devs don't want to help with that.
Thank you.

[Piccoloale099]

PHP Code:

DECLARE [MENTION=303108]slot[/MENTION]Number as tinyint = 3
DECLARE [MENTION=665444]request[/MENTION]edLevel as tinyint = 15

SELECT * FROM PS_GameDefs.dbo.MobItems_ORIGINAL WHERE Grade
IN (Select DISTINCT Grade from ps_gamedefs.dbo.Items 
where slot = [MENTION=303108]slot[/MENTION]Number AND Reqlevel <= [MENTION=665444]request[/MENTION]edLevel) 


[shadowtwinz]

Sorry but i don't understand. All you did was copy pasted. Maybe write down in readable form.

[Piccoloale099]

Originally Posted by shadowtwinz

Sorry but i don't understand. All you did was copy pasted. Maybe write down in readable form.

You have to replace the "mention " part with a @
DECLARE @Number as tinyint = 3
DECLARE @edLevel as tinyint = 15

SELECT * FROM PS_GameDefs.dbo.MobItems_ORIGINAL WHERE Grade
IN (Select DISTINCT Grade from ps_gamedefs.dbo.Items
where slot = @Number AND @evel


Basic sql

[shadowtwinz]

Basic sql

I'm not modder i dont know anything about SQL I just wanted you to extract information from data to be readable for normal people who don't understand anything about sql.
I'm just playing shaiya and need information about drops which monsters drops that because there isnt any information about that, and i know that info is hiding in data in which i can't go in.

[momocruz]

Originally Posted by shadowtwinz

I'm not modder i dont know anything about SQL I just wanted you to extract information from data to be readable for normal people who don't understand anything about sql.
I'm just playing shaiya and need information about drops which monsters drops that because there isnt any information about that, and i know that info is hiding in data in which i can't go in.

Some Client have Monster.EX on data/monster folder

this one are for making SQL script if you have this on Client you can see all drop
he have put on client side,
if the DEV have using and patch Monster.EX on client but maybe you have to ask to Admin to know what is on drop

[shadowtwinz]

Can you check it from Any 4.5 ep that is available ? I have downloaded ep 4.5 server file sbut as I said i have no skills to do that myself

[shadowtwinz]

There is a drop list or drop finder on web but there are items in game like legendary 20-30 worship 1-15 items in game and ring name ???173 those items are not on drop list. They are in drop group that is consider as rare world drop and doesnt show on drop finder or drop list thats what i was asking you to dig out. Basicly drop list doesnt have every item init. And afaik ID list shows every possible obtainable item in game.
The server im playing is classic ep 4.5 which minimal tweaks.

by the way if you played shaiya those items im asking are dropped extremely rare somewhere and none knows at what drop rate.

And i've been checking guides about drops in game and i noticed that 7-9 drop grade possesing |PPM| part per million drop chance. And the answer is lying in there,

[[Alcatraz]]

the so called rare drops like what your talking about or really any drops aren't stored in the client files they are stored in the database files. when people use sh studios and things like that to edit the drops the app reads some of the info from the client but the drops are read and edited from the database files. so if you want to know what and where they are you need access to the database.

and knowing sql is how you get the info from the database if you using sh studios or something like that it has pre determined sql query to get the info for you but that's only if you have access rights to the database . so other then a droplist that a admin gave out or having direct access to the database there isn't any other way to find the items and drop rates like what your asking.

[shadowtwinz]

But there are ep 4.5 server files you can download them and checked, thats all im asking. I think it's called OMEGA Server files or something like that. I need info from classic server.
try to google about rare world drops there is 0 info.

[sominus]

You should ask the server Owner about those drops.
Those items your're asking, most of the time have grade 999 or grade 0 (no dropable) on the database by default.
If they're a rare world drop on the server you're playing, may be the ADM set them up that way, so you should ask him.