/tools.php

<?php

/*

[Discuz!] Tools (C)2001-2008 Comsenz Inc.

This is NOT a freeware, use is subject to license terms



$Id: tools.php 1193 2010-01-20 09:35:41Z songlixin $

*/



/**********************	????? ??*******************************/

$tool_password = ''; // ?????? ???????????????????????????

/**********************	????? ??*******************************/

error_reporting(E_ERROR | E_PARSE);	//E_ERROR | E_WARNING | E_PARSE | E_ALL

@set_time_limit(0);

define('TOOLS_ROOT', dirname(__FILE__)."/");

define('VERSION', '2009');

define('Release','100120');

$functionall = array(

	array('all', 'all_repair', '????????', '???????????????'),

	array('all', 'all_runquery', '????(SQL)', '??????SQL???????'),

	array('all', 'all_checkcharset', '??????', '????????????????'),

	array('all', 'all_config', '??????', '????????'),

	array('all', 'all_restore', '???????', '?????????'),

	array('all', 'all_setadmin', '?????', '?????????????????????????'),

	array('dz', 'dz_filecheck', '????', '???????????Discuz!?????'),

	array('dz', 'dz_rplastpost', '??????', '?????????'),

	array('dz', 'dz_rpthreads', '??????', '???????????????????????????????'),

	array('dz', 'dz_mysqlclear', '???????', '??????????????????????'),

	array('dz', 'dz_moveattach', '??????', '???????????????????????????????'),

	array('dz_uch', 'uch_dz_replace', '??????', '??????????????????????????,??????????????'),

	array('all', 'all_updatecache', '<font color=red>????</font>', '?????'),

);

$toolbar = array(

	array('phpinfo','INFO'),

	array('datago','??'),

	array('all_logout','??'),	

);

//???

$plustitle = '';

$lockfile = '';

//??????????getplace()?????

$docdir = '';

$action = '';

$target_fsockopen = '0'; 

$alertmsg = ' onclick="alert(\'????????,????????,???\');"';

foreach(array('_COOKIE', '_POST', '_GET') as $_request) { 

	foreach($$_request as $_key => $_value) {

		($_key{0} != '_' && $_key != 'tool_password' && $_key != 'lockfile') && $$_key = taddslashes($_value);

	}

}

$whereis = getplace();

require_once $cfgfile;





if($whereis == 'is_dz' && !defined('DISCUZ_ROOT')) {

	define('DISCUZ_ROOT', TOOLS_ROOT);

}

if(!$whereis && !in_array($whereis, array('is_dz', 'is_uc', 'is_uch', 'is_ss'))) {

	$alertmsg = '';

	errorpage('<ul><li>???????Discuz!?UCenter?UCente Home?SupeSite????????????</li><li>?????????????????????????????config???????????</li>');

}

if(@file_exists($lockfile)) { 

	$alertmsg = '';

	errorpage("<h6>??????????????? FTP ?? $lockfile ????? </h6>");

} elseif($tool_password == '') {

	$alertmsg = '';

	errorpage('<h6>????????????????????????$tool_password?????</h6>');

}

if($action == 'login') {

	setcookie('toolpassword',md5($toolpassword), 0);

	echo '<meta http-equiv="refresh" content="2 url=?">';

	errorpage("<h6>??????????</h6>");

}

if(isset($toolpassword)) {

	if($toolpassword != md5($tool_password)) {

		$alertmsg = '';	

		errorpage("login");

	}

} else {

	$alertmsg = '';

	errorpage("login");

}

getdbcfg();

$mysql = mysql_connect($dbhost, $dbuser, $dbpw);

mysql_select_db($dbname);

$my_version = mysql_get_server_info();

if($my_version > '4.1') {

	$serverset = $dbcharset ? 'character_set_connection='.$dbcharset.', character_set_results='.$dbcharset.', character_set_client=binary' : '';

	$serverset .= $my_version > '5.0.1' ? ((empty($serverset))? '' : ',').'sql_mode=\'\'' : '';

	$serverset && mysql_query("SET $serverset");

}

//????

