PHP to convert phpBB links to vB links?

[Marco van Herwaarden]

Replace:

PHP Code:

$username=""; 
$password=""; 
$database=""; 

// thread link convertor for imported phpBB posts in vBulletin 
// use at your own risk  

mysql_connect(localhost,$username,$password); 
@mysql_select_db($database) or die( "Unable to select database"); 


by:

PHP Code:

require_once('./global.php'); 


replace:

PHP Code:

$query="SELECT * FROM vb3_post WHERE pagetext LIKE ('%www.domain.com/forum/viewtopic.php?t=%')"; 
$result=mysql_query($query) or die (mysql_error ()); 

$num=mysql_numrows($result); 


by

PHP Code:

$result = $DB_site->query("SELECT * FROM vb3_post WHERE pagetext LIKE ('%www.domain.com/forum/viewtopic.php?t=%')"); 

$num=$DB_site->num_rows($result); 


etc...