include("include/config.php"); ?> // echo $_SERVER['HTTP_REFERER']; ?> function zeroPad($num,$count) { $numZeropad = $num .''; while(strlen($numZeropad) < $count) { $numZeropad = "0".$numZeropad; } $firstpart = substr($numZeropad,0,2).':'.substr($numZeropad,2,4); return $firstpart; } if($_GET[id]&&$_GET[id]!="all"){ $item = getChildByID("ta_artist", mysql_real_escape_string($_GET[id])); $items = getAllChild("ta_event","WHERE publish = 1 AND artist_arr=".mysql_real_escape_string($_GET[id])." ORDER BY date, time ASC"); //echo '
'; //print_r($items); //echo ''; $i = 0 ; if(count($items) > 0) { foreach($items as $child) { $event[$i] = $child; $events = getAllChild("ta_location","WHERE id=".$child[location].""); //print_r($events); $lineup = array(); foreach($events as $artist) { //echo 'hiiii'; $lineup = array( 'id' => $artist['id'], 'e_id' => $child['id'], 'name' => stripslashes($artist['name']), 'subname' => stripslashes($artist['sub_name']), 'subcategory_id' => $artist['subcategory_id'], 'category_id' => $artist['category_id'], 'gps' => $artist['gps'] ); } //print_r($lineup); $event[$i]['locationni'] = $lineup; //print_r($event); $i++; } } // preparing a list of dates/times when this artist is having gigs. To be put in a
'; //print_r($programitems); //echo ''; ?>
echo stripslashes($item[name])."
"; echo "".stripslashes($item[project_name]).""; $a_image = "admin/img/noimage.jpg"; if($item[profile_image]){ $a_image = "admin/img/artist/".$item[profile_image]; } ?> |
|
$items=getAllChild("ta_event as e LEFT JOIN ta_artist as a ON a.id IN (e.artist_arr)","WHERE e.category_id=1 AND e.publish=1 AND e.date > 2010-01-01 ORDER BY a.name ASC","a.*");
if($items){
?>
Music foreach($items as $item) { ?>
echo $item[name]."
}} ?>
"; echo "".$item[project_name].""; $a_image = _ROOT_DIR."/admin/img/noimage.jpg"; if($item[profile_image]){ $a_image = _ROOT_DIR."/admin/img/artist/".$item[profile_image]; } ?> $items=getAllChild("ta_event as e LEFT JOIN ta_artist as a ON a.id IN (e.artist_arr)","WHERE e.category_id=2 AND e.publish=1 AND e.date > 2010-01-01 ORDER BY a.name ASC","a.*"); if($items){ ?> Performance foreach($items as $item) { ?>
echo $item[name]."
}} ?>
"; echo "".$item[project_name].""; $a_image = _ROOT_DIR."/admin/img/noimage.jpg"; if($item[profile_image]){ $a_image = _ROOT_DIR."/admin/img/artist/".$item[profile_image]; } ?> $items=getAllChild("ta_event as e LEFT JOIN ta_artist as a ON a.id IN (e.artist_arr)","WHERE e.category_id=3 AND e.publish=1 AND e.date > 2010-01-01 ORDER BY a.name ASC","a.*"); if($items){ ?> Exhibition foreach($items as $item) { ?>
echo $item[name]."
}} ?>
"; echo "".$item[project_name].""; $a_image = _ROOT_DIR."/admin/img/noimage.jpg"; if($item[profile_image]){ $a_image = _ROOT_DIR."/admin/img/artist/".$item[profile_image]; } ?> $items=getAllChild("ta_event as e LEFT JOIN ta_artist as a ON a.id IN (e.artist_arr)","WHERE e.category_id=4 AND e.publish=1 AND e.date > 2010-01-01 ORDER BY a.name ASC","a.*"); if($items){ ?> Presentation foreach($items as $item) { ?>
echo $item[name]."
}} ?>
"; echo "".$item[project_name].""; $a_image = _ROOT_DIR."/admin/img/noimage.jpg"; if($item[profile_image]){ $a_image = _ROOT_DIR."/admin/img/artist/".$item[profile_image]; } ?> $items=getAllChild("ta_event as e LEFT JOIN ta_artist as a ON a.id IN (e.artist_arr)","WHERE e.category_id=5 AND e.publish=1 AND e.date > 2010-01-01 ORDER BY a.name ASC","a.*"); if($items){ ?> Screening foreach($items as $item) { ?>
echo $item[name]."
}} ?>
"; echo "".$item[project_name].""; $a_image = _ROOT_DIR."/admin/img/noimage.jpg"; if($item[profile_image]){ $a_image = _ROOT_DIR."/admin/img/artist/".$item[profile_image]; } ?> $items=getAllChild("ta_event as e LEFT JOIN ta_artist as a ON a.id IN (e.artist_arr)","WHERE e.category_id=6 AND e.publish=1 AND e.date > 2010-01-01 ORDER BY a.name ASC","a.*"); if($items){ ?> Workshop foreach($items as $item) { ?>
echo $item[name]."
}} ?>
"; echo "".$item[project_name].""; $a_image = _ROOT_DIR."/admin/img/noimage.jpg"; if($item[profile_image]){ $a_image = _ROOT_DIR."/admin/img/artist/".$item[profile_image]; } ?> |
|