118 connection = exports.sarp_database:getConnection() 163 dbQuery( function (qh, sourcePlayer) if isElement(sourcePlayer) then local result, rows = dbPoll(qh, 0)[1] local banState = {isActive = "N"} 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 )