Shaiya Private Server - Instructions - English

Hello,

I have fixed my own problem, if input is needed let me know and I will be glad to share

I spoke to soon this is the error I have received, I have tried every thing I can think of to no avail
[Only registered and activated users can see links. Click Here To Register...]

@up
Plz upload files she gone !
THX

Hello all, my other computer is not working at the moment so I was trying to make my server on y other computer, yet I received an error when I start the install server file stating specified module could not be found if anyone has any ideas please let me know I would check my other computer but as I mentioned it is not working a this time

commands /vchkoff and /nprotectoff in one click
see - [Only registered and activated users can see links. Click Here To Register...]
-----------
he-he)
I did not know that you have a cold war)

ZS which sdata/lists should we use for translation of the DB item names/skills/mobs, ive looked at multiple and almost all have inconsistant matchings.

Quote:

Originally Posted by ZeroSignal You need to modify the Guild Stored Procedures so it correctly inserts all the info into the tables. Check the game log it will tell you which stored procs are failing. You may also need to edit some Guild Table MetaData so it has default values where necessary.

what do you mean with METADATA

ZeroSignal can u help me wen im on Server patch config an di make Server Setup and Apply Window registry nopes making nope restart pc nope
can u help me pls
PS: ive windows Vista Ultimate

Quote:

Originally Posted by oLago The procedures are adding null values to columns where nulls can't exist, thus it fails entering the guild. There are several between Guilds, and GuildDetails Tables, you need to change the default values of these colums to 0. You can do this one of two ways, first requires you to restart your pserver to get the subsequent error after fixing one [expect multiple restarts as the log will only give the first exception] or you can just go through the table and set all columns that do not except nulls to default bind of 0. If you choose the first, it might still save the characters as being part of a guild thus they will not be able to form or join another guild so you will have to remove them manually from the database.

Quote:

Originally Posted by oLago The procedure is failing on the first null value being inserted in a column where it will not allow a null value. There are multiple columns in the two tables where the procedure will not give a value [thus it will be null], but the log because of the failure on the first instance of it will only give the first column that fails. So to fix the first column you must set the default value to 0, then start the server, try forming a guild, look for the next column failure, shutdown the server, fix the second failed column [repeat these over and over again for all the columns that fail]. The table dealing with the guildhouse has similar issues as well.

This is what he means claude

this thing will not work. i do the whole thing by the book and shaiya doesnt even load. it just says 'cannot connect to server'

Quote:

Originally Posted by oLago This is what he means claude

my guild is in game but not in sql thats why im not understants if i restart server guild is gone in game and stil not in sql i have 2 servers rumming with the same errors no guild and portal to CT not open if someone can help me that my msn add me thnx
now my guild stay in game and in sql but if ppl add to guild i need to put then in sql dont do automatic why ????

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

Followed the guide and got everything working perfectly. Only issue we had was making the game public but thats cuz we thought to hard about the ip stuff then we figured out just to change the "PUBLIC" IP to Ext and leave the others local lol Man did I feel like a Noob.:facepalm: other then that everything was easy to figure out Thanks again

Hey man,...

I make all things like that on your post so when i open the game.exe with a hex editor i dont find it can you maybe tell me what i must search ? mean hex values,text string or what ever and the server patch config one question to when i start it, all works but 10 seconds after all is running all is paused and i dont know why can you maybe help me ?



Greetings Mike :handsdown::handsdown:

i dont understand the PSM_Service_Mgr part... I found another one deep in the PSM_Server folder and no matter which arrangement i tried to open and close, the red cross still there >.>
Tut said that the file was named 'PSM_Server\PSM_ServiceMgr.exe' but there is only 'PSM_Server\PSMServer_ServiceMgr.exe'. the other with the same name was in PSM_Client, so i dun know which one to use. What does it means by 'Close then re-open Server Patch Config'. Must I open ServiceMgr first or open that Server Patch Config. And also which one to close first. Im not really good at this and my server is not to increase the number of Private servers and not for money too. Just wanted to play with my sis >.<
Hope you can make a video or another reply on that particular part i dont understand. Just make it simpler for me to understand Q.Q
google only have 1 guide which is urs and another is in r a g e z o n e exactly the same as this

Well ima omplete and total idiot jk. Once i get every thing to start with the ">" sign it works then sessions goes back to a green mark. Wat am i doing wrong? plz help or can sum one make the whole thing copy it and send to me id be happy with that. after that i know wat to do but i cant get it all to begin

kelsimkel, this is how I fixed mine when it did the same thing.
Open your SQL Server Management Studio, sign in, go to any database for to Shaiya, like ps_billing and right click on it and go down to properties and click on it. A new window well pop up and on the upper left side you well see a list, click on files, and in the main screen you well see the path to well your database is, see if it is in D:\SHAIYA_SERVER\DATABASE. If it isn't then that is the problem, and if it is then I don't know. I had to reinstall the database.
Good luck