Jump to content

DB Table


papam77

Recommended Posts

Hello, where can type table name in DB my table with users has name "users" Where can type it ?

local serverContainer = {} 
serverContainer.Settings = {} 
-- settings 
serverContainer.Settings.user = 'ficker' 
serverContainer.Settings.pass = 'larsistcool123' 
serverContainer.Settings.host = '5.104.106.162' 
serverContainer.Settings.name = 'lars' 
-- only for example ;p 
-- [url=http://lars.projectx-gaming.net/]http://lars.projectx-gaming.net/[/url] 
  
serverContainer.startResource = function() 
    local connection = dbConnect('mysql', 'dbname='..serverContainer.Settings.name..';host='..serverContainer.Settings.host, serverContainer.Settings.user, serverContainer.Settings.pass) 
    if connection then 
        outputDebugString('[MYBB-CONNECTER]: Could connect to the mysql server') 
        serverContainer.connection = connection; 
    else 
        outputDebugString('[MYBB-CONNECTER]: Couldn\'t connect to the mysql server') 
    end 
end 
  
addEventHandler('onResourceStart', resourceRoot, serverContainer.startResource) 
  
serverContainer.loginClient = function(user, pass) 
    local qh = dbQuery(serverContainer.connection,'SELECT * FROM mybb_users WHERE username = ?',user) 
    local result, row, errmsg = dbPoll ( qh, 5000 ) 
    if row > 0 then 
        for id, result in ipairs(result) do 
            local salt = result['salt'] 
            local username = result['username'] 
            local password = result['password'] 
            if salt and username and password then 
                local newPass = md5(md5(salt):lower()..md5(pass):lower()):lower() 
                if newPass == password then 
                    triggerClientEvent(source,'onClientSuccessfullyLogin',source) 
                    outputChatBox('#ff6666[sERVER]#ffffff You have successfully login.', source,1,1,1,true) 
                else 
                    outputChatBox('#ff6666[sERVER]#ffffff This account doesn\'t exists or the password is wrong.', source,1,1,1,true) 
                end 
            end 
        end 
    end 
end 
  
addEvent('onClientLogins', true) 
addEventHandler('onClientLogins', root, serverContainer.loginClient) 

Link to comment

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...