Shaiya Private Server - Instructions - English

05/05/2010 16:24 killernos#511
hi
I have everything done so far but when I start the server is also onlein but in the nest mom again is what the off

What is it

pls help

lg killernos

Ok Post this ini´s on ******** sry that last bug you need to fix but this i can not explain but now server works when this is fixed

hey kann mihr da einer hlpe

Session

PHP Code:
2010-05-05 20:04:19 PS_SESSION__system log start (Session)

2010-05-05 20:04:30 connect login

2010
-05-05 20:05:24 1 1 SAgent::Disconnect: (464)

2010-05-05 20:05:24 1 1 T=000:00:00:000RC=7,RCS=0RB=105,RBS=1SC=2,SCS=0SB=57,SBS=1

2010
-05-05 20:05:24 disconnect login

2010
-05-05 20:05:24 3 1 SERVICE_CONTROL_STOP

2010
-05-05 20:05:24 1 1 SAgent::Disconnect: (31236)

2010-05-05 20:05:24 1 1 T=000:01:00:000RC=0,RCS=0RB=0,RBS=0SC=1,SCS=0SB=37,SBS=0

2010
-05-05 20:05:24 log system server disconnection

2010
-05-05 20:05:24 PS_SESSION__system log end (Session)

2010-05-05 20:05:24 3 1 SService::ServiceCtrlDispatcher(): service shutdown 
05/06/2010 07:48 markus1234#512
Very nice an easy HowTo, congratulation!

At my other home-pc (dsl) everything works like a charm.
But actually im trying to set it up on another location w. cable connection (+router). Ports are forwarded.

Using MS SQL Server 2005 Express (such as first time which worked well).
Remote con. & pipes are enabled. Also all ports 'r forwarded(tested).

So why this works on regular connection but not on cable(even as using localhost)?

Im allways getting DB connect errors, even as the DB is up and running with the absolutely correct pwd.

Login on SSMSE works w. windows and sql auth - no problem.
Anyone got an idea?

userlog
Quote:
2010-05-06 07:43:17 PS_USERLOG__system log start (UserLog)

2010-05-06 07:43:33 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

2010-05-06 07:43:33 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-05-06 07:43:33 PS_USERLOG__system log end (UserLog)

2010-05-06 07:43:33 3 1 SService::ServiceCtrlDispatcher(): service shutdown
session
Quote:
2010-05-06 07:43:17 PS_SESSION__system log start (Session)

2010-05-06 07:43:18 userlog connect failed

2010-05-06 07:43:18 initserver() failed

2010-05-06 07:43:18 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-05-06 07:43:18 PS_SESSION__system log end (Session)

2010-05-06 07:43:18 3 1 SService::ServiceCtrlDispatcher(): service shutdown
(then allways the same).
Seems like its this running/paused after about 5-10secs failure.

NO errors while installing SQL (soft&DB).

greetings
05/06/2010 15:05 killernos#513
hey
what you are describing is a last buke because I not get even

userlog
PHP Code:
2010-05-06 07:43:17 PS_USERLOG__system log start (UserLog)

2010-05-06 07:43:33 DB userlog connect errorServer=127.0.0.1DBName=PS_UserData, [COLOR="Red"][B]User=ShaiyaPass=Shaiya123 [/B][/COLOR]<-- correct

2010
-05-06 07:43:33 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-05-06 07:43:33 PS_USERLOG__system log end (UserLog)

2010-05-06 07:43:33 3 1 SService::ServiceCtrlDispatcher(): service shutdown 
But if you look once you pass the correct
05/07/2010 02:26 amb1guous#514
Quote:
Originally Posted by markus1234 View Post
Very nice an easy HowTo, congratulation!

At my other home-pc (dsl) everything works like a charm.
But actually im trying to set it up on another location w. cable connection (+router). Ports are forwarded.

Using MS SQL Server 2005 Express (such as first time which worked well).
Remote con. & pipes are enabled. Also all ports 'r forwarded(tested).

So why this works on regular connection but not on cable(even as using localhost)?

Im allways getting DB connect errors, even as the DB is up and running with the absolutely correct pwd.

Login on SSMSE works w. windows and sql auth - no problem.
Anyone got an idea?

userlog


session

(then allways the same).
Seems like its this running/paused after about 5-10secs failure.

NO errors while installing SQL (soft&DB).

greetings
If you're getting a database connect error, if using vista/7 (you must have UAC diabled), go into SMSE (in administrator mode) and change the password of 'sa' to 'Shaiya123' (yes, a capital S); then, reinstall the services and run them, gl.
05/07/2010 13:09 Ertoo#515
Hi il im Sufini Shaiya Player some people tel this server will be down i thig to open new one server free AP Items Free Gear All thing free my PC is good i wana help to make new one server in Shaiya but i need helps on all people know to make server : my skype :memiko_92 pls find me on skype and lear me how to make thx [IM WAITING] helps
05/07/2010 15:54 markus1234#516
Quote:
If you're getting a database connect error, if using vista/7 (you must have UAC diabled), go into SMSE (in administrator mode) and change the password of 'sa' to 'Shaiya123' (yes, a capital S); then, reinstall the services and run them, gl.
Tried and failed.
05/07/2010 21:22 IceDragon001#517
Quote:
Originally Posted by lxxNickelbyxxl View Post
pls german!!!!!!!!
this
05/08/2010 10:33 Polypropylen#518
Wenn ihr euch ein wenig anstrengt, schafft ihr's auch auf Englisch den Server hinzukriegen!
05/08/2010 17:46 killernos#519
hey

