From 2c40aed6e5dd3913d10c656c47932938632f26c4 Mon Sep 17 00:00:00 2001 From: emkael Date: Tue, 19 Sep 2017 19:27:17 +0200 Subject: Fetching current and overall round/segment info for Teamy tournaments --- Aktywator/TeamyTournament.cs | 39 +++++++++++++++++++++++++++++++++++++++ 1 file changed, 39 insertions(+) diff --git a/Aktywator/TeamyTournament.cs b/Aktywator/TeamyTournament.cs index 78ce0e0..bd6b619 100644 --- a/Aktywator/TeamyTournament.cs +++ b/Aktywator/TeamyTournament.cs @@ -43,5 +43,44 @@ namespace Aktywator return teams; } + private int rounds = 0; + internal int getRoundsNum() + { + if (this.rounds == 0) + { + this.rounds = Int32.Parse(this.mysql.selectOne("SELECT roundcnt FROM admin")); + } + return this.rounds; + } + + private int segments = 0; + internal int getSegmentsNum() + { + if (this.segments == 0) + { + this.segments = Int32.Parse(this.mysql.selectOne("SELECT segmentsperround FROM admin")); + } + return this.segments; + } + + internal List getCurrentSegment() + { + MySqlDataReader finished = this.mysql.select("SELECT rnd, segm FROM admin"); + List segment = new List(); + finished.Read(); + segment.Add(finished.GetInt32(0)); + segment.Add(finished.GetInt32(1)); + segment[1]++; + if (segment[1] > this.getSegmentsNum()) { + segment[0]++; + if (segment[0] > this.getRoundsNum()) + { + segment[0] = this.getRoundsNum(); + segment[1] = this.getSegmentsNum(); + } + } + finished.Close(); + return segment; + } } } -- cgit v1.2.3