1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: 534: 535: 536: 537: 538: 539: 540: 541: 542: 543: 544: 545: 546: 547: 548: 549: 550: 551: 552: 553: 554: 555: 556: 557: 558: 559: 560: 561: 562: 563: 564: 565: 566: 567: 568: 569: 570: 571: 572: 573: 574: 575: 576: 577: 578: 579: 580: 581: 582: 583: 584: 585: 586: 587: 588: 589: 590: 591: 592: 593: 594: 595: 596: 597: 598: 599: 600: 601: 602: 603: 604: 605: 606: 607: 608: 609: 610: 611: 612: 613: 614: 615: 616: 617: 618: 619: 620: 621: 622: 623: 624: 625: 626: 627: 628: 629: 630: 631: 632: 633: 634: 635: 636: 637: 638: 639: 640: 641: 642: 643: 644: 645: 646: 647: 648: 649: 650: 651: 652: 653: 654: 655: 656: 657: 658: 659: 660: 661: 662: 663: 664: 665: 666: 667: 668: 669: 670: 671: 672: 673: 674: 675: 676: 677: 678: 679: 680: 681: 682: 683: 684: 685: 686: 687: 688: 689: 690: 691: 692: 693: 694: 695: 696: 697: 698: 699: 700: 701: 702: 703: 704: 705: 706: 707: 708: 709: 710: 711: 712: 713: 714: 715: 716: 717: 718: 719: 720: 721: 722: 723: 724: 725: 726: 727: 728: 729: 730: 731: 732: 733: 734: 735: 736: 737: 738: 739: 740: 741: 742: 743: 744: 745: 746: 747: 748: 749: 750: 751: 752: 753: 754: 755: 756: 757: 758: 759: 760: 761: 762: 763: 764: 765: 766: 767: 768: 769: 770: 771: 772: 773: 774: 775: 776: 777: 778: 779: 780: 781: 782: 783: 784: 785: 786: 787: 788: 789: 790: 791: 792: 793: 794: 795: 796: 797: 798: 799: 800: 801: 802: 803: 804: 805: 806: 807: 808: 809: 810: 811: 812: 813: 

<?php

/**
 * This file's job is to handle things related to post moderation.
 *
 * Simple Machines Forum (SMF)
 *
 * @package SMF
 * @author Simple Machines http://www.simplemachines.org
 * @copyright 2019 Simple Machines and individual contributors
 * @license http://www.simplemachines.org/about/smf/license.php BSD
 *
 * @version 2.1 RC1
 */

if (!defined('SMF'))
    die('No direct access...');

/**
 * This is a handling function for all things post moderation.
 */
function PostModerationMain()
{
    global $sourcedir;

    // @todo We'll shift these later bud.
    loadLanguage('ModerationCenter');
    loadTemplate('ModerationCenter');

    // Probably need this...
    require_once($sourcedir . '/ModerationCenter.php');

    // Allowed sub-actions, you know the drill by now!
    $subActions = array(
        'approve' => 'ApproveMessage',
        'attachments' => 'UnapprovedAttachments',
        'replies' => 'UnapprovedPosts',
        'topics' => 'UnapprovedPosts',
    );

    // Pick something valid...
    if (!isset($_REQUEST['sa']) || !isset($subActions[$_REQUEST['sa']]))
        $_REQUEST['sa'] = 'replies';

    call_integration_hook('integrate_post_moderation', array(&$subActions));

    call_helper($subActions[$_REQUEST['sa']]);
}

/**
 * View all unapproved posts.
 */
