Модуль GameCMS [GameCMS] Матчмейкинг система [UPD] 2024-12-01

<li class="balance" style="border-style: solid 1px;">
            <?php $STHX = $pdo->prepare("SELECT * FROM `servers` WHERE `game` = 'Counter-Strike: Global Offensive'");
                $row = $STHX->fetch(); $STHX->execute();
                $insertedRows = $STHX->rowCount();
                ?>
          <i class="fa-solid fa-server fa-beat" aria-hidden="true" style="margin-right:10px;color:#05eefe;"></i><?php echo $insertedRows;?>
        <?php $STH = $pdo->query("SELECT * FROM `queue` ORDER BY `id` DESC ");$STH->execute(); $list = $STH->fetchAll(PDO::FETCH_ASSOC);?>
          <?php $STHZ = $pdo->prepare("SELECT * FROM `match_room` WHERE `status` = 4"); $STHZ->setFetchMode(PDO::FETCH_OBJ);
                $STHZ->execute();
                $insertedRows = $STHZ->rowCount();?>
          <i class="fa-solid fa-gamepad fa-beat" aria-hidden="true" style="margin-right:10px;margin-left:10px;color:#05eefe;"></i><?php echo $insertedRows;?>
        <i class="fas fa-spinner fa-spin"  aria-hidden="true" style="margin-right:10px;margin-left:10px; color:#05eefe;"></i><b id="count_queue"></b>
     
            <?php
                $STHQQ = $pdo->prepare("SELECT * FROM `config` WHERE `id` = '1'");
                $STHQQ->execute();
                $STHQQ->setFetchMode(PDO::FETCH_OBJ);
                $rowa = $STHQQ->fetch(PDO::FETCH_ASSOC);
                $queue_status = $rowa['queue_status'];
 
                $STHZ = $pdo->prepare("SELECT * FROM `queue` WHERE `login`= '{login}' LIMIT 1"); $STHZ->setFetchMode(PDO::FETCH_OBJ);
                $row = $STHZ->fetch();
                $STHZ->execute();
                $insertedRows = $STHZ->rowCount();
                $STHA = $pdo->prepare("SELECT * FROM `queue_match` WHERE `login`= '{login}' AND `status` = 1 LIMIT 1"); $STHA->setFetchMode(PDO::FETCH_OBJ);
                $rows = $STHA->fetch();
                $STHA->execute();
                $insertedRowses = $STHA->rowCount();

     

            if($insertedRows <= 0 && $insertedRowses <= 0 && $queue_status != 0) { ?>
            <a href="../" id="button" class="pursee-button" style="width: auto;height: 30px;text-align: center;padding: 10px;background:#009000;">▶ ИГРАТЬ</a>
             <?php } else if($insertedRows > 0 && $queue_status != 0){ ?>
            <a href="../" id="buttons" class="pursee-button" style="width: auto;height: 30px;text-align: center;padding: 10px;">🗙 ОТМЕНИТЬ</a>
             <?php } else if($insertedRowses > 0 && $insertedRows <= 0){ ?>
            <a href="../match_room" class="pursee-button" style="width: auto;height: 30px;text-align: center;padding: 10px; background:orange;">▶ В МАТЧЕ</a>
             <?php } else if ($queue_status != 1) { ?>
            <a class="pursee-button" style="width: auto;height: 30px;text-align: center;padding: 10px; background:#681c23;">🛠 ЗАКРЫТО</a>
             <?php } ?>
          </li>