I created a function to generate a code, then return the result but it don't return nothing, I get "..code.." instead of result. And now I get error on account argument ( a userdata value )
code:
function generateCode()
local number1 = math.random(20,40)
local number2 = math.random(100,900)
local number3 = math.random(100,900)
local result = number1.."."..number2.."."..number3
return result
end
addEventHandler('onPlayerLogin',root,
function(_,account)
local select = executeSQLQuery("SELECT * FROM Phone WHERE player='"..account.."'")
if not select or #select == 0 then
local code = generateCode()
executeSQLQuery("INSERT INTO Phone VALUES ( '"..account.."','"..code.."' )")
local select2 = executeSQLQuery("SELECT number FROM Phone WHERE player='"..account.."'")
outputChatBox('#ABCDEF* #ffffffYour phone number is: '..select2[1]['number'],source,255,255,255,true)
else
local select3 = executeSQLQuery("SELECT number FROM Phone WHERE player='"..account.."'")
outputChatBox('#ABCDEF* #ffffffYour phone number is: '..select3[1]['number'],source,255,255,255,true)
end
end
)