public function edit_item()
{
$sql = new MySQLObject();
if ($sql->query("\r\nSELECT `header`,`link`,`show`\r\nFROM " . $sql->table('menu') . "\r\nWHERE (`iid` = " . intval($_GET['iid']) . ")") && $sql->num() > 0) {
$item = $sql->fetch_one();
global $tpl, $cfg;
$tpl->assign(array('ITEM.HEADER' => $item->header, 'ITEM.LINK' => $item->link, 'ITEM.SHOW_TRUE' => $item->show == 1 ? $cfg['tpl']['checked'] : '', 'ITEM.SHOW_FALSE' => $item->show == 0 ? $cfg['tpl']['checked'] : ''));
}
}
public function fetch()
{
if (!$this->made) {
return array();
}
$start = $this->current_page * $this->per_page - $this->per_page;
$query = $this->query . " LIMIT " . $start . "," . $this->per_page;
$sql = new MySQLObject();
if (!$sql->query($query)) {
return array();
}
return $sql->fetch();
}
public function connect($host, $user, $password, $dbname)
{
global $syslog;
if (!$this->connected) {
if (!@mysql_connect($host, $user, $password)) {
$syslog->error('mysql', 'mysql_connect', mysql_error());
die;
} else {
$syslog->success('mysql', 'mysql_connect', $user . '@' . $host);
if (!@mysql_select_db($dbname)) {
$syslog->error('mysql', 'mysql_select_db', mysql_error());
die;
} else {
$this->connected = true;
$this->dbname = $dbname;
$syslog->success('mysql', 'mysql_select_db', $dbname);
$sql = new MySQLObject();
$sql->query('SET NAMES utf8');
$sql->query('SET CHARACTER SET utf8');
echo mysql_error();
}
}
}
}
public function menu_add_items()
{
$items = array();
$sql = new MySQLObject();
if ($sql->query("SELECT `pid`,`header` FROM " . $sql->table('pages') . " ORDER BY `slug` ASC")) {
global $cfg;
foreach ($sql->fetch() as $page) {
$items[] = array('ADD_TEXT' => $page->header, 'ADD_LINK' => './action.php?c=menu&mode=add&module=pages&pid=' . $page->pid);
}
}
return $items;
}
class module_updates_global
{
}
global $mod;
$mod->modules[$MODULE_NAME] = new module_updates_global();
if (defined('IN_UPDATES_GLOBAL') && IN_UPDATES_GLOBAL) {
if (isset($_GET['function'])) {
switch ($_GET['function']) {
case 'check_for_updates':
if (isset($_POST['XML'])) {
include './app/lib/simplexmlextended.class.php';
$xml = new SimpleXMLElementExtended(html_entity_decode(stripslashes($_POST['XML'])));
$modules = $xml->xpath('//module');
$count = count($modules);
if ($count > 0) {
$sql = new MySQLObject();
$query = "\r\nSELECT `code`,`type`,`date`,`name`,`modules`\r\nFROM " . $sql->table('updates_global') . "\r\nWHERE\r\n(";
$i = 0;
foreach ($modules as $module) {
$query .= "\r\n\t`modules` LIKE '%" . $module . "%'";
if ($i < $count - 1) {
$query .= " OR ";
}
$i++;
}
$query .= "\r\n)\r\nORDER BY `date` ASC";
if (!$sql->query($query)) {
echo 'ERROR';
} else {
if (!$sql->num()) {
echo 'NO_UPDATES';
function mainmenu_getorder()
{
$sql = new MySQLObject();
if ($sql->query("SELECT `order` FROM " . $sql->table('menu') . " ORDER BY `order` DESC LIMIT 0,1")) {
if ($sql->num() > 0) {
$order = $sql->fetch_one();
return $order->order;
} else {
return 0;
}
} else {
return false;
}
}
public function _module_config($query)
{
global $tpl, $cfg;
$sql = new MySQLObject();
if ($sql->query($query)) {
foreach ($sql->fetch() as $item) {
switch ($item->type) {
case 'string':
$tpl->assign('CONFIG.' . strtoupper($item->name), $item->value);
break;
case 'bool':
$tpl->assign(array('CONFIG.' . strtoupper($item->name) . '.TRUE.CHECKED' => intval($item->value) == 1 ? $cfg['tpl']['checked'] : '', 'CONFIG.' . strtoupper($item->name) . '.FALSE.CHECKED' => intval($item->value) == 0 ? $cfg['tpl']['checked'] : ''));
break;
}
}
}
}
public function group_edit()
{
global $cfg, $q;
// the total count of all permissions
$count = 0;
// get the changed permissions
foreach ($cfg['permissions'] as $module => $names) {
foreach ($names as $name => $values) {
if (isset($_POST['group_permissions'][$module][$name])) {
$out[$module][$name] = implode(';', $_POST['group_permissions'][$module][$name]);
} else {
$out[$module][$name] = '';
}
$count++;
}
}
// get the old permissions
$sql = new MySQLObject();
$sql->query("SELECT `name`,`module` FROM " . $q->table('permissions') . " WHERE (`group` = " . intval($_GET['gid']) . ")");
$to_update = array();
$to_update_count = 0;
foreach ($sql->fetch() as $perm) {
$to_update[$perm->module][$perm->name] = true;
$to_update_count++;
}
// update/insert the changed permissions
$query = "INSERT INTO " . $q->table('permissions') . " (`name`,`group`,`module`,`value`) VALUES";
$i = 0;
foreach ($out as $module => $names) {
foreach ($names as $name => $value) {
if (isset($to_update[$module][$name])) {
$sql->query("UPDATE " . $q->table('permissions') . " SET `value` = '" . $sql->escape($value) . "' WHERE (`module` = '" . $module . "' AND `name` = '" . $name . "' AND `group` = " . intval($_GET['gid']) . ")");
} else {
$query .= " ('" . $name . "'," . intval($_GET['gid']) . ",'" . $module . "','" . $sql->escape($value) . "')";
if ($i != $count - $to_update_count) {
$query .= ",";
}
# !! echo($i . $count . $to_update_count);
$i++;
}
}
}
if ($i != 0) {
$sql->query($query);
}
global $syslog, $tpl, $action;
if (!$action) {
$action = true;
$tpl->assign('REDIRECT_LOCATION', './acp.php?c=users');
$tpl->load('alert_success');
$tpl->inc('alert_success');
$tpl->assign('ALERT_SUCCESS_MESSAGE', '{L_ALERT_USERS_GROUP_EDIT_SUCCESS}');
}
}
include_once './app/subsystems/syslog.php';
include_once './app/subsystems/mysql.php';
include_once './app/subsystems/template.php';
include_once './app/subsystems/lang.php';
include_once './app/subsystems/modules.php';
// mysql: connection
$q->connect('localhost', 'blackpig', 'vGVbTen9y*:Ue7PW', 'blackpig');
$q->prefix = 'geecms_';
// mysql: select the configuration
$cfg = array();
$cfg['etc'] = array();
$cfg['tpl'] = array();
if (defined('IN_IMAGES') && IN_IMAGES) {
$cfg['tpl']['images'] = array();
}
$sql = new MySQLObject();
$sql->query("SELECT `name`,`value`,`assign` FROM " . $q->table('config') . "");
foreach ($sql->fetch() as $item) {
$cfg['etc'][$item->name] = $item->value;
if (intval($item->assign) == true) {
$tpl->assign($item->name, $item->value);
}
}
unset($sql);
define('SITE_ROOT_PATH', $cfg['etc']['SITE_ROOT_PATH']);
// load the libraries
include_once './app/lib/pages.class.php';
include_once './app/lib/js/fckeditor/fckeditor.php';
// load all
$tpl->load_config();
$lang->load();
\'LINK\' => \'./acp.php?c=updater\',
\'HEADER\' => \'{L_MODULE_UPDATER} <img src="./images.php?image=module_updater_small" alt="" style="position: absolute; top: 6px; right: 10px;" />\',
\'ACTIVE\' => (isset($_GET[\'c\']) && $_GET[\'c\'] == \'updater\')
? $cfg[\'tpl\'][\'class_active\'] : \'\'
);';
if (!isset($_GET['c'])) {
global $cfg;
$cfg['installed_modules'][] = array('MODULE_HEADER' => '{L_MODULE_UPDATER}', 'MODULE_DESCRIPTION' => '{L_MODULE_UPDATER_DESCRIPTION}', 'MODULE_LINK' => './acp.php?c=updater', 'MODULE_IMAGE' => './images.php?image=module_updater');
} elseif ($_GET['c'] == 'updater') {
$tpl->inc('updater', 1);
}
}
if (defined('IN_AJAXREQUEST') && IN_AJAXREQUEST && isset($_GET['c'], $_GET['function']) && $_GET['c'] == 'updater') {
switch ($_GET['function']) {
case 'check_for_updates':
$sql = new MySQLObject();
if (!$sql->query("SELECT `code` FROM " . $sql->table('updates') . " ORDER BY `date` DESC")) {
echo 'ERROR';
} else {
$xml = '<?xml version="1.0" encoding="utf-8"?>
<root>
<modules>';
foreach ($mod->modules as $name => $module) {
$xml .= '
<module>' . $name . '</module>';
}
$xml .= '
</modules>
<installed>';
foreach ($sql->fetch() as $update) {
$xml .= '
