function create_usage_graph($from_date, $end_date)
{
//create an instance of class database here
$con = new database();
//set up query string
$query_members = "SELECT * FROM people_online WHERE people_online.member = 'y' \r\n\t\t\t\t\t AND people_online.log_date BETWEEN '{$from_date}' AND '{$end_date}'";
$query_visitors = "SELECT * FROM people_online WHERE people_online.member = 'n' \r\n\t\t\t\t\t AND people_online.log_date BETWEEN '{$from_date}' AND '{$end_date}'";
$rs_members = $con->query($query_members) or die($con->error());
$rs_visitors = $con->query($query_visitors) or die($con->error());
// COMMENT : must use OOP style ( use the $con object uve created ) not a procedural one...-mh
$data_member = mysql_fetch_assoc($rs_members);
// this is wrong...
$data_visitors = mysql_fetch_assoc($rs_visitors);
$data_member = $con->getnumrows($rs_members);
$data_visitors = $con->getnumrows($rs_visitors);
$data = $data_member + $data_visitors;
if ($data == 0) {
echo '<script>alert("Sorry, no usage results found.");window.close();</script>';
exit;
}
//echo 'm='.$data_member;
//echo 'v='.$data_visitors;
$arr_label = array("Members", "Visitors");
//$arr_data = array($data_member['MEMBERS'], $data_visitors['VISITORS']);
$arr_data = array($data_member, $data_visitors);
//start displaying the graph
$from_date = explode('-', $from_date);
$from_date = strdate($from_date[1], '', '') . ' ' . $from_date[2] . ',' . $from_date[0];
$end_date = explode('-', $end_date);
$end_date = strdate($end_date[1], '', '') . ' ' . $end_date[2] . ',' . $end_date[0];
$graph = new graph_creator(320, 600, "People Online As of {$from_date} to {$end_date}", $arr_label, $arr_data, $center_value = 0.45);
$graph->create_pie_graph();
}
include 'configuration.php';
require 'coreclass.php';
session_start();
// if user is not login..redirect him to login page
if (!isset($_SESSION['login'])) {
header('Location: login.php');
}
if (isset($_SESSION['login'])) {
$userID = $_SESSION['userID'];
$usertype = $_SESSION['usertype'];
}
$db = new database();
$year = $_POST['year'];
$month = $_POST['month'];
$month2 = strdate("{$month}", '');
$_SESSION['month'] = $month2;
$_SESSION['year'] = $year;
$sql = " select * from article_versions av ";
$sql .= " where av.stageID=6 and av.status='published'";
$sql .= " and av.published_month = '{$month}' and av.published_year = '{$year}' ";
$sql .= " order by av.dateline DESC ";
if (!($result = $db->query($sql))) {
die('Error:' . $db->error());
}
$article_versions = array();
while ($row = $db->fetcharray()) {
$article_versions[] = $row;
}
if (!($db->getnumrows() > 0)) {
$result_msg = 'No Records Found';
unset($_SESSION['penddate']);
*/
if (isset($_POST['submit'])) {
$_SESSION['submit'] = 'submit';
$puserid = $_POST['userid'];
$pactivity = $_POST['activity'];
//$pstartdate = $_POST['from_year']."-".$_POST['from_month']."-".$_POST['from_date'];;
//$penddate = $_POST['end_year']."-".$_POST['end_month']."-".$_POST['end_date'];
$day = $_POST['from_date'];
$month = $_POST['from_month'];
$year = $_POST['from_year'];
$day2 = $_POST['end_date'];
$month2 = $_POST['end_month'];
$year2 = $_POST['end_year'];
$sdmonth = strdate("{$month}", '');
$edmonth = strdate("{$month2}", '');
$_SESSION['sdmonth'] = $sdmonth;
$_SESSION['sdday'] = $day;
$_SESSION['sdyear'] = $year;
$_SESSION['edmonth'] = $edmonth;
$_SESSION['edday'] = $day2;
$_SESSION['edyear'] = $year2;
$pstartdate = mktime(0, 0, 0, $month, $day, $year);
$penddate = mktime(0, 0, 0, $month2, $day2, $year2);
/*echo 't1='.$t1;
echo 't2='.$t2;
echo 'sd='.$pstartdate;
echo 'ed='.$penddate;*/
//print_r($_POST);
$_SESSION['puserid'] = $puserid;
$_SESSION['pactivity'] = $pactivity;
die('Error:' . $db->error());
}
$my_articles = array();
while ($row = $db->fetcharray()) {
$my_articles[] = $row;
}
if (!($db->getnumrows() > 0)) {
$result_msg = 'No Records Found';
}
//Remove pre-existing session vars if exists..
unset($_SESSION['report_editor_articles']);
unset($_SESSION['year']);
unset($_SESSION['month']);
$_SESSION['report_editor_articles'] = $my_articles;
$_SESSION['year'] = $year;
$_SESSION['month'] = strdate($month, '');
for ($i = 0; $i < count($my_articles); $i++) {
if ($my_articles[$i]->articleID) {
$i % 2 == 0 ? $bgcolor = "" : ($bgcolor = "#F5F5F5");
$row_data .= '<tr class="tdhover" id= "tdata" bgcolor = "' . $bgcolor . '">';
$row_data .= '<td>';
$row_data .= $i + 1;
$row_data .= '</td>';
$row_data .= '<td class="blue">';
$title = getArticleTitle($my_articles[$i]->articleID);
$row_data .= ' ' . $title;
$row_data .= '</td>';
$row_data .= '<td class="blue2">';
$category_name = getCategory_name($my_articles[$i]->articleID);
$row_data .= $category_name;
$row_data .= '</td>';
