Discussion on [WIP] Shaiya Wings Slot (and trade faction tag) within the Shaiya PServer Guides & Releases forum part of the Shaiya Private Server category.
Hello everyone,
I am working on the new wing slot, wings are working well, but the problem is that I didn't fixed few pack issues yet with the new game.exe such as name and few minor issues.
So I made few smalls SQL work-around that should add letters(a kind of faction tag) to your player and guild names. So fury side player names will be "F-*Myplayername" and "L-*Myplayername" for the light side. This tag will only be visible on the tradechat.
Firstly, you'll need this game.exe:
Here are my sql scripts (if you want to "fix" the name issue):
see the rar with SQL files in attachements,
also, here are the update scripts:
PHP Code:
--Adding light tags UPDATE PS_GameData.dbo.Chars SET PS_GameData.dbo.Chars.CharName = CONCAT('L-*', PS_GameData.dbo.Chars.CharName) FROM PS_GameData.dbo.Chars INNER JOIN PS_GameData.dbo.UserMaxGrow ON (PS_GameData.dbo.UserMaxGrow.UserUID = PS_GameData.dbo.Chars.UserUID) WHERE PS_GameData.dbo.UserMaxGrow.Country=0;
--Adding fury tags UPDATE PS_GameData.dbo.Chars SET PS_GameData.dbo.Chars.CharName = CONCAT('D-*', PS_GameData.dbo.Chars.CharName) FROM PS_GameData.dbo.Chars INNER JOIN PS_GameData.dbo.UserMaxGrow ON (PS_GameData.dbo.UserMaxGrow.UserUID = PS_GameData.dbo.Chars.UserUID) WHERE PS_GameData.dbo.UserMaxGrow.Country=1;
--Adding light guild tags-- UPDATE PS_GameData.dbo.Guilds SET PS_GameData.dbo.Guilds.GuildName = CONCAT('L-*', PS_GameData.dbo.Guilds.GuildName) WHERE PS_GameData.dbo.Guilds.Country = 0;
--Adding fury guild tags UPDATE PS_GameData.dbo.Guilds SET PS_GameData.dbo.Guilds.GuildName = CONCAT('D-*', PS_GameData.dbo.Guilds.GuildName) WHERE PS_GameData.dbo.Guilds.Country = 1;
if you are not using shaiya pt or shaiya es game client, you might have to import the patch #173 from shaiya pt to your current game client to make wings working. (you can use this tool to get the patch , feel free to thanks nubness)
and then you'll need my Cheat Engine script (for server files 5.4 + ep6 dll)
But, please don't use it on your public server, and for tests only, it is still a work in progress, and not a final release. there is few bugs left.
NOTE: this archive also contains an Credits goes to him for the first script of the Cheat Engine table, you should use this script if you are using . BUT THIS IS OPTIONAL.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 5
Line 5: Incorrect syntax near 'MENTION=485444'.
Msg 155, Level 15, State 2, Procedure usp_Create_Char_R, Line 48
'ReT' is not a recognized CURSOR option.
Msg 137, Level 15, State 1, Procedure usp_Create_Char_R, Line 101
Must declare the variable '@money'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 101
Must declare the variable '@CharName'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 104
Must declare the variable '@CharName'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 105
Must declare the variable '@CharName'.
Msg 155, Level 15, State 2, Procedure usp_Create_Char_R, Line 112
'Status' is not a recognized CURSOR option.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 114
Line 114: Incorrect syntax near 'UserU'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 115
Line 115: Incorrect syntax near 'UserU'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 116
Line 116: Incorrect syntax near 'Status'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 118
Must declare the variable '@Admin'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 118
Line 118: Incorrect syntax near 'UserU'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 119
Must declare the variable '@CharName'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 121
Must declare the variable '@CharName'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 124
Line 124: Incorrect syntax near 'UserU'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 126
Must declare the variable '@CharName'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 129
Line 129: Incorrect syntax near 'UserU'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 131
Must declare the variable '@CharName'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 136
Line 136: Incorrect syntax near 'UserU'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 138
Must declare the variable '@CharName'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 143
Line 143: Incorrect syntax near 'UserU'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 145
Must declare the variable '@CharName'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 148
Must declare the variable '@CharName'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 149
Must declare the variable '@NameCnt'.
Msg 156, Level 15, State 1, Procedure usp_Create_Char_R, Line 153
Incorrect syntax near the keyword 'ELSE'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 155
Must declare the variable '@CharName'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 167
Line 167: Incorrect syntax near 'MENTION=485444'.
Msg 137, Level 15, State 1, Procedure usp_Create_Char_R, Line 173
Must declare the variable '@CharID'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 174
Must declare the variable '@CharID'.
Msg 137, Level 15, State 1, Procedure usp_Create_Char_R, Line 188
Must declare the variable '@CharID'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 190
Must declare the variable '@CharID'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 192
Line 192: Incorrect syntax near ']'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 5
Line 5: Incorrect syntax near 'MENTION=485444'.
Msg 155, Level 15, State 2, Procedure usp_Create_Char_R, Line 48
'ReT' is not a recognized CURSOR option.
Msg 137, Level 15, State 1, Procedure usp_Create_Char_R, Line 101
Must declare the variable '@money'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 101
Must declare the variable '@CharName'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 104
Must declare the variable '@CharName'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 105
Must declare the variable '@CharName'.
Msg 155, Level 15, State 2, Procedure usp_Create_Char_R, Line 112
'Status' is not a recognized CURSOR option.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 114
Line 114: Incorrect syntax near 'UserU'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 115
Line 115: Incorrect syntax near 'UserU'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 116
Line 116: Incorrect syntax near 'Status'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 118
Must declare the variable '@Admin'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 118
Line 118: Incorrect syntax near 'UserU'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 119
Must declare the variable '@CharName'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 121
Must declare the variable '@CharName'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 124
Line 124: Incorrect syntax near 'UserU'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 126
Must declare the variable '@CharName'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 129
Line 129: Incorrect syntax near 'UserU'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 131
Must declare the variable '@CharName'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 136
Line 136: Incorrect syntax near 'UserU'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 138
Must declare the variable '@CharName'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 143
Line 143: Incorrect syntax near 'UserU'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 145
Must declare the variable '@CharName'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 148
Must declare the variable '@CharName'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 149
Must declare the variable '@NameCnt'.
Msg 156, Level 15, State 1, Procedure usp_Create_Char_R, Line 153
Incorrect syntax near the keyword 'ELSE'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 155
Must declare the variable '@CharName'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 167
Line 167: Incorrect syntax near 'MENTION=485444'.
Msg 137, Level 15, State 1, Procedure usp_Create_Char_R, Line 173
Must declare the variable '@CharID'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 174
Must declare the variable '@CharID'.
Msg 137, Level 15, State 1, Procedure usp_Create_Char_R, Line 188
Must declare the variable '@CharID'.
Msg 137, Level 15, State 2, Procedure usp_Create_Char_R, Line 190
Must declare the variable '@CharID'.
Msg 170, Level 15, State 1, Procedure usp_Create_Char_R, Line 192
Line 192: Incorrect syntax near ']'.
so if i want that wings in my server, i have to do all again the items in that item.sdata? there not way to create wings in my item .sdata?
ant in the first script i have error
Msg 207, Level 16, State 1, Procedure usp_Create_Char_R, Line 125
Invalid column name 'GS'.
Msg 207, Level 16, State 1, Procedure usp_Create_Char_R, Line 131
Invalid column name 'GS'.
Msg 207, Level 16, State 1, Procedure usp_Create_Char_R, Line 136
Invalid column name 'GS'.
so if i want that wings in my server, i have to do all again the items in that item.sdata? there not way to create wings in my item .sdata?
ant in the first script i have error
Msg 207, Level 16, State 1, Procedure usp_Create_Char_R, Line 125
Invalid column name 'GS'.
Msg 207, Level 16, State 1, Procedure usp_Create_Char_R, Line 131
Invalid column name 'GS'.
Msg 207, Level 16, State 1, Procedure usp_Create_Char_R, Line 136
Invalid column name 'GS'.
Try to Add the "GS" column in User Masters and try
Quote:
Originally Posted by Trayne01
#scripts updated
Please try again now
Thanks for the scripts Trayne, but, this donīt works for me, canīt fix the nameīs
hello could pass me your PS_GameData because its not fix is fucionando with mine, and if possible can help me fix the visual bug that doing this , Pet costume and weapon did not appear in char selection screen
Boot and Glove incorrect in char selection screen
Gun, pet , costume and Asa were invisible to enter the char
how you did the ct file? could you teach us pls i want to learn how
did you any course of programming or something??
srry for my english i speak spanish
I want to learn to fishhhhh
I made this script by reading the tuts already posted here. Using this script: I found where the slots checks where stored and I edited them to add the slot id 16. So I found few asm like "CMP EAX, 15 JNZ BLZBLA" so now instead of 15, we got "CMP EAX, 16 JNZ BLABLA". It's definitely easy to do. But the packets issues linked to the new game.exe are harder to fix
I made this script by reading the tuts already posted here. Using this script: I found where the slots checks where stored and I edited them to add the slot id 16. So I found few asm like "CMP EAX, 15 JNZ BLZBLA" so now instead of 15, we got "CMP EAX, 16 JNZ BLABLA". It's definitely easy to do. But the packets issues linked to the new game.exe are harder to fix
I just took a look on your release and I am kinda surprised to see my script in somebody else's release, when you use something that is not made by yourself on your release, you should give him/her credits. It is not because you have to, just to be nice. Because according to your last post, it looks like you wouldn't be able to do it without my release.
I really don't care about credits but as far as I know It is not your first time so I wanted to let you know this is not nice at all. If we want to have a better community, as 'devs' you guys should be a 'role model' for everybody.
Game.exe Ep6.3 with slot wings 03/24/2022 - Shaiya PServer Guides & Releases - 8 Replies Can someone provide me game.exe ep 6.3 slot with wings?
Add Slot Wings and add Wings 02/04/2017 - Shaiya PServer Development - 12 Replies Anyone know how to add the slot to the wings and the wings with movement =P?