[ Avaa Bypassed ]

<?php
//*******************************************
// USER STATS
//*******************************************
function total_number_of_users(){
    global $db; //connection to database already established
    $sql = mysqli_query($db, "SELECT COUNT(*) FROM phplist_user_user");
    $result = mysqli_fetch_row($sql);
    return $result[0];
}

function number_of_unconfirmed_users(){
    global $db; //connection to database already established
    $sql = mysqli_query($db, "SELECT COUNT(*) FROM phplist_user_user WHERE confirmed=0");
    $result = mysqli_fetch_row($sql);
    return $result[0];
}

function number_of_blacklisted_users(){
    global $db; //connection to database already established
    $sql = mysqli_query($db, "SELECT COUNT(*) FROM phplist_user_user WHERE blacklisted=1");
    $result = mysqli_fetch_row($sql);
    return $result[0];
}

function number_of_htmlemail_users(){
    global $db; //connection to database already established
    $sql = mysqli_query($db, "SELECT COUNT(*) FROM phplist_user_user WHERE htmlemail=1");
    $result = mysqli_fetch_row($sql);
    return $result[0];
}

function print_user_registration_by_month_table(){   
    global $db; //connection to database already established

    $table = "<table id='user-registration-table-by-month' style='position: absolute; left: -9999em;'>
    <thead>
        <tr>
            <th>Date</th>
            <th>Users Registered</th>
        </tr>
    </thead>
    <tbody>
    ";

$sql = "SELECT DATE_FORMAT(entered, '%Y') as 'year',
        DATE_FORMAT(entered, '%m') as 'month',
        COUNT(id) as 'total'
        FROM phplist_user_user
        GROUP BY DATE_FORMAT(entered, '%Y%m')";

$result = mysqli_query($db, $sql);

while($row = mysqli_fetch_array($result)) {
  $table .= "\t\t\t<tr><th>".$row[0]."-".$row[1]."</th><td>".$row[2]."</td></tr>\n";
}
    $table .= "</tbody>
        </table>";
print $table;
}


function print_user_registration_by_year_table(){   
    global $db; //connection to database already established

    $table = "<table id='user-registration-table-by-year' style='position: absolute; left: -9999em;'>
    <thead>
        <tr>
            <th>Date</th>
            <th>Users Registered</th>
        </tr>
    </thead>
    <tbody>
    ";

$sql = "SELECT DATE_FORMAT(entered, '%Y') as 'year',
        COUNT(id) as 'total'
        FROM phplist_user_user
        GROUP BY DATE_FORMAT(entered, '%Y')";

$result = mysqli_query($db, $sql);

while($row = mysqli_fetch_array($result)) {
  $table .= "\t\t\t<tr><th>".$row[0]."</th><td>".$row[1]."</td></tr>\n";
}
    $table .= "</tbody>
        </table>";
print $table;
}

function print_user_registration_over_time_table(){   
    global $db; //connection to database already established

    $table = "<table id='user-registration-table-over-time' style='position: absolute; left: -9999em;'>
    <thead>
        <tr>
            <th>Date</th>
            <th>Users Registered</th>
        </tr>
    </thead>
    <tbody>
    ";

$sql = "SELECT DATE_FORMAT(entered, '%Y') as 'year',
        DATE_FORMAT(entered, '%m') as 'month',
        COUNT(id) as 'total'
        FROM phplist_user_user
        GROUP BY DATE_FORMAT(entered, '%Y%m')";
$result = mysqli_query($db, $sql);
$running_total=0;

while($row = mysqli_fetch_array($result)) {
    $running_total = $running_total + $row[2];
  $table .= "\t\t\t<tr><th>".$row[0]."-".$row[1]."</th><td>".$running_total."</td></tr>\n";
}
    $table .= "</tbody>
        </table>";
print $table;
}





//*******************************************
// COURSE STATS
//*******************************************

function number_of_courses(){
    global $db; //connection to database already established
    $sql = mysqli_query($db, "SELECT COUNT(*) FROM ces_courses");
    $result = mysqli_fetch_row($sql);
    return $result[0];
}


function number_of_unique_courses(){
    global $db; //connection to database already established
    $sql = mysqli_query($db, "SELECT COUNT(DISTINCT (course_name)) FROM ces_courses");
    $result = mysqli_fetch_row($sql);
    return $result[0];
}


function number_of_duplicate_courses(){
    return (number_of_courses()-number_of_unique_courses())/2;
}

function number_of_active_courses(){
    global $db; //connection to database already established
    $sql = mysqli_query($db, "SELECT COUNT(*) FROM ces_courses WHERE course_active=1");
    $result = mysqli_fetch_row($sql);
    return $result[0];
}

function number_of_courses_by_level($level){
    global $db; //connection to database already established
    $sql = mysqli_query($db, "SELECT COUNT(*) FROM ces_courses WHERE level_id=$level");
    $result = mysqli_fetch_row($sql);
    return $result[0];
}

?>