Best-Killer

addEventHandler("onResourceStart", resourceRoot, function () exports.NGsql:db_exec("DELETE FROM `bans` WHERE (`duration` + `startdate`) - UNIX_TIMESTAMP() <= 0") cacheBans() setTimer(deleteOldBans, 15000, 0) -- Every 15 seconds end ) check this too pffff i tried -1 and same problem

Forever ban = the duration need to be 0 as i think function cacheBans() local query = exports.NGsql:db_query("SELECT * FROM `bans`") for _, ent in ipairs(query) do table.insert(bans, {ent.srl, getIDAccount(ent.banner), ent.reason, ent.startdate, ent.duration, getIDName(ent.banner), getIDLastIp(ent.banned), getIDName(ent.banned)}) end end function deleteOldBans() local deletion = {} for i, ent in pairs(bans) do if (ent[5] ~= -1 and (ent[4] + ent[5]) - getRealTime().timestamp <= 0) then table.insert(deletion, ent[1]) table.remove(bans, i) end end if (#deletion >= 1) then for _, val in ipairs(deletion) do exports.NGsql:db_exec("DELETE FROM `bans` WHERE `srl` = ?", val) -- Must add some form of server log here end end end with my code if the duration 0 it's will be delete pff what is the problem guys or give me other example pls

addEventHandler ( "onClientGUIClick", root, function ( ) --Player Freeze if ( source == playfreeze ) then if (guiGetText (source) == 'Freeze Players') then triggerServerEvent("eventFeezePlayers",localPlayer) else triggerServerEvent("eventUnfreezePlayers",localPlayer) end --Return Player elseif ( source == playret ) then triggerServerEvent("returnPlayers",localPlayer) --Warp To Me elseif ( source == playwarp ) then triggerServerEvent("eventwarpplayers",localPlayer) --Vehicle Fix elseif ( source == vehfix ) then triggerServerEvent("eventFixVehicles",localPlayer) --Vehicle Destroy elseif ( source == vehdest ) then triggerServerEvent("destroyVehicles",localPlayer) --Vehicle Lock elseif ( source == vehlock ) then if (guiGetText (source) == 'Lock') then triggerServerEvent("eventLockVehicles",localPlayer) else triggerServerEvent("eventUnlockVehicles",localPlayer) end --Vehicle Collusion elseif ( source == vehcoll ) then if (guiGetText (source) == 'Disable Collusion') then triggerServerEvent("eventEnableCollision",localPlayer) else triggerServerEvent("eventDisableCollision",localPlayer) end --Vehicle Disable Dammage elseif ( source == vehdamm ) then if (guiGetText (source) == 'Disable Dammage') then triggerServerEvent("eventEnableDamageProof",localPlayer) else triggerServerEvent("eventDisableDamageProof",localPlayer) end --Vehicle Freeze elseif ( source == vehfreeze ) then if (guiGetText (source) == 'Freeze') then triggerServerEvent("eventFreezeVehicle",localPlayer) else triggerServerEvent("eventUnfreezeVehicles",localPlayer) end --Pickup Destroy elseif ( source == pickdest ) then triggerServerEvent("destroyPickups",localPlayer) --Create Armor elseif ( source == pickarmor ) then triggerServerEvent("createArmourPickup",localPlayer) --Create Health elseif ( source == pickhealth ) then triggerServerEvent("createHealth",localPlayer) --Give Jetpack elseif ( source == playjet ) then triggerServerEvent("eventGiveJetpack",localPlayer) end end) this will work

this will help you : OnClientKey

function globalMessage(thePlayer, cmd, ...) if isPlayerMuted ( thePlayer ) then outputChatBox("You're muted",thePlayer,255,255,255) else local message = table.concat ( { ... }, " " ) local name = getPlayerName(thePlayer) outputChatBox("#a22222[Globa]|#F0E68C"..name..": #ffffff"..message, getRootElement(), 255, 255, 255, true) end end addCommandHandler("global", globalMessage)

it's open-source

post the client side ( drawDXBanScreen ) and check the server side that i gived you !!! cuz i edited it

i'm not sure but try this function checkPIFBanned() if isPlayerBanned(getPlayerIP(source)) then local ban = exports.USCsql:queryData("SELECT `admin`,`player`,`reason`,`duration` FROM `bans` WHERE `IP`=?", getPlayerSerial(source)) for i, v in ipairs(ban) do triggerClientEvent(source, "drawDXBanScreen", source, {v["admin"], v["player"], v["reason"], v["duration"]}) end end end addEventHandler("onPlayerJoin", root, checkPIFBanned)

ok thx i'll try

ah i got you thx i got it fixed i'm using getRealTime().timestamp to add vip how to make function to check if that player vip finished ?? what i have to use ??

i'm trying to get user name account from his ID account

any help pls ?? comon ??

about 1.00*sy you're right but your code not work and my not work too wtf any pro dxdraw text help or any others help pls #koragg thx for your try bro

function test (player,cmd) acc = getAccountName(getPlayerAccount(player)) if isPlayerVIP(acc) then outputChatBox("Vip level"..tostring(isPlayerVIP(getAccountName(getPlayerAccount(player))))) else outputChatBox("error") end end addCommandHandler("aa",test) function isPlayerVIP(accountName) local check = exports.NGsql:db_query ( "SELECT * FROM vips_data WHERE acc=? ", getIDAccount(accountName)) if ( type( check ) == "table" and #check == 0 ) or not check then return false else return check[1]["level"] end end function getIDAccount(player) plid = false pqr = exports.NGsql:db_query ( "SELECT * FROM accountdata WHERE id=? LIMIT 1", tonumber(player)) for k, plas in ipairs (pqr) do plid = plas["Username"] end if not plid then return false end return plid end i'm geting in chat error i'm sure the accountid is in database and vip level .... ect no errors what's worng guys

thx bro

i suck in math i understand this for 1*60 minute , 1*3600 hour , 1*86400 day and what about months ?? what is it !!! sorry for bad explain :v

works thx bro

any help pls ?

i'm making bans system with sql , i want check if the serial is banned from database how to do it function isSerialBanned(s) serial = exports.NGSQL:db_exec("SELECT * FROM bans WHERE srl=?", s) return end f

guys i tried with 2 ways : 1- local sWidth,sHeight = guiGetScreenSize() dxDrawText("accept",(505/1280)*sWidth, (519/768)*sHeight, (76/1280)*sWidth, (37/768)*sHeight, coloracc, (1280/sWidth)*1.00, newFont,"left","top",false,false,false) 2- screenWidth, screenHeight = guiGetScreenSize() scaleX = screenWidth/1280 scaleY = screenHeight/768 dxDrawText( "Accept" ,505*scaleX, 519*scaleY, 76*scaleX, 37*scaleY, coloracc, scaleX*1.00, newFont,"left","top",false,false,false) and same problem dude :v any help ? Note : 0 errors

Thx s3d <3

it's exports nvm bro it's fixed ^^

function getPlayerID(player) plid = false pqr = db_query ( "SELECT * FROM accountdata WHERE Username=? LIMIT 1", getAccountName(getPlayerAccount(player))) pqp = dbPoll(pqr, -1) for k, plas in ipairs (pqp) do plid = plas["id"] end if plid then return plid else return "Not logged in" end end bad argument dpPoll expected dbquery at argument 1 got table

turftimes = setTimer ( sendTurfPayout, (60*tonumber(get("*PAYOUT_TIME")))*1000, 0 ) turftim = getTimerDetails(turftimes) outputChatBox ( ""..turftim.."",p,255,0,0,true) the timer is 1hour (3600) and i'm geting it in chatbox 3600000 i want get it like 60 minute , 59 Minute , how i can do it ?

and about timer use : GetTimerDetails better