private function getItems($lifestylelid) { $flid = idconvert($lifestylelid); $db->query = "SELECT * FROM " . RSSDATA . ".dailyposts LEFT JOIN " . RSSDATA . ".items ON " . RSSDATA . ".items.id = " . RSSDATA . ".dailyposts.postid WHERE " . RSSDATA . ".dailyposts.lifestyleid = {$flid} ORDER BY enddate DESC LIMIT 10 "; //echo $db->query; $resultitems = mysql_query($db->query) or die("Error in query: {$db->query}. " . mysql_error()); $items = ''; while ($row = mysql_fetch_object($resultitems)) { $cleanhtml = html_entity_decode($row->content); $cleantags = strip_tags($cleanhtml); $summary = $cleantags; $limit = 100; if (strlen($summary) > $limit) { $summary = substr($summary, 0, strrpos(substr($summary, 0, $limit), ' ')) . '...'; } $items .= '<item> <title>' . $row->title . '</title> <link>' . $row->link . '</link> <description><![CDATA[' . $summary . ']]></description> </item>'; } $items .= '</channel> </rss>'; return $items; }
function topfivemanual($lifestylelida) { $db->query = "SELECT * FROM " . LIFEDATA . ".userlife WHERE " . LIFEDATA . ".userlife.userid = '{$_SESSION['user_id']}' AND " . LIFEDATA . ".userlife.humadd = '1' "; $resultmemenu = mysql_query($db->query) or die("Error in query: {$db->query}. " . mysql_error()); //echo $db->query; if (mysql_num_rows($resultmemenu) > 0) { while ($row = mysql_fetch_object($resultmemenu)) { // pick out those manually added if ($lifestylelida == idconvert($row->lifestyleid)) { $manaddm = 1; } } } //print_r($row); return $manaddm; }
function formmenuin() { global $topmenu; global $lifestylelid; global $lifestart; $db->query = "SELECT * FROM " . RSSDATA . ".userlife LEFT JOIN " . RSSDATA . ".lifestyle ON " . RSSDATA . ".lifestyle.idlifestyle = " . RSSDATA . ".userlife.lifestyleid WHERE " . RSSDATA . ".userlife.userid = '{$_SESSION['user_id']}' AND (" . RSSDATA . ".userlife.humadd = '0' OR " . RSSDATA . ".userlife.humadd = '1') "; $resultmemenu = mysql_query($db->query) or die("Error in query: {$db->query}. " . mysql_error()); //echo $db->query; if (mysql_num_rows($resultmemenu) > 0) { $topmenu['me'] = 46; while ($row = mysql_fetch_object($resultmemenu)) { $topmenu[$row->name] = $row->lifestyleid; } $_SESSION[topmenu] = $topmenu; //print_r($topmenu); } else { unset($_SESSION[topmenu]); } // closes else $lifestylelid = 46; idconvert($lifestylelid); $_SESSION[mecid] = $lifestart; }
function flickrfour($lifestylelid) { global $imagedisplay; global $lifestylelid; $lifestart = idconvert($lifestylelid); // first need to find latest date $db->query = "SELECT * FROM " . RSSDATA . ".imagesource WHERE " . RSSDATA . ".imagesource.idstart = '1' ORDER BY " . RSSDATA . ".imagesource.enddate DESC LIMIT 1"; $resultfdate = mysql_query($db->query) or die(mysql_error()); //echo $db->query; // contains list of word ids that match lifeterms entered. if (mysql_num_rows($resultfdate) == 1) { $row = mysql_fetch_object($resultfdate); $fenddate = $row->enddate; } $db->query = "SELECT * FROM " . RSSDATA . ".imagesource WHERE " . RSSDATA . ".imagesource.enddate = '{$fenddate}' AND " . RSSDATA . ".imagesource.idstart = '{$lifestart}' LIMIT 6"; $resultffour = mysql_query($db->query) or die(mysql_error()); //echo $db->query; // contains list of word ids that match lifeterms entered. $imagedisplay = ''; // present results in table if (mysql_num_rows($resultffour) > 0) { while ($row = mysql_fetch_object($resultffour)) { $imagedisplay .= "<p><a href=\"{$row->imgurl}\" title=\"{$row->title}\"><img src=\"{$row->sourceurl}\" border =\"1\" /></a></p>"; } // closes while } // closes if. // echo $imagedisplay; //needed ? }
function indivtopfivelife($feedid) { $topmenu = array(); $rank = ''; $date = time(); $standmenu = standardtopmenutwo(); $memenure = memenu($feedid); //echo '<br /><br />new feed'; //print_r($lifequalify); //echo '<br /><br />'; $topmenure = compareusermenutwo($standmenu, $memenure); //echo '<br /><br />top 5 feed'; //print_r($topmenure); $db->query = " INSERT INTO " . RSSDATA . ".toplife (feedid, rank, date, lifestyleid) VALUES "; foreach ($topmenure as $tpf) { $rank++; $convtpf = idconvert($tpf); $db->query .= "('{$feedid}', '{$rank}', '{$date}', '{$convtpf}'), "; } $db->query = substr($db->query, 0, strLen($db->query) - 2); //this will eat the last comma //echo $db->query; $resultmelifet = mysql_query($db->query) or die(mysql_error()); }