How to setup the famous Shaiya server without problems

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.

People,

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 [Only registered and activated users can see links. Click Here To Register...] 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?

Hope this helps,

Good luck.
Danco

Quote:

Originally Posted by baldracca 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.

Danco

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

Quote:

Originally Posted by skater_1997 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

(name,password) values('test123','3c6038d0a49e8d732544a0e9e887a35b ');

i created that with an Md5 hash

which ill attach(its from a different game but its used via mysql nd-t) so i guess it should work

Hey kinteroxeno,

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! :)

Thank you and good luck,

Danco

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

When i try to open game wit game.exe i get error Cannot connect to log in server
Or something like this wat i need to do

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
[Only registered and activated users can see links. Click Here To Register...]

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.

is there anything that I'm missing?

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.

is there anyway to make this server on vista????