require('mysqloo')
require('hio')

local DATABASE_HOST = "localhost"
local DATABASE_PORT = 3306
local DATABASE_NAME = "database"
local DATABASE_USERNAME = "root"
local DATABASE_PASSWORD = "root"
local DATABASE_SOCKET =	"/var/run/mysqld/mysqld.sock" -- window's doesn't use this.

local DBOBJ

DBOBJ = mysqloo.connect(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME, DATABASE_PORT)

DBOBJ.onConnected = function(db)
	print(db, "connected!")

	local getAllPlayers = db:query([[SELECT * FROM `sgcclan_vbforums`.`serverplayed` WHERE last_seen < "2010-11-01 00:00:01" LIMIT 1,50000]])
	getAllPlayers.onData = function(Q, D)
		local steamid = D["steamid"]

		hIO.RemoveDirectory("C:\\srcds\\garrysmod\\data\\advdupe\\"..steamid.."\\)

		print(steamid, "saves have been removed!")
	end
	getAllPlayers.onError = function(Q, E) print(E) end
	getAllPlayers:start()
end

DBOBJ.onConnectionFailed = function(db, err)
	print(db, "connection failed", err)
end

DBOBJ:connect()