Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_host = 'localhost';
- $db_user = 'root'; // имя пользователя БД
- $db_pass = ''; // пароль пользователя к БД
- $db_name = ''; // имя БД
- $res = 'full_story';
- $idres = 'id';
- $repl_db_reg = '/(\[attachment=)(\d+)(\])/i';
- $repl_db_repl = '[hide]$0[/hide]';
- $sqlid = @mysql_connect($db_host, $db_user, $db_pass) or die (mysql_error());
- $sqldb = mysql_select_db($db_name);
- // Кодировка БД, в данном случае - cp1251. Возможно, у Вас - utf8
- mysql_query("SET NAMES 'cp1251'");
- $field = mysql_query('SELECT '.$res.' FROM dle_post ORDER BY id ASC') or die (mysql_error());
- for ($data=array(); $row=mysql_fetch_assoc($field); $data[]=$row);
- $id = mysql_query('SELECT '.$idres.' FROM dle_post ORDER BY id ASC') or die (mysql_error());
- for ($iddata=array(); $idrow=mysql_fetch_assoc($id); $iddata[]=$idrow);
- for ($i=0; $i<sizeof($data); $i++) {
- $tmp = $data[$i][$res];
- $repl = preg_replace($repl_db_reg, $repl_db_repl, $tmp);
- if ($repl !== $tmp) {$tmp = $repl;}
- if ($tmp !== $data[$i][$res]) {
- mysql_query('UPDATE dle_post SET full_story="'.mysql_escape_string($tmp).'" WHERE id='.$iddata[$i][$idres]) or die (mysql_error());
- }
- }
- echo "DONE";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement