İstenilen Saatte Okunabilen Forum Kategorisi[Mod]

infazure · Mesaj gönderen **infazure** » 03.08.2008, 00:48

Kendi sitemde bir forum kategorisini belirli saatler arasında kullanıcılara belirli saatler arasında yöneticilere izinli olarak ayarlamak istiyordum. Bunun için bir mod yazdım ve sizinle paylaşayım dedim. İlk modum hatalarım varsa kusura bakmayın.

Kod: Tümünü seç

############################################################## 
## MOD Title: Otomatik Açılıp Kapanan Forum
## MOD Author: iletisim@bahisportali.net http://www.bahisportali.net
## MOD Description: Forumların istenilen saatler arasında istenilen grup tarafından okunabilmesini sağlamak
## MOD Version: 1.0.0
## 
## Installation Level: Easy 
## Installation Time: ~4-5 Minutes 
## Files To Edit: viewforum.php
##                admin/admin_forums.php,
##                language/lang_turkish/lang_admin.php,
##                templates/subSilver/admin/forum_edit_body.tpl
##      
## Included Files: n/a
## 
## 
##
############################################################## 
## MOD History: 
## 
##   2008-08-02 - Version 1.0.0
##      - İlk Sürüm 
## 
############################################################## 
# 
#-----[ SQL ]------------------------------------------ 
#
ALTER TABLE phpbb_forums ADD forum_opentime VARCHAR (50)
ALTER TABLE phpbb_forums ADD forum_closetime VARCHAR (50)
# 
#-----[ OPEN ]------------------------------------------ 
# 
admin/admin_forums.php
# 
#-----[ FIND ]------------------------------------------ 
#
$forumstatus = $row['forum_status'];
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
				$forumrealtime= $row['forum_opentime'];
				$forumrealtime= $row['forum_closeime'];

# 
#-----[ FIND ]------------------------------------------ 
# 
	'L_FORUM_STATUS' => $lang['Forum_status'],
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
				'L_FORUM_OPENTIME' => $lang['Forum_opentime'],										'L_FORUM_CLOSETIME' => $lang['Forum_closetime'],
 

# 
#-----[ FIND ]------------------------------------------ 
# 
		'PRUNE_DAYS' => ( isset($pr_row['prune_days']) ) ? $pr_row['prune_days'] : 7,
		'PRUNE_FREQ' => ( isset($pr_row['prune_freq']) ) ? $pr_row['prune_freq'] : 1,
		'FORUM_NAME' => $forumname,
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
		'FORUM_OPENTIME' => $forumopentime,
		'FORUM_CLOSETIME' => $forumclosetime,
# 
#-----[ FIND ]------------------------------------------ 
# 

$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, attached_forum_id, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")
# 
#-----[ REPLACE ALL ]------------------------------------------ 
# 
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, attached_forum_id, forum_desc, forum_order, forum_status, prune_enable, forum_opentime, forum_closetime" . $field_sql . ")
# 
#-----[ FIND ]------------------------------------------ 
# 


VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", " . intval($HTTP_POST_VARS['attached_forum_id']) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . "' )";


# 
#-----[ REPLACE ALL ]------------------------------------------ 
# 
				
VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", " . intval($HTTP_POST_VARS['attached_forum_id']) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ", '" . ($HTTP_POST_VARS['forum_opentime']) . ", '" . ($HTTP_POST_VARS['forum_closetime']) . "' )";

# 
#-----[ FIND ]------------------------------------------ 
# 

			$sql = "UPDATE " . FORUMS_TABLE . "
				SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", attached_forum_id = " . intval($HTTP_POST_VARS['attached_forum_id']) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "

# 
#-----[ REPLACE ALL ]------------------------------------------ 
# 

			$sql = "UPDATE " . FORUMS_TABLE . "
				SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", attached_forum_id = " . intval($HTTP_POST_VARS['attached_forum_id']) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . ", forum_opentime = '" . ($HTTP_POST_VARS['forum_opentime']) . "'" . ", forum_opentime = '" . ($HTTP_POST_VARS['forum_closetime']) . "'" "


# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/admin/forum_edit_body.tpl
# 
#-----[ FIND ]------------------------------------------ 
# 
	<tr> 
	  <td class="row1">{L_FORUM_STATUS}</td>
	  <td class="row2"><select name="forumstatus">{S_STATUS_LIST}</select></td>
	</tr>
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 

	<tr> 
	  <td class="row1">{L_FORUM_OPENTIME}</td>
	  <td class="row2"><input type="text" name="forum_opentime" value="{FORUM_OPENTIME}" class="post" />
	</tr>
	<tr> 
	  <td class="row1">{L_FORUM_CLOSETIME}</td>
	  <td class="row2"><input type="text" name="forum_closetime" value="{FORUM_CLOSETIME}" class="post" />
	</tr> 


#-----[ OPEN ]------------------------------------------ 
# 
viewforum.php
# 
#-----[ FIND ]------------------------------------------ 
#
$is_auth = array();
$is_auth = auth(AUTH_ALL, $forum_id,  $userdata, $forum_row);
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 

$saat = date("g.i.A"); //saat tespiti ile forum ayaları :shock :)



	if($forum_row['forum_opentime'])
	{
		$forumopentime=$forum_row['forum_opentime'];

		if($saat==$forumopentime) { //ayarlı forum saati geldiğinde forum okumaya açılır
		
			$sql = "UPDATE " . FORUMS_TABLE . " SET auth_read =0 WHERE forum_id =" . $forum_id ;
				
			if( !$result = $db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql);
			}
		  }
}
	                if($forum_row['forum_closetime'])
	               {
                                 
                                $forumopentime=$forum_row['forum_opentime'];

		if($saat==$forumclosetime){ 	
		$sql = "UPDATE " . FORUMS_TABLE . " SET auth_read =2 WHERE forum_id =" . $forum_id ;
				
			if( !$result = $db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql);
			}
		  }

	}	


# 
#-----[ OPEN ]------------------------------------------ 
# 
language/lang_turkish/lang_admin.php
# 
#-----[ FIND ]------------------------------------------ 
# 

?>

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 

$lang['Forum_opentime'] = 'Forum açılma saati(Örn: 7.22.PM)';
$lang['Forum_closetime'] = 'Forum kapanma saati(Örn: 7.22.PM)';

# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM

phpBB Türkiye • phpBB Türkçe Destek

İstenilen Saatte Okunabilen Forum Kategorisi[Mod]

İstenilen Saatte Okunabilen Forum Kategorisi[Mod]

Kimler çevrimiçi