View Full Version : select_db ?
ranger2kxlt
07-02-2004, 03:49 PM
<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
07-02-2004, 03:58 PM
Find
$query = "SELECT id,cat,title,bigimage,medsize FROM {$pp_prefix}photos WHERE userid = {$user} ORDER BY date DESC LIMIT $page,16";
BEFORE that ADD
$DB_site->select_db('photopost_db');
Find
if (!empty($photorow)) {
BFORE that ADD
$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
07-02-2004, 06:15 PM
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
07-02-2004, 06:37 PM
Then you must use a separate database connection.
Try this (remove the oder mods before doing so):
In pppanel.php FIND
$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
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
07-02-2004, 06:54 PM
Kirby Your The Man!!!!! Works Like A Charm! Thanks A Mil Buddy!!
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.