\n"; $query = "SELECT * FROM Ideas WHERE titleURL='" . $titleURL . "';"; $rsrc = mysql_query( $query ); if ( $row = mysql_fetch_array($rsrc) ) { $idea = $row['ideaID']; } else { // TEMPORARY: generate titleURL for all ideas that don't have it $query = "SELECT * FROM Ideas;"; $rsrc = mysql_query($query); while ( $row = mysql_fetch_array($rsrc) ) { $ideaID = $row['ideaID']; $title = $row['title']; if ( empty($row['titleURL']) ) { $newURL = str_replace ( " ", "-", strtolower($title) ); $newURL = str_replace ( '"', "", $newURL ); $newURL = str_replace ( "'", "", $newURL ); echo "Fixing titleURL: " . $newURL . "
\n"; $sql="UPDATE Ideas SET titleURL='" . $newURL . "'\n"; $sql .= "WHERE ideaID=" . $ideaID . ";"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } } } } $query = "SELECT * FROM Ideas WHERE titleURL='" . $titleURL . "';"; $rsrc = mysql_query( $query ); } if ( $row = mysql_fetch_array($rsrc) ) { $idea = $row['ideaID']; } else { die("Idea not found: " . $titleURL); } } } if ( empty($idea) ) { die("Idea not found"); } // look up the Idea and create header $query = "SELECT * FROM Ideas WHERE ideaID='" . $idea . "';"; $idea_record = mysql_query( $query ); if ( $idea_row = mysql_fetch_array($idea_record) ) { $name = $idea_row['title']; $imagepath = $idea_row['imagepath']; $short_desc = $idea_row['short_desc']; $med_desc = $idea_row['med_desc']; echo "" . $name . " — Inventor Labs\n"; echo '\n"; echo '\n"; if ( !empty($imagepath) ) { echo '\n"; } echo '\n"; echo '\n"; if ( !empty($idea_row['titleURL']) ) { $titleURL = $idea_row['titleURL']; echo '\n"; } } ?>

\n\n"; $uid = 0; if ( isset($_SESSION['uid']) ) { $uid = $_SESSION['uid']; } $obj = 0; if ( isset($_GET["obj"]) ) { $obj = htmlspecialchars($_GET["obj"]); } //$uid = $_REQUEST['uid']; //$pname = $_REQUEST['name']; $query = "SELECT COUNT(*) FROM Likers WHERE idea='" . $idea . "';"; $rsrc = mysql_query( $query ); $count = mysql_result($rsrc, 0); if ( $idea_row ) { $name = $idea_row['title']; $oname = $name; echo '
' . "\n\n"; echo 'Idea List | '; echo ' | '; echo ''; if ( $admin_site ) { echo '    | Edit Idea '; } echo "
\n"; echo "
\n"; echo '
' . "\n\n"; echo '

'; // use brand name if there is one, else the more generic "title" $brand = $idea_row['brand']; if ( $brand ) { echo $brand . "™"; } else { echo $name; } echo "

\n\n"; if ( 1 ) { // add Like button echo '
' . "\n"; $likes = $idea_row['likes']; if ( empty($likes) ) $likes = 0; // start Like box (button is all inside here, but has complicated components (three and an tag) echo ''; echo ''; echo ''; if ( $likes > 0 ) echo $likes; echo ' +Like'; echo "\n"; /* echo ''; echo ''; echo ' Love'; echo "\n"; echo ''; echo ''; echo ' Fund'; echo "\n"; echo "\n
\n"; */ echo "
\n"; echo "\n
\n"; } // image here $domain = $idea_row['domain']; if ( $domain ) { echo '
' . "\n"; echo '

' . $domain . "

\n"; echo "\n
\n"; } // image here if ( $imagepath ) { echo '
' . "\n"; echo ''; echo "\n
\n"; } if ( !empty($short_desc) ) { echo "\n" . '
' . "\n"; echo '' . $short_desc . ' '; echo "\n
\n"; } echo "\n"; if ( !empty($med_desc) ) { echo "\n" . '
' . "\n"; echo "\n" . '' . $med_desc . ' '; echo "\n
\n"; } echo "\n"; $long_desc = $idea_row['long_desc']; if ( !empty($long_desc) ) { echo "\n" . '
' . "\n"; echo "\n" . '' . $long_desc . ' '; echo "\n
\n"; } } else { echo "\n
\n"; die ( "Can't find idea " . $obj ); } echo "
\n"; //echo " \n"; echo '
' . "\n"; $sql = "SELECT * FROM Comments WHERE idea='" . $idea . "';"; $result = mysql_query($sql); $idx = 0; while ( $row = mysql_fetch_array($result) ) { $idea_id = $row['idea']; $idea_comment = $row['comment']; $ip = $row['ip']; //$nlink = '' . $row['name'] . ''; //$nhead = '

' . $groupName . '

'; $idx += 1; echo '
' . "\n"; echo '
' . "\n"; echo $idx . ". " . $idea_comment . "
\n"; // ---------------------- IP Address WIP --------------------- //echo "
" . long2ip($ip) . "
\n"; echo "\n
\n
\n\n"; } mysql_close($con); include ( "form_addcomment.html" ); // echo "
\n"; // include ( "form_test.html" ); echo "\n
\n \n"; ?>