[Lirbo]

Your problem is here:

PHP Code:

format(query, sizeof(query), "SELECT * FROM `users` WHERE `Clanid` = '%d' ORDER BY `ClanRank` DESC LIMIT 10", PlayerInfo[playerid][pClanid]); 


PlayerInfo[***playerid***][pClanid]
replace the "playerid" to the target's id