{"id":292,"date":"2008-01-12T18:33:39","date_gmt":"2008-01-12T22:33:39","guid":{"rendered":"http:\/\/www.rakkar.org\/blog\/?p=292"},"modified":"2008-01-12T18:33:39","modified_gmt":"2008-01-12T22:33:39","slug":"ranking-server-done","status":"publish","type":"post","link":"https:\/\/rakkar.org\/blog\/index.php\/2008\/01\/12\/ranking-server-done\/","title":{"rendered":"Ranking server done"},"content":{"rendered":"

\t\t\t\tI’ve finished writing a ranking server for RakNet<\/a>. It is a C++ interface to a PostgreSQL database that stores a table that contains a list of matches between two participants. It’s very general – participants, games, scores, ratings, are just numbers. You can store a text string and arbitrary binary data for each match. It uses my functor system so calls are asynchronous.<\/p>\n

There are currently 4 functors:
\nSubmitMatch – Submits the match results between a pair of participants.
\nGetRatingForParticipant – Get the most recent rating for a single participants.
\nGetRatingForParticipants – Get the most recent rating for a list of participants.
\nGetHistoryForParticipant – Get all the matches and the data therein for a particular participant.<\/p>\n

I store IDs as a pair of unsigned integers. The intent is that the primary integer can represent a foreign key. The secondary integer can represent a sub-type. In Galactic Melee for example I store rankings for both players and squads, so the secondary integer would differentiate between these.<\/p>\n

The class is designed in such a way as to be easily extensible while still easy to use. Generally speaking the more extensible something is, the harder it is to use because there are more pieces involved, so you have a lot more to learn. This is true of Gamebryo for example, which has good division of code but then requires a lot of steps to do anything. I wanted to avoid this, so went to a lot of extra work to make as much automatic as possible.<\/p>\n

One nice thing is you can add more queries without changing the original source code. This is because each query is just a derived class.<\/p>\n

The current table format is:<\/p>\n

CREATE TABLE rankingServer (
\n\t\trowId serial UNIQUE,
\n\t\tparticipantADbId_primaryKey integer NOT NULL,
\n\t\tparticipantADbId_secondaryKey integer NOT NULL,
\n\t\tparticipantBDbId_primaryKey integer NOT NULL,
\n\t\tparticipantBDbId_secondaryKey integer NOT NULL,
\n\t\tparticipantAScore real,
\n\t\tparticipantBScore integer,
\n\t\tparticipantAOldRating real,
\n\t\tparticipantANewRating real NOT NULL,
\n\t\tparticipantBOldRating real,
\n\t\tparticipantBNewRating real NOT NULL,
\n\t\tgameDbId_primaryKey integer NOT NULL,
\n\t\tgameDbId_secondaryKey integer NOT NULL,
\n\t\tmatchTime bigint NOT NULL DEFAULT EXTRACT(EPOCH FROM current_timestamp),
\n\t\tmatchNotes text,
\n\t\tmatchBinaryData bytea);<\/p>\n

Here’s an example of calling a Functor<\/p>\n


\nGetRatingForParticipants_PostgreSQLImpl *functor = GetRatingForParticipants_PostgreSQLImpl::Alloc();<\/p>\n

printf(\"Get the most recent rating for all participants\\n\");<\/p>\n

printf(\"Enter the primary ID of the game (int): \");
\ngets(inputStr);
\nfunctor->gameDbId.primaryKey = atoi(inputStr);<\/p>\n

printf(\"Enter the secondary ID of the game (int): \");
\ngets(inputStr);
\nfunctor->gameDbId.secondaryKey = atoi(inputStr);<\/p>\n

\/\/\/ Puts this functor on the processing queue. It will process sometime later in a thread.
\nrankingServer.PushFunctor(functor);
\n<\/code><\/p>\n

This is all part of my plan to write a complete lobby server, of which ranking and match tracking is one component.\t\t<\/p>\n","protected":false},"excerpt":{"rendered":"

I’ve finished writing a ranking server for RakNet. It is a C++ interface to a PostgreSQL database that stores a table that contains a list of matches between two participants. It’s very general – participants, games, scores, ratings, are just numbers. You can store a text string and arbitrary binary data for each match. It […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/rakkar.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/292"}],"collection":[{"href":"https:\/\/rakkar.org\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rakkar.org\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rakkar.org\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rakkar.org\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=292"}],"version-history":[{"count":0,"href":"https:\/\/rakkar.org\/blog\/index.php\/wp-json\/wp\/v2\/posts\/292\/revisions"}],"wp:attachment":[{"href":"https:\/\/rakkar.org\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rakkar.org\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rakkar.org\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}