shay data edit (0-1b)

09/23/2010 16:23 mooky#46
Hi, it's good i've changed format svmap to csv but now i've a problem of "layout" (i don't know if it's the good word, it comes from translator). When i open my map files, it's not in order and ununderstanding, i mean it's not like that :

Quote:
Originally Posted by ShaiyaUnited View Post
Prof and Clonaid Check the SS =)

[Only registered and activated users can see links. Click Here To Register...]
Someone can help me (again) please ?
(if needing, tell me and i will send a screenshot but it will be only friday night)
Mooky.
09/23/2010 20:13 signup_crap#47
Is anyone working on a script that can export .ITM files into properly formatted .CSV files?
09/23/2010 20:54 [GM]Father#48
Quote:
Originally Posted by signup_crap View Post
Is anyone working on a script that can export .ITM files into properly formatted .CSV files?
haha, yes. I was acually going to do that tonight.
09/23/2010 21:35 ProfNerwosol#49
Talking about something like this?
09/24/2010 00:05 signup_crap#50
I need script for this tool that can export the ITM files kind of how the MLT files are so they can be edited. Just curious if they are formatted in a similar way with separate "3DO", "Chain" and "DDS" parts that tell which model and texture to use for each item.

I've been able to create new armors by editing the MLT files, creating new DDS textures and updating the Item.SDATA and was curious on how to do that for other items like weapons.
09/24/2010 01:11 ProfNerwosol#51
Quote:
Originally Posted by signup_crap View Post
I need script for this tool that can export the ITM files kind of how the MLT files are so they can be edited. Just curious if they are formatted in a similar way with separate "3DO", "Chain" and "DDS" parts that tell which model and texture to use for each item.

I've been able to create new armors by editing the MLT files, creating new DDS textures and updating the Item.SDATA and was curious on how to do that for other items like weapons.
I extracted it manually when I needed to know which model/texture pairs to use to change armour appearance. ITM structure is simple. After 'ITM' you have number of 3DO's, then the names, after 3DO's number of DDS's. When DDS ends you get a nice big number which tells you how many 'weapons' there is. Everything is in that xls file I uploaded in the above post. Refer to my Guide To Shaiya Configuration if you don't know how to change armour appearance. Check my signature, the link is there.
09/24/2010 02:55 signup_crap#52
Ok I already know how to find which DDS file to re-skin to change the appearance of a weapon, but I'm wanting to add NEW items like I did with the armors. I can use the same models as existing weapons, but re-skin them. But I don't want to simply change the appearance of existing weapons.

For example:
If I wanted to add a new weapon called "Dagger of Uber" using the existing "Red Blood" model (09081.3DO) and re-skinning it with a new skin I create (ex. 99001.DDS) I need to change this info in the ITM files as well as the Item.SDATA and dbo.Items files right?

How can I export the ITM files, add the 3DO/DDS info for the new items and repack into ITM format again?

Sorry if I'm confusing you, or if you're answering me and I just don't get it. lol I'm also not good working with hex, so exporting to .csv and making changes, then repacking is how I do all my other files. Thanks for all help you can provide.
09/24/2010 10:43 ProfNerwosol#53
I left you a PM. Hope it helps.
09/26/2010 06:07 patoringa#54
Quote:
Originally Posted by nXu View Post
Mooky:

[Only registered and activated users can see links. Click Here To Register...]
Download the windows installer (Python2.7), and install it. It will create a folder "Python27" on drive C, and the python.exe will be inside there.
Now go to the downloaded Shaiya data edit, and open the .bat files with notepad. Where you see python commands, edit them to absolute paths (C:\Python27\python.exe)
Example:

map_csv.bat
Code:
python src\svmap.py %1
Change this to:
Code:
c:\Python27\python.exe src\svmap.py %1
:handsdown: Thx It worked for me. But ....

Comparing the file and table Cash.SData.CSV and ProductList I noticed a difference in the following fields:

CashSData.CSV

Code:
RowID,Category,Icon,ProductCode,ProductName,ProductDesc,BuyCost,ItemID1,ItemCount1,ItemID2... bla bla bla
ProductList

Code:
RowID, ProductName, ProductCode, BuyCost, ItemID1, ItemCount1, ItemID2... bla bla bla
ProductList has no fields "Category" and "Icon".

How can I resolve this conflict?
09/26/2010 10:00 signup_crap#55
Not all of the columns from the Cash.sdata file are used in the ProductList db file. This is the same for other sdata files too, such as Item.sdata, where there are columns for Model, Icon etc. Simply open the .csv file, remove the unneeded columns, arrange the column's order if needed to match how they appear in the db layout and save the csv file. Now you can import the csv data to your database using bulk insert or any other method you prefer.
09/26/2010 10:05 GM.Triest#56
I'm trying to extract the maps to csv format, but i'm having no luck,.... any help plz?
Or could someone extract all the maps for me and send them to me? plz

Thank you.
09/26/2010 13:05 ShaiyaUnited#57
Tell me your problem so i can help you.
09/26/2010 13:07 ProfNerwosol#58
Quote:
Originally Posted by patoringa View Post
ProductList

Code:
RowID, ProductName, ProductCode, BuyCost, ItemID1, ItemCount1, ItemID2... bla bla bla
ProductList has no fields "Category" and "Icon".

How can I resolve this conflict?
Because you don't need to know the icon and location of the item in database. Only client needs to know where to display it. Skip those two fields when inserting data to the table.
09/26/2010 18:05 GM.Triest#59
Well, i put all the svmap files on the " Input > Map " folder
then i go to the main folder and press " Map_csv.bat "
and a lil black window appears saying
" Press any key to continue.... "
I press any key but nothing happens O.O
09/26/2010 19:12 ProfNerwosol#60
Quote:
MAP EDITING:
Map extracting and combining requires you use the batch commands from command
prompt. This is because it accepts 1 parameter that is the map number.

Place the SVMAP file in
".\Input\Map\*.svmap"

Open command prompt and navigate to the programs root folder, then enter the
command along with the Map index you want to extract.

It will extract the file into several files located in
".\Output\Map\[Map_number]\*"

Example:
To extract 0.svmap into its respective CSV files in command prompt enter:
"Map_csv 0"
To re-combine it back into svmap type:
"Map_svmap 0"
Read the first post carefully. All you need to know is there.