[PROGRESS] of fixing the Server files!

[gercreed]

Anyone knows where the problem in the _REFSKILLMASTERY is ? Because there are all columns entered and it still gives an error :-(

[kevin_owner]

if you have that exception error just delete all records there is some wrong data in it.

[gercreed]

Yeah thank you but there is one more problem:
I deleted some records but im stucking now at the _REFSKILL Table! I can delete as much as I want but the Gameserver and the shardmanager are showing the same error ! Does anybody fixed this error already ?

Ty

[kevin_owner]

_REFSKILL gives you a DBtable failed error right? wel there is a column probably more which is wrong i skipped it to delete almost all the columns i had 3 left or something like that i don't know how much it exactly is but that was a test to see if it works. but the talbes doesn't load if you delete so much columns i didn't test it very well but that is what i did.

[zikor1337]

Originally Posted by DaRealMadafaka

New config file
You can change text on Launcher.

WTF? You kinda missed the section.

[ChaotiC1]

Thats what happens when u drink a bit 2 much... lol

so what do u guys need 2 run this files

[3lyka]

Originally Posted by ChaotiC1

Thats what happens when u drink a bit 2 much... lol

so what do u guys need 2 run this files

Full DataBase...you have it?

[xvaidasxx]

So,um files are fixed? SMC.exe etc..? and need only DB?

[silkbotter]

unfortunately not

[kevin_owner]

is this well connected or do i forget to link something or to the wrong managers.

it looks like these are the only managers/servers but there are a lot more below when i delete those the globalmanager freezes but it can cert other servers so i got to figure out what that is.

[silkbotter]

the globalmanager you posted seems to be correct..
now proceed to the shardmanager (the one thats causeing huge problems!!)

[Mudzas]

Hm. I am trying at this time change configuration for "ips.ini" and "link.ini" i think it going success. I am just need Sro Server List to see is server are online. Can someone post it? Thanks

[kevin_owner]

You won't get the server online with only changing the link.ini and ips.ini:P



here is a server list thing. add a new line to the config.ini with 127.0.0.1 or whatever you're using.

btw did you removed all those extra gameservers and machine managers? cuz my globalmanagers keeps freezing when i have less than 54 servers in port.ini i don't know how many servers in ips but it was somehere in 40 and when i change the count of linki.ini it freezes:P

@lucianoaibar or someone else who know it. What does that SR_gameserver.dll do does it only make a connection with the database? when i deleted it the gameserver doesn't connect to the database but when i add these 2 lines in the server.cfg

AccountDBConfig "DRIVER={SQL Server};SERVER=127.0.0.1;DSN=Silkroad;UID=sa;PWD=1 234;DATABASE=Silkroad"
SilkDBConfig "DRIVER={SQL Server};SERVER=127.0.0.1;DSN=Silkroad;UID=sa;PWD=1 234;DATABASE=Silkroad"

(copy paste from globalmanager)it connects to the database.

[pownbear]

fffuuu who reported my post

btw these are a few procedures we're missing for sure

exec _CheckCharName %d,'%s',%d,%d"
exec _ManageShardCharName %d, %d, %d, '%s', '%s'"
exec _AddLoginHistory %d,%d,%d"
exec _QueryUser '%s'"
exec _GetSMLog %d, '%s', '%s', '%s'"
exec _ViewContentUser %d,'%s'"
exec _GetUserJID '%s'"
exec _GetUserInfo %d"
EXEC _UpdatePunishment %d,%d,%d,'%s', %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s'"
EXEC _RegisterPunishment %d,%d,'%s',%d,'%s','%s','%s','%s','%s','%s','%s',' %s','%s'"
EXEC _RegisterAutomatedPunishment '%s',%d,'%s','%s','%s',%d"
exec _QueryCharOwnedUser '%s'"
exec _QueryUserByUserID '%s'"
exec _AddArticleData %d,'%s','%s'"
exec _DeleteArticleData %d"
exec _UpdateArticleData %d,'%s','%s'"
exec _GetConcurrentUserLog %d, %d, '
exec _CertifyUser '%s','%s','%s'"
exec _CertifyUser_For_SMC '%s','%s','%s'"
exec _AddUser '%s','%s','%s','%s','%s','%s','%s',%d,%d,'%s'"
exec _DeleteUser %d"
exec _EditUser %d,'%s','%s','%s','%s','%s','%s',%d,%d,'%s'"
exec _CAS_GetItemList"
exec _CAS_ChangeCategory %d, %d"
exec _CAS_ChangeStatus %d, %d, '%s', '%s'"
exec _CAS_CompleteItem %d, '%s', '%s', '%s'"
exec _CAS_AddItem %d, %d, %d, '%s', '%s', '%s', '%s', '%s'"
exec _CAS_GetAnswerList '%s'"
exec _CAS_MarkItemDeleted %d"
exec _CAS_GMCallLog %d, '%s', %d, '%s', '%s'"
exec _CAS_Search '%s', '%s', '%s', '%s', '%s', '%s'"
exec _CAS_Statistics %d, '%s', '%s'"
exec _CAS_Search_GMCall %d, %d, '%s', '%s', '%s'"
exec _IPStatistics '%s', '%s'"

btw don't report me again that's not nice

[lucianoaibar]

Originally Posted by kevin_owner

@lucianoaibar or someone else who know it. What does that SR_gameserver.dll do does it only make a connection with the database? when i deleted it the gameserver doesn't connect to the database but when i add these 2 lines in the server.cfg

download the latest server files from here:


you only need ONE configuration now for all ODBC DSN strings
edit: C:\srserver\bin\sqllog.ini
(read: Installing.txt)
the other DSN texts will be ignored