[setElementVelocity backwards]

I updated code. Try again.

[setElementVelocity backwards]

function setSpeed(vehicle, velocity, vz) 
     local _,_,rz = getElementRotation(vehicle) 
     rz = rz - math.floor(math.fmod(rz, 90)) * 90 
  
     local rad = math.rad(90 - rz) 
     vx, vy = math.cos(rad) * velocity, math.sin(rad) * velocity 
  
     setElementVelocity(vehicle, vx, vy, vz or 0) 
end 

function backwards() 
     if isPedInVehicle (localPlayer) then 
          local veh = getPedOccupiedVehicle(localPlayer) 
          if getElementModel(veh) == 498 then 
               toggleControl ( "brake_reverse", false ) 
               local vx,vy,vz = getElementVelocity(veh) 
               local speed = vx + vy 
               setSpeed(veh, speed - 0.2, vz) 
          end 
     end 
end 
bindKey("s", "down", backwards) 

Try it (not tested)

[ColumnsMovable]

I think it is MTA bug.

https://bugs.multitheftauto.com/view.php?id=9285

[ColumnsMovable]

gui["grid"] = guiCreateGridList(10, 45, 319, 155, false, gui["window"]) 
guiGridListAddColumn(gui["grid"], "column 1", 0.43) 
guiGridListAddColumn(gui["grid"], "column 2", 0.23) 
guiGridListAddColumn(gui["grid"], "column 3", 0.23) 
  
guiSetProperty(gui["grid"], "ColumnsSizable", "False") 
guiSetProperty(gui["grid"], "ColumnsMovable", "False") 

ColumnsSizable is work but ColumnsMovable is not work. Not give anything in debug. What is the problem?

[Attempt to load ...]

How can I prevent it?

[Unrecognized Token]

Try putting the toJSON in single quotes.

local database = dbConnect("sqlite", "parchement.db") 
dbExec(database, "CREATE TABLE IF NOT EXISTS parchement (account_name TEXT, parchement TEXT DEFAULT '"..toJSON({}).."')") 

I'm honestly not sure if this will fix the problem though.

Solved, thank you.

[Unrecognized Token]

local database = dbConnect("sqlite", "parchement.db") 
dbExec(database, "CREATE TABLE IF NOT EXISTS parchement (account_name TEXT, parchement TEXT DEFAULT "..toJSON({})..")") 

WARNING: system\save\save.lua:2: dbExec failed; (1) unrecognized token: "]"

Where is the problem?

[Attempt to load ...]

local dff = engineLoadDFF(dff_file) 
local result = engineReplaceModel(dff, modelID) -- Line 54 

What is the meaning of this warning?

[house id]

https://wiki.multitheftauto.com/wiki/Interior_IDs

[Need Help with a script to create peds]

swatpeds = { 
     { 
          ped = nil, 
          arguements = {285, 1572.2216796875, -1626.880859375, 13.3828125, 90}, -- model,x,y,z,rotation 
          weapon = { 
               id = 31, 
               ammo = 5000, 
               setAsCurrent = true 
          }, 
          special_function = function(ped) 
              -- eg. setPedHeadless(ped, false)  
               -- TO DO 
          end 
     }, 
     { 
          ped = nil, 
          arguements = {285, 1544.6943359375, -1621.15234375, 13.55456161499, 90}, 
          weapon = { 
               id = 31, 
               ammo = 5000, 
               setAsCurrent = true 
          }, 
          special_function = function(ped) 
               -- eg. setPedHeadless(ped, true)  
               -- TO DO 
          end 
     } 
} 
  
for i, data in ipairs(swatpeds) do 
     local ped = createPed(unpack(data.arguements)) 
     giveWeapon(ped, data.weapon.id, data.weapon.ammo, data.weapon.setAsCurrent) 
  
     if type(data.special_function) == "function" then 
          data.special_function(ped) 
     end 
  
     data.ped = ped 
end 

You can reach peds with:

swatpeds[1].ped 
swatpeds[2].ped 
... 

[Need Help with a script to create peds]

Use giveWeapon if you use it on server side.

[Need Help with a script to create peds]

swatpeds = { 
     [1] = {285, 1572.2216796875, -1626.880859375, 13.3828125} 
} 
  
for k, v in ipairs(swatpeds) do 
     local ped = createPed(unpack(v)) 
     givePedWeapon(ped, 31, 5000, true) -- Give ped 5000 rounds of M4 
end 
  

[plane bombing script]

Multiplier elements doesn't contain GTA worlds.

[Please help with my sound script]

I forgot. Remove ".sound"

stopSound(sounds[thePlayer]) 

[Please help with my sound script]

local sounds = {} 
addEventHandler("onClientVehicleEnter", root, function(thePlayer, seat) 
    if seat ~= 0 then return end 
    local vehicle = getPedOccupiedVehicle(thePlayer) 
    if getElementModel(vehicle) == 480 then 
        sounds[thePlayer] = playSound3D("files/engine.wav",0,0,0, true) 
        setSoundMaxDistance(sounds[thePlayer], 50) 
        setSoundVolume(sounds[thePlayer], 1) 
        attachElements(sounds[thePlayer], vehicle) 
    end 
end) 
  
