Jump to content

I need help with this script

Focker

By Focker
in Scripting

Recommended Posts

Focker Snitch

Focker

Posted
Posted

Hi, I need your help, I made a script for logs admin, all well but when I want to clear the log 1 for 1 all of deleted and I want a button selections the line you want and you can delete only the button

Client

function veryaellogad(tab) 
    guiGridListClear(logadmin) 
  for i, gs in pairs(tab) do 
    local row = guiGridListAddRow(logadmin) 
    guiGridListSetItemText(logadmin, row,logadm1, gs.Fecha, false, true) 
    guiGridListSetItemText(logadmin, row,logadm2, gs.Admin, false, true) 
    guiGridListSetItemText(logadmin, row,logadm3, gs.Premio, false, true) 
    guiGridListSetItemText(logadmin, row,logadm4, gs.Cantidad, false, true) 
    guiGridListSetItemText(logadmin, row,logadm5, gs.SelecTodos, false, true)    
    guiGridListSetItemText(logadmin, row,logadm6, gs.Jugador, false, true) 
     
  end 
end 
addEvent("veryaellog", true) 
addEventHandler("veryaellog", root, veryaellogad) 
  
function borrarlogadmin() 
local path = guiGridListGetItemData(logadmin, guiGridListGetSelectedItem(logadmin), 1) 
    local plr = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 6) 
    if (path and plr) then 
        triggerServerEvent("borrarlogadmin", localPlayer,path) 
end  
end

Server

executeSQLQuery("CREATE TABLE IF NOT EXISTS LogAdmin (Fecha TEXT, Admin TEXT, Premio TEXT,Cantidad TEXT,SelecTodos TEXT,Jugador TEXT)") 
     
  
function VerLogAdmin() 
    tablodelgadmin = executeSQLQuery("SELECT * FROM LogAdmin") 
    triggerClientEvent (source,"veryaellog",source,tablodelgadmin) 
end  
addEvent ("VerLogAdmin", true) 
addEventHandler ("VerLogAdmin", root, VerLogAdmin)  
  
  
addEvent("borrarlogadmin", true) 
function borrarlogadmin(path, plr) 
if (path and plr) then 
executeSQLQuery("DELETE FROM LogAdmin WHERE Fecha",path) 
executeSQLQuery("DELETE FROM LogAdmin WHERE Admin",path) 
executeSQLQuery("DELETE FROM LogAdmin WHERE Premio",path) 
executeSQLQuery("DELETE FROM LogAdmin WHERE Cantidad",path) 
executeSQLQuery("DELETE FROM LogAdmin WHERE SelecTodos",path) 
executeSQLQuery("DELETE FROM LogAdmin WHERE Jugador",path) 
        VerLogAdmin() 
    end  
    end  
addEventHandler("borrarlogadmin", root, borrarlogadmin)

GTX Lil' G

GTX

Posted
Posted

You didn't need to create new topic.

You need only 1 SQL query.

  
executeSQLQuery("CREATE TABLE IF NOT EXISTS LogAdmin (Fecha TEXT, Admin TEXT, Premio TEXT,Cantidad TEXT,SelecTodos TEXT,Jugador TEXT)") 
    
  
function VerLogAdmin() 
    tablodelgadmin = executeSQLQuery("SELECT * FROM LogAdmin") 
    triggerClientEvent (source,"veryaellog",source,tablodelgadmin) 
end 
addEvent ("VerLogAdmin", true) 
addEventHandler ("VerLogAdmin", root, VerLogAdmin) 
  
addEvent("borrarlogadmin", true) 
function borrarlogadmin(path, plr) 
    if path and plr then 
        executeSQLQuery("DELETE FROM LogAdmin WHERE Fecha='"..path.."' AND Jugador='"..plr.."'") 
        VerLogAdmin() 
    end 
end  
addEventHandler("borrarlogadmin", root, borrarlogadmin) 


  
function veryaellogad(tab) 
    guiGridListClear(logadmin) 
    for i, gs in pairs(tab) do 
        local row = guiGridListAddRow(logadmin) 
        guiGridListSetItemText(logadmin, row,logadm1, gs.Fecha, false, true) 
        guiGridListSetItemText(logadmin, row,logadm2, gs.Admin, false, true) 
        guiGridListSetItemText(logadmin, row,logadm3, gs.Premio, false, true) 
        guiGridListSetItemText(logadmin, row,logadm4, gs.Cantidad, false, true) 
        guiGridListSetItemText(logadmin, row,logadm5, gs.SelecTodos, false, true)    
        guiGridListSetItemText(logadmin, row,logadm6, gs.Jugador, false, true) 
    end 
