Guide me On Custom skills Please

how can i make custom skills for 5.4 ive downloaded Shaiya studio copied over the skill i wanted to base mine of off customized the values saved it then executed the sql file in my database with 0 errors restarted the server and logged in to find no custom skill at all

its there something i'm unaware of that i need to do on this to make it work is there a gm command i can use to try and insert this skill on my char or??

thank you

i just wasnt editing the right data.saf found the right one made the changes and it works now

You should update your Skill.sdata on client side as well and not only in sql.. Cause this is what it makes visual ingame. A sql doesnt do any changes ingame than the usage settings. To see changes like new skills at all, new skill level, skill icon or description you have to patch it.
Also be sure the class you wanna use it on is checked..

thank you

yes i wasn't editing the right file in shaiya studio i saved it the changes were added to the sql and server but not to my client changed it so i was editing the data.saf directly in my client and the skill data is there

nest i try making a custom npc this way=p
also

by the way do you know how to fix the item mall ingame got it so its not crashing the game at all when i open it and i can buy items from it but it only lets me buy 1 item

example i buy lucky charm
i try to buy knockout nostrum it wont let me however if i relog i can then buy the knockout nostrum but it wont let me buy lucky charm once ive bought the knockout nostrum

in other words its only letting me buy one item and wont let me buy anything else until i relog when i click the button it doesnt give me the item

ive already updated the cash sdata in the client and also my servers [PS_GameDefs].[dbo].[ProductList] with the new products


and my items disappear when i log off

Quote:

Originally Posted by beredas thank you yes i wasn't editing the right file in shaiya studio i saved it the changes were added to the sql and server but not to my client changed it so i was editing the data.saf directly in my client and the skill data is there nest i try making a custom npc this way=p also by the way do you know how to fix the item mall ingame got it so its not crashing the game at all when i open it and i can buy items from it but it only lets me buy 1 item example i buy lucky charm i try to buy knockout nostrum it wont let me however if i relog i can then buy the knockout nostrum but it wont let me buy lucky charm once ive bought the knockout nostrum in other words its only letting me buy one item and wont let me buy anything else until i relog when i click the button it doesnt give me the item ive already updated the cash sdata in the client and also my servers [PS_GameDefs].[dbo].[ProductList] with the new products and my items disappear when i log off

Execute this query and restart your server

USE [PS_GameData]
GO
/****** DoN-A ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[usp_Save_Char_Product_Item_E]

@[Only registered and activated users can see links. Click Here To Register...]ID tinyint,
@[Only registered and activated users can see links. Click Here To Register...]ID int,
@BankSlot tinyint,
@CharID int,
@ItemUID bigint,
@Bag tinyint,
@[Only registered and activated users can see links. Click Here To Register...] tinyint,
@ItemID int,
@[Only registered and activated users can see links. Click Here To Register...] tinyint,
@[Only registered and activated users can see links. Click Here To Register...]ID tinyint,
@Quality smallint, --int
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@MakeTimeZ varchar(50),
@Maketype varchar(1) --char(1)

AS
DECLARE @Maketime as datetime
SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120)

--SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @ProductCode varchar(20)
DECLARE @OrderNumber int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]Code bigint
DECLARE @BuyDate datetime

IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END

BEGIN DISTRIBUTED TRANSACTION

-- Logging receipt of goods
SELECT @ProductCode=ProductCode,@OrderNumber=OrderNumber @[Only registered and activated users can see links. Click Here To Register...]Code=VerifyCode,@BuyDate=BuyDate
FROM PS_Billing.dbo.Users_Product
WHERE UserUID @[Only registered and activated users can see links. Click Here To Register...]ID AND Slot=@BankSlot

-- Add inventory
INSERT INTO CharItems(CharID,Bag,Slot,ItemID,Type,TypeID,ItemU ID,Quality,Gem1,Gem2,Gem3,Gem4,
Gem5,Gem6,CraftName,[Count],Maketime,Maketype)
VALUES(@CharID,@Bag @[Only registered and activated users can see links. Click Here To Register...],@ItemID @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]ID,@ItemUID,@Quality,@Gem1,@Gem2,@Gem3,@Gem4,
@Gem5,@Gem6,@Craftname,@Count,@Maketime,@Maketype)

-- Deleting the bank storage
DELETE FROM PS_Billing.dbo.Users_Product WHERE UserUID @[Only registered and activated users can see links. Click Here To Register...]ID AND Slot=@BankSlot

IF( @@ERROR=0 AND @@ROWCOUNT=1)
BEGIN
COMMIT TRAN
RETURN 1
END
ELSE
BEGIN
ROLLBACK TRAN
RETURN -1
END

SET XACT_ABORT OFF
--SET NOCOUNT OFF