[[MG]Dimi]

Quote:

Originally Posted by PaulDinam i did something like this , it doesn't work Код: forward AddLabels(); public AddLabels() { new result[100],Float:Pos[3],Info[128]; mysql_store_result(); while(mysql_fetch_row_format(result,"|")) { sscanf(result,"p<|>fffs[50]",Pos[0],Pos[1],Pos[2],Info); CreateDynamic3DTextLabel(Info, RColors[random(sizeof(RColors))], Pos[0], Pos[1], Pos[2], 100.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, TEXTLABELDISTANCE); } mysql_free_result(); } stock AddLabelsFromFile() { mysql_function_query(dbHandle, "SELECT * FROM `labels`", false, "AddLabels", ""); return 1; }

You didn't query anything from MySQL. You can't do it like what you did.

pawn Код:

public AddLabels()
{
    new result[100],Float:Pos[3],Info[50];
    mysql_function_query(dbHandle, "SELECT * FROM `labels`", false, "", "");
    mysql_store_result();
    while(mysql_fetch_row_format(result,"|"))
    {
         sscanf(result,"p<|>fffs[50]",Pos[0],Pos[1],Pos[2],Info);
         CreateDynamic3DTextLabel(Info, RColors[random(sizeof(RColors))], Pos[0], Pos[1], Pos[2], 100.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, TEXTLABELDISTANCE);
    }
    mysql_free_result();
}

This should work. Why would you make it like that when you can simply make all in one callback.