[Lirbo]

solved but another issue popped, check my comment
code:

PHP Code:

stock LoadClans()
{
    mysql_tquery(sql, "SELECT * FROM `clans`", "tLoadClans");
    return 1;
}
forward tLoadClans();
public tLoadClans()
{
    new rows, fields;
    cache_get_data(rows, fields);
    if(rows)
    {
        for(new i = 0; i < rows; i++)
        {
            ClanDB[i][ClanID] = cache_get_field_content_int(0, "clanid");
            cache_get_field_content(0, "clan_name", ClanDB[i][ClanName]);
            ClanDB[i][ClanLevel] = cache_get_field_content_int(0, "clan_level");
            ClanDB[i][ClanEXP] = cache_get_field_content_int(0, "clan_exp");
            ClanDB[i][ClanMaxEXP] = cache_get_field_content_int(0, "clan_max_exp");
            ClanDB[i][ClanColor] = cache_get_field_content_int(0, "clan_color");
            new str[32];
            format(str, sizeof(str), "ca %d", ClanDB[i][ClanMaxEXP]);
            printf(str);
        }
    }
} 


batch:

PHP Code:

ca 0
ca 0 


MySQL: