i need help

[Meshare]

hi all

Please fix error

-- server: 
function resourceStart () 
    executeSQLCreateTable("E", "ma STRING") 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), resourceStart) 
  
addEvent("N1",true) 
addEventHandler("N1",getRootElement(), 
    function() 
        local getData = executeSQLQuery("SELECT * FROM E WHERE ma = '"..getPlayerName(source).."'") 
        triggerClientEvent(source, "B", root, getData) 
    end 
) 

-- client: 
addEventHandler("onClientGUIClick",root, 
    function() 
        if ( source == button ) then 
            triggerServerEvent("N1",getLocalPlayer()) 
        end 
    end 
) 
  
addEvent("B",true) 
addEventHandler("B",root, 
    function(data_) 
        local row = guiGridListAddRow(List) 
        for v=1,#getData do 
        guiGridListSetItemText(List, row, 1, getData[v].ma, false, false) 
        end 
    end 
) 

[tosfera]

Just a quick reply for now; I would use

executeSQLQuery 

Okee so if you post me your errors I'll take a look.

[Meshare]

help me please !

[tosfera]

If you're not posting your errors, then how can I fix them?

[Meshare]

Error : attempt to get length of global 'getData' (a nil value)

[tosfera]

Error : attempt to get length of global 'getData' (a nil value)

a nil value -> doesn't exist. So, you should give the getData to the client function as a parameter.

[Meshare]

me give give the getData !

see line 14

i want if press button then add player name in list and save name player in list

[Sarrum]

Replace 'getData' to 'data_' in client-side.

[Meshare]

ok change

addEvent("B",true) 
addEventHandler("B",root, 
    function(getData) 
        local row = guiGridListAddRow(List) 
        for v=1,#getData do 
        guiGridListSetItemText(List, row, 1, getData[v].ma, false, false) 
        end 
    end 
) 

None Error in debugscript 3 and Has not added the name in the list

[Meshare]

None Help !

[TAPL]

If you haven't insert any data, you won't have any data to get it, And i don't see where you have insert the data.

[Meshare]

function resourceStart () 
    executeSQLCreateTable("E", "ma STRING") 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), resourceStart) 
  
addEvent("N1",true) 
addEventHandler("N1",getRootElement(), 
    function() 
        setElementData(root,"NamePl",getPlayerName(source)) 
        executeSQLInsert( "E", "'".. getElementData(root,"NamePl") .."'" ) 
        local getData = executeSQLQuery("SELECT * FROM E WHERE ma = '"..getElementData(root,"NamePl").."'") 
        triggerClientEvent(source, "B", root, getData) 
    end 
) 

Thank now been added to the name of the player to the list

Error : Do Be if restart script - remove name !

i wnat if restart script dont remove name .

[Meshare]

please help me !