addEvent("checkPlayerBanState", true)
addEventHandler("checkPlayerBanState", getRootElement(),
	function ()
		if isElement(source) then
			local serial = getPlayerSerial(source)

			dbQuery(
				function (qh, sourcePlayer)
					if isElement(sourcePlayer) then
						local result, rows = dbPoll(qh, 0)[1]
						local banState = {isActive = "N"}
						local dbConnect( "mysql", "dbname=sarpdb;host=127.0.0.1;charset=utf8", "root", "" )

						if result then
							if getRealTime().timestamp >= result.expireTimestamp then
								dbExec(connection, "UPDATE accounts SET suspended = 'N' WHERE serial = ?; UPDATE bans SET isActive = 'N' WHERE playerSerial = ? AND dbID = ?", serial, serial, v.dbID)
							else
								banState = result
							end
						end

						triggerClientEvent(sourcePlayer, "receiveBanState", sourcePlayer, banState)

						if getElementData(sourcePlayer, "loggedIn") then
							local characterId = getElementData(sourcePlayer, "char.ID") or 0



							if characterId > 0 then
								assignedCharacters[characterId] = sourcePlayer

								dbExec(connection, "UPDATE accounts SET online = 'Y' WHERE accountID = ?", getElementData(sourcePlayer, "acc.ID"))
							end
						end
					end
				end, {source}, connection, "SELECT * FROM bans WHERE playerSerial = ? AND isActive = 'Y' LIMIT 1", serial
			)
		end
	end
)