end 
addEvent("veryaellog", true) 
addEventHandler("veryaellog", root, veryaellogad) 
  
function borrarlogadmin() 
    local path = guiGridListGetItemData(logadmin, guiGridListGetSelectedItem(logadmin), 1) 
    local plr = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 6) 
    if path and plr then 
        triggerServerEvent("borrarlogadmin", localPlayer, path, plr) 
    end 
end

Focker Snitch

Focker

Posted
  • Author
Posted

I do not work, not only fails or anything that the button does nothing does not give the role deveria there command the entire script

Client:

logadmin = guiCreateGridList(0.01, 0.04, 0.70, 0.91, true, TabTest2) 
logadm1 = guiGridListAddColumn(logadmin, "Fecha", 0.1) 
logadm2 = guiGridListAddColumn(logadmin, "Admin", 0.3) 
logadm3 = guiGridListAddColumn(logadmin, "Premio", 0.3) 
logadm4 = guiGridListAddColumn(logadmin, "Cantidad", 0.3) 
logadm5 = guiGridListAddColumn(logadmin, "Selecc/Todos", 0.3) 
logadm6 = guiGridListAddColumn(logadmin, "Jugador", 0.3) 
actualizarlogadm = guiCreateButton(0.73, 0.24, 0.13, 0.09, "Actualizar", true, TabTest2) 
  
  
  
 function Test() 
if source == actualizarlogadm then  
borrarlogadmin() 
end 
end 
addEventHandler("onClientGUIClick", resourceRoot, Test) 
  
function veryaellogad(tab) 
    guiGridListClear(logadmin) 
    for i, gs in pairs(tab) do 
        local row = guiGridListAddRow(logadmin) 
        guiGridListSetItemText(logadmin, row,logadm1, gs.Fecha, false, true) 
        guiGridListSetItemText(logadmin, row,logadm2, gs.Admin, false, true) 
        guiGridListSetItemText(logadmin, row,logadm3, gs.Premio, false, true) 
        guiGridListSetItemText(logadmin, row,logadm4, gs.Cantidad, false, true) 
        guiGridListSetItemText(logadmin, row,logadm5, gs.SelecTodos, false, true)   
        guiGridListSetItemText(logadmin, row,logadm6, gs.Jugador, false, true) 
    end 
end 
addEvent("veryaellog", true) 
addEventHandler("veryaellog", root, veryaellogad) 
  
function borrarlogadmin() 
    local path = guiGridListGetItemData(logadmin, guiGridListGetSelectedItem(logadmin), 1) 
    local plr = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 6) 
    if path and plr then 
        triggerServerEvent("borrarlogadmin", localPlayer, path, plr) 
    end

Server:

executeSQLQuery("CREATE TABLE IF NOT EXISTS LogAdmin (Fecha TEXT, Admin TEXT, Premio TEXT,Cantidad TEXT,SelecTodos TEXT,Jugador TEXT)") 
    
  
function VerLogAdmin() 
    tablodelgadmin = executeSQLQuery("SELECT * FROM LogAdmin") 
    triggerClientEvent (source,"veryaellog",source,tablodelgadmin) 
end 
addEvent ("VerLogAdmin", true) 
addEventHandler ("VerLogAdmin", root, VerLogAdmin) 
  
addEvent("borrarlogadmin", true) 
function borrarlogadmin(path, plr) 
    if path and plr then 
        executeSQLQuery("DELETE FROM LogAdmin WHERE Fecha='"..path.."' AND Jugador='"..plr.."'") 
        VerLogAdmin() 
    end 
end

GTX Lil' G

GTX

Posted
Posted

Client:

