[Release] Cash Shop (cash.sdata) Editor

castor4878 · 02/04/2011, 04:21

This tool is superseded by

Release 0.6.1 (February 17)

As requested by one of you, you can now use your own list of icons (instead of the embedded one).
The tool does not contain a .dds decoder so you must save your icon file in bmp format and save it in the same directory than the tool with the "cashIcons.bmp" name. If such file is present it's used, otherwise embedded list is used.

The "icon picker" has also be redesign to no longer use the stupid 1-column mode of the system comboEx ctrls.

Release 0.6 (February 13th)

Please find below an update of the tool.
All changes are related to the GUI and allow easy management of the order of the products and the section in which they are placed.

User Guide:
- to insert new item: hit "Ins" (or Edit/Create Item)
- to delete an item: select it & hit "Del" (or Edit/Delete Item)
- to edit an existing item: double-click on it
- to change order of an item, select & drag it at new position
- to change the category of an item, drag & drop it over another tab caption - or change its bag value in edition dialog

Release 0.5 notes:

A tool was listed there to edit the cash.sdata file but it seems compliant with Episo.4 only.

So here is a new one. It does:
- read cash.sdata (in plain or ciphered),
- allow edition of all item mall items,
- save cash.sdata (in plain !! encrypt it before packaging for update) & cash.sql script that reset the whole ProductList table.

The available icons are those of AGE episo 5.2 plus some extra (already used by Xtreme, Spectral, Unity, ...), in case it's the interface/icon/icon_somo2.dds list.

Of course, *save* your cash.sdata file before any modif. attempt.

[ADM]Jade · 02/04/2011, 05:24

Nice Add.. I like it. However, encouraging others to dig through other peoples clients is uncalled for.

AGE is fine though.

taurian83 · 02/04/2011, 07:12

I haven't actually played with this yet as far as testing, however I did download and open my own cash.sdata to look around.

Very nice set-up. Nice job.

[GM]Recover · 02/04/2011, 07:53

very nice it is very easy to use

matran · 02/05/2011, 07:36

Nice!
my opinion is: "if you can change This software can read Unicode Font, that will be great"

taurian83 · 02/05/2011, 22:58

Quote:

Originally Posted by castor4878

I think you mean being able to read & display "ProductName" strings defined in Unicode ... sure it would be better.
One goal of this tool was to allow easy translation of name & description but so far for "simple" scripting languages only.

A planned development is to show the four categories as 4 different panels where each item is displayed more or less as in the in-game dialog (meaning with actual icon & description) with the possibility to reorder items and move them from 1 category to another by clic-n-drag.
I note your request in the wishes-list - thank for that feedback.

Edit: Analysis of Unicode support.

Not as easy as it may sounds...
Having the text (not numerical) edit ctrls in unicode was easy - I did test with font & it works fine.

The issue comes from the data, I except that texts in the .sdata file are stored with exactly the same format than in DB; if it's the case they are encoded in page code format (not unicode); SQL Studio can easily display these texts since it does know the code page for the DB and thus is able to do the code page to unicode translation; but when one handles the .sdata file (and that file only) the code page info is missing, translation to unicode and then display is thus not possible.

May be my assumption on format within the .sdata is wrong ... if you have a .sdata in not european/american language and the ProductList table, thank to post them to allow further investigation.

very nice idea. good luck. this is one area in which you all have my envy. I couldn't code a program to get myself out of a wet paper bag.

~~Alladrios~~ · 02/09/2011, 11:46

What a fantastic tool, thank you very much. This is going to be very useful.

[GM]Recover · 02/14/2011, 07:33

nice man the new version is mad

~~Alladrios~~ · 02/17/2011, 16:26

Very nice update, thanks.

~~Xx.LaMin.xX~~ · 02/17/2011, 20:07

thx verry much bro =).. and thx you alot that you accpeted my request

~~Xx.LaMin.xX~~ · 02/22/2011, 17:22

Hey i got this error

didnt get with old version now bothversion giving me this problem

Quote:

Msg 213, Level 16, State 1, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 2
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 3
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 4
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 5
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 6
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 7
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 8
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 9
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 10
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 11
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 12
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 13
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 14
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 15
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 16
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 17
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 18
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 19
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 20
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 21
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 22
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 23
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 24
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 25
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 26
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 27
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 28
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 29
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 30
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 31
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 32
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 33
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 34
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 35
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 36
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 37
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 38
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 39
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 40
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 41
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 42
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 43
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 44
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 45
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 46
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 47
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 48
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 49
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 50
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 51
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 52
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 53
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 54
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 55
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 56
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 57
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 58
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 59
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 60
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 61
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 62
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 63
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 64
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 65
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 66
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 67
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 68
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 69
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 70
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 71
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 72
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 73
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 74
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 75
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 76
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 77
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 78
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 79
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 80
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 81
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 82
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 83
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 84
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 85
Insert Error: Column name or number of supplied values does not match table definition.

This is Cash.Sql

Quote:

