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());
}
