I have a problem with two texts

[zero00]

[10:06:49] ERROR: mysql/connection.lua:46: attempt to call global 'mysql_connect' (a nil value)
[10:06:49] ERROR: weather-system/s_weather_system.lua:56: call: failed to call 'mysql:query_free' [string "?"]

[10:12:00] ERROR: mysql/connection.lua:46: attempt to call global 'mysql_connect' (a nil value)
[10:12:00] ERROR: apps/app_manager_s.lua:46: call: failed to call 'mysql:query_fetch_assoc' [string "?"]
[10:12:00] ERROR: apps/app_manager_s.lua:47: attempt to index local 'mQuery' (a boolean value)

[10:13:17] ERROR: mysql/connection.lua:46: attempt to call global 'mysql_connect' (a nil value)
[10:13:17] ERROR: help/commands/help_s.lua:6: call: failed to call 'mysql:query' [string "?"]
[10:13:30] ERROR: mysql/connection.lua:242: attempt to call global 'mysql_escape_string' (a nil value)
[10:13:30] ERROR: mysql/connection.lua:242: attempt to call global 'mysql_escape_string' (a nil value)
[10:13:30] ERROR: account/login-panel/server.lua:32: call: failed to call 'mysql:escape_string' [string "?"]
[10:13:30] ERROR: account/login-panel/server.lua:32: attempt to concatenate a boolean value

cant login
sending request to server....

[FallenGod]

You Got MySql (DataBase) Error 

 

[zero00]

what the fix ??
 

• /home
•  
• mods
•  
• deathmatch
•  
• settings.xml

<settings>
    <setting name="@mysql.database" value="removed by Staff" />
    <setting name="@mysql.username" value="removed by Staff" />
    <setting name="@mysql.password" value="removed by Staff" />
    <setting name="@mysql.hostname" value="removed by Staff" />
    <setting name="@mysql.port" value="3306" />
    <setting name="admin.ip2cUpdateTime" value="[1691168139]"></setting>
</settings>

Spoiler

_____________________________________________________________________________________________________________________________________________________

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

======================================================================================================

 

 

 

 

/home /mods /deathmatch /resources/mysql/connection.lua

-- connection settings
hostname = get( "hostname" ) 
username = get( "username" ) 
password = get( "password" ) 
database = get( "database" ) 
port = tonumber( get( "port" ) ) 

-- global things
local MySQLConnection = nil
local resultPool = { }
local queryPool = { }
local sqllog = false
local countqueries = 0

function getMySQLUsername()
    return username
end

function getMySQLPassword()
    return password
end

function getMySQLDBName()
    return db
end

function getMySQLHost()
    return host
end

function getMySQLPort()
    return port
end

-- connectToDatabase - Internal function, to spawn a DB connection
function connectToDatabase(res)
    outputDebugString("--DATABASE CREDENTIALS--")
    outputDebugString("--HOST: "..(hostname or "Error"))
    outputDebugString("--DB: "..(database or "Error"))
    outputDebugString("--USER: "..(username or "Error"))
    outputDebugString("--PW: "..(password and "***********" or "Error"))
    outputDebugString("--PORT: "..(port or "Error"))
    outputDebugString("--RESULT: ")

 

    MySQLConnection = mysql_connect(hostname, username, password, database, port)
    
    if (not MySQLConnection) then
        outputDebugString("Cannot connect to the database.")
        cancelEvent(true, "Cannot connect to the database.")
        return nil
    else
        outputDebugString("OK")
    end
    
    return nil
end
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), connectToDatabase, false)
    
-- destroyDatabaseConnection - Internal function, kill the connection if theres one.
function destroyDatabaseConnection()
    if (not MySQLConnection) then
        return nil
    end
    mysql_close(MySQLConnection)
    return nil
end
addEventHandler("onResourceStop", getResourceRootElement(getThisResource()), destroyDatabaseConnection, false)

-- do something usefull here
function logSQLError(str)
    local message = str or 'N/A'
    outputDebugString("MYSQL ERROR "..mysql_errno(MySQLConnection) .. ": " .. mysql_error(MySQLConnection))
    exports['logs']:logMessage("MYSQL ERROR [QUERY] " .. message .. " [ERROR] " .. mysql_errno(MySQLConnection) .. ": " .. mysql_error(MySQLConnection), 24)
end

function getFreeResultPoolID()
    local size = #resultPool
    if (size == 0) then
        return 1 
    end
    for index, query in ipairs(resultPool) do
        if (query == nil) then
            return index
        end
    end
    return (size + 1)
end

------------ EXPORTED FUNCTIONS ---------------

function ping()
    if not MySQLConnection or not mysql_ping(MySQLConnection) then
        -- FUU, NO MOAR CONNECTION
        destroyDatabaseConnection()
        connectToDatabase(nil)
        if (mysql_ping(MySQLConnection) == false) then
            logSQLError()
            return false
        end
        return true
    end

    return true
end

function escape_string(str)
    if (ping()) then
        return mysql_escape_string(MySQLConnection, str)
    end
    return false
end

function query(str)
    --outputDebugString("[mySQL]...")
    if sqllog then
        exports['logs']:logMessage(str, 24)
    end
    countqueries = countqueries + 1
    
    if (ping()) then
        local result = mysql_query(MySQLConnection, str)
        if (not result) then
            logSQLError(str)
            return false
        end

        local resultid = getFreeResultPoolID()
        resultPool[resultid] = result
        queryPool[resultid] = str
        return resultid
    end
    return false
end

function unbuffered_query(str)
    if sqllog then
        exports['logs']:logMessage(str, 24)
    end
    countqueries = countqueries + 1
    
    if (ping()) then
        local result = mysql_unbuffered_query(MySQLConnection, str)
        if (not result) then
            logSQLError(str)
            return false
        end

        local resultid = getFreeResultPoolID()
        resultPool[resultid] = result
        queryPool[resultid] = str
        return resultid
    end
    return false
end

function query_free(str)
    local queryresult = query(str)
    if  not (queryresult == false) then
        free_result(queryresult)
        return true
    end
    return false
end

function rows_assoc(resultid)
    if (not resultPool[resultid]) then
        return false
    end
    return mysql_rows_assoc(resultPool[resultid])
end

function fetch_assoc(resultid)
    if (not resultPool[resultid]) then
        return false
    end
    return mysql_fetch_assoc(resultPool[resultid])
end

function free_result(resultid)
    if (not resultPool[resultid]) then
        return false
    end
    mysql_free_result(resultPool[resultid])
    table.remove(resultPool, resultid)
    table.remove(queryPool, resultid)
    return nil
end

-- incase a nub wants to use it, FINE
function result(resultid, row_offset, field_offset)
    if (not resultPool[resultid]) then
        return false
    end
    return mysql_result(resultPool[resultid], row_offset, field_offset)
end

function num_rows(resultid)
    if (not resultPool[resultid]) then
        return false
    end
    return mysql_num_rows(resultPool[resultid])
    
end

function insert_id()
    return mysql_insert_id(MySQLConnection) or false
end

function query_fetch_assoc(str)
    local queryresult = query(str)
    if  not (queryresult == false) then
        local result = fetch_assoc(queryresult)
        free_result(queryresult)
        return result
    end
    return false
end

function query_rows_assoc(str)
    local queryresult = query(str)
    if  not (queryresult == false) then
        local result = rows_assoc(queryresult)
        free_result(queryresult)
        return result
    end
    return false
end

function query_insert_free(str)
    local queryresult = query(str)
    if  not (queryresult == false) then
        local result = insert_id()
        free_result(queryresult)
        return result
    end
    return false
end

function escape_string(str)
    if not (str) then return false end
    return mysql_escape_string(MySQLConnection, str)
end

function debugMode()
    if (sqllog) then
        sqllog = false
    else
        sqllog = true
    end
    return sqllog
end

function returnQueryStats()
    return countqueries
    -- maybe later more
end

function getOpenQueryStr( resultid )
    if (not queryPool[resultid]) then
        return false
    end
    
    return queryPool[resultid]
end

--Custom functions
local function createWhereClause( array, required )
    if not array then
        -- will cause an error if it's required and we wanna concat it.
        return not required and '' or nil
    end
    local strings = { }
    for i, k in pairs( array ) do
        table.insert( strings, "`" .. i .. "` = '" .. ( tonumber( k ) or escape_string( k ) ) .. "'" )
    end
    return ' WHERE ' .. table.concat(strings, ' AND ')
end

function select( tableName, clause )
    local array = {}
    local result = query( "SELECT * FROM " .. tableName .. createWhereClause( clause ) )
    if result then
        while true do
            local a = fetch_assoc( result )
            if not a then break end
            table.insert(array, a)
        end
        free_result( result )
        return array
    end
    return false
end

function select_one( tableName, clause )
    local a
    local result = query( "SELECT * FROM " .. tableName .. createWhereClause( clause ) .. ' LIMIT 1' )
    if result then
        a = fetch_assoc( result )
        free_result( result )
        return a
    end
    return false
end

function insert( tableName, array )
    local keyNames = { }
    local values = { }
    for i, k in pairs( array ) do
        table.insert( keyNames, i )
        table.insert( values, tonumber( k ) or escape_string( k ) )
    end
    
    local q = "INSERT INTO `"..tableName.."` (`" .. table.concat( keyNames, "`, `" ) .. "`) VALUES ('" .. table.concat( values, "', '" ) .. "')"
    
    return query_insert_free( q )
end

function update( tableName, array, clause )
    
    local strings = { }
    for i, k in pairs( array ) do
        table.insert( strings, "`" .. i .. "` = " .. ( k == mysql_null() and "NULL" or ( "'" .. ( tonumber( k ) or escape_string( k ) ) .. "'" ) ) )
    end
    local q = "UPDATE `" .. tableName .. "` SET " .. table.concat( strings, ", " ) .. createWhereClause( clause, true )
    
    return query_free( q )
end

function delete( tableName, clause )
    return query_free( "DELETE FROM " .. tableName .. createWhereClause( clause, true ) )
end

 

 

 

 

 

 

_____________________________________________________________________________________________________________________________________________________

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

======================================================================================================

 

 

 

/home /mods /deathmatch/ resources /mysql s_mysql.lua

--MAXIME
mtaConn = nil
forumsConn = nil

function getHost()
    return hostname
end
 
function getUser()
    return username
end
 
function getPass()
    return password
end
 
function getDatabase()
    return database
end
 
function getPort()
    return port
end

function getMtaConn()
    return mtaConn
end

function getForumsConn()
    return forumsConn
end

function connectMTA()
    return dbConnect("mysql", "dbname="..database..";hostname="..hostname..";port="..port..";unix_socket=/var/lib/mysql/mysql.sock", username, password, "autoreconnect=1")
end

function connectForums()
    return dbConnect("mysql", "dbname="..externaldatabase..";hostname="..externalhostname..";port="..externalport..";unix_socket=/var/lib/mysql/mysql.sock",externalusername, externalpassword, "autoreconnect=1")
end
 
function connectTo(h, db, p, u, pass)
    return dbConnect("mysql", "dbname="..db..";hostname="..h..";port="..p, u, pass, 'autoreconnect=1')
end

function resourceStart(resource)
    if mtaConn and isElement(mtaConn) then
        destroyElement(mtaConn)
        mtaConn = nil
    end
    mtaConn = connectMTA()
    if mtaConn then
        outputDebugString("[maxSQL] Connection to MTA database established.")
    else
        outputDebugString("[maxSQL] Connection to MTA database failed.")
    end
    
    if forumsConn and isElement(forumsConn) then
        destroyElement(forumsConn)
        forumsConn = nil
    end
    forumsConn = connectForums()
    if forumsConn then
        outputDebugString("[maxSQL] Connection to Forums database established.")
    else
        outputDebugString("[maxSQL] Connection to Forums database failed.")
    end
end
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), resourceStart)

function mtaQuery(query)
    if not query then
        outputDebugString("[maxSQL] Error - Empty query string.")
        return false, "[maxSQL] Error - Empty query string."
    elseif not mtaConn then
        outputDebugString("[maxSQL] Error - MTA database connection is broken.")
        return false, "[maxSQL] Error - MTA database connection is broken."
    else
        local myCallback = function(qh)
            local result, num_affected_rows, last_insert_id = dbPoll( qh, 0 )   -- Timeout doesn't matter here because the result will always be ready
            if result == nil then
                dbFree(qh)
                return false, "No result"
            else
                return result, num_affected_rows, last_insert_id
            end
        end
        dbQuery( myCallback, mtaConn, query )
    end
end

function forumsQuery(query)
    if not query then
        outputDebugString("[maxSQL] Error - Empty query string.")
        return false, "[maxSQL] Error - Empty query string."
    elseif not forumsConn then
        outputDebugString("[maxSQL] Error - Forums database connection is broken.")
        return false, "[maxSQL] Error - Forums database connection is broken."
    else
        local myCallback = function(qh)
            local result, num_affected_rows, last_insert_id = dbPoll( qh, 0 )   -- Timeout doesn't matter here because the result will always be ready
            if result == nil then
                dbFree(qh)
                return false, "No result"
            else
                return result, num_affected_rows, last_insert_id
            end
        end
        dbQuery( myCallback, forumsConn, query )
    end
end

 

 

 

_____________________________________________________________________________________________________________________________________________________

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

======================================================================================================

 

 

 

/home/ mods/ deathmatch /mtaserver.conf

 