logadmin = guiCreateGridList(0.01, 0.04, 0.70, 0.91, true, TabTest2) 
logadm1 = guiGridListAddColumn(logadmin, "Fecha", 0.1) 
logadm2 = guiGridListAddColumn(logadmin, "Admin", 0.3) 
logadm3 = guiGridListAddColumn(logadmin, "Premio", 0.3) 
logadm4 = guiGridListAddColumn(logadmin, "Cantidad", 0.3) 
logadm5 = guiGridListAddColumn(logadmin, "Selecc/Todos", 0.3) 
logadm6 = guiGridListAddColumn(logadmin, "Jugador", 0.3) 
actualizarlogadm = guiCreateButton(0.73, 0.24, 0.13, 0.09, "Actualizar", true, TabTest2) 
  
  
  
 function onbtn() 
if source == actualizarlogadm then 
borrarlogadmin() 
end 
end 
addEventHandler("onClientGUIClick", root, onbtn) 
  
function veryaellogad(tab) 
    guiGridListClear(logadmin) 
    for i, gs in pairs(tab) do 
        local row = guiGridListAddRow(logadmin) 
        guiGridListSetItemText(logadmin, row,logadm1, gs.Fecha, false, true) 
        guiGridListSetItemText(logadmin, row,logadm2, gs.Admin, false, true) 
        guiGridListSetItemText(logadmin, row,logadm3, gs.Premio, false, true) 
        guiGridListSetItemText(logadmin, row,logadm4, gs.Cantidad, false, true) 
        guiGridListSetItemText(logadmin, row,logadm5, gs.SelecTodos, false, true)   
        guiGridListSetItemText(logadmin, row,logadm6, gs.Jugador, false, true) 
    end 
end 
addEvent("veryaellog", true) 
addEventHandler("veryaellog", root, veryaellogad) 
  
function borrarlogadmin() 
    local path = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 1) 
    local plr = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 6) 
    if path and plr then 
        triggerServerEvent("borrarlogadmin", localPlayer, path, plr) 
    end

iMr.Dawix~# Loc

iMr.Dawix~#

Posted
Posted
to be more specific functions? please ..

just take it

function borrarlogadmin() 
    local path = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 1) 
    local plr = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 6) 
    guiGridListRemoveRow(guiGridListGetSelectedItem(logadmin)) 
    if path and plr then 
        triggerServerEvent("borrarlogadmin", localPlayer, path, plr) 
    end 
end

Cadell Snitch

Cadell

Posted
Posted 
  
local row = guiGridListGetSelectedItem(logadmin) 
    if row ~= -1 then 
  
local id = guiGridListGetItemData(logadmin, row, 1) 
if deletecondition then 
            triggerServerEvent("delete", localPlayer, id) 
end 
end 
  
 

now use server

addEvent("delete", true) 
addEventHandler("delete", getRootElement(), 
function(id) 
    if id then 
        if dbExec(connection,'DELETE FROM table WHERE id=?', id) then 
             
            outputChatBox("log Deleted",source, 100, 100, 100) 
        end 
    end 
end 
)

hope this will help you

and use id for all u r info or instead of id get title name or etc compare and u done

id INTEGER PRIMARY KEY

iMr.Dawix~# Loc

iMr.Dawix~#

Posted
Posted
still it does not work, everything is cleared yet, want you to delete only the selected and saved in the database.

function borrarlogadmin() 
    local path = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 1) 
    local plr = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 6) 
    local row = guiGridListGetSelectedItem(logadmin) 
    if path and plr then 
        triggerServerEvent("borrarlogadmin", localPlayer, path, plr) 
        guiGridListRemoveRow(logadmin,row) 
    end 
end

if this dosen't work show me /debugscript 3

Focker Snitch

Focker

Posted
  • Author
Posted

does not leave any error but continues deleting everything disappears entire list rather than remove just the selected,

GTX Lil' G

GTX

Posted
Posted

Try this:

executeSQLQuery("CREATE TABLE IF NOT EXISTS LogAdmin (Fecha TEXT, Admin TEXT, Premio TEXT,Cantidad TEXT,SelecTodos TEXT,Jugador TEXT)") 
    
  
function VerLogAdmin() 
    tablodelgadmin = executeSQLQuery("SELECT * FROM LogAdmin") 
    triggerClientEvent (source,"veryaellog",source,tablodelgadmin) 
end 
addEvent ("VerLogAdmin", true) 
addEventHandler ("VerLogAdmin", root, VerLogAdmin) 
  
