[solstice_]

PHP код:

[23:54:31] [ERROR] mysql_format: invalid connection handle '0'
[23:54:31] [ERROR] mysql_query: invalid connection handle '0'
[23:54:31] [ERROR] cache_get_row_count: no active cache
[23:54:31] [WARNING] mysql_connect: no password specified 


PHP код:

enum ClanData
{
    ClanID,
    ClanName[32],
    ClanColor[32],
    Float:ClanSpawn[32],
    Leader[32],
    Official,
    Rank1,
    Rank2,
    Rank3,
    Rank4,
    Rank5
};
new ClanInfo[MAX_CLANS][ClanData]; 


PHP код:

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


What's the problem here? Why does it say no clans were loaded from the database when there's 17 clans in the database, also check the mysql logs i posted..

[KinderClans]

Post the LoadClans(); after connecting to your mysql database.

Did the same mistake.

[solstice_]

Quote:

Originally Posted by KinderClans Post the LoadClans(); after connecting to your mysql database. Did the same mistake.

You mean i need to post it after OnGameModeInit? it's already posted below that.

EDIT: I got it now, couldn't understand you at first. Trying

[KinderClans]

No, the LoadClans(); public should go somewhere on OnGameModeInit. You wrote this public, where do you call it?

[solstice_]

Quote:

Originally Posted by KinderClans No, the LoadClans(); public should go somewhere on OnGameModeInit. You wrote this public, where do you call it?

It load the clans now, thank you!

[solstice_]

Actually there's another problem, i don't know how can i get ClanID from the database so i tried something like this:

PHP код:

CMD<AD4>:setofficial(cmdid, playerid, params[])
{
    new query[600], string[300], targetid, rows;
    new clancolor, rank1[32], rank2[32], rank3[32], rank4[32], rank5[32];
    clancolor = (clancolor << 8) | 0xFF;
    mysql_format(Database, query, sizeof(query), "SELECT `ClanID` FROM `clans`");
    new Cache:result = mysql_query(Database, query);
    cache_get_row_count(rows);
    if(cache_num_rows() != 0)
    {
        if(sscanf(params, "dxds[32]s[32]s[32]s[32]s[32]", ClanID, clancolor, targetid, rank1, rank2, rank3, rank4, rank5)) return SendClientMessage(playerid, COLOR_RED, "[USAGE]: /setofficial [clanid] [color] [leader] [rank1] [rank2] [rank3] [rank4] [rank5]");
        format(string, sizeof(string), "[SERVER]: Faction ID %d has became official by administrator %s", ClanID, GetName(playerid));
        SendMessageToAdmins(COLOR_PINK, string);
        SaveClan(ClanID);
        SetPlayerColor(targetid, clancolor);
    }
    else
    {
         SendClientMessage(playerid, COLOR_RED, "[ERROR]: That clan does not exist.");
    }
    
    cache_delete(result);
    return 1;
} 


But it's giving me warnings.. How can i get the clan id from the database and then use it on the command?

[KinderClans]

Again? I already explained you in the last topic you made.

[solstice_]

Quote:

Originally Posted by KinderClans Again? I already explained you in the last topic you made.

No - that way it didn't work.