Dimos7

local connection = false function createTable() connection = dbConnect("sqlite", "database.db") if connection then dbExec(connection, "CREATE TABLE IF NOT EXISTS `accounts`('username', 'password', 'name', 'serial', 'kills', 'deaths', 'headshots', 'money', 'rank', 'exp', 'class', 'playtime', 'vip', 'adminlevel')") dbExec(connection, "CREATE TABLE IF NOT EXISTS `punishments`('warn', 'playername', 'by', 'reason', 'jail', 'playername', 'jailtime', 'by', 'reason', 'kick', 'playername', 'by', 'reason', 'ban', 'userplayername', 'serial', 'bantime', 'by', 'reason', 'mute', 'playername', 'mutetime', 'by', 'reason')") dbExec(connection, "INSERT INTO accounts (username, password, kills) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO accounts (name, serial) VALUES (NULL, NULL)") dbExec(connection, "INSERT INTO accounts (deaths, headshots, money) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO accounts (rank, exp, class) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO accounts (playtime, vip, adminlevel) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO punishments (warn, playername, by) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO punishments (reason, jail, jailtime) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO punishments (playername, by, reason) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO punishments (kick, playername, by) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO punishments (reason, ban, bantime) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO punishments (userplayername, serial, by) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO punishments (reason, mute, mutetime) VALUES (NULL, NULL, NULL)") dbExec(connection, "INSERT INTO punishments (playername, by, reason) VALUES (NULL, NULL, NULL)") end end addEventHandler("onResourceStart", resourceRoot, createTable) function getSQLConnection() return connection end Error line 7 dupilicate column name : playername

then need bind the mouse with the x

So want a dentai system for the player also want when player dentai the time no killed right?

if not want glue the use that addEventHandler("onPlayerLogin", root, function() unbindKey(source, "x", "down") end) addEventHandler("onResourceStart", resourceRoot, function() for _, v in ipairs(getElementsByType("player")) do unbindKey(v, "x", "down") end end)

you have addevent in the client side?

its in same folder the sound and script

try this addEventHandler("onClientPlayerWeaponFire", root, function(weapon, ammo, ammoInClip) local x, y, z = getElementPosition(localPlayer) if weapon == 30 then local sound = playSound3D("GENRL/sound_005.mp3", x, y, z) setSoundMaxDistance(sound, 75) end end) also in meta change it like that <meta> <script src="replace.lua" type="client"/> <file src="GENRL/sound_005.mp3"/> </meta>

