#Madara Posted August 20, 2015 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 )
Walid Posted August 20, 2015 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) Do not yield your back to your enemy, might feel something strange in your ass. Two things are infinite the universe and human stupidity and i'm not sure about the universe. UF: IsTextInGridList | GetGridListRowIndexFromText | Table.removeValue | removeHex | dxDrawTriangle Skype: SaSuki102 | About Me | Youtube channel | Lua Tips & Tricks | Lua Strings | Lua Tables | Lua Operators
#Madara Posted August 20, 2015 Author Posted August 20, 2015 thanks , i fix it's the problem was i put wrong colmun name
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