function inpostresults($lifestylelid, $lifestylesubid)
{
//Function Output's variables with no html markup
global $resulttotals;
global $resulttotalspage;
global $page;
global $total_pages;
global $page_number;
//global $lifestyleid;
//global $llresults;
global $streamstyle;
global $llpaging;
if ($resulttotals) {
$streamstyle = array();
$llpaging = '';
// present results in table
if (mysql_num_rows($resulttotalspage) > 0) {
while ($row = mysql_fetch_object($resulttotalspage)) {
$datepost = $row->dcdate;
$postdate = date("l jS \\of F Y h:i:s A", $datepost);
$limit = 100;
// add functions to see if image or video can be extract from post?
//images extraction
$contentb = $row->content;
$matchesimgi = '';
$matchesimgi = str_img_src($contentb);
if ($matchesimgi) {
$jpgstring = '.jpg';
$pos = stristr($matchesimgi, $jpgstring);
//echo $pos;
if ($pos === false) {
$blogimg = makeurla('display/images/blogimg.gif');
} else {
$blogimg = $matchesimgi;
}
}
// closes if
// video extraction
//videoembed ($row->link);
$cleanhtml = html_entity_decode($row->content);
$cleantags = strip_tags($cleanhtml);
$summary = $cleantags;
if (strlen($summary) > $limit) {
$summary = substr($summary, 0, strrpos(substr($summary, 0, $limit), ' ')) . '...';
}
$streamstyle[$row->drid][strblogurl] = $row->blogurl;
$streamstyle[$row->drid][strauth] = $row->author;
$streamstyle[$row->drid][strtitle] = $row->title;
$streamstyle[$row->drid][strturl] = $row->link;
$streamstyle[$row->drid][inimag] = $blogimg;
$streamstyle[$row->drid][strsumm] = $summary;
$streamstyle[$row->drid][strdate] = $postdate;
}
// closes while loop
}
for ($page = 1; $page <= $total_pages; $page++) {
if ($page == $page_number) {
// This is the current page. Don't make it a link.
$llpaging .= "{$page} ";
} else {
// This is not the current page. Make it a link.
$llpaging .= "<a href=\"" . makeurla('index.php') . "?lifestyleid=" . $lifestylelid . "&page_number=" . $page . "\">" . $page . "</a>";
}
}
} else {
$llresults .= "No posts could be presented.";
}
// print_r($streamstyle);
return $streamstyle;
}
function magazinesections()
{
global $magsect;
// display lifestyle magazine sections
// first find out which magazine section have been setup
$db->query = "SELECT * FROM " . RSSDATA . ".lifestylegroups LIMIT 6 ";
$resultlg = mysql_query($db->query) or die("Error in query: {$db->query}. " . mysql_error());
if (mysql_num_rows($resultslg) > 0) {
while ($row = mysql_fetch_object($resultlg)) {
$livegroup[] = $row->groupid;
}
}
// closesif
$db->query = "SELECT * FROM " . RSSDATA . ".lifestylegroups WHERE ";
foreach ($livegroup as $lgrp) {
$db->query .= " " . RSSDATA . ".lifestylegroups.groupid = {$lgrp} OR";
}
// closes foreach
$db->query = substr($db->query, 0, strLen($db->query) - 3);
//this will eat the last OR
$resultslg = mysql_query($db->query) or die("Error in query: {$db->query}. " . mysql_error());
if (mysql_num_rows($resultslg) > 0) {
$magsect = '';
// need to find out current magazine section selected, via getmags or via lifestylelid
if (!$_GET['mags']) {
if ($_GET['lifestyleid']) {
$lifeselmag = escapeinteger($_GET['lifestyleid']);
$db->query = "SELECT * FROM " . RSSDATA . ".grouplink WHERE " . RSSDATA . ".grouplink.idlifestyle = '{$lifeselmag}' ";
$resultcmagl = mysql_query($db->query) or die("Error in query: {$db->query}. " . mysql_error());
if (mysql_num_rows($resultcmagl) == 1) {
$row = mysql_fetch_object($resultcmagl);
$curmagset = $row->groupid;
}
} else {
$_GET['mags'] = 1;
}
} else {
$curmagset = escapeinteger($_GET['mags']);
}
while ($row = mysql_fetch_object($resultslg)) {
// if groupid matches currentid then underline
if ($curmagset == $row->groupid) {
$magsect .= "<div class=\"magalist\"><b><a href=\"" . makeurla('index.php') . "?mags={$row->groupid}\" id=\"current\" >{$row->groupname}</a></b>   </div>";
} else {
$magsect .= "<div class=\"magalist\"><b><a href=\"" . makeurla('index.php') . "?mags={$row->groupid}\">{$row->groupname}</a></b>   </div>";
}
}
//$magsect .= "<div class=\"magalist\"><a href=\"".makeurla('index.php')."?metext=3\">more</a></div>";
}
echo $magsect;
}
$abspath = $siteinfo[absolpath];
define('LLFOLDER', $basefolderurl);
if (isset($_POST['Login'])) {
if ($_POST['username'] != '' && $_POST['password'] != '') {
//Use the input username and password and check against 'users' table
$query = mysql_query('SELECT ID, Username, Active FROM users WHERE Username = "******" AND Password = "******"');
if (mysql_num_rows($query) == 1) {
$row = mysql_fetch_assoc($query);
if ($row['Active'] == 1) {
session_start();
$_SESSION['user_id'] = $row['ID'];
$_SESSION['username'] = $row['Username'];
$_SESSION['logged_in'] = TRUE;
setcookie("username", $_POST['Username'], time() + 84600 * 30);
if ($_SESSION[logged_in] == 1) {
$loginloc = makeurla('controlpanel/index.php');
header("Location: " . $loginloc . " ");
} else {
header("Location: login.php ");
}
} else {
$error = 'Your membership is not activated. Please open the email that was sent and click on the activation link';
}
} else {
$error = 'Login failed !';
}
} else {
$error = 'Please use both your username and password to access your account';
}
}
?>