addEventHandler("onClientVehicleExit", root, function(thePlayer, seat) 
    if isElement(sounds[thePlayer]) then 
        stopSound(sounds[thePlayer].sound) 
    end 
end) 

Server-side is needless. Because the event is already attached to root. Try it.

[Please help with my sound script]

function stop(veh, thePlayer, seat) 
    if thePlayer ~= localPlayer then return end 
    triggerServerEvent("stop", resourceRoot, veh ) 
end 
addEventHandler("onClientVehicleExit",root, stop) 

[death camera]

Try it

function wasted (player) 
        if not isElement(player) then return end 
        local x, y, z = -1284.8974609375, 452.08203125, 7.1875 
        local lvl = getElementData(player,"Level") 
        if (lvl >= 0) then 
        spawnPlayer (player, x, y, z ) 
        fadeCamera( player, true) 
        setCameraTarget( player, player) 
        end 
end 
  
addEventHandler ( "onPlayerWasted", root, function() 
     setTimer(wasted, 3000, 1, source) 
end) 

[plane bombing script]

Add it for high damage.

setVehicleHandling(p_tbl.fallveh, "collisionDamageMultiplier", 10) 

And add it to disable collisions.

setElementCollidableWith(p_tbl.fallveh, p_tbl.missle, false) 

[plane bombing script]

Try it.

local bombs = {} 
  
function attach(playerSource, commandName) 
      --if bombs[playerSource] then return end 
      local theVehicle = getPedOccupiedVehicle ( playerSource ) 
     if theVehicle then 
        
          local x,y,z = getElementPosition(theVehicle) 
          local rx,ry,rz = getVehicleRotation(theVehicle) 
        
          if not bombs[playerSource] then 
               bombs[playerSource] = {} 
          end 
  
          bombs[playerSource].missle = createObject(3786,x,y,z,rx,ry,rz) 
          bombs[playerSource].occVehicle = theVehicle 
  
     attachElements(bombs[playerSource].missle,bombs[playerSource].occVehicle,0,0,-1.1,0,0,-90) 
     end 
end 
  
  
function detach(playerSource, commandName) 
     local p_tbl = bombs[playerSource] 
     if not p_tbl then return end 
  
     local theVehicle = getPedOccupiedVehicle ( playerSource ) 
     if theVehicle and theVehicle == p_tbl.occVehicle then 
        
          local x,y,z = getElementPosition(playerSource) 
          local rx,ry,rz = getVehicleRotation(theVehicle) 
          local vx,vy,vz = getElementVelocity(theVehicle) 
        
          detachElements(p_tbl.missle) 
          p_tbl.fallveh = createVehicle(602, x,y,z-2,180,0,rz) 
          setElementVelocity(p_tbl.fallveh,vx,vy,vz) 
          --setElementAlpha ( p_tbl.fallveh, 0 ) 
  
     attachElements(p_tbl.missle,p_tbl.fallveh,0,0,0,0,0,270) 
     end 
end 
  
addEventHandler("onVehicleDamage", root, function() 
     for player, tbl in pairs(bombs) do 
          if tbl.fallveh == source then 
               if isElement(tbl.fallveh) then 
                    blowVehicle(tbl.fallveh) 
               end 
               bombs[player] = nil 
               return 
          end 
     end 
end) 
  
addCommandHandler("a", attach) 
addCommandHandler("d", detach) 

[Weapon Problem]

GUIEditor.button[2] = guiCreateButton(10, 147, 77, 34, "Pistol\n300$:1 LVL", false, GUIEditor.window[1]) 
  
addEventHandler("onClientGUIClick", guiRoot, function(button, state, absoluteX, absoluteY) 
     if source == GUIEditor.button[1] then 
          guiSetVisible(GUIEditor.window[1] , false) 
          showCursor(false) 
     elseif source ==  GUIEditor.button[2] then 
          guiSetEnabled(source, false) 
     end 
end) 

[All Querys of SQL]

Thanks.

[All Querys of SQL]

Where can I find all querys of SQL?

eg: INSERT, DROP, ALTER, RENAME ...

Thanks.

[Zombie ExtraHealth Error]

addEvent("onZombieSpawn", true) 
function extrah() 
     if getElementData(source, "zombie") then -- not necessary 
          if getElementModel(source) == 162 then 
               exports.extrahealth:setElementExtraHealth(source, 500) 
          end 
     end 
end 
addEventHandler("onZombieSpawn", root, extrah) 

[Zombie ExtraHealth Error]

addEvent("onZombieSpawn", true) 
function extrah() 
     if getElementData(source, "zombie") then -- not necessary 
          if getElementModel(source) == 162 then 
               exports.extrahealth:setElementExtraHealth(source, 500) 
          end 
     end 
end 
addEventHandler("onZombieSpawn", root, extrah) 

[[HELP] Ped looking at an object]

As I understand as: SetPedLookAt