------------------------------------------------------------------------------------
--  COMMUNITY CONTRIBUTION FOR CIT2.NET
--  PURPOSE: Feedback for the updates
--  DEVELOPERS: Nikos , Zelda
------------------------------------------------------------------------------------

local dbname =
local host =
local username =
local password =
local con = dbConnect("mysql", "dbname="..dbname..";host="..host.."", ""..username.."", ""..password.."")
dbExec(con, "CREATE TABLE IF NOT EXISTS feedbacks (update_post TEXT, message TEXT)")

-- local con = dbConnect("sqlite", "//feedbacks.db")
-- dbExec(con, "CREATE TABLE IF NOT EXISTS feedbacks (update_post TEXT, message TEXT)")
-- dbExec(con, "DELETE FROM feedbacks")

local removeTable ={
	-- day
	"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday",

	-- days
	"1st", "2nd", "3rd", "4th", "5th", "6th", "7th", "8th", "9th", "10th", "11th",
	"12th", "13th", "14th", "15th", "16th", "17th", "18th", "19th", "20th", "21st",
	"22nd", "23rd", "24th", "25th", "26th", "27th", "28th", "29th", "30th", "31st",
}

local months = { -- fix age bug from string
	"January", "February", "March", "April", "May", "June", "July",
	"August", "September", "October", "November", "December",
}

local antibug = {
	"a","b","c","d","e","f","g","h","i","j","k","l","m",
	"n","o","p","k","r","s","t","u","v","w","x","y","z",
	"1","2","3","4","5","6","7","8","9","10",
}

local startAge, endAge = 2018, 2070 -- age filtrer

function process_updates(data)
	local cache = {}
	local updates = ""..data..""
	for k = startAge, endAge do
		for index, v in ipairs(months) do
			updates = string.gsub(updates, ""..v.." "..k.."", "")
		end
	end
	for index, v in ipairs(removeTable) do
		updates = string.gsub(updates, ""..v.." ", "")
	end
	local updates = string.gsub(updates, "\n", "")
	local updates = string.gsub(updates, "\r", "")
	for i, v in ipairs(antibug) do -- fix bug ( - ).
		updates = string.gsub(updates, "-"..v.."", "~"..v.."")
	end
	local ent = split(updates, "-") or {}
	for i, v in ipairs(ent) do
		table.insert(cache, ""..i..". "..v)
	end
	return cache
end

function getUpdatesList()
	if (isGuestAccount(getPlayerAccount(client))) then
		return
	end
	local conversion = process_updates(exports.CITupdatesInfo:getUpdates()) or {}
	if (#conversion == 0) then
		outputChatBox("The feedback list is not loaded yet, retry later.", client, 255, 0, 0)
	else
		triggerClientEvent(client, "CITfeedback.sendFeedbackList", client, conversion)
	end
end
addEvent("CITfeedback.getUpdatesList", true )
addEventHandler("CITfeedback.getUpdatesList", root, getUpdatesList)

function sendFeedback(message, update)
	if (isGuestAccount(getPlayerAccount(client))) then
		return
	end
	local name = getPlayerName(client)
	local accname = getAccountName(getPlayerAccount(client))
	local results = dbPoll(dbQuery(con, "SELECT * FROM feedbacks WHERE update_post=?", update) ,-1)
	if (#results == 0) then
		local cc = "- "..name.." ("..accname..")\n"..message..""
		dbExec(con,"INSERT INTO feedbacks VALUES (?, ?)", update, cc, accname)
		exports.CIThelp:dm("Feedback sended", client, 0, 255, 0)
	else
		if (string.find(results[1]["message"], "("..accname..")")) then
			exports.CIThelp:dm("You have already made a comment to this update.", client, 255, 0, 0)
			return
		end
		local cc = ""..results[1]["message"].."\n- "..name.." ("..accname..")\n"..message..""
		dbExec(con, "UPDATE feedbacks SET message=? WHERE update_post=?", cc, update)
		exports.CIThelp:dm("Feedback sended", client, 0, 255, 0)
	end
end
addEvent("CITfeedback.sendFeedback", true )
addEventHandler("CITfeedback.sendFeedback", root, sendFeedback)

function getGridData(update)
	local result = dbPoll( dbQuery(con, "SELECT * FROM feedbacks WHERE update_post=?", update) , -1)
	if (type(result) == "table" and #result ~= 0) then
		triggerClientEvent(client, "CITfeedback.sendGridData", client, result[1]["message"])
	else
		triggerClientEvent(client, "CITfeedback.sendGridData", client, "No comments yet.")
	end
end
addEvent("CITfeedback.getGridData", true )
addEventHandler("CITfeedback.getGridData", root, getGridData)