if($action == 'all_repair') {

	$counttables = $oktables = $errortables = $rapirtables = 0;

	$doc = $docdir.'/repaireport.txt';

	if($check) {

		$tables = mysql_query("SHOW TABLES");

		if($iterations) {

			$iterations --;

		}

		while($table = mysql_fetch_row($tables)) {

				$counttables += 1;

				$answer = checktable($table[0],$iterations,$doc);

		}

		if($simple) {

			htmlheader();

			echo '<h4>???????</h4>

			    <h5>????:</h5>

					<table>

						<tr><th>???(?)</th><th>???(?)</th><th>????(?)</th><th>??(?)</th></tr>

						<tr><td>'.$counttables.'</td><td>'.$oktables.'</td><td>'.$rapirtables.'</td><td>'.$errortables.'</td></tr>

					</table>

				<p>????????????????????????</p>

				<p><b><a href="tools.php?action=all_repair">????</a>&nbsp;&nbsp;&nbsp;&nbsp;<b><a href="'.$doc.'">????</a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="tools.php">????</a></b></p>

				</td></tr></table>';

			specialdiv();

		}

	} else {

		htmlheader();

		@unlink($doc);

		echo "<h4>???????</h4>

		<div class='specialdiv'>

				?????

				<ul>

				<li>??????????????????????????????????</li>

				<li>??????????????????????????????????(?? MySQL 3.23+)</li>

				</ul>

				</div>

				<h5>???</h5>

				<ul>

				<li><a href=\"?action=all_repair&check=1&simple=1\">??????????1?</a>

				<li><a href=\"?action=all_repair&check=1&iterations=5&simple=1\">??????????5?</a> (????????????????????????????)

				</ul>";

		specialdiv();

	}

	htmlfooter();

} elseif($action == 'all_restore') {//???????

	ob_implicit_flush();

	$backdirarray = array( //??????????????????

						'is_dz' => 'forumdata',

						'is_uc' => 'data/backup',

						'is_uch' => 'data',

						'is_ss' => 'data'

	);

	if(!get_cfg_var('register_globals')) {

		@extract($HTTP_GET_VARS);

	}

	$sqldump = '';

	htmlheader();

	?><h4>????????? </h4><?php

	echo "<div class=\"specialdiv\">?????<ul>

		<li>??????????(?????)??????,????????????,?? FTP ??</li>

		<li>??????? Discuz! ????,???????? PHP ????</li>

		<li>??????????????,?????.?????(?? 10 ??)???,???</li></ul></div>";

	if($file) {

		if(!mysql_select_db($dbname)) {

			mysql_query("CREATE DATABASE $dbname;");

		}

		if(strtolower(substr($file, 0, 7)) == "http://") {

			echo "?????????? - ??????:<br><br>";

			echo "?????????? ... ";

			$sqldump = @fread($fp, 99999999);

			@fclose($fp);

			if($sqldump) {

				echo "??<br><br>";

			} elseif(!$multivol) {

				cexit("??<br><br><b>??????</b>");

			}

		} else {

			echo "<div class=\"specialtext\">??????? - ??????:<br><br>";

			if(file_exists($file)) {

				echo "???? $file ???? ... ??<br><br>";

			} elseif(!$multivol) {

				cexit("???? $file ???? ... ??<br><br><br><b>??????</b></div>");

			}

			if(is_readable($file)) {

				echo "???? $file ???? ... ??<br><br>";

				@$fp = fopen($file, "r");

				@flock($fp, 3);

				$sqldump = @fread($fp, filesize($file));

				@fclose($fp);

				echo "??????? ... ??<br><br>";

			} elseif(!$multivol) {

				cexit("???? $file ???? ... ??<br><br><br><b>??????</b></div>");

			}

		}

		if($multivol && !$sqldump) {

			cexit("???????? ... ??<br><br><b>???,??????????!????,????????.</b></div>");

		}

		echo "???? $file ???? ... ";

		if($whereis == 'is_uc') {

			

			$identify = explode(',', base64_decode(preg_replace("/^# Identify:\s*(\w+).*/s", "\\1", substr($sqldump, 0, 256))));		

			$method = 'multivol';

			$volume = $identify[4];

		} else {

			@list(,,,$method, $volume) = explode(',', base64_decode(preg_replace("/^# Identify:\s*(\w+).*/s", "\\1", preg_replace("/^(.+)/", "\\1", substr($sqldump, 0, 256)))));

		}

		if($method == 'multivol' && is_numeric($volume)) {

			echo "??<br><br>";

		} else {

			cexit("??<br><br><b>??? Discuz! ??????,????</b></div>");

		}

		if($onlysave == "yes") {

			echo "????????????? ... ";

			$filename = TOOLS_ROOT.'./'.$backdirarray[$whereis].strrchr($file, "/");

			@$filehandle = fopen($filename, "w");

			@flock($filehandle, 3);

			if(@fwrite($filehandle, $sqldump)) {

				@fclose($filehandle);

				echo "??<br><br>";

			} else {

				@fclose($filehandle);

				die("??<br><br><b>??????</b>");

			}

			echo "??<br><br><b>???,?????????????? <a href=\"".strstr($filename, "/")."\">$filename</a>.????,????????.</b></div>";

		} else {

			$sqlquery = splitsql($sqldump);

			echo "?????? ... ??<br><br>";

			unset($sqldump);



			echo "??????,??? ... </div>";

			foreach($sqlquery as $sql) {

				$dbversion = mysql_get_server_info();

				$sql = syntablestruct(trim($sql), $dbversion > '4.1', $dbcharset);

				if(trim($sql)) {

					@mysql_query($sql);

				}

			}

			if($auto == 'off') {

				$nextfile = str_replace("-$volume.sql", '-'.($volume + 1).'.sql', $file);

				cexit("<ul><li>???? <b>$volume#</b> ????,?????????????????</li><li>???<b><a href=\"?action=all_restore&file=$nextfile&multivol=yes\">????</a></b>	?????????????<b><a href=\"?action=all_restore&file=$nextfile&multivol=yes&auto=off\">??????????</a></b></li></ul>");

			} else {

				$nextfile = str_replace("-$volume.sql", '-'.($volume + 1).'.sql', $file);

				echo "<ul><li>???? <b>$volume#</b> ????,???????????????.</li><li><b>???????????????</b></li></ul>";

				redirect("?action=all_restore&file=$nextfile&multivol=yes");

			}

		}

	} else {

		$exportlog = array();

		if(is_dir(TOOLS_ROOT.'./'.$backdirarray[$whereis])) {

			$dir = dir(TOOLS_ROOT.'./'.$backdirarray[$whereis]);

			while($entry = $dir->read()) {

				$entry = "./".$backdirarray[$whereis]."/$entry";

				if(is_file($entry) && preg_match("/\.sql/i", $entry)) {

					$filesize = filesize($entry);

					$fp = @fopen($entry, 'rb');

					@$identify = explode(',', base64_decode(preg_replace("/^# Identify:\s*(\w+).*/s", "\\1", fgets($fp, 256))));

					@fclose ($fp);

						if(preg_match("/\-1.sql/i", $entry) || $identify[3] == 'shell') {

							$exportlog[$identify[0]] = array(	'version' => $identify[1],

												'type' => $identify[2],

												'method' => $identify[3],

												'volume' => $identify[4],

												'filename' => $entry,

												'size' => $filesize);

						}

				} elseif(is_dir($entry) && preg_match("/backup\_/i", $entry)) {

					$bakdir = dir($entry);

						while($bakentry = $bakdir->read()) {

							$bakentry = "$entry/$bakentry";

							if(is_file($bakentry)) {

								@$fp = fopen($bakentry, 'rb');

								@$bakidentify = explode(',', base64_decode(preg_replace("/^# Identify:\s*(\w+).*/s", "\\1", fgets($fp, 256))));

								@fclose ($fp);

								if(preg_match("/\-1\.sql/i", $bakentry) || $bakidentify[3] == 'shell') {

									$identify['bakentry'] = $bakentry;

								}

							}

						}

						if(preg_match("/backup\_/i", $entry)) {

							$exportlog[filemtime($entry)] = array(	'version' => $bakidentify[1],

												'type' => $bakidentify[2],

												'method' => $bakidentify[3],

												'volume' => $bakidentify[4],

												'bakentry' => $identify['bakentry'],

												'filename' => $entry);

						}

				}

			}

			$dir->close();

		} else {

			echo 'error';

		}

		krsort($exportlog);

		reset($exportlog);



		$title = '<h5><a href="?action=all_restore">??????</a>';

		if($dz_version >= 700 || $whereis == 'is_uc' || $whereis == 'is_uch' || $ss_version >= 70) {

			$title .= '&nbsp;&nbsp;&nbsp;<a href="?action=all_backup&begin=1">??????</a></h5>';

		} else {

			$title .= '</h5>';	

		}

		$exportinfo = $title.'<table><caption>&nbsp;&nbsp;&nbsp;??????</caption><tr><th>????</th><th>??</th><th>??</th><th>??</th><th>??</th><th>??</th></tr>';

		foreach($exportlog as $dateline => $info) {

			$info['dateline'] = is_int($dateline) ? gmdate("Y-m-d H:i", $dateline + 8*3600) : '??';

				switch($info['type']) {

					case 'full':

						$info['type'] = '????';

						break;

					case 'standard':

						$info['type'] = '????(??)';

						break;

					case 'mini':

						$info['type'] = '????';

						break;

					case 'custom':

						$info['type'] = '?????';

						break;

				}

			$info['volume'] = $info['method'] == 'multivol' ? $info['volume'] : '';

			$info['method'] = $info['method'] == 'multivol' ? '??' : 'shell';

			$info['url'] = str_replace(".sql", '', str_replace("-$info[volume].sql", '', substr(strrchr($info['filename'], "/"), 1)));

			$exportinfo .= "<tr>\n".

				"<td>".$info['url']."</td>\n".

				"<td>$info[version]</td>\n".

				"<td>$info[dateline]</td>\n".

				"<td>$info[type]</td>\n";

			if($info['bakentry']) {

			$exportinfo .= "<td><a href=\"?action=all_restore&bakdirname=".$info['url']."\">??</a></td>\n".

				"<td><a href=\"?action=all_restore&file=$info[bakentry]&importsubmit=yes\">[????]</a></td>\n</tr>\n";

			} else {

			$exportinfo .= "<td><a href=\"?action=all_restore&filedirname=".$info['url']."\">??</a></td>\n".

				"<td><a href=\"?action=all_restore&file=$info[filename]&importsubmit=yes\">[????]</a></td>\n</tr>\n";

			}

		}

		$exportinfo .= '</table>';

		echo $exportinfo;

		unset($exportlog);

		unset($exportinfo);

		echo "<br>";

	//??????????????????

		if(!empty($filedirname)) {

			$exportlog = array();

			if(is_dir(TOOLS_ROOT.'./'.$backdirarray[$whereis])) {

				$dir = dir(TOOLS_ROOT.'./'.$backdirarray[$whereis]);

				while($entry = $dir->read()) {

					$entry = "./".$backdirarray[$whereis]."/$entry";

					if(is_file($entry) && preg_match("/\.sql/i", $entry) && preg_match("/$filedirname/i", $entry)) {

						$filesize = filesize($entry);

						@$fp = fopen($entry, 'rb');

						@$identify = explode(',', base64_decode(preg_replace("/^# Identify:\s*(\w+).*/s", "\\1", fgets($fp, 256))));

						@fclose ($fp);

	

						$exportlog[$identify[0]] = array(	'version' => $identify[1],

											'type' => $identify[2],

											'method' => $identify[3],

											'volume' => $identify[4],

											'filename' => $entry,

											'size' => $filesize);

					}

				}

				$dir->close();

			}

			krsort($exportlog);

			reset($exportlog);

	

			$exportinfo = '<table>

							<caption>&nbsp;&nbsp;&nbsp;???????</caption>

							<tr>

							<th>???</th><th>??</th>

							<th>??</th><th>??</thd>

							<th>??</th><td>??</th>

							<th>??</th><th>??</th></tr>';

			foreach($exportlog as $dateline => $info) {

				$info['dateline'] = is_int($dateline) ? gmdate("Y-m-d H:i", $dateline + 8*3600) : '??';

					switch($info['type']) {

						case 'full':

							$info['type'] = '????';

							break;

						case 'standard':

							$info['type'] = '????(??)';

							break;

						case 'mini':

							$info['type'] = '????';

							break;

						case 'custom':

							$info['type'] = '?????';

							break;

					}

				$info['volume'] = $info['method'] == 'multivol' ? $info['volume'] : '';

				$info['method'] = $info['method'] == 'multivol' ? '??' : 'shell';

				$exportinfo .= "<tr>\n".

					"<td><a href=\"$info[filename]\" name=\"".substr(strrchr($info['filename'], "/"), 1)."\">".substr(strrchr($info['filename'], "/"), 1)."</a></td>\n".

					"<td>$info[version]</td>\n".

					"<td>$info[dateline]</td>\n".

					"<td>$info[type]</td>\n".

					"<td>".get_real_size($info[size])."</td>\n".

					"<td>$info[method]</td>\n".

					"<td>$info[volume]</td>\n".

					"<td><a href=\"?action=all_restore&file=$info[filename]&importsubmit=yes&auto=off\">[??]</a></td>\n</tr>\n";

			}

			$exportinfo .= '</table>';

			echo $exportinfo;

		}

		// ????????????? ??????????????????

		if(!empty($bakdirname)) {

			$exportlog = array();

			$filedirname = TOOLS_ROOT.'./'.$backdirarray[$whereis].'/'.$bakdirname;

			if(is_dir($filedirname)) {

				$dir = dir($filedirname);

				while($entry = $dir->read()) {

					$entry = $filedirname.'/'.$entry;

					if(is_file($entry) && preg_match("/\.sql/i", $entry)) {

						$filesize = filesize($entry);

						@$fp = fopen($entry, 'rb');

						@$identify = explode(',', base64_decode(preg_replace("/^# Identify:\s*(\w+).*/s", "\\1", fgets($fp, 256))));

						@fclose ($fp);

	

						$exportlog[$identify[0]] = array(	

											'version' => $identify[1],

											'type' => $identify[2],

											'method' => $identify[3],

											'volume' => $identify[4],

											'filename' => $entry,

											'size' => $filesize);

					}

				}

				$dir->close();

			}

			krsort($exportlog);

			reset($exportlog);

	

			$exportinfo = '<table>

					<caption>&nbsp;&nbsp;&nbsp;???????</caption>

					<tr>

					<th>???</th><th>??</th>

					<th>??</th><th>??</th>

					<th>??</th><th>??</th>

					<th>??</th><th>??</th></tr>';

			foreach($exportlog as $dateline => $info) {

				$info['dateline'] = is_int($dateline) ? gmdate("Y-m-d H:i", $dateline + 8*3600) : '??';

				switch($info['type']) {

					case 'full':

						$info['type'] = '????';

						break;

					case 'standard':

						$info['type'] = '????(??)';

						break;

					case 'mini':

						$info['type'] = '????';

						break;

					case 'custom':

						$info['type'] = '?????';

						break;

				}

				$info['volume'] = $info['method'] == 'multivol' ? $info['volume'] : '';

				$info['method'] = $info['method'] == 'multivol' ? '??' : 'shell';

				$exportinfo .= "<tr>\n".

						"<td><a href=\"$info[filename]\" name=\"".substr(strrchr($info['filename'], "/"), 1)."\">".substr(strrchr($info['filename'], "/"), 1)."</a></td>\n".

						"<td>$info[version]</td>\n".

						"<td>$info[dateline]</td>\n".

						"<td>$info[type]</td>\n".

						"<td>".get_real_size($info[size])."</td>\n".

						"<td>$info[method]</td>\n".

						"<td>$info[volume]</td>\n".

						"<td><a href=\"?action=all_restore&file=$info[filename]&importsubmit=yes&auto=off\">[??]</a></td>\n</tr>\n";

			}

			$exportinfo .= '</table>';

			echo $exportinfo;

		}

		echo "<br>";

		cexit("");

	}

} elseif($action == 'all_runquery') {//??sql

		if(!empty($_POST['sqlsubmit']) && $_POST['queries']) {

			runquery($queries);

		}

		htmlheader();

		runquery_html();

		htmlfooter();	

} elseif($action == 'all_checkcharset') {//????

	$maincharset = $dbcharset;

	$tooltip = '<h4>????</h4>'."<div class=\"specialdiv\">?????<ul>

				<li>MySQL???4.1????????????????4.1????????????</li>

				<li>????????????????????????????????????????????????</li>

				<li>??MySQL???????? <a href='http://www.discuz.net/viewthread.php?tid=1022673' target='_blank'>????</a></li>

				<li>????MySQL?????<a href='http://www.discuz.net/viewthread.php?tid=1070306' target='_blank'>??</a></li>

				<li><font color=red>??????????????????????????????????????????????????????????????????????????????????</font></li>

				<li><font color=red>??????????????????�<a href='?action=datago'>??</a>�??</font></li>

				</ul></div>";

	if($my_version > '4.1') {

		if($repairsubmit) {

			htmlheader();

			echo $tooltip;

			if(!is_array($repair)) {

				$repair=array();

				show_tools_message('????????', 'tools.php?action=all_checkcharset');

				htmlfooter();

				exit;

			}

			foreach($repair as $key=>$value) {

				$tableinfo = '';

				$tableinfo = explode('|', $value);

				$tablename = $tableinfo[0];

				$collation = $tableinfo[1];

				$maincharset = $tableinfo[2];

                		$query = mysql_query("SHOW CREATE TABLE $tablename");

				while($createsql = mysql_fetch_array($query)) {

					$colationsql = explode(",\n",$createsql[1]);

					foreach($colationsql as $numkey => $collsql) {

						if(strpos($collsql,'`'.$collation.'`')) {	

							if(strpos($collsql,'character set') > 0){

								$collsql = substr($collsql,0,strpos($collsql,'character set'));	

							} else {

								$collsql = substr($collsql,0,strpos($collsql,'NOT NULL'));

							}

							$collsql = $collsql." character set $maincharset NOT NULL";							

							$changesql = 'alter table '.$tablename.' change `'.$collation.'` '.$collsql;

							mysql_query($changesql);

						}

					}

				}

			}

			show_tools_message('????', 'tools.php?action=all_checkcharset');

			htmlfooter();

			exit;

		} else {

			$sql = "SELECT `TABLE_NAME` AS `Name`, `TABLE_COLLATION` AS `Collation` FROM `information_schema`.`TABLES` WHERE   ".(strpos("php".PHP_OS,"WIN")?"":"BINARY")."`TABLE_SCHEMA` IN ('$dbname') AND TABLE_NAME like '$tablepre%'";

			$query = @mysql_query($sql);

			$dbtable = array();

			$chars = array('gbk' => 0,'big5' => 0,'utf8' => 0,'latin1' => 0);

			if(!$query) {

				htmlheader();

				errorpage('?????????????????????????????????????', '', 0, 0);

				htmlfooter();

				exit;

			}

			while($dbdetail = mysql_fetch_array($query)) {

				$dbtable[$dbdetail["Name"]]["Collation"] = pregcharset($dbdetail["Collation"],1); 

				$dbtable[$dbdetail["Name"]]["tablename"] = $dbdetail["Name"]; 

				$tablequery = mysql_query("SHOW FULL FIELDS FROM `".$dbdetail["Name"]."`");

				while($tables= mysql_fetch_array($tablequery)) {

					if(!empty($tables["Collation"])) {

						$collcharset = pregcharset($tables["Collation"], 0);

						$tableschar[$collcharset][$dbdetail["Name"]][] = $tables["Field"];

						$chars[pregcharset($tables["Collation"], 0)]++;

					}

				}

				

			}

		}

	}



	htmlheader();

	echo $tooltip;

	if($my_version > '4.1') {

	echo'<div class="tabbody">

		<style>.tabbody p em { color:#09C; padding:0 10px;} .char_div { margin-top:30px; margin-bottom:30px;} .char_div h4, .notice h4 { font-weight:600; font-size:16px; margin:0; padding:0; margin-bottom:10px;}</style>

		<div class="char_div"><h5>???('.$dbname.')???????</h5>

		<table style="width:40%; margin:0; margin-bottom:20px;"><tr><th>gbk??</th><th>big5??</th><th>utf8??</th><th>latin1??</th></tr><tr><td>'.$chars[gbk].'&nbsp;</td><td>'.$chars[big5].'&nbsp;</td><td>'.$chars[utf8].'&nbsp;</td><td>'.$chars[latin1].'&nbsp;</td></tr></table>

		<div class="notice">

			<h5>???????????????</h5>';

			?>

<script type="text/JavaScript">

	function setrepaircheck(obj, form, table, char) {

		eval('var rem = /^' + table + '\\|.+?\\|.+?\\|' + char + '$/;');

		eval('var rechar = /latin1/;');

		for(var i = 0; i < form.elements.length; i++) {

			var e = form.elements[i];

			if(e.type == 'checkbox' && e.name == 'repair[]') {

				if(rem.exec(e.value) != null) {

					if(obj.checked) {

						if(rechar.exec(e.value) != null) {

							e.checked = true;

						} else {

							e.checked = true;

						}

					} else {

						e.checked = false;

					}

				}

			}

		}

	}

</script>

<?php

		  foreach($chars as $char => $num) {

			  if($char != $maincharset) {

				if(is_array($tableschar[$char])) {

					echo '<form name="form" action="" method="post">';

					foreach($tableschar[$char] as $tablename => $fields) {

					   	echo '<table style="margin-left:0; width:40%;">

							<tr>

								<th><input type="checkbox" id="tables[]" style="border-style:none;"  name="chkall"  onclick="setrepaircheck(this, this.form, \''.$tablename.'\', \''.$char.'\');"  value="'.$tablename.'">??</th>

								<th width=60%><strong>'.$tablename.'</strong> <font color="red">??????</font></th>

								<th>??</th>

							</tr>';

							foreach($fields as $collation) {

								echo'<tr><td><input type="checkbox" style="border-style:none;"';

								echo 'id="fields['.$tablename.'][]"';

								echo 'name=repair[] value="'.$tablename.'|'.$collation.'|'.$maincharset.'|'.$char.'">';

								echo '</td><td>'.$collation.'</td><td><font color="red">'.$char.'</font></td></tr>';

							}

						echo '</table>';

					}

				}	 

			}

		}

		echo '<input type="submit" value="???????????'.$maincharset.'" name="repairsubmit" onclick="javascript:if(confirm(\'Tools???????????????????????????????????????????????????????????????????\'));else return false;"></form>';

		echo '<br /><br /><br /></div> </div>';

	} else {

		errorpage('MySQL??????4.1???????????????', '', 0, 0);

	}

	htmlfooter();

} elseif($action == 'dz_filecheck') {//??????

	htmlheader();

	if($begin != 1) {

		echo '<h4>????</h4>';

		infobox('??????? Discuz! ????????????????????????????','tools.php?action=dz_filecheck&begin=1');

		htmlfooter();

		exit;

	}

	

	$md5data = array();

	if(!$dz_files = @file(TOOLS_ROOT.'./admin/discuzfiles.md5')) {

		errorpage('????md5??');

	}

	checkfiles('./', '\.php', 0, 'config.inc.php');

	checkfiles('api/', '\.php');

	checkfiles('admin/', '\.php');

	checkfiles('archiver/', '\.php');

	checkfiles('include/', '\.php|\.js|\.htm');

	checkfiles('modcp/', '\.php');

	checkfiles('plugins/', '\.php');

	checkfiles('templates/default/', '\.htm|\.php');

	checkfiles('uc_client/', '\.php',0);

	checkfiles('uc_client/control/', '\.php',0);

	checkfiles('uc_client/lib/', '\.php',0);

	checkfiles('uc_client/model/', '\.php',0);

	checkfiles('wap/', '\.php');

	

	$modifylists = $deletedfiles = $unknownfiles = array();

	

	docheckfiles($dz_files,$md5data);

	checkfilesoutput($modifylists,$deletedfiles,$unknownfiles);

	htmlfooter();

} elseif($action == 'dz_mysqlclear') {//?????

	ob_implicit_flush();

	define('IN_DISCUZ', TRUE);

	if(@!include("./config.inc.php")) {

		if(@!include("./config.php")) {

			htmlheader();

			cexit("<h4>????config????????????????</h4>");

		}

	}

	require './include/db_'.$database.'.class.php';

	$db = new dbstuff;

	$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);

	$db->select_db($dbname);



	if(!get_cfg_var('register_globals')) {

		@extract($_GET, EXTR_SKIP);

	}

	$rpp = "1000"; //?????????

	$totalrows = isset($totalrows) ? $totalrows : 0;

	$convertedrows = isset($convertedrows) ? $convertedrows : 0;

	$start = isset($start) && $start > 0 ? $start : 0;

	$sqlstart = isset($start) && $start > $convertedrows ? $start - $convertedrows : 0;

	$end = $start + $rpp - 1;

	$stay = isset($stay) ? $stay : 0;

	$converted = 0;

	$step = isset($step) ? $step : 0;

	$info = isset($info) ? $info : '';

	$action = array(

		'1'=>'????????',

		'2'=>'????????',

		'3'=>'????????',

		'4'=>'????????',

		'5'=>'??????',

		'6'=>'????????'

					);

	$steps = count($action);

	$actionnow = isset($action[$step]) ? $action[$step] : '??';

	$maxid = isset($maxid) ? $maxid : 0;

	$tableid = isset($tableid) ? $tableid : 1;

	htmlheader();

	if($step == 0) {

	?>

		<h4>?????????</h4>

		<h5>????????</h5>

		<table>

		<tr><th width="30%">Posts????</th><td>[<a href="?action=dz_mysqlclear&step=1&stay=1">????</a>]</td></tr>

		<tr><th width="30%">Attachments????</th><td>[<a href="?action=dz_mysqlclear&step=2&stay=1">????</a>]</td></tr>

		<tr><th width="30%">Members????</th><td>[<a href="?action=dz_mysqlclear&step=3&stay=1">????</a>]</td></tr>

		<tr><th width="30%">Forums????</th><td>[<a href="?action=dz_mysqlclear&step=4&stay=1">????</a>]</td></tr>

		<tr><th width="30%">Threads????</th><td>[<a href="?action=dz_mysqlclear&step=5&stay=1">????</a>]</td></tr>

		<tr><th width="30%">??????</th><td>[<a href="?action=dz_mysqlclear&step=1&stay=0">????</a>]</td></tr>

		</table>

	<?php

		specialdiv();

		echo "<script>$('jsmenu').style.display='inline';</script>";

	} elseif($step == '1') {

		if($start == 0) {

			validid('pid','posts');

		}

		$query = "SELECT pid, tid FROM {$tablepre}posts WHERE pid >= $start AND pid <= $end";

		$posts = $db->query($query);

			while ($post = $db->fetch_array($posts)) {

				$query = $db->query("SELECT tid FROM {$tablepre}threads WHERE tid='".$post['tid']."'");

				if($db->result($query, 0)) {

					} else {

						$convertedrows ++;

						$db->query("DELETE FROM {$tablepre}posts WHERE pid='".$post['pid']."'");

					}

				$converted = 1;

				$totalrows ++;

		}

			if($converted || $end < $maxid) {

				continue_redirect();

			} else {

				stay_redirect();

			}

	} elseif($step == '2') {

		if($start == 0) {

			validid('aid','attachments');

		}

		$query = "SELECT aid,pid,attachment FROM {$tablepre}attachments WHERE aid >= $start AND aid <= $end";

		$posts = $db->query($query);

			while ($post = $db->fetch_array($posts)) {

				$query = $db->query("SELECT pid FROM {$tablepre}posts WHERE pid='".$post['pid']."'");

				if($db->result($query, 0)) {

					} else {

						$convertedrows ++;

						$db->query("DELETE FROM {$tablepre}attachments WHERE aid='".$post['aid']."'");

						$attachmentdir = TOOLS_ROOT.'./attachments/';

						@unlink($attachmentdir.$post['attachment']);

					}

				$converted = 1;

				$totalrows ++;

		}

			if($converted || $end < $maxid) {

				continue_redirect();

			} else {

				stay_redirect();

			}

	} elseif($step == '3') {

		if($start == 0) {

			validid('uid','memberfields');

		}

		$query = "SELECT uid FROM {$tablepre}memberfields WHERE uid >= $start AND uid <= $end";

		$posts = $db->query($query);

			while ($post = $db->fetch_array($posts)) {

				$query = $db->query("SELECT uid FROM {$tablepre}members WHERE uid='".$post['uid']."'");

					if($db->result($query, 0)) {

					} else {

						$convertedrows ++;

						$db->query("DELETE FROM {$tablepre}memberfields WHERE uid='".$post['uid']."'");

					}

				$converted = 1;

				$totalrows ++;

		}

			if($converted || $end < $maxid) {

				continue_redirect();

			} else {

				stay_redirect();

			}

	} elseif($step == '4') {

		if($start == 0) {

			validid('fid','forumfields');

		}

		$query = "SELECT fid FROM {$tablepre}forumfields WHERE fid >= $start AND fid <= $end";

		$posts = $db->query($query);

			while ($post = $db->fetch_array($posts)) {

				$query = $db->query("SELECT fid FROM {$tablepre}forums WHERE fid='".$post['fid']."'");

				if($db->result($query, 0)) {

					} else {

						$convertedrows ++;

						$db->query("DELETE FROM {$tablepre}forumfields WHERE fid='".$post['fid']."'");

					}

				$converted = 1;

				$totalrows ++;

		}

			if($converted || $end < $maxid) {

				continue_redirect();

			} else {

				stay_redirect();

			}

	} elseif($step == '5') {

		if($start == 0) {

			validid('tid','threads');

		}

		$query = "SELECT tid, subject FROM {$tablepre}threads WHERE tid >= $start AND tid <= $end";

		$posts = $db->query($query);

			while ($threads = $db->fetch_array($posts)) {

				$query = $db->query("SELECT COUNT(*) FROM {$tablepre}posts WHERE tid='".$threads['tid']."' AND invisible='0'");

				$replynum = $db->result($query, 0) - 1;

				if($replynum < 0) {

					$db->query("DELETE FROM {$tablepre}threads WHERE tid='".$threads['tid']."'");

				} else {

					$query = $db->query("SELECT a.aid FROM {$tablepre}posts p, {$tablepre}attachments a WHERE a.tid='".$threads['tid']."' AND a.pid=p.pid AND p.invisible='0' LIMIT 1");

					$attachment = $db->num_rows($query) ? 1 : 0;//????

					$query  = $db->query("SELECT pid, subject, rate FROM {$tablepre}posts WHERE tid='".$threads['tid']."' AND invisible='0' ORDER BY dateline LIMIT 1");

					$firstpost = $db->fetch_array($query);

					$firstpost['subject'] = trim($firstpost['subject']) ? $firstpost['subject'] : $threads['subject']; //??????????????

					$firstpost['subject'] = addslashes($firstpost['subject']);

					@$firstpost['rate'] = $firstpost['rate'] / abs($firstpost['rate']);//????

					$query  = $db->query("SELECT author, dateline FROM {$tablepre}posts WHERE tid='".$threads['tid']."' AND invisible='0' ORDER BY dateline DESC LIMIT 1");

					$lastpost = $db->fetch_array($query);//??????

					$db->query("UPDATE {$tablepre}threads SET subject='".$firstpost['subject']."', replies='$replynum', lastpost='".$lastpost['dateline']."', lastposter='".addslashes($lastpost['author'])."', rate='".$firstpost['rate']."', attachment='$attachment' WHERE tid='".$threads['tid']."'", 'UNBUFFERED');

					$db->query("UPDATE {$tablepre}posts SET first='1', subject='".$firstpost['subject']."' WHERE pid='".$firstpost['pid']."'", 'UNBUFFERED');

					$db->query("UPDATE {$tablepre}posts SET first='0' WHERE tid='".$threads['tid']."' AND pid<>'".$firstpost['pid']."'", 'UNBUFFERED');

					$convertedrows ++;

				}

				$converted = 1;

				$totalrows ++;

			}

			if($converted || $end < $maxid) {

				continue_redirect();

			} else {

				stay_redirect();

			}

	} elseif($step == '6') {

		echo '<h4>?????????</h4><table>

			  <tr><th>????????</th></tr><tr>

			  <td><br>??????????.&nbsp;???<font color=red>'.$allconvertedrows.'</font>???.<br><br></td></tr></table>';

	}

	

	htmlfooter();

	

} elseif($action == 'uch_dz_replace') {//????s

	htmlheader();

	$rpp = "500"; //?????????

	$totalrows = isset($totalrows) ? $totalrows : 0;

	$convertedrows = isset($convertedrows) ? $convertedrows : 0;

	$convertedtrows	= isset($convertedtrows) ? $convertedtrows : 0;

	$start = isset($start) && $start > 0 ? $start : 0;

	$end = $start + $rpp - 1;

	$converted = 0;

	$maxid = isset($maxid) ? $maxid : 0;

	$threads_mod = isset($threads_mod) ? $threads_mod : 0;

	$threads_banned = isset($threads_banned) ? $threads_banned : 0;

	$posts_mod = isset($posts_mod) ? $posts_mod : 0;

	if($stop == 1) {

		echo "<h4>??????</h4><table>

			<tr>

			<th>????</th>

			</tr>";

		$threads_banned > 0 && print("<tr><td><br><li>".$threads_banned."?????????.</li></td></tr>");

		$threads_mod > 0 && print("<tr><td><br><li>".$threads_mod."??????????.</li></td></tr>");

		$posts_mod > 0 && print("<tr><td><br><li>".$posts_mod."??????????.</li></td></tr>");

		echo "<tr><td><li>???".$convertedrows."???</li></td></tr>";

		echo "<tr><td><a href='?action=uch_dz_replace&step=".$step."&start=".($end + 1 - $rpp * 2)."&stay=$stay&totalrows=$totalrows&convertedrows=$convertedrows&maxid=$maxid&replacesubmit=1&threads_banned=$threads_banned&threads_mod=$threads_mod&posts_mod=$posts_mod'>??</a></td></tr>";

		echo "</table>";

		htmlfooter();

	}

	ob_implicit_flush();

	if($whereis == 'is_uch') {

		$selectwords_cache = './data/selectwords_cache.php';

	} elseif($whereis == 'is_dz') {

		$selectwords_cache = './forumdata/cache/selectwords_cache.php';

	}



	if(isset($replacesubmit) || $start > 0) {

		if(!file_exists($selectwords_cache) || is_array($selectwords)) {

			if(count($selectwords) < 1) {

				echo "<h4>??????</h4><table><tr><th>????</th></tr><tr><td>????????????. &nbsp [<a href=tools.php?action=uch_dz_replace>??</a>]</td></tr></table>";

				htmlfooter();

			} else {

				$fp = @fopen($selectwords_cache,w);

				$content = "<?php \n";

				$selectwords = implode(',',$selectwords);

				$content .= "\$selectwords = '$selectwords';\n?>";

				if(!@fwrite($fp,$content)) {

					echo "??????$selectwords_cache ??,?????????. &nbsp [<a href=tools.php?action=uch_dz_replace>??</a>]";

					htmlfooter();

				} else {

					require_once "$selectwords_cache";

				}

				@fclose($fp);

			}

		} else {

			require_once "$selectwords_cache";

		}

		$array_find = $array_replace = $array_findmod = $array_findbanned = array();

		

		if($whereis == 'is_dz') {

			$query = mysql_query("SELECT find,replacement from {$tablepre}words where id in($selectwords)");//??????{BANNED}???? {MOD}??????

			while($row = mysql_fetch_array($query)) {

				$find = preg_quote($row['find'], '/');

				$replacement = $row['replacement'];

				if($replacement == '{BANNED}') {

					$array_findbanned[] = $find;

				} elseif($replacement == '{MOD}') {

					$array_findmod[] = $find;

				} else {

					$array_find[] = $find;

					$array_replace[] = $replacement;

				}

			}

		} elseif($whereis == 'is_uch') {

			$query = mysql_query("SELECT datavalue FROM `uchome_data` WHERE `var` = 'censor'");

			$query = mysql_fetch_array($query);

			$censor = explode("\n",$query[datavalue]);

			foreach($censor as $key => $value) {

				if(in_array($key,explode(',',$selectwords))){

					$rows = explode('=',$value);

					$row[] = $rows;					

				}

			}

			foreach($row as $value) {

				$find = preg_quote($value[0], '/');

				$replacement = $value[1];

				if($replacement == '{BANNED}') {

					$array_findbanned[] = $find;

				} else {

					$array_find[] = $find;

					$array_replace[] = $replacement;

				}				

			}

		}

		

		$array_find = topattern_array($array_find);

		$array_findmod = topattern_array($array_findmod);

		$array_findbanned = topattern_array($array_findbanned);

		if($whereis == 'is_dz'){

			if($maxid == 0) {

				validid('pid','posts');

			}

			//??posts?????

			$sql = "SELECT pid, tid, first, subject, message from {$tablepre}posts where pid >= $start and pid <= $end";

			$query = mysql_query($sql);

			while($row =  mysql_fetch_array($query)) {

				$pid = $row['pid'];

				$tid = $row['tid'];

				$subject = $row['subject'];

				$message = $row['message'];

				$first = $row['first'];

				$displayorder = 0;//  -2?? -1???

				if(count($array_findmod) > 0) {

					foreach($array_findmod as $value) {

						if(preg_match($value,$subject.$message)) {

							$displayorder = '-2';

							break;

						}

					}

				}

				if(count($array_findbanned) > 0) {

					foreach($array_findbanned as $value) {

						if(preg_match($value,$subject.$message)) {

							$displayorder = '-1';

							break;

						}

					}

				}

				if($displayorder < 0) {

					if($displayorder == '-2' && $first == 0) {//??????????

						$posts_mod ++;

						mysql_query("UPDATE {$tablepre}posts SET invisible = '$displayorder' WHERE pid = $pid");

					} else {

						if($db->affected_rows($db->query("UPDATE {$tablepre}threads SET displayorder = '$displayorder' WHERE tid = $tid and displayorder >= 0")) > 0) {

							$displayorder == '-2' && $threads_mod ++;

							$displayorder == '-1' && $threads_banned ++;

						}

					}

				}

				$subject = preg_replace($array_find,$array_replace,addslashes($subject));

				$message = preg_replace($array_find,$array_replace,addslashes($message));

				if($subject != addslashes($row['subject']) || $message != addslashes($row['message'])) {

					if(mysql_query("UPDATE {$tablepre}posts SET subject = '$subject', message = '$message' WHERE pid = $pid")) {

						$convertedrows ++;

					}

				}

				$converted = 1;

			}

			//??threads?

			$sql2 = "SELECT tid,subject from {$tablepre}threads where tid >= $start and tid <= $end";

			$query2 = mysql_query($sql2);

			while($row2 = mysql_fetch_array($query2)) {

				$tid = $row2['tid'];

				$subject = $row2['subject'];

				$subject = preg_replace($array_find,$array_replace,addslashes($subject));

				if($subject != addslashes($row2['subject'])) {

					if(mysql_query("UPDATE {$tablepre}threads SET subject = '$subject' WHERE tid = $tid")) {

						$convertedrows ++;

					}

				}

				$converted = 1;

			}

		} elseif ($whereis == 'is_uch') {

			if($maxid == 0) {

				validid('blogid','blog');

				$temp = $maxid;

				validid('cid','comment');

				$temp = max($temp,$maxid);

				validid('oid','polloption');

				$temp = max($temp,$maxid);

				validid('pid','post');

				$temp = max($temp,$maxid);

				validid('doid','doing');

				$temp = max($temp,$maxid);

				$maxid = $temp;

			}

			//blog??

			$sql =  "SELECT b.blogid,b.subject,f.message from {$tablepre}blog b,{$tablepre}blogfield f where b.blogid=f.blogid AND b.blogid >= $start and b.blogid <= $end";

			$query = mysql_query($sql);

			while($row =  mysql_fetch_array($query)) {

				$blogid = $row['blogid'];

				$subject = $row['subject'];

				$subject = preg_replace($array_find,$array_replace,addslashes($subject));

				if($subject != addslashes($row['subject']) || $message != addslashes($row['message'])) {

					if(mysql_query("UPDATE {$tablepre}blog SET subject = '$subject' WHERE blogid = $blogid")) {

						mysql_query("UPDATE {$tablepre}blogfield SET message = '$message' WHERE blogid = $blogid");

						$convertedrows ++;

					}

				}

				$converted = 1;

			}

			//comment??

			$sql =  "SELECT cid,message from {$tablepre}comment where cid >= $start and cid <= $end";

			$query = mysql_query($sql);

			while($row =  mysql_fetch_array($query)) {

				$cid = $row['cid'];

				$message = $row['message'];

				$message = preg_replace($array_find,$array_replace,addslashes($message));

				if($message != addslashes($row['message'])) {

					if(mysql_query("UPDATE {$tablepre}coment SET message = '$message' WHERE cid = $cid")) {

						$convertedrows ++;

					}

				}

				$converted = 1;

			}

			//poll??

			$sql =  "SELECT p.pid,p.subject,f.message,f.option from {$tablepre}poll p,{$tablepre}pollfield f where p.pid=f.pid AND p.pid >= $start and p.pid <= $end";

			$query = mysql_query($sql);

			while($row =  mysql_fetch_array($query)) {

				$pid = $row['pid'];

				$subject = $row['subject'];

				$message = $row['message'];

				$option = unserialize($row['option']);

				$subject = preg_replace($array_find,$array_replace,addslashes($subject));

				$message = preg_replace($array_find,$array_replace,addslashes($message));

				$option = addslashes(serialize(preg_replace($array_find,$array_replace,$option)));

				if($message != addslashes($row['message']) || $subject != addslashes($row['subject']) || $option != addslashes($row['option'])) {

					if(mysql_query("UPDATE {$tablepre}poll SET subject = '$subject' WHERE pid = $pid")) {

						mysql_query("UPDATE {$tablepre}pollfield SET `message` = '$message' WHERE pid = $pid");

						mysql_query("UPDATE {$tablepre}pollfield SET `option` = '$option' WHERE pid = $pid");

						$convertedrows ++;

					}

				}

				$converted = 1;

			}

			//polloption??

			$sql =  "SELECT oid,option from {$tablepre}polloption where oid >= $start and oid <= $end";

			$query = mysql_query($sql);

			while($row =  mysql_fetch_array($query)) {

				$oid = $row['oid'];

				$option = $row['option'];

				$option = preg_replace($array_find,$array_replace,addslashes($option));

				if($option != addslashes($row['option'])) {

					if(mysql_query("UPDATE {$tablepre}polloption SET option = '$option' WHERE oid = $oid")) {

						$convertedrows ++;

					}

				}

				$converted = 1;

			}

			//polloption??

			$sql =  "SELECT oid,option from {$tablepre}polloption where oid >= $start and oid <= $end";

			$query = mysql_query($sql);

			while($row =  mysql_fetch_array($query)) {

				$oid = $row['oid'];

				$option = $row['option'];

				$option = preg_replace($array_find,$array_replace,addslashes($option));

				if($option != addslashes($row['option'])) {

					if(mysql_query("UPDATE {$tablepre}polloption SET option = '$option' WHERE oid = $oid")) {

						$convertedrows ++;

					}

				}

				$converted = 1;

			}

			//post??

			$sql =  "SELECT pid,message from {$tablepre}post where pid >= $start and pid <= $end";

			$query = mysql_query($sql);

			while($row =  mysql_fetch_array($query)) {

				$pid = $row['pid'];

				$message = $row['message'];

				$message = preg_replace($array_find,$array_replace,addslashes($message));

				if($message != addslashes($row['message'])) {

					if(mysql_query("UPDATE {$tablepre}post SET message = '$message' WHERE pid = $pid")) {

						$convertedrows ++;

					}

				}

				$converted = 1;

			}

			//doing??

			$sql =  "SELECT doid,message from {$tablepre}doing where doid >= $start and doid <= $end";

			$query = mysql_query($sql);

			while($row =  mysql_fetch_array($query)) {

				$doid = $row['doid'];

				$message = $row['message'];

				$message = preg_replace($array_find,$array_replace,addslashes($message));

				if($message != addslashes($row['message'])) {

					if(mysql_query("UPDATE {$tablepre}doing SET message = '$message' WHERE doid = $doid")) {

						$convertedrows ++;

					}

				}

				$converted = 1;

			}

			//spacefield??

			$sql =  "SELECT uid,note,spacenote from {$tablepre}spacefield where uid >= $start and uid <= $end";

			$query = mysql_query($sql);

			while($row =  mysql_fetch_array($query)) {

				$uid = $row['uid'];

				$note = $row['note'];

				$spacenote = $row['spacenote'];

				$note = preg_replace($array_find,$array_replace,addslashes($note));

				$spacenote = preg_replace($array_find,$array_replace,addslashes($spacenote));

				if($note != addslashes($row['note']) || $spacenote != addslashes($row['spacenote'])) {

					if(mysql_query("UPDATE {$tablepre}spacefield SET note = '$note' WHERE uid = $uid")) {

						mysql_query("UPDATE {$tablepre}spacefield SET spacenote = '$spacenote' WHERE uid = $uid");

						$convertedrows ++;

					}

				}

				$converted = 1;

			}

		}



		//??

		if($converted  || $end < $maxid) {

			continue_redirect('uch_dz_replace',"&replacesubmit=1&threads_banned=$threads_banned&threads_mod=$threads_mod&posts_mod=$posts_mod");

		} else {

			echo "<h4>??????</h4><table>

						<tr>

							<th>????????</th>

						</tr>";

			if($threads_banned > 0) { echo "<tr><td><li>".$threads_banned."?????????.</li></td></tr>";}

			if($threads_mod > 0) {echo "<tr><td><li>".$threads_mod."??????????.</li></td></tr>";}

			if($posts_mod > 0) {echo "<tr><td><li>".$posts_mod."??????????.</li></td></tr>";}

			echo "<tr><td><li>???".$convertedrows."???</li></td></tr>";

			echo "</table>";

			@unlink($selectwords_cache);

		}

	} else {

		if(mysql_get_server_info > '4.1') {

			$serverset = 'character_set_connection=gbk, character_set_results=gbk, character_set_client=binary';

			$serverset && mysql_query("SET $serverset");

		}

		$i = 1;

		if ($whereis == 'is_dz') {

			define('IN_DISCUZ',TRUE);

			require_once "./forumdata/cache/cache_censor.php";

			$censorarray = $_DCACHE['censor'];

			$query = mysql_query("select * from {$tablepre}words");

		} elseif($whereis == 'is_uch') {

			define('IN_UCHOME',TRUE);

			require_once "./data/data_censor.php";

			$censorarray = $_SGLOBAL['censor'];

			$query = mysql_query("SELECT datavalue FROM `uchome_data` WHERE `var` = 'censor'");

			$query = mysql_fetch_array($query);

			$censor = explode("\n",$query[datavalue]);

			foreach($censor as $key => $value) {

				$rows = explode('=',$value);

				$row[] = $rows; 

			}

		}



		if(count($censorarray) < 1) {

			echo "<h4>??????</h4><table><tr><th>????</th></tr><tr><td><br>???,?????????,???????????.<br><br></td></tr></table>";

			htmlfooter();

		}



		echo '<form method="post" action="tools.php?action=uch_dz_replace">

			<script language="javascript">

				function checkall(form, prefix, checkall) {

					var checkall = checkall ? checkall : \'chkall\';

					for(var i = 0; i < form.elements.length; i++) {

						var e = form.elements[i];

						if(e.name != checkall && (!prefix || (prefix && e.name.match(prefix)))) {

							e.checked = form.elements[checkall].checked;

						}

					}

				}

			</script>

			<h4>??????</h4>

				<table>

					<tr>

						<th><input class="checkbox" name="chkall" onclick="checkall(this.form)" type="checkbox" checked>??</th>

						<th>????</th>

						<th>???</th></tr>';

						if($whereis == 'is_dz') {

							while($row = mysql_fetch_array($query)) {

							echo'<tr>

								<td><input class="checkbox" name="selectwords[]" value="'.$row['id'].'" type="checkbox" checked>&nbsp '.$i++.'</td>

								<td>&nbsp '.$row['find'].'</td>

								<td>&nbsp '.stripslashes($row['replacement']).'</td>

							</tr>';

							}

						} elseif($whereis == 'is_uch') {

							foreach($row as $key => $rowvalue) {

								echo'<tr>

								<td><input class="checkbox" name="selectwords[]" value="'.$key.'" type="checkbox" checked>&nbsp '.$i++.'</td>

								<td>&nbsp '.$rowvalue[0].'</td>

								<td>&nbsp '.stripslashes($rowvalue[1]).'</td>

								</tr>';	

							}

						}



			echo '</table>

				<input type="submit" name=replacesubmit value="????">

			</form>

			<div class="specialdiv">

				<h6>???</h6>

				<ul>

				<li>??????????????????????.?????<a href="./admincp.php?action=censor" target=\'_blank\'>?????</a>?</li>

				<li>???????????????.</li>

				</ul></div><br><br>';

	}

	htmlfooter();

} elseif($action == 'all_updatecache') {//????

  	if($whereis =='is_dz') {

		$clearmsg = dz_updatecache();

	} elseif($whereis == 'is_uch') {

		$clearmsg = uch_updatecache();

	} elseif($whereis == 'is_ss') {

		$clearmsg = ss_updatecache();

		}

	htmlheader();

	echo '<h4>????</h4><table><tr><th>????</th></tr><tr><td>';

	if($clearmsg == '') $clearmsg = '??????.';

	echo $clearmsg.'</td></tr></table>';

	htmlfooter();

} elseif($action == 'all_setadmin') {//??????????

	$sql_findadmin = '';

	$sql_select = '';

	$sql_update = '';

	$sql_rspw = '';

	$secq = '';

	$rspw = '';

	$username = '';

	$uid = '';

	all_setadmin_set($tablepre,$whereis);

	$info = '';

	$info_uc = '';	

	htmlheader();

	?>

	<h4>?????</h4>

	<?php

		//??????????

	if($whereis != 'is_uc') {

		$findadmin_query = mysql_query($sql_findadmin);

		$admins = '';

		while($findadmins = mysql_fetch_array($findadmin_query)) {

			$admins .= ' '.$findadmins[$username];

		}

	}

	if(!empty($_POST['loginsubmit'])) {

		if($whereis == 'is_uc') {

			define(ROOT_DIR,dirname(__FILE__)."/");

			$configfile = ROOT_DIR."./data/config.inc.php";

			$uc_password = $_POST["password"];

			$salt = substr(uniqid(rand()), 0, 6);

			if(!$uc_password) {

				$info = "??????";

			} else {

				$md5_uc_password = md5(md5($uc_password).$salt);

				$config = file_get_contents($configfile);

				$config = preg_replace("/define\('UC_FOUNDERSALT',\s*'.*?'\);/i", "define('UC_FOUNDERSALT', '$salt');", $config);

				$config = preg_replace("/define\('UC_FOUNDERPW',\s*'.*?'\);/i", "define('UC_FOUNDERPW', '$md5_uc_password');", $config);

				$fp = @fopen($configfile, 'w');

				@fwrite($fp, $config);

				@fclose($fp);

				$info = "UCenter???????????$uc_password";

			}

		} else {

			if(@mysql_num_rows(mysql_query($sql_select)) < 1) {

					$info = '<font color="red">????????????????</font>?<a href="?action=all_setadmin">????</a> ??????.<br><br>';

			} else {

				if($whereis == 'is_dz') {

					$sql_update1 = "UPDATE {$tablepre}members SET adminid='1', groupid='1' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";

					$sql_update2 = "UPDATE {$tablepre}members SET adminid='1', groupid='1',secques='' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";

					$sql_update = $_POST['issecques'] ? $sql_update2 : $sql_update1;

				}

				if($whereis == 'is_ss') {

					$sql_update1 = "UPDATE {$tablepre}members SET  groupid='1' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";

					$sql_update =  $sql_update1;

				}

				if(mysql_query($sql_update)&& !$rspw) {

					$_POST[loginfield] = $_POST[loginfield] == $username ? '???' : 'UID??';

					$info = "??$_POST[loginfield]? $_POST[where] ??????????<br><br>";

				}

				if($rspw) {

					if($whereis == 'is_dz') {

						if($dz_version < 610) {

							$psw = md5($_POST['password']);

							 mysql_query("update {$tablepre}members set password='$psw' where $_POST[loginfield] = '$_POST[where]' limit 1");

						} else {

							//???dz???????uc??????$sql_rspw????

							$salt = substr(md5(time()), 0, 6);

							$psw = md5(md5($_POST['password']).$salt);

							mysql_connect(UC_DBHOST, UC_DBUSER, UC_DBPW);

							if($_POST['issecques'] && $dz_version >= 700) {

								$sql_rspw = "UPDATE ".UC_DBTABLEPRE."members SET password='".$psw."',salt='".$salt."',secques='' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";

							} else {

								$sql_rspw = "UPDATE ".UC_DBTABLEPRE."members SET password='".$psw."',salt='".$salt."' WHERE username = '$_POST[where]' limit 1";

							}

							mysql_query($sql_rspw);

						}

						$info .= "??$_POST[loginfield]? $_POST[where] ??????????$_POST[password]<br><br>";

					} elseif($whereis == 'is_uch') {

						$salt = substr(md5(time()), 0, 6);

						$psw = md5(md5($_POST['password']).$salt);

						mysql_connect(UC_DBHOST, UC_DBUSER, UC_DBPW);

						$sql_rspw = "UPDATE ".UC_DBTABLEPRE."members SET password='".$psw."',salt='".$salt."' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";

						mysql_query($sql_rspw);

						$info .= "??$_POST[loginfield]? $_POST[where] ??????????$_POST[password]<br><br>";

					} elseif($whereis == 'is_ss') {

						if($ss_version >= 70) {

							$salt = substr(md5(time()), 0, 6);

							$psw = md5(md5($_POST['password']).$salt);

							mysql_connect(UC_DBHOST, UC_DBUSER, UC_DBPW);

							$sql_rspw = "UPDATE ".UC_DBTABLEPRE."members SET password='".$psw."',salt='".$salt."' WHERE $_POST[loginfield] = '$_POST[where]' limit 1";

							mysql_query($sql_rspw);

						}

						$info .= "??$_POST[loginfield]? $_POST[where] ??????????$_POST[password]<br><br>";

					}

			} else {

				$info_rspw = "????????UC????? <a href=11 target='_blank'>????UC??</a>";

			}

			}

		}

		

		errorpage($info,'???????',0,0);

	} else {

	?>

	<form action="?action=all_setadmin" method="post">

		<table>

			<?php

				if($whereis != 'is_uc') {

			?>

				<tr>

					<th>????????</th>

					<td><?php echo $admins; ?></td>

				</tr>

				<tr>

					<th width="30%"><input class="radio" type="radio" name="loginfield" value="<?php echo $username; ?>" checked >???<input class="radio" type="radio" name="loginfield" value="<?php echo $uid; ?>" >UID</th>

					<td width="70%"><input class="textinput" type="" name="where" size="25" maxlength="40">

					<?php if(!$rspw) {

						echo '??????????????';

					}?>

					</td>

				</tr>

			<?php

				} else {

					

				}

			?>

	

			<?php

				if($rspw) {

			?>

				<tr>

					<th width="30%">?????</th>

					<td width="70%"><input class="textinput" type="text" name="password" size="25"></td>

				</tr>

			<?php

				} else {

			?>

				<tr>

					<th width="30%">??????</th>

					<td width="70%">????????UC?????<a href=11 target='_blank'>????UC??</a> </td>

				</tr>

			<?php

				}

				if($secq) {

			?>

				<tr>

					<th width="30%">????????</th>

					<td width="70%"><input class="radio" name="issecques" value="1" checked="checked" type="radio">?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="issecques" value="" class="radio" type="radio">?</td>

				</tr>

			<?php

				}

			?>

		</table>

		<input type="submit" name="loginsubmit" value="? &nbsp; ?">

	</form>

	<?php

	}

	specialdiv();

	htmlfooter();

} elseif($action == 'all_setlock') {//?????

	touch($lockfile);

	if(file_exists($lockfile)) {

		echo '<meta http-equiv="refresh" content="3 url=?">';

		errorpage("<h6>?????????????????????????????</h6>",'?????');

	} else {

		errorpage('????????????????????????????????????tool.php???','?????');

	}

} elseif($action == 'dz_moveattach') {//????????

	define('IN_DISCUZ', TRUE);

	require_once TOOLS_ROOT."./config.inc.php";

	require_once TOOLS_ROOT."./include/db_mysql.class.php";

    	$db = new dbstuff;

	$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect, true, $dbcharset);

	$dbuser = $dbpw = $dbname = $pconnect = NULL;

	htmlheader();

	if(!function_exists('mkdir')) {

		echo "<h4>????????mkdir???????????</h4>";

		}

	echo "<h4>??????</h4>";

	$atoption = array(

		'0' => '??(????????)',

		'1' => '?????????',

		'2' => '???????????',

		'3' => '?????????',

		'4' => '????????',

	);

	if(!empty($_POST['moveattsubmit']) || $step == 1) {

		$rpp = "500"; //?????????

		$totalrows = isset($totalrows) ? $totalrows : 0;

		$convertedrows = isset($convertedrows) ? $convertedrows : 0;

		$start = isset($start) && $start > 0 ? $start : 0;

		$end =	$start + $rpp - 1;

		$converted = 0;

		$maxid = isset($maxid) ? $maxid : 0;

		$newattachsave = isset($newattachsave) ? $newattachsave : 0;

		$step = 1;

		if($start <= 1) {

			$db->query("UPDATE {$tablepre}settings SET value = '$newattachsave' WHERE variable = 'attachsave'");

			$cattachdir = $db->result($db->query("SELECT value FROM {$tablepre}settings WHERE variable = 'attachdir'"), 0);

			validid('aid', 'attachments');

		}

		$attachpath = isset($cattachdir) ? TOOLS_ROOT.$cattachdir : TOOLS_ROOT.'./attachments';

		$query = $db->query("SELECT aid, tid, dateline, filename, filetype, attachment, isimage, thumb FROM {$tablepre}attachments WHERE aid >= $start AND aid <= $end");

		while ($a = $db->fetch_array($query)) {

			$aid = $a['aid'];

			$tid = $a['tid'];

			$dateline = $a['dateline'];

			$filename = $a['filename'];

			$filetype = $a['filetype'];

			$attachment = $a['attachment'];

			$isimage = $a['isimage'];

			$thumb = $a['thumb'];

			$oldpath = $attachpath.'/'.$attachment;

			if(file_exists($oldpath)) {

				$realname = substr(strrchr('/'.$attachment, '/'), 1);

				if($newattachsave == 1) {

					$fid = $db->result($db->query("SELECT fid FROM {$tablepre}threads WHERE tid = '$tid' LIMIT 1"), 0);

					$fid = $fid ? $fid : 0;

				} elseif($newattachsave == 2) {

					$extension = strtolower(fileext($filename));

				}



				if($newattachsave) {

					switch($newattachsave) {

						case 1: $attach_subdir = 'forumid_'.$fid; break;

						case 2: $attach_subdir = 'ext_'.$extension; break;

						case 3: $attach_subdir = 'month_'.gmdate('ym', $dateline); break;

						case 4: $attach_subdir = 'day_'.gmdate('ymd', $dateline); break;

					}

					$attach_dir = $attachpath.'/'.$attach_subdir;

					if(!is_dir($attach_dir)) {

						mkdir($attach_dir, 0777);

						@fclose(fopen($attach_dir.'/index.htm', 'w'));

					}

					$newattachment = $attach_subdir.'/'.$realname;

					

				} else {

					$newattachment = $realname;

				}

				$newpath = $attachpath.'/'.$newattachment;

				$asql1 = "UPDATE {$tablepre}attachments SET attachment = '$newattachment' WHERE aid = '$aid'";

				$asql2 = "UPDATE {$tablepre}attachments SET attachment = '$attachment' WHERE aid = '$aid'";

				if($db->query($asql1)) {

					if(rename($oldpath, $newpath)) {

						if($isimage && $thumb) {

							$thumboldpath = $oldpath.'.thumb.jpg';

							$thumbnewpath = $newpath.'.thumb.jpg';

							rename($thumboldpath, $thumbnewpath);

						}

						$convertedrows ++;

					} else {

						$db->query($asql2);

					}

				}

				$totalrows ++;

			}

		}

		if($converted || $end < $maxid) {

			continue_redirect('dz_moveattach', '&newattachsave='.$newattachsave.'&cattachdir='.$cattachdir);

		} else {

			$msg = "$atoption[$newattachsave] ??????<br><li>??".$totalrows."?????</li><br /><li>???".$convertedrows."???</li>";

			errorpage($msg,'',0,0);

		}



	} else {

		$attachsave = $db->result($db->query("SELECT value FROM {$tablepre}settings WHERE variable = 'attachsave' LIMIT 1"), 0);

		$checked[$attachsave] = 'checked';

		echo "<form method=\"post\" action=\"tools.php?action=dz_moveattach\" onSubmit=\"return confirm('??????????????\\n????????????');\">

		<table>

		<tr>

		<th>??????????????????<font color=\"red\">???????????????????????</font></th></tr><tr><td>";

		foreach($atoption as $key => $val) {

			echo "<li style=\"list-style:none;\"><input class=\"radio\" name=\"newattachsave\" type=\"radio\" value=\"$key\" $checked[$key]>&nbsp; $val</input></li><br>";

		}

		echo "

		</td></tr></table>

		<input type=\"hidden\" id=\"oldattachsave\" name=\"oldattachsave\" style=\"display:none;\" value=\"$attachsave\">

		<input type=\"submit\" name=\"moveattsubmit\" value=\"? &nbsp; ?\">

		</form>";

		specialdiv();

		echo "<script>$('jsmenu').style.display='inline';</script>";

	}

	htmlfooter();

} elseif($action == 'dz_rplastpost') {//?????????



//??????????

	define('IN_DISCUZ', TRUE);

	require_once TOOLS_ROOT."./config.inc.php";

	require_once TOOLS_ROOT."./include/db_mysql.class.php";

    	$db = new dbstuff;

	$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect, true, $dbcharset);

	$dbuser = $dbpw = $dbname = $pconnect = NULL;

	if($db->version > '4.1') {

			$serverset = "character_set_connection=$dbcharset, character_set_results=$dbcharset, character_set_client=binary";

			$serverset && $db->query("SET $serverset");

	}

	$selectfid = $_POST['fid'];

	if($selectfid) {

			$i = 0;

			foreach($selectfid as $fid) {

				$sql = "select t.tid, t.subject, p.subject AS psubject, p.dateline, p.author from {$tablepre}threads t,  {$tablepre}posts p where t.fid=$fid and p.tid=t.tid and t.displayorder>=0 and p.invisible=0 and p.status=0 order by p.dateline DESC limit 1";

				$query = $db->query($sql);

				$lastarray = array();

				if($lastarray = $db->fetch_array($query)) {

					$lastarray['subject'] = $lastarray['psubject']?$lastarray['psubject']:$lastarray['subject'];

					$lastpoststr = $lastarray['tid']."\t".$lastarray['subject']."\t".$lastarray['dateline']."\t".$lastarray['author'];

					$db->query("update {$tablepre}forums set lastpost='$lastpoststr' where fid=$fid");

				}

			}

			htmlheader();

			show_tools_message("????", 'tools.php?action=dz_rplastpost');

			htmlfooter();



		} else {

			htmlheader();

		echo '<h4>???????? </h4><div class=\"specialdiv\">?????<ul>

		<li>????????????????????????????????????</li>

		</ul></div>';

		echo '<div class="tabbody">

			<script language="javascript">

				function checkall(form, prefix, checkall) {

					var checkall = checkall ? checkall : \'chkall\';

					for(var i = 0; i < form.elements.length; i++) {

						var e = form.elements[i];

						if(e.name != checkall && (!prefix || (prefix && e.name.match(prefix)))) {

							e.checked = form.elements[checkall].checked;

						}

					}

				}

			</script>

	   	 <form action="tools.php?action=dz_rplastpost" method="post">

	

	        	<h4 style="font-size:14px;">??????</h4>

				<style>table.re_forum_list { margin-left:0; width:30%;} .re_forum_list input { margin:0; margin-right:10px; border-style:none;}</style>

	        	<table class="re_forum_list">

				<tr><th><input class="checkbox re_forum_input" name="chkall" onclick="checkall(this.form)" type="checkbox" ><strong>??</strong></th></tr>';

		$sql = "SELECT fid,name FROM {$tablepre}forums WHERE type='forum' or type='sub'";

		$query = mysql_query($sql);

		$forum_array = array();

	        while($forumarray = mysql_fetch_array($query)) {

	            echo '<tr><td><input name="fid[]" value="'.$forumarray[fid].'" type="checkbox" >'.$forumarray['name'].'</td></tr>';

		}

	        echo '</table>

			<div class="opt">

			 <input type="submit" name="submit" value="??" tabindex="3" />

			</div>

	        

	    </form>

	</div>';

	specialdiv();

	echo "<script>$('jsmenu').style.display='inline';</script>";

	htmlfooter();

	}

} elseif($action == 'dz_rpthreads') {//??????

//??????????

	define('IN_DISCUZ', TRUE);

	require_once TOOLS_ROOT."./config.inc.php";

	require_once TOOLS_ROOT."./include/db_mysql.class.php";

    	$db = new dbstuff;

	$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect, true, $dbcharset);

	$dbuser = $dbpw = $dbname = $pconnect = NULL;

  

	if($db->version > '4.1') {

			$serverset = "character_set_connection=$dbcharset, character_set_results=$dbcharset, character_set_client=binary";

			$serverset && $db->query("SET $serverset");

	}

	if($rpthreadssubmit) {

		  if(empty($start)) {

			  $start = 0;

		  }

		if($fids) {

			 if(is_array($fids)) {

				$fidstr = implode(',', $fids);

			 } else {

				$fidstr = $fids;

			 }

			 $sql = "select tid from {$tablepre}threads where fid in (0,$fidstr) and displayorder>='0' limit $start, 500"; 

			 $countsql = "select count(*) from {$tablepre}threads where fid in (0,$fidstr) and displayorder>='0'";

		} else {

			 $sql = "select tid from {$tablepre}threads where displayorder>='0' limit $start, 500";

			 $countsql = "select count(*) from {$tablepre}threads where displayorder>='0'";

		}

		$query = mysql_query($countsql);

		$threadnum = mysql_result($query,0);

		if($threadnum < $start) {

			htmlheader();

			show_tools_message('????????????', 'tools.php?action=dz_rpthreads');

			htmlfooter();

			exit;

		}

		$query = mysql_query($sql);

		while($thread = mysql_fetch_array($query)) {

			$tid = $thread['tid'];

			$processed = 1;

			$updatequery = mysql_query("SELECT COUNT(*) FROM {$tablepre}posts WHERE tid='$tid' AND invisible='0'");

			$replies = mysql_result($updatequery, 0) - 1;

			$updatequery = mysql_query("SELECT a.aid FROM {$tablepre}posts p, {$tablepre}attachments a WHERE a.tid='$tid' AND a.pid=p.pid AND p.invisible='0' LIMIT 1");

			$attachment = mysql_num_rows($updatequery) ? 1 : 0;

			$updatequery  = mysql_query("SELECT pid, subject, rate FROM {$tablepre}posts WHERE tid='$tid' AND invisible='0' ORDER BY dateline LIMIT 1");

			$firstpost = mysql_fetch_array($updatequery);

			$firstpost['subject'] = addslashes(cutstr($firstpost['subject'], 79));

			@$firstpost['rate'] = $firstpost['rate'] / abs($firstpost['rate']);

			$updatequery  = mysql_query("SELECT author, dateline FROM {$tablepre}posts WHERE tid='$tid' AND invisible='0' ORDER BY dateline DESC LIMIT 1");

			$lastpost = mysql_fetch_array($updatequery);

			mysql_query("UPDATE {$tablepre}threads SET subject='$firstpost[subject]', replies='$replies', lastpost='$lastpost[dateline]', lastposter='".addslashes($lastpost['author'])."', rate='$firstpost[rate]', attachment='$attachment' WHERE tid='$tid'");

			mysql_query("UPDATE {$tablepre}posts SET first='1', subject='$firstpost[subject]' WHERE pid='$firstpost[pid]'");

			mysql_query("UPDATE {$tablepre}posts SET first='0' WHERE tid='$tid' AND pid<>'$firstpost[pid]'");

		}



		htmlheader();

		show_tools_message('????? '.$start.' ??? '.($start+500).' ???', 'tools.php?action=dz_rpthreads&rpthreadssubmit=true&fids='.$fidstr.'&start='.($start+500));

		htmlfooter();

	} else {

	htmlheader();

	echo '<h4>?????? </h4><div class=\"specialdiv\">?????<ul>

		<li>?????????"?????"???????????????????</li>

		<li>?????????????????????????????</li>

		<li>??????????????????</li>

		</ul></div>';

	echo '<div class="tabbody">

		<script language="javascript">

				function checkall(form, prefix, checkall) {

					var checkall = checkall ? checkall : \'chkall\';

							

					for(var i = 0; i < form.elements.length; i++) {

						var e = form.elements[i];

						if(e.name != checkall && (!prefix || (prefix && e.name.match(prefix)))) {

							e.checked = form.elements[checkall].checked;

						}

					}

				}

		</script>

		<h4 style="font-size:14px;">??????</h4>

		<style>table.re_forum_list { margin-left:0; width:30%;} .re_forum_list input { margin:0; margin-right:10px; border-style:none;}</style>

		<form id="rpthreads" name="rpthreads" method="post"   action="tools.php?action=dz_rpthreads">

			<table class="re_forum_list">

	  	<tr>

		<th><input type="checkbox" name="chkall" onclick="checkall(this.form)" class="checkbox re_forum_input" name="selectall" value="" />??</th>

		</tr>';

		$sql = "SELECT fid,name FROM {$tablepre}forums WHERE type='forum' or type='sub'";

		$query = mysql_query($sql);

		$forum_array = array();

		while($forumarray = mysql_fetch_array($query)) {

	            echo '<tr><td><input name="fids[]" value="'.$forumarray[fid].'" type="checkbox" >'.$forumarray['name'].'</td></tr>';

		}

	echo '</table>

		<div class="opt">

			<input type="submit" name="rpthreadssubmit" value="??" />

		</div>

		</form>

		</div>';

	specialdiv();

	echo "<script>$('jsmenu').style.display='inline';</script>";

	htmlfooter();

	}

} elseif($action == 'all_logout') {//????

	setcookie('toolpassword', '', -86400 * 365);

	errorpage("<h6>??????,??????.???????????????.</h6>");

} elseif($action == 'all_config') {

	htmlheader();

	echo '<h4>????????</h4>';

	echo "<div class=\"specialdiv\">?????<ul id=\"ping\">

		<li>??????????????????????????????????????</li>

		</ul></div>";

	if($submit) {

		all_doconfig_modify($whereis);

	}

	ping($whereis);

	all_doconfig_output($whereis);	

	htmlfooter();

} elseif($action == 'phpinfo') {

	echo phpinfo(13);exit;

} elseif($action == 'datago') {

	htmlheader();

	!$tableno && $tableno = 0;

	!$do && $do = 'create';

	!$start && $start = 0;

	$limit = 2000;

	echo '<h4>???????</h4>';

	echo "<div class=\"specialdiv\">?????<ul>

		<li><font color=red>??????????????????????????????</font></li>

		<li>???????<a href='http://www.discuz.net/thread-1460873-1-1.html'><font color=red>??Tools?????????</font></a></li>

		<li>????????????????</li>

		</ul></div>";

	if($submit) {

		do_datago($mysql,$tableno,$do,$start,$limit);

	} elseif($my_version > '4.1') {

		datago_output();

	} else {

		echo '?????????????';

	}

	htmlfooter();

} elseif($action == 'all_backup') {

	htmlheader();

	if($begin == '1') {

		echo "<h4>?????</h4><div class=\"specialdiv\">?????<ul>

			<li>???????api/dbbak.php?????????????</li>

			<li>????????????????????</li>

			<li>??????????????,???????????(?? 10 ??)???,???</li></ul></div>";

		$title = '<h5><a href="?action=all_restore">??????</a>';

		$title .= '&nbsp;&nbsp;&nbsp;<a href="?action=all_backup&begin=1">??????</a></h5>';

		echo $title;

		$begin = '<a href="?action=all_backup"><input style="margin:0px;" type="button"  value=????></a>';

		cexit($begin);

	}

	$notice = "<div class=\"specialdiv\">?????<ul>

			<li>????????</li>

			</ul></div>";

	if(!file_exists('./api/dbbak.php')) {

		cexit($notice);

	}

	if($nexturl) {

		$url = $nexturl;	

	} else {

		$url = getbakurl($whereis);

	}	

	dobak($url,$num);

	htmlfooter();

} else {

	htmlheader();

	echo '<h4>????? Comsenz ???????</h4>

		<tr><td><br>';

	echo '<h5>Comsenz ????????????</h5><ul>';

	foreach($functionall as  $value) {

		$apps = explode('_', $value['0']);

		if(in_array(substr($whereis, 3), $apps) || $value['0'] == 'all') {	

				echo '<li>'.$value[2].'?'.$value[3].'</li>';

		}

	}

	echo '</ul>';

	htmlfooter();

}