function UnapprovedPosts()
{
    global $txt, $scripturl, $context, $user_info, $smcFunc, $options, $modSettings;

    $context['current_view'] = isset($_GET['sa']) && $_GET['sa'] == 'topics' ? 'topics' : 'replies';
    $context['page_title'] = $txt['mc_unapproved_posts'];

    // Work out what boards we can work in!
    $approve_boards = boardsAllowedTo('approve_posts');

    // If we filtered by board remove ones outside of this board.
    // @todo Put a message saying we're filtered?
    if (isset($_REQUEST['brd']))
    {
        $filter_board = array((int) $_REQUEST['brd']);
        $approve_boards = $approve_boards == array(0) ? $filter_board : array_intersect($approve_boards, $filter_board);
    }

    if ($approve_boards == array(0))
        $approve_query = '';
    elseif (!empty($approve_boards))
        $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')';
    // Nada, zip, etc...
    else
        $approve_query = ' AND 1=0';

    // We also need to know where we can delete topics and/or replies to.
    if ($context['current_view'] == 'topics')
    {
        $delete_own_boards = boardsAllowedTo('remove_own');
        $delete_any_boards = boardsAllowedTo('remove_any');
        $delete_own_replies = array();
    }
    else
    {
        $delete_own_boards = boardsAllowedTo('delete_own');
        $delete_any_boards = boardsAllowedTo('delete_any');
        $delete_own_replies = boardsAllowedTo('delete_own_replies');
    }

    $toAction = array();
    // Check if we have something to do?
    if (isset($_GET['approve']))
        $toAction[] = (int) $_GET['approve'];
    // Just a deletion?
    elseif (isset($_GET['delete']))
        $toAction[] = (int) $_GET['delete'];
    // Lots of approvals?
    elseif (isset($_POST['item']))
        foreach ($_POST['item'] as $item)
            $toAction[] = (int) $item;

    // What are we actually doing.
    if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve'))
        $curAction = 'approve';
    elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete'))
        $curAction = 'delete';

    // Right, so we have something to do?
    if (!empty($toAction) && isset($curAction))
    {
        checkSession('request');

        // Handy shortcut.
        $any_array = $curAction == 'approve' ? $approve_boards : $delete_any_boards;

        // Now for each message work out whether it's actually a topic, and what board it's on.
        $request = $smcFunc['db_query']('', '
            SELECT m.id_msg, m.id_member, m.id_board, m.subject, t.id_topic, t.id_first_msg, t.id_member_started
            FROM {db_prefix}messages AS m
                INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
            LEFT JOIN {db_prefix}boards AS b ON (t.id_board = b.id_board)
            WHERE m.id_msg IN ({array_int:message_list})
                AND m.approved = {int:not_approved}
                AND {query_see_board}',
            array(
                'message_list' => $toAction,
                'not_approved' => 0,
            )
        );
        $toAction = array();
        $details = array();
        while ($row = $smcFunc['db_fetch_assoc']($request))
        {
            // If it's not within what our view is ignore it...
            if (($row['id_msg'] == $row['id_first_msg'] && $context['current_view'] != 'topics') || ($row['id_msg'] != $row['id_first_msg'] && $context['current_view'] != 'replies'))
                continue;

            $can_add = false;
            // If we're approving this is simple.
            if ($curAction == 'approve' && ($any_array == array(0) || in_array($row['id_board'], $any_array)))
            {
                $can_add = true;
            }
            // Delete requires more permission checks...
            elseif ($curAction == 'delete')
            {
                // Own post is easy!
                if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards)))
                    $can_add = true;
                // Is it a reply to their own topic?
                elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies)))
                    $can_add = true;
                // Someone elses?
                elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards)))
                    $can_add = true;
            }

            if ($can_add)
                $anItem = $context['current_view'] == 'topics' ? $row['id_topic'] : $row['id_msg'];
            $toAction[] = $anItem;

            // All clear. What have we got now, what, what?
            $details[$anItem] = array();
            $details[$anItem]["subject"] = $row['subject'];
            $details[$anItem]["topic"] = $row['id_topic'];
            $details[$anItem]["member"] = ($context['current_view'] == 'topics') ? $row['id_member_started'] : $row['id_member'];
            $details[$anItem]["board"] = $row['id_board'];
        }
        $smcFunc['db_free_result']($request);

        // If we have anything left we can actually do the approving (etc).
        if (!empty($toAction))
        {
            if ($curAction == 'approve')
            {
                approveMessages($toAction, $details, $context['current_view']);
            }
            else
            {
                removeMessages($toAction, $details, $context['current_view']);
            }
        }
    }

    // How many unapproved posts are there?
    $request = $smcFunc['db_query']('', '
        SELECT COUNT(*)
        FROM {db_prefix}messages AS m
            INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic AND t.id_first_msg != m.id_msg)
            INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
        WHERE m.approved = {int:not_approved}
            AND {query_see_board}
            ' . $approve_query,
        array(
            'not_approved' => 0,
        )
    );
    list ($context['total_unapproved_posts']) = $smcFunc['db_fetch_row']($request);
    $smcFunc['db_free_result']($request);

    // What about topics?  Normally we'd use the table alias t for topics but lets use m so we don't have to redo our approve query.
    $request = $smcFunc['db_query']('', '
        SELECT COUNT(m.id_topic)
        FROM {db_prefix}topics AS m
            INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
        WHERE m.approved = {int:not_approved}
            AND {query_see_board}
            ' . $approve_query,
        array(
            'not_approved' => 0,
        )
    );
    list ($context['total_unapproved_topics']) = $smcFunc['db_fetch_row']($request);
    $smcFunc['db_free_result']($request);

    // Limit to how many? (obey the user setting)
    $limit = !empty($options['messages_per_page']) ? $options['messages_per_page'] : $modSettings['defaultMaxMessages'];

    $context['page_index'] = constructPageIndex($scripturl . '?action=moderate;area=postmod;sa=' . $context['current_view'] . (isset($_REQUEST['brd']) ? ';brd=' . (int) $_REQUEST['brd'] : ''), $_GET['start'], $context['current_view'] == 'topics' ? $context['total_unapproved_topics'] : $context['total_unapproved_posts'], $limit);
    $context['start'] = $_GET['start'];

    // We have enough to make some pretty tabs!
    $context[$context['moderation_menu_name']]['tab_data'] = array(
        'title' => $txt['mc_unapproved_posts'],
        'help' => 'postmod',
        'description' => $txt['mc_unapproved_posts_desc'],
    );

    // Update the tabs with the correct number of posts.
    $context['menu_data_' . $context['moderation_menu_id']]['sections']['posts']['areas']['postmod']['subsections']['posts']['label'] .= ' (' . $context['total_unapproved_posts'] . ')';
    $context['menu_data_' . $context['moderation_menu_id']]['sections']['posts']['areas']['postmod']['subsections']['topics']['label'] .= ' (' . $context['total_unapproved_topics'] . ')';

    // If we are filtering some boards out then make sure to send that along with the links.
    if (isset($_REQUEST['brd']))
    {
        $context['menu_data_' . $context['moderation_menu_id']]['sections']['posts']['areas']['postmod']['subsections']['posts']['add_params'] = ';brd=' . (int) $_REQUEST['brd'];
        $context['menu_data_' . $context['moderation_menu_id']]['sections']['posts']['areas']['postmod']['subsections']['topics']['add_params'] = ';brd=' . (int) $_REQUEST['brd'];
    }

    // Get all unapproved posts.
    $request = $smcFunc['db_query']('', '
        SELECT m.id_msg, m.id_topic, m.id_board, m.subject, m.body, m.id_member,
            COALESCE(mem.real_name, m.poster_name) AS poster_name, m.poster_time, m.smileys_enabled,
            t.id_member_started, t.id_first_msg, b.name AS board_name, c.id_cat, c.name AS cat_name
        FROM {db_prefix}messages AS m
            INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
            INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
            LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
            LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
        WHERE m.approved = {int:not_approved}
            AND t.id_first_msg ' . ($context['current_view'] == 'topics' ? '=' : '!=') . ' m.id_msg
            AND {query_see_board}
            ' . $approve_query . '
        LIMIT {int:start}, {int:limit}',
        array(
            'not_approved' => 0,
            'start' => $context['start'],
            'limit' => $limit,
        )
    );
    $context['unapproved_items'] = array();
    for ($i = 1; $row = $smcFunc['db_fetch_assoc']($request); $i++)
    {
        // Can delete is complicated, let's solve it first... is it their own post?
        if ($row['id_member'] == $user_info['id'] && ($delete_own_boards == array(0) || in_array($row['id_board'], $delete_own_boards)))
            $can_delete = true;
        // Is it a reply to their own topic?
        elseif ($row['id_member'] == $row['id_member_started'] && $row['id_msg'] != $row['id_first_msg'] && ($delete_own_replies == array(0) || in_array($row['id_board'], $delete_own_replies)))
            $can_delete = true;
        // Someone elses?
        elseif ($row['id_member'] != $user_info['id'] && ($delete_any_boards == array(0) || in_array($row['id_board'], $delete_any_boards)))
            $can_delete = true;
        else
            $can_delete = false;

        $context['unapproved_items'][] = array(
            'id' => $row['id_msg'],
            'counter' => $context['start'] + $i,
            'href' => $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['id_msg'] . '#msg' . $row['id_msg'],
            'link' => '<a href="' . $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['id_msg'] . '#msg' . $row['id_msg'] . '">' . $row['subject'] . '</a>',
            'subject' => $row['subject'],
            'body' => parse_bbc($row['body'], $row['smileys_enabled'], $row['id_msg']),
            'time' => timeformat($row['poster_time']),
            'poster' => array(
                'id' => $row['id_member'],
                'name' => $row['poster_name'],
                'link' => $row['id_member'] ? '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['poster_name'] . '</a>' : $row['poster_name'],
                'href' => $scripturl . '?action=profile;u=' . $row['id_member'],
            ),
            'topic' => array(
                'id' => $row['id_topic'],
            ),
            'board' => array(
                'id' => $row['id_board'],
                'name' => $row['board_name'],
                'link' => '<a href="' . $scripturl . '?board=' . $row['id_board'] . '.0">' . $row['board_name'] . '</a>',
            ),
            'category' => array(
                'id' => $row['id_cat'],
                'name' => $row['cat_name'],
                'link' => '<a href="' . $scripturl . '#c' . $row['id_cat'] . '">' . $row['cat_name'] . '</a>',
            ),
            'can_delete' => $can_delete,
        );
    }
    $smcFunc['db_free_result']($request);

    $context['sub_template'] = 'unapproved_posts';
}

