#Madara Posted August 20, 2015 Share Posted August 20, 2015 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
Walid Posted August 20, 2015 Share Posted August 20, 2015 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
#Madara Posted August 20, 2015 Author Share Posted August 20, 2015 thanks , i fix it's the problem was i put wrong colmun name Link to comment
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now