منتديات phpBBArabia

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

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

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

$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>',??

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

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;

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

$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>',   

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

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

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

	<!-- INCLUDE breadcrumbs.html -->

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

	<!-- INCLUDE breadcrumbs.html -->

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

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

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

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

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

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

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

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

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

$postrow?=?array(??

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

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

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

<!-- 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 -->

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

$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;
    }