Monster help

~~ProffLex~~ · 02/02/2013, 18:23

...

st.jimmy998 · 02/02/2013, 19:50

lol, use Shstudios please

that give u an .slq file

st.jimmy998 · 02/02/2013, 19:58

Sure, what planet are you?
Sets (Shstudios) to give you the files saved to the desktop

st.jimmy998 · 02/02/2013, 20:02

Quote:

Originally Posted by ProffLex

shstudio not creates monster.sql

Well for sure, you know more than me, does not give files .sql
Wait other answers ¬ ¬

TeddyBear94 · 02/02/2013, 23:32

indeed sh studio is able to give u a monster.sql but i would suggest doing it via python since that will be more secure.

rempieremco153 · 02/03/2013, 10:10

Seriously, Dude..
Do the easy way:
Take SHStudio,
Press Tools --> Settings
Then put the "Location to save server data" to your desktop.
Now everytime you save there will be a new SQL file on your destop...

EDIT:
Okay just tried it and didn't work.
I guess you don't have all dds files for the mobs.
Look at the last couple of mobs (Weasel, Owl and that ****)

nubness · 02/03/2013, 12:55

You need to run 2 queries in SQL:

Code:

USE PS_GameDefs;
SELECT * FROM Mobs

Code:

USE PS_GameDefs;
SELECT * FROM MobItems

After each you need to save them as .csv WITH ANSI ENCODING and make sure you have the column headers included. You can make SQL include the column headers in your .csv files at Tools -> Options -> Query Results -> SQL Server ->

Results to Grid -> Check the "Include column headers when copying or saving the results".
Results to Text -> Check the "Include column headers in the result set."

Open the Monster.SData. Go to File -> Import, and import the 2 .csv tables.

Now in your Data\Monster folder you will have a new file named MonsterEx.SData.

That's quite it. Now whenever you save your Monster.sdata it will generate an .sql file.

nubness · 02/03/2013, 13:03

The SQL Save button has options. Look carefully.

rempieremco153 · 02/03/2013, 13:24

Quote:

Originally Posted by BMSborja99

dsfgdaaaaa

Uhh What was that for?