[carloLT]

Hi, so i'm creating a FS. In this FS i'm trying to run some of queries. MySQL plugin - blueG R7, mysql connection works properly, when compiling FS - no errors. Also i'm using y_inline for queries. But queries don't work like they even don't exist, i'd like to know why? Also in mysql_log no errors, but he event don't showing that queries are running... Magic...

The code with a query:

Код:

forward RecieveDataFromMySQL();
public RecieveDataFromMySQL()
{
    inline onDataRecieved()
    {
        print("Isgaunama funkcijos is mysql...");
        new rows, fields;
        cache_get_data(rows, fields);
        new
            sqlid,
            function_id,
            Parameter[2][50],
            string[50]
        ;
        for(new i; i < rows; i++)
        {
            cache_get_row(i, 0, string); sqlid = strval(string);
            cache_get_row(i, 1, string); function_id = strval(string);
            cache_get_row(i, 2, string); format(Parameter[0],50,string);
            cache_get_row(i, 3, string); format(Parameter[1],50,string);
            doControlFunction(sqlid,function_id,Parameter[0],Parameter[1]);
        }
       
    }
    send_query(1, "SELECT * FROM functions", true, using inline onDataRecieved,  "" );
    return 1;
}

RecieveDataFromMySQL is a timer:

Код:

public OnFilterScriptInit()
{
    mysql_debug(true);
    LoadFSVersion();
    ConnectToMySQL();
    SetTimer("RecieveDataFromMySQL",1000,true);
    return 1;
}

Where is a problem? Maybe queries don't work on FS?

[carloLT]

help :/