Shaiya Private Server - Instructions - English

09/05/2010 10:44 alexistheboss15#706
er. having same problem. they stuck on pause and when i press start they go back to pause after a couple of seconds. how to i update map and stuff like u told us too?
pls give us guide with pics on what to do. 75% of people get stuck at the Pause part.
09/06/2010 19:34 julianinou#707
Quote:
Originally Posted by julianinou View Post
So let's see if u got all the components to start the Shaiya Server program :
Go there, i posted the full program for you <3 [Only registered and activated users can see links. Click Here To Register...] .
Then, now go to SQL server 2005 homepage here you download the program [Only registered and activated users can see links. Click Here To Register...] .
Now you install it with mixed mode (you chose a password) first time don't chose "named instance" . (here you get SQLserver)
When it's installed you re-install the same program to get the MSSQLEXPRESS, you chose "name instance" > "SQLExpress", mixed mode with the same password.
Make sure u got a password when you log on your session (when you start the computer , but not on the BIOS, you've you login+password ), if no go make one in administration tools > administrator session.
Now you start your prorgam SQL in > Start > All programs > Microsoft SQL Server 2005 > Configuration manager. Go to SQL 2005 services and make sure you got the browser, MSSQL server and SQL express. click on 1 go to properties and put it on "This account" chose your COMPUTER name (the one you log in when u start your comp.) put your password > apply > ok . Do that for the 3 services and then restart the browser, MSSQL server and SQL express. This services should be running now.
Now you download the Server management, install it and put your info. of you account. The server is running :D . Now you open the folder SHAIYA_SERVER and start it when it's explained at the beginning of the first topic ^_^
If you don't know where to get SQL server 2005 + MSSQL i put the link of the folder i made : [Only registered and activated users can see links. Click Here To Register...]

This topic took 25 min to prepare oO. I made all the folders for you and put them in Megaupload only for you ... A thank you will be welcome ^_^

***Greets***
From here, now you must config. SQL before to go on the "server patch config" try to log with your comp. account on SQL server management and then you can add a new user in the folder "management" on the left side, after u added a new user with all rights! you can go on server patch config !
Now i'm stuck there! lol i've to config. SQL for the server patch config. That's all i can do for you guys >.< sorry
09/08/2010 12:52 elco2100#708
If named all the skills in SQL that workt for me.
And did here and there some fix on the skill

file
[Only registered and activated users can see links. Click Here To Register...]
09/08/2010 18:32 SaphiraGaming#709
Heya ppl,
I need help my Game in GameGroups1 doesent start :(
What can i do?
09/09/2010 04:33 patoringa#710
Quote:
Originally Posted by Caixon View Post
:mad:


it hates me i keep getting this error over and over again ><

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

I have the accutal SQL sever setup done and i can log in without that error on SQL Server 2005 but when i install it I get this and i think its interfering with me continuing ><

My settings are set to Remote Connections and i've googled everything under the sun and nothing is helpful ><
I have exactly the same problem. I installed XP 32 bit SP3, SQL 2005 with the instance SQLEXPRESS and SQL Server Browser enabled.
After this screen nothing else works. Proceeded with the procedures but the services are always paused.
Can anyone give a little help: D.

Grateful.
09/09/2010 11:30 IonutTheDawg#711
says checking server please check notice board/didn't changed the ips i left 127.0.0.1 everywhere should i change in my ip?
09/09/2010 14:21 N4ZB34T#712
patoringa, try attaching the databases manually first. It worked for me that way.


BTW, someone can help me with this?

Code:
2010-09-09 20:17:31 PS_GAME__system log start (Game01) [KR]

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/sorp1

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/croco1

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/croco2

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Troll1

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Spink1

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/GoldenPig

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Sorp3

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/SorpNamed1

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/SorpNamed2

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Sorp2

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/CrocoNamed1

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/CrocoNamed2

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/CrocoNamed3

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/OrcNamed1

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/OrcNamed2

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/OrcNamed3

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/TrollNamed1

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Deinos

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Parridalis

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Alcarian

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/ZinAlcaria

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Belizabeth

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Kirhiross

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/CrypticOne

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Haruhion

2010-09-09 20:17:31 Loaded Behavior In Factory : data/ai/Freezing

2010-09-09 20:17:32 CGameData::LoadConstMob: err=-1, query=EXEC usp_Read_Mobs_R

2010-09-09 20:17:32 DB table load error

2010-09-09 20:17:32 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-09-09 20:17:32 Call save all waiting...

2010-09-09 20:17:32 Call save all failed dbagent disconnected(user count = 0)...

2010-09-09 20:17:32 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-09-09 20:17:32 Save Shaiya.SData 0

2010-09-09 20:17:32 PS_GAME__system log end (Game01)

2010-09-09 20:17:32 3 1 SService::ServiceCtrlDispatcher(): service shutdown
09/10/2010 04:05 patoringa#713
Quote:
Originally Posted by N4ZB34T View Post
patoringa, try attaching the databases manually first. It worked for me that way.
[/code]
Thx N4ZB34T for help. Database work, but all service is paused. They start and after a few seconds to make it stay paused.
I think that is wrong in accessing the database.

Any idea?
09/11/2010 03:02 SrShaden#714
Hey Guys and Girls, I can make the SQL setup, login to Shaiya DB, and get all Green Play... So everything should be ok right? But still doesn't work. IP's are set right database connects game.exe is bypassed and changed IP to 127.0.0.1 but I get "Checking Server, please check notice board" ... any idea guys? thx in advance
09/13/2010 13:55 patoringa#715
Quote:
Originally Posted by SrShaden View Post
Hey Guys and Girls, I can make the SQL setup, login to Shaiya DB, and get all Green Play...
How did you get all Green Player?

For me are all paused. Give me a hint. :handsdown:

Could you provide only the files in your database?

Thx.
09/13/2010 15:04 speccie#716
are u use u used US shaiya client what hex editor u used?

EDIT: re-open shaiya Pserver and type /vchkoff at login01 and at Game type /nprotectoff . If u don`t know what i mean pres 2nd click on game and go comand and there u type
press thanks if i helped
Sorry for bad english
09/13/2010 22:22 platano215#717
Can Some 1 Help me Make my own private Server plz i have like 2 years tryn to do it but... im not Pro PC an i dont know alot inglesh Well my Private server Will be Spanich plz Can some 1 help me i really need ur help guys ^^
09/13/2010 23:04 patoringa#718
Hi all!

I redid all the steps and continue with the same problem: Services begin and then pause.

The log files contain certain errors that do not know how to solve:

PS_SESSION__system.log__20100913_174648.log

Code:
2010-09-13 17:46:48 PS_SESSION__system log start (Session)

2010-09-13 17:46:49 userlog connect failed

2010-09-13 17:46:49 initserver() failed

2010-09-13 17:46:49 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-09-13 17:46:49 PS_SESSION__system log end (Session)

2010-09-13 17:46:49 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_USERLOG__system.log__20100913_174648.log

Code:
2010-09-13 17:46:48 PS_USERLOG__system log start (UserLog)

2010-09-13 17:47:06 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

2010-09-13 17:47:06 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-09-13 17:47:06 PS_USERLOG__system log end (UserLog)

2010-09-13 17:47:06 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_DBAGENT__charsave.log__20100913_174651.log

Code:
//PS_DBAGENT__charsave log start (DBAgent01)

//PS_DBAGENT__charsave log start (DBAgent01)
PS_DBAGENT__system.log__20100913_174651.log

Code:
2010-09-13 17:46:51 PS_DBAGENT__system log start (DBAgent01)

2010-09-13 17:47:07 DB gamedata connect error

2010-09-13 17:47:07 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-09-13 17:47:07 DBKillCountSave db alloc failed

2010-09-13 17:47:07 SAVE kill count ERROR

2010-09-13 17:47:07 CKeepObeliskMgr::DBSave db alloc failed

2010-09-13 17:47:07 SAVE g_KeepObeliskMgr ERROR

2010-09-13 17:47:07 GuildMgrSave::DBSave db alloc failed

2010-09-13 17:47:07 SAVE g_GuildMgrSave ERROR

2010-09-13 17:47:07 PS_DBAGENT__system log end (DBAgent01)

2010-09-13 17:47:07 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GAME__system.log__20100913_174651.log

Code:
2010-09-13 17:46:51 PS_GAME__system log start (Game01)

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/sorp1

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/croco1

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/croco2

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/Troll1

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/Spink1

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/GoldenPig

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/Sorp3

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/SorpNamed1

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/SorpNamed2

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/Sorp2

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/CrocoNamed1

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/CrocoNamed2

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/CrocoNamed3

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/OrcNamed1

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/OrcNamed2

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/OrcNamed3

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/TrollNamed1

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/Deinos

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/Parridalis

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/Alcarian

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/ZinAlcaria

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/Belizabeth

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/Kirhiross

2010-09-13 17:46:51 Loaded Behavior In Factory : data/ai/CrypticOne

2010-09-13 17:47:07 DB gamedef connect error

2010-09-13 17:47:07 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-09-13 17:47:07 Call save all waiting...

2010-09-13 17:47:07 Call save all failed dbagent disconnected(user count = 0)...

2010-09-13 17:47: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

2010-09-13 17:47:07 Save MobID=1963109

2010-09-13 17:47:07 PS_GAME__system log end (Game01)

2010-09-13 17:47:07 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GAMELOG__system.log__20100913_174651.log

Code:
2010-09-13 17:46:51 PS_GAMELOG__system log start (GameLog01)

2010-09-13 17:47:07 DB gamelog connect error

2010-09-13 17:47:07 init db error

2010-09-13 17:47:07 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-09-13 17:47:07 PS_GAMELOG__system log end (GameLog01)

2010-09-13 17:47:07 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_LOGIN__system.log__20100913_174651.log

Code:
2010-09-13 17:46:51 PS_LOGIN__system log start (Login01)

2010-09-13 17:47:07 DB userdata connect error, id=Shaiya, pass=Shaiya123

2010-09-13 17:47:07 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-09-13 17:47:07 PS_LOGIN__system log end (Login01)

2010-09-13 17:47:07 3 1 SService::ServiceCtrlDispatcher(): service shutdown
I appreciate any help.
09/14/2010 06:27 mido0013241#719
I have a problem when i try to make a char it says name in use and this is what i found
Quote:
2010-09-14 00:25:04 PS_DBAGENT__system log start (DBAgent01)

2010-09-14 00:25:06 UpdateGuildPointRankDB Result=-1

2010-09-14 00:25:18 connect game



2010-09-14 00:27:51 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error al convertir el tipo de datos varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2010-09-14 00:27:51 ::CreateCharacter 85 baer retVal=-1, qerr=-1, {?=call Usp_Save_Char_Item_Add_E(85,3052322283902271488, 0,5, 13001,13,1, 3400, 0,0,0,0,0,0, '',1,'2010-09-14 00:27:50','S')}

2010-09-14 00:27:51 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

2010-09-14 00:28:37 1 1 SAgent::Disconnect: (4, 64)

2010-09-14 00:28:37 1 1 T=000:03:00:000, RC=8,RCS=0, RB=314,RBS=1, SC=9,SCS=0, SB=2200,SBS=11

2010-09-14 00:28:37 disconnect game
Anyone know how to fix this?
09/15/2010 08:23 Gold_Ace#720
I'm new to the site and looking for Info on what Specs I would need to run my own server to make a private server. I'm in college atm for Network admin and multimedia (graphic side). My next quarter I will be building a pc that will have maxed ram and grapics card with 1 gb ram. I have talked to a few people I know and they say the computer I'm building will be able to handle it with the upgrades I'm adding to the schools list. But cooling might be a problem. So if anyone has any info. on this or if there is a topic already for this please let me know.

Before anyone says anything about spelling or anything else it 2am for me lol.