Monster help

02/02/2013 18:23 ProffLex#1
...
02/02/2013 19:50 st.jimmy998#2
lol, use Shstudios please :D
that give u an .slq file
02/02/2013 19:58 st.jimmy998#3
Sure, what planet are you?
Sets (Shstudios) to give you the files saved to the desktop
02/02/2013 20:02 st.jimmy998#4
Quote:
Originally Posted by ProffLex View Post
:facepalm: shstudio not creates monster.sql
Well for sure, you know more than me, does not give files .sql
Wait other answers ¬ ¬
02/02/2013 23:32 TeddyBear94#5
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.
02/03/2013 10:10 rempieremco153#6
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 shit)
02/03/2013 12:55 nubness#7
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.
02/03/2013 13:03 nubness#8
The SQL Save button has options. Look carefully.
02/03/2013 13:24 rempieremco153#9
Quote:
Originally Posted by BMSborja99 View Post
dsfgdaaaaa
Uhh What was that for?