//???

function cexit($message) {

	echo $message;

	specialdiv();

	htmlfooter();

}

//?????

function checktable($table, $loops = 0,$doc) {

	global $db, $nohtml, $simple, $counttables, $oktables, $errortables, $rapirtables;

	$query = mysql_query("show create table $table");

	if($createarray = mysql_fetch_array($query)) {

		if(strpos($createarray[1], 'TYPE=HEAP')) {	

		   $counttables --;

			return ;

		}

	}

	$result = mysql_query("CHECK TABLE $table");

	if(!$result) {

		$counttables --;

		return ;

	}

	$message = "\n>>>>>>>>>>>>>Checking Table $table\r\n---------------------------------\r\n";

	@writefile($doc,$message,'a');

	$error = 0;

	while($r = mysql_fetch_row($result)) {

		if($r[2] == 'error') {

			if($r[3] == "The handler for the table doesn't support check/repair") {

				$r[2] = 'status';

				$r[3] = 'This table does not support check/repair/optimize';

				unset($bgcolor);

				$nooptimize = 1;

			} else {

				$error = 1;

				$bgcolor = 'red';

				unset($nooptimize);

			}

			$view = '??';

			$errortables += 1;

		} else {

			unset($bgcolor);

			unset($nooptimize);

			$view = '??';

			if($r[3] == 'OK') {

				$oktables += 1;

			} elseif($r[3] == 'The storage engine for the table doesn\'t support check') {

				$oktables += 1;

			}

		}

		$message = "$r[0] | $r[1] | $r[2] | $r[3]\r\n";

		@writefile($doc,$message,'a');

	}

	if($error) {

		$message = ">>>>>>>>????? / Repairing Table $table\r\n";

		@writefile($doc,$message,'a');

		$result2=mysql_query("REPAIR TABLE $table");

		while($r2 = mysql_fetch_row($result2)) {

			if($r2[3] == 'OK') {

				$bgcolor='blue';

				$rapirtables += 1;

			} else {

				unset($bgcolor);

			}

			$message = "$r2[0] | $r2[1] | $r2[2] | $r2[3]\r\n";

			@writefile($doc,$message,'a');

		}

	}

	if(($result2[3] == 'OK'||!$error)&&!$nooptimize) {

		$message = ">>>>>>>>>>>>>Optimizing Table $table\r\n";

		@writefile($doc,$message,'a');

		$result3 = mysql_query("OPTIMIZE TABLE $table");

		$error = 0;

		while($r3 = mysql_fetch_row($result3)) {

			if($r3[2] == 'error') {

				$error = 1;

				$bgcolor = 'red';

			} else {

				unset($bgcolor);

			}

			$message = "$r3[0] | $r3[1] | $r3[2] | $r3[3]\r\n\r\n";

			@writefile($doc,$message,'a');

		}

	}

	if($error && $loops) {

		checktable($table,($loops-1),$doc);

	}

}

//????

function checkcachefiles($currentdir){

	global $authkey;

	$dir = opendir($currentdir);

	$exts = '/\.php$/i';

	$showlist = $modifylist = $addlist = array();

	while($entry = readdir($dir)) {

		$file = $currentdir.$entry;

		if($entry != '.' && $entry != '..' && preg_match($exts, $entry)) {

			@$fp = fopen($file, 'rb');

			@$cachedata = fread($fp, filesize($file));

			@fclose($fp);



			if(preg_match("/^<\?php\n\/\/Discuz! cache file, DO NOT modify me!\n\/\/Created: [\w\s,:]+\n\/\/Identify: (\w{32})\n\n(.+?)\?>$/s", $cachedata, $match)) {

				$showlist[$file] = $md5 = $match[1];

				$cachedata = $match[2];



				if(md5($entry.$cachedata.$authkey) != $md5) {

					$modifylist[$file] = $md5;

				}

			} else {

				$showlist[$file] = $addlist[$file] = '';

			}

		}



	}



	return array($showlist, $modifylist, $addlist);

}



function continue_redirect($action = 'dz_mysqlclear', $extra = ''){

	global $scriptname, $step, $actionnow, $start, $end, $stay, $convertedrows, $allconvertedrows, $totalrows, $maxid;

	if($action == 'doctor') {

		$url = "?action=$action{$extra}";

	} else {

		$url = "?action=$action&step=".$step."&start=".($end + 1)."&stay=$stay&totalrows=$totalrows&convertedrows=$convertedrows&maxid=$maxid&allconvertedrows=$allconvertedrows".$extra;

	}

	$timeout = $GLOBALS['debug'] ? 5000 : 2000;

	echo "<script>\r\n";

	echo "<!--\r\n";

	echo "function redirect() {\r\n";

	echo "	window.location.replace('".$url."');\r\n";

	echo "}\r\n";

	echo "setTimeout('redirect();', $timeout);\r\n";

	echo "-->\r\n";

	echo "</script>\r\n";

	if($action== 'doctor') {

		echo '<h4>????</h4><br><table>

		<tr><th>??????,???</th></tr><tr><td>';

		echo "<br><a href=\"".$url."\">???????????????????????</a><br><br>";

		echo '</td></tr></table>';

	} elseif($action == 'uch_dz_replace') {

		echo '<h4>?????</h4><table>

		<tr><th>????'.$actionnow.'</th></tr><tr><td>';

		echo "???? $start ---- $end ???[<a href='$url&stop=1' style='color:red'>????</a>]";



		echo "<br><br><a href=\"".$url."\">???????????????????????</a>";

		echo '</td></tr></table>';

	} else {

		echo '<h4>?????</h4><table>

		<tr><th>????'.$actionnow.'</th></tr><tr><td>';

		echo "???? $start ---- $end ???[<a href='?action=$action' style='color:red'>????</a>]";

		echo "<br><br><a href=\"".$url."\">???????????????????????</a>";

		echo '</td></tr></table>';

	}

}



