Official Battle Tanks Community
Advanced Database request (games over 3 hours) - Printable Version

+- Official Battle Tanks Community (https://btanks.net/forum)
+-- Forum: Competition & Tournaments (https://btanks.net/forum/forumdisplay.php?fid=38)
+--- Forum: League (https://btanks.net/forum/forumdisplay.php?fid=43)
+--- Thread: Advanced Database request (games over 3 hours) (/showthread.php?tid=4631)

Advanced Database request (games over 3 hours) - RAF_Fenix - 2015-03-22

Hello admins,

I would like to query your DB somehow, with your help, to get a link of games over 3 hours long.
Possibly, with replays.

Thanks,
-RAF Fenix

RE: Advanced Database request (games over 3 hours) - eSVau - 2015-03-22

(2015-03-22, 00:46:17)RAF_Fenix Wrote: Hello admins,

I would like to query your DB somehow, with your help, to get a link of games over 3 hours long.
Possibly, with replays.

Thanks,
-RAF Fenix

All of them:

RE: Advanced Database request (games over 3 hours) - RAF_Fenix - 2015-03-22

Thanks. 

So roughly 1 game per 4000 RANKED games is that long. (11 of 43221 games)
Glad to be a player of the longest game in history !

RE: Advanced Database request (games over 3 hours) - El_Polacco - 2015-03-29

What happened to game BTanks League RANKED #43258 in league database ?

RE: Advanced Database request (games over 3 hours) - eSVau - 2015-03-29

(2015-03-29, 12:13:34)El_Polacco Wrote: What happened to game BTanks League RANKED #43258 in league database ?

The Bot could not update game status for some reason so the game was marked as zombie game and therefore its result were not saved.

edit: culprit is daylight saving time - that missing hour fucked up checking if the game still is running and marked it a zombie

I maybe fixed this (BTanks League RANKED #43258), havent done that for quite some timeAngel

RE: Advanced Database request (games over 3 hours) - RaptorXI - 2015-04-05

Here is another:
http://league.btanks.net/game.php?gameid=43111