dupers.php

<?php
date_default_timezone_set('Europe/London');
$PageTitle = "Exile Dupe Search:";
$path = dirname($_SERVER['PHP_SELF']);
include 'includes/header.php';
include 'includes/config.php';
include 'includes/functions.php';




// Display trader history

$sql3 = "   SELECT steamid64, items_sold, COUNT(*) as amount, poptabs, servername
            FROM trader_log
            WHERE time_sold > NOW() - INTERVAL 7 DAY
            AND steamid64 <> ''
            AND (
            items_sold = 'Exile_Item_Codelock' 
            OR items_sold = 'Exile_Item_Defibrillator' 
            OR items_sold = 'Exile_Item_SafeKit' 
            OR items_sold = 'Exile_Item_Grinder'
            OR items_sold = 'Exile_Item_MetalPole'
            OR items_sold = 'Exile_Item_SleepingMat'
            OR items_sold = 'Exile_Item_OilCanister'
            OR items_sold = 'Exile_Item_Foolbox'
            OR items_sold = 'Exile_Item_Screwdriver'
            OR items_sold like '%_Remote_Mag'
            OR items_sold like '%_Wire_Mag'
            OR items_sold like '%_Range_Mag'
            )
            GROUP BY steamid64,items_sold
            ORDER BY COUNT(*) DESC";
$result3 = mysqli_query($db_traders, $sql3);

if (mysqli_num_rows($result3) > 0)
{
    echo "<hr><h2>POTENTIAL DUPERS - Expensive Items sold in the last 14 days</h2><hr>";
    echo '<table class="tftable" border="1"">
            <tr>
                <td style="width:250px;">Player</td>
                <td style="width:150px;">Server</td>
                <td>Items</td>               
                <td  align=right style="width:150px;">Amount</td>             
            </tr>';
}
else
{
    echo "<hr><h2>There is no trader history</h2><hr>";
}

while ($row3 = mysqli_fetch_object($result3))
{
    $steamid64 = $row3->steamid64;
    $items_sold = str_replace('","', '", "', $row3->items_sold);
    $poptabs = $row3->poptabs;
    $amount = $row3->amount;
    $servername = $row3->servername;
    $isBanned = isBanned($steamid64, $servername, $ServerList);
    if($isBanned == 'false' && $amount >= 5)
    {
        // get the players name
        $playerName = getPlayersName($steamid64, $servername, $ServerList);
        echo '<tr>'
        . '<td valign=top style="width:250px;"><a href="playersearch.php?server='.$servername.'&searchtype=uid&searchfield=' . $steamid64 . '">'.$playerName.'</a></td>'
        . '<td valign=top>' . ucwords($servername) . '</td>'        
        . '<td valign=top>' . $items_sold . '</td>'
        . '<td valign=top align=right style="width:50px;">' . $amount . '</td>'
        . '</tr>';        
    }

}
echo "</table>";
?>