sys_data_replace.php
3.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<?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();
}
}