Official Battle Tanks Community › Competition & Tournaments › League v
Advanced Database request (games over 3 hours)

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Advanced Database request (games over 3 hours)
RAF_Fenix Offline
Member
***
Posts: 87
Threads: 36
Joined: Jan 2013
Reputation: 3
#1
2015-03-22, 00:46:17
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
Find
Reply
eSVau Offline
Arrrrr
*******
Posts: 1,297
Threads: 83
Joined: Mar 2007
Reputation: 16
#2
2015-03-22, 12:44:33
(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:
Marvin Wrote:The first ten million years were the worst and the second ten million years, they were the worst too. The third ten million years I didn't enjoy at all. After that I went into a bit of a decline
Find
Reply
RAF_Fenix Offline
Member
***
Posts: 87
Threads: 36
Joined: Jan 2013
Reputation: 3
#3
2015-03-22, 13:37:26 (This post was last modified: 2015-03-22, 13:54:27 by RAF_Fenix.)
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 !
Find
Reply
El_Polacco Offline
Senior Member
****
Posts: 304
Threads: 10
Joined: Apr 2011
Reputation: 2
#4
2015-03-29, 12:13:34
What happened to game BTanks League RANKED #43258 in league database ?
[Image: 2qltmpx.png]
Find
Reply
eSVau Offline
Arrrrr
*******
Posts: 1,297
Threads: 83
Joined: Mar 2007
Reputation: 16
#5
2015-03-29, 14:00:13 (This post was last modified: 2015-03-29, 14:27:43 by eSVau. Edit Reason: found culprit )
(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
Marvin Wrote:The first ten million years were the worst and the second ten million years, they were the worst too. The third ten million years I didn't enjoy at all. After that I went into a bit of a decline
Find
Reply
RaptorXI Offline
Senior Member
****
Posts: 542
Threads: 52
Joined: Jun 2008
Reputation: 8
#6
2015-04-05, 21:16:42
Here is another:
http://league.btanks.net/game.php?gameid=43111
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Qualifying games jojoy 9 8,560 2017-04-14, 21:26:54
Last Post: warrior_cobra
  Ban Request BENNIE.FM 51 42,484 2016-04-15, 00:58:06
Last Post: reyizz
  Unban Request GEN_Schwarzkopf 5 7,088 2015-10-30, 03:38:41
Last Post: RaptorXI
  Unban request GodStrongArms 5 4,966 2015-10-29, 00:29:46
Last Post: BENNIE.FM
  Unban Request - as in "One more favor Though please!" jojoy 1 3,162 2015-10-21, 23:59:25
Last Post: BENNIE.FM



Users browsing this thread: 1 Guest(s)