Problem with game item mall.

[krisko6]

Hey everyone,
I used ShStudio to edit my Cash.Sdata , it took me an hour to add all item codes and etc. When i seved the file i took SQL file everything were going very good. But when i tried to execute the filed it gave error on everything. I added the Cash.Sdata and resterted the server. When i tried again it didn't work.
Good is the game still working fine and when i use item mail it says me that there is no item (it was someting like that xD).
Please tell me where is my mistake.I hope my work be usefull.

Yeah my english is bad , but i'm sure you still understand me

Thank You!

[nubness]

Originally Posted by krisko6

[...] ShStudio [...]

Oh ***, why ?
I suggest you do it , it always works perfectly.

[[ADMIN]Cryptic]

what nubness said but otherwise tell us what error you got in SQL.

[Sh1nra]

Try this:

USE [PS_GameDefs]
GO
/****** Objekt:  Table [dbo].[ProductList]    Skriptdatum: 12/05/2012 18:44:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
DROP TABLE [dbo].dbo[ProductList]
CREATE TABLE [dbo].[ProductList](
 [ProductName] [varchar](50) NOT NULL,
 [ProductCode] [varchar](20) NOT NULL,
 [BuyCost] [int] NOT NULL,
 [ItemID1] [int] NOT NULL,
 [ItemCount1] [tinyint] NOT NULL,
 [ItemID2] [int] NULL,
 [ItemCount2] [tinyint] NULL,
 [ItemID3] [int] NULL,
 [ItemCount3] [tinyint] NULL,
 [ItemID4] [int] NULL,
 [ItemCount4] [tinyint] NULL,
 [ItemID5] [int] NULL,
 [ItemCount5] [tinyint] NULL,
 [ItemID6] [int] NULL,
 [ItemCount6] [tinyint] NULL,
 [ItemID7] [int] NULL,
 [ItemCount7] [tinyint] NULL,
 [ItemID8] [int] NULL,
 [ItemCount8] [tinyint] NULL,
 [ItemID9] [int] NULL,
 [ItemCount9] [tinyint] NULL,
 [ItemID10] [int] NULL,
 [ItemCount10] [tinyint] NULL,
 [ItemID11] [int] NULL,
 [ItemCount11] [tinyint] NULL,
 [ItemID12] [int] NULL,
 [ItemCount12] [tinyint] NULL,
 [ItemID13] [int] NULL,
 [ItemCount13] [tinyint] NULL,
 [ItemID14] [int] NULL,
 [ItemCount14] [tinyint] NULL,
 [ItemID15] [int] NULL,
 [ItemCount15] [tinyint] NULL,
 [ItemID16] [int] NULL,
 [ItemCount16] [tinyint] NULL,
 [ItemID17] [int] NULL,
 [ItemCount17] [tinyint] NULL,
 [ItemID18] [int] NULL,
 [ItemCount18] [tinyint] NULL,
 [ItemID19] [int] NULL,
 [ItemCount19] [tinyint] NULL,
 [ItemID20] [int] NULL,
 [ItemCount20] [tinyint] NULL,
 [ItemID21] [int] NULL,
 [ItemCount21] [tinyint] NULL,
 [ItemID22] [int] NULL,
 [ItemCount22] [tinyint] NULL,
 [ItemID23] [int] NULL,
 [ItemCount23] [tinyint] NULL,
 [ItemID24] [int] NULL,
 [ItemCount24] [tinyint] NULL,
 CONSTRAINT [PK_ProductList] PRIMARY KEY CLUSTERED 
(
 [RowID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Credits: banned Zeus

[krisko6]

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
-
Msg 213, Level 16, State 1, Line 64
Insert Error: Column name or number of supplied values does not match table definition.

And down SQL says:
Query completed with errors.
_________________________________________

Sh1nra's code didn't work.Thanks anyway.
I will try the hard way xd

[Sh1nra]

Originally Posted by krisko6

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
-
Msg 213, Level 16, State 1, Line 64
Insert Error: Column name or number of supplied values does not match table definition.

This are the errors from my script?

[[ADMIN]Cryptic]

Run the script Sh1nra posted. Your problem is you have to many (or to few) columns. Your table probably doesnt match the script SH tool prints out.

to prevent this problem you could also have done the SQL manually.

[JohnHeatz]

#Moved to the right section

[krisko6]

This are the errors from my script?

The errors what i posted yesterday are from ShStudio's file.

The error what your script gives me is :

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'ProductList'.

Originally Posted by [ADMIN]Cryptic

Run the script Sh1nra posted. Your problem is you have to many (or to few) columns. Your table probably doesnt match the script SH tool prints out.

to prevent this problem you could also have done the SQL manually.

What can i do manually i can add new columns or i should add all items codes and etc? And where i can find game item mall in SQL?
Thanks.

[Sh1nra]

You have dbo.ProductList ?

[krisko6]

Originally Posted by Sh1nra

You have dbo.ProductList ?

Yes i have it and i checked in side but there is no item in it.

[[ADMIN]Cryptic]

try deleting it and remaking it.