Does anyone actually know how to save this problem?

missesme · 06/30/2010, 10:09

Ok so i've been following the tuts on how to create a pserver and they've been helpful but only up to a certain point. We've had about 3 different people that are involved in our server try to get past it and they can't solve the issue either. I've searched google, Youtube and all over this forum, i've seen plenty of people with the problem but the responses i've been seeing are "figure it out yourself" and "you must not have followed the tut correctly" well we followed the tut to the letter a few times and still get the same error, so what i'm seeing now is "i have no clue how to fix it so i'm going to leave you in the dark" whenever i look at the responses by "skilled" hackers.

So heres the issue, you open PSMServer_Mgr go to "Control Service" select "start all server service" and all the "ll" turn into ">"....... thats all well and good but how do you stop it from turning back to "ll" 15 seconds later. I've tried searching for problems with the .ini files in my client Binary files but i'm not completely sure what i'm looking for, maybe someone could post what each of the notepad works should say? and in my client system logs like some people have said i should look i see nothing in the actual folder...

Wells this is what my separate .ini files say:

ps_dbAgent

[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, Shaiya, 5DF59870228E618AD213434D5607805F4B12780FB64F364914 7635F3FCE26CE5A5F9984F1C30D7CB26E18F4BE33CE12A7736 E92E39500F711DAB9FC6A01D863F416B0B719C23511BED7529 93915E02BF5DB6B859A35AAEC93E87F8E217D6220F4F5043AC B5BE5BD5760D2B3B5B309AEA27258E17BF71A82CF4E221992A 813686
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_game

[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=10
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDef=127.0.0.1, PS_GameDefs, Shaiya, 6C8DB9E6855CDB4C67CDDAA53E2F9E24E096AE76F1178383C3 1C5AD7E1A819B2AB5323A2BFBC34153590D10370F3EC6DE1A4 B0EE1F473B7887045A04AD7AFA276F91D36D85DA282826FC7B 78A5A174EE0A3C2AD5E3A022E4F4BAAF2B077C9430EC698710 5493948106A51108C2435E58F045A0C806B4A248F03D0A2D77 800A91
GameData=127.0.0.1, PS_GameData, Shaiya, BF7D69A385D01E5DE337ED047256087C7E740061C7283316F6 1E7ABC2C53985D1E40C72C788DC81A42A141DF49DA648825EF 7B4069BD7CAB7C86AD7CCC434BAD05399C31BFD3686A1B11D2 AEF062628CF9D612C59CACF7B6FF245BB24E65E78DF33718C5 4E7D2463D2201172FFF07E41C8292F308B990EC931A7E0FB20 3EC5B6
[GAMEINFO]
GameName=SHAIYA_SERVER
GamePublicIP=127.0.0.1
GameVersion=0x08022100
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_gameLog

[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Shaiya, 1A3FDDCF30829F3A71792BE5B1E304A69785B9CD328F7733D1 44D4C97869E3203C52C01A9FD1E2241817799E66E7455449B2 0663531CAC9DA89163BB3ABED90A7E5F7F689EE163EBD5880D 205EBA3107A65101F94BEC8539AE0ECB4E4AE76385261CC222 1167913BA34880B19AD0263577C9F7E8CEFBC27A1894ABB91D 9F06A3
DBChat01=127.0.0.1, PS_GameLog, Shaiya, 06D7585AC02E89711B74480F6FDCEE80826836655AEC3530F5 914DB2ED2E23D0C5325FA6EFDFA5FBB37933FC2C30E05A67DE 4F722D0AAA45ED523528F1F9B99E069EC10A4780223919EF02 48B41F10DBDD5915A1E72DC7BEFC03064B6A1EB28BDC7767DE DE80E2C49EDF27F331598B63341C3A6E1D0950E37B94C81AB0 F629B5
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

ps_login

[SERVER]
ServerName=Login01
ServerPort=
MaxConnection=10
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, Shaiya, CF4DF9120680DD8A3DF05E1504F7366994F844D8590D6AE522 2D841D4D572F6408DD836DCDF05E357F5A55CE24955F3C0EAE 136E4CFAB0141C6D9499623526304D5223C5C9F88F1630ACC3 44420F252FC01FC1BC2C7C673F01BBA1C404B8B7B5B1CBE486 72CC0B48DDB6D9AF0626B9D25C63EDD893B96A88EDC5420B84 C5F1B2
[GAMESERVERS]
// Game01 = SHAIYA_SERVER, Mapping ServerID, Mapping DB ID(use prev server id)
GameServerCount=1
Game01=Game, 1

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

ps_session

[SERVER]
ServerName=Session
ServerPort=
MaxConnection=

[CONNECTION]
UserLog=127.0.0.1

[GAMESERVERS]
GameServerCount=1
Game01=SHAIYA_SERVER

[LOGFILE]
Replace=0
Append=1

[MONITOR]
Enable=0
Port=50000

ps_userlog

[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=10
[DB]
UserLog=127.0.0.1, PS_UserData, Shaiya, 7427BE8A8A278E266ACBF05DF33B823012CC3A1F129615165E 1C26FAE7CE50C127D1041F0795BDAE71956EDCD6044EB5BA27 2ED083DAAC1F9BAD221379229037242AADACE62A520AC68DDD F84B36E718C2D2F2EF655440E5DBA039AA6D4455797EBAD2DF 93819D82108FC6314F9A2C23585BDAF558F0140AE4B1814A31 19745B
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

Ok so thats all my .ini files. If anyone with a fully running server has anything different or anyone has found a solution to this problem please let me know.

Thanks

Byte//Belle

AriezOMG · 06/30/2010, 13:18

post the logs so we might see the problem.

13latrix · 06/30/2010, 14:13

Logs tell you everything you need to know. However when I use to run my CB on a personaly PC I experienced the same probly. What I did was continously started the servies till they stayed on.

Since I moved our server to a true dedicated server, I havnt experienced this issue again. The logs should report any errors within the server files tho. More than likely a simply ini error. Best of luck.

~Phish

missesme · 06/30/2010, 15:20

Quote:

Originally Posted by Apocalypsist

post the logs so we might see the problem.

Well this is my client logs after restarting my computer:

PSM_AGENT__system.log__20100630_172613

2010-06-30 19:25:00 PSM_AGENT__system log start (PS_AGENT)

In client Binary Logs i have about 20 or so things so i'll not bother reposting duplicates, heres the separate messages:

PS_USERLOG__system.log__20100630_192729

2010-06-30 19:27:29 PS_USERLOG__system log start (UserLog)

2010-06-30 19:27:29 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

2010-06-30 19:27:29 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-06-30 19:27:29 PS_USERLOG__system log end (UserLog)

2010-06-30 19:27:29 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_SESSION__system.log__20100630_192729

2010-06-30 19:27:29 PS_SESSION__system log start (Session)

2010-06-30 19:27:30 userlog connect failed

2010-06-30 19:27:30 initserver() failed

2010-06-30 19:27:30 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-06-30 19:27:30 PS_SESSION__system log end (Session)

2010-06-30 19:27:30 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_LOGIN__system.log__20100630_192729

2010-06-30 19:27:29 PS_LOGIN__system log start (Login01)

2010-06-30 19:27:29 DB userdata connect error, id=Shaiya, pass=Shaiya123

2010-06-30 19:27:29 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-06-30 19:27:29 PS_LOGIN__system log end (Login01)

2010-06-30 19:27:29 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_GAMELOG__system.log__20100630_192729

2010-06-30 19:27:29 PS_GAMELOG__system log start (GameLog01)

2010-06-30 19:27:29 DB gamelog connect error

2010-06-30 19:27:29 init db error

2010-06-30 19:27:29 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-06-30 19:27:29 PS_GAMELOG__system log end (GameLog01)

2010-06-30 19:27:29 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_GAME__system.log__20100630_192729

2010-06-30 19:27:29 PS_GAME__system log start (Game01)

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/sorp1

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/croco1

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/croco2

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/Troll1

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/Spink1

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/GoldenPig

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/Sorp3

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/SorpNamed1

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/SorpNamed2

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/Sorp2

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/CrocoNamed1

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/CrocoNamed2

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/CrocoNamed3

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/OrcNamed1

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/OrcNamed2

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/OrcNamed3

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/TrollNamed1

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/Deinos

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/Parridalis

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/Alcarian

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/ZinAlcaria

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/Belizabeth

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/Kirhiross

2010-06-30 19:27:29 Loaded Behavior In Factory : data/ai/CrypticOne

2010-06-30 19:27:29 DB gamedef connect error

2010-06-30 19:27:29 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-06-30 19:27:29 Call save all waiting...

2010-06-30 19:27:29 Call save all failed dbagent disconnected(user count = 0)...

2010-06-30 19:27:29 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-06-30 19:27:29 Save MobID=1963109

2010-06-30 19:27:29 PS_GAME__system log end (Game01)

2010-06-30 19:27:29 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_DBAGENT__system.log__20100630_192709

2010-06-30 19:27:09 PS_DBAGENT__system log start (DBAgent01)

2010-06-30 19:27:09 DB gamedata connect error

2010-06-30 19:27:09 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-06-30 19:27:09 DBKillCountSave db alloc failed

2010-06-30 19:27:09 SAVE kill count ERROR

2010-06-30 19:27:09 CKeepObeliskMgr:: DBSave db alloc failed

2010-06-30 19:27:09 SAVE g_KeepObeliskMgr ERROR

2010-06-30 19:27:09 GuildMgrSave:: DBSave db alloc failed

2010-06-30 19:27:09 SAVE g_GuildMgrSave ERROR

2010-06-30 19:27:09 PS_DBAGENT__system log end (DBAgent01)

2010-06-30 19:27:09 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_DBAGENT__charsave.log__20100630_192729

//PS_DBAGENT__charsave log start (DBAgent01)

//PS_DBAGENT__charsave log start (DBAgent01)

Thats all my Client Binary logs. The spaces between : and "D" arent in the log but if i post it here i get

dreadsoul · 06/30/2010, 15:39

im haven the same issue me and miss are workn on the same server except i have no logs like what shes posted here so if anyone can help us it would be awsome ty for all the help you guys give when its given

sunder702 · 06/30/2010, 22:23

Which OS and which edition of SQL server are you using?

shinru2004 · 06/30/2010, 22:30

what server files are you using.... and sql? Your not connecting to ps_gamedefs. check your passwords on all ini's

AriezOMG · 07/01/2010, 00:35

You need to run your SQL and turn on services and switch up the ip at top with 127.0.0.1 to get this to work from the looks of it your not running your services at 127.0.0.1 you will also need to install SQL properly make sure you get Standard or Express.

dreadsoul · 07/01/2010, 01:43

Quote:

Originally Posted by Apocalypsist

You need to run your SQL and turn on services and switch up the ip at top with 127.0.0.1 to get this to work from the looks of it your not running your services at 127.0.0.1 you will also need to install SQL properly make sure you get Standard or Express.

thats alrdy been done and yes we have those been usen em sicne we started

missesme · 07/01/2010, 02:09

Quote:

Originally Posted by shinru2004

what server files are you using.... and sql? Your not connecting to ps_gamedefs. check your passwords on all ini's

I'm using the files off Zero and Prof's server tutorials, all the things they said we should download is on my computer atm. Using the top 2 downloads off his link to MSQL.

Heres my server .ini files:

__temp_PSMServer_LogGather

127.0.0.1|psm_client\main|AgentLog

127.0.0.1|gameserver\main|ServerLog

__temp_ServerPatch_DBList

127.0.0.1, PS_UserData, Shaiya, EC64CB4C09B1BD916951BAE6D73B7121D0DC5171D6E1AEF28C E47C27A73F748662769A811EE08FAA7D646BD567F39840FFE3 06F03950134C4D3CB75079D927D83C68A22A16A2E99B2D150C 53363300B5B3F397941A2A0BABF9E90F1FE3BC412E6D8E33E1 8AE4C52745626FCE2FBEDA65C095AEF1366D5EA4C830C0F4EA 8FEB23

127.0.0.1, PS_GameData, Shaiya, FF5EA2B39107805A515EC954FC0271FB74BB9CA22C5728E4FE 437C2B4DE3F1E3F1CA99F3862B74B28989B6F2048D0DECC4E5 04E65E793FBEB975001161E84B092F493F5F080F6973F75CC9 B11EED7D331AFB7CFA700B7868CFDC325507478E983A353E45 8CC87C12EF37B2130464C6DF7E5DA8A9E4FEDF76BE248F9455 6B2D10

127.0.0.1, PS_GameDefs, Shaiya, 547B396CF7B205DED789FF271A76CD92DA4396D3EF0AE16BC9 0875C01B2F061D2B09574B78949359E0F4789BE8C74724990F 7F7109F4FC17D8A3591C7A94729C4D3FAED0B09536539311D7 921C3DFAD219D19ADB9D5318DF38C68542C7ED223D89080A8E 883DAD998F842DA54567F44E50C6AF99D937E33680087D6998 3C64C8

127.0.0.1, PS_GMTool, Shaiya, 4A832BC4761D09636AB6030188615D9D6272E49A6AFE38CD4B 1403EBBED11AEAD24C962B8BA2B31DF64C94E5CB794E00D6D9 6C5BD5ABB9A8365F185473634AA7CD4F17118E85B17E627E3D BB29E5D7F2255F5BF1BF5D367175AC301E13BE065126949AE9 C502B00978BC96F3B06B4E3A1D5D4F5175887869A24A860ED9 F31CC3

127.0.0.1, PS_GameLog, Shaiya, B7BB6945BC4E8C55175C62BEB58991D5AEBA12C3C725A633A2 CE571D1D4575F9A4A47C80CA34D9511998B431BAA9891267E2 04A1D5EBF8A40B07AE77CBFE686FFE0531B16A2C86F7FC304E FBAAFEDD63C10221FAE3D5EEB3CD9FE9312E428C853533750A B7528CB354B70CB477E253327389B5D854641FC77F04111AA6 316A08

127.0.0.1, PS_GameLog, Shaiya, F03579955D3FB8D05A717A55F9E901E1C292CF051243D2911E DDB14F74A2292AD41209E247A047F356005A00CFE46BF5A89C 9DC4CBEE7936ECC4C8B3F6752AFA806BE1B510FB6256CDADB0 E378809FF0857515AC6F9C0CCD3A4E5B85C01FCE8B65E8D311 3034A83B49A43438FD99FE574C7D8BC08006F03BCD4095D62B 269B89

PSMServer_Config

[Main]

<ip_session> = 127.0.0.1

<ip_userlog> = 127.0.0.1

<db_user> = 127.0.0.1, PS_UserData, Shaiya, B41FEEAC7EF669B3C888CA009F963F3B139FFAA76D6524D301 191F46C9C4ADF703DB0DAAE5F562C66FFF833408F6BB2262F4 61CC351EEFCF794C3F4D701272A9198F4BCA07F4E1131B068F F75609BAD263DABEB43C5F9288306DD67C562B9D4A3439CC48 219FD0398C90B9648952D916F7121AB2B986FCEB16C746BCBC 395610

[Login_001]

<sv_maxuser> = 10

<ip_login> = 127.0.0.1

[GameGroup_001]

<sv_maxuser> = 10

<sv_gameversion> = 0x08022100

<sv_gamename> = Game

<sv_publicip> = 127.0.0.1

<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, 36EB7544E6417B9830B8F95311C3DF1AAE86F276FC34368663 FD68D59DFE2A44F89DA7784D448CCC2EC156455D4E5F47AC05 C9CD221E6AFA63434D49F027248A505F2A8491C799D6CE7CB2 CABB533ED63F318802129DC0C4D2D68F5558E13E35E3D07D14 FD4BFBB4E72651CDD5B6E85D2A12BAE9A148FAC0536C900775 BA94DD

<db_gamedef> = 127.0.0.1, PS_GameDefs, Shaiya, 13577F0CDF4CCD2B8B3E9D798625B8C9DE30CF00F91CD8D556 1B4E0F25EE1DC0BEB1461C26138D3C63BFDC373D22D9A35A99 248E25F190141E7F0FDC4444A773C06E99F46E7BA4C8EB51D6 2F4C782FCBA4F8476460A7AFDEB73B7E873BF2B9CF25A1D15A F4995B8EED25F97F2E56421D2161C08FFCB5417ECFB3FFB3CE D027F5

<db_gamelog> = 127.0.0.1, PS_GameLog, Shaiya, BA724A1C68254840F5893FBA413CCD4DEF62D36C91D39B4385 0168223A695AA1CEA4750C39A086EC9C3D9571F2665111790B 4FEA54E278253C06AEAB4B6AE6C4ACDB85C71F4E9E1B00D6C2 640E275A0BCA16FA3695719FF5D6B0448504F619C9BA81429B 45D89C384842A9DDB86BD400CA95249542516660FED750D122 CE2CC0

<db_chatlog> = 127.0.0.1, PS_GameLog, Shaiya, 52FB20850EA54BFD9071321085041F6B525A18CC1F6954C05B 6E5C50D48DE7E75A08C98604196B158CB30D9521B6D1F1027B 9DE4D5A9EA7C7F03C2506364B2456AF00D04BC7C2D37899D46 2D95C7FC6C4298F3A26713B132D3D5A05B32DF5C6DE56D22D3 4B56F7513F08748CDBB769A84C88EA235176371AE12941B2FD EE75B0

PSMServer_Patch_PatchInfo_Config

// filename disable char \ / : ? " < > |

[PATCH_COPY_FILE_LIST]

///////////////////////////////////////////////////////////////////
// agent server

<file_target_path> = ./
<file_src> = dbgeng.dll
<file_src> = dbghelp.dll
<file_src> = ps_passwordEnc.exe
<file_src> = psm_passwordEnc.exe
<file_src> = PSMServer_Agent.exe
<file_src> = PSMServer_Agent.pdb
<file_src> = PSMServer_AgentInstall.exe
<file_src> = PSMServer_LogGather.exe
<file_src> = PSMServer_Mgr.exe
<file_src> = PSMServer_ServiceMgr.exe
//<file_src> = PSMServer_Patch.exe

// check please
<file_target_path> = ./Config
//<file_src> = PSMServer_Patch_PatchInfo_Config.ini

///////////////////////////////////////////////////////////////////
// agent client

<file_target_path> = ShaiyaServerPatch/Agent/Common
<file_src> = dbgeng.dll
<file_src> = dbghelp.dll

<file_target_path> = ShaiyaServerPatch/Agent/Main
<file_src> = PSM_Agent.exe
<file_src> = PSM_Agent.pdb
<file_src> = PSM_AgentInstall.exe
<file_src> = PSM_ServiceMgr.exe

<file_target_path> = ShaiyaServerPatch/Agent/Main/Config
<file_src> = PSM_Agent.ini
<file_src> = PSM_Share.ini

///////////////////////////////////////////////////////////////////
// ServerMain

<file_target_path> = ShaiyaServerPatch/Server/ServerMain/PS_UserLog
<file_src> = ps_userlog.exe
<file_src> = ps_userlog.pdb

<file_target_path> = ShaiyaServerPatch/Server/ServerMain/PS_Session
<file_src> = ps_session.exe
<file_src> = ps_session.pdb

<file_target_path> = ShaiyaServerPatch/Server/ServerMain/PS_Login
<file_src> = ps_login.exe
<file_src> = ps_login.pdb

///////////////////////////////////////////////////////////////////
// GameMain

<file_target_path> = ShaiyaServerPatch/Server/GameMain/PS_GameLog
<file_src> = ps_gamelog.exe
<file_src> = ps_gamelog.pdb

<file_target_path> = ShaiyaServerPatch/Server/GameMain/PS_DBAgent
<file_src> = ps_dbagent.exe
<file_src> = ps_dbagent.pdb

<file_target_path> = ShaiyaServerPatch/Server/GameMain/PS_Game
<file_src> = ps_game.exe
<file_src> = ps_game.pdb

<file_src> = ggsrv*.dll
<file_src> = ggauth*.dll
<file_src> = csauth*.cfg

///////////////////////////////////////////////////////////////////
// Game data

<file_target_path> = ShaiyaServerPatch/Server/GameMain/PS_Game/Data
<file_src> = KillStatus.SData
<file_src> = NpcQuest.SData
<file_src> = ItemCreate.ini
<file_src> = Obelisk.ini
<file_src> = Map.ini
<file_src> = mob_ai.ini
<file_src> = *_string.db

<file_target_path> = ShaiyaServerPatch/Server/GameMain/PS_Game/Data/Map
<file_src> = *.svmap

<file_target_path> = ShaiyaServerPatch/Server/GameMain/PS_Game/Data/AI
<file_src> = *.ac
<file_src> = *.afs
<file_src> = *.ah
<file_src> = *.ai
<file_src> = *.alo
<file_src> = *.pai

///////////////////////////////////////////////////////////////////
// Game tool

<file_target_path> = ShaiyaServerPatch/Agent/Update_ForGMTool
<file_src> = PSGMTool.exe
<file_src> = PSM_Update.exe
<file_src> = PSM_StartUpdate.exe

<file_target_path> = ShaiyaServerPatch/Agent/Update_ForGMTool/Config
<file_src> = Language.lng
<file_src> = PSM_Update.ini
<file_src> = PSM_UpdateExcute.ini
<file_src> = PS_GMTool.ini
<file_src> = PSM_UpdateServer.ini

<file_target_path> = ShaiyaServerPatch/Agent/Update_ForGMTool/Data
<file_src> = NpcQuest.SData

[PATCH_SQL_DATA_LIST]
<sql_target_db> = PS_GameDefs
<sql_src> = *ExpDataExport*.sql;*ExpDataExport*.txt
<sql_src> = *BaseIemDataExport*.sql;*BaseIemDataExport*.txt
<sql_src> = *CharHPSPMPDataExport*.sql;*CharHPSPMPDataExport*. txt

<sql_src> = *ProductList*.sql;*ProductList*.txt;
<sql_src> = *ItemSellList*DataExport*.sql;*ItemSellList*DataEx port*.txt
<sql_src> = *ItemBuiling*DataExport*.sql;*ItemBuiling*DataExpo rt*.txt
<sql_src> = *ItemBilling*DataExport*.sql;*ItemBilling*DataExpo rt*.txt

<sql_src> = *ItemDataExport*.sql;*ItemDataExport*.txt
<sql_src> = *MonsterDataExport*.sql;*MonsterDataExport*.txt

<sql_src> = *SkillDataExportMob.sql;*SkillDataExportMob.txt;
<sql_src> = *SkillDataExport.sql;*SkillDataExport.txt
<sql_src> = *SkillDataExportMob_*.sql;*SkillDataExportMob_*.tx t;
<sql_src> = *SkillDataExport_*.sql;*SkillDataExport_*.txt

//<sql_src> = *SkillDataExportMob*.sql;*SkillDataExportMob*.txt
//<sql_src> = *SkillDataExport*.sql;*SkillDataExport*.txt

[PATCH_SQL_SCHEMA_LIST]
// <sql_target_db> = PS_GameDefs
// <sql_src> = *PS_GameDefs*.sql

// <sql_target_db> = PS_UserData
// <sql_src> = *PS_UserData*.sql

// <sql_target_db> = PS_GameData
// <sql_src> = *PS_GameData*.sql

// <sql_target_db> = PS_GameLog
// <sql_src> = *PS_GameLog*.sql

// <sql_target_db> = PS_ChatLog
// <sql_src> = *PS_ChatLog*.sql

// <sql_target_db> = PS_GMTool
// <sql_src> = *PS_GMTool*.sql

Quote:

Originally Posted by Apocalypsist

You need to run your SQL and turn on services and switch up the ip at top with 127.0.0.1 to get this to work from the looks of it your not running your services at 127.0.0.1 you will also need to install SQL properly make sure you get Standard or Express.

This is what my SQL looks like when i run the program:

all the passwords are Shaiya123.

sunder702 · 07/01/2010, 02:14

The reason I'm asking which sql server edition you've installed is because I have different routines for setting each up. for example, I just installed the shaiya server on windows 7 about 2 hours ago with sql server 2008 express w/advanced text services and how I did it was different from when I did the server with 2005 express.

missesme · 07/01/2010, 02:18

Quote:

Originally Posted by sunder702

The reason I'm asking which sql server edition you've installed is because I have different routines for setting each up. for example, I just installed the shaiya server on windows 7 about 2 hours ago with sql server 2008 express w/advanced text services and how I did it was different from when I did the server with 2005 express.

i think i'll use 2008 cos idt SQL 2005 is overly windows 7 friendly, would you mind telling me the process you used? and posting the link to the 2008 version please

sunder702 · 07/01/2010, 03:54

Make sure to get either the SQLEXPR_x86_ENU.exe or SQLEXPR_x64_ENU.exe depending on OS, not the SQLEXPR32_x86_ENU.exe.

I made sure to use a named instance(naming the instance MSSQLSERVER) because the naming conventions where changed between 2005 express and 2008(Who knows it may just work with default instance, but why take the chance).

make sure the database engine runs as a Network service and the Reporting service as a local.

use mixed mode auth. add your local login as an admin.

in Server Management Studio, make sure to go to Tools/Options and uncheck "Prevent saving changes that require table re-creation." or else you won't be able to save changes to your tables that had a "not null" value set.

After the installation is complete, run the configuration manager an enable tcp for both the server and client protocals.

you may get a warning message at the end of the installation. thats a known issue and can be ignored.

missesme · 07/01/2010, 05:50

Quote:

Originally Posted by sunder702

Make sure to get either the SQLEXPR_x86_ENU.exe or SQLEXPR_x64_ENU.exe depending on OS, not the SQLEXPR32_x86_ENU.exe.

I made sure to use a named instance(naming the instance MSSQLSERVER) because the naming conventions where changed between 2005 express and 2008(Who knows it may just work with default instance, but why take the chance).

make sure the database engine runs as a Network service and the Reporting service as a local.

use mixed mode auth. add your local login as an admin.

in Server Management Studio, make sure to go to Tools/Options and uncheck "Prevent saving changes that require table re-creation." or else you won't be able to save changes to your tables that had a "not null" value set.

After the installation is complete, run the configuration manager an enable tcp for both the server and client protocals.

you may get a warning message at the end of the installation. thats a known issue and can be ignored.

ok i got all that done but it still switches to pause >.>any other good ideas?

sunder702 · 07/01/2010, 16:44

where there any errors when you ran config.sql?