Nu se incarca clanul

[Cordyandrey]

Salutare, fac un clan pun tag tot frumos etc si cand sa dau restart la server intru si dispare tag-ul.. cam toate datele despre clan, ma poate ajuta cnv?

poza la stats nu apare tag clan si nume la clan https://imgur.com/a/06nMM81

poza nu apar tagurile de la clan https://imgur.com/a/hJZ0kEv

poza baza de date: https://imgur.com/a/if57IKM

cod la loadclan:

	forward LoadClanInfo();
public LoadClanInfo()
{
    new strings[256];
    clanss = cache_num_rows();
    for(new d = 1; d <= clanss; d++)
    {
        new var=d;
        format(strings, sizeof(strings), "SELECT * FROM `clans` WHERE `clanID`='%d'", var);
        new Cache: xd = mysql_query(SQL, strings);
        for(new i, j = cache_get_row_count (); i != j; ++i)
        {
            ClanInfo[var][cClanID]                      = cache_get_field_content_int(i, "clanID");
            ClanInfo[var][cClanExpire]                  = cache_get_field_content_int(i, "clanExpire");
            ClanInfo[var][cClanActive]                  = cache_get_field_content_int(i, "clanActive");
            ClanInfo[var][cClanSlots]                  = cache_get_field_content_int(i, "clanSlots");
            ClanInfo[var][cClanSeif]                  = cache_get_field_content_int(i, "clanSeif");
            cache_get_field_content(i, "clanName", ClanInfo[var][cClanName], SQL, 130);
            cache_get_field_content(i, "clanColor", ClanInfo[var][cClanColor], SQL, 130);
            cache_get_field_content(i, "clanMOTD", ClanInfo[var][cClanMOTD], SQL, 130);
               cache_get_field_content(i, "clanTag", ClanInfo[var][cClanTag], SQL, 130);
            cache_get_field_content(i, "clanRankName7", ClanInfo[var][cClanRankName7], SQL, 130);
            cache_get_field_content(i, "clanRankName6", ClanInfo[var][cClanRankName6], SQL, 130);
            cache_get_field_content(i, "clanRankName5", ClanInfo[var][cClanRankName5], SQL, 130);
            cache_get_field_content(i, "clanRankName4", ClanInfo[var][cClanRankName4], SQL, 130);
            cache_get_field_content(i, "clanRankName3", ClanInfo[var][cClanRankName3], SQL, 130);
            cache_get_field_content(i, "clanRankName2", ClanInfo[var][cClanRankName2], SQL, 130);
            cache_get_field_content(i, "clanRankName1", ClanInfo[var][cClanRankName1], SQL, 130);
        }
        cache_delete(xd);
        LoadClanCar(var);
    }
    printf("[LOADING] %d clans loaded.", clanss);
}
 
	

Edited April 27, 2019 by Cordyandrey

[AlexxAdv]

forward LoadClanInfo();
public LoadClanInfo()
{
    clanss = cache_num_rows();
    for(new i = 1; i <= clanss; i++)
    {
        new x = i - 1;
        ClanInfo[i][cClanID]                    = cache_get_field_content_int(x, "clanID");
        ClanInfo[i][cClanExpire]                = cache_get_field_content_int(x, "clanExpire");
        ClanInfo[i][cClanActive]              = cache_get_field_content_int(x, "clanActive");
        ClanInfo[i][cClanSlots]                 = cache_get_field_content_int(x, "clanSlots");
        ClanInfo[i][cClanSeif]                  = cache_get_field_content_int(x, "clanSeif");
        cache_get_field_content(x, "clanName", ClanInfo[i][cClanName], SQL, 130);
        cache_get_field_content(x, "clanColor", ClanInfo[i][cClanColor], SQL, 130);
        cache_get_field_content(x, "clanMOTD", ClanInfo[i][cClanMOTD], SQL, 130);
        cache_get_field_content(x, "clanTag", ClanInfo[i][cClanTag], SQL, 130);
        cache_get_field_content(x, "clanRankName7", ClanInfo[i][cClanRankName7], SQL, 130);
        cache_get_field_content(x, "clanRankName6", ClanInfo[i][cClanRankName6], SQL, 130);
        cache_get_field_content(x, "clanRankName5", ClanInfo[i][cClanRankName5], SQL, 130);
        cache_get_field_content(x, "clanRankName4", ClanInfo[i][cClanRankName4], SQL, 130);
        cache_get_field_content(x, "clanRankName3", ClanInfo[i][cClanRankName3], SQL, 130);
        cache_get_field_content(x, "clanRankName2", ClanInfo[i][cClanRankName2], SQL, 130);
        cache_get_field_content(x, "clanRankName1", ClanInfo[i][cClanRankName1], SQL, 130);
    }
    for(new car = 1; car <= clanss; car++)
    {
        LoadClanCar(car);
    }
    printf("[LOADING] %d clans loaded.", clanss);
}

Modifica in asta, apoi te duci in baza de date phpmyadmin, selectezi tabelul clans si dai pe el golire(empty), apoi rr la server si incerci iar.

[Iulian1337]

/*

urmatoarele:

- in baza de date trebuie adaugat:
( => `ClanName` varchar(42) NOT NULL DEFAULT 'None' <= )
( => `ClanTag` varchar(42) NOT NULL DEFAULT 'None' <= )

adaugi la playerdata sau cum ai definit enum-ul

ClanTag[24], ClanName[32] ...

*/

stock PN(playerid)
{
	new name[MAX_PLAYER_NAME];
	GetPlayerName(playerid, name, MAX_PLAYER_NAME);
	return name;
}

stock LoadPlayerClan(playerid) // Incarca detaliile
{
	if(Player[playerid][ClanID] != 0)
	{
		new Query[128], cTag[24], cName[32];
		//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
		format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `Name` = '%s' LIMIT 1", PN(playerid));
		//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
		new Cache: result = mysql_query(SQL, Query);
		//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
		cache_delete(result);
		//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
		cTag = cache_get_field_content_int(0, "ClanTag", SQL);
		//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
		cName = cache_get_field_content_int(0, "ClanName", SQL);
		//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
		format(Player[playerid][ClanTag], 24, "%s", cTag);
		format(Player[playerid][ClanName], 32, "%s", cName);
	}
	return true;
}

stock LoadPlayerClanName(playerid)
{
	new String[128];
	//
	if(strfind(Player[playerid][ClanName], "None", true) == -1)
	{
		format(String, sizeof(String), "%s", Player[playerid][ClanName]);
	}
	else
	{
		String = "";
	}
	return String;
}
stock LoadPlayerClanTag(playerid)
{
	new String[128];
	//
	if(strfind(Player[playerid][ClanTag], "None", true) == -1)
	{
		format(String, sizeof(String), "%s", Player[playerid][ClanTag]);
	}
	else
	{
		String = "";
	}
	return String;
}

stock SavePlayerClan(playerid)
{
	new Query[128];
	//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
	if(Player[playerid][ClanID] != 0)
	{
        format(Query, sizeof(Query), "UPDATE `Users` SET `ClanName` = '%s', `ClanTag` = '%s' WHERE `Name` = '%s'", Player[playerid][ClanName], Player[playerid][ClanTag], PN(playerid));
   		mysql_tquery(SQL, Query, "", "");
	}
}

 

Edited April 27, 2019 by Iulian1337