Modificare

[Ph0eniX]

Salutare cum as putea modifica in loc sa apara la "Clan stats" la Kills in loc sa apara killurile care le face toti din clan , sa apara doar killurile care le face respectivul player

format(CQuery, 200, "UPDATE `clans` SET `clankills` = '%d' WHERE `clanname` = '%s'", GetClanKills(GetPlayerClan(killerid)) + 1, GetPlayerClan(killerid));

stock GetClanKills(clan[])
{
	new CQuery[100], clan_kills[100];
	format(CQuery, sizeof(CQuery), "SELECT `clankills` FROM `clans` WHERE `clanname` = '%s'", clan);
 	Result = db_query( Database, CQuery );
	db_get_field_assoc( Result, "clankills", clan_kills, 30 );
	db_free_result(Result);
	return strval(clan_kills);
}

[Джо]

[pawn]ormat(CQuery, 200, "UPDATE `clans` SET `playerkills` = '%d' WHERE `clanname` = '%s'", GetPlayerKills(GetPlayerClan(killerid)) + 1, GetPlayer(killerid));[/pawn]

[pawn]stock GetClanKills(clan[])

{

    new CQuery[100], clan_kills[100];

    format(CQuery, sizeof(CQuery), "SELECT `clankills` FROM `clans` WHERE `clanname` = '%s'", clan);

Result = db_query( Database, CQuery );

    db_get_field_assoc( Result, "clankills", clan_kills, 30 );

    db_free_result(Result);

    return strval(clan_kills);

}[/pawn]