/**
 * View all unapproved attachments.
 */
function UnapprovedAttachments()
{
    global $txt, $scripturl, $context, $sourcedir, $smcFunc, $modSettings;

    $context['page_title'] = $txt['mc_unapproved_attachments'];

    // Once again, permissions are king!
    $approve_boards = boardsAllowedTo('approve_posts');

    if ($approve_boards == array(0))
        $approve_query = '';
    elseif (!empty($approve_boards))
        $approve_query = ' AND m.id_board IN (' . implode(',', $approve_boards) . ')';
    else
        $approve_query = ' AND 1=0';

    // Get together the array of things to act on, if any.
    $attachments = array();
    if (isset($_GET['approve']))
        $attachments[] = (int) $_GET['approve'];
    elseif (isset($_GET['delete']))
        $attachments[] = (int) $_GET['delete'];
    elseif (isset($_POST['item']))
        foreach ($_POST['item'] as $item)
            $attachments[] = (int) $item;

    // Are we approving or deleting?
    if (isset($_GET['approve']) || (isset($_POST['do']) && $_POST['do'] == 'approve'))
        $curAction = 'approve';
    elseif (isset($_GET['delete']) || (isset($_POST['do']) && $_POST['do'] == 'delete'))
        $curAction = 'delete';

    // Something to do, let's do it!
    if (!empty($attachments) && isset($curAction))
    {
        checkSession('request');

        // This will be handy.
        require_once($sourcedir . '/ManageAttachments.php');

        // Confirm the attachments are eligible for changing!
        $request = $smcFunc['db_query']('', '
            SELECT a.id_attach
            FROM {db_prefix}attachments AS a
                INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
                LEFT JOIN {db_prefix}boards AS b ON (m.id_board = b.id_board)
            WHERE a.id_attach IN ({array_int:attachments})
                AND a.approved = {int:not_approved}
                AND a.attachment_type = {int:attachment_type}
                AND {query_see_board}
                ' . $approve_query,
            array(
                'attachments' => $attachments,
                'not_approved' => 0,
                'attachment_type' => 0,
            )
        );
        $attachments = array();
        while ($row = $smcFunc['db_fetch_assoc']($request))
            $attachments[] = $row['id_attach'];
        $smcFunc['db_free_result']($request);

        // Assuming it wasn't all like, proper illegal, we can do the approving.
        if (!empty($attachments))
        {
            if ($curAction == 'approve')
                ApproveAttachments($attachments);
            else
                removeAttachments(array('id_attach' => $attachments, 'do_logging' => true));
        }
    }

    require_once($sourcedir . '/Subs-List.php');

    $listOptions = array(
        'id' => 'mc_unapproved_attach',
        'width' => '100%',
        'items_per_page' => $modSettings['defaultMaxListItems'],
        'no_items_label' => $txt['mc_unapproved_attachments_none_found'],
        'base_href' => $scripturl . '?action=moderate;area=attachmod;sa=attachments',
        'default_sort_col' => 'attach_name',
        'get_items' => array(
            'function' => 'list_getUnapprovedAttachments',
            'params' => array(
                $approve_query,
            ),
        ),
        'get_count' => array(
            'function' => 'list_getNumUnapprovedAttachments',
            'params' => array(
                $approve_query,
            ),
        ),
        'columns' => array(
            'attach_name' => array(
                'header' => array(
                    'value' => $txt['mc_unapproved_attach_name'],
                ),
                'data' => array(
                    'db' => 'filename',
                ),
                'sort' => array(
                    'default' => 'a.filename',
                    'reverse' => 'a.filename DESC',
                ),
            ),
            'attach_size' => array(
                'header' => array(
                    'value' => $txt['mc_unapproved_attach_size'],
                ),
                'data' => array(
                    'db' => 'size',
                ),
                'sort' => array(
                    'default' => 'a.size',
                    'reverse' => 'a.size DESC',
                ),
            ),
            'attach_poster' => array(
                'header' => array(
                    'value' => $txt['mc_unapproved_attach_poster'],
                ),
                'data' => array(
                    'function' => function($data)
                    {
                        return $data['poster']['link'];
                    },
                ),
                'sort' => array(
                    'default' => 'm.id_member',
                    'reverse' => 'm.id_member DESC',
                ),
            ),
            'date' => array(
                'header' => array(
                    'value' => $txt['date'],
                    'style' => 'width: 18%;',
                ),
                'data' => array(
                    'db' => 'time',
                    'class' => 'smalltext',
                    'style' => 'white-space:nowrap;',
                ),
                'sort' => array(
                    'default' => 'm.poster_time',
                    'reverse' => 'm.poster_time DESC',
                ),
            ),
            'message' => array(
                'header' => array(
                    'value' => $txt['post'],
                ),
                'data' => array(
                    'function' => function($data)
                    {
                        return '<a href="' . $data['message']['href'] . '">' . shorten_subject($data['message']['subject'], 20) . '</a>';
                    },
                    'class' => 'smalltext',
                    'style' => 'width:15em;',
                ),
                'sort' => array(
                    'default' => 'm.subject',
                    'reverse' => 'm.subject DESC',
                ),
            ),
            'action' => array(
                'header' => array(
                    'value' => '<input type="checkbox" onclick="invertAll(this, this.form);" checked>',
                    'style' => 'width: 4%;',
                    'class' => 'centercol',
                ),
                'data' => array(
                    'sprintf' => array(
                        'format' => '<input type="checkbox" name="item[]" value="%1$d" checked>',
                        'params' => array(
                            'id' => false,
                        ),
                    ),
                    'class' => 'centercol',
                ),
            ),
        ),
        'form' => array(
            'href' => $scripturl . '?action=moderate;area=attachmod;sa=attachments',
            'include_sort' => true,
            'include_start' => true,
            'hidden_fields' => array(
                $context['session_var'] => $context['session_id'],
            ),
            'token' => 'mod-ap',
        ),
        'additional_rows' => array(
            array(
                'position' => 'bottom_of_list',
                'value' => '
                    <select name="do" onchange="if (this.value != 0 &amp;&amp; confirm(\'' . $txt['mc_unapproved_sure'] . '\')) submit();">
                        <option value="0">' . $txt['with_selected'] . ':</option>
                        <option value="0" disabled>-------------------</option>
                        <option value="approve">&nbsp;--&nbsp;' . $txt['approve'] . '</option>
                        <option value="delete">&nbsp;--&nbsp;' . $txt['delete'] . '</option>
                    </select>
                    <noscript><input type="submit" name="ml_go" value="' . $txt['go'] . '" class="button"></noscript>',
                'class' => 'floatright',
            ),
        ),
    );

    // Create the request list.
    createToken('mod-ap');
    createList($listOptions);

    $context['sub_template'] = 'show_list';
    $context['default_list'] = 'mc_unapproved_attach';

    $context[$context['moderation_menu_name']]['tab_data'] = array(
        'title' => $txt['mc_unapproved_attachments'],
        'help' => '',
        'description' => $txt['mc_unapproved_attachments_desc']
    );
}