function dirsize($dir){

	$dh = @opendir($dir);

	$size = 0;

	while($file = @readdir($dh)) {

		if($file != '.' && $file != '..') {

			$path = $dir.'/'.$file;

			if(@is_dir($path)) {

				$size += dirsize($path);

			} else {

				$size += @filesize($path);

			}

		}

	}

	@closedir($dh);

	return $size;

}



function get_real_size($size){

	$kb = 1024;

	$mb = 1024 * $kb;

	$gb = 1024 * $mb;

	$tb = 1024 * $gb;



	if($size < $kb) {

		return $size.' Byte';

	} elseif($size < $mb) {

		return round($size/$kb,2).' KB';

	} elseif($size < $gb) {

		return round($size/$mb,2).' MB';

	} elseif($size < $tb) {

		return round($size/$gb,2).' GB';

	} else {

		return round($size/$tb,2).' TB';

	}

}



function htmlheader() {

	global $uch_version,$alertmsg, $whereis, $functionall,$dz_version,$ss_version,$toolpassword,$tool_password,$toolbar,$plustitle;

	switch($whereis) {

		case 'is_dz':

			$plustitle = 'Discuz '.substr($dz_version,0,1).'.'.substr($dz_version,1,1);

			break;

		case 'is_uch':

			$plustitle = 'UCenter Home '.substr($uch_version,0,1).'.'.substr($uch_version,1);

			break;

		case 'is_ss':

			$plustitle = 'SupeSite '.substr($ss_version,0,1).'.'.substr($ss_version,1,1);;

			break;

		case 'is_uc':

			$plustitle = 'UCenter';

			break;

		default:

			$plustitle = '';

			break;

		}

	echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

		<html>

		<head>

		<meta http-equiv="Content-Type" content="text/html; charset=GBK">

		<title>Comsenz ??????? '.VERSION.'-New</title>

		<style type="text/css"><!--

		body {font-family: Tahoma,Arial, Helvetica, sans-serif, "??";font-size: 12px;color:#000;line-height: 120%;padding:0;margin:0;background:#DDE0FF;overflow-x:hidden;word-break:break-all;white-space:normal;scrollbar-3d-light-color:#606BFF;scrollbar-highlight-color:#E3EFF9;scrollbar-face-color:#CEE3F4;scrollbar-arrow-color:#509AD8;scrollbar-shadow-color:#F0F1FF;scrollbar-base-color:#CEE3F4;}

        a:hover {color:#60F;}

		ul {padding:2px 0 10px 0;margin:0;}

		textarea,table,td,th,select{border:1px solid #868CFF;border-collapse:collapse;}

		table li {margin-left:10px;}

		input{margin:10px 0 0px 30px;border-width:1px;border-style:solid;border-color:#FFF #64A7DD #64A7DD #FFF;padding:2px 8px;background:#E3EFF9;}

			input.radio,input.checkbox,input.textinput,input.specialsubmit {margin:0;padding:0;border:0;padding:0;background:none;}

			input.textinput,input.specialsubmit {border:1px solid #AFD2ED;background:#FFF;}

			input.textinput {padding:4px 0;} 			input.specialsubmit {border-color:#FFF #64A7DD #64A7DD #FFF;background:#E3EFF9;padding:0 5px;}

		option {background:#FFF;}

		select {background:#F0F1FF;}

		#header {border-top:4px solid #86B9D6;height:60px;width:100%;padding:0;margin:0;}

		    h2 {font-size:20px;font-weight:normal;position:absolute;top:20px;left:20px;padding:10px;margin:0;}

		    h3 {font-size:14px;position:absolute;top:28px;right:20px;padding:10px;margin:0;}

		#content {height:510px;background:#F0F1FF;overflow-x:hidden;z-index:1000;}

		    #nav {top:60px;left:0;height:510px;width:180px;border-right:1px solid #DDE0FF;position:absolute;z-index:2000;}

		        #nav ul {padding:0 10px;padding-top:30px;}

		        #nav li {list-style:none;}

		        #nav li a {font-size:14px;line-height:180%;font-weight:400;color:#000;}

		        #nav li a:hover {color:#60F;}

		    #textcontent {padding-left:200px;height:510px;width:80%;*width:100%;line-height:160%;overflow-y:auto;overflow-x:hidden;}

			    h4,h5,h6 {padding:4px;font-size:16px;font-weight:bold;margin-top:20px;margin-bottom:5px;color:#006;}

				h5,h6 {font-size:14px;color:#000;}

				h6 {color:#F00;padding-top:5px;margin-top:0;}

				.specialdiv {width:70%;border:1px dashed #C8CCFF;padding:0 5px;margin-top:20px;background:#F9F9FF;}

				.specialdiv2 {height:240px;width:60%;border:1px dashed #C8CCFF;padding:15px;margin-top:20px;background:#F9F9FF;overflow-y:scroll;}

				#textcontent ul {margin-left:30px;}

				textarea {width:78%;height:300px;text-align:left;border-color:#AFD2ED;}

				select {border-color:#AFD2ED;}

				table {width:74%;font-size:12px;margin-left:18px;margin-top:10px;}

				    table.specialtable,table.specialtable td {border:0;}

					td,th {padding:5px;text-align:left;}

				    caption {font-weight:bold;padding:8px 0;color:#3544FF;text-align:left;}

				    th {background:#D9DCFF;font-weight:600;}

					td.specialtd {text-align:left;}

				.specialtext {background:#FCFBFF;margin-top:20px;padding:5px 40px;width:64.5%;margin-bottom:10px;color:#006;}

		#footer p {padding:0 5px;text-align:center;}

		#jsmenu {margin-left:-200px;margin-top:-110px;border:5px solid #868CFF;width:400px;height:140px;padding:4px 10px 0 10px; text-align:left;background:#FFF; left:50%; top:50%; position:absolute; font:12px;zIndex:10001;}

		.button {margin-top:20px;}

		.infobox {background:#FFF;border-bottom:4px solid #868CFF;border-top:4px solid #868CFF;margin-bottom:10px;padding:30px;text-align:center;width:90%;}

		pre {*margin-top:10px;}

		.current { font-weight: bold; color: #090 !important; border-bottom-color: #F90 !important; }

		-->

		</style>

		</head>

		<script>function $(id) {return document.getElementById(id);}

		function menuclose(){

			$(\'jsmenu\').style.display = \'none\';

		}

		</script>

		<body>

	<div id = "jsmenu" style="display:none">

	<h6>???</h6>

	?????????????????????????????????????<br/>

	<input class=button onclick=menuclose() type=button value=????></input>

	</div>

        <div id="header">

		<h2>< Comsenz Tools '.VERSION.' > Now In: '.$plustitle.'</h2>

		<h3>[ <a href="?" target="_self">??</a> ]&nbsp;

		[ <a href="?action=all_setlock" target="_self">??</a> ]&nbsp;';

	if($toolpassword == md5($tool_password)) {

		foreach($toolbar as $value) {

			echo '[ <a href="?action='.$value[0].'" target="_self">'.$value[1].'</a> ]&nbsp';

		}

	}

	echo '</h3></div>

		<div id="nav">';

		echo '<ul>';//????????????????

		if($toolpassword == md5($tool_password)) {

			foreach($functionall as  $value) {

				$apps = explode('_', $value['0']);

				if(in_array(substr($whereis, 3), $apps) || $value['0'] == 'all') {	

					if($whereis == 'is_ss' && $value[1] == 'all_setadmin' && $ss_version<70 ) {

						continue;

					}

					echo '<li>[ <a href="?action='.$value[1].'" target="_self">'.$value[2].'</a> ]</li>';

				}

			}

		} else {

			echo '<li>[ <a href="tools.php" target="_self">??????</a> ]</li>';	

		}

		echo '</ul>';

		echo '</div>

		<div id="content">

		<div id="textcontent">';

}

//????

function htmlfooter(){

	echo '</div></div>

		<div id="footer"><p>Comsenz ??????? &nbsp;Release:'.Release.'&nbsp;

		 &copy; <a href="http://www.comsenz.com" style="color: #000000; text-decoration: none">Comsenz Inc.</a> 2001-2009 </font></td></tr><tr style="font-size: 0px; line-height: 0px; spacing: 0px; padding: 0px; background-color: #698CC3">

		</p></div>

		</body>

		</html>';

	exit;

}

//????

function errorpage($message,$title = '',$isheader = 1,$isfooter = 1){

	if($isheader) {

		htmlheader();

	}

	!$isheader && $title = '';

	if($message == 'login') {

		$message ='<h4>?????</h4>

				<form action="?" method="post">

					<table class="specialtable"><tr>

					<td width="20%"><input class="textinput" type="password" name="toolpassword"></input></td>

					<td><input class="specialsubmit" type="submit" value="? ?"></input></td></tr></table>

					<input type="hidden" name="action" value="login">

				</form>';

	} else {

		$message = "<h4>$title</h4><br><br><table><tr><th>????</th></tr><tr><td>$message</td></tr></table>";

	}

	echo $message;

	if($isfooter) {

		htmlfooter();

	}

}

//??

function redirect($url) {

	echo "<script>";

	echo "function redirect() {window.location.replace('$url');}\n";

	echo "setTimeout('redirect();', 2000);\n";

	echo "</script>";

	echo "<br><br><a href=\"$url\">???????????????????</a>";

	cexit("");

}

/**

 * ?????????????

 * @param unknown_type $directory

 */



//??sql??

function splitsql($sql){

	$sql = str_replace("\r", "\n", $sql);

	$ret = array();

	$num = 0;

	$queriesarray = explode(";\n", trim($sql));

	unset($sql);

	foreach($queriesarray as $query) {

		$queries = explode("\n", trim($query));

		foreach($queries as $query) {

			$ret[$num] .= $query[0] == "#" ? NULL : $query;

		}

		$num++;

	}

	return($ret);

}



function syntablestruct($sql, $version, $dbcharset) {



	if(strpos(trim(substr($sql, 0, 18)), 'CREATE TABLE') === FALSE) {

		return $sql;

	}

	if(substr(trim($sql), 0, 9) == 'SET NAMES' && !$version) {

        return '';

    } 

	$sqlversion = strpos($sql, 'ENGINE=') === FALSE ? FALSE : TRUE;



	if($sqlversion === $version) {



		return $sqlversion && $dbcharset ? preg_replace(array('/ character set \w+/i', '/ collate \w+/i', "/DEFAULT CHARSET=\w+/is"), array('', '', "DEFAULT CHARSET=$dbcharset"), $sql) : $sql;

	}



	if($version) {

		return preg_replace(array('/TYPE=HEAP/i', '/TYPE=(\w+)/is'), array("ENGINE=MEMORY DEFAULT CHARSET=$dbcharset", "ENGINE=\\1 DEFAULT CHARSET=$dbcharset"), $sql);



	} else {

		return preg_replace(array('/character set \w+/i', '/collate \w+/i', '/ENGINE=MEMORY/i', '/\s*DEFAULT CHARSET=\w+/is', '/\s*COLLATE=\w+/is', '/ENGINE=(\w+)(.*)/is'), array('', '', 'ENGINE=HEAP', '', '', 'TYPE=\\1\\2'), $sql);

	}

}

function stay_redirect() {

	global $action, $actionnow, $step, $stay, $convertedrows, $allconvertedrows;

	$nextstep = $step + 1;

	echo '<h4>?????????</h4><table>

			<tr><th>????'.$actionnow.'</th></tr><tr>

			<td>';

	if($stay) {

		$actions = isset($action[$nextstep]) ? $action[$nextstep] : '??';

		echo "$actionnow ????.???<font color=red>{$convertedrows}</font>???.".($stay == 1 ? "&nbsp;&nbsp;&nbsp;&nbsp;" : '').'<br><br>';

		echo "<a href='?action=dz_mysqlclear&step=".$nextstep."&stay=1'>( $actions )???????</a><br>";

	} else {

		if(isset($action[$nextstep])) {

			echo '?????'.$action[$nextstep].'......';

		}

		$allconvertedrows = $allconvertedrows + $convertedrows;

		$timeout = $GLOBALS['debug'] ? 5000 : 2000;

		echo "<script>\r\n";

		echo "<!--\r\n";

		echo "function redirect() {\r\n";

		echo "	window.location.replace('?action=dz_mysqlclear&step=".$nextstep."&allconvertedrows=".$allconvertedrows."');\r\n";

		echo "}\r\n";

		echo "setTimeout('redirect();', $timeout);\r\n";

		echo "-->\r\n";

		echo "</script>\r\n";

		echo "[<a href='?action=dz_mysqlclear' style='color:red'>????</a>]<br><br><a href=\"".$scriptname."?step=".$nextstep."\">???????????????????????</a>";

	}

	echo '</td></tr></table>';

}

//????????

function loadtable($table, $force = 0) {	

	global $carray;

	$discuz_tablepre = $carray['tablepre'];

	static $tables = array();



	if(!isset($tables[$table])) {

		if(mysql_get_server_info() > '4.1') {

			$query = @mysql_query("SHOW FULL COLUMNS FROM {$discuz_tablepre}$table");

		} else {

			$query = @mysql_query("SHOW COLUMNS FROM {$discuz_tablepre}$table");

		}

		while($field = @mysql_fetch_assoc($query)) {

			$tables[$table][$field['Field']] = $field;

		}

	}

	return $tables[$table];

}



//??????????? id ?

function validid($id, $table) {

	global $start, $maxid, $mysql, $tablepre;

	$sql = mysql_query("SELECT MIN($id) AS minid, MAX($id) AS maxid FROM {$tablepre}$table");

	$result = mysql_fetch_array($sql);

	$start = $result['minid'] ? $result['minid'] - 1 : 0;

	$maxid = $result['maxid'];

}

//??

function specialdiv() {

	echo '<div class="specialdiv">

		<h6>???</h6>

		<ul>

		<li>??????????????????????????????????????????????????????????????????</li>

		<li>??????Comsenz ???????????????????????????????????/forumdata?????tool.lock?????????</li></ul></div>';

}

//????

function getplace() {

	global $lockfile, $cfgfile, $docdir;

	$whereis = false;

	if(is_writeable('./config.inc.php') && is_writeable('./forumdata')) {//??Discuz!??

			$whereis = 'is_dz';

			$lockfile = './forumdata/tools.lock';

			$cfgfile = './config.inc.php';

			$docdir = './forumdata';

	}

	if(is_writeable('./data/config.inc.php') && is_dir('./control')) {//??UCenter??

			$whereis = 'is_uc';

			$lockfile = './data/tools.lock';

			$cfgfile = './data/config.inc.php';

			$docdir = './data';

	}

	if(is_writeable('./config.php') && is_dir('source')) {//??UCenter Home??

			$whereis = 'is_uch';

			$lockfile = './data/tools.lock';

			$cfgfile = './config.php';

			$docdir = './data';

	}

	if(is_writeable('./config.php') && file_exists('./batch.common.php')) {//??SupeSite??

			$whereis = 'is_ss';

			$lockfile = './data/tools.lock';

			$cfgfile = './config.php';

			$docdir = './data';

	}

	return $whereis;

}

//?????????

function getdbcfg(){

	global $uc_dbcharset,$uc_dbhost,$uc_dbuser,$uc_dbpw,$uc_dbname,$uc_tablepre,$dbhost, $dbuser, $dbpw, $dbname, $dbcfg, $whereis, $cfgfile, $tablepre, $dbcharset,$dz_version,$ss_version,$uch_version;

	if(@!include($cfgfile)) {

			htmlheader();

			cexit("<h4>????config????????????????</h4>");

	}

	if(UC_DBHOST) {

		$uc_dbhost = UC_DBHOST;

		$uc_dbuser = UC_DBUSER;

		$uc_dbpw = UC_DBPW;

		$uc_dbname = UC_DBNAME;	

		$uc_tablepre =  UC_DBTABLEPRE;

		$uc_dbcharset = UC_DBCHARSET;

	}

	switch($whereis) {

		case 'is_dz':

			$dbhost = $dbhost;

			$dbuser = $dbuser;

			$dbpw = $dbpw;

			$dbname = $dbname;	

			$tablepre =  $tablepre;

			$dbcharset = !$dbcharset ? (strtolower($charset) == 'utf-8' ? 'utf8' : $charset): $dbcharset;

			define('IN_DISCUZ',true);

			@require_once "./discuz_version.php";

			$dz_version = DISCUZ_VERSION;

			if($dz_version >= '7.1') {

				$dz_version = intval(str_replace('.','',$dz_version)).'0';

			} else {

				$dz_version = intval(str_replace('.','',$dz_version));

				}

			break;

		case 'is_uc':

			$dbhost = UC_DBHOST;

			$dbuser = UC_DBUSER;

			$dbpw = UC_DBPW;

			$dbname = UC_DBNAME;	

			$tablepre =  UC_DBTABLEPRE;

			$dbcharset = !UC_DBCHARSET ? (strtolower(UC_CHARSET) == 'utf-8' ? 'utf8' : UC_CHARSET) : UC_DBCHARSET;

			break;

		case 'is_uch':

			$dbhost = $_SC["dbhost"];

			$dbuser = $_SC["dbuser"];

			$dbpw = $_SC["dbpw"];

			$dbname = $_SC["dbname"];	

			$tablepre =  $_SC["tablepre"];

			if(file_exists("./ver.php")) {

				require './ver.php';

				$uch_version = X_VER;

			} else {

				$common = 'common.php';

				$version = fopen($common,'r');

				$version = fread($version,filesize($common));

				$len = strpos($version,'define(\'D_BUG\')');

				$version = substr($version,0,$len);

				$cache = fopen('./data/version.php','w');

				fwrite($cache,$version);

				fclose($cache);

				require_once './data/version.php';

				$uch_version = intval(str_replace('.','',X_VER));

				unlink('./data/version.php');

			}		

			$uch_version = intval(str_replace('.','',$uch_version));

			$dbcharset = !$_SC['dbcharset'] ? (strtolower($_SC["charset"]) == 'utf-8' ? 'utf8' : $_SC["charset"]) : $_SC['dbcharset'] ;

			break;

		case 'is_ss':

			$dbhost = $dbhost ? $dbhos : $_SC['dbhost'];

			$dbuser = $dbuser ? $dbuser : $_SC['dbuser'];

			$dbpw = $dbpw ? $dbpw : $_SC['dbpw'];

			$dbname = $dbname ? $dbname : $_SC['dbname'];	

			$tablepre =  $tablepre ? $tablepre : $_SC['tablepre'];

			$dbcharset = !$dbcharset ? (strtolower($charset) == 'utf-8' ? 'utf8' : $charset) : $dbcharset;

			if(!$dbcharset) {

				$dbcharset = !$_SC['dbcharset'] ? (strtolower($_SC['charset']) == 'utf-8' ? 'utf8' : $_SC['charset']) : $_SC['dbcharset'];			

			}

			if($_SC['dbhost'] || $_SC['dbuser']) {

				$common = 'common.php';

				$version = fopen($common,'r');

				$version = fread($version,filesize($common));

				$len = strpos($version,'define(\'S_RELEASE\'');

				$version = substr($version,0,$len);

				$cache = fopen('./data/version.php','w');

				fwrite($cache,$version);

				fclose($cache);

				require_once './data/version.php';

				$ss_version = intval(str_replace('.','',S_VER));

				unlink('./data/version.php');

			}

			break;

		default:

			$dbhost = $dbuser = $dbpw = $dbname = $tablepre = $dbcharset = '';

			break;

	}

}



function taddslashes($string, $force = 0) {

	!defined('MAGIC_QUOTES_GPC') && define('MAGIC_QUOTES_GPC', get_magic_quotes_gpc());

	if(!MAGIC_QUOTES_GPC || $force) {

		if(is_array($string)) {

			foreach($string as $key => $val) {

				$string[$key] = taddslashes($val, $force);

			}

		} else {

			$string = addslashes($string);

		}

	}

	return $string;

}



function pregcharset($charset,$color = 0) {

		if(strpos('..'.strtolower($charset), 'gbk')) {

			if($color) {

				return '<font color="#0000CC">gbk</font>';

			} else {

				return 'gbk';

			}

		} elseif(strpos('..'.strtolower($charset), 'latin1')) {

			if($color) {

				return '<font color="#993399">latin1</font>';

			} else {

				return 'latin1';

			}

		} elseif(strpos('..'.strtolower($charset), 'utf8')) {

			if($color) {

				return '<font color="#993300">utf8</font>';

			} else {

				return 'utf8';

			}

		} elseif(strpos('..'.strtolower($charset), 'big5')) {

			if($color) {

				return '<font color="#006699">big5</font>';

			} else {

				return 'big5';	

			}

		} else {

	       return $charset;

		}

}



function show_tools_message($message, $url = 'tools.php',$time = '2000') {

	echo "<script>";

	echo "function redirect() {window.location.replace('$url');}\n";

	echo "setTimeout('redirect();', $time);\n";

	echo "</script>";

	echo "<h4>$title</h4><br><br><table><tr><th>????</th></tr><tr><td>$message<br><a href=\"$url\">???????????????????</a></td></tr></table>";

	exit;

}



function fileext($filename) {

	return trim(substr(strrchr($filename, '.'), 1, 10));

}

function cutstr($string, $length, $dot = ' ...') {

	global $charset;

	if(strlen($string) <= $length) {

		return $string;

	}

	$string = str_replace(array('&amp;', '&quot;', '&lt;', '&gt;'), array('&', '"', '<', '>'), $string);

	$strcut = '';

	if(strtolower($charset) == 'utf-8') {

		$n = $tn = $noc = 0;

		while($n < strlen($string)) {



			$t = ord($string[$n]);

			if($t == 9 || $t == 10 || (32 <= $t && $t <= 126)) {

				$tn = 1; $n++; $noc++;

			} elseif(194 <= $t && $t <= 223) {

				$tn = 2; $n += 2; $noc += 2;

			} elseif(224 <= $t && $t < 239) {

				$tn = 3; $n += 3; $noc += 2;

			} elseif(240 <= $t && $t <= 247) {

				$tn = 4; $n += 4; $noc += 2;

			} elseif(248 <= $t && $t <= 251) {

				$tn = 5; $n += 5; $noc += 2;

			} elseif($t == 252 || $t == 253) {

				$tn = 6; $n += 6; $noc += 2;

			} else {

				$n++;

			}

			if($noc >= $length) {

				break;

			}

		}

		if($noc > $length) {

			$n -= $tn;

		}

		$strcut = substr($string, 0, $n);

	} else {

		for($i = 0; $i < $length; $i++) {

			$strcut .= ord($string[$i]) > 127 ? $string[$i].$string[++$i] : $string[$i];

		}

	}

	$strcut = str_replace(array('&', '"', '<', '>'), array('&amp;', '&quot;', '&lt;', '&gt;'), $strcut);

	return $strcut.$dot;

}



function checkfiles($currentdir, $ext = '', $sub = 1, $skip = '') {

	global $md5data, $dz_files;

	$dir = @opendir($currentdir);

	$exts = '/('.$ext.')$/i';

	$skips = explode(',', $skip);



	while($entry = @readdir($dir)) {

		$file = $currentdir.$entry;

		if($entry != '.' && $entry != '..' && (preg_match($exts, $entry) || $sub && is_dir($file)) && !in_array($entry, $skips)) {

			if($sub && is_dir($file)) {

				checkfiles($file.'/', $ext, $sub, $skip);

			} else {

				$md5data[$file] = md5_file($file);

			}

		}

	}

}



function loadtable_ucenter($table, $force = 0) {	

	global $carray;

	$discuz_tablepre = $carray['UC_DBTABLEPRE'];

	static $tables = array();



	if(!isset($tables[$table])) {

		if(mysql_get_server_info() > '4.1') {

			$query = @mysql_query("SHOW FULL COLUMNS FROM {$discuz_tablepre}$table");

		} else {

			$query = @mysql_query("SHOW COLUMNS FROM {$discuz_tablepre}$table");

		}

		while($field = @mysql_fetch_assoc($query)) {

			$tables[$table][$field['Field']] = $field;

		}

	}

	return $tables[$table];

}



function dz_updatecache(){

	global $dz_version;

	if($dz_version < 710) {

		$cachedir = array('cache','templates');

	} else {

		$cachedir = array('cache','templates','feedcaches');

		}

	$clearmsg = '';

	foreach($cachedir as $dir) {

		if($dh = dir('./forumdata/'.$dir)) {

			while (($file = $dh->read()) !== false) {

				if($file != "." && $file != ".." && $file != "index.htm" && !is_dir($file)) {

					unlink('./forumdata/'.$dir.'/'.$file);

				}

			}

		} else {

			$clearmsg .= './forumdata/'.$dir.'????.<br>';

		}

	}

	return $clearmsg;

}



function uch_updatecache(){

	$cachedir = array('data','data/tpl_cache');

	$clearmsg = '';

	foreach($cachedir as $dir) {

		if($dh = dir('./'.$dir)) {

			while (($file = $dh->read()) !== false) {

				if(!is_dir($file) && $file != "." && $file != ".." && $file != "index.htm" && $file != "install.lock" && $file != "sendmail.lock" ) {

					unlink('./'.$dir.'/'.$file);

				}

			}

		} else {

			$clearmsg .= './'.$dir.'????.<br>';

		}

	}

	return $clearmsg;

}



function ss_updatecache(){

	$cachedir = array('cache/model','cache/tpl');

	$clearmsg = '';

	foreach($cachedir as $dir) {

		if($dh = dir('./'.$dir)) {

			while (($file = $dh->read()) !== false) {

				if(!is_dir($file) && $file != "." && $file != ".." && $file != "index.htm" && $file != "install.lock" && $file != "sendmail.lock" ) {

					unlink('./'.$dir.'/'.$file);

				}

			}

		} else {

			$clearmsg .= './'.$dir.'????.<br>';

		}

	}

	return $clearmsg;

}



function runquery($queries){//??sql??

	global $tablepre,$whereis;

	$sqlquery = splitsql(str_replace(array(' cdb_', ' {tablepre}', ' `cdb_'), array(' '.$tablepre, ' '.$tablepre, ' `'.$tablepre), $queries));

	$affected_rows = 0;

	foreach($sqlquery as $sql) {

	$sql = syntablestruct(trim($sql), $my_version > '4.1', $dbcharset);

	if(trim($sql) != '') {

		mysql_query(stripslashes($sql));

		if($sqlerror = mysql_error()) {

			break;

			} else {

			$affected_rows += intval(mysql_affected_rows());

			}

		}

	}

	if(strpos($queries,'seccodestatus') && $whereis == 'is_dz') {

		dz_updatecache();	

	}

	if(strpos($queries,'bbclosed') && $whereis == 'is_dz') {

		dz_updatecache();	

	}

	if(strpos($queries,'template') && $whereis == 'is_uch') {

		uch_updatecache();	

	}

	if(strpos($queries,'seccode_login') && $whereis == 'is_uch') {

		uch_updatecache();	

	}

	if(strpos($queries,'close') && $whereis == 'is_uch') {

		uch_updatecache();	

	}

	errorpage($sqlerror? $sqlerror : "???????,????: &nbsp;$affected_rows",'?????');



	if(strpos($queries,'settings') && $whereis == 'is_dz') {

		require_once './include/cache.func.php';

		updatecache('settings');		

	}

}



function runquery_html(){ //???????????

	global $whereis,$tablepre;

	echo "<h4>????(SQL)</h4>

		<form method=\"post\" action=\"tools.php?action=all_runquery\">

		<h5>??????????????</h4>

		<font color=red>???</font>???????SQL????????????SQL??????????????.<br/><br/>";

	if($whereis == 'is_dz') {

		echo "<select name=\"queryselect\" onChange=\"queries.value = this.value\">

			<option value = ''>???TOOLS??????</option>

			<option value = \"REPLACE INTO ".$tablepre."settings (variable, value) VALUES ('bbclosed', '0')\">??????</option>

			<option value = \"REPLACE INTO ".$tablepre."settings (variable, value) VALUES ('seccodestatus', '0')\">?????????</option>

			<option value = \"UPDATE ".$tablepre."usergroups SET allowdirectpost = '1'\">???????????????</option>

			<option value = \"REPLACE INTO ".$tablepre."settings (variable, value) VALUES ('supe_status', '0')\">??????supersite??</option>

			<option value = \"TRUNCATE TABLE ".$tablepre."failedlogins\">????????</option>

			<option value = \"UPDATE ".$tablepre."members SET pmsound=2 WHERE pmsound=1\">?????????????</option>

			<option value = \"UPDATE ".$tablepre."forums f, cdb_posts p SET p.htmlon=p.htmlon|1 WHERE p.fid=f.fid AND f.allowhtml='1';\">????????HTML???????HTML??</option>

			<option value = \"UPDATE ".$tablepre."attachments SET `remote`=1;\">???????????????????</option>

			</select>";

		}

	if($whereis == 'is_uc') {

		echo "<select name=\"queryselect\" onChange=\"queries.value = this.value\">

			<option value = ''>???TOOLS??????</option>

			<option value = \"TRUNCATE TABLE ".$tablepre."notelist;\">??????</option>

			</select>";

		}

	if($whereis == 'is_uch') {

		echo "<select name=\"queryselect\" onChange=\"queries.value = this.value\">

			<option value = ''>???TOOLS??????</option>

			<option value = \"REPLACE INTO ".$tablepre."config (datavalue, var) VALUES ('template','default')\">????????????????</option>

			<option value = \"REPLACE INTO ".$tablepre."config (datavalue, var) VALUES ('seccode_login','0')\">??????????</option>

			<option value = \"REPLACE INTO ".$tablepre."config (datavalue, var) VALUES ('close','0')\">??????</option>

			<option value = \"UPDATE ".$tablepre."pic SET `remote`=1\">?????????????????</option>

			</select>";

		}

		echo "<br />

			<br /><textarea name=\"queries\">$queries</textarea><br />

			<input type=\"submit\" name=\"sqlsubmit\" value=\"? &nbsp; ?\">

			</form>";

}



function topattern_array($source_array) { //??????

	$source_array = preg_replace("/\{(\d+)\}/",".{0,\\1}",$source_array);

	foreach($source_array as $key => $value) {

		$source_array[$key] = '/'.$value.'/i';

	}

	return $source_array;

}



function all_setadmin_set($tablepre,$whereis){ //???????????????

	global $ss_version,$dz_version,$sql_findadmin,$sql_select,$sql_update,$sql_rspw,$secq,$rspw,$username,$uid;

	if($whereis == 'is_dz') {

		$sql_findadmin = "SELECT * FROM {$tablepre}members WHERE adminid=1";

		$sql_select = "SELECT uid FROM {$tablepre}members WHERE $_POST[loginfield] = '$_POST[where]'";		$username = 'username';

		$uid = 'uid';

		

		if(UC_CONNECT == 'mysql' || $dz_version < 610) {//????ucenter???????mysql???????????????uc??????

			$rspw = 1;

			

		} else {

			$rspw = 0;

		}

		if($dz_version<710) {//???????? 7.0?????????????

			$secq = 1;

		} elseif($rspw) {

			$secq = 1;

		} else {

			$secq = 0;

		}

	} elseif($whereis == 'is_uc') {

		$secq = 0;

		$rspw = 1;

	} elseif($whereis == 'is_uch') {

		$sql_findadmin = "SELECT * FROM {$tablepre}space WHERE groupid = 1";

		$sql_select = "SELECT uid FROM {$tablepre}space WHERE $_POST[loginfield] = '$_POST[where]'";

		$sql_update = "UPDATE {$tablepre}space SET groupid='1' WHERE $_POST[loginfield] = '$_POST[where]'";

		$username = 'username';

		$uid = 'uid';

		$secq = 0;

		if(UC_CONNECT == 'mysql') {

			$rspw = 1;

		} else {

			$rspw = 0;

		}

	} elseif($whereis == 'is_ss' && $ss_version >= 70) {

		$sql_findadmin = "SELECT * FROM {$tablepre}members WHERE groupid = 1";

		$sql_select = "SELECT uid FROM {$tablepre}members WHERE $_POST[loginfield] = '$_POST[where]'";

		$sql_update = "UPDATE {$tablepre}members SET groupid='1' WHERE $loginfield = '$where'";

		$username = 'username';

		$uid = 'uid';

		$secq = 0;

		if(UC_CONNECT == 'mysql') {

			$rspw = 1;

		} else {

			$rspw = 0;

		}



	}

}



function datago_output($whereis){

	global $dbhost, $dbuser, $dbpw, $dbname, $dbcfg;

	$charsets=array('gbk','latin1','utf8');

	$options="<option value=''>";

	foreach($charsets as $value){

		$options.="<option value=\"$value\">$value";

	}

	echo '<h5>???????</h5>';

	echo '<form method=get action=tools.php?action=datago><table>

		<tbody>

		<input name=action type=hidden value=datago>

		<tr><th width=20%>????</th><td><input class=textinput name=fromdbname value='.$dbname.'></input>&nbsp;&nbsp;???tools????????,?????????????</td></tr>

		<tr><th width=20%>????</th><td><select name=todbcharset>'.$options.'</select>&nbsp;&nbsp;?????\'latin1\'<=>\'gbk\',\'gbk\'<=>\'utf8\'</td></tr></tbody></table>

		<input name=submit type=submit value=??></input>

		</form>';

}



function do_datago($mysql,$tableno,$do,$start,$limit){

	global $whereis, $dbhost, $dbuser, $dbpw, $tablepre,$fromdbname, $todbcharset, $dbcfg,$dbcharset;

	$allowcharset = array('latin1' => 'gbk','gbk' => 'utf8','utf8' => 'latin1');

	$tablename = 'Tables_in_'.strtolower($fromdbname).' ('.$tablepre.'%)';

	$mysql = mysql_connect($dbhost, $dbuser, $dbpw);

	mysql_select_db($fromdbname);

	mysql_query("SET sql_mode=''");

	$query = mysql_query('SHOW TABLES LIKE \''.$tablepre.'%\'');

	while($t = mysql_fetch_array($query,MYSQL_ASSOC)) {

		$tablearray[] = $t[$tablename];

	}

	$table = $tablearray["$tableno"];

	$query = mysql_query('SHOW TABLE STATUS LIKE '.'\''.$table.'\'');

	$tableinfo = array();

	

	while($t = mysql_fetch_array($query,MYSQL_ASSOC)) {

		$charset = explode('_',$t['Collation']);

		$t['Collation'] = $charset[0];

		$tableinfo = $t;

	}

	if($allowcharset[$tableinfo['Collation']] != $todbcharset && $allowcharset[$todbcharset] != $tableinfo['Collation']){

		if(strpos($tableinfo['Name'],$todbcharset) == 0) {

			$table = '';

		} else {

			echo "<h4>$title</h4><br><br><table><tr><th>????</th></tr><tr><td>$tableinfo[Name] ????????</td></tr></table>";

			exit;

		}

	}

	mysql_query("SET NAMES '$tableinfo[Collation]'");

	

	if($do == 'create') {

		$tablecreate=array();

		foreach ($tablearray as $key => $value){

			$query=mysql_query("SHOW CREATE TABLE $value");

			while($t = mysql_fetch_array($query,MYSQL_ASSOC)){

				$t['Create Table'] = str_replace($tablepre,$whereis.'_',$t['Create Table']);

				$t['Create Table'] = str_replace("$tableinfo[Collation]","$todbcharset",$t['Create Table']);

				$t['Create Table'] = str_replace($whereis.'_',$todbcharset.$whereis.'_',$t['Create Table']);

				$t['Table'] = str_replace($tablepre,$todbcharset.$whereis.'_',$t['Table']);

				$tablecreate[]=$t;

			}

		}

		mysql_query('SET NAMES \''.$todbcharset.'\'');

		if(mysql_get_server_info() > '5.0'){

			mysql_query("SET sql_mode=''");

		}

		foreach ($tablecreate as $key => $value){

			mysql_query("DROP TABLE IF EXISTS `$value[Table]`");

			mysql_query($value['Create Table']);

			$count++;			

		}

		$toolstip .= '?????????????? '.$count.' ???<br>';

		show_tools_message($toolstip,"tools.php?action=datago&do=data&fromdbname=$fromdbname&todbcharset=$todbcharset&submit=%D7%AA%BB%BB");



	} elseif($do == 'data') {

		$count = 0;

		$data = array();

		$newtable = str_replace($tablepre,$todbcharset.$whereis.'_',$table);

		if($table) {

			mysql_query("SET NAMES '$tableinfo[Collation]'");

			$query = mysql_query("SELECT * FROM $table LIMIT $start,$limit");

			

			while($t = mysql_fetch_array($query,MYSQL_ASSOC)) {

				$data[] = $t;	

			}			

			unset($t);			

			$todbcharset2 = $todbcharset;

			if($tableinfo['Collation'] == 'utf8' || $todbcharset=='utf8'){

				$todbcharset2 = $tableinfo['Collation'];

			}

			mysql_query('SET NAMES \''.$todbcharset2.'\'');

			if(mysql_get_server_info() > '5.0'){

				mysql_query("SET sql_mode=''");

			}

			if($start == 0){

				mysql_query("TRUNCATE TABLE $newtable");

			}



			foreach($data as $key => $value){

				$sql='';

				foreach($value as $tokey => $tovalue){

					$tovalue = addslashes($tovalue);

					$sql = $sql ? $sql.",'".$tovalue."'" : "'".$tovalue."'";

				}

				mysql_query("INSERT INTO $newtable VALUES($sql)") or mysql_errno();

				$count++;

			}

			if($count == $limit) {

				$start += $count;

				show_tools_message("???? $table ??? $start ??????? $limit ???","tools.php?action=datago&do=data&fromdbname=$fromdbname&todbcharset=$todbcharset&tableno=$tableno&start=$start&submit=%D7%AA%BB%BB");

			} else {

				$tableno ++;

				show_tools_message("???? $table ??? $start ??????? $limit ???","tools.php?action=datago&do=data&fromdbname=$fromdbname&todbcharset=$todbcharset&tableno=$tableno&submit=%D7%AA%BB%BB",$time='1000');

			}

		} elseif($dbcharset == 'latin1' || $todbcharset == 'latin1') {

			echo "<div class=\"specialdiv2\" id=\"serialize\">?????<ul>

				</ul></div>";

			echo '<script>$("serialize").innerHTML+="<li>????????????????<font color=red>'.$todbcharset.$whereis.'_ </font></li>";

				$("serialize").scrollTop=$("serialize").scrollHeight;</script>';

		} else {

			$toolstip = '?????????????????';

			show_tools_message($toolstip,"tools.php?action=datago&do=serialize&fromdbname=$fromdbname&todbcharset=$todbcharset&submit=%D7%AA%BB%BB");

		}

		

	} elseif($do == 'serialize' && $dbcharset!='latin1' && $todbcharset!='latin1') {

		if($whereis == 'is_ss') {

			$a = array('0','1','2','3','4','5','6','7','8','9','a','b','c','d','e','f');

			foreach($a as $num) {

				mysql_query("TRUNCATE TABLE ".$todbcharset.$whereis.'_'."cache_".$num);

			}

		}

		$arr = getlistarray($whereis,'datago');

		$limit = '3000';

		echo "<div class=\"specialdiv2\" id=\"serialize\">?????<ul>

					</ul></div>";

		foreach($arr as $field) {

			$stable = $todbcharset.$whereis.'_'.$field[0];

			$sfield = $field[1];

			$sid	= $field[2];

			$query = mysql_query("SELECT $sid,$sfield FROM $stable ORDER BY $sid DESC LIMIT $limit");

			while($values = mysql_fetch_array($query,MYSQL_ASSOC)) {

				$data = $values[$sfield];

				$id   = $values[$sid];

				$data = preg_replace_callback('/s:([0-9]+?):"([\s\S]*?)";/','_serialize',$data);

				$data = taddslashes($data);

				if(mysql_query("update `$stable` set `$sfield`='$data' where `$sid`='$id'")) {

					$toolstip = $stable.' ?? '.$sid.' ? '.$id.' ? '.$sfield.' ???????<br/>';

				} else {

					$toolstip = $stable.' ?? '.$sid.' ? '.$id.' ? '.$sfield.' ???<font color=red>????</font><br/>';

				}

				echo '<script>$("serialize").innerHTML+="'.$toolstip.'";

					$("serialize").scrollTop=$("serialize").scrollHeight;</script>';

			}

		}

		mysql_close($mysql);

		echo '<script>$("serialize").innerHTML+="<li>????????????????????????<font color=red>'.$todbcharset.$whereis.'_ </font></li>";

			$("serialize").scrollTop=$("serialize").scrollHeight;</script>';

	}

}



function _config_form($title = '',$varname = '',$end = '1') {

	global $$varname;

	$ucapi = UC_API;

	$ucip = UC_IP;

	$form = '';

	$form .= "<th width=20%>$title</th>";

	if($$varname  || isset($$varname)) {

		$form .= "<td><input class=textinput name=".$varname."2 value=".$$varname."></input></td>";

	} else {

		$form .= "<td></td>";	

	}

	if($end == '1') {

		$form .= '';		

	} elseif ($end == '2') {

		$form .= '</tr>';

	} elseif ($end == '3') {

		$form .= '</tr><tr>';	

	}

	echo $form;	

}

function all_doconfig_output($whereis){

	global $uc_dbhost, $uc_dbuser, $uc_dbpw, $uc_dbname,$uc_tablepre,$dbhost, $dbuser, $dbpw, $dbname, $dbcfg, $tablepre,$dbcharset,$uc_dbcharset;

	echo '<h5>????</h5>';

	echo '<form method=post action=?action=all_config><table>

		<tbody>

		<tr>';

	if($whereis != 'is_uc') {

		_config_form($title = '??????',$varname = 'dbhost');

	}

	_config_form($title = 'UCenter ??????',$varname = 'uc_dbhost',$end = '3');



	if($whereis != 'is_uc') {

		_config_form($title = '???????',$varname = 'dbuser');	

	}

	_config_form($title = 'UCenter ???????',$varname = 'uc_dbuser',$end = '3');



	if($whereis != 'is_uc') {

		echo _config_form($title = '??????',$varname = 'dbpw');

	}

	_config_form($title = 'UCenter ??????',$varname = 'uc_dbpw',$end = '3');



	if($whereis != 'is_uc') {

		_config_form($title = '?????',$varname = 'dbname');

	}

	_config_form($title = 'UCenter ?????',$varname = 'uc_dbname',$end = '3');

	

	if($whereis != 'is_uc') {

		_config_form($title = '??????',$varname = 'tablepre');

	}

	_config_form($title = 'UCenter ??????',$varname = 'uc_tablepre',$end = '3');



	if($whereis != 'is_uc') {

		_config_form($title = '??????',$varname = 'dbcharset');

	}

	_config_form($title = 'UCenter ??????',$varname = 'uc_dbcharset',$end = '3');



	if($whereis != 'is_uc') {

		_config_form();

		_config_form($title = 'UCenter ???',$varname = 'ucapi',$end = '3');

	}

	

	if($whereis != 'is_uc') {

		_config_form();

		_config_form($title = 'UCenter IP?',$varname = 'ucip',$end = '2');

	}

	echo		'</tbody>

			</table>

			<input name=submit type=submit value=??></input>

			</form>';

}



function all_doconfig_modify($whereis){

	global $dbhost2, $dbuser2, $dbpw2, $dbname2, $tablepre2,$dbcharset2;

	if($whereis == 'is_dz') {

		//  /\$dbhost.+;/i

		if(file_exists('./uc_server/data/config.inc.php')) {

			$config = file_get_contents('./uc_server/data/config.inc.php');

			writefile('./uc_server/data/config.bak.php.'.time(),$config);

			$config = uc_doconfig_modify($config);

			writefile('./uc_server/data/config.inc.php',$config);

		}

		$config = file_get_contents('./config.inc.php');

		writefile('./forumdata/config.bak.php.'.date(ymd,time()),$config);

		$config = preg_replace('/\$dbhost.+;/i','$dbhost = \''.$dbhost2.'\';',$config);

		$config = preg_replace('/\$dbuser.+;/i','$dbuser = \''.$dbuser2.'\';',$config);

		$config = preg_replace('/\$dbpw.+;/i','$dbpw = \''.$dbpw2.'\';',$config);

		$config = preg_replace('/\$dbname.+;/i','$dbname = \''.$dbname2.'\';',$config);

		$config = preg_replace('/\$tablepre.+;/i','$tablepre = \''.$tablepre2.'\';',$config);

		$config = preg_replace('/\$dbcharset.+;/i','$dbcharset = \''.$dbcharset2.'\';',$config);

		$config = uc_doconfig_modify($config);

		if(writefile('./config.inc.php',$config)) {

			show_tools_message('?????????????????????forumdata????','tools.php?action=all_config');

		}

	} elseif($whereis == 'is_uch' || $whereis == 'is_ss') {

		$config = file_get_contents('./config.php');

		writefile('./data/config.bak.php.'.date(ymd,time()),$config);

		$config = preg_replace('/\$_SC\[\'dbhost\'\].+;/i','$_SC[\'dbhost\'] = \''.$dbhost2.'\';',$config);

		$config = preg_replace('/\$_SC\[\'dbuser\'\].+;/i','$_SC[\'dbuser\'] = \''.$dbuser2.'\';',$config);

		$config = preg_replace('/\$_SC\[\'dbpw\'\].+;/i','$_SC[\'dbpw\'] = \''.$dbpw2.'\';',$config);

		$config = preg_replace('/\$_SC\[\'dbname\'\].+;/i','$_SC[\'dbname\'] = \''.$dbname2.'\';',$config);

		$config = preg_replace('/\$_SC\[\'tablepre\'\].+;/i','$_SC[\'tablepre\'] = \''.$tablepre2.'\';',$config);

		$config = preg_replace('/\$_SC\[\'dbcharset\'\].+;/i','$_SC[\'dbcharset\'] = \''.$dbcharset2.'\';',$config);

		$config = uc_doconfig_modify($config);

		if(writefile('./config.php',$config)) {

			show_tools_message('?????????????????????data????','tools.php?action=all_config');

		}

	} elseif($whereis == 'is_uc') {

		$config = file_get_contents('./data/config.inc.php');

		writefile('./data/config.bak.php.'.date(ymd,time()),$config);

		$config = uc_doconfig_modify($config);

		if(writefile('./data/config.inc.php',$config)) {

			show_tools_message('?????????????????????data????','tools.php?action=all_config');

		}

	}

}



function uc_doconfig_modify($config='') {

	global $uc_dbhost2, $uc_dbuser2, $uc_dbpw2, $uc_dbname2,$uc_tablepre2,$ucapi2,$ucip2,$uc_dbcharset2;

	$config = preg_replace('/define\(\'UC_DBHOST\'.+;/i','define(\'UC_DBHOST\', \''.$uc_dbhost2.'\');',$config);

	$config = preg_replace('/define\(\'UC_DBUSER\'.+;/i','define(\'UC_DBUSER\', \''.$uc_dbuser2.'\');',$config);

	$config = preg_replace('/define\(\'UC_DBPW\'.+;/i','define(\'UC_DBPW\', \''.$uc_dbpw2.'\');',$config);

	$config = preg_replace('/define\(\'UC_DBNAME\'.+;/i','define(\'UC_DBNAME\', \''.$uc_dbname2.'\');',$config);

	$config = preg_replace('/define\(\'UC_DBTABLEPRE\'.+;/i','define(\'UC_DBTABLEPRE\', \''.$uc_tablepre2.'\');',$config);

	$config = preg_replace('/define\(\'UC_DBCHARSET\'.+;/i','define(\'UC_DBCHARSET\', \''.$uc_dbcharset2.'\');',$config);

	$config = preg_replace('/define\(\'UC_API\'.+;/i','define(\'UC_API\', \''.$ucapi2.'\');',$config);

	$config = preg_replace('/define\(\'UC_IP\'.+;/i','define(\'UC_IP\', \''.$ucip2.'\');',$config);

	return $config;

}



function writefile($filename, $writetext, $openmod='w') {

	if(@$fp = fopen($filename, $openmod)) {

		flock($fp, 2);

		fwrite($fp, $writetext);

		fclose($fp);

		return true;

	} else {

		return false;

	}

}



function xml2array($xml) {

	$arr = xml_unserialize($xml, 1);

	preg_match('/<error errorCode="(\d+)" errorMessage="([^\/]+)" \/>/', $xml, $match);

	$arr['error'] = array('errorcode' => $match[1], 'errormessage' => $match[2]);

	return $arr;

}



function getbakurl($whereis,$action) {

	if ($whereis != 'is_uc') {

		require_once './uc_client/client.php';

		require_once './uc_client/model/base.php';

	} else {

		define('IN_UC',TRUE);

		define('UC_ROOT','./');

		require_once './model/base.php';	

	}



	$base = new base();

	$salt = substr(uniqid(rand()), -6);

	$action = !empty($action) ? $action : 'export';

	$url = 'http://'.$_SERVER['HTTP_HOST'].str_replace('tools.php', 'api/dbbak.php', $_SERVER['PHP_SELF']);

	if($whereis == 'is_dz') {

		$apptype = 'discuz';

	} elseif ($whereis == 'is_uc') {

		$apptype = 'ucenter';

	} elseif ($whereis == 'is_uch') {

		$apptype = 'uchome';

	} elseif ($whereis == 'is_ss') {

		$apptype = 'supesite';

	}

	$url .= '?apptype='.$apptype;

	$code = $base -> authcode('&method='.$action.'&time='.time(), 'ENCODE', UC_KEY);

	$url .= '&code='.urlencode($code);

	return $url;

}



function dobak($url,$num = '1') {

	global $whereis;

	$num = !empty($num) ? $num : '0';

	$return = file_get_contents($url);

	if($whereis != 'is_uc') {

		require_once './uc_client/lib/xml.class.php';

	} else {

		require_once './lib/xml.class.php';	

	}

	$arr = xml2array($return);

	

	if($arr['error']['errormessage'] == 'explor_success') {

		echo "<div class=\"specialdiv\">?????<ul>

			<li>>>>>>>>>????<<<<<<<<</li>

			<li>>>>>>>>>??".$num."???<<<<<<<<</li>

			</ul></div>";

	} else {

		$num ++;

		echo "<div class=\"specialdiv\">?????<ul>

			<li>".$arr['fileinfo']['file_name']."......".$arr['error']['errormessage']."</li>

			</ul></div>";

	}

	if($arr['nexturl']) {

		$url = './tools.php?action=all_backup&nexturl='.urlencode($arr['nexturl']).'&num='.$num;

		show_tools_message($arr['fileinfo']['file_name'],$url,$time = 2000);

	}

}

	

function getgpc($k, $var='G') {

	switch($var) {

		case 'G': $var = &$_GET; break;

		case 'P': $var = &$_POST; break;

		case 'C': $var = &$_COOKIE; break;

		case 'R': $var = &$_REQUEST; break;

	}

	return isset($var[$k]) ? $var[$k] : NULL;

}



function getlistarray($whereis,$type) {

	global $dz_version,$ss_version,$uch_version;

	if($whereis == 'is_dz' && $dz_version >= '710') {

		if($type == 'datago') {

			$list = array(

				array('advertisements','parameters','advid'),

				array('request','value','variable'),

				array('settings','value','variable'),

			);

		}

	} elseif($whereis == 'is_uch' && $uch_version >= '15') {

		if($type == 'datago') {

			$list = array(

				array('ad','adcode','adid'),

				array('blogfield','tag','blogid'),

				array('blogfield','related','blogid'),

				array('feed','title_data','feedid'),

				array('feed','body_data','feedid'),

				array('share','body_data','sid'),

			);	

		}

	} elseif($whereis == 'is_uc') {

		if($type == 'datago') {

			$list = array(

				array('feed','title_data','feedid'),

				array('feed','body_data','feedid'),

				array('settings','v','k'),

			);

		}

	} elseif($whereis == 'is_ss' && $ss_version >=70) {

		if($type == 'datago') {

			$list = array(

				array('ads','parameters','adid'),

				array('blocks','blocktext','blockid'),

			);

		}

	}

	return $list;

}



function _serialize($str) {

	global $dbcharset,$todbcharset;

	$charset = $dbcharset == 'utf8' ? 'utf-8':$dbcharset;

	$tempdbcharset = $todbcharset == 'utf8' ? 'utf-8':$todbcharset;

	$charset = strtoupper($charset);

	$tempdbcharset = strtoupper($tempdbcharset);

	$temp = iconv($charset,$tempdbcharset,$str[2]);

	$l = strlen($temp);

	return 's:'.$l.':"'.$str[2].'";';

}



function ping($whereis) {

	global $plustitle,$dbhost,$dbuser,$dbpw,$dbname,$uc_dbhost,$uc_dbuser,$uc_dbpw,$uc_dbname;

	if($whereis != 'is_uc')	{

		$ping = @mysql_connect($dbhost,$dbuser,$dbpw);

		if($ping) {

			$message = "?????:<font color=green>[??]</font>......";

			if (mysql_select_db($dbname,$ping)) {

				$message .= " $dbname ???<font color=green>[??]</font>";

			} else {

				$message .= " $dbname ???<font color=red>[???]</font>";	

			}

			mysql_close($ping);

		} else {

			$message = "?????:<font color=red>[??]</font> ";	

		}

		$message .= '<br/>';

		if(file_get_contents(UC_API.'/index.php')) {

			$message .= 'UCenter <font color=green>[????]</font>......';	

		} else {

			$message .= 'UCenter <font color=red>[????]</font>......';

		}

	}

	$ping = @mysql_connect($uc_dbhost,$uc_dbuser,$uc_dbpw);

	if($ping) {

		$message .= "UCenter ?????:<font color=green>[??]</font>......";

		if (mysql_select_db($uc_dbname,$ping)) {

			$message .= " $uc_dbname ???<font color=green>[??]</font>";

		} else {

			$message .= " $uc_dbname ???<font color=red>[???]</font>";	

		}

		mysql_close($ping);

	} else {

		$message .= "UCenter ?????:<font color=red>[??]</font> ";		

	}

	$message .= '<br/>';

	echo '<script>$(\'ping\').innerHTML += \''.$plustitle.' '.$message.'\'</script>';

}



function checkfilesoutput($modifylists,$deletedfiles,$unknownfiles) {

	$modifystats = (count($modifylists)) > 0 ? '<a href="?action=dz_filecheck&detail=modifytrue&begin=1">????</a>': '';

	$delstats = (count($deletedfiles)) > 0 ? '<a href="?action=dz_filecheck&detail=deltrue&begin=1">????</a>': '';

	$unknowtrue = (count($unknownfiles)) > 0 ? '<a href="?action=dz_filecheck&detail=unknowtrue&begin=1">????</a>': '';

	echo '<pre>';

	echo "?????: ".count($modifylists) .$modifystats."<br />????: ".count($deletedfiles).$delstats."<br />????:".count($unknownfiles).$unknowtrue;

	echo '</pre>';

	echo '----------------------------------------------------------------------------<br>';

	if (!empty($_GET['detail'])){

		$predir = '';

		if ($_GET['detail'] == 'modifytrue'){

			echo'?????:<br />';

			foreach ($modifylists as $value){

				$vdir = explode('/',$value);

				$vdir[0] = $vdir[0] == '.' ? '?' : $vdir[0]; 

				if($vdir[0] != $predir) {

					$predir = $vdir[0];

					echo "<span class='current'>".$predir."??</span><br/>";

				}

				echo "&nbsp;&nbsp;&nbsp;".$value."<br/>";

			}

		}elseif($_GET['detail'] == 'deltrue'){

			echo '????:<br />';

			foreach ($deletedfiles as $value){

				$vdir = explode('/',$value);

				$vdir[0] = $vdir[0] == '.' ? '?' : $vdir[0]; 

				if($vdir[0] != $predir) {

					$predir = $vdir[0];

					echo "<span class='current'>".$predir."??</span><br/>";

				}

				echo "&nbsp;&nbsp;&nbsp;".$value."<br/>";

			}

		}elseif($_GET['detail'] == 'unknowtrue'){

			echo '????:<br />';

			foreach ($unknownfiles as $value){

				$vdir = explode('/',$value);

				$vdir[0] = $vdir[0] == '.' ? '?' : $vdir[0]; 

				if($vdir[0] != $predir) {

					$predir = $vdir[0];

					echo "<span class='current'>".$predir."??</span><br/>";

				}

				echo "&nbsp;&nbsp;&nbsp;".$value."<br/>";

			}

		}

	}	

}



function docheckfiles($dz_files,$md5data) {

	global $modifylists,$deletedfiles,$unknownfiles;

	foreach($dz_files as $line) {

		$file = trim(substr($line, 34));

		$md5datanew[$file] = substr($line, 0, 32);

		$md5 = substr($line, 34);

		if (empty($md5data[$file]))

		{

			$deletedfiles[] = $file;

			$deltrue = 1;

			continue;

		}



		if($md5datanew[$file] != $md5data[$file]) {

			$modifylists[$file] = $file;

			$modifytrue = 1;

		}

		

	}



	$addlist = @array_diff_assoc($md5data, $md5datanew);



	if (empty($modifylists)) {

		foreach ($addlist as $file => $value){

			$unknownfiles[$file] = $file;

		}

	} else {

		foreach ($addlist as $file => $value){

			$dir = dirname($file);

			if (!array_key_exists($file, $modifylists)){

				$unknownfiles[$file] = $file;

				$unknowtrue = 1;

			}

		}

	}	

}



function infobox($str,$link) {

	if($link) {

		$button = "<input class='button' type='submit' onclick=\"location.href='".$link."'\" value='??' name='submit'/>";	

	}

	echo "<div class='infobox'><p>$str</p>$button</div>";

}

?>