تعلمنا في phpBB3 !

[Masrawy]

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

??? ( ????? ????? ???? ??????? ??? ????? )

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











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

???????

[saanina]

??? ?? ???? ????? ?????? :
http://www.phpbbarabia.com/community/vi ... 79#p159579

??? ?????? ????? ???? ????? ?? utf8 :

[saanina]

??? ??????? ????? ??????? ?? ???? ?????? "?????" ?? ???? ?????? .. ???? ??? ???? ???? ??????? :




????? ??????? ????? ??? ????? : ?? ??? ??????? ???? ????? ?????? ????? ?? ???? ????? ???????
??????? ??????? ????? ??? ??????? ???? ????? ..

[saanina]

??? ??????? , ?? ????? ??????? , ?? ??? ????? ?? ?? ???????? ????? ???? "?????" ????? .. ??? ??? ???????? ??????? ..
??? ????? ?????? ?????? ???? ??????? ???? ???? ? "????" ..

[saanina]

?? ??? ????????? ???? ??? ???????? ????? ???? , ????? ?????? ??? ??????? ..
????? ?? ??????? ?????? ??? ??????? ?????? ! ??? ??? ?

---------------
???? ?? phpmyadmin ? ???? ????? ?????? ??????? ????? ?????? ??? SQL

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

كود: تحديد الكل

UPDATE phpbb_topics SET topic_status = 1 WHERE topic_time < UNIX_TIMESTAMP('2008-11-30 12:0:0')

2008-11-30 12:0:0
?? ??????? ???? ???? ?? ???? ???? ??? ??? !
2008 : ?????
11: ?????
30: ?????

??? ????? ????? ??? ??????? ???????? ???????? ???????? ??? ??? ??? !

[saanina]

* ????? ????? ??? ????????? ??????? ??? "????? ??????" drop down

??? :


???? ??? includes/functions_display.php
????

كود: تحديد الكل

$s_subforums_list[]?=?'<a?href="'?.?$subforum['link']?.?'"?class="subforum?'?.?(($subforum['unread'])???'unread'?:?'read')?.?'"?title="'?.?(($subforum['unread'])???$user->lang['NEW_POSTS']?:?$user->lang['NO_NEW_POSTS'])?.?'">'?.?$subforum['name']?.?'</a>';??

????? ??

كود: تحديد الكل

$s_subforums_list[]?=?'<option?value="'?.?$subforum['link']?.?'">'.?$subforum['name']?.?'</option>';??

????

كود: تحديد الكل

$s_subforums_list?=?(string)?implode(',?',?$s_subforums_list);??

?????

كود: تحديد الكل

$s_subforums_list?=?(string)?implode(null,?$s_subforums_list);??

????

كود: تحديد الكل

'SUBFORUMS'????????????????????????????????=>?$s_subforums_list,??

?????

كود: تحديد الكل

'SUBFORUMS'????????????????????????=>?empty($s_subforums_list)???''?:?'<select?onchange="location.href=this.options[this.selectedIndex].value"><option?selected="selected">'?.?$user->lang['SELECT_FORUM']?.?'</option>'?.?$s_subforums_list?.'</select>',??

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

[saanina]

????? ????? ????? ???????? ??????? utf8

كود: تحديد الكل

