shaiya privateserver ReadMe

04/27/2009 17:56 yn126#1
╭════════════════╮
║ LovePrivateServer ║
╭════════┤ [Only registered and activated users can see links. Click Here To Register...] ├═════════╮
║ ║ MSN:[Only registered and activated users can see links. Click Here To Register...] ║ ║
║ ╰════════════════╯ ║
 ║ ¤ [Only registered and activated users can see links. Click Here To Register...]
║ ║
║ ¤if you also like privateserver,please join us¤ ║
║ ╭════════════════════╮ ║
║ ║ ║ ║
╰═══════┤ Network Sharing, Unlimited Resources ├══════╯
║ ║
╰════════════════════╯
hello everyone,this time i will teach us how to set up shaiya server..

************************************************** **************************

Stressed, the path should be "D:\SHAIYA_SERVER", because it has a file path is set up well, if on the other disk, or some other folder will result in service not to start up, if friends do not want to put here Please modify "PSM_Client\Config\PSM_Service.ini" path. Keep this in mind!

Of course, need to be reminded that the best of your database is MSSQL Server 2000 and must be marked with the service pack 4.
And then we begin to attach database.

OMG_GameWeb
PS_Statistics
PS_UserData
PS_GameDefs
PS_GameData
PS_Billing
PS_ChatLog
PS_GameLog
PS_GMTool
PS_Monitor

one by one to attach..
.
.
.
.

this time we still have a database to create..not attach,i dont know why but it can't attach..let us restore it..
create database name as "PS_UserLog",then restore it.like me..

Then we create a new user name is Shaiya, the password is kickit.Of course, your password can not be called kickit, but you need to modify a lot of configuration files, the back, we will explain in detail.

Open Query Analyzer,and execute following code.Its role is to establish a database link.

=============================code================= ============
if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'Shaiya','kickit'
================================================== =============

Server options there are five check,choice them.

Now, we need to start a Microsoft's own services..Otherwise, When friends enter the game will be dropped after the case.
"Distributed Transaction Coordinator" Set Startup type to Automatic and start it.

Then we have to do is replace the IP, this time we need to use a tool and it is a Chinese language interface,if friends can not read Chinese, just follow my operation can be okay...

Did you still remember the three batch file under the instal folder? Aware of their role in it? Then will show their Role this time.

First of all, we run "服务安装.bat",Translated into English is "install service.bat",its role is install the services which Shaiya need.Then we running "服务启动. Bat", his role is just to start the service which We have just installed..And another file called "服务停止.bat" is use to stop the serveices(Of course, we don't have to run it now)....:)

We can running PSM_ServiceMgr.exe under PSM_Server folder after we start the service.
selected Login01,modify IP for your IP, the application of the closure process, and restart the program! Not back to show the red cross!

selected Main,modify Account for your MSSQL account,modify Passwd for your MSSQL password and!
Select GameGroups01 modify IP and server name!
After the election all ready,selected Server Update --- click Update to all server (exe, data files ..

Finally, select the menu [Control Service]->Start All Server Service.When all the services into the Green Triangle,Close version checking..
Close version check
Login01 - Right click,then click Command pop-up dialog box enter "/vchkoff" (Does not include the quotation marks),Press Enter!

close NP verification
Game - Right click,then click Command pop-up dialog box enter "/nprotectoff" (Does not include the quotation marks),Press Enter!

OK, Done!!!! :)


If you have any problems, you can put then question on the forum.
*********AD**************************************

Advertising time----->[Only registered and activated users can see links. Click Here To Register...]

*************************************************
04/27/2009 17:58 yn126#2
shaiya privateserver File Download
[Only registered and activated users can see links. Click Here To Register...]


Client
[Only registered and activated users can see links. Click Here To Register...] ... 10-dna.exe

Sign browser
game.exe start game 192.168.1.111 ---- bat
04/30/2009 03:49 nubsy#3
Ok, I tried it out, and Im giving my feedback. I got MS SQL Server 2000. Used Pesonal Edition to be able to run it on Windows XP (so far only Personal and Developer are supperted by XP).

Im a total n00b in this DB, so it took quite some time till I found, how to restore those databases. But I got it done. Not attached, not imported, but restored. :) Made "Shaiya" user with appropriate password. Run query to create linked "game" server. After I got all DBs in SQL 2k I thought it would go easy, but I was mistaken.

Well, what happened after, I got server files to D:\SHAIYA_SERVER\SHAIYA just as the ini files require it. Installed 2 services from bat file and started them. After that I have started that Windows own service "Distributed something". Installed the service from client folder, after that installed the service from server folder.

Pfew... Seems Im rdy to go, that were my thoughts :D

Started that Server programm to tune up IPs and passwords and so on. Put my IP everywhere it was needed, somewhere I put external IP, somewhere I let localhost IP. After getting all info in it, restarted the programm. And there was a good sign - red crosses turned to green || (looks like "pause" on video player).Updated the server and after all klicked "Start all Services".Actually it had to work, green || go to green > ... But only for some seconds. First "Sessions" goes back to green ||, and after it all other do same.

