Board3

Code: Select all

{$C_BLOCK_H_L}Handicaps{$C_BLOCK_H_R}
<table class="tablebg" cellspacing="1" width="100%">
	<tr class="row1">
		<td>Player</td>
		<td>HDCP</td>		
<!-- BEGIN handicaplist -->
   <tr class="row1">
      <td><strong>{handicaplist.USER_NAME} : {handicaplist.HANDICAP}</strong></td>
   </tr>
<!-- END handicaplist -->
	</tr>	
</table>
{$C_BLOCK_F_L}{$C_BLOCK_F_R}

Code: Select all

<?php

//Portal Block to return username and handicap

//make sure the code is being called inside of the application itself and is not a hack attempt
        if (!defined('IN_PHPBB'))
        {
           exit;
        }

//make sure it is being run from the portal mod
        if (!defined('IN_PORTAL'))
        {
           exit;
        }
        
//select the username from the users table paired with the handicap from the profile fields table by user_id        
 $sql = 'SELECT u.username, p.handicap
		FROM ' . USERS_TABLE . ' u
		LEFT JOIN  . PROFILE_FIELD_DATA_TABLE . p
			ON u.user_id = p.user_id	
		ORDER BY u.username ASC';
//execute the query and assign the results to the $result array
$result = $db->sql_query($sql);

//loop through each item in the result set assigning each row to the row array and then read the row array and set the values in the handicaplist array for the block display from the contents of the row
foreach($result as $row)
        {
            $template->assign_block_vars('handicaplist', array(
                'USER_NAME'    => $row['username'],
                'HANDICAP'        => $row['handicap'],
            ));
        }
?>