/**
* stats_browser_stats() - Get browser stats
*/
function stats_browser_stats()
{
/*
Browser
*/
$sql = "SELECT * FROM stats_agg_pages_by_browser";
$result = db_query($sql);
$rows = db_numrows($result);
if (!$result || $rows < 1) {
echo '<h1>Stats Problem</h1>';
echo db_error();
} else {
GraphResult($result, 'Page Views By Browser');
}
echo '<p> </p>';
/*
Platform
*/
$sql = "SELECT * FROM stats_agg_pages_by_platform";
$result = db_query($sql);
$rows = db_numrows($result);
if (!$result || $rows < 1) {
echo '<h1>Stats Problem</h1>';
echo db_error();
} else {
GraphResult($result, 'Page Views By Platform');
}
echo '<p> </p>';
/*
Browser/ver
*/
$sql = "SELECT * FROM stats_agg_pages_by_plat_brow_ver";
$result = db_query($sql);
$rows = db_numrows($result);
if (!$result || $rows < 1) {
echo '<h1>Stats Problem</h1>';
echo db_error();
} else {
ShowResultSet($result, 'Page Views By Platform/Browser Version');
}
echo '<p> </p>';
}
function stats_browser_stats()
{
global $Language;
/*
Browser
*/
$sql = "SELECT * FROM stats_agg_pages_by_browser";
$result = db_query($sql);
$rows = db_numrows($result);
if (!$result || $rows < 1) {
echo '<H1>' . $Language->getText('include_stats_function', 'stats_problem') . '</H1>';
echo db_error();
} else {
GraphResult($result, $Language->getText('include_stats_function', 'view_by_browser'));
}
echo '<P>';
/*
Platform
*/
$sql = "SELECT * FROM stats_agg_pages_by_platform";
$result = db_query($sql);
$rows = db_numrows($result);
if (!$result || $rows < 1) {
echo '<H1>' . $Language->getText('include_stats_function', 'stats_problem') . '</H1>';
echo db_error();
} else {
GraphResult($result, $Language->getText('include_stats_function', 'view_by_platform'));
}
echo '<P>';
/*
Browser/ver
*/
$sql = "SELECT * FROM stats_agg_pages_by_plat_brow_ver";
$result = db_query($sql);
$rows = db_numrows($result);
if (!$result || $rows < 1) {
echo '<H1>' . $Language->getText('include_stats_function', 'stats_problem') . '</H1>';
echo db_error();
} else {
ShowResultSet($result, $Language->getText('include_stats_function', 'view_by_platform_browser'));
}
echo '<P>';
}
$sql = "SELECT avg(response::int) AS avg FROM survey_responses WHERE survey_id='{$survey_id}' AND question_id='{$quest_array[$i]}' AND group_id='{$group_id}' AND response IN ('1','2','3','4','5')";
}
$result2 = db_query($sql);
if (!$result2 || db_numrows($result2) < 1) {
echo _('error');
echo db_error();
} else {
echo "<strong>" . number_format(db_result($result2, 0, 'avg'), 2) . "</strong>" . _('Average');
}
$sql = "SELECT response,count(*) AS count FROM survey_responses WHERE survey_id='{$survey_id}' AND question_id='{$quest_array[$i]}' AND group_id='{$group_id}' AND response IN ('1','2','3','4','5') GROUP BY response";
$result2 = db_query($sql);
if (!$result2 || db_numrows($result2) < 1) {
echo _('error');
echo db_error();
} else {
GraphResult($result2, stripslashes(db_result($result, 0, "question")));
}
}
// end if (responses to survey question present)
} else {
if ($question_type == "2") {
// This is a text-area question.
echo db_result($result, 0, "question") . "<br />\n";
echo "<a href=\"show_results_comments.php?survey_id={$survey_id}&question_id={$quest_array[$i]}&group_id={$group_id}\">" . _('View All Comments') . "</a>";
} else {
if ($question_type == "3") {
// This is a Yes/No question.
// Show the Yes/No only if this is the first in a series
if ($question_type != $last_question_type) {
echo "<strong>" . _('Yes / No') . "</strong><br />\n";
}
} else {
$type = " <B>" . $Language->getText('survey_common_survey', 'select_box') . "</B>\n";
}
}
if (!isset($last_question_type) || $question_type != $last_question_type) {
echo ' ' . $Language->getText('survey_admin_show_r_aggregate', 'type') . $type;
}
$sql = "SELECT response,count(*) AS count FROM survey_responses WHERE survey_id='" . db_ei($survey_id) . "' " . "AND question_id='" . db_ei($quest_array[$i]) . "' AND response <> '' AND group_id='" . db_ei($group_id) . "' GROUP BY response";
$result2 = db_query($sql);
// Graph it even if there is zero row because GraphResult
// is in charge of displaying the question itself
if (!$result2) {
echo $Language->getText('global', 'error');
echo db_error();
} else {
GraphResult($result2, util_unconvert_htmlspecialchars(db_result($result, 0, "question")));
}
} else {
if ($question_type == "2") {
/*
This is a text-area question.
*/
$sql = "SELECT count(*) AS count FROM survey_responses WHERE survey_id='" . db_ei($survey_id) . "' " . "AND question_id='" . db_ei($quest_array[$i]) . "' AND group_id='" . db_ei($group_id) . "' AND response<>'' ";
$result2 = db_query($sql);
$sql = "SELECT count(*) AS count FROM survey_responses WHERE survey_id='" . db_ei($survey_id) . "' " . "AND question_id='" . db_ei($quest_array[$i]) . "' AND group_id='" . db_ei($group_id) . "' AND response='' ";
$result3 = db_query($sql);
$answers_cnt = db_result($result2, 0, 'count');
$blank_cnt = db_result($result3, 0, 'count');
echo $purifier->purify(db_result($result, 0, "question")) . "<BR>\n";
echo "<A HREF=\"show_results_comments.php?survey_id={$survey_id}&question_id={$quest_array[$i]}&question_num={$q_num}&group_id={$group_id}\">" . $Language->getText('survey_admin_show_r_aggregate', 'view_cmmts') . "</A>" . ' ';
echo $answers_cnt ? "{$answers_cnt} " . $Language->getText('survey_admin_show_r_aggregate', 'cmmts') : $Language->getText('global', 'none');