/**
 * Callback function for UnapprovedAttachments
 * retrieve all the attachments waiting for approval the approver can approve
 *
 * @param int $start The item to start with (for pagination purposes)
 * @param int $items_per_page How many items to show on each page
 * @param string $sort A string indicating how to sort the results
 * @param string $approve_query Additional restrictions based on the boards the approver can see
 * @return array An array of information about the unapproved attachments
 */
function list_getUnapprovedAttachments($start, $items_per_page, $sort, $approve_query)
{
    global $smcFunc, $scripturl;

    // Get all unapproved attachments.
    $request = $smcFunc['db_query']('', '
        SELECT a.id_attach, a.filename, a.size, m.id_msg, m.id_topic, m.id_board, m.subject, m.body, m.id_member,
            COALESCE(mem.real_name, m.poster_name) AS poster_name, m.poster_time,
            t.id_member_started, t.id_first_msg, b.name AS board_name, c.id_cat, c.name AS cat_name
        FROM {db_prefix}attachments AS a
            INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
            INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
            INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
            LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
            LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
        WHERE a.approved = {int:not_approved}
            AND a.attachment_type = {int:attachment_type}
            AND {query_see_board}
            {raw:approve_query}
        ORDER BY {raw:sort}
        LIMIT {int:start}, {int:items_per_page}',
        array(
            'not_approved' => 0,
            'attachment_type' => 0,
            'start' => $start,
            'sort' => $sort,
            'items_per_page' => $items_per_page,
            'approve_query' => $approve_query,
        )
    );

    $unapproved_items = array();
    while ($row = $smcFunc['db_fetch_assoc']($request))
    {
        $unapproved_items[] = array(
            'id' => $row['id_attach'],
            'filename' => $row['filename'],
            'size' => round($row['size'] / 1024, 2),
            'time' => timeformat($row['poster_time']),
            'poster' => array(
                'id' => $row['id_member'],
                'name' => $row['poster_name'],
                'link' => $row['id_member'] ? '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['poster_name'] . '</a>' : $row['poster_name'],
                'href' => $scripturl . '?action=profile;u=' . $row['id_member'],
            ),
            'message' => array(
                'id' => $row['id_msg'],
                'subject' => $row['subject'],
                'body' => parse_bbc($row['body']),
                'time' => timeformat($row['poster_time']),
                'href' => $scripturl . '?topic=' . $row['id_topic'] . '.msg' . $row['id_msg'] . '#msg' . $row['id_msg'],
            ),
            'topic' => array(
                'id' => $row['id_topic'],
            ),
            'board' => array(
                'id' => $row['id_board'],
                'name' => $row['board_name'],
            ),
            'category' => array(
                'id' => $row['id_cat'],
                'name' => $row['cat_name'],
            ),
        );
    }
    $smcFunc['db_free_result']($request);

    return $unapproved_items;
}

