Everything is correct, but i'm not sure about the ip address in game.exe file. As i said i'm not using any router or internet connection, so what my ip will be exactly? if anyone knows then please answer me.
Once again, verify the connection to the database first if the session does not run.... Login locally on the main SQL program, wit the user pass combination, do not use mixed auth this way, otherwise you wont know if its working or not. The name already in use comes up when u try to install the database twice or more due to errors... Try to remove the whole database, and all server files, the more times you do it, the better you get in it! FalconR try to lookup ur WAN ip and in CMD (start-run-type cmd-hit enter) ipconfig /all . Look on the local area network networkcard to see what your ip is, the easier way is to log on to it locally (127.0.0.1) This is a loopback adress and will automatically sent the game towards ur own computer, no way to put this server online tho if u use this ip everywhere, ull need public ip and the game.exe's ip to be public, or use the local area network card to play it in your network only. Some tutorials about editing the game.exe are in this forum already, and are not hard to find, as i said before, i will only discuss about the server part, the client you should be able to handle, if not, why even start on the server?
Did u check if there r errors in logsession file?
Sometimes is enough to restart manually but if all goes in pause maybe u got some problem in db.
Anyone can tell me how to insert a new toon directly by db?
INSERT INTO what_table (what_Column…)
VALUES (what_values…)
or something like this?
Its better not to add in a character manually this will only cause problems, its better to make it ingame. If you get the error name is already in use, the database is corrupted, and its better to start over at that point. Even at this point i dont know how to fully explain this, the only way is to try as i described before.
ok so most people cant find a mysql 2005 package but if u want a copy of it pm me and i'll send a link for it im not posting it as im unaware of the repurcussions and no its not from that BS forum R Z either
Hmm how i can build a SQL server Database ?? or i dont need
How i can make accounts
What exactly do u mean by that and do u mean u want to make an account manually if so find the account section of the database and run this query into it its user test123 and password abc1234
Thank you for your addition to this thread, i havent been able to complete my easy registration site, and thats why i didnt enclose it to my release. The fact that it works trough a md5 hash makes it more secure and makes it possible to run it on a local webpage (same machine as the server) so i guess with the whois additions, this should be able to work with the other published functions.
All the information should be in this thread to know how to solve problems etc, if you have any problems, ask here, and ill help as fast as possible, lately i have been very busy, so i couldnt check his thread every day, my excuses for that.
Currently im looking for a completed script to enclose to the release, and maybe a webserver to. I am not working anymore on the shaiya server itself, more on the scripts to access and maintain it. If anyone have an addition i can put in the release, let me know, i will look at it, and if its a good one, i will add it and ill put you in the credits!
ty danco... now i try to reinstall db but i dunno the right way to install it eheh. I followed instruction on frist post. Anyway i will retry. ty again
OK guys, here is my exact problem, as i mentioned before i dont have a router or internet on the comp i'm trying to setup the server. I use internet from one of my friend's comp. So as i told earlier i changed the ip in game.exe to 127.0.0.1
But still it says to check the notice board. i dont have any idea about what to do here. help me with it please. thanks.
I am using sql 2008 I thought I set up the server right but I think I am missing something I receive this error when starting the install_server program
This is an SQL related problem, nothin with my server, make sure there is not something that is using the ports of SQL.... Its not related to my published files, so therefor i dont give support for this, i already explained how to open the named pipes, this should do thr trick, just use a clean installation, reset ur router, open new ports etc, start from scratch. Good luck, but these basic questions dont get us nowhere . i recently tried to help a friend with this, got the same problem, the problem was because of some P2P programs, maybe that rings a bell?.. For all the people who have send me a private message, post your errors including screenshots in this thread, for i dont respond on private messages!!!!
grtz
[EDIT]
XPSP3 and SQL SERVER Standard 2005 is what i use, if u use another program, i dont give support anyway, come on people, follow the tutorial!!!! even my little brother can do it -.-'
what exactly do I need to download?
things I have downloaded:
SQL 2005 STANDARD.
Shaiya full client.
SHAIYA_SERVER_LITE_v0-12.zip.
MD5 hash maker for sql.
I need help, in PSMServer_Mgr, I start all server services, and all start up, but game stops running, what can I do to fix this?
I am running XP Pro. with Ms SQL Server 2008. The IP is right in the SQL and as far as I can till there all right in all the ini files, or seems to be.
[Guide] Shaiya Server Setup Clarification and Fixes 11/18/2014 - Shaiya PServer Guides & Releases - 30 Replies To setup a Shaiya EP3 or EP4 guide is rather easy, but alot of the guides can be unclear in some areas , and more don't have all of the answers, (how can they, when the errors come from people messing up guides >.< )
To setup a EP3 Server Please Follow ZeroSignal's Guide here Zero's Guide
If that is all you want then you are done !! lol
But you will most likely want to update that to EP4 to do so please use ProfNerwosol's guide located here: Prof's Guide
Follow the guide with all of...
pls help i have TV shaiya server setup 05/28/2010 - Shaiya Private Server - 0 Replies hi all pls help me git my shaiya up i am 100% confused i have 2005 SQL up
[email protected] is my msn
warboy. is my skype pls my friend is the main admin but we are stuck pls contact me tyvm if u help <3
to lookup ur WAN ip and in CMD (start-run-type cmd-hit enter) ipconfig /all . Look on the local area network networkcard to see what your ip is, the easier way is to log on to it locally (127.0.0.1) This is a loopback adress and will automatically sent the game towards ur own computer, no way to put this server online tho if u use this ip everywhere, ull need public ip and the game.exe's ip to be public, or use the local area network card to play it in your network only. Some tutorials about editing the game.exe are in this forum already, and are not hard to find, as i said before, i will only discuss about the server part, the client you should be able to handle, if not, why even start on the server? 
. i recently tried to help a friend with this, got the same problem, the problem was because of some P2P programs, maybe that rings a bell?.. For all the people who have send me a private message, post your errors including screenshots in this thread, for i dont respond on private messages!!!! 