After playing with logs, i think my particular problem is the connection to SQL... I probably made a mistake somewhere, but it was kinda late, so i stoped. Maybe tomorrow ill be able to give more feedback.

Id also appreciate, if u guys give me some clues :D Any help is welcome.
04/30/2009 18:36 nubsy#4
Got it running so far. Having troubles with client now. Starting shaiya client with "game.exe start game IP" seems to be ignored by the client. Cause after taking US loging im able to see US servers...
How have u solved it?
05/01/2009 07:24 ZeroSignal#5
Quote:
Originally Posted by nubsy View Post
Ok, I tried it out, and Im giving my feedback. I got MS SQL Server 2000. Used Pesonal Edition to be able to run it on Windows XP (so far only Personal and Developer are supperted by XP).

Im a total n00b in this DB, so it took quite some time till I found, how to restore those databases. But I got it done. Not attached, not imported, but restored. :) Made "Shaiya" user with appropriate password. Run query to create linked "game" server. After I got all DBs in SQL 2k I thought it would go easy, but I was mistaken.
How did you import the Databases? Did the files need to have extensions or something?
05/01/2009 23:02 nubsy#6
No, u dont need extensions, if u use sql 2000 server, just make a database with the name of the file u want to import, and then use "restore database" pointing to the right file.

Also i want to warn u before u start to work with that server files, modify the bat file which installes services. I put all those files in D:\SHAIYA_SERVER\SERVER. If u do same u have to modify only that one bat file which installes services.

When u got that server proggie running, with green > everywhere, u will have to modify the client to tell him to connect to ur IP. This is little tricky, but not hard to do. After u install official client, get u that NO GG game.exe so u dont have problems with GameGuard. After that, open that game.exe file with Hex Editor (i used "xvi32" - simple windows hex editor) and make text search, looking for official IP, after that just replace the official IP with ur IP using replace function. If u dont know the official IP, use firewall, like Sygate Firewall (Private version is free to use) to find out where the official client is trying to connect to.

If u need more help, feel free to ask here, i had quite some troubles getting this server running, but now i got it done, and will help others if i can.
05/02/2009 04:48 nubsy#7
Next thing i cant get running is PSGMTool.exe
Any ideas on it?
05/03/2009 03:23 destroyer667#8
Hey nubsy i would like alittle more help with this, would u beable to help me Step by step? i have some knowledge of my own with running servers but with different games so im not a complete idiot so you shouldn't get frustrated with helping me :] heres my Msn, [Only registered and activated users can see links. Click Here To Register...] i've downloaded the files needed but i just need alittle more of a boost to get things going. the 2 servers ive seen out right now i dont really like so... please help me out thanks.
05/03/2009 18:46 nubsy#9
Im not often in MSN, only used it to contact yn126, ill try to add u, but we also can try to set up ur server using this forum. Tell what have u done so far?
05/03/2009 22:22 Destroyer666#10
hi nubsy^^

i get stuck at the same point as u...

Quote:
"Actually it had to work, green || go to green > ... But only for some seconds. First "Sessions" goes back to green ||, and after it all other do same."
next post u wrote was that u having probs with the client....it would be nice if u let other ppl here know how u solve the prob^^

the client is easy but im think a bit far...so how we will register accounts later?? orginal shayia and extreme uses a web site..so we maybe must set up a webserver for that too??

other thing in my mind are how we make GS accounts?? or changing exp, drop rates etc...

thought we should help us all to get more servers running and tell our expiriences here...

when i got my server runnning i will delete it and do it all again and write a step by step instrucion for all...cause its realy a bit difficult to understand what yn126 mean sometimes^^

what i wonder too is..i had several p-servers and all need the data files from the client....did this one didnt need any data files?? like the data.saf file??

btw here are the codes GS and players used in game ( some in korean or so, so dont blame me for gibbersih^^)

