The Arcive of Official vBulletin Modifications Site.

Marco van Herwaarden · #11 08-04-2005, 03:34 PM

Jelsoft will never make it i think, because there are too many (not only phpBB) variations.

PS You should remove connecting to the database, and start with a require_once of global.php. That will setup your connection in a secure way. Also change the database functions to vB onces.

Marris · #12 08-05-2005, 10:06 PM

Well, I've got a rough, ROUGH version of a script to rewrite topic links in the database (no post links yet). This is cobbled together from my image link re-writing script which was equally shabby. Obviously, I don't really know what I am doing, but I pick up what I can from Google and work things out with lots of trial and error.

Anyway, this is basically working on my test server database.

It searches for any post with a link pointing to an old forum topic, then counts the number of links within a post. Then it splits the post into segments for each link and fills an array with replacement links, then puts in a placeholder for already replaced links. After processing all the segments, it fills in all the placeholders with replacements and writes the updated post to the database.

Code:

<?php
$username="";
$password="";
$database="";
 

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$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);

$searchstring = "www.domain.com/forum/viewtopic.php?t=";

// echo "<b><center>Database Output</center></b><br><br>";
$nonexistcount=0;
$changedcount=0;
$i=0; // 100 should be $num below
while ($i < $num) {
$postid=mysql_result($result,$i,"postid");
$pagetext=mysql_result($result,$i,"pagetext");

   $count=substr_count($pagetext,$searchstring);
   $replacecount=0;
 echo "<b>ROW:$i, POSTID:$postid, NUMBER OF LINKS:$count<br>ORIGINAL POST:<BR>$pagetext<br>";
$pagetext = addslashes($pagetext);
echo "<br>SLASHIFIED POST:<br>$pagetext<br>";


while ($count > 0) {
   
   $begPos = strpos($pagetext,$searchstring);
   echo "<br>beginning position: $begPos</br>";
   $step = 0;
	$checknum = 0;
	$dbsize = 10; // number of digits in total number of posts in database + 1

	while (($step < $dbsize) && ($checknum !== 1))
	{
		$step=$step+1;
		$checkstring = substr($pagetext,$begPos+strlen($searchstring),$step);
		$checknum = preg_match ('/[^0-9]/', $checkstring);
	}
	$endPos = ($begPos+strlen($searchstring)+$step-1);
	echo "<br>ending position: $endPos</br>";
//	$topicid = substr($pagetext,$begPos+strlen($searchstring),$endPos-$begPos-1);  
// old below
  
  $psum =($endPos-$begPos);
   $psumneg=$psum;
   if ($psum < 0){
   	
   	$ic=0;
$psegs=explode("http:\/\/",$pagetext);
echo "<br>number of segments:$psegs[$ic]<br>";
$begPos = strpos($psegs[$ic],$searchstring);

echo "<br>beginning position segment $ic: $begPos</br>";

while (( $begPos < 1 ) and ($ic < 100))

{$ic++;
$begPos = strpos($psegs[$ic],$searchstring); 

}
   echo "<br>segment $ic : $psegs[$ic]<br>$endPos : before<br>";
   
   $step = 0;
	$checknum = 0;
	$dbsize = 10; // number of digits in total number of posts in database + 1

	while (($step < $dbsize) && ($checknum !== 1))
	{
		$step=$step+1;
		$checkstring = substr($psegs[$ic],$begPos+strlen($searchstring),$step);
		$checknum = preg_match ('/[^0-9]/', $checkstring);
	}
	$endPos = ($begPos+strlen($searchstring)+$step-1);  
   
    
	 
	 echo "$endPos : after<br>";
   $psumneg=($endPos-$begPos); 
   $tmp = substr($psegs[$ic],$begPos+strlen($searchstring),$endPos-$begPos-strlen($searchstring));
   
echo "<br>COUNT:$ic<br>POST ID:$postid<br><br>NEGSUM:$psumneg<br>";
      echo "<Br>START:$begPos<br>END:$endPos<br>thread ID:$tmp<br>";
  } else {
   $tmp = substr($pagetext,$begPos+strlen($searchstring),$endPos-$begPos-strlen($searchstring));
  }
   if (ereg("&", $tmp)) { 
   	 $tmpsplit=explode("&",$tmp);
   	 $tmp=$tmpsplit[0];
   	 $tmpsid=$tmpsplit[1];
   	 } else {
   	 $tmpsid='';
   	}
   $oldthreadid = $tmp;
   
 $sql = "SELECT * FROM vb3_post WHERE importthreadid = '$oldthreadid'";
if( !($result2 = mysql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not query thread information', '', __LINE__, __FILE__, $sql);
}
$result2=mysql_query($sql);
@$newthread=mysql_result($result2,0,"threadid");


if (empty($newthread))
{
$filename[$replacecount]="thread_deleted";
	$nonexistcount=$nonexistcount+1;
}  else {
	$filename[$replacecount] = $newthread;
}
   

$filename[$replacecount]=("testvb/showthread.php?t=" . $filename[$replacecount]);

if (!empty($tmpsid)) {
$oldthreadid=( "$oldthreadid" . "&" . "$tmpsid" );
//echo "$oldthreadid<br>";
}

$replace[$replacecount]=("forum/viewtopic.php?t=" . $oldthreadid); 


$placeholder[$replacecount]=("place" . $replacecount);

$pagetext = str_replace($replace[$replacecount],$placeholder[$replacecount],$pagetext);
   
echo "PASS:$replacecount<BR>Old thread ID:$oldthreadid<br>TEXT TO BE REPLACED: $replace[$replacecount]<br>";
echo "REPLACEMENT TEXT: $filename[$replacecount]<br>";
        
   $count=$count-1;
$replacecount=$replacecount+1;
$changedcount=$changedcount+1;
}   

$pagetext = str_replace($placeholder,$filename,$pagetext);  


mysql_query("UPDATE vb3_post SET pagetext='$pagetext' WHERE postid=$postid") or die (mysql_error ());

echo "<b>EDITED POST:<br>$pagetext<hr><br>";


$i++;
}
mysql_close();
echo "...DONE<br>";
echo "$nonexistcount missing threads replaced with placeholder link<br>";
echo "$changedcount links updated<br>";
echo "$i rows modified";
?>

Here's some sample output:

Code:

POSTID:8761, NUMBER OF LINKS:3
ORIGINAL POST:
related threads: story title 1 another interesting link My last link for today

TEXT TO BE REPLACED: forum/viewtopic.php?t=1954
REPLACEMENT TEXT: testvb/showthread.php?t=1911

TEXT TO BE REPLACED: forum/viewtopic.php?t=1930
REPLACEMENT TEXT: testvb/showthread.php?t=1888

TEXT TO BE REPLACED: forum/viewtopic.php?t=1834
REPLACEMENT TEXT: testvb/showthread.php?t=1797

EDITED POST:
related threads: story title 1 another interesting link My last link for today

If you can make any sense of this mess and have any constructive tips, please let me know.

I apologize for the state of the code.

Marco van Herwaarden · #13 08-06-2005, 05:49 AM

Tips in my previous post are still valid.

Marris · #14 08-06-2005, 06:54 AM

I don't know how much further I'll go with these. They're still very sloppy, but the output is "good enough" for my needs (and considering my lack of skills). Anyway, I'm posting these in the hope that maybe this will inspire someone to write a proper conversion script someday.

I have made a second script copied from the first that fixes the the "p=" post links. The main difference is an additional check for '#' in the link.

Running on a local test server, I have used these to update my full database (several thousand links updated within a few hundred thousand posts).

imported post link converter (viewtopic.php?=p):

PHP Code:


			
<?php

$username="";

$password="";

$database="";



// post link convertor for imported phpBB posts in vBulletin

// use at your own risk 



// post replace script converted from topic replace



mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

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

$result=mysql_query($query) or die (mysql_error ());



$num=mysql_numrows($result);



$searchstring = "www.domain.com/forum/viewtopic.php?p=";



// echo "<b><center>Database Output</center></b><br><br>";

$nonexistcount=0;

$changedcount=0;

$i=0; // 10 should be $num below

while ($i < $num) {

$postid=mysql_result($result,$i,"postid");

$pagetext=mysql_result($result,$i,"pagetext");



   $count=substr_count($pagetext,$searchstring);

   $replacecount=0;

 //echo "<b>ROW:$i, POSTID:$postid, NUMBER OF LINKS:$count<br>ORIGINAL POST:<BR>$pagetext<br>";

$pagetext = addslashes($pagetext);

//echo "<br>SLASHIFIED POST:<br>$pagetext<br>";





while ($count > 0) {

   

   $begPos = strpos($pagetext,$searchstring);

   // echo "<br>beginning position: $begPos</br>";

   $step = 0;

    $checknum = 0;

    $dbsize = 10; // number of digits in total number of posts in database + 1



    while (($step < $dbsize) && ($checknum !== 1))

    {

        $step=$step+1;

        $checkstring = substr($pagetext,$begPos+strlen($searchstring),$step);

        $checknum = preg_match ('/[^0-9]/', $checkstring);

    }

    $endPos = ($begPos+strlen($searchstring)+$step-1);

    //echo "<br>ending position: $endPos</br>";

//    $topicid = substr($pagetext,$begPos+strlen($searchstring),$endPos-$begPos-1);  

// old below

  

  $psum =($endPos-$begPos);

   $psumneg=$psum;

   if ($psum < 0){

       

       $ic=0;

$psegs=explode("http:\/\/",$pagetext);

//echo "<br>number of segments:$psegs[$ic]<br>";

$begPos = strpos($psegs[$ic],$searchstring);



//echo "<br>beginning position segment $ic: $begPos</br>";



while (( $begPos < 1 ) and ($ic < 100))



{$ic++;

$begPos = strpos($psegs[$ic],$searchstring); 



}

   //echo "<br>segment $ic : $psegs[$ic]<br>$endPos : before<br>";

   

   $step = 0;

    $checknum = 0;

    $dbsize = 10; // number of digits in total number of posts in database + 1



    while (($step < $dbsize) && ($checknum !== 1))

    {

        $step=$step+1;

        $checkstring = substr($psegs[$ic],$begPos+strlen($searchstring),$step);

        $checknum = preg_match ('/[^0-9]/', $checkstring);

    }

    $endPos = ($begPos+strlen($searchstring)+$step-1);  

   

    

     

     //echo "$endPos : after<br>";

   $psumneg=($endPos-$begPos); 

   $tmp = substr($psegs[$ic],$begPos+strlen($searchstring),$endPos-$begPos-strlen($searchstring));

   

//echo "<br>COUNT:$ic<br>POST ID:$postid<br><br>NEGSUM:$psumneg<br>";

      //echo "<Br>START:$begPos<br>END:$endPos<br>new post ID:$tmp<br>";

  } else {

   $tmp = substr($pagetext,$begPos+strlen($searchstring),$endPos-$begPos-strlen($searchstring));

  }

   if (ereg("&", $tmp)) { 

        $tmpsplit=explode("&",$tmp);

        $tmp=$tmpsplit[0];

        $tmpsid=$tmpsplit[1];

        } else {

        $tmpsid='';

       }

   $oldpostid = $tmp;

   

 $sql = "SELECT * FROM vb3_post WHERE importpostid = '$oldpostid'";

if( !($result2 = mysql_query($sql)) )

{

    message_die(GENERAL_ERROR, 'Could not query post information', '', __LINE__, __FILE__, $sql);

}

$result2=mysql_query($sql);

@$newpost=mysql_result($result2,0,"postid");





if (empty($newpost))

{

$filename[$replacecount]="post_deleted";

    $nonexistcount=$nonexistcount+1;

}  else {

    $filename[$replacecount] = $newpost;

}

   



$filename[$replacecount]=("testvb/showthread.php?p=" . $filename[$replacecount] . "#post" . $filename[$replacecount]);



if (!empty($tmpsid)) {

$oldpostid=( "$oldpostid" . "&" . "$tmpsid" );

//echo "$oldpostid<br>";

}



$replace[$replacecount]=("forum/viewtopic.php?p=" . $oldpostid . "#" . $oldpostid); 



if (substr_count($pagetext,$replace[$replacecount]) == 0){

    $replace[$replacecount]=("forum/viewtopic.php?p=" . $oldpostid);    

}    



$placeholder[$replacecount]=("place" . $replacecount);



$pagetext = str_replace($replace[$replacecount],$placeholder[$replacecount],$pagetext);

   

//echo "PASS:$replacecount<BR>Old post ID:$oldpostid<br>TEXT TO BE REPLACED: $replace[$replacecount]<br>";

//echo "REPLACEMENT TEXT: $filename[$replacecount]<br>";

        

   $count=$count-1;

$replacecount=$replacecount+1;

$changedcount=$changedcount+1;

}   



$pagetext = str_replace($placeholder,$filename,$pagetext);  





mysql_query("UPDATE vb3_post SET pagetext='$pagetext' WHERE postid=$postid") or die (mysql_error ());



//echo "<b>EDITED POST:<br>$pagetext<hr><br>";





$i++;

}

mysql_close();

echo "...DONE<br>";

echo "$nonexistcount missing posts replaced with placeholder link<br>";

echo "$changedcount links updated<br>";

echo "$i rows modified";

?>

imported thread link converter (viewtopic.php?=t):

PHP Code:


			
<?php

$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");

$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);



$searchstring = "www.domain.com/forum/viewtopic.php?t=";



// echo "<b><center>Database Output</center></b><br><br>";

$nonexistcount=0;

$changedcount=0;

$i=0; // 10 should be $num below

while ($i < $num) {

$postid=mysql_result($result,$i,"postid");

$pagetext=mysql_result($result,$i,"pagetext");



   $count=substr_count($pagetext,$searchstring);

   $replacecount=0;

 //echo "<b>ROW:$i, POSTID:$postid, NUMBER OF LINKS:$count<br>ORIGINAL POST:<BR>$pagetext<br>";

$pagetext = addslashes($pagetext);

//echo "<br>SLASHIFIED POST:<br>$pagetext<br>";





while ($count > 0) {

   

   $begPos = strpos($pagetext,$searchstring);

   //echo "<br>beginning position: $begPos</br>";

   $step = 0;

    $checknum = 0;

    $dbsize = 10; // number of digits in total number of posts in database + 1



    while (($step < $dbsize) && ($checknum !== 1))

    {

        $step=$step+1;

        $checkstring = substr($pagetext,$begPos+strlen($searchstring),$step);

        $checknum = preg_match ('/[^0-9]/', $checkstring);

    }

    $endPos = ($begPos+strlen($searchstring)+$step-1);

    //echo "<br>ending position: $endPos</br>";

//    $topicid = substr($pagetext,$begPos+strlen($searchstring),$endPos-$begPos-1);  

// old below

  

  $psum =($endPos-$begPos);

   $psumneg=$psum;

   if ($psum < 0){

       

       $ic=0;

$psegs=explode("http:\/\/",$pagetext);

//echo "<br>number of segments:$psegs[$ic]<br>";

$begPos = strpos($psegs[$ic],$searchstring);



//echo "<br>beginning position segment $ic: $begPos</br>";



while (( $begPos < 1 ) and ($ic < 100))



{$ic++;

$begPos = strpos($psegs[$ic],$searchstring); 



}

   //echo "<br>segment $ic : $psegs[$ic]<br>$endPos : before<br>";

   

   $step = 0;

    $checknum = 0;

    $dbsize = 10; // number of digits in total number of posts in database + 1



    while (($step < $dbsize) && ($checknum !== 1))

    {

        $step=$step+1;

        $checkstring = substr($psegs[$ic],$begPos+strlen($searchstring),$step);

        $checknum = preg_match ('/[^0-9]/', $checkstring);

    }

    $endPos = ($begPos+strlen($searchstring)+$step-1);  

   

    

     

     //echo "$endPos : after<br>";

   $psumneg=($endPos-$begPos); 

   $tmp = substr($psegs[$ic],$begPos+strlen($searchstring),$endPos-$begPos-strlen($searchstring));

   

//echo "<br>COUNT:$ic<br>POST ID:$postid<br><br>NEGSUM:$psumneg<br>";

      //echo "<Br>START:$begPos<br>END:$endPos<br>thread ID:$tmp<br>";

  } else {

   $tmp = substr($pagetext,$begPos+strlen($searchstring),$endPos-$begPos-strlen($searchstring));

  }

   if (ereg("&", $tmp)) { 

        $tmpsplit=explode("&",$tmp);

        $tmp=$tmpsplit[0];

        $tmpsid=$tmpsplit[1];

        } else {

        $tmpsid='';

       }

   $oldthreadid = $tmp;

   

 $sql = "SELECT * FROM vb3_post WHERE importthreadid = '$oldthreadid'";

if( !($result2 = mysql_query($sql)) )

{

    message_die(GENERAL_ERROR, 'Could not query thread information', '', __LINE__, __FILE__, $sql);

}

$result2=mysql_query($sql);

@$newthread=mysql_result($result2,0,"threadid");





if (empty($newthread))

{

$filename[$replacecount]="thread_deleted";

    $nonexistcount=$nonexistcount+1;

}  else {

    $filename[$replacecount] = $newthread;

}

   



$filename[$replacecount]=("testvb/showthread.php?t=" . $filename[$replacecount]);



if (!empty($tmpsid)) {

$oldthreadid=( "$oldthreadid" . "&" . "$tmpsid" );

//echo "$oldthreadid<br>";

}



$replace[$replacecount]=("forum/viewtopic.php?t=" . $oldthreadid); 





$placeholder[$replacecount]=("place" . $replacecount);



$pagetext = str_replace($replace[$replacecount],$placeholder[$replacecount],$pagetext);

   

//echo "PASS:$replacecount<BR>Old thread ID:$oldthreadid<br>TEXT TO BE REPLACED: $replace[$replacecount]<br>";

//echo "REPLACEMENT TEXT: $filename[$replacecount]<br>";

        

   $count=$count-1;

$replacecount=$replacecount+1;

$changedcount=$changedcount+1;

}   



$pagetext = str_replace($placeholder,$filename,$pagetext);  





mysql_query("UPDATE vb3_post SET pagetext='$pagetext' WHERE postid=$postid") or die (mysql_error ());



//echo "<b>EDITED POST:<br>$pagetext<hr><br>";





$i++;

}

mysql_close();

echo "...DONE<br>";

echo "$nonexistcount missing threads replaced with placeholder link<br>";

echo "$changedcount links updated<br>";

echo "$i rows modified";

?>

Marco van Herwaarden · #15 08-06-2005, 07:00 AM

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...

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08471 seconds Memory Usage 2,345KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (2)bbcode_code (6)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (5)post_thanks_box (5)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (5)post_thanks_postbit_info (5)postbit (5)postbit_onlinestatus (5)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!