Focker

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

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

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

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

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

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

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

to be more specific functions? please ..

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

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

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 Thank you Brother (y) Last visit! now set to DB functions as I can delete?

But it did not erase

Could you be more specific please

Hello I need your help on this script that I'm doing well I want to be deleted from the list marrow to select the log from the list and can delete a button, the problem in the script is that I deleted everything and I just want to delete the selected down here I can see the script 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,plr) end end Server function resourceStart () executeSQLCreateTable("LogAdmin", "Fecha TEXT,Admin TEXT,Premio TEXT,Cantidad TEXT,SelecTodos TEXT,Jugador TEXT") end addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), resourceStart) 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) executeSQLDelete("LogAdmin","Fecha", path) executeSQLDelete("LogAdmin","Admin", path) executeSQLDelete("LogAdmin","Premio", path) executeSQLDelete("LogAdmin","Cantidad", path) executeSQLDelete("LogAdmin","SelecTodos", path) executeSQLDelete("LogAdmin","Jugador", path) VerLogAdmin() end addEventHandler("borrarlogadmin", root, borrarlogadmin)

Hello help me? I made a log for punishment to jail, mutes, ban, etc ... The problem is that if an admin returns evil punishment can not be erased and want to make a button with the function of selecting the wrong log given by the administrator and to delete local sql = { Query = executeSQLQuery }; addEventHandler( 'onResourceStart', resourceRoot, function() sql.Query( "CREATE TABLE IF NOT EXISTS LogPunishment (\ Date STRING, Elemento STRING, STAFF STRING,\ Time STRING, Reazon STRING )" ) end ) function LogAdmin (source) local logPunish = executeSQLQuery("SELECT * FROM LogPunishment") triggerClientEvent (source,"Punishlog",source,logPunish) end addCommandHandler ("punishlog", LogAdmin)