require("inc/db_conn.php"); // Change color based on section // Yellow: About BrickFest PDX 2004 // Red: News & Announcements // Blue: Events & Expo // White: Register // Brown: Log In // Green: Community Projects // Gray: Links & FAQs $thisSection = "green"; ?>
One of the best parts of attending a large LEGO community event is seeing what others have created. Not content to limit viewing to three days, we feature models that will be displayed at =$titleEvent?> below. Check back often for inspiration, this page will be updated every time an attendee enters an URL in their MOC Display Card.
If you registered MOCs for a previous event, please make sure that you register your MOCs going with you to =$titleEvent?> and delete any others. Thank you.
// get the mocs // First, get a list of themes they can select $getTheme = mysql_query("select theme_id, theme from themes order by theme"); $themeList = "\n"; echo("\n"); if(isset($HTTP_POST_VARS['showtheme']) && $HTTP_POST_VARS['showtheme'] > 0) { // Constrain output $theConstrain = " and {$moctable}.theme = {$HTTP_POST_VARS['showtheme']}"; } else { $theConstrain = ""; } $getMocs = "select mocid, title, designer, description, url, theme, othertheme from {$moctable} where e_id = 1 {$theConstrain} order by title"; $getMocsQ = "select distinct {$moctable}.mocid, {$moctable}.title, {$moctable}.designer, {$moctable}.description, {$moctable}.url, {$moctable}.othertheme, themes.theme from {$moctable}, themes, registration where {$moctable}.theme = themes.theme_id and {$moctable}.u_id = registration.u_id and registration.active = 1 and registration.e_id = $master_event_id $theConstrain order by themes.theme_id"; $getMocs = mysql_query($getMocsQ); if(mysql_error() != ""){ echo("ERROR: " . mysql_error() . "\n"); } if(mysql_num_rows($getMocs) > 0) { echo("
| Title | \nDesigner | \n"); echo("Description | Theme |
|---|---|---|---|
| {$row['title']} | \n"); } else { echo("|||
| {$row['title']} | \n"); } echo("{$row['designer']} | \n"); if(strlen($row['description']) > 36) { $theREalDesc = addslashes($row['description']); $theDesc = substr($row['description'],0,36) . "... »"; } else { $theDesc = $row['description']; } echo("{$theDesc} | \n"); if($row['theme'] != "Other...") { $thisTheme = $displayThemeList[$row['theme']]; $thisTheme = $row['theme']; } else { $thisTheme = $row['othertheme']; } echo("$thisTheme | \n"); } echo("