memberinfo template - what variable do I 'pass' to a PHP script for a member's userID

[criscokid]

I've creating small PHP script that I'll be using to output info on the Memberinfo template by way of a pluugin.

What variable do I use in the PHP script for the userID of the profile I'm looking at at the time?

Assuming my userID is 1 and I'm looking at the profile of the person whose userID is 5 - I want userID=5 to be passed through to the PHPscript or 10 if their userID happens to be 10.

[EnIgMa1234]

try $vbulletin->GPC['userid']

not tested ^^

[criscokid]

Thanks for the speedy reply (it's REALLY appreciated!) and your suggestion works. :) :)

[EnIgMa1234]

Great to hear :)

[criscokid]

I created a PHP script yesterday that displays fine in a vB template via a plugin. I've created another PHP script today but when I view it in a vB template it just outputs the content of the PHP script (the actual PHP script is what you see), it doesn't actually execute the PHP script and output the result of that.

I've double checked the script and it appears fine... something, I can't figure out what, is stopping vB from 'executing' the PHP script.

[EnIgMa1234]

Come again?

Whats he code of the script and the template?

[criscokid]

Typical... I make a forum posting and then figure out what's wrong... vB wasn't happy because there wasn't a space between the = and the 'searchvalue'.

I've made some progress but I've still having a problem...

Here's my PHP code:

<?php
$selected = $_POST['selected'];
require_once('global.php');
$dbuser="username";
$dbpass="password";
$dbname="database"; //the name of the database
$chandle = mysql_connect("localhost", $dbuser, $dbpass)
or die("Connection Failure to Database");
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found." . $dbuser);

$counter = 0;

// Lets get the Recent Reviews
$queryz = ("SELECT
rp_products.title,
rp_reviews.username,
rp_reviews.userid,
rp_reviews.review,
rp_reviews.cat,
rp_reviews.product,
rp_products.bigimage,
rp_products.cat,
rp_products.userid
FROM
rp_reviews
INNER JOIN rp_products ON (rp_reviews.product=rp_products.id)
WHERE
(rp_reviews.review IS NOT NULL) AND
(rp_products.approved = 1) AND
(rp_reviews.userid = {$vbulletin->GPC['userid']})
ORDER BY
rp_reviews.`date` DESC LIMIT 5");

$result = mysql_query($queryz) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<div align=\"center\">\n";
echo "<table width=\"100%\">\n";

while ($row = mysql_fetch_array($result)) {

$title = $row['title'];
$review = $row['review'];
$username = $row['username'];
$product = $row['product'];
$bigimage = $row['bigimage'];
$cat = $row['cat'];

$review = strip_bbcode($review, $stripquotes = false, $fast_and_dirty = false, $showlinks = false);

// split the message at the first paragraph
$preview = preg_split('#(\r\n|\n|\r)#', $review, -1, PREG_SPLIT_NO_EMPTY);
$displaypreview = $preview[0];

echo "\t<tr align=\"center\" valign=\"top\">\n";
echo "\t\t<td width=\"20%\" valign=\"top\"><a href=\"http://domain.com/party/showproduct.php\?product={$product}\"><img src=\"http://domain.com/party/data/{$cat}/thumbs/{$bigimage}\" alt=\"{$title}\" height =\"66\"border=\"0\" ></a><br />
{$title}<br/><br/></td><td align=\"left\" valign=\"top\">{$displaypreview}<br/><br/><a href=\"http://domain.com/party/showproduct.php\?product={$product}\">Read the full review of {$title}.<br/><br/></td>\n";
echo "\t</tr>\n";

}

echo "</table>\n";
echo "</div>\n";

mysql_close($chandle);
?>


When I view the user profile of 'person with userID of 1959' the output is nothing. If I change
(rp_reviews.userid = {$vbulletin->GPC['userid']})
to
(rp_reviews.userid = '1959')
then the script works fine / as expected so I suspect I might be using the wrong variable in my query.

[EnIgMa1234]

Is this a vbulletin script?

[criscokid]

No it's something I've written myself to utilise data from a Reviewpost table and show it on a user's profile page. I'm new to mySQL, PHP and vB plugins so it's pretty much done by looking at other similar code and modifying / altering to suit what I want to do.

[EnIgMa1234]

k first of all if your using plugins hooks are used to display the code on pages e.g forumhome_compete will execute at the bottom of the index.php file.

If your adding code, you will be using member_***

Next, you dont need to connect to the database, it is done automatically. Also you dont need the opening php tag or the closing one.

Finally I taken a bit of your code and changed it around to be more vbulletin compatible

$counter = 0;

// Lets get the Recent Reviews
$queryz = $vbulletin->db->query_read("SELECT
rp_products.title,
rp_reviews.username,
rp_reviews.userid,
rp_reviews.review,
rp_reviews.cat,
rp_reviews.product,
rp_products.bigimage,
rp_products.cat,
rp_products.userid
FROM " . TABLE_PREFIX . "
rp_reviews
INNER JOIN rp_products ON (rp_reviews.product=rp_products.id)
WHERE
(rp_reviews.review IS NOT NULL) AND
(rp_products.approved = 1) AND
(rp_reviews.userid = {$vbulletin->GPC['userid']})
ORDER BY
rp_reviews.`date` DESC LIMIT 5");

// Printing results in HTML
echo "<div align=\"center\">\n";
echo "<table width=\"100%\">\n";

while ($row = $vbulletin->db->fetch_array($queryz)) {

$title = $row['title'];
$review = $row['review'];
$username = $row['username'];
$product = $row['product'];
$bigimage = $row['bigimage'];
$cat = $row['cat'];
}


Also it's better to use templates instead of echoing html. Chec the articles section for more help.

Hope that helps.

[criscokid]

Thanks for your help so far.

The database that I'm querying isn't the vB database which is why I used 'connect to database' - sorry I didn't make that clear.

I've just changed the hook location from member_start to member_complete and I'm happy to say it's working :)
I originally chose member_start because I thought that would get processed / executed before member_complete - thinking that member_complete might be used for 'end of page' things - may be a stupid assumption but I often do things through trial and error... often the best way to get your head around things when you don't really know what you're doing LOL. I tried doing some reading up yesterday on the different hook locations but the vB manual wasn't very informative.

[EnIgMa1234]

Good to hear :) Remember that the files only print out the template and dont echo html