Code: Selecteer alles
<td class="row1" align="right" valign="middle" width="8%">{user_row.ROW_NUMBER}</td>en in het php
Code: Selecteer alles
'NUMBER' => ($start + $i + 1),
Code: Selecteer alles
<td class="row1" align="right" valign="middle" width="8%">{user_row.ROW_NUMBER}</td>Code: Selecteer alles
'NUMBER' => ($start + $i + 1),Code: Selecteer alles
<HTML>
<table><tr>
<td align="left" valign="middle" class="nav" width="100%"><span class="nav"> <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">€ 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">€ 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">€ 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">€ 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">€ 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>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);
?>Code: Selecteer alles
{user_row.ROW_NUMBER}Code: Selecteer alles
{topposter.ROW_NUMBER}Code: Selecteer alles
'NUMBER' => ($start + $i + 1), Code: Selecteer alles
'ROW_NUMBER' => ($i + 1),