TRUNCATE TABLE [PS_GameDefs].[dbo].[ProductList];
GO
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Premium Package','PK_primm0001',2999,100075,1,100001,1,100 002,1,100003,1,100004,1,100043,1,100053,1,100056,1 ,100049,1,100081,1,100045,1,100046,1,30246,1,30247 ,1,30248,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Shaiya Package','PK_shaiy0001',999,100001,1,100042,1,1000 57,1,100083,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Etein Potion','B1_etain0001',150,100001,15,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Stats Initializing Stone','B1_setst0001',200,100048,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Skill Initialization Stone...','B1_setsk0001',200,100047,1,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Sex Change Scroll','B1_Cshap0001',100,100071,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Appearance Change Scroll','B1_Cface0001',100,100070,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Name Change Stone','B1_Charname0001',200,100136,1,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Normal Item Pocket','B1_SpBox0001',150,100078,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Hard Item Pocket','B1_SpBox0002',250,100079,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Ultimate Item Pocket','B1_SpBox0003',350,100080,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Lucky Box','B1_Mystery0002',100,100143,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Mystery Box','B1_UbBox0001',200,44186,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Mysterious Lapis Pocket','B1_Robag0001',298,100068,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('49 AP Mystery Box','B1_Mystery0001',49,100142,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Extraction Hammer','B1_Exthmr1000',349,100140,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Large Extraction Hammer','B1_Exthmr2000',499,100141,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Red Phoenix Charm','B1_RpChrm0001',400,100074,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Blue Dragon Charm','B1_BdChrm0001',200,100072,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('White Tiger Charm','B1_WtChrm0001',300,100073,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Teleportation Stone','B1_Telpstn1005',50,100065,5,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Lucky Charm','B1_Sftscrl0001',100,100139,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Increase EXP','B1_exper0007',498,100042,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Party Member Summon Rune','B1_Bcall0005',98,100045,5,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Linking Hammer','B1_inche0005',100,100049,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Eternal Endurance','B1_SIndu0007',98,100050,1,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Prevent of Item Drop...','B1_Sdrop0007',198,100052,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Warehouse Call Rune','B1_bcall0001',198,100054,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Prevent of EXP Drop','B1_Expno0002',598,100057,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Repair Hammer','B1_Repai0001',98,100066,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Double Warehouse','B1_Bactw0030',398,100075,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Increase Drop Gold','B1_Sgold0001',298,100083,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Mysterious Charm','B1_Mycha0001',598,100113,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Black Art Nostrum ','B1_Nosba0001',198,100012,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Small Sun EXP Stone','B1_Sasun0001',198,100109,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Lucky RemedyLv1','B1_Reluc0001',149,100032,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Dexterity RemedyLv1 ','B1_Redex0001',149,100029,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Knockout Nostrum','B1_Nosko0001',249,100010,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Wisdom RemedyLv1 ','B1_Rewis0001',149,100038,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Clean Hit Nostrum','B1_Nosct0001',149,100005,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Wizardship Nostrum','B1_Noswz0001',149,100007,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Remedy Set B package','PK_remed0002',249,100158,1,100161,1,1001 49,1,100155,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Remedy Set A package','PK_remed0001',249,100146,1,100149,1,1001 52,1,100155,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Defense Nostrum','B1_Nosdf0001',149,100006,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Sharp Shooter Nostrum ','B1_Nosss0001',198,100011,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Concentration Nostrum ','B1_Nosco0001',198,100013,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Intelligence Remedy Lv1','B1_Reint0001',149,100035,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Clean Hit Nostrum Lv1','B1_Nchit1008',98,100101,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Defense Nostrum Lv1','B1_Ndefc1008',98,100104,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Eihcim''s Competence Lv1','B1_PowHR0020',49,100121,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Strength RemedyLv1 ','B1_Restr0001',149,100023,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Lucky Charm','B1_Safesc0001',100,100139,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Ventsol''s AbilityLv1','B1_PowAP0020',49,100124,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Huckleberry''s Power Lv1','B1_PowRT0020',49,100118,1,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Reaction RemedyLv1','B1_Rerec0001',149,100026,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B1_Noswm0001',0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B1_Restm0001',0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B1_Mdrop0001',0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B1_Expno0001',0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B1_Sroul0005',98,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B1_Misun0001',0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B1_Rehel0001',0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B2_Mvcp0010',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B2_Mvbm0010',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B1_Nossp0001',0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B1_Reman0001',0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Free Space','B2_Mvbg0010',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Big Firecracker','B1_Firec0001',25,100115,3,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Love Firecracker','B1_Firec0002',49,100116,3,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Jumbo Firecracker','B1_Firec0003',49,100117,3,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('SK Butterfly Firecracker','B1_Firec0004',49,100128,3,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('7 day Continuous Resurrect...','B1_regem0001',100,100163,1,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('15 day Continuous Resurrec...','B1_tiregem0003',349,100164,1,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Termit long mantle','B2_HwgLM4801',500,39073,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Skay Long mantle','B2_HwgLM5401',1000,39074,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Zubelyou Long Cape','B2_HhaLM4801',500,39157,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Bestong Long Cape','B2_HhaLM5401',1000,39158,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Phukey Long Cape','B2_HpoLM4801',500,39243,1,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Hermit Long Cape','B2_HpoLM5401',1000,39244,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Revenge','B2_HfdLM4801',500,24073,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Vengeance','B2_HfdLM5401',1000,24074,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Feral','B2_HraLM4801',500,24157,1,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Savage','B2_HraLM5401',1000,24158,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Virtue','B2_HmfLM4801',500,24243,1,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Cape of the Sancitude','B2_HmfLM5401',1000,24244,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
GO

do you know how to fix it? thx

tkminh · 03/14/2011, 13:35

I meet the problem, after I extract Cash.sdata, then import back, run the game.exe, after select my character to start , the error display: game data load error

How can i fix this ? Plz help.

Da Boss · 06/29/2011, 16:20

@castor4878 Your a Legend, ty so much for this. By any chance when it asks for product code, would it matter what I used, or could I put custom product codes? ty

Guilades4 · 06/29/2011, 17:03

GREAT so now editing is going to be easyer and faster thanks!!

Da Boss · 06/29/2011, 17:16

This deserves to be stuck !