/**
 * Callback function for UnapprovedAttachments
 * count all the attachments waiting for approval that this approver can approve
 *
 * @param string $approve_query Additional restrictions based on the boards the approver can see
 * @return int The number of unapproved attachments
 */
function list_getNumUnapprovedAttachments($approve_query)
{
    global $smcFunc;

    // How many unapproved attachments in total?
    $request = $smcFunc['db_query']('', '
        SELECT COUNT(*)
        FROM {db_prefix}attachments AS a
            INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
            INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
        WHERE a.approved = {int:not_approved}
            AND a.attachment_type = {int:attachment_type}
            AND {query_see_board}
            ' . $approve_query,
        array(
            'not_approved' => 0,
            'attachment_type' => 0,
        )
    );
    list ($total_unapproved_attachments) = $smcFunc['db_fetch_row']($request);
    $smcFunc['db_free_result']($request);

    return $total_unapproved_attachments;
}

/**
 * Approve a post, just the one.
 */
function ApproveMessage()
{
    global $user_info, $topic, $board, $sourcedir, $smcFunc;

    checkSession('get');

    $_REQUEST['msg'] = (int) $_REQUEST['msg'];

    require_once($sourcedir . '/Subs-Post.php');

    isAllowedTo('approve_posts');

    $request = $smcFunc['db_query']('', '
        SELECT t.id_member_started, t.id_first_msg, m.id_member, m.subject, m.approved
        FROM {db_prefix}messages AS m
            INNER JOIN {db_prefix}topics AS t ON (t.id_topic = {int:current_topic})
        WHERE m.id_msg = {int:id_msg}
            AND m.id_topic = {int:current_topic}
        LIMIT 1',
        array(
            'current_topic' => $topic,
            'id_msg' => $_REQUEST['msg'],
        )
    );
    list ($starter, $first_msg, $poster, $subject, $approved) = $smcFunc['db_fetch_row']($request);
    $smcFunc['db_free_result']($request);

    // If it's the first in a topic then the whole topic gets approved!
    if ($first_msg == $_REQUEST['msg'])
    {
        approveTopics($topic, !$approved);

        if ($starter != $user_info['id'])
            logAction(($approved ? 'un' : '') . 'approve_topic', array('topic' => $topic, 'subject' => $subject, 'member' => $starter, 'board' => $board));
    }
    else
    {
        approvePosts($_REQUEST['msg'], !$approved);

        if ($poster != $user_info['id'])
            logAction(($approved ? 'un' : '') . 'approve', array('topic' => $topic, 'subject' => $subject, 'member' => $poster, 'board' => $board));
    }

    redirectexit('topic=' . $topic . '.msg' . $_REQUEST['msg'] . '#msg' . $_REQUEST['msg']);
}

