chess_player_stats()

Complexity

Conditions	21
Paths	> 20000

Size

Total Lines	286
Code Lines	121

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
function chess_player_stats($player_uid, $player_uname, $show_option = _CHESS_SHOW_EXCEPT_SELFPLAY, $cstart = 0, $gstart = 0)
{
    global $xoopsDB, $xoopsTpl;

    $rating_system = chess_moduleConfig('rating_system');

    $num_provisional_games = chess_ratings_num_provisional_games();

    // set show_option to default if appropriate

    if (!$show_option || ('none' == $rating_system && _CHESS_SHOW_RATED_ONLY == $show_option)) {
        $show_option = _CHESS_SHOW_EXCEPT_SELFPLAY;
    }

    // get maximum number of items to display on a page, and constrain it to a reasonable value

    $max_items_to_display = chess_moduleConfig('max_items');

    $max_items_to_display = min(max($max_items_to_display, 1), 1000);

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

    $games_table = $xoopsDB->prefix('chess_games');

    $ratings_table = $xoopsDB->prefix('chess_ratings');

    $player = [];

    $player['uid'] = $player_uid;

    $player['uname'] = $player_uname;

    // ---------------------------------------------

    // form for selecting player and display-options

    // ---------------------------------------------

    // security token not needed for this form

    $form = new XoopsThemeForm(_MD_CHESS_SELECT_PLAYER, 'form1', 'player_stats.php');

    $form->addElement(new XoopsFormText('', 'player_uname', 25, 50, $player_uname));

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

    $menu_show_option = new XoopsFormSelect('', 'show_option', $show_option, 1, false);

    $menu_show_option->addOption(_CHESS_SHOW_ALL_GAMES, _MD_CHESS_SHOW_ALL_GAMES);

    $menu_show_option->addOption(_CHESS_SHOW_EXCEPT_SELFPLAY, _MD_CHESS_SHOW_EXCEPT_SELFPLAY); // default

    if ('none' != $rating_system) {
        $menu_show_option->addOption(_CHESS_SHOW_RATED_ONLY, _MD_CHESS_SHOW_RATED_ONLY);
    }

    $form->addElement($menu_show_option);

    $form->assign($xoopsTpl);

    // user IDs that will require mapping to usernames

    $userids = [];

    // --------------

    // player's games

    // --------------

    // 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.

    $where = "'$player_uid' IN (white_uid, black_uid)";

    if (_CHESS_SHOW_EXCEPT_SELFPLAY == $show_option) {
        $where .= ' AND white_uid != black_uid';
    } elseif (_CHESS_SHOW_RATED_ONLY == $show_option) {
        $where .= ' AND is_rated = "1" AND white_uid != black_uid';
    }

    $result = $xoopsDB->query("SELECT COUNT(*) FROM $games_table WHERE $where");

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

    $xoopsDB->freeRecordSet($result);

    $result = $xoopsDB->query(
        "
        SELECT   game_id, fen_active_color, white_uid, black_uid, pgn_result, is_rated,
            UNIX_TIMESTAMP(GREATEST(create_date,start_date,last_date)) AS last_activity
        FROM      $games_table
        WHERE     $where
        ORDER BY  last_activity DESC
        LIMIT     $gstart, $max_items_to_display
    "
    );

    $games = [];

    while (false !== ($row = $xoopsDB->fetchArray($result))) {
        $games[] = [
            'game_id'          => $row['game_id'],
            'white_uid'        => $row['white_uid'],
            'black_uid'        => $row['black_uid'],
            'fen_active_color' => $row['fen_active_color'],
            'pgn_result'       => $row['pgn_result'],
            'last_activity'    => $row['last_activity'],
            'is_rated'         => $row['is_rated'],
        ];

        // save user IDs that will require mapping to usernames

        if ($row['white_uid']) {
            $userids[$row['white_uid']] = 1;
        }

        if ($row['black_uid']) {
            $userids[$row['black_uid']] = 1;
        }
    }

    $xoopsDB->freeRecordSet($result);

    $show_option_urlparam = "&amp;show_option=$show_option";

    $games_pagenav = new XoopsPageNav($num_items, $max_items_to_display, $gstart, 'gstart', "player_uid=$player_uid$show_option_urlparam");

    // -------------------

    // player's challenges

    // -------------------

    // 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.

    $where = "'$player_uid' IN (player1_uid, player2_uid)";

    if (_CHESS_SHOW_RATED_ONLY == $show_option) {
        $where .= ' AND is_rated = "1"';
    }

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

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

    $xoopsDB->freeRecordSet($result);

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

    $challenges = [];

    while (false !== ($row = $xoopsDB->fetchArray($result))) {
        $challenges[] = [
            'challenge_id' => $row['challenge_id'],
            'game_type'    => $row['game_type'],
            'color_option' => $row['color_option'],
            'player1_uid'  => $row['player1_uid'],
            'player2_uid'  => $row['player2_uid'],
            'create_date'  => $row['create_date'],
            'is_rated'     => $row['is_rated'],
        ];

        // save user IDs that will require mapping to usernames

        if ($row['player1_uid']) {
            $userids[$row['player1_uid']] = 1;
        }

        if ($row['player2_uid']) {
            $userids[$row['player2_uid']] = 1;
        }
    }

    $xoopsDB->freeRecordSet($result);

    $show_option_urlparam = "&amp;show_option=$show_option";

    $challenges_pagenav = new XoopsPageNav($num_items, $max_items_to_display, $cstart, 'cstart', "player_uid=$player_uid$show_option_urlparam");

    // ---------

    // usernames

    // ---------

    // get mapping of user IDs to usernames

    $memberHandler = xoops_getHandler('member');

    $criteria = new \Criteria('uid', '(' . implode(',', array_keys($userids)) . ')', 'IN');

    $usernames = $memberHandler->getUserList($criteria);

The method getUserList() does not exist on XoopsObjectHandler. It seems like you code against a sub-type of XoopsObjectHandler such as XoopsPersistableObjectHandler.

    // add usernames to $games

    foreach ($games as $k => $game) {
        $games[$k]['white_uname'] = $usernames[$game['white_uid']] ?? '?';

        $games[$k]['black_uname'] = $usernames[$game['black_uid']] ?? '?';
    }

    // add usernames to $challenges

    foreach ($challenges as $k => $challenge) {
        $challenges[$k]['player1_uname'] = $usernames[$challenge['player1_uid']] ?? '?';

        $challenges[$k]['player2_uname'] = $usernames[$challenge['player2_uid']] ?? '?';
    }

    // ---------------------------------------------------

    // player's rating info (if rating feature is enabled)

    // ---------------------------------------------------

    if ('none' != $rating_system) {
        $result = $xoopsDB->query(
            "
            SELECT   player_uid, rating, games_won, games_lost, games_drawn, (games_won+games_lost+games_drawn) AS games_played
            FROM     $ratings_table
            ORDER BY rating DESC, player_uid ASC
        "
        );

        $ranking = 0;

        while (false !== ($row = $xoopsDB->fetchArray($result))) {
            if ($row['games_played'] >= $num_provisional_games) {
                ++$ranking;
            }

            if ($row['player_uid'] == $player_uid) {
                break;
            }
        }

        $xoopsDB->freeRecordSet($result);

        if ($row['player_uid'] == $player_uid) {
            $player['ranking'] = $ranking;

            $player['rating'] = $row['rating'];

            $player['games_won'] = $row['games_won'];

            $player['games_lost'] = $row['games_lost'];

            $player['games_drawn'] = $row['games_drawn'];

            $player['games_played'] = $row['games_played'];
        }
    }

    // Template variables

    $player['games'] = $games;

    $player['challenges'] = $challenges;

    $xoopsTpl->assign('chess_player', $player);

    $xoopsTpl->assign('chess_rating_system', chess_moduleConfig('rating_system'));

    $xoopsTpl->assign('chess_provisional_games', $num_provisional_games);

    $xoopsTpl->assign('chess_show_option_urlparam', $show_option_urlparam);

    $xoopsTpl->assign('chess_games_pagenav', $games_pagenav->renderNav());

    $xoopsTpl->assign('chess_challenges_pagenav', $challenges_pagenav->renderNav());
}