function content() { global $HTTP_POST_VARS, $HTTP_GET_VARS, $list_prefix; $MAIN = loadadmintmplate("main"); $LINKS = loadadmintmplate("links"); $WORK = $LINKS; if (0 == strcmp($HTTP_GET_VARS['mode'], "select")) { //if we are to edit a link //lets get the links from the db $sql = "SELECT * FROM `" . $list_prefix . "links` WHERE `id` = '" . $HTTP_POST_VARS['links'] . "';"; $result = db_query($sql); if ($result) { $rows = db_num_rows($result); } else { $rows = 0; } if ($rows == 0) { //lets make sure that the news exists $WORK = insert_into_template($WORK, "{NEWCHECK}", "checked"); $WORK = insert_into_template($WORK, "{CATLIST}", catlist(0)); } else { //if it does we will read it from the db and add it to our output. $row = db_fetch_array($result); $WORK = insert_into_template($WORK, "{LINKID}", $row['id']); $WORK = insert_into_template($WORK, "{CATLIST}", catlist($row['category'])); $WORK = insert_into_template($WORK, "{LINKTITLE}", $row['title']); $WORK = insert_into_template($WORK, "{LINKURL}", $row['url']); } } else { //if we are not editing an news lets prepare the form for a new news. $WORK = insert_into_template($WORK, "{NEWCHECK}", "checked"); $WORK = insert_into_template($WORK, "{CATLIST}", catlist(0)); } //lets delete a link if its selected if (0 == strcmp($HTTP_GET_VARS['mode'], "delete") && isset($HTTP_POST_VARS['delete_yes'])) { $sql = "DELETE FROM `" . $list_prefix . "links` WHERE `id` = '" . $HTTP_POST_VARS['links'] . "';"; $result = db_query($sql); } elseif (0 == strcmp($HTTP_GET_VARS['mode'], "delete")) { $WORK = "You must check the confirmation box to delete a link.<br>\r\n" . $WORK; } //lets edit/add a link if thats our job. if (0 == strcmp($HTTP_GET_VARS['mode'], "edit")) { if (isset($HTTP_POST_VARS['newlink'])) { //we are adding a new link $sql = "SELECT * FROM `" . $list_prefix . "links` WHERE `category` = '" . $HTTP_POST_VARS['category'] . "' ORDER BY `order` DESC limit 1;"; $result = db_query($sql); if ($result) { $rows = db_num_rows($result); } else { $rows = 0; } if ($rows > 0) { $row = db_fetch_array($result); $order = $row['order'] + 1; } else { $order = 1; } if (isset($HTTP_POST_VARS['linktitle']) && isset($HTTP_POST_VARS['linkurl'])) { $sql = "INSERT INTO " . $list_prefix . "links VALUES ('', '" . $HTTP_POST_VARS['category'] . "', '" . $HTTP_POST_VARS['linktitle'] . "', '" . $HTTP_POST_VARS['linkurl'] . "', '" . $order . "');"; $result = db_query($sql); } } else { //we are editing an existing link if (isset($HTTP_POST_VARS['linkid'])) { //we must know the links linkid to work on it. //lets get our existing db entry $sql = "SELECT * FROM `" . $list_prefix . "links` WHERE `id` = '" . $HTTP_POST_VARS['linkid'] . "' ORDER BY `order` DESC limit 1;"; $result = db_query($sql); $row = db_fetch_array($result); //lets figure out our order $order = 1; if (0 == strcmp($HTTP_POST_VARS['position'], "same")) { //no change to the order. $order = $row['order']; } elseif (0 == strcmp($HTTP_POST_VARS['position'], "up")) { //it needs to move up $sql = "SELECT * FROM `" . $list_prefix . "links` WHERE `order` < '" . $row['order'] . "' ORDER BY `order` DESC;"; $result = db_query($sql); if ($result) { $rows = db_num_rows($result); } else { $rows = 0; } if ($rows > 0) { $row2 = db_fetch_array($result); $sql = "UPDATE `" . $list_prefix . "links` SET `order` = '" . $row['order'] . "' WHERE `id` = '" . $row2['id'] . "';"; $result = db_query($sql); $order = $row2['order']; } } elseif (0 == strcmp($HTTP_POST_VARS['position'], "down")) { // it needs to move down $sql = "SELECT * FROM " . $list_prefix . "links WHERE `order` > '" . $row['order'] . "' ORDER BY `order`;"; $result = db_query($sql); if ($result) { $rows = db_num_rows($result); } else { $rows = 0; } if ($rows > 0) { $row2 = db_fetch_array($result); $sql = "UPDATE " . $list_prefix . "links SET `order` = '" . $row['order'] . "' WHERE `id` = '" . $row2['id'] . "';"; $result = db_query($sql); $order = $row2['order']; } } //now we have the correct order, category, name, and url lets update the db if ($row['category'] != $HTTP_POST_VARS['category']) { //if we are moving to a NEW category lets make this the last link present. $sql = "SELECT * FROM " . $list_prefix . "links WHERE `category` = '" . $HTTP_POST_VARS['category'] . "' ORDER BY `order` DESC;"; $result = db_query($sql); if ($result) { $rows = db_num_rows($result); } else { $rows = 0; } if ($rows > 0) { $row = db_fetch_array($result); $order = $row['order'] + 1; } else { $order = 1; } } //now lets save our changes $sql = "UPDATE " . $list_prefix . "links SET `category` = '" . $HTTP_POST_VARS['category'] . "', `title` = '" . $HTTP_POST_VARS['linktitle'] . "', `url` = '" . $HTTP_POST_VARS['linkurl'] . "', `order` = '" . $order . "' WHERE `id` = '" . $HTTP_POST_VARS['linkid'] . "';"; $result = db_query($sql); } else { $WORK = "ERROR: you must check 'Save as a new link' to make a new link.<BR>\r\n" . $WORK; } } catorder(); } //lets output our news cp. $WORK = insert_into_template($WORK, "{LINKSLIST}", linkslist()); $WORK = insert_into_template($MAIN, "{CONTENT}", $WORK); $WORK = filltemplate($WORK, "{SITENAME} Administration panel"); printf("%s", striptemplate($WORK)); }
<?php get_header(); ?> <div class="page_meta clear"> <div class="rss"> <a href="<?php bloginfo('rss2_url'); ?> ">Subscribe to RSS feed</a> </div> <div class="heading"> <h3>404 Page not found</h3> </div> <?php if (function_exists('catlist')) { catlist(); } ?> <?php get_search_form(); ?> </div> <?php get_footer();
function catalogueDispatch($op) { if (isset($_POST['undo'])) { $op = 'catlist'; } if (isset($_POST['undoentry'])) { $op = 'entrylist'; } if (isset($_POST['cancelselector'])) { $op = 'catlist'; } switch ($op) { case "catlist": catlist(); break; case "newcatalogue": mancatalogue(false); break; case "modcatalogue": mancatalogue(importVar('id', false, 0)); break; case "savecatalogue": savecatalogue(); break; case "delcatalogue": delcatalogue(); break; case "entrylist": entrylist(); break; case "import": import(); break; case "delentry": delentry(); break; case "modcatalogueassoc": modcatalogueassoc(); break; } }
function content() { global $HTTP_POST_VARS, $HTTP_GET_VARS, $list_prefix; $MAIN = loadadmintmplate("main"); $ARTICLES = loadadmintmplate("articles"); $WORK = $ARTICLES; if (0 == strcmp($HTTP_GET_VARS['mode'], "select")) { //if we are to edit an article //lets get the article from the db $sql = "SELECT * FROM `" . $list_prefix . "articles` WHERE `id` = '" . $HTTP_POST_VARS['article'] . "';"; $result = db_query($sql); if ($result) { $rows = db_num_rows($result); } else { $rows = 0; } if ($rows == 0) { //lets make sure that the article exists $WORK = insert_into_template($WORK, "{NEWCHECK}", "checked"); $WORK = insert_into_template($WORK, "{CATLIST}", catlist(0)); } else { //if it does we will read it from the db and add it to our output. $row = db_fetch_array($result); $WORK = insert_into_template($WORK, "{ARTICLEID}", $row['id']); $WORK = insert_into_template($WORK, "{CATLIST}", catlist($row['category'])); $WORK = insert_into_template($WORK, "{ARTICLETITLE}", $row['article_title']); $WORK = insert_into_template($WORK, "{TEASER}", stripslashes($row['teaser'])); $WORK = insert_into_template($WORK, "{ARTICLE}", stripslashes($row['article'])); $WORK = insert_into_template($WORK, "{BYLINE}", $row['byline']); } } else { //if we are not editing an article lets prepare the form for a new article. $WORK = insert_into_template($WORK, "{NEWCHECK}", "checked"); $WORK = insert_into_template($WORK, "{CATLIST}", catlist(0)); } //lets delete an article if its selected if (0 == strcmp($HTTP_GET_VARS['mode'], "delete") && isset($HTTP_POST_VARS['delete_yes'])) { $sql = "DELETE FROM `" . $list_prefix . "articles` WHERE `id` = '" . $HTTP_POST_VARS['article'] . "';"; $result = db_query($sql); } elseif (0 == strcmp($HTTP_GET_VARS['mode'], "delete")) { $WORK = "You must check the confirmation box to delete an article.<br>\r\n" . $WORK; } if (0 == strcmp($HTTP_GET_VARS['mode'], "edit")) { $user = admincookie(); $posted_by = $user['user_id']; if (isset($HTTP_POST_VARS['newarticle'])) { //its a new article being saved. $sql = "INSERT INTO " . $list_prefix . "articles VALUES ('', '" . addslashes($HTTP_POST_VARS['articletitle']) . "', '" . addslashes($HTTP_POST_VARS['teaser']) . "', '" . addslashes($HTTP_POST_VARS['article']) . "', '" . $posted_by . "', '" . addslashes($HTTP_POST_VARS['byline']) . "', '" . time() . "', '" . $HTTP_POST_VARS['category'] . "');"; $result = db_query($sql); } elseif (isset($HTTP_POST_VARS['articleid'])) { //its an old article being saved $sql = "UPDATE `" . $list_prefix . "articles` SET `article_title` = '" . addslashes($HTTP_POST_VARS['articletitle']) . "', `teaser` = '" . addslashes($HTTP_POST_VARS['teaser']) . "', `article` = '" . addslashes($HTTP_POST_VARS['article']) . "', `byline` = '" . addslashes($HTTP_POST_VARS['byline']) . "', `category` = '" . $HTTP_POST_VARS['category'] . "' WHERE `id` = '" . $HTTP_POST_VARS['articleid'] . "';"; $result = db_query($sql); } else { $WORK = "You must check the new article box to save a new article<br>\r\n" . $WORK; } } //lets output our article cp. $WORK = insert_into_template($WORK, "{ARTICLELIST}", articlelist()); $WORK = insert_into_template($MAIN, "{CONTENT}", $WORK); $WORK = filltemplate($WORK, "{SITENAME} Administration panel"); printf("%s", striptemplate($WORK)); }