$sort = $request->getSorting();
$msg = '';
// If upload
if (isset($post['upload'])) {
// Error check
$errorMsg = array();
$ext = $filter->isImage($file['image']['name']);
if ($ext === false) {
$errorMsg['upload'] = '<p class="error">Please insert only png/jpg/jpeg/gif/bmp</p>';
}
if (isset($file['image']['name']) && $filter->isSize($file['image']['tmp_name'])) {
$errorMsg['upload'] = '<p class="error">Minimum 2MB and 200px x 200px</p>';
}
// If no errors
if (count($errorMsg) === 0) {
$data->saveImage($file['image']['tmp_name'], $ext);
$msg = '<p class="success">Successfully saved.</p>';
}
}
// 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
