TheNightRider

Thanks man ive already done that, got the binary's trouble am getting now is its saying unable to bind the ip and port? EDIT: NVM ive fixed it finally ROFL thanks for your help bud .

Thanks man ive already done that, got the binary's trouble am getting now is its saying unable to bind the ip and port?

Yes mate your right but the mta-server file I was referring too didn't exist, had to download the binary's but now ive got a problem. Says libncursew.so.5: cannot open shared object file: No such file or directory. Then it says ERROR: could not load ./core.so *Check installed data files. Press enter to continue. This happens when I start the mta-server and am not sure how to fix it

Hey guys am trying to start up MTA Server on Linux but am unable to locate the MTA_Server.sh, Any Idea's?

Thanks mate that did the trick works fine I just need to alter it in places so it only does if true eg if there is nothing for example banned_reason it won't try to show it on GUI otherwise it flags a bad argument but I can do that myself. Am still bit of a Noob when it comes to LUA for MTA but am slowly finding my way around things. You guys have been most helpful

Thanks mate got that section working finally LOl. PS the pData is still returning as Boolean do you have any idea's why this is so?

Thanks budy but it returns an error saying attempt to index local pData (boolean value) regarding the following line:- guiSetText(IDEd, pData.id) PS is the function which retrieves selected user from gridlist:- function selecteditem(datainput) local datainput = guiGridListGetSelectedItem(UsrList) if(datainput) then triggerServerEvent( "selector:query",getRootElement(), datainput) end end

I divided the clientside function into 2 in the hope to solve the issue but the problem still remains, could you explain why selected returning a Boolean value ddEvent("item",true) function selecteditem(datainput) local datainput = guiGridListGetSelectedItem(UsrList) if (datainput) then triggerServerEvent( "SelectD",getRootElement(), UsrList ) else if not (datainput) then return 0 end end end addEventHandler("item",getRootElement(),selecteditem) addEvent("takedata",true) function retrieve(selected) if not (selected) then outputChatBox ( selected ) return 0 else if (selected) then local id=GuiGetText(IDEd,selected["id"]) local usr=GuiGetText(UsrN,selected["username"]) local admin=GuiGetText(ALvl,selected["admin"] ) local reason=GuiGetText(Banned,selected["banned_reason"] ) end end end addEventHandler("takedata",getRootElement(),retrieve)

Okay thanks for that but am not able to figure out why its not passing the data to ClientSide as its always returning a Boolean value You know that is off subject cos its got nothing to do with why a value is returning a value whatsoever and its getLocalPlayer which does Sweet FA eg in this instance it returns an error

Thanks ive fixed that part Its supposed to get the data from the guigridlist if selected and run it within the sql query so it gets the data of that username. I am not sure where am going wrong with this section. The problem is it doesn't seem to be passing the data onto the ClientSide. addEvent("SelectD",true) function getselected(take) outputChatBox ( take ) local result = mysql:query_fetch_assoc ( "SELECT id, admin, adminjail_time,banned_reason FROM accounts WHERE 'username'="..take.."'" ) if (result["take"]) then local data= mysql:fetch_assoc(result) end triggerClientEvent ( playerSource, "takedata", playerSource, data["id"] ) end addEventHandler("SelectD",getRootElement(),getselected ClientSide:- addEvent("takedata",true) function retrieve(selected) local selected = guiGridListGetSelectedItem(UsrList) if (selected) then triggerServerEvent( "SelectD",getRootElement(), UsrList ) local id=GuiGetText(IDEd,selected["id"]) local usr=GuiGetText(UsrN,selected["username"]) local admin=GuiGetText(ALvl,selected["admin"] ) local reason=GuiGetText(Banned,selected["banned_reason"] ) else if not(selected) then return 0 end end end addEventHandler("takedata",getRootElement(),retrieve)

Thanks man I wondering whats with the triggerServerSide I cannot fathom out the issue. I changed it to what you said but its still telling me that userdata is boolean.

Am working on the next piece of code for some reason it keeps on returning a boolean for each guiSetText although I guess it could be cos of the other issue. When I try to make the trigger work 1 am not too sure what the first argument I should be using in this case and why its saying the 2nd argument is saying expected element got string when the argument is an addEvent. PS its a TextEdit box am using to display the data for each id, admin etc. I'll be most thankful to anyone who gives me some good advice on the related issues. ClientSide addEvent("takedata",true) function retrieve(userdata) local selected = guiGridListGetSelectedItem(UsrList) if (selected) then triggerServerEvent( addrow, "SelectD", true ) local id=guiSetText(IDEd,userdata["id"]) local usr=guiSetText(UsrN,userdata["username"]) local admin=guiSetText(ALvl,userdata["admin"] ) local reason=guiSetText(Banned,userdata["banned_reason"] ) else if not(selected) then return 0 end end end addEventHandler("takedata",getRootElement(),retrieve) ServerSide addEvent("selectD",true) function getselected() local result = mysql:query ( "SELECT id, admin, adminjail_time,banned_reason FROM accounts WHERE 'username'="..select.."'" ) if (result["select"]) then local data= mysql:fetch_assoc(result) -- outputChatBox ( data["admin"] ) end triggerClientEvent ( playerSource, "takedata", playerSource, data ) end addEventHandler("SelectD",getRootElement(),getselected

Thanks man that works great

I did try it what you wrote and there was no output to gridedit and no errors.

Am working on the next stage, ive got it to query for the usernames I did a test and the first username in the table showed on chat as exspected. The issue am having is passing the data to clientside so it will be displayed on the Gridlist. Serverside:- function UsrList( playerSource)--query database table for list of users to be used on clientside. local usrs = mysql:query_fetch_assoc("SELECT username FROM accounts ") if (usrs) then triggerClientEvent (( usrs["username"]),"getlist",true) outputChatBox ( tostring ( usrs ["username"] ) ) end end addCommandHandler ( "dbmanl", UsrList ) Clientside so far:- addEvent ("getlist",true) function Listing()--Display list of users in gridlist on GUI. local addrow = guiGridListAddRow(UsrList) guiGridListSetItemText(UsrList,addrow,Col,(usrs ["username"]) ,false,false) end addEventHandler("getlist",getRootElement(),Listing)