ну кланы) как на вип таборе))
вот здесь код иеонки
$us = mysql_fetch_array(mysql_query(\"SELECT * FROM `clan_user` WHERE `id_user` = \'$user[id]\' AND `activaty` = \'0\' LIMIT 1\"
);
$clan = mysql_fetch_array(mysql_query(\"SELECT * FROM `clan` WHERE `id` = \'$us[id_clan]\' LIMIT 1\"
);
$set[\'title\'] = \'Мой клан\';
include_once \'../sys/inc/thead.php\';
title();
aut();
if (mysql_result(mysql_query(\"SELECT COUNT(id) FROM `clan_user` where `id_user` = \'$user[id]\' AND `activaty` = \'0\' LIMIT 1\"
,0)==0){
echo \"<div class=\\\"str\\\">\\n\";
echo \"Вы не состоите в клане\\n\";
echo \"</div>\\n\";
}
else
{
$count = mysql_result(mysql_query(\"SELECT COUNT(*) FROM `clan_user` WHERE `id_clan` = \'$clan[id]\' AND `activaty` = \'0\'\"
,0);
$level = ($clan[\'level\']*5)*$count;
echo \"<div class=\'infosm\'><center>\\n\";
if(is_file(H.\'files/klanico/\'.$clan[\'id\'].\'.jpg\')){
echo \' <img src=\"/files/klanico/\'.$clan[\'id\'].\'.jpg\" alt=\"\"/>\';
}
echo \"<strong>$clan[name]</strong></center></div>\\n\";
echo \"<div class=\'vip\'>$clan[about]<br />\\n\";
if(is_file(H.\'files/klan/\'.$clan[\'id\'].\'.jpg\')){
echo \'<img src=\"/files/klan/\'.$clan[\'id\'].\'.jpg\" alt=\"\"/><br/>\';
}