$time_conts=31*24*60*60;$time_sel=time()-$time_conts;$select_users=mysql_query("SELECT username_hashed,acc_type,turns,civ FROM data WHERE ban='0' AND active > '$time_sel'"); while($data=mysql_fetch_array($select_users)) { $username=$data['username_hashed']; $acc_type=$data['acc_type']; $civ=$data['civ']; $turns=$data['turns']; if($acc_type=='player'){$max=200;} if($acc_type=='vip'){$max=300;} if($civ=="briton"){$add=1;}else{$add=0;} $user_building=mysql_query("SELECT slaveries FROM data WHERE username_hashed='$username'"); $slaverie=mysql_result($user_building,0,"slaveries"); $new_turns=$turns+$slaverie+$add; if($new_turns>$max){$turn_add=$max-$turns;}else{$turn_add=$slaverie+$add;} $update_data=mysql_query("UPDATE data SET turns=turns+'$turn_add' WHERE username_hashed='$username'"); }