Well, I'm having no luck but this is what I attempted: (Keep in mind that reviewpost resides in a different database that vbulletin)
Quote:
$domain="mysite.com/forums/reviewpost";
$dbuser="reviewpostdbuser";
$dbpass="reviewpostdbpass";
$dbname="reviewpostdb"; //the name of the database
$chandle = mysql_connect("my.host.com", $dbuser, $dbpass)
or die("Connection Failure to Database");
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found." . $dbuser);
// replace the URL below with your ReviewPost links main folder URL
$vba_links_url = 'http://www.mysite.com/forums/reviewpost/';
$lnkg = $db->query_read("SELECT id,cat,date FROM rp_products");
while ($lnk = $db->fetch_array($lnkg))
{
$url = 'showproduct.php/product/?product='.$lnk['id'];
if(VBSEO_ON)
$url = vbseo_any_url($url);
$url = $vba_links_url . $url;
vbseo_add_url($url, 1.0, $lnk['lastpost'], 'weekly');
}
mysql_close($chandle);
?>
|
Any advice would be appreciated.
Buster