I need help with this script

Focker · July 13, 2015

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 · July 13, 2015

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 · July 13, 2015

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 · July 13, 2015

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

Focker · July 13, 2015

Thanks longer works, but the problem now is that you do not delete the selecionado now erased all.

iMr.Dawix~# · July 13, 2015

guiGridListRemoveRow 
guiGridListGetSelectedItem

Focker · July 14, 2015

to be more specific functions? please ..

iMr.Dawix~# · July 14, 2015

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

Focker · July 14, 2015

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

Cadell · July 14, 2015

  
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

Focker · July 14, 2015

does not work is not even supported, please need urgent help!

Focker · July 14, 2015

I need only the selected line is cleared and you clear a button, someone help.

iMr.Dawix~# · July 14, 2015

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 · July 15, 2015

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

GTX · July 15, 2015

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 · July 15, 2015

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

Focker · July 15, 2015

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

Focker · July 15, 2015

get error on line 14 executeSQLQuery("DELETE FROM LogAdmin WHERE Fecha='"..path.."' AND

Focker · July 15, 2015

get error on line 14 executeSQLQuery("DELETE FROM LogAdmin WHERE Fecha='"..path.."' AND

Focker · July 15, 2015

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

GTX · July 15, 2015

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 July 15, 2015 by Guest

Focker · July 15, 2015

sorry for the spam I did not realize it had sent the message, I am new to the forum

Focker · July 15, 2015

as usual, there is no error and continue erasing everything and just want the selected: c

GTX · July 15, 2015

It's impossible lol. Are rows even there? Are they EXACTLY the same?

Focker · July 15, 2015

if the same but please Help me in this script

I need help with this script

Recommended Posts

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Link to comment

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members