<?php
if ($totalrows['total'] > 0) {
?>
<form method="post" action="../php/action.php">
<table class='table table-hover'>
<thead>
<tr>
<th></th><?php
foreach ($array as $key => $value) {
if ($key == "id") {
$field = str_replace("id", "#", $key);
} else {
$field = str_replace("_", " ", $key);
}
$field = ucwords($field);
$field = columnSortArrows($key, $field, $orderby, $sort);
?>
<th>
<?php
echo $field;
?>
</th><?php
}
?>
</tr>
</thead>
<tbody>
<?php
mysql_data_seek($result, 0);
while ($row = mysql_fetch_assoc($result)) {
?>
//IF SORT NOT SET OR VALID, SET DEFAULT
if (!isset($_GET['sort']) or $_GET['sort'] != "ASC" and $_GET['sort'] != "DESC") {
//default sort
$sort = "ASC";
} else {
$sort = mysql_real_escape_string($_GET['sort']);
}
//GET DATA
$sql = "SELECT * FROM `" . $config['table'] . "` ORDER BY {$orderby} {$sort} LIMIT {$startrow},{$limit}";
$result = mysql_query($sql) or die(mysql_error());
//START TABLE AND TABLE HEADER
echo "<table class=\"table table-striped table-bordered table-condensed\">\n<thead>\n<tr>";
$field1 = columnSortArrows('id', 'ID', $orderby, $sort);
$field2 = columnSortArrows('ip', 'IP', $orderby, $sort);
$field3 = columnSortArrows('datetime', 'Date & Time', $orderby, $sort);
$field4 = columnSortArrows('username', 'Nickname', $orderby, $sort);
echo "<th>" . $field1 . "</th>\n";
echo "<th>" . $field2 . "</th>\n";
echo "<th>" . $field3 . "</th>\n";
echo "<th>" . $field4 . "</th>\n";
echo "<th></th>\n";
echo "</tr>\n</thead>\n";
//reset result pointer
mysql_data_seek($result, 0);
//LOOP TABLE ROWS
echo "<tbody>\n";
while ($row = mysql_fetch_assoc($result)) {
echo "<tr>\n";
echo "<td>" . $row['id'] . "</td>\n";
echo "<td>" . $row['ip'] . "</td>\n";
echo "<td>" . date('d/m/Y, H:m', $row['datetime']) . "</td>\n";
//default sort
$sort = "ASC";
} else {
$sort = mysql_real_escape_string($_GET['sort']);
}
//GET DATA
$sql = "SELECT * FROM `" . $config['table'] . "` ORDER BY {$orderby} {$sort}";
$result = mysql_query($sql) or die(mysql_error());
//START TABLE AND TABLE HEADER
echo "<table class=\"table table-striped table-bordered table-condensed\">\n<thead>\n<tr>";
$field1 = columnSortArrows('id', 'ID', $orderby, $sort);
$field2 = columnSortArrows('userwd', 'Username', $orderby, $sort);
$field3 = columnSortArrows('fullname', 'Fullname', $orderby, $sort);
$field4 = columnSortArrows('email', 'Email', $orderby, $sort);
$field5 = columnSortArrows('reg_time', 'Registered', $orderby, $sort);
$field6 = columnSortArrows('userip', 'IP', $orderby, $sort);
echo "<th>" . $field1 . "</th>\n";
echo "<th>" . $field2 . "</th>\n";
echo "<th>" . $field3 . "</th>\n";
echo "<th>" . $field4 . "</th>\n";
echo "<th>" . $field5 . "</th>\n";
echo "<th>" . $field6 . "</th>\n";
echo "<th>SharerLink</th>\n";
echo "<th></th>\n";
echo "</tr>\n</thead>\n";
//reset result pointer
mysql_data_seek($result, 0);
//LOOP TABLE ROWS
echo "<tbody>\n";
while ($row = mysql_fetch_assoc($result)) {
$checkUser = $row['userwd'];
//default sort
$sort = "ASC";
} else {
$sort = mysql_real_escape_string($_GET['sort']);
}
//GET DATA
$sql = "SELECT * FROM `" . $config['table'] . "` ORDER BY {$orderby} {$sort} LIMIT {$startrow},{$limit}";
$result = mysql_query($sql) or die(mysql_error());
//START TABLE AND TABLE HEADER
echo "<table id='userlist' class='table table-striped table-bordered table-condensed open-sans'>\n<thead>\n<tr>";
$field1 = columnSortArrows('id', 'ID', $orderby, $sort);
$field2 = columnSortArrows('username', 'Username', $orderby, $sort);
$field3 = columnSortArrows('registration_ip', 'Last IP', $orderby, $sort);
$field4 = columnSortArrows('email', 'Email', $orderby, $sort);
$field5 = columnSortArrows('registered', 'Registered', $orderby, $sort);
$field6 = columnSortArrows('last_visit', 'Last Visit', $orderby, $sort);
echo "<th style='text-align:center'>" . $field1 . "</th>\n";
echo "<th style='text-align:center'>" . $field2 . "</th>\n";
echo "<th style='text-align:center'>" . $field3 . "</th>\n";
echo "<th style='text-align:center'>" . $field4 . "</th>\n";
echo "<th style='text-align:center'>" . $field5 . "</th>\n";
echo "<th style='text-align:center'>" . $field6 . "</th>\n";
echo "<th style='text-align:center'>SharerLink</th>\n";
echo "<th style='text-align:center'>Actions</th>\n";
echo "</tr>\n</thead>\n";
//reset result pointer
mysql_data_seek($result, 0);
//LOOP TABLE ROWS
echo "<tbody>\n";
while ($row = mysql_fetch_assoc($result)) {
$userID = $row['id'];
if (!isset($_GET['sort']) or $_GET['sort'] != "ASC" and $_GET['sort'] != "DESC") {
//default sort
$sort = "ASC";
} else {
$sort = mysql_real_escape_string($_GET['sort']);
}
//GET DATA
$sql = "SELECT * FROM `" . $config['table'] . "` ORDER BY {$orderby} {$sort}";
$result = mysql_query($sql) or die(mysql_error());
//START TABLE AND TABLE HEADER
echo "<table class=\"table table-striped table-bordered table-condensed\">\n<thead>\n<tr>";
$field1 = columnSortArrows('id', 'ID', $orderby, $sort);
$field2 = columnSortArrows('filename', 'Filename', $orderby, $sort);
$field3 = columnSortArrows('author', 'Author', $orderby, $sort);
$field4 = columnSortArrows('uploaddate', 'Upload Date', $orderby, $sort);
$field5 = columnSortArrows('uploader', 'Uploader', $orderby, $sort);
echo "<th>" . $field1 . "</th>\n";
echo "<th>" . $field2 . "</th>\n";
echo "<th>" . $field3 . "</th>\n";
echo "<th>" . $field4 . "</th>\n";
echo "<th>" . $field5 . "</th>\n";
echo "<th></th>\n";
echo "</tr>\n</thead>\n";
//reset result pointer
mysql_data_seek($result, 0);
//LOOP TABLE ROWS
echo "<tbody>\n";
while ($row = mysql_fetch_assoc($result)) {
echo "<tr>\n";
echo "<td>" . $row['id'] . "</td>\n";
echo "<td>" . $row['filename'];
