$script=$_SERVER['SCRIPT_FILENAME'];
$ip=$_SERVER['REMOTE_ADDR'];
if(!$db)
{
$db_mv = new database();
// Need to initialize db functions if not already
}
if (!$_SESSION['auth'])
{
session_start();
}
//////////To track member visits to the site.
#see if row exists for this member for this month
$aid=$_SESSION['session_id'];
$month=date("Ym");
$queryText = sprintf("SELECT * FROM `usage` WHERE `member_id`='%s' && `month`='%s' LIMIT 1;",
mysql_real_escape_string($aid),
mysql_real_escape_string($month));
#echo "$queryText
";
$query=mysql_query($queryText);
if(mysql_num_rows($query))
{
#if yes
# update (count++)
$result = mysql_fetch_assoc($query);
extract($result, EXTR_PREFIX_ALL, 'usage');
$count=$usage_count+1;
$queryText = sprintf("UPDATE `usage` SET `count` = '%s' WHERE `id` ='%s' LIMIT 1 ;",
mysql_real_escape_string($count),
mysql_real_escape_string($usage_id)
);
if($aid){$query=mysql_query($queryText);}
}
else
{
#if no
# insert data, set count to 1
$queryText = sprintf("INSERT INTO `usage`
(`id`, `member_id`, `month`, `count`) VALUES
(NULL, '%s', '%s', '1');",
mysql_real_escape_string($aid),
mysql_real_escape_string($month)
);
if($aid){$query=mysql_query($queryText);}
}
# $smarty_title=$smarty->get_template_vars('title');
$smarty_title='';
$queryText = sprintf("INSERT INTO `usage_details`
(`id`, `timestamp`, `mar_id`, `page_title`, `page_url`, `ip`) VALUES
(NULL, NULL, '%s', '%s', '%s', '%s');",
mysql_real_escape_string($aid),
mysql_real_escape_string($smarty_title),
mysql_real_escape_string($script),
mysql_real_escape_string($ip)
);
if($aid){$query=mysql_query($queryText);}
?>
MAR — Member Dashboard
Affiliate Member
> Profile
Scott Engel
Finance of America Mortgage