function fullentry($record) { global $conn; global $imageover; # 24 hours ago. We compare timestamps to this in order to # detect recently changed entries. $yesterday = date("Y-m-d H:i:s", strtotime("yesterday")); # extract info from the record $id = $record["id"]; $title = htmlspecialchars(strtoupper($record["title"])); if ($record["eventstatus"] == "C") { $eventtime = "CANCELED"; $eventduration = 0; } else { $eventtime = hmmpm($record["eventtime"]); $eventduration = $record["eventduration"]; } $dayofmonth = substr($record["eventdate"], -2); $timedetails = $record["timedetails"]; if ($record["audience"] == "F" && $record["area"] == "P") { $badge = "ff.gif"; $badgealt = "FF"; $badgehint = "Family Friendly"; } if ($record["audience"] == "G" && $record["area"] == "P") { $badge = ""; $badgealt = ""; $badgehint = ""; } if ($record["audience"] == "A" && $record["area"] == "P") { $badge = "beer.gif"; $badgealt = "21+"; $badgehint = "Adult Only (21+)"; } if ($record["audience"] == "F" && $record["area"] == "V") { $badge = "ffwa.gif"; $badgealt = "FF,WA"; $badgehint = "Family Friendly, Meet in/around Vancouver"; } if ($record["audience"] == "G" && $record["area"] == "V") { $badge = "washington.gif"; $badgealt = "WA"; $badgehint = "Meet in/around Vancouver"; } if ($record["audience"] == "A" && $record["area"] == "V") { $badge = "beerwa.gif"; $badgealt = "21+,WA"; $badgehint = "Adult Only (21+), Meet in/around Vancouver"; } $address = htmlspecialchars($record["address"]); if ($record["locname"]) { $address = htmlspecialchars($record["locname"]) . ", {$address}"; } $locdetails = htmlspecialchars($record["locdetails"]); $descr = htmldescription($record["descr"]); $newsflash = htmlspecialchars($record["newsflash"]); $name = htmlspecialchars(ucwords($record["name"])); $email = $record["hideemail"] ? "" : htmlspecialchars($record["email"]); $email = mangleemail($email); $phone = $record["hidephone"] ? "" : htmlspecialchars($record["phone"]); $contact = $record["hidecontact"] ? "" : htmlspecialchars($record["contact"]); $weburl = $record["weburl"]; $webname = $record["webname"]; if ($webname == "" || array_key_exists('p', $_REQUEST)) { $webname = $weburl; } $webname = htmlspecialchars($webname); $forum = mysql_query("SELECT modified FROM calforum WHERE id={$id} ORDER BY modified DESC", $conn) or die(mysql_error()); $forumimg = "images/forum.gif"; $forumqty = mysql_num_rows($forum); $forumtitle = "{$forumqty} message" . ($forumqty == 1 ? "" : "s"); if ($forumqty > 0) { $msg = mysql_fetch_array($forum); $msgmod = $msg["modified"]; # Format the timestamp -- varies with SQL ver. if (strlen($msgmod) == 14) { # older MySQL uses YYYYMMDDhhmmss format $msgmod = substr($msgmod, 0, 4) . "-" . substr($msgmod, 4, 2) . "-" . substr($msgmod, 6, 2) . " " . substr($msgmod, 8, 2) . ":" . substr($msgmod, 10, 2) . ":" . substr($msgmod, 12, 2); } $forumtitle = "{$forumtitle}, newest " . substr($msgmod, 0, 10); if (strcmp($msgmod, $yesterday) > 0) { $forumimg = "images/forumflash.gif"; } } # get the image info $image = ""; if ($record["image"] && !isset($_REQUEST["i"])) { $t = pathinfo($record["image"]); $t = $t["extension"]; $image = "eventimages/{$id}.{$t}"; $imageheight = $record["imageheight"]; $imagewidth = $record["imagewidth"]; # Defend against obnoxiously wide banners or zero-height images. if ($imagewidth > 300) { $imageheight = $imageheight * 300 / $imagewidth; $imagewidth = 300; } if ($imageheight < 1) { $imagehight = 1; } } if ($eventtime == "CANCELED") { $style = "text-decoration: line-through;"; } else { $style = ""; } print "<dt style=\"{$style}\">"; if ($image && $imageover <= 0 && $imageheight > RIGHTHEIGHT / 2) { if ($imageheight > RIGHTHEIGHT) { $imagewidth = $imagewidth * RIGHTHEIGHT / $imageheight; $imageheight = RIGHTHEIGHT; } print "\n<img src=\"{$image}\" height={$imageheight} width={$imagewidth} align=\"right\" alt=\"\">\n"; } print "<a name=\"{$dayofmonth}-{$id}\" style=\"{$style}\">{$title}</a>\n"; print "<a href=\"#{$dayofmonth}-{$id}\"><img border=0 src=\"images/chain.gif\" alt=\"Link\" title=\"Link to this event\"></a>\n"; if (isset($_COOKIE['havemore']) && $_COOKIE['havemore'] == 'bikefun') { print "<a href=\"calform.php?edit=" . obscure($id) . "\"><img src=\"images/edit.gif\" alt=\"[edit]\" border=0></a>\n"; } if ($badge != "") { print "<img align=left src=\"" . IMAGES . "/{$badge}\" alt=\"{$badgealt}\" title=\"{$badgehint}\">\n"; } if ($image && ($imageover > 0 || $imageheight <= RIGHTHEIGHT / 2)) { if ($imageheight > LEFTHEIGHT) { $imagewidth = $imagewidth * LEFTHEIGHT / $imageheight; $imageheight = LEFTHEIGHT; } print "</dt><dd><img src=\"{$image}\" height={$imageheight} width={$imagewidth} align=\"left\" alt=\"\">\n"; } else { print "</dt><dd>"; } print "<div style=\"{$style}\">"; if (TRUE || $record["addressverified"] == "Y") { #print '<a href="http://tripplanner.bycycle.org/?region=portlandor&q='.urlencode($record["address"]).'" target="_BLANK">'.$address.'</a>'; print '<a href="http://maps.google.com/?bounds=45.389771,-122.829208|45.659647,-122.404175&q=' . urlencode($record["address"]) . '" target="_BLANK">' . $address . '</a>'; } else { print $address; } if (!isset($_REQUEST['p']) || $_REQUEST['p'] == '') { print " <a href=\"" . trimeturl($record["eventdate"], $record["eventtime"], $record["address"]) . "\" target=\"_BLANK\" title=\"TriMet trip planner\"><img alt=\"Take Trimet\" src=\"images/trimetrose.gif\" border=0></a>"; } if ($locdetails != "") { print " ({$locdetails})"; } print "</div>\n"; print "{$eventtime}"; if ($eventtime == "CANCELED" && $newsflash != "") { print " <font color=magenta>{$newsflash}</font>"; } if ($eventtime != "CANCELED") { if ($eventduration != 0) { print " - " . endtime($eventtime, $eventduration); } if ($timedetails != "") { print ", {$timedetails}"; } if ($record["datestype"] == "C" || $record["datestype"] == "S") { print ", {$record[dates]}"; } } print "<div style=\"{$style}\">\n"; print "<em>{$descr}</em>\n"; if ($newsflash != "" && $eventtime != "CANCELED") { print "<font color=magenta>{$newsflash}</font>"; } print '<br>'; if (strstr($name, '@')) { print mangleemail($name); } else { print $name; } if ($email != "") { print ", {$email}"; } if ($weburl != "") { print ", <a href=\"{$weburl}\">{$webname}</a>"; } if ($contact != "") { print ", " . mangleemail($contact); } if ($phone != "") { print ", {$phone}"; } if (!isset($_REQUEST['p'])) { print " <a href=\"calforum.php?id={$id}\" title=\"{$forumtitle}\"><img border=0 src=\"{$forumimg}\" alt=\"[forum]\"></a>\n"; } print "</div></dd>\n"; # if this event has no image, then the next event's # image can be left-aligned. if ($image == "" || $imageover > 0 || $imageheight <= RIGHTHEIGHT / 2) { $imageover = 0; } else { $imageover = $imageheight - RIGHTHEIGHT / 2; } }
if ($hh >= TZTWEAK) { $hh -= TZTWEAK; } $modified = substr($record["modified"], 0, 11) . $hh . substr($record["modified"], 13); } print "<div class=hr></div>\n"; if ($record["organizer"]) { print "<div class=organizer>\n<dt class=organizer>"; } else { print "<div class=msg>\n<dt>"; } print "<font size=\"-2\">" . htmlspecialchars($record["name"]) . " ({$modified}) " . htmlspecialchars($record["title"]) . "</font><br>\n"; print htmlspecialchars($record["subject"]) . "\n"; print "<a onClick=\"return confirm('Do you really want to delete this message?');\" href=\"admforum.php?edit=" . obscure($record["id"]) . "&delmsg=" . $record["msgid"] . "\">\n"; print " <img border=0 src=\"images/forumdel.gif\" alt=\"Delete\" title=\"Delete this message\">\n"; print "</a>\n"; print "</dt>\n"; if ($record["organizer"]) { print "<dd class=organizer>"; } else { print "<dd>"; } print htmldescription($record["msg"]) . "</dd>\n"; print "</div>\n"; } print "</dl></div>\n"; print "<center>Newer messages at top, older messages at bottom</center>\n"; } print "</center>\n"; include INCLUDES . "/footer.html"; #ex:set sw=4: