[HelpDesk]Fixes | Ask For Help | Q&A | Updated

ihatehaxor · Aug 24, 2009

You can ask your help here, and most of the answers will be here too.
No credits for me, I searched around the whole Shaiya section for these answers.
I might have missed some, and if i did please add them here, and I will add it to this post.

Please check the whole thread, before asking a question.

Ports said:
(you only need to port forward if you are behind a router )
1433 - SQL (for remote connections like link server used by session)
30800 - ps_login.exe
30810 - ps_game.exe
30900 - ps_session.exe
30901 - ps_userLog.exe, ps_userLog.exe, ps_userLog.exe
30911 - ps_dbAgent.exe
30912 - ps_gameLog.exe
40900 - PSM_Agent.exe

Twilight's fixes -

Q : error( GOT SQL 2005 EXPRESS EDITION / WIN XP SP3 32 BIT)

Answer said:
Twilight said:

http://forum.ragezone.com/5325983-post64.html

Click to expand...

-How to fix DC/Rollback?

Answer said:
In the beginning it is necessary to define the second process caused blocking - both access
Example

You must be registered to see links

After definition of blocking function to add an option
with (UPDLOCK)
Example
Select *From DeadLoack with (UPDLOCK)

This function will not be blocked. Another will expect end.

-after I buy something from cash shop I get client error?

Answer said:
1. Unpack saf (ZeroSignal Python tools)
2. Generate csv or sql from Cash.SData
3. Delete all rows from ProductList table
4. exec import from csv or exec sql script for add new items in ProductList table
5. If error or crash check logs and edit store proc... i think problem RPC game.

-"disconnected from server , ERROR 0

Answer said:
Stop all servises.Close PSMServer_Mgr.exe
and run again...

and use command Game-> /nprotectoff

-I tried to run PSGMTool.exe, but I couldn't get it to work, I always get the same error message "GM Server connetion failed".

Is the solution quoted above a solution for the problem with PSGMTool.exe or it's only to make the Store Procedures to work?

Answer said:
PSGMTool.exe - I have no this file (I do not see the big necessity for it), is probable in the beginning is necessary DSN after that there is a verification using usp_GMTool_Login or (_2, _3)
My opinion at present:
.htaccess + php + store procs [/qoute]

-No View
help me..!!

Answer said:

... enable in game options game/player

Click to expand...

Answer said:
sod78's fixes -

-How to connect successfully with out disconnect issue?

Answer said:

Basically all you need is to go into the game command console and execute /nprotectoff

Click to expand...

-How to increase exp level?

Answer said:

use /exp2xenable <exp level>
Eg. /exp2xenable 100 = 100x exp

Click to expand...

-Complete mobs, items, skills, etc database. Just restore it
You must be registered to see links

-Error DBAGENT

2009-04-20 16:27:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure Usp_Save_Char_Item_Add_E has no parameters and arguments were supplied., SQL STATE: 42000, NATIVE ERROR: 8146 (0x1FD2)

2009-04-20 16:27:31 ::CreateCharacter 18 Tester retVal=-1, qerr=-1, {?=call Usp_Save_Char_Item_Add_E(18,2677679008296009728, 0,5, 12006,12,6, 2400, 0,0,0,0,0,0, '',1,'2009-04-20 16:27:31','S')}

2009-04-20 16:27:31 err=0, , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

and can't create character.

Answer said:

Thats the missing stored procedures Reflax was refering to, u will need to re-create that for PS_GameData db.

That procedure should insert into 'charitems' table from the looks of it.

Click to expand...

-Here's the complete PS_GameData which contains all the needed stored procedures.

Just restore that to your original PS_GameData

You must be registered to see links

-And here's the english version of server manager

You must be registered to see links

Main Thread's fixes -

-how use gm command /getitem?

Answer said:

/getitem Type TypeID Count
see PS_GameDefs->Items

Click to expand...

-I need gm commands please

Answer said:

Click to expand...

-my server not working proc usp_AdjustMobsMoney help plz?

AngryBvr said:

I think the best approach to solve this problem is not to use ups_AdjustMobsMoney SP, and just modifiy the usp_Read_Mobs_R SP in this way:

Code:

ALTER PROC [dbo].[usp_Read_Mobs_R] AS DECLARE @Multiplier AS INT SET @Multiplier = 10 SELECT MobID, MobName, [Level], [Exp], AI, ( CASE WHEN (Money1 * @Multiplier) > 32767 THEN 32767 ELSE (Money1 * @Multiplier) END ) AS Money1, ( CASE WHEN (Money2 * @Multiplier) > 32767 THEN 32767 ELSE (Money2 * @Multiplier) END ) AS Money2, QuestItemID, HP, SP, MP, Dex, Wis, Luc, [Day], [Size], Attrib, Defense, Magic, ResistState1, ResistState2, ResistState3, ResistState4, ResistState5, ResistState6, ResistState7, ResistState8, ResistState9, ResistState10, ResistState11, ResistState12, ResistState13, ResistState14, ResistState15, ResistSkill1, ResistSkill2, ResistSkill3, ResistSkill4, ResistSkill5, ResistSkill6, NormalTime, NormalStep, ChaseTime, ChaseStep, ChaseRange, AttackType1, AttackTime1, Attackrange1, Attack1, Attackplus1, Attackattrib1, Attackspecial1, Attackok1, Attacktype2, Attacktime2, Attackrange2, Attack2, Attackplus2, Attackattrib2, Attackspecial2, Attackok2, Attacktype3, Attacktime3, Attackrange3, Attack3, Attackplus3, Attackattrib3, Attackspecial3, Attackok3 FROM Mobs ORDER BY MobID ASC

In this way you avoid altering any table data, and to vary the money that monters drop you only need to change the value of @Multiplier.

If you have already used ups_AdjustMobsMoney SP, you need to restore Mobs Table data to its initial state to make your server work againg.

Click to expand...

<by AngryBvr>

-can giv me some guide for Microsoft Sql Server 2005 ??

Answer said:

Database from first post you just need atach it in sql 2005 and the others 2 from reflax you need restore. This way you will have all data in tables.

Click to expand...

-database server bug pass login. For example, ID. 1234. PASS 1234. Server can be accessed by entering anything.

Answer said:

Just delete all the rows you don't want in the ps_userdata database...
tables Users_Master and Users_Detail.

That will fix your problem

Click to expand...

-i set AdminLevel = 255 but Account is default user.

Answer said:

PSMServer_Mgr.exe -> Login01->Command:

/help - allcommands
//adminopen

Click to expand...

-wat ever password i type it logs me in
no matter wat password i type correct or wrong.

Answer/Twilight said:

just edit
usp_Try_GameLogin_Taiwan

Click to expand...

or

Answer/reflax said:

i swear people are lazy lol

add this
DECLARE @InPassword2 varchar(32)

change your query to match this
SELECT @UserUID=UserUID, @Status=Status, @InPassword2=Pw, @Leave=Leave FROM Users_Master WHERE UserID = @UserID

somewhere in there add this
IF ( @InPassword <> @InPassword2 )
BEGIN
SET @Status = -1
END

presto... or you can use bits of their code and add md5 passwords instead to make it more secure.

Click to expand...

- Error = 2009-05-03 16:13:32 PS_SESSION__system log start (Session)
2009-05-03 16:13:35 userlog connect failed
2009-05-03 16:13:35 initserver() failed
2009-05-03 16:13:35 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-03 16:13:35 PS_SESSION__system log end (Session)
2009-05-03 16:13:35 3 1 SService::ServiceCtrlDispatcher(): service shutdown

2009-05-03 18:23:23 PS_USERLOG__system log start (UserLog)
2009-05-03 18:23:39 DB userlog connect error, Server=127.0.0.1 DBName=PS_UserData, User=sa, Pass=987654
2009-05-03 18:23:39 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-03 18:23:39 PS_USERLOG__system log end (UserLog)
2009-05-03 18:23:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Answer said:

to fix ur problem, go to PSM_Client\bin\config , dbAgent config, copy the hashed password (the numbers after ur "sa, ") , now go to all the rest of the files in same folder, and delete the other numbers and paste the one u just copied....

the problem is that the svr manager doesn't do his job properly xd, and gl after taht ;d

Click to expand...

-How to add Points "charactor" in database?

Answer/Destroyer6666 said:

u can add points for item store in PS_UserData -> dbo.Users_Master -> Point

its in the table after ModiDate!

Click to expand...

-I am trying to start the server, but I get the following error in the "PSM_Client\Bin\Log\PS_DBAGENT__system.log__*" files:

Answer/Twilight said:

Check GameData=10.3.20.43, PS_GameData, sa,
if local server db set 127.0.0.1 or (local) or enable remote connection

Click to expand...

-every time i can not create a char, its always telling me "name already in use"

Answer/HASKOMAN said:

GO TO

SQL Database - PS_GameData - CHAR - design table and change Maketime in varchar

xd you have the same problem I've had but I am a good programmer

CHANGE MY SCRYPT

go to USP_SAVE_CHAR_ITEM_ADD_E

/****** Object: Stored Procedure dbo.usp_Save_Char_Item_Add_E Script Date: 2008-6-7 18:31:57 ******/

/****** Object: Stored Procedure dbo.usp_Save_Char_Item_Add_E Script Date: 2008/3/15 下午 05:25:52 ******/

/****** 偃羹: 盪濰 煎衛盪 dbo.usp_Save_Char_Item_Add_E 蝶觼董 陳瞼: 2006-04-11 螃 10:57:16 ******/

CREATE Proc usp_Save_Char_Item_Add_E

@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@Maketime varchar(20)='01/01/1999',
@Maketype char(1)

AS

--SET NOCOUNT ON

IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END

INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)

IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

--SET NOCOUNT OFF
GO

and

go to usp_Read_Char_Items_Detail_R

CHANGE MY SCRYPT

/****** Object: Stored Procedure dbo.usp_Read_Char_Items_Detail_R Script Date: 2008-6-7 18:31:57 ******/

/****** Object: Stored Procedure dbo.usp_Read_Char_Items_Detail_R Script Date: 2008/3/15 下午 05:25:51 ******/

CREATE Proc usp_Read_Char_Items_Detail_R

@CharID int

AS

/******SET NOCOUNT ON******/

SELECT ItemID, Type, TypeID, ItemUID, Bag, Slot, Quality,
Gem1, Gem2, Gem3, Gem4, Gem5, Gem6, Craftname, [Count], Maketype ,
'2009' AS MakeTime_YYYY,
'01' AS MakeTime_MM,
'01' AS MakeTime_DD,
'00' AS MakeTime_HH,
'00' AS MakeTime_MI,
'00' AS MakeTime_SS

FROM CharItems

WHERE CharID = @CharID AND Del = 0

/******SET NOCOUNT OFF******/
GO

and restarts all the service and good luck

I've spend 4 days but I've successfully with these changes it is sufficient to look for or just the error ^ ^
And you can create characters now

Click to expand...

Releases

-by phprap

sql tools - link >
You must be registered to see links

Click to expand...

-by Limpamesa

For know how many player is online
In PS_GameData, table Chars, add field LoginStatus as tinyint (default = 0)
In usp_Read_Chars_Detail2_R, change:
UPDATE Chars SET JoinDate=GETDATE(), LoginStatus = 1 WHERE CharID=@CharID
usp_Save_Char_LeaveDate_R, change:
UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE CharID=@CharID

===========
total players online:
SELECT COUNT(LoginStatus) AS PlayersON
FROM dbo.CHARS where LoginStatus = 1

==========
Who's online:
SELECT CharID, CharName,Level, JoinDate, LeaveDate, LoginStatus
FROM CHARS
WHERE (LoginStatus = 1)

Click to expand...

-by Mazdik

TOP players

Code:

<?php $sql_server = "127.0.0.1"; $sql_user = "sa"; $sql_pass = "123456"; $sql_data = "PS_GameData"; $conn=mssql_connect($sql_server,$sql_user,$sql_pass); $xadb = mssql_select_db($sql_data,$conn) or die("$uwebmsg_cerr"); $toplvlq = "SELECT * FROM CHARS ORDER BY Level DESC"; $toplvlr = mssql_query($toplvlq); $toplvl_num = 0; echo "TOP PLAYERS"; echo "<Table width=100% border=1><TR><TD>RANK NUMBER</td><TD>PLAYER NAME</td><TD>PLAYER LEVEL</td></tr>"; while ($toplvlrow = mssql_fetch_array($toplvlr)) { $toplvl_num++; echo "<TR><TD>$toplvl_num</td><TD>".$toplvlrow[CharName]."</td><TD>".$toplvlrow[Level]."</td>"; if ($toplvl_num >= 100) break; } echo "</table>"; ?>

Whos online

Code:

<?php $sql_server = "127.0.0.1"; $sql_user = "sa"; $sql_pass = "123456"; $sql_data = "PS_GameData"; $conn=mssql_connect($sql_server,$sql_user,$sql_pass); $xadb = mssql_select_db($sql_data,$conn) or die("$uwebmsg_cerr"); $toplvlq = "SELECT * FROM CHARS WHERE (LoginStatus = 1) ORDER BY Level DESC"; $toplvlr = mssql_query($toplvlq); $toplvl_num = 0; echo "TOP PLAYERS"; echo "<Table width=100% border=1><TR><TD>RANK NUMBER</td><TD>PLAYER NAME</td><TD>PLAYER LEVEL</td></tr>"; while ($toplvlrow = mssql_fetch_array($toplvlr)) { $toplvl_num++; echo "<TR><TD>$toplvl_num</td><TD>".$toplvlrow[CharName]."</td><TD>".$toplvlrow[Level]."</td>"; if ($toplvl_num >= 100) break; } echo "</table>"; ?>

Click to expand...

-By ZeroSignal

ZeroSignal said:

I managed to do the Monster Name translation on the Database, by extracting the name from the Monster.SData file.

Note that this will also need to be adapted for the Cash.SData, Skill.SData, and Item.SData binary files.

This was coded in Python:

Main.py

Code:

import struct import re # Open SData File. input = open("Monster.SData", mode='rb') # Open SQL File for writing. output = open("Monster.SData.txt.sql", mode='w') # Unpack binary into 4-byte integer. file_header = struct.unpack('i', input.read(4)) # The total amount of records. record_total = file_header[0] print 'Monster records: ' + str(record_total) monster = [] for i in range(record_total): monster.append({}) # Length of monster name string. data = struct.unpack('i', input.read(4)) name_len = data[0] # Read Monster name string, stripping NULL Terminator. monster[i]['name'] = input.read(name_len)[:-1] # Other Data we don't need. input.read(31) # Sanitize string by adding escape char quotes. sanitize_name = monster[i]['name'].replace('\'', '\'\'') # Generate update SQL String. sql = "UPDATE Mobs SET MobName = '" + sanitize_name + "' WHERE MobID = " + str(i) +";\n" # Write the SQL to a file. output.write(sql)

Click to expand...

-Zero's three goals.

By Zero.

1. To be able to get all the SData binary files (including English names) reflected in the Server Database. I think it's best to create Comma Separated Extracts as they produce best results and can easily be imported.
2. To add re-combine functionality to the DATA.SAF Extractor. This is actually a fairly big task and not trivial at all.
3. To make programs to convert the SData files to CSV Files that can be edited, and be re-combined back into the SAF format. Pretty Easy as partly demonstrated below.
4. Make the DATA.SAF Extractor be able to create Update Patch Files. Fairly Difficult as it will need to compare DIFF changes.

Code here

Click to expand...

-By ZeroSignal

Got the full specification of the Item.SData file said:

Read Me :[/B]

Code:

