Please help me for mod the item mall

trabo · 03/18/2013, 19:54

Hi all.
I have a problem with the item shop.
I launched shaiya data file tool, I selected the data file in directorty of my game
With shaiya data file tool I extracted the data.saf on my desktop.
As soon as he finished, I opened sh study.
I opened the file Cash, I modified the costs of the item.
I On the server, I launched the game.exe but wrong.
tells me can not find the item.
How do I?
I have to connect to the database?
If you are like you?
I have to make the updater?

Please help me.
I miss this and I just finished

JohnHeatz · 03/18/2013, 20:57

You've described doing everything client sided and nothing done server sided. That's the hint I'll give you

trabo · 03/18/2013, 21:32

I have everything configured by the installer,
I have connected the server to the client,
I can connect and get with nick and pass
I know how to create a game account.

I need only configure the item mall
how do I do server side? please give me a hand xD
I do not know how to continue, I am following the guide, but a guide that explains everything else is right.
Please I'm almost at the end.
The only thing missing that

Thank you.

TeddyBear94 · 03/18/2013, 22:40

transform the *** **** cash.sdata to a cash.sql and run that in sql to update ur database <.<
dont forget to make a server restart and ur done.

trabo · 03/19/2013, 12:37

I realized I create cash.sql file, and then start with sql.
This fact do run and upgrade the item in the database.
As for the client?
I put the extracted files in the game folder?
or just the file cash.sdata and item.sdata?
Thank you for everything.

very nice

I edited the file with sh study cash.sdata.
I changed the price of an item.
I saved the format cash.sql
I open the file cash.sql, put run on sql.
and does not work.
are many errors, and I do not know what to do.
Please help me.

JohnHeatz · 03/19/2013, 15:55

Quote:

Originally Posted by trabo

I open the file cash.sql, put run on sql.
and does not work.
are many errors, and I do not know what to do.
Please help me.

And....we need to guess which errors you got? If you want help at least post important information

trabo · 03/19/2013, 16:30

thanks for the help, here's what appears

Message 213, Level 16, State 1, Line 1
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 2
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 3
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 4
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 5
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 6
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 7
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 8
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 9
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 10
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 11
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 12
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 13
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 14
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 15
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 16
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 17
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 18
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 19
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 20
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 21
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 22
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 23
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 24
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 25
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 26
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 27
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 28
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 29
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 30
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 31
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 32
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 33
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 34
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 35
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 36
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 37
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 38
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 39
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 40
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 41
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 42
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 43
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 44
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 45
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 46
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 47
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 48
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 49
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 50
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 51
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 52
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 53
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 54
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 55
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 56
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 57
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 58
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 59
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 60
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 61
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 62
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 63
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 64
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 65
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 66
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 67
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 68
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 69
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 70
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 71
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 72
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 73
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 74
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 75
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 76
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 77
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 78
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 79
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 80
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 81
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 82
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 83
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 84
Input error. The column name or number of supplied values does not match table definition.

Message 213, Level 16, State 1, Line 85
Input error. The column name or number of supplied values does not match table definition.

JohnHeatz · 03/19/2013, 17:26

Could you please post any of the lines from the query that are shown as giving errors? It is known that the tool you are using isn't that good when it comes to SQL queries, so it would be helpful to see what issues those created queries have.

nubness · 03/19/2013, 22:37

It's a mismatch between the dbo.ProductList and the query.
Your dbo.ProductList table MUST start with the column named ProductName, not RowID.

Quote:

Originally Posted by JohnHeatz

It is known that the tool you are using isn't that good when it comes to SQL queries

I would argue that.

JohnHeatz · 03/20/2013, 01:05

Sadly it actually has really a lot of issues with SQL Queries, but you are always defending it avoiding the real issues it has, so I won't get into a discussion about it, as all you'll do is bring in what it is good instead of see what the issues are with its queries.

But, if what you mentioned is the issue, then believe me, it isn't the database's issue

trabo · 03/20/2013, 09:36

Quote:

Originally Posted by JohnHeatz

Sadly it actually has really a lot of issues with SQL Queries, but you are always defending it avoiding the real issues it has, so I won't get into a discussion about it, as all you'll do is bring in what it is good instead of see what the issues are with its queries.