/°æº¸
/alert
/°æº¸
/apowercan
/±ÇÇÑÃë¼Ò
/apower
/±ÇÇѺο©
/chatcolor
/äÆÃÄ÷¯
/shutdown
/¼*¹ö´Ù¿î
/server off
/¼*¹öÁ¦ÇÑ
/server on
/¼*¹öÁ¦ÇÑÃë¼Ò
/aban
/À¯Àú¹ê
/abancan
/À¯Àú¹êÃë¼Ò
/akick
/À¯Àúű
/nera
/NPC»èÁ¦ %s %d %d
/nmake
/NPC»ý¼º %d %d
/mera
/¸÷»èÁ¦
/mera t
/¸÷»èÁ¦ t
/¸÷»ý¼º %s %hu %d
/mmake %s %d %d %d
/getitem
/recallitem
/¸®ÄݾÆÀÌÅÛ
/imake
/»ý¼º
/set
/¼ÂÆÃ
/ban
/¹ê
/bancan
/¹êÃë¼Ò
/kick
/ű
/eventrem
/À̺¥Æ®»èÁ¦
/eventadd
/À̺¥Æ®Ãß°¡
/event off
/À̺¥Æ®Á¾·á
/event on
/À̺¥Æ®½ÃÀÛ
/questrem
/Äù½ºÆ®»èÁ¦
/pvpoff
/pvpon %s %s %d
/questadd
/Äù½ºÆ®Ãß°¡
/questoff
/Äù½ºÆ®´Ù¿î %s %d
/queston
/Äù½ºÆ®¿ÀÇÂ
/eclear
/ÀåÂøÃ»¼Ò
/iclear
/Àκ¥Ã»¼Ò
/noautocure
/ÀÚµ¿Ä¡·áÇØÁ¦
/autocure
/ÀÚµ¿Ä¡·á
/cure
/Ä¡·á
/bnotice
/Á¾Á·°øÁö
/znotice
/¸Ê°øÁö
/notice
/°øÁö
/wnotice
/±Ó°øÁö
/cnotice
/ê°øÁö
/gmnotice
/¿î¿µÀÚ°øÁö
/Á¾Á·°øÁöÇØÁ¦
/¸Ê°øÁöÇØÁ¦
/°øÁöÇØÁ¦ dump
/±Ó°øÁöÇØÁ¦
/ê°øÁöÇØÁ¦
/guildpoint
/±æµåÆ÷ÀÎÆ®
/guildrank
/±æµå¼øÀ§
/guildgrade
/±æ¿øµî±Þ
/mob
/¸÷º¸±â
/item
/¾ÆÀÌÅÛº¸±â
/partysummon
/ÆÄƼÀ̵¿
/bsummon
/ij¸¯Á¸À̵¿
/asummon
/ij¸¯À̵¿
/quiry
/Á¶È¸
/stopoff
/À̵¿±ÝÁöÇØÁ¦
/stopon
/À̵¿±ÝÁö
/silence
/ä±Ý
/silence off
/ä±ÝÇØÁ¦
/cwatch off
/´ëÈ*°¨½ÃÇØÁ¦
/cwatch
/´ëÈ*°¨½Ã
/watch
/°¨½Ã
/warning
/°æ°í
/gmove
/±æÁ¸À̵¿
/tacticszone
/xcall
/Áø¿µ¼Òȯ
/itemlv
/cmove
/¸ÊÀ̵¿
/bmove
/Á¸À̵¿
/amove
/À̵¿
/attack off
/°ø°ÝÇØÁ¦
/attack on
/°ø°Ý¼³Á¤
/char off
/Åõ¸íÇØÁ¦ %s %u
/¸÷Á¤º¸
/char on
/Åõ¸í¼³Á¤ %s %s
/UQCOUNT
/UQGET
/basic
/point
/wire
/time
/join
/Âü¿©
/party
/ÃÊ´ë
/town

i've tried most out but didnt have GM or alike status lol

so most wont work for me maybe on my own server..but if someone tries them out and get results pls post em here^^ thnx..

greets all
05/04/2009 23:54 ZeroSignal#11
Thanks heaps nubsy I'm pretty sure I got the Server running, I just haven't added any user accounts yet.

Regarding the GMTool, no luck for me, are you sure it's the full version as it is in an Update directory?
05/05/2009 03:10 Paga#12
Quote:
Originally Posted by nubsy View Post
Got it running so far. Having troubles with client now. Starting shaiya client with "game.exe start game IP" seems to be ignored by the client. Cause after taking US loging im able to see US servers...
How have u solved it?

I'm at this point and I have this problem,the command to the file bat is ignored by the client.
Can you tell how to solve please?
05/05/2009 05:20 ZeroSignal#13
Quote:
Originally Posted by Paga View Post
I'm at this point and I have this problem,the command to the file bat is ignored by the client.
Can you tell how to solve please?
For US:
Open up the game.exe client in a hex editor, use find and enter "72.55.177.194". When it's found change it to your Login Server IP Address.

edit:
I can open the client executable, and I'm positive that its going to the local Login Server, however I get a Username/Password invalid error.
Just entering a random username, or some valid US version usernames brings up Account does not exist, so it must be at least looking in the table.
I noticed that EncPassword was NULL, does that need to be set? What's wrong with the user account record? Any1 got any ideas?
[Only registered and activated users can see links. Click Here To Register...]

Just one more thing under Services shaiya_server and shaiya_serverf keep ending, is that an issue?
05/05/2009 08:16 destroyer667#14
Im having alittle trouble with sql 2000.. Does anyone know where i can get sql 2000 English version? i can figure out alot on my own but this stupid download is no wheres to be found -.- maybe i just suck at looking but a link would be helpful thanks
05/05/2009 11:45 ZeroSignal#15
Quote:
Originally Posted by destroyer667 View Post
Im having alittle trouble with sql 2000.. Does anyone know where i can get sql 2000 English version? i can figure out alot on my own but this stupid download is no wheres to be found -.- maybe i just suck at looking but a link would be helpful thanks
I downloaded a SQL 2000 Evaluation Edition (120 days) from Isohunt. SQL 2000 SP4 was downloaded from M$.