MySQL question

[_Dark_]

I need to use different resources at connection to MySQL.

Is it possible to create a one connection at one resource and in others use it? If yes, how?

I'm using a MySQL-Module, not standard dbConnect

[Castillo]

Yes, it is, export the function and then use it with exports.

[_Dark_]

Yes, it is, export the function and then use it with exports.

I have this code in some file in my resource, called database

MySQL = nil 
function start( ) 
  
    MySQL = mysql_connect("127.0.0.1", "dark", "12345", "DarkLife") 
    if MySQL then 
        outputDebugString("[MySQL] Connection established! ") 
    end 
end 
  
addEventHandler("onResourceStart", getResourceRootElement(), start) 

How to use the MySQL handler in other resources?

[Castillo]

This topic should go in the "Scripting", but well.

MySQL = nil 
function start( ) 
    MySQL = mysql_connect("127.0.0.1", "dark", "12345", "DarkLife") 
    if MySQL then 
        outputDebugString("[MySQL] Connection established! ") 
    end 
end 
addEventHandler("onResourceStart", getResourceRootElement(), start) 
  
function getMySQLHandler() 
    return MySQL 
end 

Then in the meta.xml of THIS resource you must add:

function="getMySQLHandler" type="server" /> 

Then you can use it in other resources like this:

local handler = exports["myHandlerResourceName"]:getMySQLHandler() 

[_Dark_]

This topic should go in the "Scripting", but well.

MySQL = nil 
function start( ) 
    MySQL = mysql_connect("127.0.0.1", "dark", "12345", "DarkLife") 
    if MySQL then 
        outputDebugString("[MySQL] Connection established! ") 
    end 
end 
addEventHandler("onResourceStart", getResourceRootElement(), start) 
  
function getMySQLHandler() 
    return MySQL 
end 

Then in the meta.xml of THIS resource you must add:

function="getMySQLHandler" type="server" /> 

Then you can use it in other resources like this:

local handler = exports["myHandlerResourceName"]:getMySQLHandler() 

If you would:) I already did. No.

function start () 
  
    local handler = exports.MySQL:getMySQLHandler() 
    mysql_query(handler, "INSERT INTO `users` SET `login` = 'test', `password` = '1234'") 
end 
addEventHandler("onResourceStart", getResourceRootElement(), start) 

bad argument #1 to `mysql_query` <mysqlHandler expected, got string> 

[Castillo]

I don't know, for me works perfectly, but I'm using the new MTA DB functions, so maybe is different.

[_Dark_]

I don't know, for me works perfectly, but I'm using the new MTA DB functions, so maybe is different.

yes, but i'm using the module...

Is there any ideas?

[AeroXbird]

I don't know, for me works perfectly, but I'm using the new MTA DB functions, so maybe is different.

yes, but i'm using the module...

Is there any ideas?

The SQL resource from mta-paradise is perfect for your needs.

here's a link: https://github.com/mabako/mta-paradise

[_Dark_]

I saw this resource. Thank you.