Sure
databaseINFO = {
host = 'localhost',
user = 'root',
pass = 'PRIVATE',
db = 'mybb',
}
addEventHandler("onResourceStart",resourceRoot,
function()
local connection = dbConnect('mysql', 'dbname='..databaseINFO.db..';host='..databaseINFO.host, databaseINFO.user, databaseINFO.pass)
if connection then
databaseINFO.connection = connection
outputDebugString('[MYSQL-CONNECT]: Connected')
else
databaseINFO.connection = false
outputDebugString('[MYSQL-CONNECT]: Could not connect')
end
end)
function playerWantToLogin(username,password)
local qh = dbQuery(databaseINFO.connection,'SELECT * FROM mybb_users WHERE username = ?',username)
local result, row, errmsg = dbPoll ( qh, 5000 )
if row and row > 0 then
for id, result in ipairs(result) do
local Asalt = result['salt']
local Aname = result['username']
local Apass = result['password']
local convertPass = md5(md5(Asalt):lower()..md5(password):lower()):lower()
if convertPass == Apass then
return "success",result['uid']
end
end
end
end
function getPlayerGroup(accName)
local qh = dbQuery(databaseINFO.connection,'SELECT * FROM mybb_users WHERE username = ?',accName)
local result, row, errmsg = dbPoll ( qh, 5000 )
if row and row > 0 then
for id, result in ipairs(result) do
local groupID = result['usergroup']
return groupID
end
else
return false
end
end
function checkUserName(username)
local qh = dbQuery(databaseINFO.connection,'SELECT * FROM mybb_users WHERE username = ?',username)
local result, row, errmsg = dbPoll ( qh, 5000 )
if row and row > 0 then
return "success"
end
return false
end
In my windows server works. Now, i dont know why it dosent on linux.
