Jump to content

[Pytanie]Baza MYSQL do MTA:Paradise


Recommended Posts

Witam. Mam problem, ponieważ chcę wgrać gamemod MTA:Paradise na serwer ale mam źle skonfigurowaną Baze MYSql czy ktoś mógłby pomóc ? Ew. wstawić kod pliku ? Tak wygląda mój plik mysql w plikach serwera :

local connection = nil 
local connection = nil 
local null = nil 
local results = { } 
local max_results = 128 
  
-- connection functions 
local function connect( ) 
-- retrieve the settings 
local server = get( "server" ) or "localhost" 
local user = get( "user" ) or "nazwa bazy danych" 
local password = get( "password" ) or "tu mam hasło" 
local db = get( "database" ) or "mta" 
local port = get( "port" ) or 3306 
local socket = get( "socket" ) or nil 
  
-- connect 
connection = mysql_connect ( server, user, password, db, port, socket ) 
if connection then 
if user == "root" then 
setTimer( outputDebugString, 100, 1, "Connecting to your MySQL as 'root' is strongly discouraged.", 2 ) 
end 
return true 
else 
outputDebugString ( "Connection to MySQL Failed.", 1 ) 
return false 
end 
end 
  
local function disconnect( ) 
if connection and mysql_ping( connection ) then 
mysql_close( connection ) 
end 
end 
  
local function checkConnection( ) 
if not connection or not mysql_ping( connection ) then 
return connect( ) 
end 
return true 
end 
  
addEventHandler( "onResourceStart", resourceRoot, 
function( ) 
if not mysql_connect then 
if hasObjectPermissionTo( resource, "function.shutdown" ) then 
shutdown( "MySQL module missing." ) 
end 
cancelEvent( true, "MySQL module missing." ) 
elseif not hasObjectPermissionTo( resource, "function.mysql_connect" ) then 
if hasObjectPermissionTo( resource, "function.shutdown" ) then 
shutdown( "Insufficient ACL rights for mysql resource." ) 
end 
cancelEvent( true, "Insufficient ACL rights for mysql resource." ) 
elseif not connect( ) then 
if connection then 
outputDebugString( mysql_error( connection ), 1 ) 
end 
  
if hasObjectPermissionTo( resource, "function.shutdown" ) then 
shutdown( "MySQL failed to connect." ) 
end 
cancelEvent( true, "MySQL failed to connect." ) 
else 
null = mysql_null( ) 
end 
end 
) 
  
addEventHandler( "onResourceStop", resourceRoot, 
function( ) 
for key, value in pairs( results ) do 
mysql_free_result( value.r ) 
outputDebugString( "Query not free()'d: " .. value.q, 2 ) 
end 
  
disconnect( ) 
end 
) 
  
-- 
  
function escape_string( str ) 
if type( str ) == "string" then 
return mysql_escape_string( connection, str ) 
elseif type( str ) == "number" then 
return tostring( str ) 
end 
end 
  
local function query( str, ... ) 
checkConnection( ) 
  
if ( ... ) then 
local t = { ... } 
for k, v in ipairs( t ) do 
t[ k ] = escape_string( tostring( v ) ) or "" 
end 
str = str:format( unpack( t ) ) 
end 
  
local result = mysql_query( connection, str ) 
if result then 
for num = 1, max_results do 
if not results[ num ] then 
results[ num ] = { r = result, q = str } 
return num 
end 
end 
mysql_free_result( result ) 
return false, "Unable to allocate result in pool" 
end 
return false, mysql_error( connection ) 
end 
  
function query_free( str, ... ) 
if sourceResource == getResourceFromName( "runcode" ) then 
return false 
end 
  
checkConnection( ) 
  
if ( ... ) then 
local t = { ... } 
for k, v in ipairs( t ) do 
t[ k ] = escape_string( tostring( v ) ) or "" 
end 
str = str:format( unpack( t ) ) 
end 
  
local result = mysql_query( connection, str ) 
if result then 
mysql_free_result( result ) 
return true 
end 
return false, mysql_error( connection ) 
end 
  
function free_result( result ) 
if results[ result ] then 
mysql_free_result( results[ result ].r ) 
results[ result ] = nil 
end 
end 
  
function query_assoc( str, ... ) 
if sourceResource == getResourceFromName( "runcode" ) then 
return false 
end 
  
local t = { } 
local result, error = query( str, ... ) 
if result then 
for result, row in mysql_rows_assoc( results[ result ].r ) do 
local num = #t + 1 
t[ num ] = { } 
for key, value in pairs( row ) do 
if value ~= null then 
t[ num ][ key ] = tonumber( value ) or value 
end 
end 
end 
free_result( result ) 
return t 
end 
return false, error 
end 
  
function query_assoc_single( str, ... ) 
if sourceResource == getResourceFromName( "runcode" ) then 
return false 
end 
  
local t = { } 
local result, error = query( str, ... ) 
if result then 
local row = mysql_fetch_assoc( results[ result ].r ) 
if row then 
for key, value in pairs( row ) do 
if value ~= null then 
t[ key ] = tonumber( value ) or value 
end 
end 
free_result( result ) 
return t 
end 
free_result( result ) 
return false 
end 
return false, error 
end 
  
function query_insertid( str, ... ) 
if sourceResource == getResourceFromName( "runcode" ) then 
return false 
end 
  
local result, error = query( str, ... ) 
if result then 
local id = mysql_insert_id( connection ) 
free_result( result ) 
return id 
end 
return false, error 
end 
  
function query_affected_rows( str, ... ) 
if sourceResource == getResourceFromName( "runcode" ) then 
return false 
end 
  
local result, error = query( str, ... ) 
if result then 
local rows = mysql_affected_rows( connection ) 
free_result( result ) 
return rows 
end 
return false, error 
end 
  

Powiedzcie co robie źle, bardzo mi na tym zależy. Nie wiem czy też mam dobrze baze skonfigurowaną.

Link to post

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...