admin-flagged.php

<?php
/*
	Question2Answer by Gideon Greenspan and contributors
	http://www.question2answer.org/

	Description: Controller for admin page showing posts with the most flags


	This program is free software; you can redistribute it and/or
	modify it under the terms of the GNU General Public License
	as published by the Free Software Foundation; either version 2
	of the License, or (at your option) any later version.

	This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
	GNU General Public License for more details.

	More about this license: http://www.question2answer.org/license.php
*/

if (!defined('QA_VERSION')) { // don't allow this page to be requested directly from browser
	header('Location: ../../../');
	exit;
}

require_once QA_INCLUDE_DIR . 'app/admin.php';
require_once QA_INCLUDE_DIR . 'db/selects.php';
require_once QA_INCLUDE_DIR . 'app/format.php';


// Find most flagged questions, answers, comments

$userid = qa_get_logged_in_userid();
$start = qa_get_start();
$pageSize = (int)qa_opt('page_size_qs');

$questions = qa_db_select_with_pending(
	qa_db_flagged_post_qs_selectspec($userid, $start, true, $pageSize)
);


// Check admin privileges (do late to allow one DB query)

if (qa_user_maximum_permit_error('permit_hide_show')) {
	$qa_content = qa_content_prepare();
	$qa_content['error'] = qa_lang_html('users/no_permission');
	return $qa_content;
}


// Check to see if any were cleared or hidden here

$pageerror = qa_admin_check_clicks();


// Remove questions the user has no permission to hide/show

if (qa_user_permit_error('permit_hide_show')) { // if user not allowed to show/hide all posts
	foreach ($questions as $index => $question) {
		if (qa_user_post_permit_error('permit_hide_show', $question)) {
			unset($questions[$index]);
		}
	}
}


// Get information for users

$usershtml = qa_userids_handles_html(qa_any_get_userids_handles($questions));


// Prepare content for theme

$qa_content = qa_content_prepare();

$qa_content['title'] = qa_lang_html('admin/most_flagged_title');
$qa_content['error'] = isset($pageerror) ? $pageerror : qa_admin_page_error();

$qa_content['q_list'] = array(
	'form' => array(
		'tags' => 'method="post" action="' . qa_self_html() . '"',

		'hidden' => array(
			'code' => qa_get_form_security_code('admin/click'),
		),
	),

	'qs' => array(),
);


if (count($questions)) {
	foreach ($questions as $question) {
		$postid = qa_html(isset($question['opostid']) ? $question['opostid'] : $question['postid']);
		$elementid = 'p' . $postid;

		$htmloptions = qa_post_html_options($question);
		$htmloptions['voteview'] = false;
		$htmloptions['tagsview'] = ($question['obasetype'] == 'Q');
		$htmloptions['answersview'] = false;
		$htmloptions['viewsview'] = false;
		$htmloptions['contentview'] = true;
		$htmloptions['flagsview'] = true;
		$htmloptions['elementid'] = $elementid;

		$htmlfields = qa_any_to_q_html_fields($question, $userid, qa_cookie_get(), $usershtml, null, $htmloptions);

		if (isset($htmlfields['what_url'])) // link directly to relevant content
			$htmlfields['url'] = $htmlfields['what_url'];

		$htmlfields['form'] = array(
			'style' => 'light',

			'buttons' => array(
				'clearflags' => array(
					'tags' => 'name="admin_' . $postid . '_clearflags" onclick="return qa_admin_click(this);"',
					'label' => qa_lang_html('question/clear_flags_button'),
				),

				'hide' => array(
					'tags' => 'name="admin_' . $postid . '_hide" onclick="return qa_admin_click(this);"',
					'label' => qa_lang_html('question/hide_button'),
				),
			),
		);

		$qa_content['q_list']['qs'][] = $htmlfields;
	}
	// Manual count query
	$totalflaged = qa_opt('cache_flaggedcount'); // Fetching total flagged value from cache; may be used for better performance
	//$totalflaged = qa_db_read_one_value(qa_db_query_sub("SELECT COUNT(*) FROM qa_posts WHERE flagcount > 0"),true); // Fetching total flagged value from the db through a complete run

	// Add page links
	$qa_content['page_links'] = qa_html_page_links(
										qa_request(),     // Current request
										$start,           // Current start offset
										$pageSize,        // how many posts per page
										$totalflaged,     // Total number of items
										2,             // number of page links before and after current
										array(),          // Extra query params
										''                // Anchor
									);


} else
	$qa_content['title'] = qa_lang_html('admin/no_flagged_found');


$qa_content['navigation']['sub'] = qa_admin_sub_navigation();
$qa_content['script_rel'][] = 'qa-content/qa-admin.js?' . QA_VERSION;


return $qa_content;