Replay System

[wetlettuce]

I'd like to help with a new replay system.

Can I have the current DB structure please.

[Lu_Xun_17]

You should contact Raging Squirrel, he had aleady started to work on redesigned replay vault, but he never found time to finish it.

[wetlettuce]

I have. I've also contacted Zep. Just awaiting structure so I can make a start.

[Ze_PilOt]

The structure is as easy as it can be:

`id` bigint(20) unsigned NOT NULL DEFAULT '0',
`gameName` tinytext,
`filename` varchar(200) DEFAULT NULL,
`startTime` timestamp NULL DEFAULT NULL,
`EndTime` timestamp NULL DEFAULT NULL,
`gamemod` varchar(50) DEFAULT NULL,
`playerId` mediumint(8) unsigned NOT NULL,
`mapId` mediumint(8) unsigned DEFAULT NULL COMMENT 'map id',
`rating` double NOT NULL DEFAULT '0',
`gamemodid` tinyint(3) unsigned DEFAULT NULL,

I will only explain the no self-explanatory fields:

id is the uid of the game.
filename is the directory where the map is.
rating is the rating of the player before the game.
gamemodid is the uid of the featured mod (while gamemod is the featured mod name in full letter).

There is of course another table that link the uid of a game to the replay (a blob field).

[RoLa]

Is there any chance to get the replay tables as tar gz dump? I wanna try to make a replay cluster system so that we can search in older replays faster.

[RoLa]

I would like to help with replay system. Is there any chance to get

- the structure of all tables
- the dump of the whole database except login table ( i would generate a randomly filled one)

you posted some information:
viewtopic.php?f=42&t=6799&start=20

It would be easier with all the data, to experiment with. I know it's a really huge dump, but i could put it online on my server so other developers could download it from there. Maybe a tar.gz file of all replays would also be enough. Most Information should be in there.

[Ze_PilOt]

Dumping the DB is several GB of data and would freeze the server for a day, so I will say no on that.

For prototyping a better system, the best alternative for the moment is to use the current structure and fill it with 3-4 millions of random data similar to the real ones.

[nine2]

Is the rest of the replay data (eg: teams) inside the replay file in the header in json? Ta

[Ze_PilOt]

Is the rest of the replay data (eg: teams) inside the replay file in the header in json? Ta

Yes.

On Top of these metadata, the server save the player position, color, faction, and rating before / after the game.

[nine2]

So can you post the rest of the db schema please?