function log_list()
{
pagetop(gTxt('visitor_logs'));
extract(get_prefs());
safe_delete("txp_log", "`time` < date_sub(now(),interval " . $expire_logs_after . " day)");
safe_optimize("txp_log");
safe_repair("txp_log");
$page = gps('page');
$total = getCount('txp_log', "1");
$limit = 50;
$numPages = ceil($total / $limit);
$page = !$page ? 1 : $page;
$offset = ($page - 1) * $limit;
$nav[] = $page > 1 ? PrevNextLink("log", $page - 1, gTxt('prev'), 'prev') : '';
$nav[] = sp . small($page . '/' . $numPages) . sp;
$nav[] = $page != $numPages ? PrevNextLink("log", $page + 1, gTxt('next'), 'next') : '';
$rs = safe_rows_start("*, unix_timestamp(time) as stamp", "txp_log", "1 order by time desc limit {$offset},{$limit}");
if ($rs) {
echo startTable('list'), assHead('time', 'host', 'page', 'referrer');
$stamp = '';
while ($a = nextRow($rs)) {
extract($a);
if ($refer) {
$referprint = preg_replace("/^www\\./", "", chunk(htmlspecialchars($refer), 50));
$referprint = '<a href="http://' . htmlspecialchars($refer) . '">' . $referprint . '</a>';
} else {
$referprint = ' ';
}
$pageprint = preg_replace('/\\/$/', '', htmlspecialchars(substr($page, 1)));
$pageprint = $pageprint == '' ? '' : '<a href="' . htmlspecialchars($page) . '" target="_blank">' . chunk($pageprint, 50) . '</a>';
if ($method == 'POST') {
$pageprint = '<b>' . $pageprint . '</b>';
}
$fstamp = date("n/j g:i a", $stamp + tz_offset());
$hostprint = chunk($host, 40);
echo tr(td($fstamp) . td($hostprint) . td($pageprint) . td($referprint));
unset($refer, $referprint, $page, $pageprint);
}
echo '<tr><td colspan="4" align="right" style="padding:10px">', join('', $nav), "</td></tr>", endTable();
} else {
echo graf(gTxt('no_refers_recorded'), ' align="center"');
}
}
$file_tags = str_replace('_', " ", $field);
$multi_upload->upload_dir = $dir;
$multi_upload->message[] = $multi_upload->extra_text(4);
$multi_upload->do_filename_check = 'y';
$multi_upload->tmp_names_array = $_FILES['upload']['tmp_name'];
$multi_upload->names_array = $_FILES['upload']['name'];
$multi_upload->error_array = $_FILES['upload']['error'];
$multi_upload->replace = isset($_POST['replace']) ? $_POST['replace'] : 'n';
$multi_upload->extensions = array('.png', '.jpg', '.gif', '.zip', '.mp3', '.pdf', '.exe', '.rar', '.swf', '.vcf', '.css', '.dmg', '.php', '.doc', '.xls', '.xml', '.eps', '.rtf', '.iso', '.psd', '.txt', '.ppt', '.mov', '.flv', '.avi', '.m4v', '.mp4', '.gz', '.bz2', '.tar', '.7z', '.svg', '.svgz', '.lzma', '.sig', '.sign', '.js', '.rb', '.ttf', '.html', '.phtml', '.flac', '.ogg', '.wav', '.mkv', '.pls', '.m4a', '.xspf', '.ogv');
$multi_upload->upload_multi_files();
if (lastword($multi_upload->show_error_string()) == 'uploaded.') {
$sql = "file_name = '{$file_name}', file_extension = '{$file_ext}', file_type = '{$file_type}', tags = '{$file_tags}'";
$ok = safe_insert('pixie_files', $sql);
if (!$ok) {
$message = $lang['file_upload_error'];
} else {
$messageok = $multi_upload->show_error_string();
logme($messageok, 'no', 'folder');
safe_optimize('pixie_files');
safe_repair('pixie_files');
}
} else {
$message = $multi_upload->show_error_string();
}
print $message;
}
/* This file should be merged as an include or merged directly into another file instead of it being directly accessed like this. */
} else {
header('Location: ../../../');
exit;
}
if ($page_type == 'dynamic') {
safe_delete('pixie_dynamic_posts', "page_id = '{$empty}'");
safe_optimize('pixie_dynamic_posts');
if (isset($pixie_dynamic_posts)) {
safe_repair("{$pixie_dynamic_posts}");
}
} else {
if ($page_type == 'static') {
safe_update('pixie_core', "page_content = ''", "page_id = '{$empty}'");
safe_optimize('pixie_core');
safe_repair("{$pixie_core}");
} else {
$table = 'pixie_module_' . $page_name;
if (table_exists($table)) {
safe_query("TRUNCATE TABLE {$table}");
safe_optimize($table);
safe_repair($table);
}
}
}
if ($page_type == 'plugin') {
$word = $lang['settings_plugin'] . '.';
} else {
$word = $lang['page'];
}
$messageok = $lang['all_content_deleted'] . " " . $page_display_name . " {$word}";
logme($lang['all_content_deleted'] . " " . $page_display_name . " {$word}", 'yes', 'site');
}
}
if (isset($edit) && $edit) {
$rs = safe_row('*', 'pixie_core', "page_id = '{$edit}'");
include "../admin/modules/{$m}.php";
} else {
if ($x) {
/* Was : */
/* $x = ereg_replace('[^A-Za-z0-9]', "", $x); */
/* But ereg_replace() is depreciated. */
$x = preg_replace('[^A-Za-z0-9]', "", $x);
include "mod_{$x}.php";
} else {
if (isset($do) && $do == 'referral') {
echo "\n\t\t\t\t<div id=\"pixie_content\">\n\t\t\t\t\t<ul id=\"log_tools\">\n\t\t\t\t\t\t<li id=\"log_switch_latest\"><a href=\"?s=myaccount\" title=\"" . $lang['switch_to'] . " " . $lang['latest_activity'] . "\">" . $lang['switch_to'] . " " . $lang['latest_activity'] . "</a></li>\n\t\t\t\t\t</ul>\n\t\t\t\t\t<h2>" . $lang['latest_referrals'] . "</h2>\n\t\t\t\t\t<div id=\"logs_table\">\n\t\t\t\t\t\t<table class=\"tbl\" summary=\"" . $lang['latest_referrals'] . ' @ ' . str_replace('http://', "", $site_url) . "\">\n\t\t\t\t\t\t<thead>\n\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<th class=\"tbl_heading\" id=\"icon\"></th>\n\t\t\t\t\t\t\t\t<th class=\"tbl_heading\" id=\"when\">" . $lang['when'] . "</th>\n\t\t\t\t\t\t\t\t<th class=\"tbl_heading\" id=\"who\">" . $lang['who'] . "</th>\n\t\t\t\t\t\t\t\t<th class=\"tbl_heading\" id=\"from\">" . $lang['from'] . "</th>\n\t\t\t\t\t\t\t</tr>\n\n\t\t\t\t\t\t</thead>\n\t\t\t\t\t\t<tbody>\n\t\t\t\t\t";
} else {
echo "\n\t\t\t\t<div id=\"pixie_content\">\n\t\t\t\t\t<ul id=\"log_tools\">\n\t\t\t\t\t\t<li id=\"log_switch_referral\"><a href=\"?s=myaccount&do=referral\" title=\"" . $lang['switch_to'] . " " . $lang['latest_referrals'] . "\">" . $lang['switch_to'] . " " . $lang['latest_referrals'] . "</a></li>\n\t\t\t\t\t\t<li id=\"log_rss\"><a href=\"?s=myaccount&do=rss&user="******"\" title=\"" . $lang['feed_subscribe'] . "\">" . $lang['feed_subscribe'] . "</a></li>\n\t\t\t\t\t</ul>\n\t\t\t\t\t<h2>" . $lang['latest_activity'] . "</h2>\n\t\t\t\t\t<div id=\"logs_table\">\n\t\t\t\t\t\t<table class=\"tbl\" summary=\"" . $lang['latest_activity'] . " @ " . str_replace('http://', "", $site_url) . "\">\n\t\t\t\t\t\t<thead>\n\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<th class=\"tbl_heading\" id=\"icon\"></th>\n\t\t\t\t\t\t\t\t<th class=\"tbl_heading\" id=\"when\">" . $lang['when'] . "</th>\n\t\t\t\t\t\t\t\t<th class=\"tbl_heading\" id=\"who\">" . $lang['who'] . "</th>\n\t\t\t\t\t\t\t\t<th class=\"tbl_heading\" id=\"what\">" . $lang['what'] . "</th>\n\t\t\t\t\t\t\t</tr>\n\n\t\t\t\t\t\t</thead>\n\t\t\t\t\t\t<tbody>\n\t\t\t\t\t";
}
safe_delete('pixie_log', "`log_time` < date_sub(utc_timestamp(),interval {$GLOBALS['logs_expire']} day)");
safe_optimize('pixie_log');
safe_repair('pixie_log');
if (isset($do) && $do == 'referral') {
$rs = safe_rows_start('*, unix_timestamp(log_time) as stamp', 'pixie_log', "log_type = 'referral' order by log_time desc limit 30");
} else {
$rs = safe_rows_start('*, unix_timestamp(log_time) as stamp', 'pixie_log', "log_type = 'system' order by log_time desc limit 30");
}
if ($rs) {
$counter = 0;
while ($a = nextRow($rs)) {
$counter++;
extract($a);
$logunix = returnUnixtimestamp($log_time);
$time = safe_strftime($date_format, $logunix);
if ($log_important == 'yes') {
$trclass = 'logimportant';
$ok = safe_update('pixie_settings', "site_name = '{$sitename}', \r\n\t\t\t\t\t\t\t\t\tsite_url = '{$url}', \r\n\t\t\t\t\t\t\t\t\tsite_keywords = '{$keywords}', \r\n\t\t\t\t\t\t\t\t\tsite_author = '{$site_auth}',\r\n\t\t\t\t\t\t\t\t\tsite_copyright = '{$site_cright}',\r\n\t\t\t\t\t\t\t\t\tdefault_page = '{$default}',\r\n\t\t\t\t\t\t\t\t\tclean_urls = '{$cleanurls}'", "settings_id ='1'");
}
if (!$ok) {
$message = $err[0];
if (!$message) {
$message = $lang['error_save_settings'];
}
$site_name = $sitename;
$site_url = $url;
$site_keywords = $keywords;
$site_author = $site_auth;
$site_copyright = $site_cright;
$default_page = $default;
} else {
if (isset($table_name)) {
safe_optimize("{$table_name}");
safe_repair("{$table_name}");
}
$messageok = $lang['ok_save_settings'];
$prefs = get_prefs();
extract($prefs);
}
} else {
$prefs = get_prefs();
extract($prefs);
}
if (in_array('name', $scream)) {
$name_style = 'form_highlight';
}
if (in_array('url', $scream)) {
$url_style = 'form_highlight';
?>
</li>
<li><img src="admin/theme/images/icons/user.png" alt="Client" /> <?php
print $lang['help_settings_user_client'];
?>
</li>
<li><img src="admin/theme/images/icons/user.png" alt="User" /> <?php
print $lang['help_settings_user_user'];
?>
</li>
</ul>
</div>
</div>
<?php
echo "\t\t\t\t<div id=\"pixie_content\">\n";
safe_optimize('pixie_users');
safe_repair('pixie_users');
echo "\t\t\t\t\t<h2>" . $lang['nav2_users'] . "</h2>\n\t\t\t\t\t<p>" . $lang['user_info'] . "</p>";
$rs = safe_rows('*', 'pixie_users', 'privs >= 2 order by realname asc');
if ($rs) {
echo "\n\t\t\t\t\t<div id=\"user_admins\">\n\t\t\t\t\t\t<h3>Administrators</h3>\n";
// last seen "commenting on: XXXXX & DATE"
$num = count($rs);
$i = 0;
while ($i < $num) {
$out = $rs[$i];
$user_name = $out['user_name'];
$realname = $out['realname'];
$email = $out['email'];
$privs = $out['privs'];
$userid = $out['user_id'];
function remove_lang($lang, $debug = '')
{
$lang = doSlash($lang);
$where = " `lang`='{$lang}'";
@safe_delete('txp_lang', $where, $debug);
@safe_optimize('txp_lang', $debug);
}
exit;
}
global $l10n_vars;
global $l10n_painters;
$l10n_vars = array();
$l10n_mappings = null;
$l10n_painters = array();
if ($l10n_view->installed()) {
#
# Detect the dirty-flag and re-build tables...
#
global $prefs;
if (@$prefs[L10N_DIRTY_FLAG_VARNAME] === 'DIRTY') {
# Ensure new indexes (indices) are present in case of upgade...
_l10n_check_index();
safe_optimize('textpattern');
# Iterate over the site languages, rebuilding the tables...
$langs = MLPLanguageHandler::get_site_langs();
foreach ($langs as $lang) {
_l10n_generate_lang_table($lang);
_l10n_generate_localise_table_fields($lang);
}
# Clear the dirty flag...
_l10n_update_dirty_flag('');
}
#
# Observors...
#
register_callback('_l10n_observe_glz_custom_fields', 'glz_custom_fields');
#
# Article handlers...
}
}
}
}
}
if (isset($sql)) {
} else {
$sql = NULL;
}
$sql = substr($sql, 0, strlen($sql) - 1) . "";
//echo $sql; //view the SQL for current form save
if (!isset($error)) {
if (isset($submit_new) && $submit_new) {
$ok = safe_insert($table_name, $sql);
$idofsave = mysql_insert_id();
safe_optimize($table_name);
safe_repair($table_name);
if (!$ok) {
$message = $lang['unknown_error'];
logme($message, 'no', 'error');
} else {
if (isset($s) && $s == 'settings' && $page_type == 'dynamic') {
$sql = "`page_id` = '{$idofsave}', `posts_per_page` = '10', `rss` = 'yes'";
safe_insert('pixie_dynamic_settings', $sql);
}
if ($table_name == 'pixie_core') {
$output = safe_field('page_display_name', 'pixie_core', "page_id='{$idofsave}'");
$icon = 'site';
$messageok = $lang['saved_new_page'] . ": {$output}.";
} else {
$ptitle = $title;