local connection = false function createTable() connection = dbConnect("sqlite", "database.db") if connection then dbExec(connection, "CREATE TABLE IF NOT EXISTS `accounts`('username', 'password', 'name', 'serial', 'kills', 'deaths', 'headshots', 'money', 'rank', 'exp', 'class', 'playtime', 'vip', 'adminlevel')") dbExec(connection, "CREATE TABLE IF NOT EXISTS `punishments`('warn', 'playerSource', 'by', 'reason', 'jail', 'jailtime', 'playerSource', 'by', 'reason', 'kick', 'playerSource', 'by', 'reason', 'ban', 'bantime', 'username', 'serial', 'by', 'reason', 'mute', 'mutetime', 'playerSource', 'by', 'reason')") dbExec(connection, "INSERT INTO accounts (username, password, kills) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO accounts (name, serial) VALUES ('"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO accounts (deaths, headshots, money) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO accounts (rank, exp, class) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO accounts (playtime, vip, adminlevel) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO punishments (warn, playerSource, by) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO punishments (reason, jail, jailtime) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO punishments (playerSource, by, reason) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO punishments (kick, playerSource, by) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO punishments (reason, ban, bantime) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO punishments (username, serial, by) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO punishments (reason, mute, mutetime) VALUES ('"..nil.."','"..nil.."','"..nil.."')") dbExec(connection, "INSERT INTO punishments (playerSource, by, reason) VALUES ('"..nil.."','"..nil.."','"..nil.."')") end end addEventHandler("onResourceStart", replayerSourceRoot, createTable) function getSQLConnection() return connection end error line 8 attempt to concatenate a nil value

you mean by script or just recplace the default sounds?

function tvScreensound() setBrowserVolume(myBrowser, 0.0) local x, y, z = getElementPosition(localPlayer) local dist = getDistanceBetweenPoints3D(x, y , z, 0, 0, 3) -- in 0, 0 ,3 put the location of your object where is your screen tv on. if dist <= 100 then setBrowserVolume(myBrowser, 1.0) end end

function tvScreensound() local x, y, z = getElementPosition(localPlayer) local dist = getDistanceBetweenPoints3D(x,y ,z, 0, 0, 3) -- in 0, 0 ,3 put the location of your object where is your screen tv on. if dist <= 100 then setBrowserVolume(the browser, 1) end end

for the sound can you take the distance between your tv and player example function tvScreensound() local x, y, z = getElementPosition(localPlayer) local dist = getDistanceBetweenPoints3D(x,y ,z, 0, 0, 3) -- in 0, 0 ,3 put the location of your screen if dist <= 100 then setSoundVolume(file/soundname, 100) end end

Hello guys i make a anticheat system and i want ban player and addBan but in resposible element idk what to put any ideas?

ty also when i create a table is all null?

guy i want ask a question when i want insert the table two values for example username password need like this? local connection = exports.database:getSQLConnection() function registerHandler(thePlayer, username, password) local query = dbQuery(connection, "SELECT * FROM accounts WHERE username=? and password=?", username, password) local result, num_affected_rows = dbPoll(query, -1) local account = getAccount(username, password) if (account ~= false) and num_affected_rows == 1 then triggerClientEvent(thePlayer, "registerTaken", root) else account = addAccount(username, password) dbExec(connection, "INSERT INTO accounts VALUES(?, ?) (username, password)", username, password)

Kills = {} Deaths = {} Headshot = {} Money = {} Playtime = {} exports.scoreboard:scoreboardAddColumn("Kills", 20, root, "Kills", 3) exports.scoreboard:scoreboardAddColumn("Deaths", 20, root, "Deaths", 4) exports.scoreboard:scoreboardAddColumn("Headshot", 20, root, "Headshot", 5) exports.scoreboard:scoreboardAddColumn("Money", 20, root, "Money", 6) exports.scoreboard:scoreboardAddColumn("Playtime", 20, root, "Playtime", 9) addEventHandler("onPlayerLogin", root, function() for i = 0, Kills do if not Kills[i] then Kills[i] = source setElementData(source, "Kills", i) break; end end for i = 0 , Deaths do if not Deaths[i] then Deaths[i] = source setElementData(source, "Deaths", i) break; end end for i = 0 , Headshot do if not Headshot[i] then Headshot[i] = source setElementData(source, "Headshot", i) break; end end for i = 0, Money do if not Money[i] then Money[i] = source setElementData(source, "Money", i) break; end end for i = 0, Playtime do if not Playtime[i] then Playtime[i] = source local time = getRealTime() local hours = time.hour local minutes = time.minute getTickCount() setElementData(source, "Playtime", i) break; end end end) addEventHandler("onResourceStart", resourceRoot, function() for _, v in ipairs(getElementsByType("player")) do for i = 0, Kills do if not Kills[i] then Kills[i] = v setElementData(v, "Kills", i) break; end end for i = 0, Deaths do if not Deaths[i] then Deaths[i] = v setElementData(v, "Deaths", i) break; end end for i = 0, Headshot do if not Headshot[i] then Headshot[i] = v setElementData(v, "Headshot", i) break; end end for i = 0, Money do if not Money[i] then Money[i] = v setElementData(v, "Money", i) break; end end for i = 0 , Playtime do if not Playtime[i] then Playtime[i] = v local time = getRealTime() local hours = time.hour local minutes = time.minute getTickCount() setElementData(v, "Playtime", i) break; end end end end) function setPlayerStatus(attacker, weapon, bodypart) if attacker then if (getElementType(attacker) == "player") then killPed(source, attacker, weapon) setElementData(attacker, "Kills", Kills + 1) setElementData(source, "Deaths", Deaths + 1) end if bodypart == 9 then killPed(source, attacker, weapon, bodypart) setElementData(attacker, "Headshot", Headshot + 1) end end end addEventHandler("onPlayerWasted", root, setPlayerStatus) function getPlayerStatus(player) if isElement(player) and getElementType(player) == "player" and getElementData(player, "Kills") and getElementData(player, "Deaths") and getElementData(player, "Headshot") and getElementData(player, "Money") and getElementData(player, "Playtime") then return getElementData(player, "Kills"), getElementData(player, "Deaths"), getElementData(player, "Headshot"), getElementData(player, "Money"), getElementData(player, "Playtime") end end error line 60 must be number

anyone?

local connection = dbConnect("sqlite", "database.db", "127.0.0.1", "root", "921994") function createTable() if connection == true then dbExec(connection, "CREATE TABLE IF NOT EXISTS `accounts`('usernames', 'password', 'kills', 'deaths', 'headshots', 'money', 'rank', 'class', 'timeplay', 'vip', 'adminlevel')") end end addEventHandler("onResourceStart", resourceRoot, createTable) I want create that table not created and use it to another resource use it ty

How i can get in client side the time a player play like this? function playTime() local time = getRealTime() local hours = time.hour local minutes = time.minute end

ops sorry my bad ty

local connection =dbConnect("sqllitle", "dbsql/database.db") function passwordHandler(player, oldpassword, newpassword) local query = dbQuery(connection, "SELECT * FROM accoutns WHERE password=?", oldpassword) local result, num_affected_rows = dbPoll(query, -1) local account = getPlayerAccount(player) if (account) then if (isGuestAccount(account)) then outputChatBox("You must be logged in to change your password.", player) return end local playerName = getPlayerName(player) local password_check = getAccount(playerName, oldpassword) if (password_check ~= false) and num_affected_rows < 1 then if (string.len(newpassword) >= 5) then setAccountPassword(account, newpassword) triggerClientEvent(player, "hidePasswordWindow", getRootElement()) dbExec(connection, "UPDATE accoutns SET password=?", newpassword) else outputChatBox("Your new password must be at least 5 characters long!", player) end else outputChatBox("Old password invalid.", player) end end end function loginHandler(player, username, password, thePlayer) local query = dbQuery (connection, "SELECT * FROM accoutns WHERE username=? and password=?", username, password) local result, num_affected_rows = dbPoll(query, -1) local account = getAccount(username, password) if (account ~= false) and num_affected_rows < 1 then if (logIn(player, account, password) == true) then triggerClientEvent (player, "hideLoginWindow", getRootElement()) else triggerClientEvent (player, "unknownError", getRootElement()) end else triggerClientEvent (player, "loginWrong", getRootElement()) end end function registerHandler(player, username, password) local query = dbQuery(connection, "SELECT * FROM accoutns WHERE username=? and password=?", username, password) local result, num_affected_rows = dbPoll(query, -1) local account = getAccount(username, password) if (account ~= false) and num_affected_rows > 1 then triggerClientEvent(player, "registerTaken", getRootElement()) else account = addAccount(username, password) dbExec(connection,"INSERT INTO accounts VALUES(?, ?)", username, password) if (logIn(player, account, password) == true) then triggerClientEvent(player, "hideLoginWindow", getRootElement()) else triggerClientEvent(player, "unknownError", getRootElement()) end end end local camtable = { {3074.04468, -3041.53442, 69.20741, 3099.33130, -3110.32227, 42.89851}, {-305.43381, 1349.10864, 84.20972, -329.04495, 1535.28113, 75.56250}, {1266.68579, -2064.46631, 85.27428, 1190.04834, -2036.79968, 69.00781}, {1543.23889, -2382.14258, 56.26112, 1497.80872, -2309.76709, 25.14184}, {-1590.68567, 592.59760, 52.45333, -1522.07080, 674.48999, 52.22255} } function setCameraOnPlayerJoin() fadeCamera(source, true, 5) setTimer ( fadeCamera, 5000, 1, source, true, 0.5 ) joincampos = math.random(#camtable) lx, ly, lz, wx, wy, wz = camtable[joincampos][1], camtable[joincampos][2], camtable[joincampos][3], camtable[joincampos][4], camtable[joincampos][5], camtable[joincampos][6] setCameraMatrix(source, lx, ly, lz, wx, wy, wz) end addEventHandler("onPlayerJoin", getRootElement(), setCameraOnPlayerJoin) function setCameraRegister(player, thePlayer) setTimer( setCameraTarget,1200,1, source ) setElementFrozen ( source, false ) end function onJoin() showChat(source, false) setPlayerHudComponentVisible(source, "all", false) end addEventHandler("onPlayerJoin", root, onJoin) function onSpawn() setPlayerHudComponentVisible(source, "all", true) showChat(source, true) showCursor(source, false) end addEventHandler("onPlayerSpawn", root, onSpawn) addEvent("setCameraRegister", true) addEvent("submitChangepw", true) addEvent("submitLogin", true) addEvent("submitRegister", true) addEventHandler("submitChangepw", root, passwordHandler) addEventHandler("submitLogin", root, loginHandler) addEventHandler("submitRegister", root, registerHandler) addEventHandler("setCameraRegister", root, setCameraRegister) still same error

local connection =dbConnect("sqllitle", "dbsql/database.db") function passwordHandler(player, oldpassword, newpassword) local query = dbQuery(connection, "SELECT * FROM accoutns WHERE password=?", oldpassword) local result, num_affected_rows = dbPoll(query, -1) local account = getPlayerAccount(player) if (account) then if (isGuestAccount(account)) then outputChatBox("You must be logged in to change your password.", player) return end local playerName = getPlayerName(player) local password_check = getAccount(playerName, oldpassword) if (password_check ~= false) and num_affected_rows < 1 then if (string.len(newpassword) >= 5) then setAccountPassword(account, newpassword) triggerClientEvent(player, "hidePasswordWindow", getRootElement()) dbExec(connection, "UPDATE accoutns SET password=?", newpassword) else outputChatBox("Your new password must be at least 5 characters long!", player) end else outputChatBox("Old password invalid.", player) end end end function loginHandler(player, username, password, thePlayer) local query = dbQuery (connection, "SELECT * FROM accoutns WHERE username=? and password=?", username, password) local result, num_affected_rows = dbPoll(query, -1) local account = getAccount(username, password) if (account ~= false) and num_affected_rows < 1 then if (logIn(player, account, password) == true) then triggerClientEvent (player, "hideLoginWindow", getRootElement()) else triggerClientEvent (player, "unknownError", getRootElement()) end else triggerClientEvent (player, "loginWrong", getRootElement()) end end function registerHandler(player, username, password) local query = dbQuery(connection, "SELECT * FROM accoutns WHERE username=? and password=?", username, password) local result, num_affected_rows = dbPoll(query, -1) local account = getAccount(username, password) if (account ~= false) and num_affected_rows > 1 then triggerClientEvent(player, "registerTaken", getRootElement()) else account = addAccount(username, password) dbExec(connection,"INSERT INTO accounts VALUES(?, ?)", username, password) if (logIn(player, account, password) == true) then triggerClientEvent(player, "hideLoginWindow", getRootElement()) else triggerClientEvent(player, "unknownError", getRootElement()) end end end local camtable = { {3074.04468, -3041.53442, 69.20741, 3099.33130, -3110.32227, 42.89851}, {-305.43381, 1349.10864, 84.20972, -329.04495, 1535.28113, 75.56250}, {1266.68579, -2064.46631, 85.27428, 1190.04834, -2036.79968, 69.00781}, {1543.23889, -2382.14258, 56.26112, 1497.80872, -2309.76709, 25.14184}, {-1590.68567, 592.59760, 52.45333, -1522.07080, 674.48999, 52.22255} } function setCameraOnPlayerJoin() fadeCamera(source, true, 5) setTimer ( fadeCamera, 5000, 1, source, true, 0.5 ) joincampos = math.random(#camtable) lx, ly, lz, wx, wy, wz = camtable[joincampos][1], camtable[joincampos][2], camtable[joincampos][3], camtable[joincampos][4], camtable[joincampos][5], camtable[joincampos][6] setCameraMatrix(source, lx, ly, lz, wx, wy, wz) end addEventHandler("onPlayerJoin", getRootElement(), setCameraOnPlayerJoin) function setCameraRegister(player, thePlayer) setTimer( setCameraTarget,1200,1, source ) setElementFrozen ( source, false ) end function onJoin() showChat(source, false) setPlayerHudComponentVisible(source, "all", false) end addEventHandler("onPlayerJoin", root, onJoin) function onSpawn() setPlayerHudComponentVisible(source, "all", true) showChat(source, true) showCursor(source, false) end addEventHandler("onPlayerSpawn", root, onSpawn) addEvent("setCameraRegister", true) addEvent("submitChangepw", true) addEvent("submitLogin", true) addEvent("submitRegister", true) addEventHandler("submitChangepw", root, passwordHandler) addEventHandler("submitLogin", root, loginHandler) addEventHandler("submitRegister", root, registerHandler) addEventHandler("setCameraRegister", root, setCameraRegister)

function stopAnimation2(thePlayer) if isPedInVehicle(thePlayer) then setPedAnimation(thePlayer, false) end end

I think he want to take a vehicle zone which hes not in and go to his position

so you want see a vehicle location which your are not in