'. $lang['query_delete_article'] .' #id '.$_GET['article'].': '. $article->title .'?');
} else {
$result=sql_query("SELECT title FROM ".$SQL_PREFIX."_articles WHERE article = '".$_GET['article']."' AND part = '".$_GET['part']."'");
$article_part = sql_fetch_object($result);
echo(''. $lang['query_delete_article_part'] .' #id '.$_GET['article'].': '. $article->title .'?');
}
echo('
');
}
elseif($_GET['conf'] == 1) {
sql_query("DELETE FROM ".$SQL_PREFIX."_articles WHERE article = '" . $_GET['article'] . "' AND part = '".$_GET['part']."' ");
header('Location: ../?cmd=articles.index&r=5');
}
}
elseif($_GET['op'] == 'get-to-publish') {
$datetime_now = date(Y.'-'.m.'-'.d.' '.H.':'.i.':'.s);
$result=sql_query("SELECT article, part FROM ".$SQL_PREFIX."_articles WHERE article = '".$_GET['id']."'");
$total_result=sql_num_rows($result);
for($i=0;$i<0;$i++) { $main_row_array = sql_fetch_row($result); }
for($i=0;($i<(2147)) && ($i<$total_result);$i++) {
$main_row_array = sql_fetch_row($result);
$pub_article[article] = $main_row_array[0];
$pub_article[part] = $main_row_array[1];
sql_query("UPDATE ".$SQL_PREFIX."_articles SET published = 'no' WHERE article='" . $_GET['id'] . "' and part='".$pub_article[part]."';");
}
header('Location: ../?cmd=articles.index&r=9');
}
elseif($_GET['op'] == 'publish') {
$datetime_now = date(Y.'-'.m.'-'.d.' '.H.':'.i.':'.s);
$result=sql_query("SELECT article, part FROM ".$SQL_PREFIX."_articles WHERE article = '".$_GET['id']."'");
$total_result=sql_num_rows($result);
for($i=0;$i<0;$i++) { $main_row_array = sql_fetch_row($result); }
for($i=0;($i<(2147)) && ($i<$total_result);$i++) {
$main_row_array = sql_fetch_row($result);
$pub_article[article] = $main_row_array[0];
$pub_article[part] = $main_row_array[1];
sql_query("UPDATE ".$SQL_PREFIX."_articles SET published = 'yes' WHERE article='" . $_GET['id'] . "' and part='".$pub_article[part]."';");
sql_query("UPDATE ".$SQL_PREFIX."_articles SET date = '". $datetime_now ."' WHERE article='" . $_GET['id'] . "' and part='".$pub_article[part]."';");
}
header('Location: ../?cmd=articles.index&r=6');
}
elseif($_GET['op'] == 'pull:back') {
$result=sql_query("SELECT article, part FROM ".$SQL_PREFIX."_articles WHERE article = '".$_GET['id']."'");
$total_result=sql_num_rows($result);
for($i=0;$i<0;$i++) { $main_row_array = sql_fetch_row($result); }
for($i=0;($i<(2147)) && ($i<$total_result);$i++) {
$main_row_array = sql_fetch_row($result);
$pub_article[article] = $main_row_array[0];
$pub_article[part] = $main_row_array[1];
sql_query("UPDATE ".$SQL_PREFIX."_articles SET published = 'no' WHERE article='" . $_GET['id'] . "' and part='".$pub_article[part]."';");
}
header('Location: ../?cmd=articles.index&r=7');
}
elseif($_GET['op'] == 'cron') {
$result=sql_query("SELECT article, part FROM ".$SQL_PREFIX."_articles WHERE article = '".$_GET['id']."'");
$total_result=sql_num_rows($result);
for($i=0;$i<0;$i++) { $main_row_array = sql_fetch_row($result); }
for($i=0;$i<$total_result;$i++) {
$main_row_array = sql_fetch_row($result);
$pub_article[article] = $main_row_array[0];
$pub_article[part] = $main_row_array[1];
sql_query("UPDATE ".$SQL_PREFIX."_articles SET published = 'cron' WHERE article='" . $_GET['id'] . "' and part='".$pub_article[part]."';");
}
header('Location: ../?cmd=articles.index&r=8');
}
/* ARTICLES COLUMNS */
if($_GET['op'] == 'save_column') {
$item = $_POST['column_title'];
ItemMaker($item);
if($_GET['subop'] == "new") {
$result = sql_query("INSERT INTO ".$SQL_PREFIX."_articles_column (id,title,address) VALUES ('" . $_POST['column_id'] . "','" . $_POST['column_title'] . "','" . $item . "');");
if($result) {
header('Location: ../?cmd=articles.columns.index&r=1');
}
}
if($_GET['subop'] == "edit") {
sql_query("update ".$SQL_PREFIX."_articles_column set title='" . $_POST['column_title'] . "' where id='" . $_POST['column_id'] . "';");
sql_query("update ".$SQL_PREFIX."_articles_column set address='" . $column_item . "' where id='" . $_POST['column_id'] . "';");
header('Location: ../?cmd=articles.columns.index&r=2');
}
}
elseif($_GET['op'] == 'delete_column') {
if($_GET['conf'] == 0) {
$result=sql_query("SELECT title FROM ".$SQL_PREFIX."_articles_column WHERE id = '".$_GET['id']."'");
$column = sql_fetch_object($result);
echo(''. $lang['query_delete_column'] .' #id '.$_GET['id'].': '. $column->title .'?');
echo('
');
}
elseif($_GET['conf'] == 1) {
$result = sql_query("DELETE FROM ".$SQL_PREFIX."_articles_column WHERE id = '" . $_GET['id'] . "'");
if($result) {
header('Location: ../?cmd=articles.columns.index&r=3');
}
}
}
/* ARTICLES SERIALS */
if($_GET['op'] == 'save_serial') {
$item = $_POST['serial_title'];
ItemMaker($item);
if ($_GET['subop'] == "new") {
$result = sql_query("INSERT INTO ".$SQL_PREFIX."_articles_serials (id,title,item) VALUES ('" . $_POST['serial_id'] . "','" . $_POST['serial_title'] . "','" . $item . "');");
if($result) {
header('Location: ../?cmd=articles.serials.index&r=1');
} else {
echo('error');
}
}
if ($_GET['subop'] == "edit") {
sql_query("update ".$SQL_PREFIX."_articles_serials set title='" . $_POST['serial_title'] . "' where id='" . $_POST['serial_id'] . "';");
sql_query("update ".$SQL_PREFIX."_articles_serials set item='" . $serial_item . "' where id='" . $_POST['serial_id'] . "';");
header('Location: ../?cmd=articles.serials.index&r=2');
}
}
elseif($_GET['op'] == 'delete_serial') {
if($_GET['conf'] == 0) {
$result=sql_query("SELECT title FROM ".$SQL_PREFIX."_articles_serials WHERE id = '".$_GET['id']."'");
$serial = sql_fetch_object($result);
echo(''. $lang['query_delete_serial'] .' #id '.$_GET['id'].': '. $serial->title .'?');
echo('
');
}
elseif($_GET['conf'] == 1) {
$result = sql_query("DELETE FROM ".$SQL_PREFIX."_articles_serials WHERE id = '" . $_GET['id'] . "'");
if($result) {
header('Location: ../?cmd=articles.serials.index&r=3');
} else {
echo('error');
}
}
}
/* ARTICLES SUBCOLUMNS */
if($_GET['op'] == 'save_subcolumn') {
$item = $_POST['subcolumn_title'];
ItemMaker($item);
if ($_GET['subop'] == "new") {
$result = sql_query("INSERT INTO ".$SQL_PREFIX."_articles_subcolumn (id,title,over_column,address) VALUES ('" . $_POST['subcolumn_id'] . "','" . $_POST['subcolumn_title'] . "','" . $_POST['subcolumn_over'] . "','" . $item . "');");
if($result) {
header('Location: ../?cmd=articles.subcolumns.index&r=1');
} else {
echo('error');
}
}
if ($_GET['subop'] == "edit") {
sql_query("update ".$SQL_PREFIX."_articles_subcolumn set title='" . $_POST['subcolumn_title'] . "' where id='" . $_POST['subcolumn_id'] . "';");
sql_query("update ".$SQL_PREFIX."_articles_subcolumn set over_column='" . $_POST['subcolumn_over'] . "' where id='" . $_POST['subcolumn_id'] . "';");
sql_query("update ".$SQL_PREFIX."_articles_subcolumn set address='" . $subcolumn_address . "' where id='" . $_POST['subcolumn_id'] . "';");
header('Location: ../?cmd=articles.subcolumns.index&r=2');
}
}
elseif($_GET['op'] == 'delete_subcolumn') {
if($_GET['conf'] == 0) {
$result=sql_query("SELECT title FROM ".$SQL_PREFIX."_articles_subcolumn WHERE id = '".$_GET['id']."'");
$subcolumn = sql_fetch_object($result);
echo(''. $lang['query_delete_subcolumn'] .' #id '.$_GET['id'].': '. $subcolumn->title .'?');
echo('
');
}
elseif($_GET['conf'] == 1) {
$result = sql_query("DELETE FROM ".$SQL_PREFIX."_articles_subcolumn WHERE id = '" . $_GET['id'] . "'");
if($result) {
header('Location: ../?cmd=articles.subcolumns.index&r=3');
} else {
echo('error');
}
}
}
/* ARTICLES TYPES */
if($_GET['op'] == 'save_types') {
if ($_GET['subop'] == "new") {
$result = sql_query("INSERT INTO ".$SQL_PREFIX."_articles_types (id,type) VALUES ('" . $_POST['type_id'] . "','" . $_POST['type_title'] . "');");
if($result) {
header('Location: ../?cmd=articles.types.index&r=1');
} else {
echo('error');
}
}
if ($_GET['subop'] == "edit") {
sql_query("UPDATE ".$SQL_PREFIX."_articles_types SET type='" . $_POST['type_title'] . "' WHERE id='" . $_POST['type_id'] . "';");
header('Location: ../?cmd=articles.types.index&r=2');
}
}
elseif($_GET['op'] == 'delete_types') {
if($_GET['conf'] == 0) {
$result=sql_query("SELECT type FROM ".$SQL_PREFIX."_articles_types WHERE id = '".$_GET['id']."'");
$type = sql_fetch_object($result);
echo(''. $lang['query_delete_article_type'] .' #id '.$_GET['id'].': '. $type->type .'?');
echo('
');
}
elseif($_GET['conf'] == 1) {
$result = sql_query("DELETE FROM ".$SQL_PREFIX."_articles_types WHERE id = '" . $_GET['id'] . "'");
if($result) {
header('Location: ../?cmd=articles.types.index&r=3');
} else {
echo('error');
}
}
}
?>