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
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]
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 @point smallint -> Replace smallint to int 4- Add @ int = 0 after @ 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 @Point = @Point + 25 SET @ = '1'
END
6- In the UPDATE Chars add Reset = Reset + @ just after leavedate=getdate(),
7- Execute
8- Done
[Reset your kills when you got 1 millions kills and give a reward]
[Difficulty : Easy]
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 @point smallint -> Replace smallint to int
4- Add @ int = 0 after @ 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 @Point = @Point + 25
SET @ = '1'
END
6- In the UPDATE Chars add Reset = Reset + @ just after leavedate=getdate(),
7- Execute
8- Done
could publish class exchange, I realized that you have enough sql knowledge
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.
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.
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".
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
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
How to remove LoL chat and never again get chat restriction! 05/14/2018 - League of Legends Guides & Strategies - 3 Replies Why should you remove your chat in League of Legends?
How to disable chat in League of LegendsIt’s hard not to come by toxic players or feeders in League of Legends. As you progress through the ranks you will meet more and more toxicity and salt. One can try to explain it by their frustration of failing at something that they spent so much time on, the competitiveness of the game or anything else. The fact still stands that LoL is full of crying babies and trolls. That’s why Riot gave us...
Suche only Boss emote Sound Pack oder Guide zum MPQ Edit. 09/02/2014 - World of Warcraft - 3 Replies Hi, da ich weder über Google noch hier etwas zu diesem Thema gefunden habe mache ich einfach mal einen neuen Thread auf ;)
Ich habe zu Cata mal geänderte MPQ Dateien für den Sound gefunden in denen Quasi alle Sounds (Spells,Emotes etc) entfernt waren, so das ich Infight nur noch die Boss Stimmen hatte.
Da nun mit MoP massiv neue Spells eingefügt wurden, sind diese auch als Sound hörbar (alle alten Sounds sind nach wie vor nicht vorhanden)
Nun zur eigentlichen Frage, Kennt jemand eine...
[Request Help] Remove mobs / remove eur items / remove npc 02/15/2013 - SRO Private Server - 0 Replies Iam sure all now saies this guy is mad :D why not remove the db
i want to know how i can remove mobs from samrkand and add alex mobs there and remove eur item from npc and drobs
and remove some npcs
ty guys
_________________________
I see that there is too much help here
it's my topic no.2
without any answer
[Wts/Vk] Aion Wing emote/Flügel emote 03/05/2010 - Guild Wars Trading - 7 Replies Halli Hallo
Verkaufe hier 3x Aion Wing Emote
Ich habe interesse an Ingame stuff (Platin/Ektos oder auch Miniaturen)
Solltet ihr interesse an einem oder mehreren Codes habt, meldet euch einfach bei mir.
ICQ/MSN gibt es auf Anfrage
Ich möchte darauf hinweisen, das ich im normalfall immer erst abends ab 19 Uhr online kommen kann, da ich berufstätig bin.
![[Small-Guide] Remove Chat Emote](https://www.elitepvpers.com/forum/iconimages/shaiya-pserver-guides-releases/small-guide-remove-chat-emote_ltr.gif){kind=small}
point smallint -> Replace smallint to int
![[GameAdvisor]Finn's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar6941637_1.gif){kind=avatar}
