'' and biennialfield.playerid = '".$player['id']."' "; $result = mysql_query( $q ); $active = false; $pavilions = array(); while ($pavilion = mysql_fetch_assoc($result) ) { $pavilions[] = $pavilion; $active = true; } $count = sizeOf($pavilions); //echo "(".$player['id'].$hash.")"; } else { header("location: new.php"); } if (isset($_POST['country']) ) { $country = makesafe($_POST['country']); } if (isset($_POST['fieldid']) ) { $fieldid = makesafe($_POST['fieldid']); } if (isset($_POST['type']) ) { $type = makesafe($_POST['type']); } if (isset($_POST['step']) ) { $step = makesafe($_POST['step']); } if (isset($_GET['step']) ) { $step = makesafe($_GET['step']); } if (isset($step) && $step == 4) { $q = "update biennialfield set playerid = ".$player['id'].", since = NOW(), last = NOW(), views = 0, type = '".$type."', countryid = ".$country. " where id = ".$fieldid; // echo $q; mysql_query( $q ); $q = "SELECT * from country where id = ".$country; $result = mysql_query( $q ); $pavilion = mysql_fetch_assoc($result); $q = "INSERT into biennialevents (playerid,message,moment,fieldid,action) VALUES (0,'Pavilion ".$pavilion['printable_name']." added ', NOW(), ".$fieldid.",'ins' )"; // echo $q; mysql_query( $q ); $step = 5; } else { // nog toevoegen: niet de reeds in gebruik zijnde pavs $q = "SELECT * from country where active ='y' "; $result = mysql_query( $q ); $rows = array(); while ($row = mysql_fetch_assoc($result) ) { $available[] = $row; $size = count($available); } $q = "SELECT * from biennialfield where type = '' order by y, x"; $fieldsresults = mysql_query( $q ); } ?> Battling Pavilions
GOOD LUCK!

MONITOR YOUR PAVILIONS >

ADD A VIRTUAL PAVILION >
INSIDE THE GIARDINI OF
VENICE BIENNALE
SELECT LOCATION:

Choose country for this pavilion:



(Randomly pre-selected: )

Pavilion type:

YOUR SCORE: REFRESH SCORE
ADD ANOTHER PAVILION

Your pavilion(s) inside the Giardini:
Placed: