BrainCMS | Trade Logs unknown column

[DanishAdam]

Hello DevBest!

Can someone guide me on how do I fix the logs_client_table? I'm confused.

You must be registered for see images attach

You must be registered for see images attach

 

[Wieiscool]

This changes it a little bit, I changed the code to make it work etc, maybe not the best fix but it was exactly how I wanted it.
If you want it different than how I did it, you can probably change it yourself or ask here.

Go to the "adminpan" folder and open "tradelogs.php"

Replace everything with:

<?php
    include_once "includes/head.php";
    include_once "includes/header.php";
    include_once "includes/navi.php";
    admin::CheckRank(3);
?>
<aside class="right-side">
    <section class="content">
        <div class="row">
            <div class="col-md-12">
                <section class="panel">
                    <header class="panel-heading">
                        <b>Trade Logs - Unknown items are either exchanged credits/clothing</b><br>
                        <form name="mygallery" action="" method="POST">
                        </header>
                        <div class="panel-body">
                            <table class="table table-striped table-bordered table-condensed">
                                <b>    <strong><tr><td><b>Trade (ID)</b></td><td><b>User (ID)</b></td><td><b>Item (ID)</b></td><td><b>Date/Time</b></td></tr></strong></b
                                <tbody>
                                <?php
                                    $getLogs = $dbh->prepare("SELECT * FROM room_trade_log_items JOIN room_trade_log ORDER BY room_trade_log_items.id DESC");
                                    $getLogs->execute();
                                    while($log = $getLogs->fetch())
                                    {
                                        echo'<tr>
                                        <td>'.$log["id"].'</td>
                                        <td style="width: 13%;">'.$log["user_id"].'</td>
                                        <td style="width: 25%;">'.$log["item_id"].'</td>
                                        <td>'. gmdate('d-m-Y, H:i ', $log['timestamp']).'</td>
                                        ';
                                    }
                                   
                                ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
            <?php
                include_once "includes/footer.php";
                include_once "includes/script.php";
            ?>

 

[DanishAdam]

This changes it a little bit, I changed the code to make it work etc, maybe not the best fix but it was exactly how I wanted it.
If you want it different than how I did it, you can probably change it yourself or ask here.

Go to the "adminpan" folder and open "tradelogs.php"

Replace everything with:

<?php
    include_once "includes/head.php";
    include_once "includes/header.php";
    include_once "includes/navi.php";
    admin::CheckRank(3);
?>
<aside class="right-side">
    <section class="content">
        <div class="row">
            <div class="col-md-12">
                <section class="panel">
                    <header class="panel-heading">
                        <b>Trade Logs - Unknown items are either exchanged credits/clothing</b><br>
                        <form name="mygallery" action="" method="POST">
                        </header>
                        <div class="panel-body">
                            <table class="table table-striped table-bordered table-condensed">
                                <b>    <strong><tr><td><b>Trade (ID)</b></td><td><b>User (ID)</b></td><td><b>Item (ID)</b></td><td><b>Date/Time</b></td></tr></strong></b
                                <tbody>
                                <?php
                                    $getLogs = $dbh->prepare("SELECT * FROM room_trade_log_items JOIN room_trade_log ORDER BY room_trade_log_items.id DESC");
                                    $getLogs->execute();
                                    while($log = $getLogs->fetch())
                                    {
                                        echo'<tr>
                                        <td>'.$log["id"].'</td>
                                        <td style="width: 13%;">'.$log["user_id"].'</td>
                                        <td style="width: 25%;">'.$log["item_id"].'</td>
                                        <td>'. gmdate('d-m-Y, H:i ', $log['timestamp']).'</td>
                                        ';
                                    }
                                  
                                ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
            <?php
                include_once "includes/footer.php";
                include_once "includes/script.php";
            ?>

Bro thank you! may god bless u always