السلام عليكم ممكن تدخلو هنا
المشرف: alhitary
قوانين المنتدى
فضلاً قبل وضع أي مشكلة تأكد من استخدام البحث ومن ثم ملء استمارة الدعم إذا لم تجد حلا لمشكلتك.
فضلاً قبل وضع أي مشكلة تأكد من استخدام البحث ومن ثم ملء استمارة الدعم إذا لم تجد حلا لمشكلتك.
- AL_AWAL_15
- عضو جديد
- مشاركات: 12
- اشترك في: الخميس سبتمبر 22, 2005 2:44 pm
- مكان: السعودية
- اتصال:
?????? ????? ???? ????? ???
?????? ????? ????? ???? ???????
?? ????? ??? ???? ???? ???? ????? ??? ????? ????? ???? ??? ??? 5
?? ????? ??? ??? ???? ?????
???? ???? ???? ??? ????? ???? ???????? ???? ?? ???? ??? ????? ???? ???? ??????? ????????? ???
??? ?? ??? ???? ????? 8)
??? ???? ?????? http://www.bluo3.com/vb
?? ????? ??? ???? ???? ???? ????? ??? ????? ????? ???? ??? ??? 5
?? ????? ??? ??? ???? ?????

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

??? ?? ??? ???? ????? 8)
??? ???? ?????? http://www.bluo3.com/vb
- momo2020
- عضو فعال
- مشاركات: 625
- اشترك في: الأربعاء ديسمبر 21, 2005 3:08 am
- مكان: مصـــ ام الدنيا ـــر
- اتصال:
?????? ?????? ???:)
?? ???? ???? ?????? ????? ???????? ???? ?? ??? ???????? ????? ??? ????? ?????:o
??????
?? ???? ???? ?????? ????? ???????? ???? ?? ??? ???????? ????? ??? ????? ?????:o
??????
كلمتان خفيفتان على اللسان ثقيلتان في الميزان حبيبتان الى الرحمن .. سبحان الله وبحمده سبحان الله العظيم .
هـــلا

- AL_AWAL_15
- عضو جديد
- مشاركات: 12
- اشترك في: الخميس سبتمبر 22, 2005 2:44 pm
- مكان: السعودية
- اتصال:
- momo2020
- عضو فعال
- مشاركات: 625
- اشترك في: الأربعاء ديسمبر 21, 2005 3:08 am
- مكان: مصـــ ام الدنيا ـــر
- اتصال:
??? ???? ?? ???????
????? ???? ??????? ?? ???????
??? ???index_body.tpl
??? ???index.php
??????
[/b]

????? ???? ??????? ?? ???????
??? ???index_body.tpl
كود: تحديد الكل
<!-- BEGIN switch_user_logged_out -->
<form method="post" action="{U_INDEX}"><b>{L_SELECT_STYLE}:</b>
<br>{TEMPLATE_SELECT} <input type="submit" class="mainoption" name="cangenow" value="{L_CHANGE_NOW}" />
</form>
<!-- END switch_user_logged_out -->
<!-- BEGIN switch_user_logged_in -->
<form method="post" action="{U_INDEX}"><b>{L_SELECT_STYLE}:</b>
<br>{FPAGE_STYLE} <input type="submit" class="mainoption" name="fpcangenow" value="{L_CHANGE_NOW}" />
</form>
<!-- END switch_user_logged_in -->
<div align="center">
<table width="100%" cellspacing="0" cellpadding="2" border="0" style="border: 1px dotted #CCCCCC">
<tr>
<td align="right" valign="bottom"><span class="gensmall">
<!-- BEGIN switch_user_logged_in -->
{LAST_VISIT_DATE}<br />
<!-- END switch_user_logged_in -->
{CURRENT_TIME}<br /></span><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a></span></td>
<td align="right" valign="bottom" class="gensmall">
<!-- BEGIN switch_user_logged_in -->
<a href="{U_SEARCH_NEW}" class="gensmall">{L_SEARCH_NEW}</a><br /><a href="{U_SEARCH_SELF}" class="gensmall">{L_SEARCH_SELF}</a><br />
<!-- END switch_user_logged_in -->
<a href="{U_SEARCH_UNANSWERED}" class="gensmall">{L_SEARCH_UNANSWERED}</a></td>
</tr>
</table>
</div>
<!-- BEGIN catrow -->
<table width="100%" cellpadding="2" cellspacing="0" class="forumline">
<thead>
<caption><table border="0" cellspacing="0" cellpadding="0" width="100%" class="forumheader">
<tr>
<td align="right" valign="bottom" width="25">
<img src="templates/Dream8/images/hdr_left.gif" alt="" /></td>
<td align="center"><a href="{catrow.U_VIEWCAT}">{catrow.CAT_DESC}</a></td>
<td align="right" valign="bottom" width="25">
<img src="templates/Dream8/images/hdr_right.gif" alt="" border="0" /></td>
</tr></table></caption>
</thead>
<tbody>
<tr>
<th colspan="2">{L_FORUM}</th>
<th width="50">{L_TOPICS}</th>
<th width="50">{L_POSTS}</th>
<th>{L_LASTPOST}</th>
</tr>
<!-- BEGIN forumrow -->
<tr>
<td class="row1" align="center" valign="middle" style="padding: 5px;">
<img src="{catrow.forumrow.FORUM_FOLDER_IMG}" width="40" height="40" alt="{catrow.forumrow.L_FORUM_FOLDER_ALT}" title="{catrow.forumrow.L_FORUM_FOLDER_ALT}" /></td>
<td class="row1" align="right" width="100%"> <fieldset>
<legend><span class="forumlink"> <script language="JavaScript">FolderStart('{catrow.forumrow.FORUM_FOLDER_IMG}');</script><a href="{catrow.forumrow.U_VIEWFORUM}" class="forumlink">{catrow.forumrow.FORUM_NAME}</a><script language="JavaScript">FolderEnd();</script></span><table border="0" width="100%" cellspacing="0" cellpadding="0" style="border: 1px solid #C0C0C0; " height="25">
<tr>
<td bgcolor="#CFCFCF" width="5"> </td>
<td bgcolor="#F7F7F7"> <span class="genmed"> {catrow.forumrow.FORUM_DESC}</span></td>
</tr>
</table>
<span class="genmed">
</span><span class="gensmall">{catrow.forumrow.L_MODERATOR} {catrow.forumrow.MODERATORS}</span></td>
<td class="row2" align="center" valign="middle"><span class="gensmall">{catrow.forumrow.TOPICS}</span></td>
<td class="row2" align="center" valign="middle"><span class="gensmall">{catrow.forumrow.POSTS}</span></td>
<td class="row2" align="center" valign="middle" nowrap="nowrap"> <span class="gensmall">{catrow.forumrow.LAST_POST}</span></td>
</tr>
<!-- END forumrow -->
</tbody>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="90">
<img border="0" src="templates/Dream8/images/rightdown.gif" width="90" height="25"></td>
<td background="templates/Dream8/images/middown.gif"> </td>
<td width="90">
<img border="0" src="templates/Dream8/images/leftdown.gif" width="90" height="25"></td>
</tr>
</table>
<br class="spacer" />
<!-- END catrow -->
<table width="100%" cellspacing="0" border="0" align="center" cellpadding="2">
<tr>
<td align="right"><span class="gensmall"><a href="{U_MARK_READ}" class="gensmall">{L_MARK_FORUMS_READ}</a></span></td>
<td align="right"><span class="gensmall">{S_TIMEZONE}</span></td>
</tr>
</table>
<table width="100%" cellpadding="3" cellspacing="0" class="forumline">
<thead>
<caption><table border="0" cellspacing="0" cellpadding="0" width="100%" class="forumheader">
<tr>
<td align="right" valign="bottom" width="25"><img src="templates/Dream8/images/hdr_left.gif" alt="" /></td>
<td align="center"><a href="{U_VIEWONLINE}">{L_WHO_IS_ONLINE}</a></td>
<td align="right" valign="bottom" width="25"><img src="templates/Dream8/images/hdr_right.gif" alt="" /></td>
</tr></table></caption>
</thead>
<tbody>
<tr>
<td class="row1" align="center" valign="middle" rowspan="2" style="padding: 5px;">
<img src="templates/Dream8/images/whosonline.gif" alt="{L_WHO_IS_ONLINE}" width="40" height="40" /></td>
<td class="row1" align="right" width="100%"><span class="gensmall">{TOTAL_POSTS}<br />{TOTAL_USERS}<br />{NEWEST_USER}</span>
</td>
</tr>
<tr>
<td class="row1" align="right"><span class="gensmall">{TOTAL_USERS_ONLINE} [ {L_WHOSONLINE_ADMIN} ] [ {L_WHOSONLINE_MOD} ]<br />{RECORD_USERS}<br />{LOGGED_IN_USER_LIST}</span></td>
</tr>
</tbody>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="90">
<img border="0" src="templates/Dream8/images/rightdown.gif" width="90" height="25"></td>
<td background="templates/Dream8/images/middown.gif"> </td>
<td width="90">
<img border="0" src="templates/Dream8/images/leftdown.gif" width="90" height="25"></td>
</tr>
</table>
<table width="100%" cellpadding="1" cellspacing="1" border="0">
<tr>
<td align="right" valign="top">
<p align="center"><span class="gensmall">{L_ONLINE_EXPLAIN}</span></td>
</tr>
</table>
<!-- BEGIN switch_user_logged_out -->
<form method="post" action="{S_LOGIN_ACTION}">
<table width="100%" cellpadding="2" cellspacing="0" class="forumline">
<thead>
<caption><table border="0" cellspacing="0" cellpadding="0" width="100%" class="forumheader">
<tr>
<td align="right" valign="bottom" width="25"><img src="templates/Dream8/images/hdr_left.gif" alt="" /></td>
<td align="center"><a name="login"></a>{L_LOGIN_LOGOUT}</td>
<td align="right" valign="bottom" width="25"><img src="templates/Dream8/images/hdr_right.gif" alt="" /></td>
</tr></table></caption>
</thead>
<tbody>
<tr>
<td class="row1" align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="1">
<tr>
<td><span class="gensmall">{L_USERNAME}:</span></td>
<td>
<input class="post" type="text" name="username" size="10" style="border-style: dotted; border-width: 1px; background-image: url('templates/Dream8/images/Dream8_03.jpg')" /></td>
<td><span class="gensmall"> {L_PASSWORD}:</span>
<td>
<input class="post" type="password" name="password" size="10" maxlength="32" style="border-style:dotted; border-width:1px; background-image: url('templates/Dream8/images/Dream8_03.jpg')" /></td>
<td><span class="gensmall"> {L_AUTO_LOGIN}</span></td>
<td width="20"><span class="cbstyled"><input type="checkbox" name="autologin" /></span></td>
<td><span class="gensmall"> </span></td>
<td><input type="submit" class="mainoption" name="login" value="{L_LOGIN}" /></td>
</tr>
</table></td>
</tr>
</tbody>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="90">
<img border="0" src="templates/Dream8/images/rightdown.gif" width="90" height="25"></td>
<td background="templates/Dream8/images/middown.gif"> </td>
<td width="90">
<img border="0" src="templates/Dream8/images/leftdown.gif" width="90" height="25"></td>
</tr>
</table>
</form>
<form method="post" action="profile.php">
<table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
<tr><td class="catHead" height="28" colspan="4">
<a href="profile.php?mode=register&agreed=TRUE" class="nav"><span class="nav"><font color="006699">????? ????</span></a>
</td></tr>
<tr colspan="4">
<td class="row1" width="25%"><span class="genmed">??? ????????: *</span></td><td class="row2" width=25%><input type="text" class="post" style="width:150px" name="username" size="25" maxlength="20" value="" /></td>
<td class="row1" width=25%><span class="genmed">?????? ??????????: *</span></td> <td class="row2"><input type="text" class="post" style="width:150px" name="email" size="25" maxlength="255" value="" /></td>
</TR><TR colspan="4">
<td class="row1" width=25%><span class="genmed">???? ????: *</span><br /><span class="gensmall"></span></td><td class="row2"><input type="password" class="post" style="width: 150px" name="new_password" size="25" maxlength="100" value="" /></td>
<td class="row1" width=25%><span class="genmed">??? ???? ????: * </span>
<br /><span class="gensmall"></span></td><td class="row2" width=25%> <input type="password" class="post" style="width: 150px" name="password_confirm" size="25" maxlength="100" value="" /></td>
</tr><tr colspan="4">
<td class="row1"><span class="genmed" width=25%>?????: *</span></td><td class="row2" width=25% div align=right><input type="hidden" name="gender" value="0" checked="checked"/><div align=right><span class="gen"></span><input type="radio" name="gender" value="1" /><span class="genmed">???</span> <input type="radio" name="gender" value="2" /><span class="genmed">????</span></td>
<input type="hidden" name="viewemail" value="1" />
<input type="hidden" name="viewemail" value="0" checked="checked" />
<input type="hidden" name="hideonline" value="1" />
<input type="hidden" name="hideonline" value="0" checked="checked" />
<input type="hidden" name="notifyreply" value="1" />
<input type="hidden" name="notifyreply" value="0" checked="checked" />
<input type="hidden" name="notifypm" value="1" checked="checked" />
<input type="hidden" name="notifypm" value="0" />
<input type="hidden" name="popup_pm" value="1" checked="checked" />
<input type="hidden" name="popup_pm" value="0" />
<input type="hidden" name="attachsig" value="1" checked="checked" />
<input type="hidden" name="attachsig" value="0" />
<input type="hidden" name="allowbbcode" value="1" checked="checked" />
<input type="hidden" name="allowbbcode" value="0" />
<input type="hidden" name="allowhtml" value="1" />
<input type="hidden" name="allowhtml" value="0" checked="checked" />
<input type="hidden" name="allowsmilies" value="1" checked="checked" />
<input type="hidden" name="allowsmilies" value="0" />
<input type="hidden" name="dateformat" value="D M d, Y g:i a" maxlength="14" class="post" />
<td class="row1" width=25%><span class="genmed">???? ???? "????": *</span></td><td class="row2" colspan="1" align="right" height="28" width=25%><input type="hidden" name="mode" value="register" />
<input type="hidden" name="agreed" value="true" />
<input type="hidden" name="coppa" value="0" />
<input type="submit" name="submit" value="????" class="liteoption" />
<input type="reset" value="???" name="reset" class="liteoption" /></td>
</tr></form>
</table>
<!-- END switch_user_logged_out -->
<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
كود: تحديد الكل
<?php
/***************************************************************************
* index.php
* -------------------
* begin : Saturday, Feb 13, 2001
* copyright : (C) 2001 The phpBB Group
* email : support@phpbb.com
*
* $Id: index.php,v 1.99.2.6 2005/10/30 15:17:13 acydburn Exp $
*
*
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
$viewcat = ( !empty($HTTP_GET_VARS[POST_CAT_URL]) ) ? $HTTP_GET_VARS[POST_CAT_URL] : -1;
if( isset($HTTP_GET_VARS['mark']) || isset($HTTP_POST_VARS['mark']) )
{
$mark_read = ( isset($HTTP_POST_VARS['mark']) ) ? $HTTP_POST_VARS['mark'] : $HTTP_GET_VARS['mark'];
}
else
{
$mark_read = '';
}
//change theme on index - new code by Smartor (smartor.is-root.com)
$fpage_style = $userdata['user_style'];
if(isset($HTTP_POST_VARS['fpage_theme']))
{
$fpage_theme = intval($HTTP_POST_VARS['fpage_theme']);
$fpuser_id = $userdata['user_id'];
$fp_sql = "UPDATE " . USERS_TABLE . " SET user_style = '$fpage_theme' WHERE
user_id = $fpuser_id";
if ( !($fp_result = $db->sql_query($fp_sql)) )
{
message_die(GENERAL_ERROR, 'Could not update users table ' . "$user_id
$fpage_theme", '', __LINE__, __FILE__, $sql);
}
else
{
$fp_message = $lang['Profile_updated'] . '<br /><br />' .
sprintf($lang['Click_return_index'], '<a href="' .
append_sid("index.$phpEx") . '">', '</a>');
message_die(GENERAL_MESSAGE, $fp_message);
}
}
//
// Handle marking posts
//
if( $mark_read == 'forums' )
{
if( $userdata['session_logged_in'] )
{
setcookie($board_config['cookie_name'] . '_f_all', time(), 0, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']);
}
$template->assign_vars(array(
"META" => '<meta http-equiv="refresh" content="3;url=' .append_sid("index.$phpEx") . '">')
);
$message = $lang['Forums_marked_read'] . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a> ');
message_die(GENERAL_MESSAGE, $message);
}
//
// End handle marking posts
//
$tracking_topics = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . "_t"]) : array();
$tracking_forums = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . "_f"]) : array();
//
// If you don't use these stats on your index you may want to consider
// removing them
//
$total_posts = get_db_stat('postcount');
$total_users = get_db_stat('usercount');
$newest_userdata = get_db_stat('newestuser');
$newest_user = $newest_userdata['username'];
$newest_uid = $newest_userdata['user_id'];
if( $total_posts == 0 )
{
$l_total_post_s = $lang['Posted_articles_zero_total'];
}
else if( $total_posts == 1 )
{
$l_total_post_s = $lang['Posted_article_total'];
}
else
{
$l_total_post_s = $lang['Posted_articles_total'];
}
if( $total_users == 0 )
{
$l_total_user_s = $lang['Registered_users_zero_total'];
}
else if( $total_users == 1 )
{
$l_total_user_s = $lang['Registered_user_total'];
}
else
{
$l_total_user_s = $lang['Registered_users_total'];
}
//
// Start page proper
//
$sql = "SELECT c.cat_id, c.cat_title, c.cat_order
FROM " . CATEGORIES_TABLE . " c
ORDER BY c.cat_order";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}
$category_rows = array();
while( $category_rows[] = $db->sql_fetchrow($result) );
$db->sql_freeresult($result);
if( ( $total_categories = count($category_rows) ) )
{
//
// Define appropriate SQL
//
switch(SQL_LAYER)
{
case 'postgresql':
$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
WHERE p.post_id = f.forum_last_post_id
AND u.user_id = p.poster_id
UNION (
SELECT f.*, NULL, NULL, NULL, NULL
FROM " . FORUMS_TABLE . " f
WHERE NOT EXISTS (
SELECT p.post_time
FROM " . POSTS_TABLE . " p
WHERE p.post_id = f.forum_last_post_id
)
)
ORDER BY cat_id, forum_order";
break;
case 'oracle':
$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
WHERE p.post_id = f.forum_last_post_id(+)
AND u.user_id = p.poster_id(+)
ORDER BY f.cat_id, f.forum_order";
break;
default:
$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
FROM (( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
ORDER BY f.cat_id, f.forum_order";
break;
}
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
}
$forum_data = array();
while( $row = $db->sql_fetchrow($result) )
{
$forum_data[] = $row;
}
$db->sql_freeresult($result);
if ( !($total_forums = count($forum_data)) )
{
message_die(GENERAL_MESSAGE, $lang['No_forums']);
}
//
// Obtain a list of topic ids which contain
// posts made since user last visited
//
if ($userdata['session_logged_in'])
{
// 60 days limit
if ($userdata['user_lastvisit'] < (time() - 5184000))
{
$userdata['user_lastvisit'] = time() - 5184000;
}
$sql = "SELECT t.forum_id, t.topic_id, p.post_time
FROM " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p
WHERE p.post_id = t.topic_last_post_id
AND p.post_time > " . $userdata['user_lastvisit'] . "
AND t.topic_moved_id = 0";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query new topic information', '', __LINE__, __FILE__, $sql);
}
$new_topic_data = array();
while( $topic_data = $db->sql_fetchrow($result) )
{
$new_topic_data[$topic_data['forum_id']][$topic_data['topic_id']] = $topic_data['post_time'];
}
$db->sql_freeresult($result);
}
//
// Obtain list of moderators of each forum
// First users, then groups ... broken into two queries
//
$sql = "SELECT aa.forum_id, u.user_id, u.username
FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g, " . USERS_TABLE . " u
WHERE aa.auth_mod = " . TRUE . "
AND g.group_single_user = 1
AND ug.group_id = aa.group_id
AND g.group_id = aa.group_id
AND u.user_id = ug.user_id
GROUP BY u.user_id, u.username, aa.forum_id
ORDER BY aa.forum_id, u.user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query forum moderator information', '', __LINE__, __FILE__, $sql);
}
$forum_moderators = array();
while( $row = $db->sql_fetchrow($result) )
{
$forum_moderators[$row['forum_id']][] = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '">' . $row['username'] . '</a>';
}
$db->sql_freeresult($result);
$sql = "SELECT aa.forum_id, g.group_id, g.group_name
FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g
WHERE aa.auth_mod = " . TRUE . "
AND g.group_single_user = 0
AND g.group_type <> " . GROUP_HIDDEN . "
AND ug.group_id = aa.group_id
AND g.group_id = aa.group_id
GROUP BY g.group_id, g.group_name, aa.forum_id
ORDER BY aa.forum_id, g.group_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query forum moderator information', '', __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
$forum_moderators[$row['forum_id']][] = '<a href="' . append_sid("groupcp.$phpEx?" . POST_GROUPS_URL . "=" . $row['group_id']) . '">' . $row['group_name'] . '</a>';
}
$db->sql_freeresult($result);
//
// Find which forums are visible for this user
//
$is_auth_ary = array();
$is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data);
//
// Start output of page
//
define('SHOW_ONLINE', true);
$page_title = $lang['Index'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$template->set_filenames(array(
'body' => 'index_body.tpl')
);
$template->assign_vars(array(
'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts),
'TOTAL_USERS' => sprintf($l_total_user_s, $total_users),
'NEWEST_USER' => sprintf($lang['Newest_user'], '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$newest_uid") . '">', $newest_user, '</a>'),
'FORUM_IMG' => $images['forum'],
'FORUM_NEW_IMG' => $images['forum_new'],
'FORUM_LOCKED_IMG' => $images['forum_locked'],
'TEMPLATE_SELECT' => style_select($board_config['default_style'], 'template'),
'L_SELECT_STYLE' => $lang['Change_style'],
'L_CHANGE_NOW' => $lang['Go'],
'FPAGE_STYLE' => style_select($fpage_style, 'fpage_theme'),
'L_FORUM' => $lang['Forum'],
'L_TOPICS' => $lang['Topics'],
'L_REPLIES' => $lang['Replies'],
'L_VIEWS' => $lang['Views'],
'L_POSTS' => $lang['Posts'],
'L_LASTPOST' => $lang['Last_Post'],
'L_NO_NEW_POSTS' => $lang['No_new_posts'],
'L_NEW_POSTS' => $lang['New_posts'],
'L_NO_NEW_POSTS_LOCKED' => $lang['No_new_posts_locked'],
'L_NEW_POSTS_LOCKED' => $lang['New_posts_locked'],
'L_ONLINE_EXPLAIN' => $lang['Online_explain'],
'L_MODERATOR' => $lang['Moderators'],
'L_FORUM_LOCKED' => $lang['Forum_is_locked'],
'L_MARK_FORUMS_READ' => $lang['Mark_all_forums'],
'U_MARK_READ' => append_sid("index.$phpEx?mark=forums"))
);
//
// Okay, let's build the index
//
for($i = 0; $i < $total_categories; $i++)
{
$cat_id = $category_rows[$i]['cat_id'];
//
// Should we display this category/forum set?
//
$display_forums = false;
for($j = 0; $j < $total_forums; $j++)
{
if ( $is_auth_ary[$forum_data[$j]['forum_id']]['auth_view'] && $forum_data[$j]['cat_id'] == $cat_id )
{
$display_forums = true;
}
}
//
// Yes, we should, so first dump out the category
// title, then, if appropriate the forum list
//
if ( $display_forums )
{
$template->assign_block_vars('catrow', array(
'CAT_ID' => $cat_id,
'CAT_DESC' => $category_rows[$i]['cat_title'],
'U_VIEWCAT' => append_sid("index.$phpEx?" . POST_CAT_URL . "=$cat_id"))
);
if ( $viewcat == $cat_id || $viewcat == -1 )
{
for($j = 0; $j < $total_forums; $j++)
{
if ( $forum_data[$j]['cat_id'] == $cat_id )
{
$forum_id = $forum_data[$j]['forum_id'];
if ( $is_auth_ary[$forum_id]['auth_view'] )
{
if ( $forum_data[$j]['forum_status'] == FORUM_LOCKED )
{
$folder_image = $images['forum_locked'];
$folder_alt = $lang['Forum_locked'];
}
else
{
$unread_topics = false;
if ( $userdata['session_logged_in'] )
{
if ( !empty($new_topic_data[$forum_id]) )
{
$forum_last_post_time = 0;
while( list($check_topic_id, $check_post_time) = @each($new_topic_data[$forum_id]) )
{
if ( empty($tracking_topics[$check_topic_id]) )
{
$unread_topics = true;
$forum_last_post_time = max($check_post_time, $forum_last_post_time);
}
else
{
if ( $tracking_topics[$check_topic_id] < $check_post_time )
{
$unread_topics = true;
$forum_last_post_time = max($check_post_time, $forum_last_post_time);
}
}
}
if ( !empty($tracking_forums[$forum_id]) )
{
if ( $tracking_forums[$forum_id] > $forum_last_post_time )
{
$unread_topics = false;
}
}
if ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) )
{
if ( $HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all'] > $forum_last_post_time )
{
$unread_topics = false;
}
}
}
}
$folder_image = ( $unread_topics ) ? $images['forum_new'] : $images['forum'];
$folder_alt = ( $unread_topics ) ? $lang['New_posts'] : $lang['No_new_posts'];
}
$posts = $forum_data[$j]['forum_posts'];
$topics = $forum_data[$j]['forum_topics'];
if ( $forum_data[$j]['forum_last_post_id'] )
{
$last_post_time = create_date($board_config['default_dateformat'], $forum_data[$j]['post_time'], $board_config['board_timezone']);
$last_post = $last_post_time . '<br />';
$last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? $forum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $forum_data[$j]['user_id']) . '">' . $forum_data[$j]['username'] . '</a> ';
$last_post .= '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $forum_data[$j]['forum_last_post_id']) . '#' . $forum_data[$j]['forum_last_post_id'] . '"><img src="' . $images['icon_latest_reply'] . '" border="0" alt="' . $lang['View_latest_post'] . '" title="' . $lang['View_latest_post'] . '" /></a>';
}
else
{
$last_post = $lang['No_Posts'];
}
if ( count($forum_moderators[$forum_id]) > 0 )
{
$l_moderators = ( count($forum_moderators[$forum_id]) == 1 ) ? $lang['Moderator'] : $lang['Moderators'];
$moderator_list = implode(', ', $forum_moderators[$forum_id]);
}
else
{
$l_moderators = ' ';
$moderator_list = ' ';
}
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
$template->assign_block_vars('catrow.forumrow', array(
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'FORUM_FOLDER_IMG' => $folder_image,
'FORUM_NAME' => $forum_data[$j]['forum_name'],
'FORUM_DESC' => $forum_data[$j]['forum_desc'],
'POSTS' => $forum_data[$j]['forum_posts'],
'TOPICS' => $forum_data[$j]['forum_topics'],
'LAST_POST' => $last_post,
'MODERATORS' => $moderator_list,
'L_MODERATOR' => $l_moderators,
'L_FORUM_FOLDER_ALT' => $folder_alt,
'U_VIEWFORUM' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id"))
);
}
}
}
}
}
} // for ... categories
}// if ... total_categories
else
{
message_die(GENERAL_MESSAGE, $lang['No_forums']);
}
require_once("honor.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
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>

كلمتان خفيفتان على اللسان ثقيلتان في الميزان حبيبتان الى الرحمن .. سبحان الله وبحمده سبحان الله العظيم .
هـــلا

- AL_AWAL_15
- عضو جديد
- مشاركات: 12
- اشترك في: الخميس سبتمبر 22, 2005 2:44 pm
- مكان: السعودية
- اتصال:
- momo2020
- عضو فعال
- مشاركات: 625
- اشترك في: الأربعاء ديسمبر 21, 2005 3:08 am
- مكان: مصـــ ام الدنيا ـــر
- اتصال:
??? ????? ?????? ???? ??? http://www.members.lycos.co.uk/momo2006/gharam
كلمتان خفيفتان على اللسان ثقيلتان في الميزان حبيبتان الى الرحمن .. سبحان الله وبحمده سبحان الله العظيم .
هـــلا

- AL_AWAL_15
- عضو جديد
- مشاركات: 12
- اشترك في: الخميس سبتمبر 22, 2005 2:44 pm
- مكان: السعودية
- اتصال:
- مهند قمرة
- مشرف سابق
- مشاركات: 4222
- اشترك في: السبت أكتوبر 30, 2004 8:32 pm
- مكان: مـصـر [ولي الفخر]
- اتصال:
?? ??? ?????? ????? ???? ?? ??????? ?????? ?????
http://www.bluo3.com/vb/
http://www.bluo3.com/vb/
سأعود قريبا لعالمي في ارابيا 
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-


-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-

الموجودون الآن
المتصفحون للمنتدى الآن: لا يوجد أعضاء مسجلين متصلين و 24 زائرًا