sys_repair.php | searchcode

/uploads/dede/sys_repair.php

http://pj-photohost.googlecode.com/
PHP | 286 lines | 278 code | 2 blank | 6 comment | 9 complexity | d5d3ca8d88eb98a03d01a401c724fac0 MD5 | raw file
Possible License(s): LGPL-2.1

<?php

require_once(dirname(__FILE__).'/config.php');

CheckPurview('sys_ArcBatch');

require_once(dirname(__FILE__).'/../include/oxwindow.class.php');

ShowMsg("?????????????????????????????<br /><a href='index_body.php'>&lt;&lt;?????&gt;&gt;</a>", "javascript:;");

exit();

if(empty($dopost))

{

	$win = new OxWindow();

	$win->Init("sys_repair.php","js/blank.js","POST' enctype='multipart/form-data' ");

	$win->mainTitle = "??????";

	$wecome_info = "<a href='index_body.php'>????</a> &gt;&gt; ????????";

	$win->AddTitle('?????????????????????');

	$msg = "

	<table width='98%' border='0' cellspacing='0' cellpadding='0' align='center'>

  <tr>

    <td height='250' valign='top'>

    <br />

    ???????????????SQL???????????????????????????????????????????<br /><br />

    <b>??????????????</b><br />

    1????DedeCms V5.3??????????????<br />

    2?????dede_arctiny?????<br />

    3??????????????????????id??????<br />

    <br />

    <br />

    <a href='sys_repair.php?dopost=1' style='font-size:14px;color:red'><b>???????????&gt;&gt;</b></a>

    <br /><br /><br />

    </td>

  </tr>

 </table>

	";

	$win->AddMsgItem("<div style='padding-left:20px;line-height:150%'>$msg</div>");

	$winform = $win->GetWindow('hand','');

	$win->Display();

	exit();

}

/*-------------------

??????

function 1_test_db() {  }

--------------------*/

else if($dopost==1)

{

	$msg = '';

	$dsql->Execute('n',"Show Create Table `#@__arctiny` ");

	$row = $dsql->GetArray('n', MYSQL_BOTH);

	if(!eregi('typeid2', $row[1]))

	{

		$rs = $dsql->ExecuteNoneQuery(" ALTER TABLE `#@__arctiny`  ADD `typeid2` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL AFTER `typeid` ; ");

		if($rs) $msg .= "??? #@__arctiny ???????typeid2??????<br />";

		else $msg .= "<font color='red'>??? #@__arctiny ???????typeid2??????</font><br />";

	}

	else

	{

		$msg .= "??? #@__arctiny ??????????<br />";

	}

	$dsql->Execute('n',"Show Create Table `#@__archives` ");

	$row = $dsql->GetArray('n', MYSQL_BOTH);

	if(!eregi('typeid2', $row[1]))

	{

		$rs = $dsql->ExecuteNoneQuery(" ALTER TABLE `#@__archives`  ADD `typeid2` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL AFTER `typeid` ; ");

		if($rs) $msg .= "?? #@__archives ???????typeid2??????<br />";

		else $msg .= "<font color='red'>?? #@__archives ???????typeid2??????</font><br />";

	}

	else

	{

		$msg .= "??? #@__archives ??????????<br />";

	}

	

	$upsqls[] = "ALTER TABLE `#@__tagindex` CHANGE `tag` `tag` VARCHAR( 20 ) NOT NULL default ''; ";

	$upsqls[] = "ALTER TABLE `#@__taglist` CHANGE `tag` `tag` VARCHAR( 20 ) NOT NULL default ''; ";

	$upsqls[] = "ALTER TABLE `#@__archives` CHANGE `litpic` `litpic` VARCHAR( 80 ) NOT NULL default ''; ";

	$upsqls[] = "INSERT INTO `#@__sysconfig` (`aid` ,`varname` ,`info` ,`value` ,`type` ,`groupid`) VALUES (713, 'cfg_need_typeid2', '???????', 'N', 'bool', 6); ";

  $upsqls[] = "INSERT INTO `#@__sysconfig` (`aid` ,`varname` ,`info` ,`value` ,`type` ,`groupid`) VALUES (715, 'cfg_mb_pwdtype', '???????????32  32?md5????<br />l16  ?16?? r16  ?16?? m16  ??16?', '32', 'string', 4); ";

  $upsqls[] = "Update `#@__sysconfig` set `groupid` = '8' where `varname` like 'cfg_group_%'; ";

  $upsqls[] = "ALTER TABLE `#@__arccache` ADD `stylehash` CHAR(32) NOT NULL default '' AFTER `md5hash`; ";

	

	$msg .= "????????????????????SQL?????????????????...<br />";

	foreach($upsqls as $upsql)

	{

		$rs = $dsql->ExecuteNoneQuery($upsql);

		$msg .= "ˇ?? <font color='green'>".$upsql."</font> ok!<br />";

	}

	

	$msg .= "??? #@__advancedsearch ?????...<br />";

	

	$createQuery = "CREATE TABLE IF NOT EXISTS `#@__advancedsearch` (

  	`mid` int(11) NOT NULL,

  	`maintable` varchar(255) NOT NULL default '',

  	`mainfields` text,

  	`addontable` varchar(255) default '',

  	`addonfields` text,

  	`forms` text,

  	`template` varchar(255) NOT NULL default '',

  	UNIQUE KEY `mid` (`mid`)

  ) TYPE=MyISAM; ";

	$dsql->ExecuteNoneQuery($createQuery);

	

	$win = new OxWindow();

	$win->Init("sys_repair.php","js/blank.js","POST' enctype='multipart/form-data' ");

	$win->mainTitle = "??????";

	$wecome_info = "<a href='sys_repair.php'>????????</a> &gt;&gt; ??????";

	$win->AddTitle('?????????????????????');

	$msg = "

	<table width='98%' border='0' cellspacing='0' cellpadding='0' align='center'>

  <tr>

    <td height='250' valign='top'>

    {$msg}

    <b><font color='green'>?????????????</font></b>

    <hr size='1'/>

    <br />

    <b>????????????????????????</b><br />

    1??????????????????<br />

    2??????archives????<br />

    3?????????????????<br />

    <br />

    <a href='sys_repair.php?dopost=2' style='font-size:14px;'><b>??????????&gt;&gt;</b></a>

    <br /><br /><br />

    </td>

  </tr>

 </table>

	";

	$win->AddMsgItem("<div style='padding-left:20px;line-height:150%'>$msg</div>");

	$winform = $win->GetWindow('hand','');

	$win->Display();

	exit();

}

