phpBB.nl

ik heb topposter en ik wil de nummer er voor hoe kan dit ik heb dit al

          <td class="row1" align="right" valign="middle" width="8%">{user_row.ROW_NUMBER}</td>

in de tpl

en in het php

Code: Selecteer alles

	'NUMBER' => ($start + $i + 1),

wat is er fout

Wat voor 'topposter'? En het werkt niet omdat $i niet verhoogd wordt.

wat moet ik er dan voor doen ?

Werl je met een for lus? Waar wordt $i aangemaakt? Ik heb meer code nodig.

tpl

Code: Selecteer alles

<HTML>

<table><tr>
<td align="left" valign="middle" class="nav" width="100%"><span	class="nav">&nbsp;&nbsp;&nbsp;<a href="{U_INDEX}" class="nav">{L_INDEX}</a></span></td>
</tr></table><hr>

<center>

		
		
		
		
		
		<table width="100%">
		<tr colspan="2">
		<td colspan="2">
		
		
		
		
		
		<table colspan="2" cellpadding="3" cellspacing="1" border="0" class="forumline">
        <tr>
          <td class="catHead" align ="left" colspan="2" nowrap="nowrap"><span class="genmed"><b><center>Uitleg</b></td>
        </tr>
        
        
        <tr>
          
          <td class="row1" align="right" valign="middle" colspan="2"><span class="gen"><center>De bedoeling van deze maand top 50 is om aan het eind van de maand zo hoog uit te komen en je daarvoor dus geld uitbetaald krijgt. Elke begin van de maand gaat deze maand top 50 weer op 0 en heeft iedereen weer evenveel kans om de top te bereiken en sukkeltjes/geld in de wacht te slepen.</span></td>
          
          
          </tr>

         
          </table>
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		</td>
		</tr>
		<TR>
		<td width="50%" valign="top">
		
		<!-- top posters -->



			<table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
        <tr>
          <td class="catHead" align ="left" colspan="4" nowrap="nowrap"><span class="genmed"><b><center>Maand top 50</b></td>
        </tr>
        
         <!-- BEGIN topposter -->
        <tr>
          <td class="row1" align="right" valign="middle" width="8%">{user_row.ROW_NUMBER}</td>
          
          <td class="row1" align="right" valign="middle" width="49%"><span class="gen"><a href="{topposter.U_VIEWPOSTER}" class="gen"><center>
            <p>{user_row.ROW_NUMBER}<br>
              {topposter.AVATAR_IMG}</p>            </td>
          <td class="row1" align="center" valign="middle"width="43%"><span class="genmed"><a href="{topposter.U_VIEWPOSTER}" class="gen">{topposter.USERNAME} ({topposter.POSTS})</a></span></td>
          
          </tr>

          <!-- END topposter -->
           </table>
		  
	

<!-- End top posters -->
</td><td width="50%" valign="top">
		
		<table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
        <tr>
          <td class="catHead" align ="left" colspan="3" nowrap="nowrap"><span class="genmed"><b><center>Uitbetalingen (per maand)</b></td>
        </tr>
        
         
        
        
        
        
        <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">nu.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">sukkeltjes/geld</span></td>
         </tr>
        
        
        
        
        
        
        
        
        <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">1.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">&euro; 5.00</span></td>
         </tr>
		<tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">2.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">&euro; 2.00</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">3.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">&euro; 1.00</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">4.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">&euro; 0.50</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">5.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">&euro; 0.25</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">6.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">45.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">7.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">44.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">8.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">43.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">9.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">42.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">10.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">41.000 sukkeltjes</span></td>
         </tr>
         
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">11.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">40.000 sukkeltjes</span></td>
         </tr>
          <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">12.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">39.000 sukkeltjes</span></td>
         </tr>
          <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">13.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">38.000 sukkeltjes</span></td>
         </tr>
          <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">14.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">37.000 sukkeltjes</span></td>
         </tr>
          <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">15.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">36.000 sukkeltjes</span></td>
         </tr>
          <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">16.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">35.000 sukkeltjes</span></td>
         </tr>
          <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">17.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">34.000 sukkeltjes</span></td>
         </tr>
          <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">18.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">33.000 sukkeltjes</span></td>
         </tr>
          <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">19.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">32.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">20.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">31.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">21.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">30.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">22.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">29.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">23.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">28.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">24.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">27.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">25.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">26.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">26.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">25.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">27.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">24.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">28.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">23.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">29.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">22.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">30.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">21.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">31.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">20.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">32.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">19.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">33.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">18.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">34.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">17.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">35.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">16.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">36.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">15.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">37.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">14.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">38.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">13.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">39.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">12.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">40.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">11.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">41.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">10.000 sukkeltjes</span></td>
         </tr>
         
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">42.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">9.000 sukkeltjes</span></td>
         </tr>
         
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">43.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">8.000 sukkeltjes</span></td>
         </tr>
         
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">44.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">7.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">45.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">6.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">46.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">5.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">47.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">4.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">48.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">3.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">49.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">2.000 sukkeltjes</span></td>
         </tr>
         <tr>
          <td class="row1" align="right" valign="middle" width="5%"><span class="gen">50.</span></td>
          <td class="row1" align="center" valign="middle"width="95%"><span class="genmed">1.000 sukkeltjes</span></td>
         </tr>
         
         
           
         
         
         
 </table>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

 
 
 
           
      
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
          </table>    
           
           
           
		
		
		
		
		
		
		
		
		
		
		
		
		
