Extinction Posted March 28, 2017 Share Posted March 28, 2017 SERVER SIDE function getCharacters() local result = {} local query = dbQuery(db, "SELECT * FROM characters WHERE account=?", getPlayerUsername(source)) result = dbPoll(query,-1) dbFree(query) if #result > 0 then triggerClientEvent(client,"setCharacters",client,result) else triggerClientEvent(client,"setCharacters",client,{}) end end addEvent("getCharacters",true) addEventHandler("getCharacters", root, getCharacters) CLIENT SIDE charGrid = guiCreateGridList(0.37, 0.32, 0.31, 0.25, true) guiGridListAddColumn(charGrid, "id", 0.3) guiGridListAddColumn(charGrid, "name", 0.3) guiGridListAddColumn(charGrid, "skin", 0.3) guiSetVisible(charGrid, false) guiSetVisible(playBtn, false) function setData(tab) for i=1,#tab do local row = guiGridListAddRow ( charGrid ) guiGridListSetItemText ( charGrid, row, 1, tab[i]['id'] , false, false ) guiGridListSetItemText ( charGrid, row, 2, tab[i]['name'] , false, false ) guiGridListSetItemText ( charGrid, row, 3, tab[i]['skin'] , false, false ) end end addEvent("setCharacters",true) addEventHandler("setCharacters",root,setData) ------------------------ function onClick() if source == characters then triggerServerEvent("getCharacters",getLocalPlayer()) end end addEventHandler("onClientGUIClick", root, onClick) everytime i will click on characters button, it will keep adding more rows of the same character again and again, how can i fix this issue? Link to comment
NeXuS™ Posted March 28, 2017 Share Posted March 28, 2017 function setData(tab) guiGridListClear(charGrid) for i=1,#tab do local row = guiGridListAddRow ( charGrid ) guiGridListSetItemText ( charGrid, row, 1, tab[i]['id'] , false, false ) guiGridListSetItemText ( charGrid, row, 2, tab[i]['name'] , false, false ) guiGridListSetItemText ( charGrid, row, 3, tab[i]['skin'] , false, false ) end end addEvent("setCharacters",true) addEventHandler("setCharacters",root,setData) Try this one. Link to comment
Extinction Posted March 28, 2017 Author Share Posted March 28, 2017 Thank you this one is work 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