Item.py Needs to have the Item.SData in the same folder. USAGE 1: >python Item.py csv_complete TODO USAGE 2: >python Item.py csv_import Creates an Items.import.csv file which can be used to import into PS_GameDefs.dbo.Items. File Format: Delimited File type: ANSI Row delimiter: {CR}{LF} First row has column names: enabled Text Qualifier: Double Quote {"} Column Delimiter: Comma USAGE 3: >python Item.py sql_update_lang Creates Items.update.sql file which has Update Queries that can be used to update the names into the language of the Item.SData file.

Note - It will still need to have functionality to extract the complete Item.SData into a file that easily can be edited (most likely CSV). And a re-combine function to make it back into an SData binary file.

You must be registered to see links

Click to expand...

Got the full specification of the Item.SData file said:

Sod78's tips :

Sod78 said:

I just realised that Shaiya is full of quests lol. Just a few tips, u can play with admin account.

/char on/off to switch the invisibility.
/attack on/off to turn switch the mobs attack on you.

To get items
/getitem <Type> <TypeID>
Eg. /getitem 25 19 = Mini Healing Potion
Eg. /getitem 42 1 = Level 40 Horse Mount

Some Examples::
25 <Type> is potion, the second arguments will be the potion <TypeID>
Mini Healing Potion 25 19
Healing Potion 25 20
Great Healing Potion 25 21
Mini Stamina Potion 25 22
Stamina Potion 25 23
Grain Stamina Potion 25 24
Mini MP Potion 25 25
MP Potion 25 26
Great MP Potion 25 27

42<Type> is Mount
Lvl 40 Horse Mount 42 1
Lvl 40 Leopard Mount 42 2
Lvl 40 Basilisk Mount 42 3
Lvl 40 Lion Mount 42 4
Etc Mount goes from 42 1 to 42 24

To summon/create the mobs, use /mmake <Type> <ID>

I will attach untranslated items and mobs list which was distributed in CN language. so feel free to translate and experiment with it.

Click to expand...

Here :
You must be registered to see links

Sod78 said:

Few more tips regarding user creation for those planning to revise a better php / asp script for it. To enable the user to obtain all modes (Hard, Ultimate), just insert into the PS_GameData, UserMaxGrow table.

<RowID> <ServerID> <UserUID> <Country> <MaxGrow> <Del>

RowID - Auto

ServerID - 1 (default if you use the server files configuration)

UserUID - Same reference to the PS_UserData db, User_Master table

Country - 0/1 (0 - Light, 1 - Dark)

MaxGrow - 3 (All modes available)

Del - 0

Click to expand...

Other Fixes :

All services show a red X
This is most likely to your Shaiya Agent Client service (D:\SHAIYA_SERVER\SERVER\PSM_Client\PSM_Agent.exe) not being installed and/or not running. Get it installed and started, and restart PSMServer_Mgr.exe if needed.

All services show a green x
This means your services are not installed, or are not being recognized as being installed.

Services go to a green arrow, but then back to pause
This usually means the services were unable to connect to the database. Check your logs in D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Log and D:\SHAIYA_SERVER\SERVER\PSM_Client\Log. These logs help tell you of problems with services starting, so keep that in mind for future problems.

Check notice board
Usually caused by connecting to the wrong IP address, or Windows Firewall blocking the client.
Can also be cause by using the wrong game client, thus connecting to the wrong IP address.

Failed to connect to game server, after selecting server and clicking ok
May be caused by Windows Firewall blocking the client trying to connect to the server.
Can also be caused by the incorrect IP address entered in D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config\ps_g ame.ini on the line that starts with GamePublicIP=
It could possibly also be from incorrect IP addresses in other .ini files.

Disconnect after selecting game server and clicking ok
Most likely you have incorrect or missing data in your database. There could be many causes of this. I'd suggest using the SQL profiler to trace what happens in this case and look for error messages in the logs. If there is an error message present in the logs try to find which SQL query that you traced with the profiler caused it.

Disconnect after less than 2 minutes of being connected to the server
Usually caused by forgetting to run the /nprotectoff command. Normally this needs to be run every time the server services are restarted, which includes server reboots, etc.

Disconnect when targetting mobs, or doing other specific activities
Most likely you have incorrect or missing data in your database. There could be many causes of this. I'd suggest using the SQL profiler to narrow down the problem.

Disconnect when buying an item from the item mall.
The Distributed Transaction Coordinator service may not be running, it is required to use the statement: BEGIN DISTRIBUTED TRANSACTION

Credits : abrasive

More to be added, just don't have time right now~

(on page 10 on thread)

Click to expand...

ihatehaxor · Aug 28, 2009

Thread updated. 8/28/09.

If you have any questions feel free to ask it here.

drew666 · Sep 11, 2009

Yes im a total noob when it comes to making a shaiya Private server. But i have made and ran other Pserver for others games i would like to get into Shaiya. I can host the server and run it i just need help getting started. So im asking if you can take time and teach me. I have read all the Guides that are out there. I have read your guide and fixes and it extremely helpfully but i learn alot better by doing it and having someone watching and telling me what i have done wrong. I have tried many time to make one and it never seem to be sucessful. So im asking for a some of ur time in helping me.

ihatehaxor · Sep 11, 2009

Hmm okay I'll try to help u tmrw but what exacty do u need help with?

drew666 · Sep 12, 2009

If you can add me on msn i can explain more on what i need help with. My msn is drew09225@hotmail.com I really want to say thanks for taking the time in helping me.

ihatehaxor · Sep 13, 2009

Hmm, I'm not that active on msn, mind telling me on here?

drew666 · Sep 14, 2009

basically i need a guide or help with the importing of the database
How to connect it to the server. One guide a while ago said something about making and names folder then doing something. Idk im lost at this part

ihatehaxor · Sep 15, 2009

Did u check the stickied guide in the guide section?

drew666 · Sep 18, 2009

Yep i got it all working now server and database.

Now i need help with a register page. I have been reading so many website about php and connect it to SQL server.

I have tried idk how many times to make my own and nope still dont work. So if you can help me in making a register page Ill love you forever.

claudeD · Sep 20, 2009

hi my name is claude and i have a problem my server run but i cant play the game what i do wrong can some 1 help me
server run i hex the game exe but stil load shaiya us mot my server why ???

wolfnibbles · Sep 24, 2009

My virus protected found a virus in this file:
Releases
-by phprap
Quote:
sql tools - link >

You must be registered to see links

loko2345 · Sep 25, 2009

hi, well after a few days my server works, but now, dont want to start GameGroups>GameGroups01>Game, this service try to start but, then ends, i saw at the logs, but all is correct before start "Game" i have this:
userlog:

Code:

2009-09-25 13:31:13 PS_USERLOG__system log start (UserLog)

2009-09-25 13:31:19 connect

2009-09-25 13:31:22 connect

Session:

Code:

2009-09-25 13:31:19 PS_SESSION__system log start (Session)

2009-09-25 13:31:22 connect login

Login

Code:

2009-09-25 13:31:21 PS_LOGIN__system log start (Login01)

Gamelog

Code:

2009-09-25 13:31:26 PS_GAMELOG__system log start (GameLog01)

DBagent_charsave

Code:

//PS_DBAGENT__charsave log start (DBAgent01)

DBagent_system

Code:

2009-09-25 13:31:29 PS_DBAGENT__system log start (DBAgent01)

2009-09-25 13:31:29 UpdateGuildPointRankDB Result=-1

After i start "Game"

userlog

Code:

2009-09-25 13:34:35 1 1 SAgent::Disconnect: (4, 64)

2009-09-25 13:34:35 1 1 T=000:00:00:000, RC=2,RCS=0, RB=****RBS=0, SC=0,SCS=0, SB=0,SBS=0

2009-09-25 13:34:35 disconnect

session

Code:

2009-09-25 13:34:34 connect game

2009-09-25 13:34:35 1 1 SAgent::Disconnect: (4, 64)

2009-09-25 13:34:35 1 1 T=000:00:00:000, RC=2,RCS=0, RB=70,RBS=0, SC=1,SCS=0, SB=5,SBS=0

2009-09-25 13:34:35 disconnect game

Gamelog

Code:

2009-09-25 13:34:35 1 1 SAgent::Disconnect: (4, 64)

2009-09-25 13:34:35 1 1 T=000:00:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2009-09-25 13:34:35 disconnect game

dbagent_system

Code:

2009-09-25 13:34:34 connect game



2009-09-25 13:34:35 1 1 SAgent::Disconnect: (4, 64)

2009-09-25 13:34:35 1 1 T=000:00:00:000, RC=4,RCS=0, RB=133,RBS=0, SC=5,SCS=0, SB=2162,SBS=0

2009-09-25 13:34:35 disconnect game



2009-09-25 13:34:35 save all... wait plz... enter /uc

PS_Game

Code:

2009-09-25 13:34:33 Loaded Behavior In Factory : data/ai/ZinAlcaria

2009-09-25 13:34:33 Loaded Behavior In Factory : data/ai/Belizabeth

2009-09-25 13:34:33 Loaded Behavior In Factory : data/ai/Kirhiross

2009-09-25 13:34:33 Loaded Behavior In Factory : data/ai/CrypticOne

2009-09-25 13:34:34 CItemDrop::InitSequenceItemCreate SequenceItemCreate open 0

2009-09-25 13:34:34 connect mgr 808

2009-09-25 13:34:34 connect dbagent 840

2009-09-25 13:34:34 connect gamelog 876

2009-09-25 13:34:34 map  0, zone 2 mob count = 905

2009-09-25 13:34:34 map  1, zone 3 mob count = 1747

2009-09-25 13:34:34 map  2, zone 4 mob count = 1811

2009-09-25 13:34:34 map  3, zone 5 mob count = 294

2009-09-25 13:34:34 map  4, zone 6 mob count = 47

2009-09-25 13:34:34 map  5, zone 7 mob count = 173

2009-09-25 13:34:34 map  6, zone 8 mob count = 45

2009-09-25 13:34:34 map  7, zone 9 mob count = 162

2009-09-25 13:34:34 map  8, zone 10 mob count = 37

2009-09-25 13:34:34 map  9, zone 11 mob count = 334

2009-09-25 13:34:34 map 10, zone 12 mob count = 234

2009-09-25 13:34:34 map 11, zone 13 mob count = 176

2009-09-25 13:34:34 map 12, zone 14 mob count = 233

2009-09-25 13:34:34 map 13, zone 15 mob count = 245

2009-09-25 13:34:34 map 14, zone 16 mob count = 202

2009-09-25 13:34:34 map 15, zone 17 mob count = 203

2009-09-25 13:34:34 map 16, zone 18 mob count = 205

2009-09-25 13:34:34 map 17, zone 19 mob count = 155

2009-09-25 13:34:34 map 18, zone 20 mob count = 172

2009-09-25 13:34:34 map 19, zone 21 mob count = 1105

2009-09-25 13:34:34 map 20, zone 22 mob count = 1142

2009-09-25 13:34:34 map 21, zone 23 mob count = 160

2009-09-25 13:34:34 map 22, zone 24 mob count = 93

2009-09-25 13:34:34 map 23, zone 25 mob count = 143

2009-09-25 13:34:34 map 24, zone 26 mob count = 157

2009-09-25 13:34:34 map 25, zone 27 mob count = 478

2009-09-25 13:34:34 map 26, zone 28 mob count = 234

2009-09-25 13:34:34 map 27, zone 29 mob count = 61

2009-09-25 13:34:35 map 28, zone 30 mob count = 1077

2009-09-25 13:34:35 map 29, zone 31 mob count = 1107

2009-09-25 13:34:35 map 30, zone 32 mob count = 246

2009-09-25 13:34:35 map 31, zone 33 mob count = 93

2009-09-25 13:34:35 map *** zone 34 mob count = 94

2009-09-25 13:34:35 map 33, zone 35 mob count = 136

2009-09-25 13:34:35 map 34, zone 36 mob count = 121

2009-09-25 13:34:35 map 35, zone 37 mob count = 0

2009-09-25 13:34:35 map 36, zone 38 mob count = 0

2009-09-25 13:34:35 map 37, zone 39 mob count = 190

2009-09-25 13:34:35 map 38, zone 40 mob count = 228

2009-09-25 13:34:35 map 39, zone 41 mob count = 0

2009-09-25 13:34:35 map 40, zone 42 mob count = 0

2009-09-25 13:34:35 map 41, zone 43 mob count = 0

2009-09-25 13:34:35 map 42, zone 44 mob count = 0

2009-09-25 13:34:35 map 43, zone 45 mob count = 922

2009-09-25 13:34:35 map 44, zone 46 mob count = 852

i has cheked the sql connections, i can connect with the shaiya user and i can query, also i have the "game server"

in the event viewer i have something like
"the Shaiya Game Server service has terminated abrubtaly" or something like that, i cant tell u the exact msg cause my windows is in spanish.

also i try to copy/paste all the hashed passwords in the ini files.

txs to all, i will see what i can do, if i find the solution i will post here

--------->>EDIT<<-----------
i deleted all the databases, then restore all from the "originals" (ZS server files) and all works again.

ty all

ihatehaxor · Oct 12, 2009

loko2345 said:

hi, well after a few days my server works, but now, dont want to start GameGroups>GameGroups01>Game, this service try to start but, then ends, i saw at the logs, but all is correct before start "Game" i have this:
userlog:

Code:

2009-09-25 13:31:13 PS_USERLOG__system log start (UserLog)

2009-09-25 13:31:19 connect

2009-09-25 13:31:22 connect

Session:

Code:

2009-09-25 13:31:19 PS_SESSION__system log start (Session)

2009-09-25 13:31:22 connect login

Login

Code:

2009-09-25 13:31:21 PS_LOGIN__system log start (Login01)

Gamelog

Code:

2009-09-25 13:31:26 PS_GAMELOG__system log start (GameLog01)

DBagent_charsave

Code:

//PS_DBAGENT__charsave log start (DBAgent01)

DBagent_system

Code:

2009-09-25 13:31:29 PS_DBAGENT__system log start (DBAgent01)

2009-09-25 13:31:29 UpdateGuildPointRankDB Result=-1

After i start "Game"

userlog

Code:

2009-09-25 13:34:35 1 1 SAgent::Disconnect: (4, 64)

2009-09-25 13:34:35 1 1 T=000:00:00:000, RC=2,RCS=0, RB=****RBS=0, SC=0,SCS=0, SB=0,SBS=0

2009-09-25 13:34:35 disconnect

session

Code:

2009-09-25 13:34:34 connect game

2009-09-25 13:34:35 1 1 SAgent::Disconnect: (4, 64)

2009-09-25 13:34:35 1 1 T=000:00:00:000, RC=2,RCS=0, RB=70,RBS=0, SC=1,SCS=0, SB=5,SBS=0

2009-09-25 13:34:35 disconnect game

Gamelog

Code:

2009-09-25 13:34:35 1 1 SAgent::Disconnect: (4, 64)

2009-09-25 13:34:35 1 1 T=000:00:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2009-09-25 13:34:35 disconnect game

dbagent_system

Code:

2009-09-25 13:34:34 connect game



2009-09-25 13:34:35 1 1 SAgent::Disconnect: (4, 64)

2009-09-25 13:34:35 1 1 T=000:00:00:000, RC=4,RCS=0, RB=133,RBS=0, SC=5,SCS=0, SB=2162,SBS=0

2009-09-25 13:34:35 disconnect game



2009-09-25 13:34:35 save all... wait plz... enter /uc

PS_Game

Code:

2009-09-25 13:34:33 Loaded Behavior In Factory : data/ai/ZinAlcaria

2009-09-25 13:34:33 Loaded Behavior In Factory : data/ai/Belizabeth

2009-09-25 13:34:33 Loaded Behavior In Factory : data/ai/Kirhiross

2009-09-25 13:34:33 Loaded Behavior In Factory : data/ai/CrypticOne

2009-09-25 13:34:34 CItemDrop::InitSequenceItemCreate SequenceItemCreate open 0

2009-09-25 13:34:34 connect mgr 808

2009-09-25 13:34:34 connect dbagent 840

2009-09-25 13:34:34 connect gamelog 876

2009-09-25 13:34:34 map  0, zone 2 mob count = 905

2009-09-25 13:34:34 map  1, zone 3 mob count = 1747

2009-09-25 13:34:34 map  2, zone 4 mob count = 1811

2009-09-25 13:34:34 map  3, zone 5 mob count = 294

2009-09-25 13:34:34 map  4, zone 6 mob count = 47

2009-09-25 13:34:34 map  5, zone 7 mob count = 173

2009-09-25 13:34:34 map  6, zone 8 mob count = 45

2009-09-25 13:34:34 map  7, zone 9 mob count = 162

2009-09-25 13:34:34 map  8, zone 10 mob count = 37

2009-09-25 13:34:34 map  9, zone 11 mob count = 334

2009-09-25 13:34:34 map 10, zone 12 mob count = 234

2009-09-25 13:34:34 map 11, zone 13 mob count = 176

2009-09-25 13:34:34 map 12, zone 14 mob count = 233

2009-09-25 13:34:34 map 13, zone 15 mob count = 245

2009-09-25 13:34:34 map 14, zone 16 mob count = 202

2009-09-25 13:34:34 map 15, zone 17 mob count = 203

2009-09-25 13:34:34 map 16, zone 18 mob count = 205

2009-09-25 13:34:34 map 17, zone 19 mob count = 155

2009-09-25 13:34:34 map 18, zone 20 mob count = 172

2009-09-25 13:34:34 map 19, zone 21 mob count = 1105

2009-09-25 13:34:34 map 20, zone 22 mob count = 1142

2009-09-25 13:34:34 map 21, zone 23 mob count = 160

2009-09-25 13:34:34 map 22, zone 24 mob count = 93

2009-09-25 13:34:34 map 23, zone 25 mob count = 143

2009-09-25 13:34:34 map 24, zone 26 mob count = 157

2009-09-25 13:34:34 map 25, zone 27 mob count = 478

2009-09-25 13:34:34 map 26, zone 28 mob count = 234

2009-09-25 13:34:34 map 27, zone 29 mob count = 61

2009-09-25 13:34:35 map 28, zone 30 mob count = 1077

2009-09-25 13:34:35 map 29, zone 31 mob count = 1107

2009-09-25 13:34:35 map 30, zone 32 mob count = 246

2009-09-25 13:34:35 map 31, zone 33 mob count = 93

2009-09-25 13:34:35 map *** zone 34 mob count = 94

2009-09-25 13:34:35 map 33, zone 35 mob count = 136

2009-09-25 13:34:35 map 34, zone 36 mob count = 121

2009-09-25 13:34:35 map 35, zone 37 mob count = 0

2009-09-25 13:34:35 map 36, zone 38 mob count = 0

2009-09-25 13:34:35 map 37, zone 39 mob count = 190

2009-09-25 13:34:35 map 38, zone 40 mob count = 228

2009-09-25 13:34:35 map 39, zone 41 mob count = 0

2009-09-25 13:34:35 map 40, zone 42 mob count = 0

2009-09-25 13:34:35 map 41, zone 43 mob count = 0

2009-09-25 13:34:35 map 42, zone 44 mob count = 0

2009-09-25 13:34:35 map 43, zone 45 mob count = 922

2009-09-25 13:34:35 map 44, zone 46 mob count = 852

i has cheked the sql connections, i can connect with the shaiya user and i can query, also i have the "game server"

in the event viewer i have something like
"the Shaiya Game Server service has terminated abrubtaly" or something like that, i cant tell u the exact msg cause my windows is in spanish.

also i try to copy/paste all the hashed passwords in the ini files.

txs to all, i will see what i can do, if i find the solution i will post here

--------->>EDIT<<-----------
i deleted all the databases, then restore all from the "originals" (ZS server files) and all works again.

ty all

Okay, if you guys find any fixes post em here, and I'll add it to the main thread.
You guys will get credited, once this section grows.

wolfnibbles · Oct 12, 2009

First off I'm running xp pro, using ms sql enterprice 2008.
I have been trying to a server, on this try, I run the PSMServer_Mgr all well start up, but the game well stop about 30 secs after it starts up, I right click and go to run again and it does the same thing well run for about 30 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.

drew666 · Oct 13, 2009

Can you please post your Config files here that might help determine where the problem is.

wolfnibbles · Oct 13, 2009

OK, here they are:
PSMServer_Config.ini

Code:

[Main]  
<ip_session> = 127.0.0.1  
<ip_userlog> = 127.0.0.1  
<db_user>    = 127.0.0.1, PS_UserData, Shaiya, F1ED08CF3BD82E02B97C3F337AF27783207A19EF22977BBD9A3D2C59AC1E3CBCAC84F126B86C438B97DDC370AC3F537C0AD9A8BFFF768593DEA25A19842B6DCE9520D1289FA9E718E3653DCD8D39D1C32C4B1B3A9490E09A90BF13F1A4B3E935CB3DAFBCB430BAB019BCA9EEB5B11C1E083B238F82D49F8288838E5BE20EC665

PSMServer_Config.ini

Code:

[Main]

  <ip_session> = 127.0.0.1

  <ip_userlog> = 127.0.0.1

  <db_user>    = 127.0.0.1, PS_UserData, Shaiya, 9469203698A0F1C36BE7ABC6FCFE66E9DC56FAE467C84598DD6E1347D8470E7CE0A1CBF84F94204ADAEA4AA0CCCD52BD4296B2C5A56249B04D9609956DE3FA3BDC6A0C264E01748DB2C267899F75B6146CDE55BE4768232A2B0D80DD34B2F383F117DB49192DB47BF762466AA08790D5BA86CF8AF0C9CE37F72AA65E823A1446



[Login_001]

  <sv_maxuser>  = 10

  <ip_login>    = 127.0.0.1



[GameGroup_001]

  <sv_maxuser>     = 10

  <sv_gameversion> = 0x08022100

  <sv_gamename>    = Shaiya

  <sv_publicip>    = 192.168.254.2

  <ip_game>    = 127.0.0.1

  <ip_dbagent> = 127.0.0.1

  <ip_gamelog> = 127.0.0.1

  <db_game>    = 127.0.0.1, PS_GameData, Shaiya, 8CA7E733DB444246CEC191E520C8830CA1DD18A5AFCE085EC89419610CEB5D580B336F9CBB350AFB92C1B0BA320816141BD8027839DC9CFA85E4765CFC87C972AEA63F62E8DB582188A14966B67C7A36D6480E97DBD5D4874F11BDFD856745C33C3EDA517ABA2D8817F2590DE6E92F3176B635E96AA4B748A4775B666F01C005

  <db_gamedef> = 127.0.0.1, PS_GameDefs, Shaiya, 098BF768DD13E0E3A71AB49E0D04A532046A2F7CC47C7F9C6A3C62F48D6DB9E043DF1EF74D7CEC99E29E49BC31E8165964ADE0BA8457D84D9C6B2630AECFB66833B4518473A9161AC840D9E6D01B1A7438A2C422A72C39B3914582262C22BDBA80DC2A75023409F89C3F927B3E025B45FE6B46B846A2E1CA408931BAEC6E6D50

  <db_gamelog> = 127.0.0.1, PS_GameLog, Shaiya, 8335F53590D65190FDFECE9E13BB69D8ED2AC30EBB48492EB06FAC39DB82ED86753BFFB189B0A9DF5789645ECF5D9B13C4BFA7E52002076A73F044DDD309482F05A9A9E72145A7F5E53EC53DB324560E9A5AE35CFF6057DAC4E30F0F1193B411E759FDE3A377B398AB96E26E2FE94C6097F60E2183482F98D2912B4280A25292

  <db_chatlog> = 127.0.0.1, PS_GameLog, Shaiya, BEB4745EB6D6A6ADFD301363DD258A055C1C2F92604D029CDC3A5DF08A30788987E96FA33298FBCE9062B1B87B3DDB1B295D21E07719FB60A7820212CC72196B03AA44EEA5837B12909CB538917066B4217BACD1258F9093A6687FF09C5579A86C3054AE63C98B634CE4FF7428E40B5FBDBDBF9EEC9F7D1EB53CE4E5EBA3EFAE

ps_game.ini

Code:

[SERVER]
ServerName=Game01
ServerPort=192.168.254.2
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, 71F298915ADF46A0CCBD244BF0AB817A37507BC1F042123FE55A65BC962FE041FAC8C871047438C7A75CB90F7A2BE812C793A28D588BC126A69F612BD18BD37FA8428666675771F0D012B027992BBDE82A9E1A24E5A807ECFA1B78982192F24B6BDE36C6A78A93612BB57CE97A8A1C9305CE164583F6AD3F110E7C6668BB200A
GameData=127.0.0.1, PS_GameData, Shaiya, 570933AF43E12DC8E468362C786C98EC00AD67C2939708DFE509422E7CF818116849BC60AE1329B62581C6D21D01579C6320391D552930375F1E4F271980DD0B359890E77F432F9AC3FB60EB91DB12B14D61F4C550D3A2D4E09624EABFB7496BC16E53D6A4607B73B70D61E781647F7718E784B1CA315DAA93636B69E03E6EE2
[GAMEINFO]
GameName=Shaiya
GamePublicIP=192.168.254.2
GameVersion=0x08022100
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

If you need others, please let me know, Thank you

wolfnibbles · Oct 15, 2009

I just deleted every thing, and started over. But I decided to us the Chinese version, I can log in, and chose the server, but the server never come up, it just stays loading.
Does any one know what would cause that to happen, I looked at all the ini files, and they all have the right ip in the right places, I was thanking it may be in ms sql data base, but I don't really know were to look, or start looking, I need some help here if someone is available.
Here are all my ini files just ioncase:

ps_dbAgent.ini

Code:

[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, Shaiya, 9658B12D2D2CDD6F9DA2D68A0A023A7CBEAD70DD2D256EBBB126FBCB7B48DB86E05E901A6F19D9C2C0A86FA0ECFFEFD8CA45411C2ED167C0E5215F942EEA422F87CA3D193130C40C19F0E188D3BA6F4FF10DAECF74402D0B43E481F73141EB43C0314C3F3A78F692D24E33F97414488CAFB085686E70BCAF0BD83E99F63614AD
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_game.ini

Code:

[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=3000
[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, 5561BCD39225B8E53092D3EC2F276E1D548A5CF03E6D2BD5F780A6B65C2B3BEF877BE47BC66E36D188F4D63062E19B2EDD712B88545EACA43A0F56B3F734C2D3CCD8F6F83B465380794475ABB2D32A7765FE3A1909FBB019D2DE7AE7AB31AC201055D94C00A83169E2C3186C2055403139CD94F513F739FFADD5E9D7B68EE039
GameData=127.0.0.1, PS_GameData, Shaiya, 3BFA3DE9A48C2EBFDE50461973F63CA0B1E55F91782C50320F696FAB54A39C9C2DD72FD5968C1A294C8060F67B10A86C89B98B1B264D09932593820F67148823DB5EEFF265731D327D380B645DACEFCBF5B6BA5846DB8723D5039CFA41F9AA43C32F08864E44B5A1CEF5EB27DFD61C0521AEE7184A29010E0B1FBEA9BA1F9484
[GAMEINFO]
GameName=TestSrv
GamePublicIP=192.168.254.2
GameVersion=0x08022100
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_gameLog.ini

Code:

[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Shaiya, 4232DEFECBB21455E10A2A1280CD68E2FDCC85EDB91A5EBDDAEA28F2A126867A35C114AB39D29604193F5AACCF4CD518D044E614B092AA8452003D210BA99F5394DBAD92218E769DB4BBF3120858976A3F6D45DB709D0A753CDAB30D37D51BF34750C78734E5393661556D8DD2C9AEED71DCDF0049EDCE0BC25295C7BB343DCC
DBChat01=127.0.0.1, PS_ChatLog, Shaiya, F3EB3DA506874D06C465E7A54FC63688A6D3E66D9DF075D1AE034E6EE978E1DF5D1BDE0DAE0033E7052094B5671B4E8E26A62D1CB1846C71B4C9CA6EB0681D74B721B358E30AB8D1239FD83AD2A3F7E99D5818B2CC3CCEC9729A1C489BE45AD2F4D519FA7A5EE816DA4AF6CBD22241FCA84CD0CF0BD0C0A164E210B3477AA8CE
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

ps_login.ini

Code:

[SERVER]
ServerName=Login01
ServerPort=
MaxConnection=5000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, Shaiya, 48C2C2F549BFFD848B6D1ECF240B89C91B320F37FE5442C69231D3A8F41898DD3140969DA4AD32E7CE04BB90AE505F6294675BDAFB7EB00E15A6140922BD02353E9182DCC1FBE3032181A9DC5E207E2C662CF7DA36BDE162EAD2225E46A91BBFE61B55D58DB231920FFF1724C929C9FDE172AE2BFACFE7F54A0D0084D31281B2
[GAMESERVERS]
// Game01 = name, Mapping ServerID, Mapping DB ID(use prev server id)
GameServerCount=1
Game01=Testsvr, 	1, 1


[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_session.ini

Code:

[SERVER]
ServerName=Session
ServerPort=
MaxConnection=

[CONNECTION]
UserLog=127.0.0.1

[GAMESERVERS]
GameServerCount=1
Game01=TestSrv

[LOGFILE]
Replace=0
Append=1

[MONITOR]
Enable=0
Port=50000

ps_userlog.ini

Code:

[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=
[DB]
UserLog=127.0.0.1, PS_UserData, Shaiya, 0D43478F0A81D315F60A1D627FBBA6AC9ABEA65C74951D2F1A63F9CB5A3A9C7F8C26C21B01137D9CC13BCE9AFC8D57D4D2DA651424B0B35D2EDE247A09F5E9CF7243A1ED5A41FA94E6946C773E0275A9585054F32B8EFAC3184A2B00773F8CAAC367E7456E0071CB3CC305E6D8E369E73F16DD385D878C4FCA49EA83C374028D
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

PSMServer_Config.ini

Code:

[Main]

  <ip_session> = 127.0.0.1

  <ip_userlog> = 127.0.0.1

  <db_user>    = 127.0.0.1, PS_UserData, Shaiya, 14DE1E475513A89F7168A68381D567F38083CBB5BE6731900F12900328CA7C694375BA00C355FBBA39895EDC7C0D171056065AE3ED1B2625DF11AB0A2194AA187A2AC96A4C5693E6F7FB3DA4D6D105BA43542ED21F66177BF7C782711E65EE3C46C20A882A0B5DF77C5EBA5A0888368CF1505247B04222D8D7633406EAA54523



[Login_001]

  <sv_maxuser>  = 5000

  <ip_login>    = 192.168.254.2



[GameGroup_001]

  <sv_maxuser>     = 3000

  <sv_gameversion> = 0x08022100

  <sv_gamename>    = TestSrv

  <sv_publicip>    = 192.168.254.2

  <ip_game>    = 127.0.0.1

  <ip_dbagent> = 127.0.0.1

  <ip_gamelog> = 127.0.0.1

  <db_game>    = 127.0.0.1, PS_GameData, Shaiya, B85E22B9E58EE2704670029B81DF2783D6F823771DF053874DB5CCB4CDEC926DE1F307062381127940AC14010709627E0B4EA64D7AC06A04DD5EA63FDE4967B1EB127BEB0CCA7C94687E82E1EB7578DB0552CD5A77F65CFF8E5F8DB0AE5B55B46D7D073028C8212DAE9C561A81BD05EAFD94A6AA1F3F3F3BF3BA5971D13023FC

  <db_gamedef> = 127.0.0.1, PS_GameDefs, Shaiya, 7DC78C1674389BDC74C973A119D3CC26A88B569EA42D1E1030C5D20E20DDB5F3451382F89E3677949851489B92EE17B7A8D062FAED360E4D27F1DEE9C4EFF351C8F01B9A3A4095260F563328C49E3DF9DF6AA0F57031954D09CF6985679FEE342350E317E975552363623DDACB232EA8F8FB10978EEB4FCD305B1B4500FC4F39

  <db_gamelog> = 127.0.0.1, PS_GameLog, Shaiya, D0F55B06F4A39A1CC65563D1B143ADAB7569A447F565CC2F6C01F600A8FA3BD02CBD5EA1EE2E1E9631B10E105CBC6438F787D0B8C041B8C46F72A2AE81A478A04784195E9795FC87451A081358917ACDED295EF9D3DA250F9B21547EDBBB84DA04635E6D99552D696BC626FE6EC84A5631E80D378CC7246E909A817E464F5423

  <db_chatlog> = 127.0.0.1, PS_ChatLog, Shaiya, A83311FE7B785B48876C3E2BF54343A8E2483B2D647442DAEAFE3E728BBA6F3D960323752AF07D1FEA4B6FAF8E034A2771BA3E96596A36F6A3D5C83AA08C5290FBC63895DFCDA7B8390DD5E65B9046877784444748F3B6C92F9AEA62827B2AE2A5F619D115B5C35DC60686A1D214DC50FD000858CC88F2DC97DA9CABA080679A

PS_GMTool.ini

Code:

[OPEN_SERVER]
IP=192.168.254.2

[TEST_SERVER]
IP=192.168.254.2

[SQL_PORT]
PORT=2163

I don't know if I should change the port number, the ip I us here don't go through a router, but I am not sure if that pertains to this port.

PSM_UpdateServer.ini

Code:

192.168.254.2:40901

Just like the other one, I dont know where this port goes.

ps_dbAgent.ini

Code:

[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, Shaiya, 9658B12D2D2CDD6F9DA2D68A0A023A7CBEAD70DD2D256EBBB126FBCB7B48DB86E05E901A6F19D9C2C0A86FA0ECFFEFD8CA45411C2ED167C0E5215F942EEA422F87CA3D193130C40C19F0E188D3BA6F4FF10DAECF74402D0B43E481F73141EB43C0314C3F3A78F692D24E33F97414488CAFB085686E70BCAF0BD83E99F63614AD
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_game.ini

Code:

[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=3000
[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, 5561BCD39225B8E53092D3EC2F276E1D548A5CF03E6D2BD5F780A6B65C2B3BEF877BE47BC66E36D188F4D63062E19B2EDD712B88545EACA43A0F56B3F734C2D3CCD8F6F83B465380794475ABB2D32A7765FE3A1909FBB019D2DE7AE7AB31AC201055D94C00A83169E2C3186C2055403139CD94F513F739FFADD5E9D7B68EE039
GameData=127.0.0.1, PS_GameData, Shaiya, 3BFA3DE9A48C2EBFDE50461973F63CA0B1E55F91782C50320F696FAB54A39C9C2DD72FD5968C1A294C8060F67B10A86C89B98B1B264D09932593820F67148823DB5EEFF265731D327D380B645DACEFCBF5B6BA5846DB8723D5039CFA41F9AA43C32F08864E44B5A1CEF5EB27DFD61C0521AEE7184A29010E0B1FBEA9BA1F9484
[GAMEINFO]
GameName=TestSrv
GamePublicIP=192.168.254.2
GameVersion=0x08022100
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_gameLog.ini

Code:

[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Shaiya, 4232DEFECBB21455E10A2A1280CD68E2FDCC85EDB91A5EBDDAEA28F2A126867A35C114AB39D29604193F5AACCF4CD518D044E614B092AA8452003D210BA99F5394DBAD92218E769DB4BBF3120858976A3F6D45DB709D0A753CDAB30D37D51BF34750C78734E5393661556D8DD2C9AEED71DCDF0049EDCE0BC25295C7BB343DCC
DBChat01=127.0.0.1, PS_ChatLog, Shaiya, F3EB3DA506874D06C465E7A54FC63688A6D3E66D9DF075D1AE034E6EE978E1DF5D1BDE0DAE0033E7052094B5671B4E8E26A62D1CB1846C71B4C9CA6EB0681D74B721B358E30AB8D1239FD83AD2A3F7E99D5818B2CC3CCEC9729A1C489BE45AD2F4D519FA7A5EE816DA4AF6CBD22241FCA84CD0CF0BD0C0A164E210B3477AA8CE
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

ps_login.ini

Code:

[SERVER]
ServerName=Login01
ServerPort=
MaxConnection=5000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, Shaiya, 

48C2C2F549BFFD848B6D1ECF240B89C91B320F37FE5442C69231D3A8F41898DD3140969DA4AD32E7CE0

4BB90AE505F6294675BDAFB7EB00E15A6140922BD02353E9182DCC1FBE3032181A9DC5E207E2C662CF7

DA36BDE162EAD2225E46A91BBFE61B55D58DB231920FFF1724C929C9FDE172AE2BFACFE7F54A0D0084D

31281B2
[GAMESERVERS]
// Game01 = name, Mapping ServerID, Mapping DB ID(use prev server id)
GameServerCount=1
Game01=Testsvr, 	1, 1


[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_session.ini

Code:

[SERVER]
ServerName=Session
ServerPort=
MaxConnection=

[CONNECTION]
UserLog=127.0.0.1

[GAMESERVERS]
GameServerCount=1
Game01=TestSrv

[LOGFILE]
Replace=0
Append=1

[MONITOR]
Enable=0
Port=50000

ps_userlog.ini

Code:

[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=
[DB]
UserLog=127.0.0.1, PS_UserData, Shaiya, 0D43478F0A81D315F60A1D627FBBA6AC9ABEA65C74951D2F1A63F9CB5A3A9C7F8C26C21B01137D9CC13BCE9AFC8D57D4D2DA651424B0B35D2EDE247A09F5E9CF7243A1ED5A41FA94E6946C773E0275A9585054F32B8EFAC3184A2B00773F8CAAC367E7456E0071CB3CC305E6D8E369E73F16DD385D878C4FCA49EA83C374028D
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

I hope that someone can help here and that I gave all that info you need, I us Windows pro, and ms swl ent. 2008.
If there is anything else that you need to know please let me know and I well post it.
Thank you

ledok · Oct 16, 2009

you choose the server, then everything freezes at loading?
if i understood you correctly, then after a while (2-3min) should see a window with an error.
Try it first -

You must be registered to see links

(i changed it to your IP - 192.168.254.2)

wolfnibbles · Oct 16, 2009

ledok said:
you choose the server, then everything freezes at loading?
if i understood you correctly, then after a while (2-3min) should see a window with an error.
Try it first -
You must be registered to see links
(i changed it to your IP - 192.168.254.2)

Thank you, I tried it, its the wrong game, I am trying to make a Shaiya 2 private server. It is only available in China (testing stage).
But you did give me the area were to look, Thank you

ledok · Oct 16, 2009

sorry, I only worked with the US client
with the Chinese, I did not work (

Welcome!

[HelpDesk]Fixes | Ask For Help | Q&A | Updated

Custom Title Activated

Custom Title Activated

Newbie Spellweaver

Custom Title Activated

Newbie Spellweaver

Custom Title Activated

Newbie Spellweaver

Custom Title Activated

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Initiate Mage

Custom Title Activated

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor