<?
require_once ('../inc/database.php');
$q = acc("SELECT * FROM `clan_users` ORDER BY `id` ASC");
foreach($q as $u){
	$i++;
	if($u['vernost'] < 100){
		qry("UPDATE `clan_users` SET `vernost` = `vernost` + '3' WHERE `id` = ?", array($u['id']));
}
	qry("UPDATE `clan_users` SET `exp_72` = `exp_48`, `exp_48` = `exp_24`, `exp_24` = '0' WHERE `id` = ?", array($u['id']));
	
	qry("UPDATE `clan_users` SET `limit_gold` = ?, `limit_silver` = ? where `id` = ?", array($u['vernost']*10/2,$u['vernost']*500,$u['id']));
	echo $i;
}
?>