<config>
    
    <!-- This parameter specifies the name the server will be visible as in the ingame server browser 
         and on Game-Monitor. It is a required parameter. -->
    <servername>rok</servername>
    
    <!-- This parameter specifies the contact email addresses for the owner(s) of this server.
         The email addresses will not be publicly available, and only used by MTA administrators
         to contact the server owner.
         Note: Missing or incorrect owner_email_address can affect visibility in the master server list.
         Values: Comma separated list of email addresses -->
    <owner_email_address>[email protected]</owner_email_address>
    
    <!-- ONLY USE THIS PARAMETER IF YOU ARE SURE OF WHAT YOU ARE DOING - it is generally only
         needed for professional servers and should be left at the default value otherwise.
         This parameter specifies the IP to use for servers that have multiple IP addresses. If set
         to auto, it will automatically detect and use the server's standard local IP address.
         Values: auto or x.x.x.x ; default value: auto -->
    <!-- SERVERIP SHOULD BE LEFT SET TO auto UNLESS YOU ARE SURE OF WHAT YOU ARE DOING -->
    <serverip>auto</serverip>
    <!-- WARNING: SETTING serverip AND THEN ASKING FOR SUPPORT CAN CAUSE DEATH OR INJURY -->
    
    <!-- This parameter specifies the UDP port on which the server will be accepting incoming player
         connections; default value: 22003. It is a required parameter. -->
    <serverport>22033</serverport>
    
    <!-- This parameter specifies the number of maximum player slots available on the server; default
         value: 32. It is a required parameter. -->
    <maxplayers>200</maxplayers>
    
    <!-- This parameter specifies the TCP port on which the server will be accepting incoming http
         connections. It can be set to the same value as <serverport>. It is a required parameter
         if <httpserver> is set to 1. -->
    <httpport>22033</httpport>
    
    <!-- If set, this parameter specifies the external URL from which clients will be able to download
         needed resources ingame. If not set (or the external URL files are incorrect), resource downloads
         are switched to the internal http server. -->
    <httpdownloadurl>http://92.222.49.96:15000/fastdl/2460/</httpdownloadurl>
    <httpautoclientfiles>1</httpautoclientfiles>
    
    <!-- This parameter limits the number of http connections each client can make. Depending on the type
         of http server that is used, a lower figure may reduce download timeouts.
         Available range: 1 to 8. -->
    <httpmaxconnectionsperclient>8</httpmaxconnectionsperclient>
    
    <!-- This parameter limits the number http connections that an IP can initiate over a short period of time.
         Available range: 1 to 100. default value: 20 -->
    <httpdosthreshold>20</httpdosthreshold>
    
    <!-- This parameter lists the IP addresses that are to be excluded from http dos threshold limits.
         e.g. 88.11.22.33,101.2.3.4 -->
    <http_dos_exclude></http_dos_exclude>
    
    <!-- By default, the server will block the use of locally customized gta3.img player skins
         This setting can be used to allow such mods. Not recommended for competitive servers.
         Values: none, peds ; default value: none -->
    <allow_gta3_img_mods>none</allow_gta3_img_mods>
    
    <!-- By default, the server will block the use of customized GTA:SA data files. -->
    <!-- To allow specific client files, add one or more of the following: -->
    <!-- <client_file name="data/carmods.dat" verify="0"/> -->
    <client_file name="anim/ped.ifp" verify="0" />
    <client_file name="data/maps" verify="0" />
    
    <!-- Comma separated list of disabled anti-cheats.
         For details see http://wiki.multitheftauto.com/wiki/Anti-cheat_guide
         e.g. To disable anti-cheat #2 and #3, use: 2,3 -->
    <disableac></disableac>
    
    <!-- Comma separated list of enabled special detections.
         A special detection is a type of anti-cheat for (usually) harmless game modifications.
         Competitive servers may wish to enable special detections, but most servers should leave this setting blank.
         For details see http://wiki.multitheftauto.com/wiki/Anti-cheat_guide
         e.g. To enable special detection #12 use: 12 -->
    <enablesd></enablesd>
    
    <!-- Minimum client version. Clients with a lower version will not be allowed to connect. After
         disconnection, clients will be given an opportunity to download an update.
         If left blank, this setting is disabled and there are no restrictions on who can connect.
         Version numbers are described here: http://wiki.multitheftauto.com/wiki/GetPlayerVersion
         and look like this: 1.1.0-9.03100.0 
         Note that this setting only determines if the client should be prompted to update. The actual
         build number they receive will be the highest available. See: http://nightly.mtasa.com/ver  -->
    <minclientversion>1.6.0-9.21890.0</minclientversion>
    
    <!-- This parameter specifies if/when the <minclientversion> setting is automatically updated.
         Keeping <minclientversion> updated can help reduce cheating.
         Note: The instant setting (2) is only recommended for competitive servers.
         Values: 0 - disabled, 1 - enabled (delayed by a few days), 2 - enabled (instant) ; default value: 1.  -->
    <minclientversion_auto_update>1</minclientversion_auto_update>
    
    <!-- Recommended client version. When connecting, if clients have a lower version, they will be given
         the option to download an update. If left blank, this setting is disabled.
         Note that this setting only determines if the client should be prompted to update. The actual
         build number they receive will be the highest available. See: http://nightly.mtasa.com/ver  -->
    <recommendedclientversion></recommendedclientversion>
    
    <!-- This parameter can be used to make the server report to Game-Monitor master servers, allowing it to
         be visible in the ingame server browser. An additional UDP port needs to be available for this to
         work (value from <serverport> + 123 , so on a default <serverport> value 22003 the right port
         will be 22126 ). Available values: 0 - disabled , 1 - enabled. Optional parameter, defaults to 0. -->
    <ase>1</ase>
    
    <!-- This parameter allows you to disable LAN broadcasting. -->
    <donotbroadcastlan>0</donotbroadcastlan>
    
    <!-- If set, players will have to provide a password specified below, before they can connect to the
         server. If left blank, server doesn't require a password from them. -->
    <password></password>
    
    <!-- This parameter reduces the server's bandwidth usage by using various optimizations.
         Values: none, medium or maximum ; default value: medium -->
    <bandwidth_reduction>medium</bandwidth_reduction>
    
    <!-- The following ???_sync_interval parameters determine the time in milliseconds between certain
         network packets being sent. More information on how each settings works is available here:
        http://wiki.multitheftauto.com/wiki/Server_mtaserver.conf -->
    <!-- Player sync interval. Default: 100 -->
    <player_sync_interval>100</player_sync_interval>
    <!-- Lightweight (player) sync interval. Used when players are far apart. Default: 1500 -->
    <lightweight_sync_interval>1500</lightweight_sync_interval>
    <!-- Camera sync interval. Default: 500 -->
    <camera_sync_interval>500</camera_sync_interval>
    <!-- Ped sync interval. Default: 400 -->
    <ped_sync_interval>400</ped_sync_interval>
    
    <!-- Ped far sync interval. Used when peds are far away. Default: 2000 -->
    <ped_far_sync_interval>2000</ped_far_sync_interval>
    <!-- Unoccupied_vehicle sync interval. Default: 400 -->
    <unoccupied_vehicle_sync_interval>400</unoccupied_vehicle_sync_interval>
    <!-- Keysync mouse rotation sync interval. For limiting key sync packets due to mouse movement. Default: 100 -->
    <keysync_mouse_sync_interval>100</keysync_mouse_sync_interval>
    <!-- Keysync analog movement sync interval. For limiting key sync packets due to joystick movement. Default: 100 -->
    <keysync_analog_sync_interval>100</keysync_analog_sync_interval>
    
    <!-- This parameter can improve the reliability of shots when using certain weapons. However, it uses more bandwidth.
         Values: 0 - disabled , 1 - enabled ; default value: 1. -->
    <bullet_sync>1</bullet_sync>
    
    <!-- This parameter sets the amount of extrapolation that clients will apply to remote vehicles. This can reduce
         some of the latency induced location disparency by predicting where the remote vehicles will probably be.
         Depending on the gamemode, an incorrect prediction may have a negative effect. Therefore this setting
         should be considered experimental.
         Available range: 0 to 100.  Default - 0 -->
    <vehext_percent>50</vehext_percent>
    
    <!-- This parameter places a limit on how much time (in milliseconds) the vehicle extrapolation will attempt to
         compensate for.
         Only relevant if <vehext_percent> is greater than zero.
         Available range: 50 to 500.  Default - 150 -->
    <vehext_ping_limit>150</vehext_ping_limit>
    
    <!-- This parameter can reduce the delay of player actions appearing on remote clients by 2 frames (approx 50ms).
         Due to the impact this may have on shot lag compensation, it should be considered experimental.
         Values: 0 - disabled , 1 - enabled ; default value: 0. -->
    <latency_reduction>0</latency_reduction>
    
    <!-- Specifies the location and file name of this servers unique private key.
         This is used to prevent private files saved on the client from being read by other servers.
         More infomation about client private files can be found here: http://wiki.multitheftauto.com/wiki/Filepath
         Keep a backup of this file in a safe place. Default value: server-id.keys-->
    <idfile>server-id.keys</idfile>
    
    <!-- Specifies the location and name of the main server log file. If left blank, server won't be saving this file. -->
    <logfile>logs/server.log</logfile>
    
    <!-- As well as the main log file, login successes and failures are logged here for easy reviewing of security issues.
         If left blank, this file is not used -->
    <authfile>logs/server_auth.log</authfile>
    
    <!-- Specifies the location and name of the file used to log database queries.
         The server command 'debugdb' sets the amount of logging. -->
    <dbfile>logs/db.log</dbfile>
    
    <!-- Specifies the location and name of the file used to log loadstring function calls.
         If left blank or not set, no logging is done. -->
    <!-- <loadstringfile>logs/loadstring.log</loadstringfile> -->
    
    <!-- This parameter specifies the location and name of the Access Control List settings file. If left
         blank, server will use acl.xml file, located in the same folder as this configuration file. -->
    <acl>acl.xml</acl>
    
    <!-- Specifies the location and name of the debugscript log file. If left blank, server won't be saving this file. -->
    <scriptdebuglogfile>logs/scripts.log</scriptdebuglogfile>
    
    <!-- Specifies the level of the debugscript log file. Available values: 0, 1, 2, 3. When not set, defaults to 0. -->
    <scriptdebugloglevel>0</scriptdebugloglevel>
    
    <!-- Specifies the level of the html debug. Available values: 0, 1, 2, 3. When not set, defaults to 0. -->
    <htmldebuglevel>0</htmldebuglevel>
    
    <!-- Specifies whether or not duplicate log lines should be filtered. Available values: 0 or 1, defaults to 1. -->
    <filter_duplicate_log_lines>1</filter_duplicate_log_lines>
    
    <!-- Specifies the frame rate limit that will be applied to connecting clients.
         Available range: 25 to 100. Default: 36. -->
    <fpslimit>65</fpslimit>
    
    <!-- This parameter specifies whether or not to enable player voice chat in-game
         Values: 0 - disabled , 1 - enabled -->
    <voice>0</voice>
    
    <!-- This parameter specifies the sample rate for voice chat.  'voice' parameter must be set to 1 for this to be effective.
         Higher settings use more bandwidth and increase the sampling quality of voice chat
         Values: 0 - Narrowband (8kHz), 1 - Wideband (16kHz), 2 - Ultrawideband (32kHz).  Default - 1 -->
    <voice_samplerate>1</voice_samplerate>
    
    <!-- This parameter specifies the voice quality for voice chat.  'voice' parameter must be set to 1 for this to be effective.
         Higher settings use more bandwidth and increase the the overall quality of voice chat
         Available range: 0 to 10.  Default - 4 -->
    <voice_quality>4</voice_quality>
    
    <!-- Specifies the voice bitrate, in bps. This optional parameter overrides the previous two settings. 
         If not set, MTA handles this automatically.  Use with care. -->
    <!-- <voice_bitrate>24600</voice_bitrate> -->
    
    <!-- This parameter specifies the path to use for a basic backup of some server files.
         Note that basic backups are only made during server startup. Default value: backups -->
    <backup_path>backups</backup_path>
    
    <!-- This parameter specifies the number of days between each basic backup.
         Backups are only made during server startup, so the actual interval may be much longer.
         Setting backup_interval to 0 will disable backups
         Available range: 0 to 30.  Default - 3 -->
    <backup_interval>3</backup_interval>
    
    <!-- This parameter specifies the maximum number of backup copies to keep.
         Setting backup_copies to 0 will disable backups
         Available range: 0 to 100.  Default - 5 -->
    <backup_copies>5</backup_copies>
    
    <!-- This parameter specifies when the internal sqlite databases should be defragmented.
        http://www.sqlite.org/lang_vacuum.html
         Values: 0 - Never, 1 - On server start only after basic backup, 2 - On server start always.  Default - 1 -->
    <compact_internal_databases>1</compact_internal_databases>
    
    <!-- This parameter specifies whether server crash dump files should be sent to MTA HQ.
         Values: 0 - Off, 1 - On. Default - 1 -->
    <crash_dump_upload>1</crash_dump_upload>
    
    <!-- This parameter lists the ACL groups that are protected by serial authorization.
         Login attempts to a protected account from a second serial are blocked until the serial is manually authorized via
         the authserial command.
         For more info see: https://mtasa.com/authserial
         Note: This is security critical feature and disabling auth_serial_groups can affect visibility in the master server list.
         Values: Comma separated list of ACL groups.  Default - Admin -->
    <auth_serial_groups>Admin</auth_serial_groups>
    
    <!-- This parameter specifies if the authorized serial login checks should also apply to the http interface.
         Protected account login attempts to the http interface will only succeed if the IP address matches one
         recently used by the account holder in-game
         For more info see: https://mtasa.com/authserialhttp
         Note: This is security critical feature and disabling auth_serial_http can affect visibility in the master server list.
         Values: 0 - Off, 1 - Enabled.  Default - 1 -->
    <auth_serial_http>1</auth_serial_http>
    
    <!-- This parameter specifies which IP addresses should always pass auth_serial_http checks.
         Values: Comma separated list of IP addresses -->
    <auth_serial_http_ip_exceptions>127.0.0.1</auth_serial_http_ip_exceptions>
    
    <!-- This parameter specifies if extra security measures are applied to resources which use dbConnect with mysql.
         The extra measures are:
           - Script files cannot be accessed with fileOpen()
           - meta.xml is read only
         *NOTE* This only protects resources which use dbConnect with mysql
         Values: 0 - Off, 1 - Enabled.  Default - 1 -->
    <database_credentials_protection>1</database_credentials_protection>
    
    <!-- Specifies the module(s) which are loaded with the server. To load several modules, add more <module>
         parameter(s). Optional parameter. -->
    <!-- <module src="sample_win32.dll"/> -->
    <!-- <module src="sample_linux.so"/> -->
    <module src="mta_mysql64.so" />
    
    <!-- Specifies resources that are loaded when the server starts and/or which are protected from being stopped.
         To specify several resources, add more <resource> parameter(s). -->
    
    <resource src="mysql" startup="1" protected="0" />
    <resource src="admin" startup="1" protected="0" />
    <resource src="data" startup="1" protected="0" />
    <resource src="pool" startup="1" protected="0" />
    <resource src="global" startup="1" protected="0" />
    <resource src="debug" startup="1" protected="0" />
    <resource src="resources" startup="1" protected="0" />
    <resource src="datetime" startup="1" protected="0" />
    <resource src="integration" startup="1" protected="0" />
    <resource src="anticheat" startup="1" protected="0" />
    <resource src="cache" startup="1" protected="0" />
    <resource src="rightclick" startup="1" protected="0" />
    <resource src="hud" startup="1" protected="0" />
    <resource src="logs" startup="1" protected="0" />
    <resource src="maps" startup="1" protected="0" />
    <resource src="bans" startup="1" protected="0" />
    <resource src="account" startup="1" protected="0" />
    <resource src="serialwhitelist" startup="1" protected="0" />
    <resource src="admin-system" startup="1" protected="0" />
    <resource src="colorblender" startup="1" protected="0" />
    <resource src="realtime-system" startup="1" protected="0" />
    <resource src="selfck-system" startup="1" protected="0" />
    <resource src="animation-system" startup="1" protected="0" />
    <resource src="camera-system" startup="1" protected="0" />
    <resource src="chat-system" startup="1" protected="0" />
    <resource src="ticket-system" startup="1" protected="0" />
    <resource src="driveby" startup="1" protected="0" />
    <resource src="elevator-system" startup="1" protected="0" />
    <resource src="duty" startup="1" protected="0" />
    <resource src="faction-system" startup="1" protected="0" />
    <resource src="factions" startup="1" protected="0" />
    <resource src="freecam" startup="1" protected="0" />
    <resource src="freecam-tv" startup="1" protected="0" />
    <resource src="fuel-system" startup="1" protected="0" />
    <resource src="gps-system" startup="1" protected="0" />
    <resource src="help" startup="1" protected="0" />
    <resource src="heligrab" startup="1" protected="0" />
    <resource src="id-system" startup="1" protected="0" />
    <resource src="interior-system" startup="1" protected="0" />
    <resource src="language-system" startup="1" protected="0" />
    <resource src="bank" startup="1" protected="0" />
    <resource src="item-system" startup="1" protected="0" />
    <resource src="artifacts" startup="1" protected="0" />
    <resource src="item-texture" startup="1" protected="0" />
    <resource src="item-world" startup="1" protected="0" />
    <resource src="item-move" startup="1" protected="0" />
    <resource src="gatekeepers-system" startup="1" protected="0" />
    <resource src="job-system" startup="1" protected="0" />
    <resource src="job-system-trucker" startup="1" protected="0" />
    <resource src="license-system" startup="1" protected="0" />
    <resource src="es-system" startup="1" protected="0" />
    <resource src="pd-system" startup="1" protected="0" />
    <resource src="fbi-system" startup="1" protected="0" />
    <resource src="mods" startup="1" protected="0" />
    <resource src="parachute" startup="1" protected="0" />
    <resource src="paynspray-system" startup="1" protected="0" />
    <resource src="phone" startup="1" protected="0" />
    <resource src="realism-system" startup="1" protected="0" />
    <resource src="report-system" startup="1" protected="0" />
    <resource src="savevehicle-system" startup="1" protected="0" />
    <resource src="saveplayer-system" startup="1" protected="0" />
    <resource src="social-system" startup="1" protected="0" />
    <resource src="scoreboard" startup="1" protected="0" />
    <resource src="shop-system" startup="1" protected="0" />
    <resource src="spike-system" startup="1" protected="0" />
    <resource src="statistics-system" startup="1" protected="0" />
    <resource src="tag-system" startup="1" protected="0" />
    <resource src="tow-system" startup="1" protected="0" />
    <resource src="tooltips-system" startup="1" protected="0" />
    <resource src="vehicle-system" startup="1" protected="0" />
    <resource src="vehicleplate" startup="1" protected="0" />
    <resource src="vehicle-mods-system" startup="1" protected="0" />
    <resource src="weaponcap" startup="1" protected="0" />
    <resource src="weather-system" startup="1" protected="0" />
    <resource src="roadblock-system" startup="1" protected="0" />
    <resource src="glue-system" startup="1" protected="0" />
    <resource src="vehicle-interiors" startup="1" protected="0" />
    <resource src="dancer-system" startup="1" protected="0" />
    <resource src="OwlGamingLogs" startup="1" protected="0" />
    <resource src="apps" startup="1" protected="0" />
    <resource src="object-system" startup="1" protected="0" />
    <resource src="donators" startup="1" protected="0" />
    <resource src="carshop-system" startup="1" protected="0" />
    <resource src="superman" startup="1" protected="0" />
    <resource src="payday" startup="1" protected="0" />
    <resource src="gate-manager" startup="1" protected="0" />
    <resource src="sittablechairs" startup="1" protected="0" />
    <resource src="usercontrolpanel" startup="1" protected="0" />
    <resource src="carradio" startup="1" protected="0" />
    <resource src="tintedwindows" startup="1" protected="0" />
    <resource src="selfck-system" statup="1" protected="0" />
    <resource src="lottery-system" startup="1" protected="0" />
    <resource src="chance-system" startup="1" protected="0" />
    <resource src="resource-keeper" startup="1" protected="0" />
    <resource src="hardwaresurvey" startup="1" />
    <resource src="sfia" startup="1" />
    <resource src="1" startup="1" />
    <resource src="admin" startup="1" />
    <resource src="72o2" startup="1" />
    <resource src="notification" startup="1" />
    <resource src="gie" startup="1" />
    <resource src="mangm" startup="1" />
    <resource src="ttt" startup="1" />
    <resource src="f1" startup="1" />
    <resource src="zbala" startup="1" />
    <resource src="map1" startup="1" />
    <resource src="map2" startup="1" />
    <resource src="map3" startup="1" />
    <resource src="moddownloader" startup="1" />
    <resource src="info" startup="1" />
    <resource src="G" startup="1" />
    <resource src="G1" startup="1" />
    <resource src="G2" startup="1" />
    <resource src="G3" startup="1" />
    <resource src="description" startup="1" />
    <resource src="anti-cmdspam" startup="1" />
    <resource src="model-system" startup="1" />
    <resource src="interior-manager" startup="1" />
    <resource src="forums" startup="0" />
    <resource src="vehicle-manager" startup="1" />
    <resource src="business-system" startup="1" />
    <resource src="official-interiors" startup="1" protected="0" />
    <resource src="advertisements" startup="1" protected="0" />
    <resource src="object-interaction" startup="1" protected="0" />
    <resource src="cmd-library" startup="0" protected="0" />
    <resource src="texture-system" startup="1" protected="0" />
    <resource src="announcement" startup="1" protected="0" />
    <resource src="bone_attach" startup="1" protected="0" />
    <resource src="briefcase" startup="1" protected="0" />
    <resource src="weapon-system" startup="1" protected="0" />
    <resource src="ramp-system" startup="1" protected="0" />
    <resource src="shader_car_paint" startup="1" protected="0" />
    <resource src="shader_water" startup="1" protected="0" />
    <resource src="toll" startup="1" protected="0" />
    <resource src="achievement" startup="1" protected="0" />
    <resource src="astro-clothing" startup="1" protected="0" />
    <resource src="LSFD" startup="1" protected="0" />
    <resource src="death" startup="1" protected="0" />
    <resource src="clubtec" startup="1" protected="0" />
    <resource src="fakevideo" startup="1" protected="0" />
    <resource src="interior_keypad" startup="1" protected="0" />
    <resource src="prison-system" startup="1" protected="0" />
    <resource src="cockpit" startup="1" protected="0" />
    <resource src="ped-system" startup="1" protected="0" />
    <resource src="sapt-system" startup="1" protected="0" />
    <resource src="mabako-clothingstore" startup="1" protected="0" />
    <resource src="health-addon" startup="1" protected="0" />
    <resource src="shader_lights" startup="1" protected="0" />
    <resource src="hdradar" startup="1" protected="0" />
    <resource src="mapm" startup="1" protected="0" />
    <resource src="masna" startup="1" protected="0" />
    <resource src="Drugs" startup="1" protected="0" />
    <resource src="chat" startup="1" protected="0" />
    <resource src="drive" startup="1" protected="0" />
    <resource src="anti-jump" startup="1" protected="0" />
    <resource src="dead" startup="1" protected="0" />
    <resource src="mic" startup="1" protected="0" />
    <resource src="mapm1" startup="1" protected="0" />
    <resource src="sea" startup="1" protected="0" />
    <resource src="hall" startup="1" protected="0" />
    <resource src="jeeb" startup="1" protected="0" />
    <resource src="computers-system" startup="1" protected="0" />
    <resource src="event-system" startup="1" protected="0" />
    <resource src="drawtag" startup="1" protected="0" />
    <resource src="drawtag_bc" startup="1" protected="0" />
    <!--
    <resource src="shader_radar" startup="1" protected="0" />
    <resource src="aimer-system" startup="0" protected="0" />
    <resource src="shader_car_paint_reflect" startup="0" protected="0" />
    <resource src="shader_roadshine3" startup="0" />
    <resource src="informationicon-system" startup="0" protected="0" />
    <resource src="event-system" startup="0" protected="0" />
    <resource src="runcode" startup="0" protected="0" />
    <resource src="help" startup="0" protected="0" />
    <resource src="sfhr-system" startup="1" />
    <resource src="ticket-system" startup="1" />
    <resource src="chopping-system" startup="1" />
    -->
    
</config>

 

you have fix plz ?

Edited August 4, 2023 by Vinyard
removed exposure of confidential credentials

[Zango]

You can't/shouldn't use the old mysql module anymore.

Use the built-in database functions: https://wiki.multitheftauto.com/wiki/DbConnect