TRUNCATE TABLE [PS_GameDefs].[dbo].[ProductList];
GO
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Recreation Rune','recreationrunewe',0,100171,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','redphoenixwe',50,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 ('Movement Rune x15','movementwe',10,100046,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 ('Party Member Summon Rune x15','summonwe',10,100045,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 ('Warehouse Recall Rune','warehousewe',5,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 ('Union Summon Stone x10','unionsummonwe',25,100230,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 ('Target Resurrection Rune x10','targetresswe',50,100067,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 Recall Rune x100','ahwe',10,100132,100,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,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 Recall Rune x100','capitalwe',10,100131,100,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,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 Recall Rune x100','arenawe',10,100133,100,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,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 x10','savingplaceswe',10,100065,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 ('Clean Hit Nostrum','nonstrumche1we',5,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','nostrumche2we',5,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','nostrumche3we',5,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 ('Health Remedy Lv3','healthnostrumwe',10,100019,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 ('Stamina Remedy Lv3','staminanostrumwe',10,100016,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 ('Mana Remedy Lv3','mananostrumwe',10,100022,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','skillresetwe',150,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','statresetwe',150,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','appearancewe',250,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','sexchangewe',350,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','smenqisiimetowe',250,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 ('Big Firecracker x10','firecracker1we',1,100115,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 ('Love Firecracker x10','lovefirecrackwe',1,100116,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 ('Jumbo Firecracker x10','jumbowe',1,100117,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 ('Power Lapisia of Syeeric','powerlapisianwe',10,95002,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 Lapisia of Syeeric','defenselapisianwe',10,95007,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 ('Linking Hammer Lv7','linkingwe',9,100194,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 ('Operator''s Exclusive','linking2we',50,100082,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','extractvaiwe',10,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','kusmetlii4owe',10,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 ('Splinter of Elimental x10','enchantwe',100,38006,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 ('Tears of Goddess x10','wenchant2we',100,38008,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)
GO
GO
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Recreation Rune','recreationrunewe',0,100171,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','redphoenixwe',50,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 ('Movement Rune x15','movementwe',10,100046,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 ('Party Member Summon Rune x15','summonwe',10,100045,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 ('Warehouse Recall Rune','warehousewe',5,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 ('Union Summon Stone x10','unionsummonwe',25,100230,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 ('Target Resurrection Rune x10','targetresswe',50,100067,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 Recall Rune x100','ahwe',10,100132,100,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,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 Recall Rune x100','capitalwe',10,100131,100,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,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 Recall Rune x100','arenawe',10,100133,100,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,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 x10','savingplaceswe',10,100065,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 ('Clean Hit Nostrum','nonstrumche1we',5,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','nostrumche2we',5,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','nostrumche3we',5,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 ('Health Remedy Lv3','healthnostrumwe',10,100019,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 ('Stamina Remedy Lv3','staminanostrumwe',10,100016,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 ('Mana Remedy Lv3','mananostrumwe',10,100022,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','skillresetwe',150,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','statresetwe',150,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','appearancewe',250,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','sexchangewe',350,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','smenqisiimetowe',250,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 ('Big Firecracker x10','firecracker1we',1,100115,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 ('Love Firecracker x10','lovefirecrackwe',1,100116,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 ('Jumbo Firecracker x10','jumbowe',1,100117,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 ('Power Lapisia of Syeeric','powerlapisianwe',10,95002,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 Lapisia of Syeeric','defenselapisianwe',10,95007,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 ('Linking Hammer Lv7','linkingwe',9,100194,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 ('Operator''s Exclusive','linking2we',50,100082,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','extractvaiwe',10,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','kusmetlii4owe',10,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 ('Splinter of Elimental x10','enchantwe',100,38006,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 ('Tears of Goddess x10','wenchant2we',100,38008,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)
GO
Error Message:
Code:
Msg 4701, Level 16, State 1, Line 1 Cannot find the object "ProductList" because it does not exist or you do not have permissions. Msg 208, Level 16, State 1, Line 1 Invalid object name 'PS_GameDefs.dbo.ProductList'.
Thanks in advance






