Code: Select all
array('physical_filename', 'files.file_id', 'import_attachment'),
array('real_filename', 'files.filename', ''),
Code: Select all
<?php
require_once 'MDB2.php'; //PEAR MDB2 used here
$dsn = 'mysqli://user:password@host/dbName';
$options = array(
'debug' => 2,
'result_buffering' => false,
);
$mdb2 =& MDB2::factory($dsn, $options);
if (PEAR::isError($mdb2)) {
die($mdb2->getMessage());
}
$sql="SELECT post_id,post_text from phpbb_posts";
$res =& $mdb2->query($sql);
if (PEAR::isError($res)) {
die($res->getMessage());
}
$done=0;
while (($row = $res->fetchRow())) {
$count=0;
$updated_text=preg_replace('/\[attachment \d+ (\S+\.\S+)\]/i', '[attachment=0]$1\[/attachment]', $row[1],-1,$count);
if($count>0){
$update="UPDATE phpbb_posts set post_text='$updated_text',post_attachment=1 where post_id=$row[0]";
$affected =& $mdb2->exec($update);
$done++;
}
echo $done.'\n';
}
$mdb2->disconnect();
?>
Hi! It was few years ago when I've converted my phorum to phpbb. I realy can't remember exactly what i did, but I'll try to help. First, tell me can you see your users in Database table phpbb_users.hhouwaard wrote: Can someone assist me in this? I very much want to be able to convert away from phorum.
Hans
