		elitepvpers › MMORPGs › Shaiya
[HELP] Cash.SData Execute Error

You last visited: Today at 05:19

Please register to post and access all features, it's quick, easy and FREE!

Advertisement

Advertise with us!

[HELP] Cash.SData Execute Error

Discussion on [HELP] Cash.SData Execute Error within the Shaiya forum part of the MMORPGs category.

05/04/2017, 20:25	#1
[DEV]MasterMind elite*gold: 0 The Black Market: 0/0/0 Join Date: Jun 2014 Posts: 29 Received Thanks: 4	[HELP] Cash.SData Execute Error This is my Cash.sql file, I really don't know where is the problem with it... It gives me error when I execute the code, which I will write below. Spoiler 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 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'. May you guys give me some tips or atleast tell me where is the error located in this code. Thanks in advance

05/04/2017, 22:27	#2
ResidentSH elite*gold: 0 The Black Market: 0/0/0 Join Date: Nov 2016 Posts: 2 Received Thanks: 0	Try this delete the ProductList and excute this and try again Spoiler USE [PS_GameDefs] GO /**** Object: Table [dbo].[ProductList] Script Date: 05/01/2016 16:59:24 ****/ 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

« Shaiya | GM commands »

Similar Threads
Deutsche Item.Sdata /Skill.Sdata /Monster.Sdata 05/27/2018 - Shaiya PServer Development - 3 Replies hey.. ich bin auf der suche nach den wie oben stehenden s.data´s.. ich habe alles scho durchsucht.. kann jedoch nichts finden :/ dank im vorraus.
[SUCHE]Episode 4.5 Item.sdata & Mosnter.sdata 11/19/2012 - Shaiya Private Server - 6 Replies Hallo EPVP wie der Titel schon sagt suche ich eine Deutsche Episode 4.5 Item.sdata & Monster.sdata MFG Oder ein Deutscher Episode 4 Client wäre auch Gut^^
[REQUEST]XXX.SDATA decryptor for episode 5 files+ npcquest.sdata 06/13/2012 - Shaiya - 1 Replies Can somebody help me with a SDATA decryptor and a episode 5 npcquest.sdata that is decrypted?
[HELP]Item.SData & NPCQuest.SData 02/28/2011 - Shaiya Private Server - 2 Replies Ok there is 2 parts to where I need help so let me try and explain this as clearly as I can so that someone can understand and hopefully come up with a solution. I have been trying to create an NPC of my own, and I have followed tutorials to the exact steps, and every time I make it and throw in my patch the NPC is always a cow Note that was editing it via in CSV format using a Open Office Table. Now I have even tried to modify an existing NPC through Hex (including the name, items, etc)...
NpcSkills.SData and NpcQuest.SData question 08/23/2010 - Shaiya Private Server - 1 Replies Time to time thinking about that, best releases by lipro had decrypted files and has new decrypted Sacra map mobs and boses but NpcQuest.SData and NpcSkill.SData are old files without New Sacra update, so Sacra NPC angel around portal is Cow and quests with Sacra are unable and all Sacra mobs cant use skills and cant attack so in game are bad effect if try to kill Sacra mobs - mobs use stup debuff and laggy toon and mobs etc. Anyone have decrypted this both files, or way to fix it? Thanks!

All times are GMT +2. The time now is 05:20.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.