blob: 01034b53425fe6b3584ffe2563a3e42d6ea5ef5a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
using System;
using System.Collections.Generic;
using System.Text;
using MySql.Data.MySqlClient;
namespace Aktywator
{
class TeamyTournament : MySQLTournament
{
public TeamyTournament(string name, int type = Tournament.TYPE_TEAMY)
: base(name, type)
{
this._type = Tournament.TYPE_TEAMY;
}
override internal string getTypeLabel()
{
return "Teamy";
}
override public string getSectionsNum()
{
return "1";
}
override public string getTablesNum()
{
return this.mysql.selectOne("SELECT teamcnt FROM admin;");
}
override internal Dictionary<int, List<string>> getNameList()
{
Dictionary<int, List<String>> teams = new Dictionary<int, List<string>>();
MySqlDataReader dbData = this.mysql.select(MainForm.teamNames.getQuery());
while (dbData.Read())
{
List<string> names = new List<string>();
names.Add(dbData.IsDBNull(1) ? " " : dbData.GetString(1));
names.Add(dbData.IsDBNull(2) ? " " : dbData.GetString(2));
teams.Add(dbData.GetInt32(0), names);
}
dbData.Close();
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<int> getCurrentSegment()
{
MySqlDataReader finished = this.mysql.select("SELECT rnd, segm FROM admin");
List<int> segment = new List<int>();
finished.Read();
segment.Add(finished.GetInt32(0));
segment.Add(finished.GetInt32(1));
segment[1]++;
if (segment[1] > this.getSegmentsNum()) {
segment[0]++;
segment[1] = 1;
if (segment[0] > this.getRoundsNum())
{
segment[0] = this.getRoundsNum();
segment[1] = this.getSegmentsNum();
}
}
if (segment[0] < 1)
{
segment[0] = 1;
}
if (segment[1] < 1)
{
segment[1] = 1;
}
finished.Close();
return segment;
}
internal String getPointsUnit()
{
MySqlDataReader points = this.mysql.select("SELECT imponly FROM admin");
points.Read();
int unit = points.GetInt32(0);
points.Close();
return (unit < 0) ? "IMP" : "VP";
}
}
}
|
