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
---
I explain the bad sorry guys if dont understand me
Have Question About Drop
03/07/2012 20:54
Murik13#1
03/07/2012 21:44
JohnHeatz#2
Drops are on PS_GameDefs.dbo.MobItems, so I am not quite sure what is it that you are asking about...
03/08/2012 09:04
[Admin]Accident#3
here u go :)
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
03/08/2012 11:23
Murik13#4
lmao i am no need how add drop
03/09/2012 12:28
[Dev]Ansem#5
well than explain your prob a little more please.Quote:
lmao i am no need how add drop
You want the MobItems table as a .sql file like the cash.sql and item.sql from shStudio?
03/09/2012 14:02
Murik13#6
yes greester
it is possible?
it is possible?
03/09/2012 18:36
VirtuozZ#7
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.
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.
03/09/2012 22:24
Tradehappy#8
was talking to castor on this very subject but never recieved reply on how to get the csv files for mobs. Thank you
03/09/2012 23:31
VirtuozZ#9
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.
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.