[Small-Guide] Remove Chat Emote
 

[Difficulty: Easy] :rollsafe:

1- Open HxD and put your game.exe in
2- Search for GetMsg Error %d
3- Select the GetMsg Error %d (the one near sysmsg-uni.txt)
4- Right click on it -> Fill Selection -> Hex Values : 00 -> Ok
5 - Save
6- Extract sysmsg-uni from the client
7- Open it and search for poses for victory
8- Delete the 10 lines of Emotes
9- Save and import in your data.sah
10- Done


[IMG=expandable: 1]http://epvpimg.com/Yu9saab[/IMG]

[Add new icons to your Shaiya icon]

The icon of Shaiya is in data/interface/icon.
Take a picture of the pet or weapons or costume you want has icon.
Resize it to 41 and 40 with Paint.
Put the white part invisible with photoshop (thanks google)
Now open icon_pet or other and import it correctly in photoshop
Now select your new icon with ShStudio
Don't forget to import it in your client to see it in game ;o

[Reset your kills when you got 1 millions kills and give a reward]

[Difficulty : Easy] :rollsafe:

1- Open SQL -> Connect -> New Query -> Paste this and execute:

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE PS_Gamedata.dbo.Chars ADD
Reset int NOT NULL CONSTRAINT DF_Chars_Reset DEFAULT 0
GO
COMMIT

2- Database -> PS_GameData -> Programmability -> Stored Procedures -> Right click on usp_Save_Char_Info_E -> Modify
3- Search for @[Only registered and activated users can see links. Click Here To Register...]point smallint -> Replace smallint to int
4- Add @[Only registered and activated users can see links. Click Here To Register...] int = 0 after @[Only registered and activated users can see links. Click Here To Register...] tinyint (don't forget the , )
5- Just before UPDATE Char Paste this:

IF (@K1 = '1000000') -- number of kills needed to reset
BEGIN
SET @K1 = '0'
SET @K2 = '0'
SET @[Only registered and activated users can see links. Click Here To Register...]Point = @[Only registered and activated users can see links. Click Here To Register...]Point + 25
SET @[Only registered and activated users can see links. Click Here To Register...] = '1'
END

6- In the UPDATE Chars add Reset = Reset + @[Only registered and activated users can see links. Click Here To Register...] just after leavedate=getdate(),
7- Execute
8- Done

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

could publish class exchange, I realized that you have enough sql knowledge

Can you explain better how this in-game action works?

I managed to use it but I would like a trigger within the game. that the player himself can make this change

Trigger is not the best for this, will work on it when I get time. Atm got a lot of work in rl so eh. Dw

Class Change with command in Game
 

[Difficulty: Medium]

This script would cost if it was made by someone who ask moni. Be happy you got it for free ;)

It is made in my versions, feel free to edit it to your version.

Will work only if your last 8 slots from your inventory is Free. To make them free remove the items on it and relog.

This script will not reply any message of success or fail, because I don't think you guys got private notice or private message. So we won't add a public notice that say "Alex succed change his class to Alien"... would be annoying... If you got private notice or private message, you can look at my Alex scripts release or a lil pm in discord or skype.

can you help me Version 3.
2- Open PS_ChatLag -> Programmability -> Right Click on usp_Insert_Chat_Log_E -> Modify

3- Paste this after the INSERT

i can't find INSERT
so when i add and execute got error!

[Only registered and activated users can see links. Click Here To Register...]

You can get my custom chatlog, the insert part is the sql part that insert the chatlog in ChatLog table.

can you tell me what area?
this is my insert_Chat_log_E

i try many time but i always
get this error

Msg 137, Level 15, State 2, Procedure usp_Insert_Chat_Log_E, Line 322
Must declare the scalar variable "@CharLevel".
Msg 137, Level 15, State 2, Procedure usp_Insert_Chat_Log_E, Line 339
Must declare the scalar variable "@CharLevel".
Msg 137, Level 15, State 2, Procedure usp_Insert_Chat_Log_E, Line 356
Must declare the scalar variable "@CharLevel".

maybe is because of missing declare

Just wrrite this Before: IF (@CharLevel = '15')

thank you its complete (work)