select_db ?

[ranger2kxlt]

<a href="https://vborg.vbsupport.ru/showthread.php?t=60917" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=60917</a>

Can someone look at this hack, and near the bottom of the first post it says...if you use a different database then use select_mysql_db(), or something like that...

Can someone explain and tell me HOW to insert this into the script?

Thanks!

[Andreas]

Find

PHP Code:

$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$user} ORDER BY date DESC LIMIT $page,16"; 


BEFORE that ADD

PHP Code:

$DB_site->select_db('photopost_db'); 


Find

PHP Code:

if (!empty($photorow)) { 


BFORE that ADD

PHP Code:

$DB_site->select_db('vbulletin_db'); 


Of course you must replace photopost_db and vbulletin_db with the real names of your dabases

I don't know if this does work as I do not have Photopost, but in theory it should.

[ranger2kxlt]

thanks kirby you got me ALOT closer then i got myself!!

Next...i get an error, BUT its only because its trying to use my sql username from the forums database, to login to the photopost database....can you rewrite it to fix that for me?

Thanks A BUNCH!

[Andreas]

Then you must use a separate database connection.

Try this (remove the oder mods before doing so):

In pppanel.php FIND

PHP Code:

$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$user} ORDER BY date DESC LIMIT $page,16";
$myphotos = $DB_site->query($query);
$numrows = $DB_site->num_rows($myphotos);

if ( $numrows < 16 ) $nextpage = 0;

$i=0;
$photorow="";
$photopanel="";

while ( $thisphoto = $DB_site->fetch_array($myphotos) ) { 


REPLACE that with

PHP Code:

require_once('./includes/db_mysql.php');

$DB_site_pp = new DB_Sql_vb;

$DB_site_pp->appname = 'foobar';
$DB_site_pp->appshortname = 'foobar (barfoo)';
$DB_site_pp->database = 'photopost_db';

$DB_site_pp->connect('photopost_dvbserver', 'photopost_dbuser', 'photopost_dbpass', false);

$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$user} ORDER BY date DESC LIMIT $page,16";
$myphotos = $DB_site_pp->query($query);
$numrows = $DB_site_pp->num_rows($myphotos);

if ( $numrows < 16 ) $nextpage = 0;

$i=0;
$photorow="";
$photopanel="";

while ( $thisphoto = $DB_site_pp->fetch_array($myphotos) ) { 


Instead of foobar you could/should place something meaningful there

Also note that you must replace photopost_db, photopost_dbserver, photopost_user and pohotopost_pass with the actual values.

Don't know if this does work, but in theory it should.

[ranger2kxlt]

Kirby Your The Man!!!!! Works Like A Charm! Thanks A Mil Buddy!!