// All rights reserved.
This script is part of PHPWCMS. The PHPWCMS web content management system is
free software; you can redistribute it and/or modify it under the terms of
the GNU General Public License as published by the Free Software Foundation;
either version 2 of the License, or (at your option) any later version.
The GNU General Public License can be found at http://www.gnu.org/copyleft/gpl.html
A copy is found in the textfile GPL.txt and important notices to the license
from the author is found in LICENSE.txt distributed with these scripts.
This script is distributed in the hope that it will be useful, but WITHOUT ANY
WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE. See the GNU General Public License for more details.
This copyright notice MUST APPEAR in all copies of the script!
*************************************************************************************/
// ----------------------------------------------------------------
// obligate check for phpwcms constants
if (!defined('PHPWCMS_ROOT')) {
die("You Cannot Access This Script Directly, Have a Nice Day.");
}
// ----------------------------------------------------------------
// keyword specific functions
$BE['HEADER'][] = getJavaScriptSourceLink('include/inc_js/lib.keyword.js');
function backend_list_keywords() {
$list = '' . LF;
return $list;
}
function backend_edit_keywords() {
$list = '';
$keyword_id = empty($_POST['keyword_selected_id']) ? 0 : intval($_POST['keyword_selected_id']);
// UPDATE keyword
if(isset($_POST['send_update'])) {
$update = backend_getKeywordPostValues();
if(empty($update['keyword_name'])) {
// False, empty Keyword Name
$list .= 'Proof your input. Keyword name had no value. Value was reset.
';
} else {
$sql = "UPDATE ".DB_PREPEND."phpwcms_keyword SET ";
$sql .= "keyword_name='" . aporeplace($update['keyword_name']) ."' ";
$sql .= "WHERE keyword_id=".$keyword_id." ";
$sql .= "AND keyword_name!='" . aporeplace($update['keyword_name']) ."' LIMIT 1";
$update['result'] = _dbQuery($sql, 'UPDATE');
}
// INSERT keyword
} elseif(isset($_POST['send_insert'])) {
$insert = backend_getKeywordPostValues();
if(empty($insert['keyword_name'])) {
// False, empty Keyword Name
$list .= 'Proof your input. Keyword name had no value. Value was reset.
';
} else {
// 1st check if keyword does not exist
$sql = "SELECT * FROM ".DB_PREPEND."phpwcms_keyword ";
$sql .= "WHERE keyword_trash=0 AND keyword_name='" . aporeplace($insert['keyword_name']) ."'";
$check = _dbQuery($sql);
if(empty($check[0])) {
$sql = "INSERT INTO ".DB_PREPEND."phpwcms_keyword SET ";
$sql .= "keyword_name='" . aporeplace($insert['keyword_name']) ."'";
$insert['result'] = _dbQuery($sql, 'INSERT');
$keyword_id = $insert['result']['INSERT_ID'];
} else {
$list .= 'No new keyword created. Keyword name must be unique.
';
}
}
}
$sql = "SELECT * FROM ".DB_PREPEND."phpwcms_keyword WHERE keyword_trash=0 AND keyword_id=" . $keyword_id." LIMIT 1";
$keyword = _dbQuery($sql);
if(!$keyword) return 'No keyword could be found for the given ID
';
$list .= '' . LF;
return $list;
}
function backend_getKeywordPostValues() {
$value = array();
$value['keyword_name'] = isset($_POST['keyword_name']) ? clean_slweg($_POST['keyword_name']) : '';
return $value;
}
?>