Initial commitHEADmaster

1 files changed, 38 insertions, 0 deletions

diff --git a/gamemode/sv_various/mysql.lua b/gamemode/sv_various/mysql.lua
new file mode 100644
index 0000000..4e51e6c
--- /dev/null
+++ b/gamemode/sv_various/mysql.lua
@@ -0,0 +1,38 @@
+pcall(require,"mysqloo")
+
+if (!mysqloo) then Msg("--- MySQL functions disabled. MySQLoo Module not found! ---\n") return end
+
+mysql = {}
+
+local Retries		= 0
+
+function mysql:Start(Host,User,Pass,Database)
+	local db = mysqloo.connect(Host,User,Pass,Database)
+	function db.onConnectionFailed(self,er) Msg( "Connection failed: "..er.."\n" ) end
+	function db.onConnected(self) Msg( "Connection has been established.\n" ) end
+	db:connect()
+	return db
+end
+	
+function mysql:Query(DAT,DB)
+	local db = DB or nil
+	if (!db) then Msg( "Database does not exist. Call mysql:Start()\n" ) return end
+	if (db:status() == mysqloo.DATABASE_NOT_CONNECTED) then 
+		if (Retries < 4) then
+			Msg( "Reconnecting...\n" ) 
+			db:connect() 
+			timer.Simple(5,function() self:Query(DAT,DB) end)
+			
+			 Retries = Retries+1
+		else Retries = 0 end
+		return
+	end
+
+	local DATABASE = db:query(DAT)
+	if (DATABASE) then
+		DATABASE:start()
+		function DATABASE.onError(s,er) Msg( er.."\n" ) end
+		function DATABASE.onFailure(s,er) Msg( er.."\n" ) end
+	end
+	return DATABASE
+end