Public feed #888449

Stuff

public php v1 · immutable
Raw Edit
·published 2008-02-02 03:18 UTC
rendered paste body
function get_build($name){	$user_build=mysql_query("SELECT * FROM buildings WHERE username_hashed='$name'");		while($build=mysql_fetch_array($user_build))			{				$u_b['dwellings']=$build['dwellings'];				$u_b['slaveries']=$build['slaveries'];				$u_b['barracks']=$build['barracks'];				$u_b['blacksmiths']=$build['blacksmiths'];				$u_b['farms']=$build['farms'];			}				$user_data=mysql_query("SELECT turns,turns_spent,pop,money,food,land FROM data WHERE username_hashed='$name'");		while($data=mysql_fetch_array($user_data))			{				$u_b['pop']=$data['pop'];				$u_b['turns']=$data['turns'];				$u_b['food']=$data['food'];				$u_b['money']=$data['money'];				$u_b['land']=$data['land'];				$u_b['turns_spent']=$data['turns_spent'];			}				$user_units=mysql_query("SELECT light_infantry,medium_infantry,heavy_infantry FROM units WHERE username_hashed='$name'");		while($data=mysql_fetch_array($user_units))			{				$u_b['light']=$data['light_infantry'];				$u_b['medium']=$data['medium_infantry'];				$u_b['heavy']=$data['heavy_infantry'];			}	return $u_b;}