function lifestylerank()
{
global $lifeobjects;
global $lifeorder;
global $new;
$date = time();
// need to find the latest date of melife date produced
$db->query = "SELECT * FROM " . RSSDATA . ".melife ORDER BY date DESC LIMIT 1 ";
$resultlmedate = mysql_query($db->query) or die(mysql_error());
//echo $db->query;
if (mysql_num_rows($resultlmedate) == 1) {
$row = mysql_fetch_object($resultlmedate);
$lmedate = $row->date;
}
foreach ($lifeobjects as $lifestyleidc) {
unset($lifelistc);
unset($lifeavgc);
unset($toplifec);
$db->query = "SELECT * FROM " . RSSDATA . ".melife WHERE " . RSSDATA . ".melife.idlifestart = {$lifestyleidc} AND " . RSSDATA . ".melife.topmatch >= 1 HAVING " . RSSDATA . ".melife.date = {$lmedate} ";
$resultlifelist = mysql_query($db->query) or die(mysql_error());
//echo $db->query;
if (mysql_num_rows($resultlifelist) > 0) {
while ($row = mysql_fetch_object($resultlifelist)) {
$lifelistc[] = $row->feed_id;
}
$db->query = "SELECT * FROM " . RSSDATA . ".melife LEFT JOIN " . RSSDATA . ".feeds on " . RSSDATA . ".feeds.id = " . RSSDATA . ".melife.feed_id WHERE " . RSSDATA . ".melife.idlifestart = {$lifestyleidc} AND " . RSSDATA . ".melife.topmatch >= 1 HAVING " . RSSDATA . ".melife.date = {$lmedate} ORDER BY " . RSSDATA . ".melife.diffavg DESC ";
$resultavglife = mysql_query($db->query) or die(mysql_error());
//echo $db->query;
if (mysql_num_rows($resultavglife) > 0) {
while ($row = mysql_fetch_object($resultavglife)) {
$lifeavgc[] = $row->feed_id;
}
}
$db->query = " SELECT * FROM " . RSSDATA . ".melife LEFT JOIN " . RSSDATA . ".feeds on " . RSSDATA . ".feeds.id = " . RSSDATA . ".melife.feed_id WHERE " . RSSDATA . ".melife.idlifestart = {$lifestyleidc} AND " . RSSDATA . ".melife.topmatch >= 1 HAVING " . RSSDATA . ".melife.date = {$lmedate} ORDER BY " . RSSDATA . ".melife.topmatch DESC ";
$resulttoplife = mysql_query($db->query) or die(mysql_error());
//echo $db->query;
if (mysql_num_rows($resulttoplife) > 0) {
while ($row = mysql_fetch_object($resulttoplife)) {
$toplifec[] = $row->feed_id;
}
}
if ($lifeavgc && $toplifec) {
unset($lifeorder);
unset($lifeavgca);
unset($toplifeca);
//$daypostsca = array_flip($daypostsc);
//print_r($lifelistc);
//echo '<br /><br />';
$lifeavgca = array_flip($lifeavgc);
//print_r($lifeavgca);
//echo '<br /><br />';
$toplifeca = array_flip($toplifec);
//print_r($toplifeca);
foreach ($lifelistc as $key => $obj) {
$lifelistrankc = ($lifeavgca[$obj] + $toplifeca[$obj]) / 2;
//echo $lifelistrankc;
$lifeorder[$obj] = $lifelistrankc;
}
$lifeordersort = asort($lifeorder);
//echo '<br /><br />';
//print_r($lifeorder);
}
// find out length of peergroup list
$start = 0;
$end = 200;
//unset($new);
associativeArraySlicep($lifeorder, $start, $end);
//print_r($new);
$drpeers = '';
$rank = 0;
foreach ($new as $key => $rankid) {
$rank++;
$drpeers .= "( '{$rank}', '{$date}', '{$lifestyleidc}', '{$key}' ), ";
//echo $drposts;
}
// closes foreach loop
$drpeers = substr($drpeers, 0, strLen($drpeers) - 2);
//this will eat the last comma
if (strLen($drpeers) > 0) {
// if no posts for that day, no need for query
$db->query = "INSERT INTO " . RSSDATA . ".dailypeers (rank, date, idlifestart, peerid) VALUES ";
$db->query .= "{$drpeers}";
//echo $db->query;
$resultpeerinsert = mysql_query($db->query) or die(mysql_error());
}
}
// closes if statement any individuals qualify for this lifestyle?
}
// closes foreach lifesstyle object loop
}
<form method="post" action=" <?php
echo $_SERVER['PHP_SELF'];
?>
" >
Go prepare new peer groups for each lifestyle
<input type="Submit" name="dailypeers" value="Every 24 hrs prepare new Peer group tables"><br><br>
</form>
<br />
<br />
<?php
if (isset($_POST['dailypeers'])) {
error_reporting(5);
lifestylestartarray();
lifestylerank();
associativeArraySlicep($lifeorder, $start, $end);
}
// closes button pressed
?>
<br />
<br />
<br />
<form method="post" action=" <?php
echo $_SERVER['PHP_SELF'];
?>
" >
Find out top 5 lifestyles for each individual ie. feed
<input type="Submit" name="melifetopfive" value="Find out top 5 lifestyles all feeds"><br><br>
</form>
<br />
