www.gusucode.com > Tatter Tools 0.961 SE GB2312 简体中文版 > upload/admin/setting.php
<?
include("../inc_global.php");
include("../inc_function.php");
check_authority();
if ($HTTP_POST_VARS[mode] == "drop") {
include("../inc_scheme.php");
drop_scheme();
header("Location: setting.php");
exit;
}
if ($mode == "export") {
/*
分卷备份 by 冬天来了 @ 美刻时空
http://www.mecee.com
*/
$tables = array("t3_".$dbid, "t3_".$dbid.'_ct1', "t3_".$dbid.'_ct2', "t3_".$dbid.'_files', "t3_".$dbid.'_reply', "t3_".$dbid.'_trackback', "t3_".$dbid.'_tblog', "t3_".$dbid.'_keyword', "t3_".$dbid.'_keyword_files',
"t3_".$dbid.'_link', "t3_".$dbid.'_rss', "t3_".$dbid.'_rss_group', "t3_".$dbid.'_rss_item', "t3_".$dbid.'_setting', "t3_".$dbid.'_count',
"t3_".$dbid.'_referlog', "t3_".$dbid.'_referstat', "t3_".$dbid.'_guest', "t3_".$dbid.'_guest_reply', "t3_".$dbid.'_guest_icon');
if(!$filename) {
error_process('02C1');
}
$timestamp = time();
$time = gmdate("Y-m-d H:i:s", $timestamp);
$volume = intval($volume) + 1;
$idstring = '# Identify: '.base64_encode("$timestamp,$method,$volume,0.961SE")."\n";
mysql_query("SET SQL_QUOTE_SHOW_CREATE = 0");
$sqldump = '';
$tableid = $tableid ? $tableid - 1 : 0;
$startfrom = intval($startfrom);
for($i = $tableid; $i < count($tables) && strlen($sqldump) < $sizelimit * 1000; $i++) {
$sqldump .= sqldumptable($tables[$i], $startfrom, strlen($sqldump));
$startfrom = 0;
}
$tableid = $i;
$dumpfile = substr($filename, 0, strrpos($filename, '.'))."-%s".strrchr($filename, '.');
if(trim($sqldump)) {
$sqldump = "$idstring".
"#<?exit()?>\n".
"# MeCee Multi-Volume Data Dump Vol.$volume\n".
"# Version: Tatter Tools 0.961 SE\n".
"# Time: $time\n".
"# Table Prefix: $dbid\n".
"# Alliance website : Meyu.Net\n".
"# Please visit our website for newest infomation about MeCee.com\n".
"# --------------------------------------------------------\n\n\n".
$sqldump;
@$fp = fopen(($method == 'multivol' ? sprintf($dumpfile, $volume) : $filename), 'w');
@flock($fp, 2);
if(@!fwrite($fp, $sqldump)) {
@fclose($fp);
error_process('02C2');
} else {
msg ("分卷备份：数据文件 #$volume 成功创建，程序将自动继续。<meta http-equiv=\"refresh\" content=\"2;url=setting.php?mode=export&type=$type&saveto=server&filename=$filename&method=multivol&sizelimit=$sizelimit&volume=$volume&tableid=$tableid&startfrom=$startrow&exportsubmit=yes\">");
}
} else {
$volume--;
$filelist = '<ul>';
for($i = 1; $i <= $volume; $i++) {
$filename = sprintf($dumpfile, $i);
$filelist .= "<li><a href=\"$filename\">$filename</a></li>\n";
}
$filelist .= '</ul>';
msg ("恭喜您，全部 $volume 个备份文件成功创建，备份完成。\n<br>$filelist");
}
}
if ($mode == "update") {
if ($perm_rp == "on") $perm_rp = 1;
if ($perm_tb == "on") $perm_tb = 1;
if ($imagefile || $_FILES["imagefile"][size]) {
if (!$imagefile) $imagefile = $_FILES["imagefile"][tmp_name];
if (!$imagefile_name) $imagefile_name = $_FILES["imagefile"][name];
$imagefile_name = str_replace("'", "", $imagefile_name);
// list($width,$height) = getimagesize($imagefile);
// if (!$width) error_process("02B2");
$t_path = $r_attach_path."image/";
force_rmdirs($t_path);
mkdir($t_path, 0777);
chmod($t_path, 0777);
$attachname = get_timestamp3().substr($imagefile_name, strrpos($imagefile_name, "."));
move_uploaded_file($imagefile, $t_path.$attachname);
list($width,$height) = getimagesize($t_path.$attachname);
if (!$width) error_process("02B2");
$add_query = "
, imagefile = '$attachname'
, imagelabel = '$imagefile_name'
, width = '$width'
, height = '$height'
";
}
put_query("
update t3_".$dbid."_setting set
user_nick = '$user_nick',
title = '$title',
description = '$description',
article_cnt = '$article_cnt',
keyword_cnt = '$keyword_cnt',
xml_cnt = '$xml_cnt',
perm_rp = '$perm_rp',
perm_tb = '$perm_tb'
, ip_block = '$ip_block'
, box1_style = '$box1_style'
, box2_style = '$box2_style'
, box3_style = '$box3_style'
, box4_style = '$box4_style'
, rss_public = '$rss_public'
$add_query
");
$p_rss_public = $rss_public;
$p_user_nick = $user_nick;
$p_title = $title;
$p_description = $description;
update_xml();
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<meta name="keywords" content="TT,TatterTools,Skin,php">
<meta name="description" content="Meyu，梦游，华人中文网">
<meta name="generator" content="TatterTools中文BLOG">
<meta name="MSSmartTagsPreventParsing" content="TRUE">
<meta http-equiv="MSThemeCompatible" content="Yes">
</head>
<script type="text/javascript">
alert('系统相关设置修改完毕！\t');
location.href = 'setting.php';
</script>
<?
}
admin_header("onclick_image_checkbox(document.setting, document.setting.image_checkbox);");
?>
<script type="text/javascript">
function onclick_image_checkbox(form, obj) {
if (obj.checked) {
form.imagefile.disabled = false;
form.imagefile.style.backgroundColor = '#FFFFFF';
} else {
form.imagefile.disabled = true;
form.imagefile.style.backgroundColor = '#E0E0E0';
}
}
function onclick_update(form) {
if (isNull(form.user_nick, '请输入你的姓名')) return false;
if (isNull(form.title, '请输入您的网志名称')) return false;
if (isNull(form.description, '请输入您的网志描述')) return false;
form.submit();
}
</script>
<form method="post" enctype="multipart/form-data" name="setting" action="<?=$PHP_SELF?>">
<input type="hidden" name="temp">
<input type="hidden" name="mode" value="update">
<table cellpadding="0" cellspacing="0" width="1003"><tr>
<td width="430" valign="top" style="padding:10 5 5 5">
<table width="100%" style="margin-bottom:3"><tr>
<td width="24" align="right"><img src="../images/num_12.gif" height="17"></td>
<td width="9"><img src="../images/ver_01.gif" width="9" height="17"></td>
<td><img src="../images/cap_12.gif" height="17"></td>
</tr></table>
<? print_content_line(); ?>
<table class="content_back1" cellpadding="0" cellspacing="0" width="100%"><tr>
<td style="padding:10 0 10 0">
<table cellpadding="0" cellspacing="0"><tr>
<td width="90" align="right" style="padding-top:2">作者姓名 :: </td>
<td><input class="text" type="text" name="user_nick" value="<?=$p_user_nick?>" maxlength="32"></td>
</tr></table>
<table cellpadding="0" cellspacing="0" style="margin-top:5"><tr>
<td width="90" align="right" style="padding-top:2">修改密码 :: </td>
<td><img class="ib" src="../images/b_advanced.gif" onclick="window.open('setting_account.php','s_ac','width=397,height=172,location=0,menubar=0,resizable=0,scrollbars=0,status=0,toolbar=0')"></td>
</tr></table>
<? input_block(); ?>
<table cellpadding="0" cellspacing="0" style="margin-top:10"><tr>
<td width="90" align="right" style="padding-top:2">网志名称 :: </td>
<td><input class="text" type="text" name="title" value="<?=$p_title?>" maxlength="128" style="width:230"></td>
</tr></table>
<table cellpadding="0" cellspacing="0" style="margin-top:5"><tr>
<td width="90" align="right" style="padding-top:2">网志描述 :: </td>
<td><input class="text" type="text" name="description" value="<?=$p_description?>" maxlength="256" style="width:230"></td>
</tr></table>
<table cellpadding="0" cellspacing="0" style="margin:5 0 10 0"><tr>
<td width="90" align="right" valign="top">个人头像 :: </td>
<td>
<table cellpadding="0" cellspacing="0"><tr>
<td style="padding-left:5">当前图片 </td>
<td>
<?
if ($p_imagefile) {
?>
(<font color="#000099"><?=$p_imagelabel?></font>)</td>
<td style="padding-left:5"><img class="ib" src="../images/b_view.gif" width="53" height="17" onclick="window.open('../image_pop.php?imagefile=<?=$s_attach_path."image/".$p_imagefile?>&width=<?=$p_width?>&height=<?=$p_height?>','s_im','width=<?=$p_width?>,height=<?=$p_height?>,location=0,menubar=0,resizable=0,scrollbars=0,status=0,toolbar=0')"><br>
<?
} else {
?>
(没有上传图片)
<?
}
?>
</td>
</tr></table>
<table><tr>
<td><input type="checkbox" name="image_checkbox" onclick="onclick_image_checkbox(setting, this)"></td>
<td style="padding-top:2">新建上传图片或更新图片</td>
</tr></table>
<input type="file" class="button" name="imagefile" size="36">
</td>
</tr></table>
<? input_block(); ?>
<table width="100%" border="0">
<tr>
<td width="50%">
<table cellpadding="0" cellspacing="0" style="margin-top:10">
<tr>
<td width="90" align="right" style="padding-top:2">模板选项 :: </td>
<td><img class="ib" src="../images/b_advanced.gif" onclick="window.open('setting_skin.php','s_sk','width=400,height=560,location=0,menubar=0,resizable=0,scrollbars=0,status=0,toolbar=0')"></td>
</tr>
</table>
</td>
<td width="50%">
<table cellpadding="0" cellspacing="0" style="margin-top:10">
<tr>
<td width="90" align="right" style="padding-top:2">表情选项 :: </td>
<td><img class="ib" src="../images/b_advanced.gif" onclick="ShowModeWin('setting_emoticon.php','s_ei','Center','center','480','280','0','0','0','0','0','0');"></td>
</tr>
</table></td>
</tr>
<tr>
<td><table cellpadding="0" cellspacing="0" style="margin:05 0 10 0;">
<tr>
<td width="90" align="right" style="padding-top:2">菜单选项 :: </td>
<td><img class="ib" src="../images/b_advanced.gif" onclick="window.open('setting_tree.php','s_tr','width=580,height=330,location=0,menubar=0,resizable=0,scrollbars=0,status=0,toolbar=0')"></td>
</tr>
</table></td>
<td><table cellpadding="0" cellspacing="0" style="margin:05 0 10 0;">
<tr>
<td width="90" align="right" style="padding-top:2">留言选项 :: </td>
<td><img class="ib" src="../images/b_advanced.gif" onclick="ShowModeWin('setting_guest.php','s_gb','Center','center','800','600','0','0','0','0','0','0');"></td>
</tr>
</table></td>
</tr>
</table>
<? input_block(); ?>
<table style="margin-top:10"><tr>
<td style="padding-top:2;padding-left:20">:: 网志管理每页显示</td>
<td>
<select name=article_cnt>
<? for ($i=1;$i<=30;$i++) { ?><option value="<?=$i?>" <? if ($p_article_cnt == $i) print "selected"; ?>><?=$i?></option><? }?>
</select>
</td>
<td style="padding-top:2">篇资料.</td>
</tr></table>
<table style="margin-top:5"><tr>
<td style="padding-top:2;padding-left:20">:: 关键字管理每页显示</td>
<td>
<select name="keyword_cnt">
<? for ($i=1;$i<=30;$i++) { ?><option value="<?=$i?>" <? if ($p_keyword_cnt == $i) print "selected"; ?>><?=$i?></option><? }?>
</select>
</td>
<td style="padding-top:2">篇资料.</td>
</tr></table>
<table style="margin:5 0 0 0"><tr>
<td style="padding-top:2;padding-left:20">:: 提供订阅的 RSS (XML) 网志文章显示最新的</td>
<td>
<select name="xml_cnt">
<? for ($i=5;$i<=30;$i=$i+5) { ?><option value="<?=$i?>" <? if ($p_xml_cnt == $i) print "selected"; ?>><?=$i?></option><? }?>
</select>
</td>
<td style="padding-top:2">篇资料.</td>
</tr></table>
<table style="margin:5 0 10 0"><tr>
<td style="padding-top:2;padding-left:20">:: XML给其它站订阅</td>
<td>
<select name="rss_public">
<option value="1">提供</option>
<option value="0" <? if (!$p_rss_public) print "selected";?>>不提供</option>
</select>
</td>
<td style="padding-top:2">最新发表的网志文章.</td>
</tr></table>
<? input_block(); ?>
<table cellpadding="0" cellspacing="0" style="margin:10 0 15 0"><tr>
<td width="90" align="right" valign="top" style="padding-top:2">IP拦截 :: </td>
<td style="padding:2 0 0 0">
来自以下 IP 不允许发表回复或留言<br>
设定 IP 时请用(,) 来做区隔.<br>
例: 000.000.000.000, 111.111.111.111, 222...<br>
<textarea name="ip_block" rows="4" style="width:290;margin-top:5"><?=$p_ip_block?></textarea><br>
</td>
</tr></table>
<? input_block(); ?>
<table cellpadding="0" cellspacing="0" style="margin-top:10"><tr>
<td width="90" align="right" style="padding-top:2">文字框样式 :: </td>
<td style="padding-top:2">在这里可以自定义撰写文章时的文字框样式功能.</td>
</tr></table>
<table cellpadding="0" cellspacing="0" style="margin-top:5"><tr>
<td width="90" align="right" style="padding-top:2">样式1 </td>
<td><input class="text" type="text" name="box1_style" value="<?=$p_box1_style?>" maxlength="256" style="width:290"></td>
</tr></table>
<table cellpadding="0" cellspacing="0" style="margin-top:5"><tr>
<td width="90" align="right" style="padding-top:2">样式2 </td>
<td><input class="text" type="text" name="box2_style" value="<?=$p_box2_style?>" maxlength="256" style="width:290"></td>
</tr></table>
<table cellpadding="0" cellspacing="0" style="margin-top:5"><tr>
<td width="90" align="right" style="padding-top:2">样式3 </td>
<td><input class="text" type="text" name="box3_style" value="<?=$p_box3_style?>" maxlength="256" style="width:290"></td>
</tr></table>
<table cellpadding="0" cellspacing="0" style="margin-top:5"><tr>
<td width="90" align="right" style="padding-top:2">样式4 </td>
<td><input class="text" type="text" name="box4_style" value="<?=$p_box4_style?>" maxlength="256" style="width:290"></td>
</tr></table>
<div align="center" style="margin-top:10"><img class="ib" src="../images/b_save.gif" width="53" height="17" onclick="onclick_update(setting);"></div>
</td>
</tr></form></table>
</td>
<td width="23"></td>
<td valign="top" style="padding-top:10">
<table width="100%" style="margin-bottom:3"><tr>
<td width="24" align="right"><img src="../images/num_16.gif" height="17"></td>
<td width="9"><img src="../images/ver_01.gif" width="9" height="17"></td>
<td><img src="../images/cap_16.gif" width="149" height="17"></td>
</tr></table>
<? print_content_line(); ?>
<table class="content_back1" cellpadding="0" cellspacing="0" width="100%"><tr>
<td style="padding:10">
<?
$tt = 0; $tr = 0; $misc = 0;
$sql = "show table status";
$res = mysql_query($sql);
while($row = @mysql_fetch_assoc($res)) $row_set[] = $row;
for($i=0; $i<count($row_set); $i++) {
foreach($row_set[$i] as $k => $v) { $k = strtolower($k); $$k = $v; }
$table_length = $data_length + $index_length;
// print "$create_time, $update_time, $name<br>";
if ($name == "t3_$dbid") $tt += $table_length;
else if ($name == "t3_$dbid"."_comment") $tt += $table_length;
else if ($name == "t3_$dbid"."_count") $tt += $table_length;
else if ($name == "t3_$dbid"."_ct1") $tt += $table_length;
else if ($name == "t3_$dbid"."_ct2") $tt += $table_length;
else if ($name == "t3_$dbid"."_files") $tt += $table_length;
else if ($name == "t3_$dbid"."_keyword") $tt += $table_length;
else if ($name == "t3_$dbid"."_keyword_files") $tt += $table_length;
else if ($name == "t3_$dbid"."_link") $tt += $table_length;
else if ($name == "t3_$dbid"."_reply") $tt += $table_length;
else if ($name == "t3_$dbid"."_setting") $tt += $table_length;
else if ($name == "t3_$dbid"."_tblog") $tt += $table_length;
else if ($name == "t3_$dbid"."_trackback") $tt += $table_length;
else if ($name == "t3_$dbid"."_guest") $tt += $table_length;
else if ($name == "t3_$dbid"."_guest_reply") $tt += $table_length;
else if ($name == "t3_$dbid"."_guest_icon") $tt += $table_length;
else if ($name == "t3_$dbid"."_referlog") $tt += $table_length;
else if ($name == "t3_$dbid"."_referstat") $tt += $table_length;
else if ($name == "t3_$dbid"."_cnt_log") $tt += $table_length;
else if ($name == "t3_$dbid"."_rss") $tr += $table_length;
else if ($name == "t3_$dbid"."_rss_group") $tr += $table_length;
else if ($name == "t3_$dbid"."_rss_item") $tr += $table_length;
else if ($name == "t3_$dbid"."_rss_rel_group") $tr += $table_length;
else if ($name == "t3_$dbid"."_rss_setting") $tr += $table_length;
else $misc += $table_length;
}
?>
<table cellpadding="0" cellspacing="0"><tr>
<td width="80" align="right" style="padding-top:2">MYSQL数据库总计使用 :: </td>
<td style="padding-left:5;padding-top:2;color:#000099"> <?=get_filesize($tt + $tr + $misc)?></td>
<td class="h1" style="padding-left:5;">( tatter blog <?=get_filesize($tt)?> | tatter reader <?=get_filesize($tr)?> | ? <?=get_filesize($misc)?> )</td>
</tr></table>
</td>
</tr></table>
<table width="100%" style="margin:30 0 3 0"><tr>
<td width="24" align="right"><img src="../images/num_17.gif" height="17"></td>
<td width="9"><img src="../images/ver_01.gif" width="9" height="17"></td>
<td><img src="../images/cap_17.gif" height="17"></td>
</tr></table>
<? print_content_line(); ?>
<table class="content_back1" cellpadding="0" cellspacing="0" width="100%"><tr>
<td style="padding:10 0 10 0">
<table cellpadding="0" cellspacing="0" width="100%" class="content_back1">
<form name="backup" method="post" action="setting.php?mode=export" target="new">
<input type="hidden" name="method" value="multivol">
<tr>
<td style="padding-left:10">长度限制(kb)</td>
<td><input type="text" size="60" name="sizelimit" value="2048"></td>
</tr>
<tr>
<td style="padding-left:10">备份文件名</td>
<td><input type="text" size="60" name="filename" value="./backup/<?=date('md').'_'.random(8)?>.php" onclick="alert('注意：\n\n数据文件保存在服务器的可见目录下，其他人有 \n可能下载得到这些文件，这是不安全的。因此请 \n在使用随机文件名的同时，适时删除备份文件。');"></td>
</tr>
<tr>
<td width="70" style="padding-left:20"><a href="###" onclick="backup.submit();"><img class="ib" src="../images/b_db_export.gif"></a></td>
<td style="padding-left:10">
按左边的按钮来备份MYSQL. 请按照提示把文件存放在安全的地方.<br>
<b>注意:</b> 这个备份的档案只有备份mysql资料库内容. <br> 不包含<b>config.php</b>与所有上传的档案.<br>
<b>config.php</b>配置数据库文件与所有上传的文件必须使用 FTP软件下载..
</td>
</tr></form></table>
</td>
</tr></table>
<table width="100%" style="margin:30 0 3 0"><tr>
<td width="24" align="right"><img src="../images/num_18.gif" height="17"></td>
<td width="9"><img src="../images/ver_01.gif" width="9" height="17"></td>
<td><img src="../images/cap_18.gif" height="17"></td>
</tr></table>
<? print_content_line(); ?>
<table class="content_back1" cellpadding="0" cellspacing="0" width="100%"><tr>
<td style="padding:10 0 10 0">
<table cellpadding="0" cellspacing="0" width="100%"><tr>
<td width="70" style="padding-left:20"><img class="ib" src="../images/b_db_import.gif" width="57" height="53" onclick="window.open('setting_import.php','setting_import','width=500,height=400,location=0,menubar=0,resizable=0,scrollbars=0,status=0,toolbar=0')"></td>
<td style="padding-left:10">
按左边的按钮来还原资料库. <br>
<b>小心:</b> 还原备份的资料库将会<b>删除</b>现下的资料库(管理密码除外)! <br>在执行动作前请务必确认!<br>
<b>注意:</b> 确定要还原的版本与现之使用的版本编码是否一致!<br>
</td>
</tr></table>
</td>
</tr></table>
<table width="100%" style="margin:30 0 3 0"><tr>
<td width="24" align="right"><img src="../images/num_20.gif" height="17"></td>
<td width=9><img src="../images/ver_01.gif" width="9" height="17"></td>
<td><img src="../images/cap_20.gif" height="17"></td>
</tr></table>
<? print_content_line(); ?>
<table class="content_back1" cellpadding="0" cellspacing="0" width="100%"><tr>
<td style="padding:10 0 10 0">
<table cellpadding="0" cellspacing="0" width="100%"><tr>
<td width="70" style="padding-left:20"><img class="ib" src="../images/b_db_drop.gif" width="57" height="53" onclick="if (confirm('执行此操作将删除且不可恢复，您确定吗?\t')) { setting.mode.value='drop'; setting.submit(); }"></td>
<td style="padding-left:10">
<b>注意:</b>这会删除您所有的资料库内容.<br>
删除之前请务必备份文件<br>
此功能将会清空所有TT安装过的数据.
</td>
</tr></table>
</td>
</tr></table>
<center>
<br><br>
<img src="../images/new.gif"> <a href="#" onclick="window.open('diagnosis.php','_blank','width=320,height=600,scrollbars=1');">文件目录权限检查</a>
</td>
</tr></table>
</center>
</td>
</tr></table>
<? admin_footer("") ?>