Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Tut]Shaiya Private Server Instructions

Newbie Spellweaver
Joined
Mar 25, 2009
Messages
51
Reaction score
20
Probably is available in view of table Maketaime from dbo.CharItems? At it type by default 'datatime' (i am not assured)

try to make so..
 
Initiate Mage
Joined
Sep 14, 2009
Messages
3
Reaction score
0
Ok, found and changed but problem remain... i tried to reboot system and always the same error "name already in use". I checked in db to see and now Maketime is a varchar(50).. boh, im stuck

ty anyway

P.S.
Then i installed all on my laptop (vista, mssql2008). Exactely same problem "name already in use". I think something wrong in db but what? Oo
 
Last edited:
Initiate Mage
Joined
Jun 30, 2009
Messages
3
Reaction score
0
hi all fellow pserver creators , i am seriously not doin as elite as all you peeps , i am only getting to install.bat , then reboot and i am not getting green X's in server config , id be happy to use TeamViewer for anyone wanting to investigate the issue , i have Windows Server 2003 , and MSSQL server 2005 Enterprise , hope to hear a reply
 
Initiate Mage
Joined
Sep 23, 2009
Messages
4
Reaction score
0
I'm utterly confused right now, i've followed the instructions quite closely, however when i try to connect to the Server i get the error "Connection with server has been disconnected Error 0" any ideas? i've done the /nprotectoff command and that stuff too.
 
Newbie Spellweaver
Joined
Mar 25, 2009
Messages
51
Reaction score
20
1. show me the IP address of the server and the machine with which you plugged (by executing cmd-> ipconfig / all on the computer where the server and where the client)
2. show me ... \SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config\ps_ game.ini
3. show me .. \SHAIYA_SERVER\SERVER\PSM_Server\Config\PSMServe r_Config.ini
-------
and see errors in PSM_Client\Bin\Log
 
Last edited:
Initiate Mage
Joined
Sep 23, 2009
Messages
4
Reaction score
0
1. show me the IP address of the server and the machine with which you plugged (by executing cmd-> ipconfig / all on the computer where the server and where the client)
2. show me ... \SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config\ps_ game.ini
3. show me .. \SHAIYA_SERVER\SERVER\PSM_Server\Config\PSMServe r_Config.ini
-------
and see errors in PSM_Client\Bin\Log
my ip is 192.168.1.203
ps_game.ini
Code:
ERVER]
ServerName=Game01
ServerPort=
MaxConnection=10
[CONNECTION]
Session=192.168.1.203
UserLog=192.168.1.203
DBAgent=127.1.0.0
GameLog=127.1.0.0
[DB]
GameDef=192.168.1.203, PS_GameDefs, Shaiya, 5BEB15B94CD150954D8FD66756F71B003B58D01CB4F7C73FA6879D3C6CF2A36552C8225D39E50F37DD5D1ADA099AD0DEE4BEE75B832DFB83139BF1B167C678C2AACC7BAD21DEC32A35976BC9E34F934193D9FCF206FD5D8F8AD5781260EB74A1DDC6728946D111BFFDC05CA88A42F49755BCF46749F0F3C43A382D37AB229495
GameData=192.168.1.203, PS_GameData, Shaiya, 165A64F771E31A05BE480A44B71EDDA2A67A5A16BCBD42E0CF9825381E72F2B06CCED3BA751DB6C8DC07E7CF7773369D9609FD03051C0CF5987116A884BE5DD4FE4724F597E5851C8FD2DABE2F3FEE7AA7FD769F86F476D08DCE5FDA0B1B729588879CB25EFF62382A7165DD36F829A3C2EB36E7E7E9C2BF42CB0B384525D97C
[GAMEINFO]
GameName=Game
GamePublicIP=192.168.1.203
GameVersion=0x08022100
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

