Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Called when the server initializes.
- function GM:Initialize()
- ErrorNoHalt"----------------------\n"
- ErrorNoHalt(os.date().." - Server starting up\n")
- ErrorNoHalt"----------------------\n"
- local host = self.Config["MySQL Host"]
- local username = self.Config["MySQL Username"]
- local password = self.Config["MySQL Password"]
- local database = self.Config["MySQL Database"]
- -- Initialize a connection to the MySQL database.
- self.DB, err = mysqloo.connect(self.Config["MySQL Host"], self.Config["MySQL Username"], self.Config["MySQL Password"], self.Config["MySQL Database"], 3306)
- if (!self.DB) then
- error("You didn't setup the SQL correctly!")
- end
- self.DB.OnError = function(self, err)
- print("DB Connection error: "..err)
- end
- self.DB.OnConnectionFailed = function(self, err)
- error("You didn't setup the SQL Correctly!\n Here's what I got: \n "..err)
- end
- self.DB.OnConnected = function()
- print("Successfully connected to database!")
- timer.Create("mysqloo.checkConnection", 30, 0, function()
- local q = self.DB:query("SELECT 1+1")
- q:start();
- local status = self.DB:status()
- if (status == mysqloo.DATABASE_NOT_CONNECTED) then
- self.DB:connect()
- timer.Destroy("mysqloo.checkConnection")
- end
- end)
- end
- self.DB:connect()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement