][مساعدة من ذوي الخبرة عاجل][

[shabab-alqatif]

?????? ????? ????? ???? ???????

????? ??? ???? ???? ??? ???? ???????? ???? ??????? ?????? ???? ???? ??? ??????? ???? ??? ????? ???? ????? ?? ???

?? ????? ?????? ?? ????? ??? ???? ?? ???? ??????? ????? ??? ????..

???? ???????? ????? ?????? ??? ?????? ??? ???? ?????? ??? ?????? ?? ??? ????..

??? ?????? away_moon@hotmail.com

[الفقير]

????? shabab-alqatif

???? ?????? ??? http://www.phpbbarabia.com/board/terms.php ???? ??? ???? ?? ?????

????? ?? ??? ???? ?? ???? ???? ??? ?? ??? ???? ??? ??????? ??????? install.txt ?? ??????.txt
?? readme.txt .. ???? ?????

[shabab-alqatif]

????? ???? ????? ??? ????...


??? ???? ?????? http://members.lycos.co.uk/alqatifmoon

?? ????? ??? ???? ??????? ????? ???? ??????? ??????? ?????? ????

[shabab-alqatif]

??????? ?????? ???? ???? ????

[alnaeemy]

???? ?????
??? ?????? ??????? ?????? ???? ????? ??????? ???? ???? ??????? ???? ??? ???????


??? ??? ??? ?????? ???? ??? ?????? ???? ??? ???? ??? ??? ????

***********************************

##########
# ???? index_body.tpl
##########
# ???? ?? ???????
##########
<br>
<TABLE cellSpacing="1" cellPadding="3" width="100%" align="center" border="0" class="forumline">
<tr>
<th colspan="2">???? 5 ???? </th>
<th colspan="2">??? 5 ??????</th>
<th colspan="2">??? 5 ??????</th>
</tr>
<tr>
<td align="center" width="16%" class="row3"><span class="gen">???????</span></td>
<td align="center" width="16%" class="row3"><span class="gen">?????????</span></td>
<td align="center" width="16%" class="row3"><span class="gen">????????</span></td>
<td align="center" width="16%" class="row3"><span class="gen">?????????</span></td>
<td align="center" width="16%" class="row3"><span class="gen">????????</span></td>
<td align="center" width="16%" class="row3"><span class="gen">?????????</span></td>
</tr>
<!-- BEGIN mini -->
<tr>
<td align="center" class="{mini.ROW}"><span class="gen"><a href="{mini.POSTER}">{mini.POSTERA}</a></span></td>
<td align="center" class="{mini.ROW}"><span class="gen">{mini.NBPOSTS}</span></td>

<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">???? ????? ?????? ??: <a href="{pop.TOPIC}">{pop.POST}</a>, ??? ?????? ??????? {pop.NB} ???</td>
</tr>
<!-- END pop -->
</table>
<br>
##########
# ???? ?????
##########
# ???? index.php
##########
# ???? ??
##########
//
// Generate the page
//

##########
# ?? ???? ???
##########
//
// generation des mini stats (top5 utilisateurs)
//
$top_posting_users_sql="SELECT user_id,username,user_posts FROM phpbb_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 phpbb_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 phpbb_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++;
}
$usertop5 = append_sid("profile.php?mode=viewprofile&u=".$line['user_id']);
$newmb = append_sid("profile.php?mode=viewprofile&u=".$line3['user_id']);
$topic = append_sid("viewtopic.php?t=".$line2['topic_id']);

$sql = "SELECT poster_id, COUNT(*) AS real_user_posts
FROM ".POSTS_TABLE. "
WHERE poster_id = ".$line['user_id']."
GROUP BY poster_id";
$result = $db->sql_query($sql);
$rowuserposts = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$posts_per_day = $rowuserposts['real_user_posts'];

$sql = "SELECT poster_id, COUNT(*) AS real_user_posts
FROM ".POSTS_TABLE. "
WHERE poster_id = ".$line3['user_id']."
GROUP BY poster_id";
$result = $db->sql_query($sql);
$rowuserposts = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
$posts_per_day2 = $rowuserposts['real_user_posts'];

$template->assign_block_vars('mini', array(
'NEWMB' => $newmb,
'NBNAME' => $line3['username'],
'POST' => $posts_per_day2,
'POSTER' => $usertop5,
'POSTERA' => $line['username'],
'NBPOSTS' => $posts_per_day,
'TOPIC' => $topic,
'ID' => $line2['topic_views'],
'ROW' => $class,
'NOM' => $line2['topic_title'])
);
};
// fin du top 5 utilisateurs
//
//sujet le plus populaire
//
$topic_views_sql="SELECT topic_title,topic_views,topic_id FROM phpbb_topics ORDER BY topic_views DESC LIMIT 1";
$more_views = $db->sql_query($topic_views_sql);
while ($line = mysql_fetch_array($more_views)) {
$topic = append_sid("viewtopic.php?t=".$line['topic_id']);
$template->assign_block_vars('pop', array(
'TOPIC' => $topic,
'POST' => $line['topic_title'],
'NB' => $line['topic_views'])
);
};
// fin du sujet le plus populaire