summaryrefslogtreecommitdiff
path: root/Aktywator/Tournament.cs
diff options
context:
space:
mode:
authorMichal Zimniewicz <mzimniew@man.poznan.pl>2015-01-28 10:49:16 +0100
committerMichal Zimniewicz <mzimniew@man.poznan.pl>2015-01-28 10:58:38 +0100
commit29d9771333f9f996208b0e3dbce95dd80cddf8e9 (patch)
tree7160accad1184eabc2dbfadf4175aeeb6abf82dc /Aktywator/Tournament.cs
parenta331533373a95820a89aa93fead351ceb9a30046 (diff)
initial commit with unreleased version 1.0.4
Diffstat (limited to 'Aktywator/Tournament.cs')
-rw-r--r--Aktywator/Tournament.cs82
1 files changed, 82 insertions, 0 deletions
diff --git a/Aktywator/Tournament.cs b/Aktywator/Tournament.cs
new file mode 100644
index 0000000..b46740b
--- /dev/null
+++ b/Aktywator/Tournament.cs
@@ -0,0 +1,82 @@
+using System;
+using System.Collections.Generic;
+using System.Text;
+using MySql.Data.MySqlClient;
+using data = MySql.Data.MySqlClient.MySqlDataReader;
+
+namespace Aktywator
+{
+ public class Tournament
+ {
+ private string _name;
+ public string name
+ {
+ get { return _name; }
+ }
+
+ private int _type; // 0-unknown, 1-Pary, 2-Teamy
+ public int type
+ {
+ get { return _type; }
+ }
+
+ public MySQL mysql;
+
+ public Tournament(string name)
+ {
+ this._name = name;
+ mysql = new MySQL(name);
+ recognizeType();
+ }
+
+ private void recognizeType()
+ {
+ if ((mysql.selectOne("SHOW TABLES LIKE 'admin'") == "admin")
+ && (mysql.selectOne("SHOW FIELDS IN admin LIKE 'dnazwa'") == "dnazwa")
+ && (mysql.selectOne("SHOW TABLES LIKE 'zawodnicy'") == "zawodnicy"))
+ _type = 1;
+ else if ((mysql.selectOne("SHOW TABLES LIKE 'admin'") == "admin")
+ && (mysql.selectOne("SHOW FIELDS IN admin LIKE 'teamcnt'") == "teamcnt")
+ && (mysql.selectOne("SHOW TABLES LIKE 'players'") == "players"))
+ _type = 2;
+ else _type = 0;
+ }
+
+ public override string ToString()
+ {
+ return this.name + " [" + (this.type == 1 ? 'P' : 'T') + "]";
+ }
+
+ public static List<Tournament> getTournaments()
+ {
+ List<Tournament> list = new List<Tournament>();
+ MySQL c = new MySQL("");
+ data dbs = c.select("SHOW DATABASES;");
+ while (dbs.Read())
+ {
+ Tournament t = new Tournament(dbs.GetString(0));
+ if (t.type > 0)
+ list.Add(t);
+ t.mysql.close();
+ }
+ return list;
+ }
+
+ public string getSectionsNum()
+ {
+ if (type == 1)
+ return mysql.selectOne("SELECT COUNT(DISTINCT seknum) FROM sektory;");
+ else
+ return "1";
+ }
+
+ public string getTablesNum()
+ {
+ if (type == 1)
+ return mysql.selectOne("SELECT COUNT(*) FROM sektory;");
+ else
+ return mysql.selectOne("SELECT teamcnt FROM admin;");
+ }
+
+ }
+}