[PROGRESS] of fixing the Server files!

[Windrius]

Now I'm gonna tell some facts.
You need all the machine managers IF YOU RUN EVERY SINGLE SERVER ON DIFFRENT MACHINE (just like joymax).
These files are clearly from GNGWC because where else would we find all the servers at 1 place? So we are capable of running the server with only 1 machine manager :P Hurreh!

[gercreed]

Can anyone pls update his edited port.ini and ips.ini since when I edit mine, the Globalmanager can't connect to the database anymore, although I did not make any changes in the sql.ini !

[kevin_owner]

This is my link.ini port.ini and ips.ini i only removed those download and machine managers in the port.ini (i think)
please backup your own edited files before you put this one in it.
i don't know if this is the right one but it looks like it is.



and change the shard, agent and gameserver port to 30005 in the server.cfg

this would only fix the cannot establish session thing
and the downloadserver which couldn't get a server cord.

edit:
is this a joke of joymax's programmers or is it just a fail?

kek!!! why did you assign shard to common manager server? -_-+ plz check out server license table !!!

[gercreed]

Can we already download stuff from the downloadserver ?
And I think I've got the right column names for the _REFLEVEL table. I have to test some stuff now and if I'm right, ill post it^^

//edit:

@kevin_owner with your config files, i get an "execute query error : exec _AddCurrentUserCount 64, 0, '2010-5-8 12:23:1' " in the global manager after ~2-3 minutes. The error after it: SQL Error State:42000, Native Error Code: 1FD2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure _AddCurrentUserCount has no parameters and arguments were supplied.

I think its a problem with the procedure itself! I will try to fix it...

[kevin_owner]

Yeah that procedure doesn't have a query so it gives an error:P

EDIT:

How can i open those .dat files of the certifications properly. wordpad shows me some data but it has a lot of wrong icons.

[gercreed]

Does anybody fixed the problems with the _REF-Tables ?? If not, can't we cath the errors? Perhaps the error looks like "Column xyz not found". Then we could have all real column names !

@kevin_owner
I tested it witht he Normal windows Editor and with Notepad++, but in all cases there were many wrong icons, I think its because some data is writtin in another language like Chinese or Japan so that we cant read it!

[kevin_owner]

Originally Posted by gercreed

Does anybody fixed the problems with the _REF-Tables ?? If not, can't we cath the errors? Perhaps the error looks like "Column xyz not found". Then we could have all real column names !

@kevin_owner
I tested it witht he Normal windows Editor and with Notepad++, but in all cases there were many wrong icons, I think its because some data is writtin in another language like Chinese or Japan so that we cant read it!

Thanks i already tought that those things are in korean or something like that. lucianoaibar made a sqllog so you can see which query's go to the sql server but those _REF tables are SELECT * FROM _REF... so you don't know which columns it wants.

btw i've been messing with the data of cert and do we need all these servers/managers too?



I've seen those names in the sname.dat(in the spoiler)But is this just what the cert can handle or some things we need.

This is the list of the sname.dat

 Spoiler

Certification
GlobalManager
DownloadServer
GatewayServer
FarmManager
AgentServer
SR_ShardManager
SR_GameServer
SR_Client
ServiceManager
MachineManager
JmxMsgSvr
JmxMessenger
SMC
CPRJ_Client
CPRJ_GameServer
CPRJ_ShardManager
Silkroad_Dev
Silkroad_Korea_Yahoo_Official
Silkroad_Korea_Yahoo_Test_IN
SRO_China_Official
SRO_China_TestLocal
Silkroad_Joymax
JoymaxMessenger
ServiceManager
SRO_China_TestIn
SRO_Taiwan_TestIn
SRO_Taiwan_TestLocal
SRO_Taiwan_Official
SRO_DEEPDARK
SRO_Taiwan_BillingTest
SRO_Japan_Official
SRO_Japan_TestLocal
SRO_Japan_TestIn
SRO_Global_TestBed
SRO_Global_TestBed_In
SRO_EuropeTest
SRO_Vietnam_TestIn
SRO_Vietnam_TestLocal
SRO_Net2E_Official
Yahoo_Official_Test
SRO_GNGWC_TestIn
SRO_GNGWC_Official
SRO_China_OpenTest
SRO_GNGWC_Official_Final
CPRJ_Dev
SRO_INTERNAL_EU
SRO_INTERNAL_EU_QUEST
!Vietnam_Dev
"SRO_China_EuroTest
#SRO_Taiwan_FOS CB
$SRO_GameOn_Official_Test

[gercreed]

Guys have you ever looked in the strings of e.g. the ShardManager or the GameServer ?!!
Someone needs to get the full database ^^ ( Perhaps here is an uber hacker who knows how to get into the database Server and uses a sql injection to dump their complete database and download it^^)

There are many queries which we dont have and already the _GameWorldInitialize procedure might have so much code that we need very good sql coders and much time !

[Yo123]

btw just to mention, those are not the ecsro etc files.
those already include euros and 100 cap ^-^

[-Burton-]

too bad alot of files missing and you don't know what even missing and you trying to fix it lol. you just guessing.

[Yo123]

thats how most things were invented;D
or made to work=D

[-Burton-]

the database you have found is only 5MB lol, I suppose the real one is much more than you think.
the main thing is the DATABASE, if you don't have it so....nothing will out i guess.

[Yo123]

i think we have smart people in here who'll make it.

even noex is working on it

[bogmaerke]

Figuring out the database is "just" sitting down, write up everything you can come up with that the server has to save. Then keep track of what kind of information each thing contains. Perhaps you guys should attempt to get someone with real skills to help out, someone who doesn't necessarily play SRO, but wants to take on a challenge

[kevin_owner]

Where are all the certification files cuz i think i forgot one cuz my globalmanagers keeps freezing(not a crash cuz it can cert all the other servers) when i have less than 54 servers in the port.ini or less than 47 in ips.ini.
port.ini
ips.ini
link.ini
sql.ini
those are all the cert files or is there something more?