forked from OMARATION/mcforge
-
Notifications
You must be signed in to change notification settings - Fork 0
/
MySQL.cs
117 lines (109 loc) · 3.22 KB
/
MySQL.cs
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
105
106
107
108
109
110
111
112
113
114
115
116
/*
Copyright 2010 MCSharp team (Modified for use with MCZall/MCLawl/MCForge)
Dual-licensed under the Educational Community License, Version 2.0 and
the GNU General Public License, Version 3 (the "Licenses"); you may
not use this file except in compliance with the Licenses. You may
obtain a copy of the Licenses at
http://www.osedu.org/licenses/ECL-2.0
http://www.gnu.org/licenses/gpl-3.0.html
Unless required by applicable law or agreed to in writing,
software distributed under the Licenses are distributed on an "AS IS"
BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
or implied. See the Licenses for the specific language governing
permissions and limitations under the Licenses.
*/
using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using MySql.Data.MySqlClient;
using MySql.Data.Types;
//using System.Data.SQLite;
namespace MCForge
{
public static class MySQL
{
public static string connString = "Data Source=" + Server.MySQLHost + ";Port=" + Server.MySQLPort + ";User ID=" + Server.MySQLUsername + ";Password=" + Server.MySQLPassword + ";Pooling=" + Server.MySQLPooling;
public static void executeQuery(string queryString, bool createDB = false)
{
int totalCount = 0;
if (!Server.useMySQL)
return;
retry: try
{
using (var conn = new MySqlConnection(connString))
{
conn.Open();
if (!createDB)
{
conn.ChangeDatabase(Server.MySQLDatabaseName);
}
using (MySqlCommand cmd = new MySqlCommand(queryString, conn))
{
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception e)
{
if (!createDB)
{
totalCount++;
if (totalCount > 10)
{
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n");
Server.ErrorLog(e);
}
else
{
goto retry;
}
}
else
{
throw e;
}
}
}
public static DataTable fillData(string queryString, bool skipError = false)
{
int totalCount = 0;
using (DataTable toReturn = new DataTable("toReturn"))
{
if (!Server.useMySQL)
return toReturn;
retry: try
{
using (var conn = new MySqlConnection(connString))
{
conn.Open();
conn.ChangeDatabase(Server.MySQLDatabaseName);
using (MySqlDataAdapter da = new MySqlDataAdapter(queryString, conn))
{
da.Fill(toReturn);
}
conn.Close();
}
}
catch (Exception e)
{
totalCount++;
if (totalCount > 10)
{
if (!skipError)
{
File.AppendAllText("MySQL_error.log", DateTime.Now + " " + queryString + "\r\n");
Server.ErrorLog(e);
}
}
else
goto retry;
}
return toReturn;
}
}
}
}