kann mir einer helfen ich weiß an der stehle nicht mehr weider

I can sometimes help a case of things here I know not weider

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

PS_GAME log

Quote:
2010-05-08 17:39:53 PS_GAME__system log start (Game01)

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/sorp1

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/croco1

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/croco2

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/Troll1

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/Spink1

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/GoldenPig

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/Sorp3

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/SorpNamed1

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/SorpNamed2

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/Sorp2

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/CrocoNamed1

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/CrocoNamed2

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/CrocoNamed3

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/OrcNamed1

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/OrcNamed2

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/OrcNamed3

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/TrollNamed1

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/Deinos

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/Parridalis

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/Alcarian

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/ZinAlcaria

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/Belizabeth

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/Kirhiross

2010-05-08 17:39:53 Loaded Behavior In Factory : data/ai/CrypticOne

2010-05-08 18:20:15 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler bei der Anmeldung für den Benutzer 'Shaiya'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)

2010-05-08 18:20:15 CGameData::LoadItemLimit: err=-1, query=exec usp_Read_ItemCount_ByServer_R

2010-05-08 18:20:15 DB table load error item limit

2010-05-08 18:20:15 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-05-08 18:20:15 Call save all waiting...

2010-05-08 18:20:15 Call save all failed dbagent disconnected(user count = 0)...

2010-05-08 18:20:15 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

2010-05-08 18:20:15 Save MobID=1

2010-05-08 18:20:15 PS_GAME__system log end (Game01)

2010-05-08 18:20:15 3 1 SService::ServiceCtrlDispatcher(): service shutdown


lg killernos
05/08/2010 19:02 nephren#520
Solltest du EP4 Datenbank+Files von ProfNerwosol haben
die neuen Maps runterladen dann sollte Game-Groups starten.
In den Maps Ordner kopieren bei PSM_Client

[Only registered and activated users can see links. Click Here To Register...] (by Blast3r)
05/09/2010 13:48 cyyberloop#521
I've exactly the same error, by any chance do you have this one as well on your DM agent PS_DBAGENT__system__.log ? Anyway since NO ONE seems to help me on my error, I'll just try to help others :

killernos, check in your SQL under GameDefs, Items and check at the items that the log stated as "RandomOption Error" : All of them have something in common - The error says it already : byServer=1 . If we would change the "server" to value "0" then it should work... :) I'll give it a try...

hope this helps ...

