<?php
$clan_sql = mysql_query("SELECT `exp`,`lvl` FROM `clan` WHERE `id` = '".$row['clan']."' ");
$exp = mysql_fetch_array($clan_sql);
if($exp['lvl']<=1 and $exp['exp']>=50000){
$lvl=$exp['lvl']+1;
$update=mysql_query("UPDATE `clan` SET `lvl`='".$lvl."' WHERE `id`='".$row['clan']."'");
}
if($exp['lvl']==2 and $exp['exp']>=1500000){
$lvl=$exp['lvl']+1;
$update=mysql_query("UPDATE `clan` SET `lvl`='".$lvl."' WHERE `id`='".$row['clan']."'");
}
if($exp['lvl']==3 and $exp['exp']>=3000000){
$lvl=$exp['lvl']+1;
$update=mysql_query("UPDATE `clan` SET `lvl`='".$lvl."' WHERE `id`='".$row['clan']."'");
}
if($exp['lvl']==4 and $exp['exp']>=6000000){
$lvl=$exp['lvl']+1;
$update=mysql_query("UPDATE `clan` SET `lvl`='".$lvl."' WHERE `id`='".$row['clan']."'");
}
if($exp['lvl']==5 and $exp['exp']>=12000000){
$lvl=$exp['lvl']+1;
$update=mysql_query("UPDATE `clan` SET `lvl`='".$lvl."' WHERE `id`='".$row['clan']."'");
}
if($exp['lvl']==6 and $exp['exp']>=22000000){
$lvl=$exp['lvl']+1;
$update=mysql_query("UPDATE `clan` SET `lvl`='".$lvl."' WHERE `id`='".$row['clan']."'");
}
if($exp['lvl']==7 and $exp['exp']>=38000000){
$lvl=$exp['lvl']+1;
$update=mysql_query("UPDATE `clan` SET `lvl`='".$lvl."' WHERE `id`='".$row['clan']."'");
}
if($exp['lvl']==8 and $exp['exp']>=59000000){
$lvl=$exp['lvl']+1;
$update=mysql_query("UPDATE `clan` SET `lvl`='".$lvl."' WHERE `id`='".$row['clan']."'");
}
if($exp['lvl']==9 and $exp['exp']>=85000000){
$lvl=$exp['lvl']+1;
$update=mysql_query("UPDATE `clan` SET `lvl`='".$lvl."' WHERE `id`='".$row['clan']."'");
}
if($exp['lvl']==10 and $exp['exp']>=125000000){
$lvl=$exp['lvl']+1;
$update=mysql_query("UPDATE `clan` SET `lvl`='".$lvl."' WHERE `id`='".$row['clan']."'");
}
?>