/*-------------------

????????????

function 2_test_arctiny() {  }

--------------------*/

else if($dopost==2)

{

  $msg = '';

  

  $allarcnum = 0;

  $row = $dsql->GetOne("Select count(*) as dd From `#@__archives` ");

  $allarcnum = $arcnum = $row['dd'];

  $msg .= "ˇ#@__archives ?????? {$arcnum} <br />";

  

  $shtables = array();

  $dsql->Execute('me', " Select addtable From `#@__channeltype` where id < -1 ");

  while($row = $dsql->GetArray('me') )

  {

  	$addtable = strtolower(trim(str_replace('#@__', $cfg_dbprefix, $row['addtable'])));

  	if(empty($addtable)) {

  		continue;

  	}

  	else

  	{

  		if( !isset($shtables[$addtable]) )

  		{

  			$shtables[$addtable] = 1;

  			$row = $dsql->GetOne("Select count(aid) as dd From `$addtable` ");

  			$msg .= "ˇ{$addtable} ?????? {$row['dd']} <br />";

  			$allarcnum += $row['dd'];

  		}

  	}

  }

  $msg .= "???????? {$allarcnum} <br /> ";

  $errall = "<a href='index_body.php' style='font-size:14px;'><b>??????????&gt;&gt;</b></a>";

  $row = $dsql->GetOne("Select count(*) as dd From `#@__arctiny` ");

  $msg .= "????????? {$row['dd']}<br />";

  if($row['dd']==$allarcnum)

  {

  	$msg .= "<p style='color:green;font-size:16px'><b>????????????</b></p><br />";

  }

  else

  {

  	$sql = " TRUNCATE TABLE `#@__arctiny`";

		$dsql->executenonequery($sql);

	  $msg .= "<font color='red'>????????????????...</font><br />";

		//?????????

		$sql = "insert into `#@__arctiny`(id, typeid, typeid2, arcrank, channel, senddate, sortrank, mid)  

	        Select id, typeid, typeid2, arcrank, channel, senddate, sortrank, mid from `#@__archives` ";

		$dsql->executenonequery($sql);

		//?????????

		foreach($shtables as $tb=>$v)

		{

			$sql = "insert into `#@__arctiny`(id, typeid, typeid2, arcrank, channel, senddate, sortrank, mid)  

			        Select aid, typeid, 0, arcrank, channel, senddate, 0, mid from `$tb` ";

			$rs = $dsql->executenonequery($sql); 

			$doarray[$tb]  = 1;

		}

		$row = $dsql->GetOne("Select count(*) as dd From `#@__arctiny` ");

		if($row['dd']==$allarcnum)

    {

    	$msg .= "<p style='color:green;font-size:16px'><b>???????</b></p><br />";

    }

    else

    {

    	$msg .= "<p style='color:red;font-size:16px'><b>??????????????????</b></p><br />";

    	$errall = " <a href='sys_repair.php?dopost=3' style='font-size:14px;'><b>?????????&gt;&gt;</b></a> ";

    }

  }

  UpDateCatCache();

  $win = new OxWindow();

	$win->Init("sys_repair.php","js/blank.js","POST' enctype='multipart/form-data' ");

	$win->mainTitle = "??????";

	$wecome_info = "<a href='sys_repair.php'>????????</a> &gt;&gt; ???????";

	$win->AddTitle('?????????????????????');

	$msg = "

	<table width='98%' border='0' cellspacing='0' cellpadding='0' align='center'>

  <tr>

    <td height='250' valign='top'>

    {$msg}

    <hr />

    <br />

    {$errall}

    </td>

  </tr>

 </table>

	";

	$win->AddMsgItem("<div style='padding-left:20px;line-height:150%'>$msg</div>");

	$winform = $win->GetWindow('hand','');

	$win->Display();

	exit();

}

