<?php

include '/var/www/stepcity/sql_con.php';



$gold = array();
$pop = array();
$crime = array();

$sql = mysql_query("SELECT  `tiles`.`user_id` , SUM(  `building_list`.`gold` ) as `gold` , SUM(  `building_list`.`population` ) as `population` , SUM(  `building_list`.`crime` ) as `crime`, COUNT(  `building_list`.`building` ) FROM  `tiles` ,  `building_list` ,  `members` WHERE  `tiles`.`tile` =  `building_list`.`building` AND  `tiles`.`user_id` =  `members`.`user_id` GROUP BY  `tiles`.`user_id` ");

while ($row = mysql_fetch_array($sql)){

	$user = $row[0];
	$gold_total = $row['gold'];
	$crime_total = $row[3];
	$pop_total = $row[2];
	
	if($crime_total > 100){
		$crime_total = 99;
	}
	if($crime_total < 0){
		$crime_total = 1;
	}

$crime_percent = ($crime_total/100);
$goldy = ($gold_total*$crime_percent);
$goldz = ($gold_total - $goldy);

	
$bank_query = mysql_query("SELECT gold, crime, population FROM groups WHERE groupname='$user'");
echo "SELECT gold, crime, population FROM groups WHERE groupname='$user';";
if($bank_query === FALSE) {
    die(mysql_error()); // TODO: better error handling
}
$bank_check = mysql_fetch_array($bank_query);

$bank_gold = $bank_check[0];
$bank_crime = $bank_check[1];
$bank_pop = $bank_check[2];

$add_gold = (floor($goldz) + $bank_gold);

$add_query = mysql_query("UPDATE groups SET gold='$add_gold', crime='$crime_total', population='$pop_total' WHERE groupname='$user'");

}

?>