A trip id should be in the url..."); exit; } ?> '; echo '='.$tripinfo["name"].'=

'; if (trim($tripinfo["blurb"])) { echo '

==Synopsis==

'; printf(nl2br(strip_tags($tripinfo["blurb"]))); } echo '

==Organizer==

'; echo 'Organized by: [http://www.ubc-voc.com/members/show_extended.php?target_id='.$tripinfo['organizerid'].' '; echo $memberinfo["name"].']

'; echo '

==Links==

'; if ( !( IS_NULL($tripinfo['mburl']) || $tripinfo['mburl']=='' ) ){ echo 'Here is the '; echo '['.$tripinfo['mburl'].' Message Board Thread]

'; } if ( !( IS_NULL($tripinfo['wikiurl']) || $tripinfo['wikiurl']=='') ) { echo "Here is the "; echo '['.$tripinfo['wikiurl'].' Wiki Page]

'; } if ( !( IS_NULL($tripinfo['otherurl']) || $tripinfo['otherurl']=='') ) { echo 'Here is the '; echo '['.$tripinfo['otherurl'].' External Link]

'; } echo '

==When==

'; echo "Start time: '''"; cv_datetimeshow($tripinfo['starttime']); echo "'''

"; if ( !( IS_NULL($tripinfo['endtime']) || $tripinfo['endtime']=='0000-00-00 00:00:00') ){ echo "End time: '''"; cv_datetimeshow($tripinfo['endtime']); echo "'''

"; } if ( !( IS_NULL($tripinfo['pretriptime']) || $tripinfo['pretriptime']=='0000-00-00 00:00:00') ){ echo '

===Pre-trip meeting===

'; echo "Pre-trip meeting time: '''"; cv_datetimeshow($tripinfo['pretriptime']); echo "'''

"; } if ( !( IS_NULL($tripinfo['pretriploc']) || $tripinfo['pretriploc']=='') ){ echo "Pre-trip meeting location: '''".$tripinfo['pretriploc']."'''"; if ( !( IS_NULL($tripinfo['pretripmap']) || $tripinfo['pretripmap']=='') ) { echo ' ['.$tripinfo['pretripmap'].' MAP]'; } echo '

'; } echo '

=Signup=

'; echo '[http://www.ubc-voc.com/tripagenda/details.php?tripid='.$tripinfo["id"].' Details and Signup Here!]'; //optional stuff if using signup tools if ($tripinfo['usesignup']) { $types = array(1 => 'interested', 2 => 'committed', 3 => 'actually going'); for ($i=1; $i <=3; $i++){ $type=$types[$i]; echo '

=='.$type.'==

'; //make a list of participants $participationkey=mysql_query("SELECT `id`,`memberid`,`driving`,`answers` FROM `participation` WHERE `tripid`='$cleantripid' AND `signupclass`='$i' ORDER BY `signuptime`") or die("Invalid trip query"); while ($participant = mysql_fetch_array($participationkey)) { echo '# '; //get particpant name, make link $getid=$participant["memberid"]; $gottenkey=mysql_query("SELECT `name` FROM members WHERE id='$getid'") or die("Invalid membership query"); $gotteninfo = mysql_fetch_array($gottenkey); echo '[http://www.ubc-voc.com/members/show_extended.php?target_id='.$participant['memberid'].' '; echo $gotteninfo["name"].']'; if ($participant['driving']){ echo "; Can drive '''".$participant['driving']."'''"; } if (trim($participant['answers'])) { echo "; Says -> ''".$participant['answers']."''"; } echo '
'; } } //for $i }//end signup tools if ($tripinfo["needtodrive"]){ echo '

===Rides===

'; for ($i=1; $i <=3; $i++){ $type=$types[$i]; echo '

===='.$type.' Drivers====

'; //make a list of drivers $participationkey=mysql_query("SELECT `id`,`memberid`,`driving`,`carname` FROM `participation` WHERE `tripid`='$cleantripid' AND `signupclass`='$i' AND `driving` > 0 ORDER BY `signuptime`") or die("Invalid participant query"); while ($participant = mysql_fetch_array($participationkey)) { //get particpant name, make link $getid=$participant["memberid"]; $gottenkey=mysql_query("SELECT `name` FROM members WHERE id='$getid'") or die("Invalid membership query"); $gotteninfo = mysql_fetch_array($gottenkey); echo "'''".$participant["carname"]."'''
"; echo '# '; echo '[http://www.ubc-voc.com/members/show_extended.php?target_id='.$participant['memberid'].' '; echo $gotteninfo["name"].']
'; for ($j=2; $j <= $participant["driving"]; $j++){ echo "# ''empty seat''
"; } echo '

'; } } //for $i }//END need to drive echo ''; ?>