<?php
require_once './include/common.inc.php';
$limit = 500;
$sql = "select pid,message from {$tablepre}posts where message like '%[flash=%]%' order by pid limit $limit ";
$sql = $db->query($sql);
while($row = $db->fetch_array($sql)){
$pid = $row['pid'];
$msg = $row['message'];
//echo $msg."<br />\n";
$msg2 = preg_replace('/\[flash=[0-9,]+?\]/i', '[flash]', $msg);
$sql2 = "update {$tablepre}posts set message='$msg2' where pid=$pid limit 1 ";
//echo $sql2."<hr />\n";
$db->query($sql2);
}
if($db->querynum>$limit){
echo '<script>reload()</script>';
}else{
echo '完毕';
}
如果是[wmv=314,256,1]的的要这么转换呢 |
