require("mysql")

local DATABASE_HOST = "173.192.220.106"
local DATABASE_PORT = 3308
local DATABASE_NAME = "unleashe_bans"
local DATABASE_USERNAME = "unleashe_hemi"
local DATABASE_PASSWORD = "joseph11"
local pInfo = glon.decode(file.Read("ev_playerinfo.txt"))


print("Connect test!")
local db, error = mysql.connect(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME)
if (db == 0) then print(tostring(error) .. "\n") return end
print("connection opened - " .. db .. "!\n");
for k,v in pairs(pInfo) do
    test, isok, error = mysql.query(db, "INSERT INTO player_info (UniqueID,Nick, LastJoin, IPAddress, SteamID, BanAdmin, PlayTime, BanEnd, BanReason, Rank) VALUES('"..k.."','"..pInfo[k]["Nick"].."','"..pInfo[k]["LastJoin"].."','"..pInfo[k]["IPAddress"].."','"..pInfo[k]["SteamID"].."','"..pInfo[k]["BanAdmin"].."','"..pInfo[k]["PlayTime"].."','"..pInfo[k]["BanEnd"].."','"..pInfo[k]["BanReason"].."','"..pInfo[k]["Rank"].."')");
end
if (test) then
    PrintTable(test)
end
if (!isok) then
    print(tostring(error) .. "\n");
end