if($qr_data>0)
{
if (!getAdvertCount('', $_SESSION['userid'])) {
?>
Premium Membership is required to list training courses, products, resources (books, CDs, DVDs), this means you must have paid for LIVE ad listing in the worldwidehealth directory.
click here to get your directory listing > |
}
}
if (isset($_GET['advertcreated']) && ($_GET['advertcreated']=='yes')) {
?>
}
if (strlen($_GET['msg'])) {
?>
}
if($pay_weblinks=="1")
{
?>
}
?>
if($qr_data>0)
{
?>
$cron_status=$result['cron_status'];
$cron_type=$result['cron_type'];
$sql = "SELECT * FROM adverts WHERE user='".$_SESSION['userid']."' AND force_delete!=1 order by title, to_date";
$query = mysqli_query($conn,$sql);
?>
if(mysqli_num_rows($query)>0)
{
?>
}
?>
$therapist_directory = new therapist_directory();
if($row_query_upgrade['grade']=="")
{
if (!$therapist_directory->isRegisteredTherapist($_SESSION['userid'], true)) {
?>
}
}
}
?>
if(is_array($adv_id)>0)
{
?>
if (mysqli_num_rows($query)) { ?>
| TOTAL STATS FOR THIS MONTH TO DATE |
Views |
Direct Visits |
Web Clicks |
Email Enquiries |
$previewed=0;
$clicks=0;
$inquiries=0;
$direct_view=0;
$show_previewed=0;
$show_clicks=0;
$show_inquiries=0;
$show_direct_view=0;
foreach($adv_id as $single_adv)
{
$string_adv.=($string_adv=="")?$single_adv:",".$single_adv;
}
$year=date('Y');
$month=date('n');
// echo "SELECT * FROM advert_stat_clicks WHERE ad_id in (".$string_adv.")
// AND month_id IN (SELECT id FROM advert_stat_month where year='".$year."'
//and month='".$month."";
$advert_stat=mysqli_query($conn,"SELECT * FROM advert_stat_clicks WHERE ad_id in (".$string_adv.") AND month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')");
while($advert_row=mysqli_fetch_array($advert_stat, MYSQLI_ASSOC))
{
$previewed+=$advert_row['previewed'];
$clicks+=$advert_row['clicks'];
$inquiries+=$advert_row['inquiries'];
$direct_view+=$advert_row['detailviewed'];
$show_previewed+=$advert_row['previewed'];
$show_clicks+=$advert_row['clicks'];
$show_inquiries+=$advert_row['inquiries'];
$show_direct_view+=$advert_row['detailviewed'];
}
?>
Adverts |
|
|
|
|
$show_previewed=0;
$show_clicks=0;
$show_inquiries=0;
$show_direct_view=0;
// echo "SELECT group_concat(id) as grp_id FROM event WHERE user_id='".$_SESSION['userid']."'";
$all_product=mysqli_query($conn,"SELECT group_concat(id) as grp_id FROM event WHERE user_id='".$_SESSION['userid']."'");
$row_exec=mysqli_fetch_array($all_product, MYSQLI_ASSOC);
$allprod=$row_exec['grp_id'];
if($allprod=="")
{
$combine="ad_id='-1' AND ";
}
else
{
if(substr($allprod, -1)==',')
{
$allprod.="0";
$combine=" ad_id in (".$allprod.") AND ";
}
else
{
$combine=" ad_id in (".$allprod.") AND ";
}
}
//echo "SELECT sum(view) as 'view', sum(click) as 'click', sum(direct_view) as 'direct_view',sum(inquiries) as inquiries FROM event_month_clicks WHERE ".$combine." AND month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')";
// echo "SELECT sum(view) as 'view', sum(click) as 'click', sum(direct_view) as 'direct_view',sum(inquiries) as inquiries FROM event_month_clicks WHERE ".$combine." month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')";
if($have_grade==8)
{
}
else
{
$course_stat=mysqli_query($conn,"SELECT sum(view) as 'view', sum(click) as 'click', sum(direct_view) as 'direct_view',sum(inquiries) as inquiries FROM event_month_clicks WHERE ".$combine." month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')");
while($course_row=mysqli_fetch_array($course_stat, MYSQLI_ASSOC))
{
$previewed+=$course_row['view'];
$clicks+=$course_row['click'];
$inquiries+=$course_row['inquiries'];
$direct_view+=$course_row['direct_view'];
$show_previewed+=$course_row['view'];
$show_clicks+=$course_row['click'];
$show_inquiries+=$course_row['inquiries'];
$show_direct_view+=$course_row['direct_view'];
}
?>
Courses |
|
|
|
|
}
$show_previewed=0;
$show_clicks=0;
$show_inquiries=0;
$show_direct_view=0;
// echo "SELECT group_concat(id) as grp_id FROM articles WHERE user_id='".$_SESSION['userid']."' ";
$all_product=mysqli_query($conn,"SELECT group_concat(id) as grp_id FROM articles WHERE user_id='".$_SESSION['userid']."' ");
$row_exec=mysqli_fetch_array($all_product, MYSQLI_ASSOC);
$allprod=$row_exec['grp_id'];
if($allprod=="")
{
$combine="ad_id='-1' AND ";
}
else
{
if(substr($allprod, -1)==',')
{
$allprod.="0";
$combine=" ad_id in (".$allprod.") AND ";
}
else
{
$combine=" ad_id in (".$allprod.") AND ";
}
}
// echo "SELECT sum(view) as 'view', sum(click) as 'click', sum(direct_view) as 'direct_view',sum(inquiries) as nquiries FROM article_month_clicks WHERE ad_id in (".$allprod.") AND month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')";
//echo "SELECT sum(view) as 'view', sum(click) as 'click', sum(direct_view)
// as 'direct_view',sum(inquiries) as nquiries FROM article_month_clicks WHERE ".$combine."
// month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')";
$article_stat=mysqli_query($conn,"SELECT sum(view) as 'view', sum(click) as 'click', sum(direct_view)
as 'direct_view',sum(inquiries) as nquiries FROM article_month_clicks WHERE ".$combine."
month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')");
while($article_row=mysqli_fetch_array($article_stat, MYSQLI_ASSOC))
{
$previewed+=$article_row['view'];
$clicks+=$article_row['click'];
$inquiries+=$article_row['inquiries'];
$direct_view+=$article_row['direct_view'];
$show_previewed+=$article_row['view'];
$show_clicks+=$article_row['click'];
$show_inquiries+=$article_row['inquiries'];
$show_direct_view+=$article_row['direct_view'];
}
?>
Articles |
|
|
|
|
$show_previewed=0;
$show_clicks=0;
$show_inquiries=0;
$show_direct_view=0;
$concat="";
$all_product=mysqli_query($conn,"SELECT id FROM products WHERE user_id='".$_SESSION['userid']."'");
if(mysqli_num_rows($all_product)>0)
{
while($row_exec=mysqli_fetch_array($all_product, MYSQLI_ASSOC))
{
$concat.=($concat=="")?$row_exec['id']:",".$row_exec['id'];
}
$combine=" ad_id in (".$concat.") AND ";
}
else
{
$combine="ad_id='-1' AND ";
}
if($have_grade==8)
{
}
else
{
//echo $allprod;
//echo "SELECT sum(view) as 'views', sum(click) as 'click', sum(direct_view) as 'direct_view',sum(inquiries) as inquiries FROM product_month_clicks WHERE ".$combine." month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')";
$product_stat=mysqli_query($conn,"SELECT sum(view) as 'views', sum(click) as 'click', sum(direct_view) as 'direct_view',sum(inquiries) as inquiries FROM product_month_clicks WHERE ".$combine." month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')");
while($producte_row=mysqli_fetch_array($product_stat, MYSQLI_ASSOC))
{
$previewed+=$producte_row['views'];
$clicks+=$producte_row['click'];
$inquiries+=$producte_row['inquiries'];
$direct_view+=$producte_row['direct_view'];
$show_previewed+=$producte_row['views'];
$show_clicks+=$producte_row['click'];
$show_inquiries+=$producte_row['inquiries'];
$show_direct_view+=$producte_row['direct_view'];
}
?>
Products |
|
|
|
|
$show_previewed=0;
$show_clicks=0;
$show_inquiries=0;
$show_direct_view=0;
$concat="";
$all_product=mysqli_query($conn,"SELECT id FROM resources WHERE user_id='".$_SESSION['userid']."'");
if(mysqli_num_rows($all_product)>0)
{
while($row_exec=mysqli_fetch_array($all_product, MYSQLI_ASSOC))
{
$concat.=($concat=="")?$row_exec['id']:",".$row_exec['id'];
}
$combine=" ad_id in (".$concat.") AND ";
}
else
{
$combine="ad_id='-1' AND ";
}
$resource_stat=mysqli_query($conn,"SELECT sum(view) as 'view', sum(click) as 'click', sum(direct_view) as 'direct_view',sum(inquiries) as inquiries FROM resource_month_clicks WHERE ".$combine." month_id IN (SELECT id FROM advert_stat_month where year='".$year."' and month='".$month."')");
while($resource_row=mysqli_fetch_array($resource_stat, MYSQLI_ASSOC))
{
$previewed+=$resource_row['view'];
$clicks+=$resource_row['click'];
$inquiries+=$resource_row['inquiries'];
$direct_view+=$resource_row['direct_view'];
$show_previewed+=$resource_row['view'];
$show_clicks+=$resource_row['click'];
$show_inquiries+=$resource_row['inquiries'];
$show_direct_view+=$resource_row['direct_view'];
}
?>
Resources |
|
|
|
|
}
?>
Total |
|
|
|
|
} else echo 'I have no Item listed'; ?>
|
}
?>
|