initial commit with unreleased version 1.0.4

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;");
+        }
+
+    }
+}