/**
 * Approve a batch of posts (or topics in their own right)
 *
 * @param array $messages The IDs of the messages to approve
 * @param array $messageDetails An array of information about each message, for the log
 * @param string $current_view What type of unapproved items we're approving - can be 'topics' or 'replies'
 */
function approveMessages($messages, $messageDetails, $current_view = 'replies')
{
    global $sourcedir;

    require_once($sourcedir . '/Subs-Post.php');
    if ($current_view == 'topics')
    {
        approveTopics($messages);
        // and tell the world about it
        foreach ($messages as $topic)
        {
            logAction('approve_topic', array('topic' => $topic, 'subject' => $messageDetails[$topic]['subject'], 'member' => $messageDetails[$topic]['member'], 'board' => $messageDetails[$topic]['board']));
        }
    }
    else
    {
        approvePosts($messages);
        // and tell the world about it again
        foreach ($messages as $post)
        {
            logAction('approve', array('topic' => $messageDetails[$post]['topic'], 'subject' => $messageDetails[$post]['subject'], 'member' => $messageDetails[$post]['member'], 'board' => $messageDetails[$post]['board']));
        }
    }
}

/**
 * This is a helper function - basically approve everything!
 */
function approveAllData()
{
    global $smcFunc, $sourcedir;

    // Start with messages and topics.
    $request = $smcFunc['db_query']('', '
        SELECT id_msg
        FROM {db_prefix}messages
        WHERE approved = {int:not_approved}',
        array(
            'not_approved' => 0,
        )
    );
    $msgs = array();
    while ($row = $smcFunc['db_fetch_row']($request))
        $msgs[] = $row[0];
    $smcFunc['db_free_result']($request);

    if (!empty($msgs))
    {
        require_once($sourcedir . '/Subs-Post.php');
        approvePosts($msgs);
    }

    // Now do attachments
    $request = $smcFunc['db_query']('', '
        SELECT id_attach
        FROM {db_prefix}attachments
        WHERE approved = {int:not_approved}',
        array(
            'not_approved' => 0,
        )
    );
    $attaches = array();
    while ($row = $smcFunc['db_fetch_row']($request))
        $attaches[] = $row[0];
    $smcFunc['db_free_result']($request);

    if (!empty($attaches))
    {
        require_once($sourcedir . '/ManageAttachments.php');
        ApproveAttachments($attaches);
    }
}