/*-------------------

????????(???????????)

function 3_re_arctiny() {  }

--------------------*/

else if($dopost==3)

{

  $errnum = 0;

  $sql = " TRUNCATE TABLE `#@__arctiny`";

	$dsql->executenonequery($sql);

	

	$sql = "Select arc.id, arc.typeid, arc.typeid2, arc.arcrank, arc.channel, arc.senddate, arc.sortrank,

	        arc.mid, ch.addtable FROM `#@__archives` arc left join `#@__channeltype` ch on ch.id=arc.channel ";

  $dsql->Execute('me', $sql);

  while($row = $dsql->GetArray('me') )

  {

      $sql = "Insert Into `#@__arctiny`(id, typeid, typeid2, arcrank, channel, senddate, sortrank, mid)

              Values('{$row['id']}','{$row['typeid']}','{$row['typeid2']}','{$row['arcrank']}',

             '{$row['channel']}','{$row['senddate']}','{$row['sortrank']}','{$row['mid']}');  ";

      $rs = $dsql->executenonequery($sql);

      if(!$rs)

      {

      	$addtable = trim($addtable);

      	$errnum ++;

      	$dsql->executenonequery("Delete From `#@__archives` where id='{$row['id']}' ");

      	if(!empty($addtable)) $dsql->executenonequery("Delete From `$addtable` where id='{$row['id']}' ");

      }

  }

  //?????????

	$dsql->SetQuery("Select id,addtable From `#@__channeltype` where id < -1 ");

	$dsql->Execute();

	$doarray = array();

	while($row = $dsql->GetArray())

	{

		$tb = str_replace('#@__', $cfg_dbprefix, $row['addtable']);

		if(empty($tb) || isset($doarray[$tb]) )

		{

			continue;

		}

		else

		{

			$sql = "insert into `#@__arctiny`(id, typeid, typeid2, arcrank, channel, senddate, sortrank, mid)  

			        Select aid, typeid, 0, arcrank, channel, senddate, 0, mid from `$tb` ";

			$rs = $dsql->executenonequery($sql); 

			$doarray[$tb]  = 1;

		}

	}

	$win = new OxWindow();

	$win->Init("sys_repair.php","js/blank.js","POST' enctype='multipart/form-data' ");

	$win->mainTitle = "??????";

	$wecome_info = "<a href='sys_repair.php'>????????</a> &gt;&gt; ????????";

	$win->AddTitle('?????????????????????');

	$msg = "

	<table width='98%' border='0' cellspacing='0' cellpadding='0' align='center'>

  <tr>

    <td height='250' valign='top'>

    ??????????????? {$errnum} ??

    <hr />

    <br />

    <a href='index_body.php' style='font-size:14px;'><b>??????????&gt;&gt;</b></a>

    </td>

  </tr>

 </table>

	";

	$win->AddMsgItem("<div style='padding-left:20px;line-height:150%'>$msg</div>");

	$winform = $win->GetWindow('hand','');

	$win->Display();

	exit();

}

?>