PHP Calls

[Mike_XBLW]

I'm trying to figure out how to make a php call to a database outside of the forum database. Any ideas?

Thanks,

Mike

[merk]

In what way?


You want to make a query to a different database inside the forum?

[Mike_XBLW]

Basically, I want this for a sidebar. I run a gaming site that does game reviews and previews

 /*-- Reviews -- */$maxRows_Reviews = 5;
$pageNum_Reviews = 0;
if (isset($HTTP_GET_VARS['pageNum_Reviews']))
{  $pageNum_Reviews = $HTTP_GET_VARS['pageNum_Reviews'];
}
$startRow_Reviews = $pageNum_Reviews * $maxRows_Reviews;
mysql_select_db($database_xblwConn, $xblwConn);
$query_Reviews = "SELECT reviews.id as reviewId, reviews.GameId, reviews.CreatedDate, reviews.FinalScore, games.id as gameId, games.Name as gamename FROM reviews, games WHERE games.id = reviews.GameId ORDER BY reviews.CreatedDate DESC";
$query_limit_Reviews = sprintf("%s LIMIT %d, %d", $query_Reviews, $startRow_Reviews, $maxRows_Reviews);
$Reviews = mysql_query($query_limit_Reviews, $xblwConn) or die(mysql_error());
$row_Reviews = mysql_fetch_assoc($Reviews); if (isset($HTTP_GET_VARS['totalRows_Reviews']))
{  $totalRows_Reviews = $HTTP_GET_VARS['totalRows_Reviews'];
} else {  $all_Reviews = mysql_query($query_Reviews);
$totalRows_Reviews = mysql_num_rows($all_Reviews);
}
$totalPages_Reviews = ceil($totalRows_Reviews/$maxRows_Reviews)-1;
/*-- Reviews -- */ 

And the HTML calling this:

 <?php do
{ ?>
<tr>
<td Class="Medium">&nbsp; <a href="review.php?ReviewId=<?php echo $row_Reviews['reviewId'];  ?>" class="MediumLink"><?php echo $row_Reviews['gamename']; ?></a></td>
<td Class="Medium" align="Right"><b><?php echo $row_Reviews['FinalScore'];  ?></b></td> </tr>
<?php
} while ($row_Reviews = mysql_fetch_assoc($Reviews));
 ?>

[merk]

The method you are trying to use wont always work properly with vBulletin and its php including methods.

First off, there are 2 ways of doing what you want to do.

You can either have a file (normally i would place it in includes/name.php) with all the code needed to generate the "output" i needed, and call it with one line from the phpinclude_start template. Or, you could just put the code you need to use in the phpinclude_start template, a much easier to modify way

If you open up phpinclude_start, and put the following in there,

/*-- Reviews -- */
$maxRows_Reviews = 5;
$pageNum_Reviews = 0;
if (isset($HTTP_GET_VARS['pageNum_Reviews']))
{
 $pageNum_Reviews = $HTTP_GET_VARS['pageNum_Reviews'];
}
$startRow_Reviews = $pageNum_Reviews * $maxRows_Reviews;
mysql_select_db($database_xblwConn, $xblwConn);
$query_Reviews = "SELECT reviews.id as reviewId, reviews.GameId, reviews.CreatedDate, reviews.FinalScore, games.id as gameId, games.Name as gamename FROM reviews, games WHERE games.id = reviews.GameId ORDER BY reviews.CreatedDate DESC";
$query_limit_Reviews = sprintf("%s LIMIT %d, %d", $query_Reviews, $startRow_Reviews, $maxRows_Reviews);
$Reviews = mysql_query($query_limit_Reviews, $xblwConn) or die(mysql_error());
$row_Reviews = mysql_fetch_assoc($Reviews);
if (isset($HTTP_GET_VARS['totalRows_Reviews']))
{
 $totalRows_Reviews = $HTTP_GET_VARS['totalRows_Reviews'];
}
else
{
 $all_Reviews = mysql_query($query_Reviews);
 $totalRows_Reviews = mysql_num_rows($all_Reviews);
}
$totalPages_Reviews = ceil($totalRows_Reviews/$maxRows_Reviews)-1;
/*-- Reviews -- */ 
do
{
$reviews = "<tr>
 <td Class=\"Medium\">&nbsp; <a href=\"review.php?ReviewId=$row_Reviews[reviewId]\" class=\"MediumLink\">$row_Reviews[gamename]</a></td>
 <td Class=\"Medium\" align=\"Right\"><b>$row_Reviews[FinalScore]</b></td>
</tr>";
} while ($row_Reviews = mysql_fetch_assoc($Reviews)); 

The first problem i see being a problem is that your mysql connection line uses variables that were not set in the stuff you pasted above. You will most probably have to either hard code them in, or set the variables (above the connect line).

Once that is done, you will be able to use $reviews in any vbulletin template to put your reviews output in. (header is normally the best place)

I can also see the external query being a problem for speed, but then again, it shouldnt be more than a few microseconds