addEvent("borrarlogadmin", true) 
function borrarlogadmin(path, plr) 
    if path and plr then 
        executeSQLQuery("DELETE FROM LogAdmin WHERE Fecha='"..path.."' AND Jugador='"..plr.."' LIMIT 1") 
        VerLogAdmin() 
    end 
end 
addEventHandler("borrarlogadmin", root, borrarlogadmin)

And if you could translate that words to english, it would be helpful.

Focker Snitch

Focker

Posted
  • Author
Posted

sale error en la linea 14 executeSQLQuery("DELETE FROM LogAdmin WHERE Fecha='"..path.."' AND Jugador='"..plr.."' LIMIT 1")

Focker Snitch

Focker

Posted
  • Author
Posted

get error on line 14 executeSQLQuery("DELETE FROM LogAdmin WHERE Fecha='"..path.."' AND Jugador='"..plr.."' LIMIT 1")

GTX Lil' G

GTX

Posted
Posted (edited)

Client:

logadmin = guiCreateGridList(0.01, 0.04, 0.70, 0.91, true, TabTest2) 
logadm1 = guiGridListAddColumn(logadmin, "Fecha", 0.1) 
logadm2 = guiGridListAddColumn(logadmin, "Admin", 0.3) 
logadm3 = guiGridListAddColumn(logadmin, "Premio", 0.3) 
logadm4 = guiGridListAddColumn(logadmin, "Cantidad", 0.3) 
logadm5 = guiGridListAddColumn(logadmin, "Selecc/Todos", 0.3) 
logadm6 = guiGridListAddColumn(logadmin, "Jugador", 0.3) 
actualizarlogadm = guiCreateButton(0.73, 0.24, 0.13, 0.09, "Actualizar", true, TabTest2) 
  
  
  
 function onbtn() 
if source == actualizarlogadm then 
borrarlogadmin() 
end 
end 
addEventHandler("onClientGUIClick", root, onbtn) 
  
function veryaellogad(tab) 
    guiGridListClear(logadmin) 
    for i, gs in pairs(tab) do 
        local row = guiGridListAddRow(logadmin) 
        guiGridListSetItemText(logadmin, row,logadm1, gs.Fecha, false, true) 
        guiGridListSetItemText(logadmin, row,logadm2, gs.Admin, false, true) 
        guiGridListSetItemText(logadmin, row,logadm3, gs.Premio, false, true) 
        guiGridListSetItemText(logadmin, row,logadm4, gs.Cantidad, false, true) 
        guiGridListSetItemText(logadmin, row,logadm5, gs.SelecTodos, false, true)   
        guiGridListSetItemText(logadmin, row,logadm6, gs.Jugador, false, true) 
    end 
end 
addEvent("veryaellog", true) 
addEventHandler("veryaellog", root, veryaellogad) 
  
function borrarlogadmin() 
    local path = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 1) 
    local admin = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 2) 
    local premio = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 3) 
    local cantidad = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 4) 
    local selectodos = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 5) 
    local plr = guiGridListGetItemText(logadmin, guiGridListGetSelectedItem(logadmin), 6) 
    if path and path ~= -1 then 
        triggerServerEvent("borrarlogadmin", localPlayer, path, admin, premio, cantidad, selectodos, plr) 
    end 
end

Server:

executeSQLQuery("CREATE TABLE IF NOT EXISTS LogAdmin (Fecha TEXT, Admin TEXT, Premio TEXT,Cantidad TEXT,SelecTodos TEXT,Jugador TEXT)") 
    
  
function VerLogAdmin() 
    tablodelgadmin = executeSQLQuery("SELECT * FROM LogAdmin") 
    triggerClientEvent (source,"veryaellog",source,tablodelgadmin) 
end 
addEvent ("VerLogAdmin", true) 
addEventHandler ("VerLogAdmin", root, VerLogAdmin) 
  
addEvent("borrarlogadmin", true) 
function borrarlogadmin(path, admin, premio, cantidad, selectodos, plr) 
    if path then 
        executeSQLQuery("DELETE FROM LogAdmin WHERE Fecha=? AND Admin=? AND Premio=? AND Cantidad=? AND SelecTodos=? AND Jugador=?", path, admin, premio, cantidad, selectodos, plr) 
        VerLogAdmin() 
    end 
end 
addEventHandler("borrarlogadmin", root, borrarlogadmin)

Edited by Guest

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...