$maxallowed+50) { // give them a little 'cushion' $toolong = true; $shortlisting = substr($blurb, 0, $maxallowed) . "" . substr($blurb, $maxallowed) . " (less) ... (more)"; } if ($defaultcoupon) { // go get that info $query = "SELECT headline, body, uniqueid FROM deals WHERE uniqueid='$defaultcoupon' AND expirationdate >= CURDATE()"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); list($couponheadline, $couponbody, $dealid) = mysql_fetch_row($result); if (strlen($couponbody) > 200) $couponbody = substr($couponbody, 0, 190) . '…'; } // go get one of their 'Map It' listings randomly // select a listing $query = "SELECT listingid FROM listings WHERE businessid='$bid' LIMIT 1"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); list($listingid) = mysql_fetch_row($result); // does that listing have 'map it' info? $query = "SELECT mapitid FROM mapit WHERE businessid='$bid' AND listingid='$listingid'"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); if (mysql_num_rows($result) > 0) $mapit = true; // check for bots $human = TRUE; include('/var/www/html/botlist.php'); $useragent = $_SERVER['HTTP_USER_AGENT']; foreach ($bots as $bot) { if (stristr($useragent, $bot) !== FALSE) $human = FALSE; } if ($human) { // how many views of this review already today? $query = "SELECT num FROM linktrack WHERE bid='$bid' AND type='parentreview' AND id='$id' AND linkdate=CURDATE()"; $result = mysql_query($query); list($num) = mysql_fetch_row($result); $num++; // record the view if (mysql_num_rows($result) > 0) $query = "UPDATE linktrack SET num='$num' WHERE bid='$bid' AND type='parentreview' AND id='$id' AND linkdate=CURDATE()"; else $query = "INSERT INTO linktrack SET bid='$bid', type='parentreview', id='$id', linkdate=CURDATE(), num=1"; $result = mysql_query($query); } } if ($editorid) { // this was reviewed by one of our editors - go get their info $query = "SELECT lname, fname, photo, bloglink, bloglinktext, blogid FROM editors WHERE id='$editorid'"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); list($lname, $fname, $photo, $editorwebsitelink, $editorwebsitetitle, $blogid) = mysql_fetch_row($result); // is this editor associated with a blog? go get that blog info if ($blogid) { $query = "SELECT blogname, bloglink FROM blogs WHERE id='$blogid'"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); list($blogname, $bloglink) = mysql_fetch_row($result); } $editors = array(); // go get all our editors' info $query = "SELECT id, lname, fname FROM editors"; $result = mysql_query($query) or die("Query failed: " . mysql_error()); while (list($thiseditorid, $thislname, $thisfname) = mysql_fetch_row($result)) $editors[$thiseditorid] = "$thisfname $thislname"; } if ($error) echo "
"; elseif ($ok) echo "
"; ?>