Jump to content

Delete Selected from gridlist from sql


#Madara

Recommended Posts

Posted

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 
) 
Posted

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

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...