You have to select all values of your dbo.Mobs [MobItems] and save this as Mobs.csv [MobItems.csv]. Open your Monster.SData in shStudio and Import this two Files.
Good Luck.
You have to select all values of your dbo.Mobs [MobItems] and save this as Mobs.csv [MobItems.csv]. Open your Monster.SData in shStudio and Import this two Files.
Good Luck.
Second Thanks for Reply . Dear Philipp__ .
i am Making but Some Error's Give ShStudio. Me Want to Only I am Have Monster.SDATA File Convert to Sql File, later Execute in Sql.
Just use the SELECT function to grab the info you want:
Code:
SELECT * FROM PS_[COLOR="Red"]DatabaseName[/COLOR].dbo.[COLOR="red"]TableName[/COLOR]
Fill in the DatabaseName and TableName parts with the real DB and Table names, obviously; like PS_GameData.dbo.Chars, or PS_GameDefs.dbo.Mobs, etc.
Before the next step, make sure you have SQL set to save the headers of the table, if you need them (if not, skip this). If this is for ShStudio, you will indeed have to do this. You'll find the option here:
SQL Management Studio Tools menu > Options > Query Results > SQL Server > Results to Grid > check box for "Include column headers when copying or saving the results" > Ok
You may want to restart Management Studio to make sure those changes take effect, in which case you will need to run the SELECT query again before moving on. Then, click on the top left square of the results window, the one that highlights the entire results grid. Right click, Save Results As... The save window pops up. Just make sure the file type is CSV, and you're good to go.
If this is specifically for making a Monster.EX for ShStudio, it goes a little further. Type the name of the file (Mobs or MobItems). Instead of just hitting the "Save" button, click the tiny black arrow next to it and select "Save with encoding". Change the dropdown option to ANSI, then hit OK and it should save. Then open the Monster.Sdata and File > Import, import BOTH files before saving, then save. A Monster.EX should have been generated.
1: Open Monster.Sdata on ShStudio 7.5.5.
2: Click on Tools>Scripts>Import Server Definitions (creat monsterEx.Sdata)
3:Click on File>Save and go to location of server data or search for monster.sql.
As someone point out above, first make sure you have SStudio set up properly,
then open Monster.SData and go to Tools>Scripts>Import Server Definitions and wait for SStudio to import data.
After that SAVE your Monster.SData and it will put Monster.sql in your PSM_Client folder
I've added screenshots to this post but somehow they won't show...
How to make .div file to size 128 kb every file ? 02/08/2010 - Dekaron Private Server - 1 Replies How to make .div file to size 128 kb every file ?
i got div file from some where 500 file and every file size 128 kb
how to make div file like that please guide .
:)
Monster.ini file - Boss Monster time and location 12/16/2008 - Zero - 2 Replies does any1 have the monster.ini file that tell you wen the boss monster appears and where it appears cause i think they mightve patched over the other 1. if any1 can find a way to get it to work again id be grateful. if u think u can help i can send u the other monster.ini file that used to work. Or if this isnt possible does any1 have spawn times for the bosses in neptune/green planet?
Either of those would be helpful
Thanks in advance
Monster Dat file 02/18/2006 - Conquer Online 2 - 10 Replies Hey all im kinda new so i was wondering if there is a way to change the monsters color to show if it has a good item super,mets,dragonballs, etc. I look in the search catergory of ConquerOnline 2 and i didnt see anything so i dont know if its possible but if it is id apperate it if someone made it!
