} else {
$err = 2;
}
}
if ($t) {
downloadaFile();
} else {
header("Location: ./dwn1.php?err={$err}");
}
break;
case 'getitemcount':
getItemCount();
echo "\n----------------------------------------------------------------------------------------------------\n";
break;
case 'getitemlist':
getItemsList();
echo "\n----------------------------------------------------------------------------------------------------\n";
break;
case 'getiteminfo':
getItemInfo();
echo "\n----------------------------------------------------------------------------------------------------\n";
break;
case 'changeexpiration':
changeExpiration();
echo "\n----------------------------------------------------------------------------------------------------\n";
break;
case 'deleteitem':
deleteItem();
echo "\n----------------------------------------------------------------------------------------------------\n";
break;
}
if (isset($_GET['item'])) {
$item = $_GET['item'];
if ($item == 'combo') {
$file = $_GET['file'];
$page = getUsingTable(substr($file, 0, -4), $link);
function getItemsList($page, $link)
{
$i = 0;
$sql = "SELECT * FROM {$page}";
$result = mysqli_query($link, $sql) or die(mysql_error());
while ($row = mysqli_fetch_array($result)) {
$list[] = $row;
}
echo json_encode($list, JSON_PRETTY_PRINT);
}
getItemsList($page, $link);
} else {
function getRidOfColumns($table, $link)
{
$sql = "SHOW COLUMNS FROM {$table}";
$result = mysqli_query($link, $sql) or die(mysql_error());
$list = array();
while ($row = mysqli_fetch_array($result)) {
$list[] = array('Type' => $row['Type'], 'Field' => $row['Field']);
}
echo json_encode($list, JSON_PRETTY_PRINT);
}
$page = getUsingTable(substr($item, 0, -4), $link);
getRidOfColumns($page, $link);
}
}
$item = $_GET['item'];
if ($item == 'combo') {
$file = $_GET['file'];
$page = getUsingTable(substr($file, 0, -4), $link);
function getItemsList($page, $link, $translationsTable)
{
$list = array();
$sql = "SELECT DISTINCT * FROM {$page}, {$translationsTable} where description = translationid ";
$result = mysqli_query($link, $sql) or die(mysql_error($link));
$i = 0;
while ($row = mysqli_fetch_array($result)) {
$list[] = $row;
}
return $list;
}
echo json_encode(getItemsList($page, $link, $translationsTable));
} else {
function getRidOfColumns($table, $link, $translationsTable, $databaseScheme)
{
// $sql = "SHOW COLUMNS FROM $table, translations";
$sql = "SELECT COLUMN_NAME, COLUMN_TYPE FROM `information_schema`.`columns` WHERE `table_schema` = '{$databaseScheme}' and `table_name` in ('{$table}', '{$translationsTable}')";
$result = mysqli_query($link, $sql) or die(mysql_error());
$list = array();
while ($row = mysqli_fetch_array($result)) {
$list[] = array('Type' => $row['COLUMN_TYPE'], 'Field' => $row['COLUMN_NAME']);
}
echo json_encode($list);
}
$page = getUsingTable(substr($item, 0, -4), $link);
getRidOfColumns($page, $link, $translationsTable, $databaseScheme);
}