ALTER TABLE `phpbb_acl_groups`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_acl_options`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_acl_roles`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_acl_roles_data`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_acl_users`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_attachments`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_banlist`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_bbcodes`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_bookmarks`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_bots`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_config`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_confirm`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_disallow`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_drafts`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_extensions`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_extension_groups`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_forums`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_forums_access`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_forums_track`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_forums_watch`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_groups`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_lang`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_log`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_moderator_cache`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_modules`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_poll_options`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_poll_votes`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_posts`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_privmsgs`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_privmsgs_folder`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_privmsgs_rules`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_privmsgs_to`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_profile_fields`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_profile_fields_data`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_profile_fields_lang`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_profile_lang`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_ranks`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_reports`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_reports_reasons`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_search_results`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_search_wordlist`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_search_wordmatch`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_sessions`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_sessions_keys`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_sitelist`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_smilies`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_styles`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_styles_imageset`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_styles_imageset_data`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_styles_template`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_styles_template_data`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_styles_theme`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_topics`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_topics_posted`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_topics_track`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_topics_watch`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_users`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_user_group`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_warnings`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_words`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

ALTER TABLE `phpbb_zebra`  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

[saanina]

* ????? ????? ??? ????????? ??????? ??? "????? ?????"

???? ??? includes/functions_display.php
????

كود: تحديد الكل

$s_subforums_list[] = '<a href="' . $subforum['link'] . '" class="subforum ' . (($subforum['unread']) ? 'unread' : 'read') . '" title="' . (($subforum['unread']) ? $user->lang['NEW_POSTS'] : $user->lang['NO_NEW_POSTS']) . '">' . $subforum['name'] . '</a>';   

????? ??

كود: تحديد الكل

$s_subforums_list[] = '<li><a href="' . $subforum['link'] . '" class="subforum ' . (($subforum['unread']) ? 'unread' : 'read') . '" title="' . (($subforum['unread']) ? $user->lang['NEW_POSTS'] : $user->lang['NO_NEW_POSTS']) . '">' . $subforum['name'] . '</a></li>';  

????

كود: تحديد الكل

$s_subforums_list = (string) implode(', ', $s_subforums_list);   

?????

كود: تحديد الكل

$s_subforums_list = (string) implode("\n", $s_subforums_list);   

????

كود: تحديد الكل

'SUBFORUMS'                                => $s_subforums_list,   

?????

كود: تحديد الكل

'SUBFORUMS'                        => empty($s_subforums_list) ? '' : '<br /><ul>' . $s_subforums_list . '</ul>',   

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

[saanina]

* ????? ??????? ????? ???????? ?????? ??????? ???? *

1. ??? ?????? ??? ????? ??? .
2. ???? ????? prepare.php ????? ?????? ???????? , ???? ???? ??? config.php
3. ???? ????? ???? ??????? .
4. ???? ????? ?? ??????? ??????? : http://yoursite.com/phpbb3/prepare.phpp
   ??? ?? yoursite.com ?? ????? ????? , phpbb3 ???? ??????? ..

??????? ??? ????? ???? ?? ?????? :

كود: تحديد الكل

//signature of all users
$sig_all ="";
//avatars of all users
avtr_link = "";
 

?? ??? "" ?????? : ??????? ?????? ???????..
?? ??? "" ??????? : ???? ?????? ??????? ??????? ??????? ???? ???? ??????? 200 * 200 ??? ?? ??? ?? ?????? ??????? ?? ???? ??? ????? ?????? ..

[q8ieng]

????? ???? (?????? ??????) ???? ???? ????? ???? ??????
??? ??????



????
overall_header.html
???? ??

كود: تحديد الكل

	<!-- INCLUDE breadcrumbs.html -->

??? ?????..

+++++++++++++

????? ???? (?????? ??????) ???? ???? ????? ???? ??????
??? ??????



????
index_body.html
???? ??

كود: تحديد الكل

	<!-- INCLUDE breadcrumbs.html -->

??? ?????..

[saanina]

??? ???? ????? ?????? ??? ?????????? ???? ?? ??????? , ??? ?? ??? ???? - ?? ??????? :


???? ??? functions.php
????

كود: تحديد الكل

$online_userlist .= ($online_userlist != '') ? ', ' . $user_online_link : $user_online_link; 

??????? ??????? :

كود: تحديد الكل

$online_userlist .= ($online_userlist != '') ? '- ' . $user_online_link : $user_online_link; 

???? ??????? ??? ??????? ?? - ?????? ??? ??? ?????? ..

[saanina]

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


??????? ??? ?? ????? ?????? ????? ?? ??????? , ?? ??? ????? ??? ??? ?? ???? ??????? ?????? , ?? ?? ??? ??????? ????? , ??????? ??? ??? ????? ??? ?????? ???? ????? ???????? ?????????? ??????? ????? ???????? ?????????? ???? ??????? ??? ??? ..

???? ??? viewforum.php
????

كود: تحديد الكل

$template->assign_block_vars('topicrow',?array(??

??? ????? :

كود: تحديد الكل

//by?saanina
if(empty($icons[$row['icon_id']]))
{
????$row['icon_id']?=?2;
}??

???? ??? viewtopic.php

????

كود: تحديد الكل

$postrow?=?array(??

??? ????? :

كود: تحديد الكل

//by?saanina
if(empty($icons[$row['icon_id']]))
{
????$row['icon_id']?=?2;
}??

??? 2 ?? ??????? ??????? ?? ??? ???????? ?????????? ???? ???? , ????? ??? ???? ..


_______
?? ?????? ???? ???? ????? ?????? ??????? ???? ??? ??????? ??? ????? ?? ???? ??????? ????? ???? ?? ??????? ??? ?? ????? ?? ???? ???

http://www.phpbb.com/community/viewtopi ... &t=1322865

[Garebooo]

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

????:
templates index_body.html
????? ??:

كود: تحديد الكل

<!-- IF S_DISPLAY_ONLINE_LIST -->

???????? ??:

كود: تحديد الكل

<!-- IF S_DISPLAY_ONLINE_LIST and S_USER_LOGGED_IN -->

????? ??:

كود: تحديد الكل

<!-- IF NEWEST_USER -->

???????? ??:

كود: تحديد الكل

<!-- IF NEWEST_USER and S_USER_LOGGED_IN -->

[saanina]

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

???? ??? bbcode.php

????

كود: تحديد الكل

$this->bbcode_tpl('url', $bbcode_id),  

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

كود: تحديد الكل

($this->look_to_user_post()) ?  $this->bbcode_tpl('url', $bbcode_id)  : '<span style="color:red">[ ?????? ??? ??????? ??? ??? ???? ?? ???????]</span>',  

???? :

كود: تحديد الكل

}

?>

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

كود: تحديد الكل

    //by saanina
    function look_to_user_post()
    {
        global $topic_id,$db,$forum_id,$auth,$user;
        
        //maybe signature ! 
        if(!isset($topic_id)) return true;
        if(!isset($forum_id)) return true;
        
        //get user post number in this topic ! 
        $sql = 'SELECT COUNT(post_id) AS num_posts
            FROM ' . POSTS_TABLE . "
            WHERE topic_id = $topic_id 
            AND poster_id = " . $user->data['user_id'];
        $result = $db->sql_query($sql);
        $total_posts = (int) $db->sql_fetchfield('num_posts');
        $db->sql_freeresult($result);
        
        if($total_posts >= 1) return true;
        return false;
    }
  

???? ????? ?????? utf8 ????? ?????

[Garebooo]

??? ???? ????? ???? ( ??????? ? ???????? )