in what event

[sconer]

Hello, i want to connect to mysql in my server. But i don't know what eventhandler i need to call to connect to the mysql. Who knows please reply to this thread. Thanks.

function mysqlconnect() 
  
    handler = mysql_connect("localhost", "root", "", "crpmta") -- Establish the connection 
    if ( not handler ) then -- The connection failed 
      outputDebugString("Unable to connect to the MySQL server") 
    else 
      mysql_close(handler) -- Close the connection 
    end 
  
end 

[Chopper]

You can use any event handler. There isnt a specific one for mysql connections.

[Castillo]

If you want it to connect to the MySQL server when the resource starts, then you can use onResourceStart.

function mysqlconnect ( ) 
    handler = mysql_connect ( "localhost", "root", "", "crpmta" ) -- Establish the connection 
    if ( not handler ) then -- The connection failed 
        outputDebugString ( "Unable to connect to the MySQL server" ) 
    else 
        mysql_close ( handler ) -- Close the connection 
    end 
end 
addEventHandler ( "onResourceStart", resourceRoot, mysqlconnect )