MySQL Connection

[scienziato-pazzo]

Hi, I created an SQL connection in a resource, how to use it into another resource?

[Castillo]

Export a function which returns the mysql handler, like this:

function getMySQLConnection ( ) 
    return connection -- connection is defined at dbConnect. 
end 

Then export it on the meta.xml:

function="getMySQLConnection" type="server" /> 

Then you can use it on another resource like this:

local connection = exports [ "MySQLResource" ]:getMySQLConnection ( )