/** * 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');