Hola necesito ayuda en mi script, quiero que se borre la linea seleccionada apretando solo el boton pero me borra todo.
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)
borrarselec = guiCreateButton(0.73, 0.24, 0.13, 0.09, "Borrar Seleccionado", true, TabTest2)
function onbtn()
if source == borrarselec 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='"..path.."' AND Admin='"..admin.."' AND Premio='"..premio.."' AND Cantidad='"..cantidad.."' AND SelecTodos='"..selectodos.."' AND Jugador='"..plr.."'")
VerLogAdmin()
end
end
addEventHandler("borrarlogadmin", root, borrarlogadmin)