Code:
UPDATE "Items"
set Server=0
where Server=1
[EDIT]
*optional [don't know why there are some items with different values as the server should be 0. Found 125,25,50 and some 5 and 6 which were in total about 600 entries. changing them to 0 should be the right thing to do :S, i guess :)

Code:
UPDATE "Items"
set Server=0
where Server <> 0

My error, need help on it plz...
Code:
2010-05-09 12:22:56 PS_DBAGENT__system log start (DBAgent)

2010-05-09 12:23:02 connect game, Name=



2010-05-09 12:23:02 connect game, Name=



2010-05-09 12:23:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_Market_INIT'., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)

2010-05-09 12:23:02 InitMarket failed qerr=-1, {?=call usp_Market_INIT}

2010-05-09 12:23:02 1 1 SAgent::Disconnect: (9, 64)

2010-05-09 12:23:02 1 1 T=000:00:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2010-05-09 12:23:02 disconnect game, Name=Game



2010-05-09 12:23:02 save market... wait plz...



2010-05-09 12:23:03 1 1 SAgent::Disconnect: (4, 64)

2010-05-09 12:23:03 1 1 T=000:00:00:000, RC=1,RCS=1, RB=37,RBS=37, SC=5,SCS=5, SB=2162,SBS=2162

2010-05-09 12:23:03 disconnect game, Name=Game



2010-05-09 12:23:03 save all... wait plz... enter /uc
[EDIT]
For what it's worth, i took the PS_GameLog.mdf, PS_GameLog.ldf and PS_GameLog.log.ldf files from the old EP3 onto this one and now the server seems to be up and running. I could not access the DP for GameLog on the SQL manager thus thinking the DB of EP4 might be corrupted. Anyway, will see how it goes now...
05/11/2010 01:44 enginarslan#522
i'm using win7, is it possible to install server?
can someone explain that if it possible?
05/11/2010 03:16 Banker1173#523
Yes it is possible to install it on Win 7.

[Only registered and activated users can see links. Click Here To Register...]
05/15/2010 21:43 DEvolver#524
Ok so i've managed to get all the Green || (Pause Signs) to Green > (play signs)

i tried to edit the US shaiya game.exe file in hex workshop , the ip part , but when i put it in the "Find" box it doesn't find anything...

if anyone could help me i'd much appreciate it :)

here are my .ini from SHAIYA_SERVER/SERVER/PSM_Agent/bin/config folder

Code:
[SERVER]
ServerName=DBAgent
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, Shaiya, 5DF59870228E618AD213434D5607805F4B12780FB64F3649147635F3FCE26CE5A5F9984F1C30D7CB26E18F4BE33CE12A7736E92E39500F711DAB9FC6A01D863F416B0B719C23511BED752993915E02BF5DB6B859A35AAEC93E87F8E217D6220F4F5043ACB5BE5BD5760D2B3B5B309AEA27258E17BF71A82CF4E221992A813686
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
Code:
[SERVER]
ServerName=Game
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]
GameDef=127.0.0.1, PS_GameDefs, Shaiya, 6C8DB9E6855CDB4C67CDDAA53E2F9E24E096AE76F1178383C31C5AD7E1A819B2AB5323A2BFBC34153590D10370F3EC6DE1A4B0EE1F473B7887045A04AD7AFA276F91D36D85DA282826FC7B78A5A174EE0A3C2AD5E3A022E4F4BAAF2B077C9430EC6987105493948106A51108C2435E58F045A0C806B4A248F03D0A2D77800A91
GameData=127.0.0.1, PS_GameData, Shaiya, BF7D69A385D01E5DE337ED047256087C7E740061C7283316F61E7ABC2C53985D1E40C72C788DC81A42A141DF49DA648825EF7B4069BD7CAB7C86AD7CCC434BAD05399C31BFD3686A1B11D2AEF062628CF9D612C59CACF7B6FF245BB24E65E78DF33718C54E7D2463D2201172FFF07E41C8292F308B990EC931A7E0FB203EC5B6
[GAMEINFO]
GameName=Game
GamePublicIP=192.168.x.xxx
GameVersion=0x08022100
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
Code:
[SERVER]
ServerName=GameLog
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Shaiya, 1A3FDDCF30829F3A71792BE5B1E304A69785B9CD328F7733D144D4C97869E3203C52C01A9FD1E2241817799E66E7455449B20663531CAC9DA89163BB3ABED90A7E5F7F689EE163EBD5880D205EBA3107A65101F94BEC8539AE0ECB4E4AE76385261CC2221167913BA34880B19AD0263577C9F7E8CEFBC27A1894ABB91D9F06A3
DBChat01=127.0.0.1, PS_GameLog, Shaiya, 06D7585AC02E89711B74480F6FDCEE80826836655AEC3530F5914DB2ED2E23D0C5325FA6EFDFA5FBB37933FC2C30E05A67DE4F722D0AAA45ED523528F1F9B99E069EC10A4780223919EF0248B41F10DBDD5915A1E72DC7BEFC03064B6A1EB28BDC7767DEDE80E2C49EDF27F331598B63341C3A6E1D0950E37B94C81AB0F629B5
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001
Code:
[SERVER]
ServerName=Login
ServerPort=
MaxConnection=10
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, Shaiya, CF4DF9120680DD8A3DF05E1504F7366994F844D8590D6AE5222D841D4D572F6408DD836DCDF05E357F5A55CE24955F3C0EAE136E4CFAB0141C6D9499623526304D5223C5C9F88F1630ACC344420F252FC01FC1BC2C7C673F01BBA1C404B8B7B5B1CBE48672CC0B48DDB6D9AF0626B9D25C63EDD893B96A88EDC5420B84C5F1B2
[GAMESERVERS]
// Game01 = name, Mapping ServerID, Mapping DB ID(use prev server id)
GameServerCount=1
Game01=UltimateShaiya, 1

[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
Code:
[SERVER]
ServerName=Session
ServerPort=
MaxConnection=

[CONNECTION]
UserLog=127.0.0.1

[GAMESERVERS]
GameServerCount=1
Game01=Game

[LOGFILE]
Replace=0
Append=1

[MONITOR]
Enable=0
Port=50000
Code:
[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=
[DB]
UserLog=127.0.0.1, PS_UserData, Shaiya, 7427BE8A8A278E266ACBF05DF33B823012CC3A1F129615165E1C26FAE7CE50C127D1041F0795BDAE71956EDCD6044EB5BA272ED083DAAC1F9BAD221379229037242AADACE62A520AC68DDDF84B36E718C2D2F2EF655440E5DBA039AA6D4455797EBAD2DF93819D82108FC6314F9A2C23585BDAF558F0140AE4B1814A3119745B
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001
05/17/2010 11:08 killernos#525
hey

kann mir einer helfen ich weiß an der stehle nicht mehr weider

I can sometimes help a case of things here I know not weider

PS_Game


LG KillerNos