[Small-Guide] Remove Chat Emote

01/28/2019 22:50 JujiPoli#1

[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

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

02/02/2019 15:20 JujiPoli#2

[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

02/03/2019 14:51 JujiPoli#3

[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...]

02/03/2019 23:49 ShaiyaIwanttolearn#4

Quote:

Originally Posted by JujiPoli

[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

02/04/2019 20:53 XareL#5

If you want class exchange, you can use this mini query.

02/05/2019 09:42 ShaiyaIwanttolearn#6

Quote:

Originally Posted by XareL

If you want class exchange, you can use this mini query.

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

02/06/2019 17:06 JujiPoli#7

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

02/09/2019 23:34 JujiPoli#8

[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.

Version 1

Version 2

Version 3

Version 4

02/21/2019 02:15 [GameAdvisor]Finn#9

Quote:

Originally Posted by JujiPoli

[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.

Version 1

Version 1: Free Version (do not need any points or ... just use the command)

1- Create 2 new tables (Named Class Stats) 1 in PS_ChatLog and 1 in PS_GameData.

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

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

2- Open PS_ChatLag -> Programmability -> Right Click on usp_Insert_Chat_Log_E -> Modify

3- Paste this after the INSERT

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

4- Open PS_GameData -> Programmability -> Right Click on usp_Save_Char_Info_E -> Modify

5- Paste this before the UPDATE

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

6- Go in game and write !class fighter

7- Relog, done. Enjoy.

Version 2

Version 2: Free version with: if you are dark the class stay dark, if you are light the class stay light.

1- Create 2 new tables (Named Class Stats) 1 in PS_ChatLog and 1 in PS_GameData.

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

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

2- Open PS_ChatLag -> Programmability -> Right Click on usp_Insert_Chat_Log_E -> Modify

3- Paste this after the INSERT

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

4- Open PS_GameData -> Programmability -> Right Click on usp_Save_Char_Info_E -> Modify

5- Paste this before the UPDATE

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

6- Go in game and write !class fighter

7- Relog, done. Enjoy.

Version 3

Version 3: Cost version (points)

1- Create 2 new tables (Named Class Stats) 1 in PS_ChatLog and 1 in PS_GameData.

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

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

2- Open PS_ChatLag -> Programmability -> Right Click on usp_Insert_Chat_Log_E -> Modify

3- Paste this after the INSERT

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

4- Open PS_GameData -> Programmability -> Right Click on usp_Save_Char_Info_E -> Modify

5- Paste this before the UPDATE

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

6- Go in game and write !class fighter

7- Relog, done. Enjoy.

Version 4

Version 4: Cost version (points) with: if you are dark the class stay dark, if you are light the class stay light.

1- Create 2 new tables (Named Class Stats) 1 in PS_ChatLog and 1 in PS_GameData.

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

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

2- Open PS_ChatLag -> Programmability -> Right Click on usp_Insert_Chat_Log_E -> Modify

3- Paste this after the INSERT

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

4- Open PS_GameData -> Programmability -> Right Click on usp_Save_Char_Info_E -> Modify

5- Paste this before the UPDATE

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

6- Go in game and write !class fighter

7- Relog, done. Enjoy.

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!

02/23/2019 12:05 JujiPoli#10

[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.

02/23/2019 12:37 [GameAdvisor]Finn#11

Quote:

Originally Posted by JujiPoli

[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

Spoiler

02/23/2019 12:42 JujiPoli#12

Code:

BEGIN
SET [MENTION=806297]sql[/MENTION] = N'
INSERT INTO PS_ChatLog.dbo.ChatLog
(UserUID, CharID, ChatType, TargetName, ChatData, MapID, ChatTime)
VALUES [MENTION=2805776]UserU[/MENTION]ID, @CharID, [MENTION=2266852]chatty[/MENTION]pe, [MENTION=336840]target[/MENTION]Name, @ChatData, [MENTION=619529]Mapi[/MENTION]D, @ChatTime)'

EXEC sp_executesql [MENTION=806297]sql[/MENTION], 
N [MENTION=2805776]UserU[/MENTION]ID int, @CharID int, [MENTION=2266852]chatty[/MENTION]pe tinyint, [MENTION=336840]target[/MENTION]Name varchar(30), @ChatData varchar(128) [MENTION=619529]Mapi[/MENTION]D smallint, @ChatTime datetime',
 [MENTION=2805776]UserU[/MENTION]ID, @CharID, [MENTION=2266852]chatty[/MENTION]pe, [MENTION=336840]target[/MENTION]Name, @ChatData, [MENTION=619529]Mapi[/MENTION]D, @ChatTime
END

02/23/2019 14:17 [GameAdvisor]Finn#13

Quote:

Originally Posted by JujiPoli

Code:

BEGIN
SET [MENTION=806297]sql[/MENTION] = N'
INSERT INTO PS_ChatLog.dbo.ChatLog
(UserUID, CharID, ChatType, TargetName, ChatData, MapID, ChatTime)
VALUES [MENTION=2805776]UserU[/MENTION]ID, @CharID, [MENTION=2266852]chatty[/MENTION]pe, [MENTION=336840]target[/MENTION]Name, @ChatData, [MENTION=619529]Mapi[/MENTION]D, @ChatTime)'

EXEC sp_executesql [MENTION=806297]sql[/MENTION], 
N [MENTION=2805776]UserU[/MENTION]ID int, @CharID int, [MENTION=2266852]chatty[/MENTION]pe tinyint, [MENTION=336840]target[/MENTION]Name varchar(30), @ChatData varchar(128) [MENTION=619529]Mapi[/MENTION]D smallint, @ChatTime datetime',
 [MENTION=2805776]UserU[/MENTION]ID, @CharID, [MENTION=2266852]chatty[/MENTION]pe, [MENTION=336840]target[/MENTION]Name, @ChatData, [MENTION=619529]Mapi[/MENTION]D, @ChatTime
END

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

02/23/2019 16:04 Wa7dani#14

Quote:

Originally Posted by [GameAdvisor]Finn

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

Code:

DECLARE @CharLevel int

Before: IF (@CharLevel = '15')

Code:

IF (@CharLevel = '15')
BEGIN
SET [MENTION=351675]stat[/MENTION]point = '126'
 IF (@Family = '0' and @Job = '0')BEGIN SET [MENTION=414808]str[/MENTION] = [MENTION=414808]str[/MENTION] + '14' END
 IF (@Family = '0' and @Job = '1')BEGIN SET [MENTION=1400467]rec[/MENTION] = [MENTION=1400467]rec[/MENTION] + '14' END
 IF (@Family = '0' and @Job = '5')BEGIN SET [MENTION=2031046]Wis[/MENTION] = [MENTION=2031046]Wis[/MENTION] + '14' END
 IF (@Family = '1' and @Job = '3')BEGIN SET [MENTION=391860]luc[/MENTION] = [MENTION=391860]luc[/MENTION] + '14' END
 IF (@Family = '1' and @Job = '2')BEGIN SET @DEX = @DEX + '14' END
 IF (@Family = '1' and @Job = '4')BEGIN SET @INT = @INT + '14' END
 IF (@Family = '3' and @Job = '0')BEGIN SET [MENTION=414808]str[/MENTION] = [MENTION=414808]str[/MENTION] + '14' END
 IF (@Family = '3' and @Job = '1')BEGIN SET [MENTION=1400467]rec[/MENTION] = [MENTION=1400467]rec[/MENTION] + '14' END
 IF (@Family = '3' and @Job = '3')BEGIN SET [MENTION=391860]luc[/MENTION] = [MENTION=391860]luc[/MENTION] + '14' END
 IF (@Family = '2' and @Job = '4')BEGIN SET @INT = @INT + '14' END
 IF (@Family = '2' and @Job = '2')BEGIN SET @DEX = @DEX + '14' END
 IF (@Family = '2' and @Job = '5')BEGIN SET [MENTION=2031046]Wis[/MENTION] = [MENTION=2031046]Wis[/MENTION] + '14' END
 END

02/23/2019 16:20 [GameAdvisor]Finn#15

Quote:

Originally Posted by Wa7dani

Just wrrite this

Code:

DECLARE @CharLevel int

Before: IF (@CharLevel = '15')

Code:

IF (@CharLevel = '15')
BEGIN
SET [MENTION=351675]stat[/MENTION]point = '126'
 IF (@Family = '0' and @Job = '0')BEGIN SET [MENTION=414808]str[/MENTION] = [MENTION=414808]str[/MENTION] + '14' END
 IF (@Family = '0' and @Job = '1')BEGIN SET [MENTION=1400467]rec[/MENTION] = [MENTION=1400467]rec[/MENTION] + '14' END
 IF (@Family = '0' and @Job = '5')BEGIN SET [MENTION=2031046]Wis[/MENTION] = [MENTION=2031046]Wis[/MENTION] + '14' END
 IF (@Family = '1' and @Job = '3')BEGIN SET [MENTION=391860]luc[/MENTION] = [MENTION=391860]luc[/MENTION] + '14' END
 IF (@Family = '1' and @Job = '2')BEGIN SET @DEX = @DEX + '14' END
 IF (@Family = '1' and @Job = '4')BEGIN SET @INT = @INT + '14' END
 IF (@Family = '3' and @Job = '0')BEGIN SET [MENTION=414808]str[/MENTION] = [MENTION=414808]str[/MENTION] + '14' END
 IF (@Family = '3' and @Job = '1')BEGIN SET [MENTION=1400467]rec[/MENTION] = [MENTION=1400467]rec[/MENTION] + '14' END
 IF (@Family = '3' and @Job = '3')BEGIN SET [MENTION=391860]luc[/MENTION] = [MENTION=391860]luc[/MENTION] + '14' END
 IF (@Family = '2' and @Job = '4')BEGIN SET @INT = @INT + '14' END
 IF (@Family = '2' and @Job = '2')BEGIN SET @DEX = @DEX + '14' END
 IF (@Family = '2' and @Job = '5')BEGIN SET [MENTION=2031046]Wis[/MENTION] = [MENTION=2031046]Wis[/MENTION] + '14' END
 END

thank you its complete (work)