$query = $_SGLOBAL['db']->query('SELECT msg.*, item.* FROM ' . tname('robotitems') . ' item LEFT JOIN ' . tname('robotmessages') . ' msg ON item.itemid=msg.itemid WHERE item.itemid=\'' . $itemid . '\'');
if ($thevalue = $_SGLOBAL['db']->fetch_array($query)) {
}
} elseif ($_GET['op'] == 'add') {
//ONE ADD
$thevalue = array('itemid' => 0);
} elseif ($_GET['op'] == 'viewmessage') {
//ONE DELETE
$query = $_SGLOBAL['db']->query('SELECT * FROM ' . tname('robotitems') . ' WHERE itemid=\'' . $_GET['itemid'] . '\'');
if ($showvalue = $_SGLOBAL['db']->fetch_array($query)) {
$query = $_SGLOBAL['db']->query('SELECT * FROM ' . tname('robotmessages') . ' WHERE itemid=\'' . $_GET['itemid'] . '\' ORDER BY msgid');
$showvalue['message'] = array();
while ($rmsg = $_SGLOBAL['db']->fetch_array($query)) {
$showvalue['message'][] = $rmsg;
}
$robotarr = getrobot();
$catarr = getcategory('news');
} else {
showmessage('robotmessage_none_exists');
}
}
//MENU
echo '
<table summary="" id="pagehead" cellpadding="0" cellspacing="0" border="0" width="100%">
<tr>
<td><h1>' . $alang['rototmessage_title'] . '</h1></td>
<td class="actions">
<table summary="" cellpadding="0" cellspacing="0" border="0" align="right">
<tr>
<td' . $view0class . '><a href="' . $theurl . '" class="view">' . $alang['robotmessage_view_list_0'] . '</a></td>
<td' . $view1class . '><a href="' . $theurl . '&isimport=1" class="view">' . $alang['robotmessage_view_list_1'] . '</a></td>
define('DISCUZ_ROOT', substr(dirname(__FILE__), 0, -7));
define('MAGIC_QUOTES_GPC', get_magic_quotes_gpc());
!defined('CURSCRIPT') && define('CURSCRIPT', '');
if (PHP_VERSION < '4.1.0') {
$_GET =& $HTTP_GET_VARS;
$_POST =& $HTTP_POST_VARS;
$_COOKIE =& $HTTP_COOKIE_VARS;
$_SERVER =& $HTTP_SERVER_VARS;
$_ENV =& $HTTP_ENV_VARS;
$_FILES =& $HTTP_POST_FILES;
}
if (isset($_REQUEST['GLOBALS']) or isset($_FILES['GLOBALS'])) {
exit('Request tainting attempted.');
}
require_once DISCUZ_ROOT . './include/global.func.php';
getrobot();
if (defined('NOROBOT') && IS_ROBOT) {
exit(header("HTTP/1.1 403 Forbidden"));
}
foreach (array('_COOKIE', '_POST', '_GET') as $_request) {
foreach (${$_request} as $_key => $_value) {
$_key[0] != '_' && (${$_key} = daddslashes($_value));
}
}
if (!MAGIC_QUOTES_GPC && $_FILES) {
$_FILES = daddslashes($_FILES);
}
$charset = $dbs = $dbcharset = $forumfounders = $metakeywords = $extrahead = $seodescription = $mnid = '';
$plugins = $hooks = $admincp = $jsmenu = $forum = $thread = $language = $actioncode = $modactioncode = $lang = array();
$_DCOOKIE = $_DSESSION = $_DCACHE = $_DPLUGIN = $advlist = array();
require_once DISCUZ_ROOT . './config.inc.php';
define('DISCUZ_ROOT', substr(dirname(__FILE__), 0, -7));
define('MAGIC_QUOTES_GPC', get_magic_quotes_gpc());
!defined('CURSCRIPT') && define('CURSCRIPT', '');
if (PHP_VERSION < '4.1.0') {
$_GET =& $HTTP_GET_VARS;
$_POST =& $HTTP_POST_VARS;
$_COOKIE =& $HTTP_COOKIE_VARS;
$_SERVER =& $HTTP_SERVER_VARS;
$_ENV =& $HTTP_ENV_VARS;
$_FILES =& $HTTP_POST_FILES;
}
if (isset($_REQUEST['GLOBALS']) or isset($_FILES['GLOBALS'])) {
exit('Request tainting attempted.');
}
require_once DISCUZ_ROOT . './include/global.func.php';
define('ISROBOT', getrobot());
if (defined('NOROBOT') && ISROBOT) {
exit(header("HTTP/1.1 403 Forbidden"));
}
foreach (array('_COOKIE', '_POST', '_GET') as $_request) {
foreach (${$_request} as $_key => $_value) {
$_key[0] != '_' && (${$_key} = daddslashes($_value));
}
}
if (!MAGIC_QUOTES_GPC && $_FILES) {
$_FILES = daddslashes($_FILES);
}
$charset = $dbcharset = $forumfounders = $metakeywords = $extrahead = $seodescription = '';
$plugins = $hooks = $admincp = $jsmenu = $forum = $thread = $language = $actioncode = $modactioncode = $lang = array();
require_once DISCUZ_ROOT . './config.inc.php';
$_DCOOKIE = $_DSESSION = $_DCACHE = $_DPLUGIN = $advlist = array();