Have Question About Drop

[Murik13]

Can i do my drop into file .sql how item.sql or cash.sql? when make drop list do this all drops in 1 sql file?
---
I explain the bad sorry guys if dont understand me

[JohnHeatz]

Drops are on PS_GameDefs.dbo.MobItems, so I am not quite sure what is it that you are asking about...

[[Admin]Accident]

here u go

[Murik13]

lmao i am no need how add drop

[[Dev]Ansem]

Originally Posted by Murik13

lmao i am no need how add drop

well than explain your prob a little more please.
You want the MobItems table as a .sql file like the cash.sql and item.sql from shStudio?

[Murik13]

yes greester

it is possible?

[VirtuozZ]

It is possible,
Get your dbo.mobs and dbo.MobItems as .csv files,
open Monster.sdata and click file/import and import the 2 mobs.csv and mobsitems.csv
This will create MonsterEX.sdata and now when you set the drops, if you save there will be a file named Monster.sql
execute it and your drops will be set.

[Tradehappy]

was talking to castor on this very subject but never recieved reply on how to get the csv files for mobs. Thank you

[VirtuozZ]

for make the .csv files, open your database go to PS_GameDefs.dbo.Mobs
Select all lines, copy and stick it into a excel new document (excel or whatever existing programs that allow you to save in .csv).
If it's not set, add a line on top with the column names in your database (don't make error or it won't work).
If exists the last line set to NULL NULL NULL ..., delete this line.
Save it as .csv file.
Same job with PS_GameData.dbo.MobItems.