leyu_admin/admin/sys_data_replace.php

<?php
/**
 * 数据库操作替换
 *
 * @version        $Id: sys_data_replace.php 1 22:28 2010年7月20日Z tianya $
 * @package        DedeCMS.Administrator
 * @copyright      Copyright (c) 2007 - 2010, DesDev, Inc.
 * @license        http://help.dedecms.com/usersguide/license.html
 * @link           http://www.dedecms.com
 */
require_once(dirname(__FILE__).'/config.php');
CheckPurview('sys_Data');
if(empty($action)) $action = '';
if(empty($action))
{
    require_once(DEDEADMIN."/templets/sys_data_replace.htm");
    exit();
}

/*-------------------------------
//列出数据库表里的字段
function __getfields()
--------------------------------*/
else if($action=='getfields')
{
    AjaxHead();
    $dsql->GetTableFields($exptable);
    echo "<div style='border:1px solid #ababab;background-color:#FEFFF0;margin-top:6px;padding:3px;line-height:160%'>";
    echo "表(".$exptable.")含有的字段：<br>";
    while($row = $dsql->GetFieldObject())
    {
        echo "<a href=\"javascript:pf('{$row->name}')\"><u>".$row->name."</u></a>\r\n";
    }
    echo "</div>";
    exit();
}
/*-------------------------------
//保存用户设置，清空会员数据
function __Apply()
--------------------------------*/
else if($action=='apply')
{
    $validate = empty($validate) ? '' : strtolower($validate);
    $svali = GetCkVdValue();
    if($validate == "" || $validate != $svali)
    {
        ShowMsg("安全确认码不正确!", "javascript:;");
        exit();
    }
    if($exptable == '' || $rpfield == '')
    {
        ShowMsg("请指定数据表和字段！", "javascript:;");
        exit();
    }
    if($rpstring=='')
    {
        ShowMsg("请指定被替换内容！", "javascript:;");
        exit();
    }
    if($rptype=='replace')
    {
        $condition = empty($condition) ? '' : " WHERE $condition ";
        $rs = $dsql->ExecuteNoneQuery("UPDATE $exptable SET $rpfield=REPLACE($rpfield,'$rpstring','$tostring') $condition ");
        $dsql->ExecuteNoneQuery("OPTIMIZE TABLE `$exptable`");
        if($rs)
        {
            ShowMsg("成功完成数据替换！", "javascript:;");
            exit();
        }
        else
        {
            ShowMsg("数据替换失败！", "javascript:;");
            exit();
        }
    }
    else
    {
        $condition = empty($condition) ? '' : " And $condition ";
        $rpstring = stripslashes($rpstring);
        $rpstring2 = str_replace("\\","\\\\",$rpstring);
        $rpstring2 = str_replace("'","\\'",$rpstring2);
        $dsql->SetQuery("SELECT $keyfield,$rpfield FROM $exptable WHERE $rpfield REGEXP '$rpstring2'  $condition ");
        $dsql->Execute();
        $tt = $dsql->GetTotalRow();
        if($tt==0)
        {
            ShowMsg("根据你指定的正则，找不到任何东西！","javascript:;");
            exit();
        }
        $oo = 0;
        while($row = $dsql->GetArray())
        {
            $kid = $row[$keyfield];
            $rpf = preg_replace("#".$rpstring."#i", $tostring, $row[$rpfield]);
            $rs = $dsql->ExecuteNoneQuery("UPDATE $exptable SET $rpfield='$rpf' WHERE $keyfield='$kid' ");
            if($rs)
            {
                $oo++;
            }
        }
        $dsql->ExecuteNoneQuery("OPTIMIZE TABLE `$exptable`");
        ShowMsg("共找到 $tt 条记录，成功替换了 $oo 条！", "javascript:;");
        exit();
    }
}