PSMServer_Config.ini
Code:
[Main]

  <ip_session> = 192.168.1.203

  <ip_userlog> = 192.168.1.203

  <db_user>    = 192.168.1.203, PS_UserData, Shaiya, 3AFD42D3F967EB069C3BF2EA444838D19AEB4E3694AEB4B445C5F6FE8E2D93BF82F6C50B4D2A0B9F2BF83E7AAF0C6B110B3C2AC47CC1F9B30FDCA45D100D6BD619F74A755F13F4B0A2DF0CBB9432F6181BB88412C33318D4046BE4368D7998522B46A2096C46873B35CE8BF248F91D86DF55CE1BD28ADD08FC5CA6949396A093



[Login_001]

  <sv_maxuser>  = 10

  <ip_login>    = 192.168.1.203



[GameGroup_001]

  <sv_maxuser>     = 10

  <sv_gameversion> = 0x08022100

  <sv_gamename>    = Game

  <sv_publicip>    = 192.168.1.203

  <ip_game>    = 192.168.1.203

  <ip_dbagent> = 127.1.0.0

  <ip_gamelog> = 127.1.0.0

  <db_game>    = 192.168.1.203, PS_GameData, Shaiya, 9952E08E603D9FBD7959C9A8CED070EA6F35DB3F4A040143D9EC5221828E6010E1B06CBA59CE24C906FE7CDA64D88671C3B553E2131768FD425E929CB288B50181733C5682CB30378D0D32BEC58FE30BEB929E2E6E5799DD44DC043CBDE895CC287ED37BB20A77B7602218109A536AE28C17CF9B3E0ECA17A735AC03BF124A51

  <db_gamedef> = 192.168.1.203, PS_GameDefs, Shaiya, 6D5806E0695E8E2CFF42AC38BE323B63C1224B04ACCA909EE2E16B2E687A03A92E39413F2D6CE8731DA96DD7B4E051B13F81FECD31F0B5FC788E910612A6D96E1D243B2CC1D29E89289EB9B7472CD490527CEEAFE4A09237F0D9736C46B93D23D778F57FB3325A4E1679E1C4EE3DDA9B8CF18C8A6E7A04248721731A65BF4F24

  <db_gamelog> = 127.1.0.0, PS_GameLog, Shaiya, F93225C60A7E86595D128968DEC1B527FE6EDC274225EC7F5915249ABF780BAE932F3552AD13C3F186CD748D81509EDE9CCE605E468CBB6F093C2AA231E932D045FF7911840909BAA799006EFD74265D5991DDF3DC39092E0F319E49713FF9F26EF4A307C0306277473CA707370EDC9A29CBE9C2F57C127C898D890938309CF5

  <db_chatlog> = 127.1.0.0, PS_GameLog, Shaiya, E901998D950E95913BD55440BEC470D7384627BD39A577C7BBCC3BA9F60918D97A54C57B2E9C9EFBFF91DC0DD81F986FF382F8E205C19527170C2E524203215327E23CE1834D573C5F37FADC84BA4848ABAB4358A325DC1ACA96CBDA9F5110083D09577DAE3786BC9B3DB18D4A217F1580FCB5DF0D45F680DC5F3294E606DA58
 
Newbie Spellweaver
Joined
Mar 25, 2009
Messages
51
Reaction score
20
if the client and server are on the same computer (unless you use a virtual machine (VM)), then write anywhere 127.0.0.1
do not forget about / vchkoff and changed using hex editor on the ip 127.0.0.1 in game.exe
--------------
if you write in the configuration of 192.168.1.203, then write it everywhere
and check PSM_Client \ Bin \ Log
-----------
example:
If I connect to the server within the my subnet (192.168.1.x) I use this:
...\SHAIYA_SERVER\SERVER\PSM_Server\Config\PSMServer_Config.ini
Code:
[Main]
  <ip_session> = 192.168.1.3
  <ip_userlog> = 192.168.1.3
  <db_user>    = 192.168.1.3, PS_UserData, Shaiya, B1ABF53976A1982D7C4A2E1A7F42D6EA81CABE150F0063F21FF8A1E8801C2747EEFCFB1B1B9FF06862E94ACAD969DDE3E4D31603B7A3D921C0936E0F1F7BDEB283DCF29998DE12AF591C2080930A1F7DCE7350CFC6F3CCE8BA1EE0A4D3BF27A1C9367670A1393380B7C336E2E0857EB27CF8637BAAD8E6C129765C2E5A609404
