Hello ...
I tried posting this in the PostNuke forums, but nobody seems to know how to get this working.
I added a mod to my forums, that added 3 fields to the nuke_phpbb_users table (user_totalpts,
user_pendpts, & user_rwrpnd). Image link below:
I am using PNphpBB2 1.2a for the forums, the mod works fine. What I am trying to do, is create
a PHP Block, to pull the info from those fields and put them in the Block, and display like this (so each user can see their points in the block once they log in):
Total Points: 12
Pending Points: 10
Reward Points Pending: 25
Here is how the code we came up with, which does not work. Please note, I don't really have
any coding experience. This is just what was suggested from the PostNuke forums.
list($dbconn) = pnDBGetConn();
$pntable = pnDBGetTables();
$column = &$pntable['phpbb_users_column'];
$result = $dbconn->Execute("SELECT $column[totalpts], $column[pendpts], $column[rwrpnd], FROM $pntable[phpbb_users]);
while (list($totalpts, $pendpts, $rwrpnd) = $result->fields) {
$result->MoveNext();
echo '<br>·Total Points: '.$totalpts.' ';
echo '<br>·Pending Points: '.$pendpts.' ';
echo '<br>·Reward Points Pending: '.$rwrpnd.' ';
}
echo '</div>';
Can someone help me out?
Thanks ...
Ron Herr, rherrfamily@yahoo.com
