PDA

View Full Version : mysql query not working at all


carloLT
19/05/2013, 08:56 PM
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
20/05/2013, 02:22 PM
help :/