Jump to content

Delete Selected from gridlist from sql


#Madara

Recommended Posts

hi guys ,

i want delete what i select from grid list from sql lite ,

i make it but i don't know why it's don't work

no debug .

Client :

addEventHandler("onClientGUIClick",root, 
function() 
if ( source == Remove ) then 
local xText = guiGridListGetItemText ( GridList, guiGridListGetSelectedItem ( GridList ), 1 ) 
if ( xText ~= "" or xText ~= " ") then 
triggerServerEvent("RemoveFromDataBase",localPlayer,xText) 
local clear = guiGridListClear ( GridList )    
if ( clear ) then 
triggerServerEvent("requestData", localPlayer) 
end 
end 
end 
end 
) 

Server :

addEvent("RemoveFromDataBase",true) 
addEventHandler("RemoveFromDataBase",root, 
function(text) 
executeSQLQuery("DELETE FROM `VIP System` WHERE PlayerAccount=?", text) 
end 
) 
Link to comment

After deleting the playerAccount from your database you need to remove it also from the GridList So you need sth like this

local row = guiGridListGetSelectedItem(GridList) 
if not row or row == -1 then return end 
guiGridListRemoveRow(GridList, row) 

Link to comment

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
  • Recently Browsing   0 members

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