No active cache error - Printable Version

No active cache error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: No active cache error (/showthread.php?tid=658122)

No active cache error - solstice_ - 23.08.2018

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..

Re: No active cache error - KinderClans - 23.08.2018

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

Did the same mistake.

Re: No active cache error - solstice_ - 23.08.2018

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

Re: No active cache error - KinderClans - 23.08.2018

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

Re: No active cache error - solstice_ - 23.08.2018

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!

Re: No active cache error - solstice_ - 23.08.2018

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?

Re: No active cache error - KinderClans - 23.08.2018

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

Re: No active cache error - solstice_ - 24.08.2018

Quote:

Originally Posted by KinderClans

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

No - that way it didn't work.