[Login_001]
  <sv_maxuser>  = 10
  <ip_login>    = 192.168.1.3
[GameGroup_001]
  <sv_maxuser>     = 10
  <sv_gameversion> = 0x00000000
  <sv_gamename>    = Game
  <sv_publicip>    = 192.168.1.3
  <ip_game>    = 192.168.1.3
  <ip_dbagent> = 192.168.1.3
  <ip_gamelog> = 192.168.1.3
  <db_game>    = 192.168.1.3, PS_GameData, Shaiya, 05779109709EC867F8F88B577D64F83556E336A7D0FFB30FD571F5A8F7E4FCF37E3EA3E6E40E9875E57EB8F73C8B0A187E9DBE12188767AF32F56ECD3C3ACB134705421E6D02A3EC6A067004FDA11085C124C1488655C2F71F92D157D6BD0CAED8B555B9264502B0F32D8541F726571A857F159694AB7DB3B71709E537F025A5
  <db_gamedef> = 192.168.1.3, PS_GameDefs, Shaiya, 7C0CD8F95C21EC2DF008EDE78464ACB781CFEBB433C72CF97408E35AAE48A3870E94F429DECE2188AB9D6BDEC8CD7815BA70A7D429113A243A8910B4FE9D328A10B5BCD21DE0201A03EBB09674DCE350F4BF06A6407FC5A93B6EE6260EF38B54AD4E7B1F3D28E36772BDE3D6D5F45F08FE6AE6C69D29A2CD498F8ADD2701671D
  <db_gamelog> = 192.168.1.3, PS_GameLog, Shaiya, 7DD444854F85A62E4017BBE3962B5E48F77B2FC0428D20167A4526B7E7775B0E8D47CDCD2669BCAEB452C1216E962482DD879C692D56329BDC797166638E6B0BFCEAC3B2485E665F43494367365465CCB6B46F3CA254DC99A49B103900DDCE96EEB24EF0814DBA3D93EA4A37994F5EFDE34CB43559EBA4A496B96916EFEC167D
  <db_chatlog> = 192.168.1.3, PS_GameLog, Shaiya, 627126AB86466CD4EB872F876440C773C29C08FCB78A09777F308685E7EB9E3820708FD185604057DAC31B727D82D99EE913F37A6AA3C8D4A1C0E10F8E9F593AF11066CF327525C8E1BA7273097A14965C4DA73F604162D4190CF04E0FE5476128ED2F5CA6B86C505AE379FB66011FD7BEC5E2E9A1F7C325C7818A02DF522CF3
...\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config\ps_game.ini
Code:
[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=10
[CONNECTION]
Session=192.168.1.3
UserLog=192.168.1.3
DBAgent=192.168.1.3
GameLog=192.168.1.3
[DB]
GameDef=192.168.1.3, PS_GameDefs, Shaiya, 6C8DB9E6855CDB4C67CDDAA53E2F9E24E096AE76F1178383C31C5AD7E1A819B2AB5323A2BFBC34153590D10370F3EC6DE1A4B0EE1F473B7887045A04AD7AFA276F91D36D85DA282826FC7B78A5A174EE0A3C2AD5E3A022E4F4BAAF2B077C9430EC6987105493948106A51108C2435E58F045A0C806B4A248F03D0A2D77800A91
GameData=192.168.1.3, PS_GameData, Shaiya, BF7D69A385D01E5DE337ED047256087C7E740061C7283316F61E7ABC2C53985D1E40C72C788DC81A42A141DF49DA648825EF7B4069BD7CAB7C86AD7CCC434BAD05399C31BFD3686A1B11D2AEF062628CF9D612C59CACF7B6FF245BB24E65E78DF33718C54E7D2463D2201172FFF07E41C8292F308B990EC931A7E0FB203EC5B6
[GAMEINFO]
GameName=Game1
GamePublicIP=192.168.1.3
GameVersion=0x00000000
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
In this case, my client ip 192.168.1.3
--------------------------------------
If I connect to the server from outside network, then these ip changed to:
Code:
<sv_publicip>    = 212.26.x.x
and
GamePublicIP = 212.26.x.x
and client ip=212.26.x.x
 
Last edited:
Initiate Mage
Joined
Sep 23, 2009
Messages
4
Reaction score
0
Ok so i changed all of that to the correct ip's. Now i have a different problem, the little icons won't change from the pause signs, or they will but they will revert back after a short period of time. It was working earlier just fine too.
I have Win XP Pro SP3
and M$SQL Server 2008 Enterprise

Edit: I've seen fixes but they haven't worked

I solved it ^.^ the password got changed...
 
Last edited:
Newbie Spellweaver
Joined
Aug 24, 2009
Messages
12
Reaction score
0
i have made a private server only problem is its public not local and when i tell my buddy to try logging in it says :login data load error ? how can i fix this ?
 
Initiate Mage
Joined
Aug 5, 2009
Messages
4
Reaction score
0
Ace uf y want to help me please help me wit this i dont know how to make and yes i google it Mixed Mode Authentication Win NT & SQL Authentication
 
Newbie Spellweaver
Joined
Oct 11, 2009
Messages
11
Reaction score
4
I started playing with SQL Server 2005 Express. I managed to make most of the services working but got stuck with one of them. I am not sure what is wrong, as it is the only one that cannot establish connection to the database. I'll post both log and the configuration file. Could someone scroll through and see if they can come up with a solution? Thank you.

Code:
[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=10
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDefs=TOMMO\SQLEXPRESS, PS_GameDefs, Shaiya, 

6C8DB9E6855CDB4C67CDDAA53E2F9E24E096AE76F1178383C31C5AD7E1A819B2AB5323A2BFBC3415

3590D10370F3EC6DE1A4B0EE1F473B7887045A04AD7AFA276F91D36D85DA282826FC7B78A5A174EE

0A3C2AD5E3A022E4F4BAAF2B077C9430EC6987105493948106A51108C2435E58F045A0C806B4A248

F03D0A2D77800A91
GameData=TOMMO\SQLEXPRESS, PS_GameData, Shaiya, 

BF7D69A385D01E5DE337ED047256087C7E740061C7283316F61E7ABC2C53985D1E40C72C788DC81A

42A141DF49DA648825EF7B4069BD7CAB7C86AD7CCC434BAD05399C31BFD3686A1B11D2AEF062628C

F9D612C59CACF7B6FF245BB24E65E78DF33718C54E7D2463D2201172FFF07E41C8292F308B990EC9

31A7E0FB203EC5B6
[GAMEINFO]
GameName=Game
GamePublicIP=127.0.0.1
GameVersion=0x08022100
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

Code:
2009-10-11 17:53:39 PS_GAME__system log start (Game01)

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/sorp1

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/croco1

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/croco2

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/Troll1

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/Spink1

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/GoldenPig

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/Sorp3

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/SorpNamed1

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/SorpNamed2

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/Sorp2

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/CrocoNamed1

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/CrocoNamed2

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/CrocoNamed3

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/OrcNamed1

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/OrcNamed2

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/OrcNamed3

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/TrollNamed1

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/Deinos

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/Parridalis

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/Alcarian

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/ZinAlcaria

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/Belizabeth

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/Kirhiross

2009-10-11 17:53:39 Loaded Behavior In Factory : data/ai/CrypticOne

2009-10-11 17:54:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]TCP Provider: [COLOR="Red"]Nie można nawiązać połączenia, ponieważ komputer docelowy aktywnie go odmawia.[/COLOR]

, SQL STATE: 42000, NATIVE ERROR: 10061 (0x274D)

2009-10-11 17:54:07 CGameData::LoadItemLimit: err=-1, query=exec usp_Read_ItemCount_ByServer_R

2009-10-11 17:54:07 DB table load error item limit

2009-10-11 17:54:07 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2009-10-11 17:54:07 Call save all waiting...

2009-10-11 17:54:07 Call save all failed dbagent disconnected(user count = 0)...

2009-10-11 17:54:07 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0

2009-10-11 17:54:07 Save MobID=1963109

2009-10-11 17:54:07 PS_GAME__system log end (Game01)

2009-10-11 17:54:07 3 1 SService::ServiceCtrlDispatcher(): service shutdown


All I had to do is change DB server name to the actual name my sever has.

Text in red says: Connection could not be establishes, because the computer is actively rejecting it.

Something like that.
 
Newbie Spellweaver
Joined
Oct 11, 2009
Messages
11
Reaction score
4
Thank you Twilight.

I spent some time looking through the forums and found the solution. Just had to reinstall SQL server with default instance and everything installed nicely. I had some issues with "game.exe" but I used Evolution files and all works fine :).

