Troubles with Database

Zoas · 01/05/2014, 13:42

After editing my web mall with shStudio, I wanted to import all in my database.
Using this code I got:

Code:

TRUNCATE TABLE [PS_GameDefs].[dbo].[ProductList];
GO
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Ultimativ 30 day Package','PK_primm0001',30000,100043,1,100044,1,100053,1,100073,1,100075,1,100076,1,100053,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,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 ('Hard 30 day package','PK_shaiy0001',20,100043,1,100053,1,100056,1,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)
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Remedy Set A package','PK_remed0001',249,100146,1,100149,1,100152,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,100149,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
Msg 213, Level 16, State 1, Line 1
Column name or number of supplied values does not match table definition.

This error occured.
So I looked at my database files and i am in trouble.
I will show you some pictures to let you see what I mean.

I wondered now that I got no WEB_WebMall.
And normally now my problem with the product list should be away, but my productlist is still empty.
I would be very lucky if sb. would help me.

andr3y_you96 · 01/06/2014, 16:57

The webmal is not the ingame item mall.
Webmall is used if you want an item mall on your website.
You can find the product list items here [PS_GameDefs].[dbo].[ProductList]
just look at the query you run

Zoas · 01/06/2014, 17:56

yeah, ok item mall not ingame ok, but my main trouble is that my [PS_GameDefs].[dbo].[ProductList] is completly empty.
Using the upper code from shStudio, it was all empty

AxelMac · 01/06/2014, 19:53

Need remove or NULL RowID

andr3y_you96 · 01/06/2014, 20:17

Quote:

Originally Posted by Zoas

yeah, ok item mall not ingame ok, but my main trouble is that my [PS_GameDefs].[dbo].[ProductList] is completly empty.
Using the upper code from shStudio, it was all empty

you get any error runing the query for from cash.sdata?

if you do just remake it

Code:

USE [PS_GameDefs]
GO

/****** Object:  Table [dbo].[ProductList]    Script Date: 01/06/2014 20:23:28 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProductList]') AND type in (N'U'))
DROP TABLE [dbo].[ProductList]
GO

USE [PS_GameDefs]
GO

/****** Object:  Table [dbo].[ProductList]    Script Date: 01/06/2014 20:23:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ProductList](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[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
GO

this is my productlist table and i have no problem because the rowid is set to autoincremet
Axel you dont need to remove it. With this it will work

AxelMac · 01/08/2014, 17:43

Quote:

Originally Posted by andr3y_you96

Axel you dont need to remove it. With this it will work

i've write REMOVE or ADD NULL, use null is sufficient

Zoas · 01/10/2014, 14:14

Ok, thank to you two but doesn't worked I made it myself at last.

Autrux · 01/14/2014, 15:29

#closed as request