habe mir ein neues fenster für den mod erstellt. nun sollen die benutzer mit den meisten quizpunkten aufgeführt werden.
habe in den 2 dateien den code von den top postern abgewandelt. die tabelle ist aber irgendwie leer. kann sich das mal jemand anschauen?
portal.php
Code: Alles auswählen
// SWITCH QUIZBOX START
if( $introportalmod_config['quizbox_active'] == "1" )
{
//phpcode
$sql = "SELECT user_id, username, quiz_points
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY quiz_points DESC
LIMIT 5";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain user/online forums information', '', __LINE__, __FILE__, $sql);
}
while ($row = $db->sql_fetchrow($result))
{
$user_id=$row['user_id'];
if( $introportalmod_config['quizbox_active'] == "1" )
{
$template->assign_block_vars("quiz_points", array(
'USERNAME' => $row['username'],
'QUIZ_POINTS' => $row['quiz_points'],
'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id"))
);
}
}
//phpcode
$template->assign_block_vars('switch_quizbox_active', array(
$template->assign_vars(array(
// TEMPLATE CODE VARS START
'QUIZBOX1' => $lang['quizbox1'],
'QUIZBOX2' => $lang['quizbox2']
// TEMPLATE CODE VARS END
))
));
}
// SWITCH QUIZBOX ENDCode: Alles auswählen
<!-- ##### QUIZBOX START ##### -->
<!-- BEGIN switch_quizbox_active -->
<table width="100%" border="0" cellpadding="1" cellspacing="1" style="border-collapse: collapse" class="forumline">
<tr>
<td align="center" class="catHead" colspan="2" height="25"><span class="cattitle">
{QUIZBOX1}:
</span></td>
</tr>
<tr>
<td colspan="2" height="1" class="row3"><img src="images/spacer.gif" width="1" height="1" alt="."></td>
</tr>
<tr>
<td align="center" nowrap="nowrap" class="row1"><span class="gensmall">
<!-- CODE -->
<tr>
<td class="row1"> <span class="genmed"><a href="{quiz_points.U_VIEWPROFILE}" class="genmed">{quiz_points.USERNAME}</a></span> </td>
<td align="center" nowrap="nowrap" class="row2"> <span class="genmed">{quiz_points.QUIZ_POINTS}</span> </td>
</tr>
<!-- CODE -->
</span></td>
</tr>
</table>
<br>
<!-- END switch_quizbox_active -->
<!-- ##### QUIZBOX END ##### -->anzuschauen unter:
http://www.server-control.de/Elsfleth/phpBB2/portal.php
