chess_admin_challenges()

Complexity

Conditions	5
Paths	2

Size

Total Lines	64
Code Lines	30

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function chess_admin_challenges()
{
    global $start, $max_items_to_display, $op, $xoopsDB, $xoopsModule;

    $memberHandler = xoops_getHandler('member');

    // Two queries are performed, one without a limit clause to count the total number of rows for the page navigator,

    // and one with a limit clause to get the data for display on the current page.

    // SQL_CALC_FOUND_ROWS and FOUND_ROWS(), available in MySQL 4.0.0, provide a more efficient way of doing this.

    $challenges_table = $xoopsDB->prefix('chess_challenges');

    $result = $xoopsDB->query("SELECT COUNT(*) FROM $challenges_table");

    [$num_rows] = $xoopsDB->fetchRow($result);

    $xoopsDB->freeRecordSet($result);

    $result = $xoopsDB->query(
        trim(
            "
        SELECT   challenge_id, game_type, color_option, player1_uid, player2_uid, UNIX_TIMESTAMP(create_date) AS create_date
        FROM     $challenges_table
        ORDER BY create_date DESC
        LIMIT    $start, $max_items_to_display
    "
        )
    );

    if ($xoopsDB->getRowsNum($result) > 0) {
        echo '<h3>' . _AM_CHESS_CHALLENGES . "</h3>\n";

        while (false !== ($row = $xoopsDB->fetchArray($result))) {
            $user_player1 = $memberHandler->getUser($row['player1_uid']);

            $username_player1 = is_object($user_player1) ? $user_player1->getVar('uname') : '?';

            $user_player2 = $memberHandler->getUser($row['player2_uid']);

            $username_player2 = is_object($user_player2) ? $user_player2->getVar('uname') : '(open)';

            $date = date('Y.m.d', $row['create_date']);

            $title_text = _AM_CHESS_CHALLENGE . " #{$row['challenge_id']}&nbsp;&nbsp;&nbsp;$username_player1 " . _AM_CHESS_CHALLENGED . ": $username_player2&nbsp;&nbsp;&nbsp;(" . _AM_CHESS_CREATED . " $date)";

            $form = new XoopsThemeForm($title_text, "challenge_{$row['challenge_id']}", XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . "/create.php?challenge_id={$row['challenge_id']}", 'post', true);

            $form->addElement(new XoopsFormButton('', 'submit', _AM_CHESS_ARBITRATE_SUBMIT, 'submit'));

            $form->addElement(new XoopsFormHidden('show_arbiter_ctrl', 1));

            $form->display();
        }

        $pagenav = new XoopsPageNav($num_rows, $max_items_to_display, $start, 'start', "op=$op");

        echo '<div align="center">' . $pagenav->renderNav() . "&nbsp;</div>\n";
    } else {
        echo '<h3>' . _AM_CHESS_NO_CHALLENGES . "</h3>\n";
    }

    $xoopsDB->freeRecordSet($result);
}