HELP

[AirFighter]

Hai people I found this multigamemode on internet but its working with a database Connected with a site I want it to work normally not on a site connected with so if there is someone who can help there is the code

  
server = {} 
server.__index = server 
  
server.connection = dbConnect( "mysql", "dbname=wtf;host=localhost", "root", "" ) 
if ( server.connection ) then 
    outputDebugString("Connection to database successful") 
else 
    outputDebugString("Connection to database failed") 
end 
  
server.maps = { 
    ["Deathmatch"] = {}, 
    ["Destruction"] = {}, 
    ["Hunter"] = {}, 
    ["Shooter"] = {} 
} 
  
function server.refreshMaps() 
    --// Clear Map Lists 
    server.maps["Deathmatch"] = {} 
    server.maps["Destruction"] = {} 
    server.maps["Hunter"] = {} 
    server.maps["Shooter"] = {} 
     
    --// Fill Map Lists 
    for index, resource in ipairs ( getResources() ) do 
        local name = getResourceName( resource ) 
        if ( string.find( name, "[DM]", 1, true ) ) then 
            local real = getResourceInfo( resource, "name" ) 
            table.insert( server.maps["Deathmatch"], { name, real } ) 
        elseif ( string.find( name, "[DD]", 1, true ) ) then 
            local real = getResourceInfo( resource, "name" ) 
            table.insert( server.maps["Destruction"], { name, real } ) 
        elseif ( string.find( name, "[Hunter]", 1, true ) ) then 
            local real = getResourceInfo( resource, "name" ) 
            table.insert( server.maps["Hunter"], { name, real } ) 
        elseif ( string.find( name, "[shooter]", 1, true ) ) then 
            local real = getResourceInfo( resource, "name" ) 
            table.insert( server.maps["Shooter"], { name, real } ) 
        end 
    end 
end 
addEventHandler("onResourceStart", getRootElement( getThisResource() ), server.refreshMaps) 
  