</center>
		
		
		</a>
	
	
	
	
	<TR>
	<td class="catBottom" align="center" colspan="6"></td>
	</tr>
</table></center>
<HTML>

php

Code: Selecteer alles

<?php 

// standard hack prevent 
define('IN_PHPBB', true); 
$phpbb_root_path = './'; 
include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'common.'.$phpEx); 

// standard session management 
$userdata = session_pagestart($user_ip, PAGE_TEMPLATE); 
init_userprefs($userdata); 

// set page title 
$page_title = 'TEMPLATE'; 

// standard page header 
include($phpbb_root_path . 'includes/page_header.'.$phpEx); 

// assign template 
$template->set_filenames(array( 
        'body' => 'top_posters.tpl') 
); 



//
//start top poster
//

$total_poster = '50'; // total of top poster
$avatar_height = '50'; // the avatar's height

$sql = "SELECT username, user_id,  user_maand,  user_avatar, user_avatar_type, user_allowavatar
        FROM " . USERS_TABLE . "
        WHERE user_id <> " . ANONYMOUS . "
        ORDER BY user_maand DESC LIMIT $total_poster";
if( !($result = $db->sql_query($sql)) )
{
        message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}

if ( $row = $db->sql_fetchrow($result) )
{
        $i = 0;
        do
        {
                $username = $row['username'];
				            $user_id = $row['user_id'];
                $posts = ( $row['user_maand'] ) ? $row['user_maand'] : 0;
                $poster_avatar = '';
                if ( $row['user_avatar_type'] && $user_id != ANONYMOUS && $row['user_allowavatar'] )
                {
                        switch( $row['user_avatar_type'] )
                        {
                                case USER_AVATAR_UPLOAD:
                                        $poster_avatar = ( $board_config['allow_avatar_upload'] ) ? '<img src="' . $board_config['avatar_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" height="' . $avatar_height . '" />' : '';
                                        break;
                                case USER_AVATAR_REMOTE:
                                        $poster_avatar = ( $board_config['allow_avatar_remote'] ) ? '<img src="' . $row['user_avatar'] . '" alt="" border="0" height="' . $avatar_height . '" />' : '';
                                        break;
                                case USER_AVATAR_GALLERY:
                                        $poster_avatar = ( $board_config['allow_avatar_local'] ) ? '<img src="' . $board_config['avatar_gallery_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" height="' . $avatar_height . '" />' : '';
                                        break;
                        }
                }



                $template->assign_block_vars('topposter', array(

                        'USERNAME' => $username,
						'POSTS' => $posts,
                        'AVATAR_IMG' => $poster_avatar,
						'NUMBER' => ($start + $i + 1),
						'U_VIEWPOSTER' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id"))
                );

                $i++;
        }
        while ( $row = $db->sql_fetchrow($result) );
}

//
//end top poster
//

$template->pparse('body'); 

// standard page footer 
include($phpbb_root_path . 'includes/page_tail.'.$phpEx); 

?>

Vervang (in de tpl) dit:

Code: Selecteer alles

{user_row.ROW_NUMBER}

Met:

Code: Selecteer alles

{topposter.ROW_NUMBER}

Vervang (in de php code) dit:

Code: Selecteer alles

'NUMBER' => ($start + $i + 1),

Met:

Code: Selecteer alles

'ROW_NUMBER' => ($i + 1),

Hartelijk dank

phpBB.nl

nummer ervoor

nummer ervoor