![Antiguo](http://static.forosdelweb.com/fdwtheme/images/statusicon/post_old.gif)
04/07/2002, 18:22
|
| | Fecha de Ingreso: febrero-2002 Ubicación: Valencia - España
Mensajes: 488
Antigüedad: 23 años Puntos: 0 | |
Re: nuevo mod para el foro de PhpBB ayudarme
Código:
<td align="center" class="{mini.ROW}"><span class="gen"><a href="{mini.NEWMB}">{mini.NBNAME}</a></span></td>
<td align="center" class="{mini.ROW}"><span class="gen">{mini.POST}</span></td>
<td align="center" class="{mini.ROW}"><span class="gen"><a href="{mini.TOPIC}">{mini.NOM}</a></span></td>
<td align="center" class="{mini.ROW}"><span class="gen">{mini.ID}</span></td>
</tr>
<!-- END mini -->
<!-- BEGIN pop -->
<tr>
<td colspan="6" align="center" class="row2"><span class="gen">le sujet le plus vus est: <a href="{pop.TOPIC}">{pop.POST}</a>, il a été vu {pop.NB} fois</span></td>
</tr>
<!-- END pop -->
</table>
<br>
##########
# sauvegarde et ferme
##########
##########
# Ouvre le fichier index.php situé à la racine du forum
##########
##########
# cherche
##########
//
// Generate the page
//
##########
# ajoutes juste avant
##########
//
// generation des mini stats (top5 utilisateurs)
//
$top_posting_users_sql="SELECT user_id,username,user_posts FROM phpbb2_users where user_id>0 ORDER BY user_posts DESC LIMIT 5";
$top_posting_users = $db->sql_query($top_posting_users_sql);
$last_topic_replies_sql="SELECT topic_id,topic_title,topic_views FROM phpbb2_topics where topic_id>0 ORDER BY topic_id DESC LIMIT 5";
$last_replies = $db->sql_query($last_topic_replies_sql);
$new_mb_sql="SELECT user_id,username,user_posts FROM phpbb2_users ORDER BY user_id DESC LIMIT 5";
$new_mb = $db->sql_query($new_mb_sql);
// préparation de l'affichage (top5 utilisateurs)
while ($line = mysql_fetch_array($top_posting_users) AND $line2 = mysql_fetch_array($last_replies) AND $line3 = mysql_fetch_array($new_mb)) {
$rank++;
if($num==1) {
$class=row1;
$num = 0;
} else {
$class=row2;
$num++;
}
|