Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Development
You last visited: Today at 20:13

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Shaiya Private Server - Instructions - English

Discussion on Shaiya Private Server - Instructions - English within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Closed Thread
 
Old 05/05/2010, 16:24   #511
 
killernos's Avatar
 
elite*gold: 0
Join Date: Apr 2010
Posts: 95
Received Thanks: 24
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 
killernos is offline  
Old 05/06/2010, 07:48   #512
 
elite*gold: 0
Join Date: Jun 2009
Posts: 34
Received Thanks: 16
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
markus1234 is offline  
Old 05/06/2010, 15:05   #513
 
killernos's Avatar
 
elite*gold: 0
Join Date: Apr 2010
Posts: 95
Received Thanks: 24
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
killernos is offline  
Old 05/07/2010, 02:26   #514
 
elite*gold: 0
Join Date: May 2010
Posts: 3
Received Thanks: 0
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.
amb1guous is offline  
Old 05/07/2010, 13:09   #515
 
elite*gold: 0
Join Date: Nov 2009
Posts: 24
Received Thanks: 4
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
Ertoo is offline  
Old 05/07/2010, 15:54   #516
 
elite*gold: 0
Join Date: Jun 2009
Posts: 34
Received Thanks: 16
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.
markus1234 is offline  
Old 05/07/2010, 21:22   #517
 
elite*gold: 0
Join Date: Nov 2009
Posts: 898
Received Thanks: 318
Quote:
Originally Posted by lxxNickelbyxxl View Post
pls german!!!!!!!!
this
IceDragon001 is offline  
Old 05/08/2010, 10:33   #518

 
Polypropylen's Avatar
 
elite*gold: 0
Join Date: Feb 2009
Posts: 4,507
Received Thanks: 3,086
Wenn ihr euch ein wenig anstrengt, schafft ihr's auch auf Englisch den Server hinzukriegen!
Polypropylen is offline  
Old 05/08/2010, 17:46   #519
 
killernos's Avatar
 
elite*gold: 0
Join Date: Apr 2010
Posts: 95
Received Thanks: 24
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 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
killernos is offline  
Old 05/08/2010, 19:02   #520
 
nephren's Avatar
 
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
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

(by Blast3r)
nephren is offline  
Old 05/09/2010, 13:48   #521
 
elite*gold: 0
Join Date: Jun 2009
Posts: 3
Received Thanks: 0
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...
cyyberloop is offline  
Old 05/11/2010, 01:44   #522
 
elite*gold: 0
Join Date: Mar 2010
Posts: 1
Received Thanks: 3
i'm using win7, is it possible to install server?
can someone explain that if it possible?
enginarslan is offline  
Old 05/11/2010, 03:16   #523
 
elite*gold: 0
Join Date: Oct 2009
Posts: 12
Received Thanks: 0
Yes it is possible to install it on Win 7.

Banker1173 is offline  
Old 05/15/2010, 21:43   #524
 
elite*gold: 0
Join Date: Oct 2008
Posts: 71
Received Thanks: 15
I'm Almost There :)

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
DEvolver is offline  
Old 05/17/2010, 11:08   #525
 
killernos's Avatar
 
elite*gold: 0
Join Date: Apr 2010
Posts: 95
Received Thanks: 24
Exclamation

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
killernos is offline  
Closed Thread




All times are GMT +2. The time now is 20:13.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.