/**
 * Remove a batch of messages (or topics)
 *
 * @param array $messages The IDs of the messages to remove
 * @param array $messageDetails An array of information about the messages for the log
 * @param string $current_view What type of item we're removing - can be 'topics' or 'replies'
 */
function removeMessages($messages, $messageDetails, $current_view = 'replies')
{
    global $sourcedir, $modSettings;

    // @todo something's not right, removeMessage() does check permissions,
    // removeTopics() doesn't
    require_once($sourcedir . '/RemoveTopic.php');
    if ($current_view == 'topics')
    {
        removeTopics($messages);
        // and tell the world about it
        foreach ($messages as $topic)
            // Note, only log topic ID in native form if it's not gone forever.
            logAction('remove', array(
                (empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $messageDetails[$topic]['board'] ? 'topic' : 'old_topic_id') => $topic, 'subject' => $messageDetails[$topic]['subject'], 'member' => $messageDetails[$topic]['member'], 'board' => $messageDetails[$topic]['board']));
    }
    else
    {
        foreach ($messages as $post)
        {
            removeMessage($post);
            logAction('delete', array(
                (empty($modSettings['recycle_enable']) || $modSettings['recycle_board'] != $messageDetails[$post]['board'] ? 'topic' : 'old_topic_id') => $messageDetails[$post]['topic'], 'subject' => $messageDetails[$post]['subject'], 'member' => $messageDetails[$post]['member'], 'board' => $messageDetails[$post]['board']));
        }
    }
}

?>