nummer ervoor

Installatie lukt niet? Plotseling een foutmelding. Of weet je niet hoe iets werkt. Problemen met phpBB2 kun je in dit archief opzoeken.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
phpBB2.0.x
Gesloten
timgoud
Berichten: 1505
Lid geworden op: 30 mei 2003, 07:25

nummer ervoor

Bericht door timgoud » 22 jun 2004, 13:48

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

Code: Selecteer alles

          <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

Gebruikersavatar
WebSiteNet
Berichten: 6524
Lid geworden op: 20 okt 2003, 16:56
Locatie: Wieringerwerf
Contacteer:

Bericht door WebSiteNet » 22 jun 2004, 13:58

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

timgoud
Berichten: 1505
Lid geworden op: 30 mei 2003, 07:25

Bericht door timgoud » 22 jun 2004, 14:02

wat moet ik er dan voor doen ?

Gebruikersavatar
WebSiteNet
Berichten: 6524
Lid geworden op: 20 okt 2003, 16:56
Locatie: Wieringerwerf
Contacteer:

Bericht door WebSiteNet » 22 jun 2004, 14:04

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

timgoud
Berichten: 1505
Lid geworden op: 30 mei 2003, 07:25

Bericht door timgoud » 22 jun 2004, 14:07

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); 

?>

Gebruikersavatar
WebSiteNet
Berichten: 6524
Lid geworden op: 20 okt 2003, 16:56
Locatie: Wieringerwerf
Contacteer:

Bericht door WebSiteNet » 22 jun 2004, 14:11

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), 

timgoud
Berichten: 1505
Lid geworden op: 30 mei 2003, 07:25

Bericht door timgoud » 22 jun 2004, 14:17

Hartelijk dank

Gesloten