shay data edit (0-1b)

mooky · 09/23/2010, 16:23

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

Prof and Clonaid Check the SS =)

Someone can help me (again) please ?
(if needing, tell me and i will send a screenshot but it will be only friday night)
Mooky.

signup_crap · 09/23/2010, 20:13

Is anyone working on a script that can export .ITM files into properly formatted .CSV files?

[GM]Father · 09/23/2010, 20:54

Quote:

Originally Posted by signup_crap

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.

ProfNerwosol · 09/23/2010, 21:35

Talking about something like this?

signup_crap · 09/24/2010, 00:05

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.

ProfNerwosol · 09/24/2010, 01:11

Quote:

Originally Posted by signup_crap

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.

signup_crap · 09/24/2010, 02:55

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.

ProfNerwosol · 09/24/2010, 10:43

I left you a PM. Hope it helps.

patoringa · 09/26/2010, 06:07

Quote:
Originally Posted by nXu
Mooky:

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

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?

signup_crap · 09/26/2010, 10:00

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.

GM.Triest · 09/26/2010, 10:05

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.

~~ShaiyaUnited~~ · 09/26/2010, 13:05

Tell me your problem so i can help you.

ProfNerwosol · 09/26/2010, 13:07

Quote:
Originally Posted by patoringa
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.

GM.Triest · 09/26/2010, 18:05

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

ProfNerwosol · 09/26/2010, 19:12

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.