[Scenario]

Assuming your maximum amount of businesses is like 100, you'd be handling 100 queries at OnGameModeInit(). Without threaded queries, your server is going to hang.

This code retrieves ALL of the data from the "businesses" table and handles it accordingly.

pawn Код:

stock LoadBusiness()
{
    new string[64];
    mysql_query("SELECT * FROM `Business`");
    mysql_store_result();

    for(new i = 0; i < mysql_num_rows(); i++)
    {
        mysql_fetch_row_format(query,"|");
        sscanf(query,"p<|>e<ds[64]dds[64]dddffffffdds[24]d>",BizInfo[i]);
        if(BizInfo[i][Owned]==0) format(string,sizeof(string),"Verslas parduodamas\nKaina %d",BizInfo[i][Price]);
        else if(BizInfo[i][Owned]>0) format(string,sizeof(string),"%s\nIejimo kaina %d",BizInfo[i][BizName],BizInfo[i][EntrancePrice]);
        BizInfo[i][HouseLabel]=Create3DTextLabel(string,0xFFFF00FF,BizInfo[i][enX],BizInfo[i][enY],BizInfo[i][enZ],25,BizInfo[i][VirtualWorld]);
    }
    
    mysql_free_result();
    return 1;
}

P.S: You really should be using threaded queries. People writing new code that doesn't use threaded queries are just hurting themselves in the long run. Not to mention, it's pretty idiotic.