But, if what you mentioned is the issue, then believe me, it isn't the database's issue

so what do you advise me?
How do I proceed?

JohnHeatz · 03/20/2013, 09:55

Just follow what nubness has mentioned above, if that doesn't work, post in here any of the lines from the SQL Query that are shown in the error and so we can check on it.

trabo · 03/20/2013, 10:57

I changed the position between productname and row id in the table.
I rerun the file cash. sql, but appear the usual mistakes

This is file cash.sql

TRUNCATE TABLE [PS_GameDefs].[dbo].[ProductList];
GO
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Premium package','PK_primm0001',0,100075,1,100001,1,100002 ,1,100003,1,100004,1,100043,1,100053,1,100056,1,10 0049,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',849,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 ('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 ('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 ('Etein Potion','B1_etain0001',298,100001,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 ('Health Remedy','B1_Rehel0001',198,100002,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 ('Stamina Remedy','B1_Restm0001',198,100003,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 ('Mana Remedy','B1_Reman0001',198,100004,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 ('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 ('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 ('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 ('Spirit Nostrum','B1_Nossp0001',98,100008,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 ('Weapon Mastery Nostrum','B1_Noswm0001',98,100009,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 ('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 ('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 ('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 ('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 ('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 ('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 ('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 ('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 ('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 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 ('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 ('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 ('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 ('Blue Dragon Charm','B1_BdChrm0001',800,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',1800,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 ('Red Phoenix Charm','B1_RpChrm0001',2800,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 ('Teleportation Stone','B1_Telpstn1005',200,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',1499,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 ('Uber Mystery Box','B1_UbBox0001',299,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 ('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 ('Resurrection Rune','B1_regem0001',249,100044,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 ('Movement Rune','B1_Sroul0005',98,100046,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',298,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 ('Prevent of Item Drop','B1_Mdrop0001',98,100112,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 ('Prevent of EXP Drop','B1_Expno0001',98,100110,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 ('Mini Sun EXP Stone','B1_Misun0001',49,100108,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 ('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 ('Continuous Resurrection Ru...','B1_tiregem0003',349,100129,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 ('Capital Movement Stone','B2_Mvcp0010',249,100131,10,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 ('Bootleggery Movement Stone...','B2_Mvbm0010',398,100132,10,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 ('Arena Movement Stone','B2_Mvbg0010',298,100133,10,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 ('Lucky Charm','B1_Safesc0001',1499,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 ('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 ('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 ('Termit long mantle','B2_HwgLM4801',2999,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',2999,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',2999,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',2999,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',2999,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',2999,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',2999,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',2999,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',2999,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',2999,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',2999,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',2999,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)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Normal Item Pocket','B1_SpBox0001',249,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',299,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',399,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 ('Skill Initialization Stone...','B1_setsk0001',998,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 ('Stats Initializing Stone','B1_setst0001',998,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 ('Appearance Change Scroll','B1_Cface0001',398,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 ('Sex Change Scroll','B1_Cshap0001',698,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 ('Name Change Stone','B1_Charname0001',1998,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 ('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 ('249 AP Mystery Box','B1_Mystery0002',249,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)
GO

nubness · 03/20/2013, 11:37

You don't need RowID at all, that's the point.
Your query is trying to place some values into fields that don't accept them. Simply remove the RowID column.

And John, I really didn't see any problem with the queries generated by Shaiya Studio. I believe you're referring to the Skill.sql that completes with errors, those errors are totally irrelevant.

P.S. trabo, when posting your logs use a spoiler, it looks better.

trabo · 03/20/2013, 12:45

Quote:

Originally Posted by nubness

You don't need RowID at all, that's the point.
Your query is trying to place some values into fields that don't accept them. Simply remove the RowID column.

And John, I really didn't see any problem with the queries generated by Shaiya Studio. I believe you're referring to the Skill.sql that completes with errors, those errors are totally irrelevant.

P.S. trabo, when posting your logs use a spoiler, it looks better.

it works
works perfectly, I deleted row id.
Last thing:
1) before I extract the data with data file tool Shaiya
2) I make my changes, I will save the file cash.sql, and what I have changed.
3) convert the date extracted in data.sah.
4) I put everything in the game folder
5) run the cash.sql (work)
6) Launch the game

I think go well, or else a mistake?

Thank you for all