}
// If truncate
if (isset($post['truncate'])) {
$sql = 'TRUNCATE pixel';
$db->select($sql);
}
$sql = 'SELECT pixelID,
AES_DECRYPT(pixelRGB1, "' . $db->aesKey . '") AS pixelRGB1,
AES_DECRYPT(pixelRGB2, "' . $db->aesKey . '") AS pixelRGB2,
AES_DECRYPT(pixelRGB3, "' . $db->aesKey . '") AS pixelRGB3,
pixelX,
pixelY,
pixelRank
FROM pixel ORDER BY pixelID ' . $sort[0]['get'];
$table1 = array();
$table1 = $data->paging($db->select($sql), 20, $page, $sort);
$sql = 'SELECT
AES_DECRYPT(pixelRGB1, "' . $db->aesKey . '") AS pixelRGB1,
AES_DECRYPT(pixelRGB2, "' . $db->aesKey . '") AS pixelRGB2,
AES_DECRYPT(pixelRGB3, "' . $db->aesKey . '") AS pixelRGB3,
pixelX,
pixelY,
pixelRank
FROM pixel ORDER BY pixelRank ' . $sort[1]['get'];
$table2 = array();
$table2 = $data->paging($db->select($sql), 20, $page, $sort);
// Start html
echo '<?xml version="1.0" encoding="UTF-8"?>' . "\n";
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
