RankingServer: ...stored procedures?

[Twilight]

subj...

hi all..

0041A548: '  SetAutoUpdate : %s ',0
0041A560: 'SetAutoUpdate',0
0041A570: '  Update Hour: %d',0
0041A588: 'SetUpdateHour',0
0041A598: 'BuildRank',0
0041A5A4: 'ShowInfo',0
0041A5B0: 'ShowINI',0
0041A5B8: 'ShowUserCount',0
0041A5C8: 'help',0
0041A5D0: 'resume',0
0041A5D8: 'pause',0
0041A5E0: 'quit',0
.
.
.
.

0041AB68: 'ServerName',0
0041AB80: 'No Character Exists...: %s',0Ah,0
0041AB9C: 'exec dbo.ProcGetCharacterInfo_One_Rank %d ',0
0041ABC8: 'No User Exists...: %s',0Ah,0
0041ABE0: 'exec dbo.ProcGetRank_Personal %d, ',27h,'%s',27h,0
0041AC08: 'QueryUserInfoFromDB...: %s',0Ah,0
0041AC24: 'DB Error...: %s',0Ah,0
0041AC38: 'No Data...: %s',0Ah,0
0041AC48: 'QueryMyRankFromDB...: %s',0Ah,0
0041AC68: 'QueryRankListFromDB(%d) %s',0Ah,0
0041AC84: 'QueryRankListFromDB %s ',0Ah,0
0041ACA0: '-------- exit from SubTheadProc()',0Ah,0
0041ACC4: 'User closed by heartbit check: %s',0Ah,0
0041ACE8: 'Invalid packet header (sPacket_Size: %d) in OnMsg()',0Ah,0
0041AD20: 'Buffer full in OnMsg(): index: %d, IP address: %s',0Ah,0
0041AD58: 'Exec dbo.ProcGetRank_Record_My %d, ',27h,'%s',27h,', %d',0
0041AD84: 'Exec dbo.ProcGetRank_Map_My %d, ',27h,'%s',27h,', %d',0
0041ADB0: 'Exec dbo.ProcGetRank_My %d, ',27h,'%s',27h,', %d',0
0041ADD8: 'Exec dbo.ProcGetRank_Record %d, %d',0
0041ADFC: 'Exec dbo.ProcGetRank_Map %d, %d',0
0041AE1C: 'Exec dbo.ProcGetRank %d, %d',0

[MentaL]

[bubbastic]

Welcome back and good luck with that

[Tsukasa]

This is just basic output from the resources of the RankingServer, so it's safe to say Twilight just posted them for reference for interested parties.

Granted - this is my personal opinion but as in S1, the Ranking Server is pretty much a useless beast for most people. If someone is in dire need of statistics or ladders, it'd be easier to implement those without the dedicated server component (possibly into a scheduled query?). Another "limitation" seems to be that the index gets rebuild periodically only; I know that many people prefer live statistics over cached ones (as long as it's feasonable).

Good to know some people from the S1 days are still here/back and in full swing. :)

[chreadie]

This is just basic output from the resources of the RankingServer, so it's safe to say Twilight just posted them for reference for interested parties.

Granted - this is my personal opinion but as in S1, the Ranking Server is pretty much a useless beast for most people. If someone is in dire need of statistics or ladders, it'd be easier to implement those without the dedicated server component (possibly into a scheduled query?). Another "limitation" seems to be that the index gets rebuild periodically only; I know that many people prefer live statistics over cached ones (as long as it's feasonable).

Good to know some people from the S1 days are still here/back and in full swing. :)

Well with the ranking server you could move load of the main gameserver. Also you could present ranking data on a remote webserver for security reasons.

[Twilight]

Good to know some people from the S1 days are still here/back and in full swing. :)

=)


Yes. Perhaps you are right and statistics is unnecessary .... But who then is necessary and I posted information here ...
to work properly you need to create multiple tables and fix these procedures or to create a link ... .. pangya_s3_Rank

ps: Of course the port 1433 must be closed for safety on and off xp_сmdshell .....
=)