vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   select_db ? (https://vborg.vbsupport.ru/showthread.php?t=66787)

ranger2kxlt 07-02-2004 03:49 PM
select_db ?
 
<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
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 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

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 07-02-2004 06:54 PM
Kirby Your The Man!!!!! Works Like A Charm! Thanks A Mil Buddy!!


All times are GMT. The time now is 10:58 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02091 seconds
  • Memory Usage 1,743KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete