[solstice_]

Quote:

Originally Posted by Sew_Sumi Just check where exactly it is, it's reporting rank 3, but it's in rank 2.

Yeah it's in rank 2 i've fixed it, but is there something wrong with LoadClans too?

PHP код:

forward LoadClans();
public LoadClans()
{
    new query[1500], clanid;
    if(cache_num_rows() == 0) return printf("[SERVER]: No clans were loaded from the MYSQL Database.");
    new rows, fields;
    cache_get_row_count(rows);
    cache_get_field_count(fields);
    
    mysql_format(Database, query, sizeof(query), "SELECT * FROM `clans` WHERE `ClanID`='%e' LIMIT 1;", clanid);
    new Cache:result = mysql_query(Database, query);
    
    cache_get_value_name_int(clanid, "ClanID", ClanInfo[clanid][ClanID]);
    cache_get_value_name(clanid, "ClanName", ClanInfo[clanid][ClanName]);
    cache_get_value_name(clanid, "ClanColor", ClanInfo[clanid][ClanColor]);
    cache_get_value_name_float(clanid, "ClanSpawn", ClanInfo[clanid][ClanSpawn]);\
    cache_get_value_name(clanid, "Leader", ClanInfo[clanid][Leader]);
    cache_get_value_name(clanid, "Official", ClanInfo[clanid][Official]);
    cache_get_value_name_int(clanid, "Rank1", ClanInfo[clanid][Rank1]);
    cache_get_value_name_int(clanid, "Rank2", ClanInfo[clanid][Rank2]);
    cache_get_value_name_int(clanid, "Rank3", ClanInfo[clanid][Rank3]);
    cache_get_value_name_int(clanid, "Rank4", ClanInfo[clanid][Rank4]);
    cache_get_value_name_int(clanid, "Rank5", ClanInfo[clanid][Rank5]);
    cache_delete(result);
    printf("[SERVER] %d clans were loaded from the MYSQL Database", rows);
    return 1;
} 


because when i /createclan in-game it creates and the data inserts into mysql database but whenever i start the gamemode it says no clans were loaded from the database even tho there are tons of clans in the database.