function server.randomMap( List ) 
    --// Return a random Map 
    local map 
    if ( List ~= "" ) then 
        local id = math.random( #server.maps[List] ) 
        if ( id > 0 ) then 
            map = id 
        end 
        return map 
    end 
end 
  
function server.getMapName( List, id, Version ) 
    --// Return Mapname 
    local name = "N/A" 
    if ( List ~= "" and id > 0 and #server.maps[List] >= id ) then 
        name = server.maps[List][id][Version] --// Version: 1 = Resourcename | 2 = Meta Name 
    end 
    return name 
end 
  
function server.login( thePlayer, Username, Password ) 
    --// Login the Player 
    if ( thePlayer ~= "" and Username ~= "" and Password ~= "" ) then 
        if ( getElementData( thePlayer, "Connection" ) ~= 1 ) then 
            local accounts = dbQuery( server.connection, "SELECT * FROM wtf_accounts WHERE Accountname = '" .. Username .. "'" ) 
            local result, rows, errormessage = dbPoll( accounts, -1 ) 
             
            if ( rows == 1 ) then 
                for i, row in pairs( result ) do 
                    local pass = string.upper( row['Password'] ) 
                    local salt = row['Salt'] 
                    local gens = md5( md5( salt .. pass .. salt ) ) 
                    local ePass = md5( Password ) 
                    local salted = md5( md5( salt .. ePass .. salt ) ) 
                     
                    if ( gens == salted ) then 
                        setElementData( thePlayer, "Connection", 1 ) -- 0 = Guest | 1 = Logged in 
                        setElementData( thePlayer, "Arena", "Lobby" ) -- Set Player into Lobby 
                        setPlayerName( thePlayer, row['IngameName'] ) 
                         
                        --// Deathmatch Info 
                        setElementData( thePlayer, "DM_Points", row['Deathmatch_Points'] ) 
                        setElementData( thePlayer, "DM_Rank", row['Deathmatch_Rank'] ) 
                         
                        --// Destruction Info 
                        setElementData( thePlayer, "DD_Points", row['Destruction_Points'] ) 
                        setElementData( thePlayer, "DD_Rank", row['Destruction_Rank'] ) 
                         
                        --// Hunter Info 
                        setElementData( thePlayer, "Hunter_Points", row['Hunter_Points'] ) 
                        setElementData( thePlayer, "Hunter_Rank", row['Hunter_Rank'] ) 
                         
                        --// Shooter Info 
                        setElementData( thePlayer, "Shooter_Points", row['Shooter_Points'] ) 
                        setElementData( thePlayer, "Shooter_Rank", row['Shooter_Rank'] ) 
                         
                        triggerClientEvent( thePlayer, "player:loginNotification", getRootElement(), true ) 
                        triggerClientEvent( thePlayer, "server:note", getRootElement(), "success", "You successfully logged in") 
                        return true 
                    else 
                        triggerClientEvent( thePlayer, "server:note", getRootElement(), "error", "You entered a wrong password") 
                        triggerClientEvent( thePlayer, "player:loginNotification", getRootElement(), false ) 
                        return false 
                    end 
                end 
            else 
                triggerClientEvent( thePlayer, "server:note", getRootElement(), "error", "Account does not exists. Register at [url=http://www.wtf-mta.com]http://www.wtf-mta.com[/url]") 
                return false 
            end 
            dbFree( accounts ) 
        else 
            outputDebugString( getPlayerName( thePlayer ) .. " failed to login. - Already logged in. Serial: " .. getPlayerSerial( thePlayer ) ) 
        end 
    end 
end 
  
addEvent("player:login", true) 
addEventHandler("player:login", getRootElement(), server.login) 
  
function server.logout( thePlayer ) 
    if ( thePlayer ~= "" ) then 
        if ( getElementData( thePlayer, "Connection" ) == 1 ) then 
            local save = dbQuery( server.connection, "UPDATE wtf_accounts SET `??` = ?",  
                "IngameName", getPlayerName( thePlayer ), -- Current InGame Name 
                 
                --// Deathmatch Save 
                "Deathmatch_Points", getElementData( thePlayer, "DM_Points" ), --// Current Deathmatch Points 
                "Deathmatch_Rank", getElementData( thePlayer, "DM_Rank" ), --// Current Deathmatch Rank 
                 
                --// Destruction Save 
                "Destruction_Points", getElementData( thePlayer, "DD_Points" ), --// Current Destruction Points 
                "Destruction_Rank", getElementData( thePlayer, "DD_Rank" ), --// Current Destruction Rank 
                 
                --// Hunter Save 
                "Hunter_Kills", getElementData( thePlayer, "Hunter_Kills" ), --// Current Hunter Kills 
                "Hunter_Deaths", getElementData( thePlayer, "Hunter_Deaths" ), --// Current Hunter Deaths 
                "Hunter_Rank", getElementData( thePlayer, "Hunter_Rank" ), --// Current Hunter Rank 
                 
                --// Shooter Save 
                "Shooter_Kills", getElementData( thePlayer, "Shooter_Kills" ), --// Current Shooter Kills 
                "Shooter_Deaths", getElementData( thePlayer, "Shooter_Deaths" ), --// Current Shooter Deaths 
                "Shooter_Rank", getElementData( thePlayer, "Shooter_Rank" ) --// Current Shooter Rank 
            ) 
            dbFree( save ) 
        end 
    end 
end 
  
addEventHandler("onPlayerQuit", getRootElement(), 
    function()  
        server.logout( source ) 
    end 
) 
  
addEventHandler("onPlayerJoin", getRootElement(), 
    function() 
        setElementData( source, "Connection", false ) 
    end 
) 
  
addCommandHandler("log",  
    function( player, cmd, username, password )  
        server.login( player, username, password ) 
    end 
) 

[BroadOne]

You will need to rewrite it. You could also host the MySQL database on your server and just connect it, probably your only solution.

[AJXB]

I presume you need the database structure?

I don't believe we can help you with a script unless it's yours, or you allowed to use it, by the author.