Then only problem now is I keep getting disconnected.

"Connection to the server has been disconnected: Error 0"

It's just like Aeria, but it happens always about a min after I run the game. I read through wikia and it says that something might interfeer with the connection. Could that be Avast or windows firewall?

Any ideas? Can't find any leads as to what might be causing it.


EDITED:

Oh.The server runs on MSSQL Server 2005 Express. It only needs some configuration as Twilight said: Named Pipelines, enable TCP protocol, etc.
 
Last edited:
Custom Title Activated
Loyal Member
Joined
Apr 30, 2008
Messages
2,868
Reaction score
214
Thank you Twilight.

I spent some time looking through the forums and found the solution. Just had to reinstall SQL server with default instance and everything installed nicely. I had some issues with "game.exe" but I used Evolution files and all works fine :).

Then only problem now is I keep getting disconnected.

"Connection to the server has been disconnected: Error 0"

It's just like Aeria, but it happens always about a min after I run the game. I read through wikia and it says that something might interfeer with the connection. Could that be Avast or windows firewall?

Any ideas? Can't find any leads as to what might be causing it.


EDITED:

Oh.The server runs on MSSQL Server 2005 Express. It only needs some configuration as Twilight said: Named Pipelines, enable TCP protocol, etc.

yea twilight already said the answer to ur question.
 
Joined
Dec 22, 2004
Messages
513
Reaction score
162
Thank you Twilight.
"Connection to the server has been disconnected: Error 0"

[*]Close version checking:
Select Logins >> Login01, right click, then Command. Enter "/vchkoff" press Enter.
(Type "/help" command for more info on available commands).

ihatehaxor - [Tut]Shaiya Private Server Instructions - RaGEZONE Forums


[*]Close NProtect verification:
Select GameGroups >> GameGroups01 >> Game, right click, then Command. Enter "/nprotectoff" press Enter.
(Type "/help" command for more info on available commands).

ihatehaxor - [Tut]Shaiya Private Server Instructions - RaGEZONE Forums

.
need this two commands
 
Newbie Spellweaver
Joined
Feb 19, 2008
Messages
18
Reaction score
0
First off I'm running xp pro, using ms sql enterprice 2008.
I have been trying to make a server, on this try, I run the PSMServer_Mgr all well start up, but the game well stop about 10 secs after it starts up, I right click and go to run again and it does the same thing well run for about 10 secs and stop. I have checked all the ini files, they look good, sql is running on the right ip. I know I am missing something simple. I just haven't figured it out, I need your help.
 
Joined
Dec 22, 2004
Messages
513
Reaction score
162
First off I'm running xp pro, using ms sql enterprice 2008.
I have been trying to make a server, on this try, I run the PSMServer_Mgr all well start up, but the game well stop about 10 secs after it starts up, I right click and go to run again and it does the same thing well run for about 10 secs and stop. I have checked all the ini files, they look good, sql is running on the right ip. I know I am missing something simple. I just haven't figured it out, I need your help.
1. In the list of system services: two services from server Shaiya should work.
2. In INI files correct options of connections with servers both a correct login and the generated password for access to a database are specified.
See errors in :
PSM_Client\Bin\Log
 
Newbie Spellweaver
Joined
Oct 11, 2009
Messages
11
Reaction score
4
Thank you for the help.

I didn't know I have to turn that off everytime I start the server. Everything is working now :).
 
Back
Top