Bestaat er een MOD of heeft er iemand een idee van hoe je een bepaald onderwerp enkel en alleen tussen een bapaald tijdstip gesloten is.
Concreet:
Zo wil ik een nachtelijk onderwerp openen waar enkel tussen 23.00u en 07.00u op gepost kan worden, ervoor of erna zou hij opnieuw gesloten moeten worden (dit liefst automatisch natuurlijk 8) ...)
Iemand enig idee? Zou super zijn...
Kan je timer op onderwerp zetten???
Forumregels
Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
Hoi nede,
Ik heb de volgende bestanden voor je, helaas kan ik ze niet anders geven:
Ik heb de volgende bestanden voor je, helaas kan ik ze niet anders geven:
Code: Selecteer alles
########################################################
## Mod Title: Auth Time mod
## Mod Version: 0.9.8
## Author: Niels Chr. Rød Denmark < ncr@db9.dk > HTTP://mods.db9.dk
##
##
## This mod will make it posible to controll in witch date/time interval
## a user or a usergroup have rigths to
##
## be a moderator
## make announcements
## view forum
## read forum
## new topics
## sticky topics
## reply to a topic
## delete a topic
## vote in polls
## delete polls
## read topics
##
## There can at present time be as meny active time intervall for eatch item and eatch forum as you like
## in board configuration, you can choise in witch way they shall be applyed, either one rule, or all rules,
## I call it "Priority" or "Merged"
## witch means:
##
## "Priority" : in the order ( date, day of week, time or no time )
## if more than one rule is active, then the most priorized rule will apply, if both a
## rule is set to the user, and a group the user belongs to, then only the rule for the user will aplly
##
## "Merged" : all rules, will be put together, and they wil to gether grant access
##
## This is ofcouse imporent to understand, however if you don't understand how this apply completly
## then it is still safe, becouse worst case is, that the use will have less access that you think...
## A tutorial on how to make and change time based permissions is provided together with this zip (tutorial.txt)
##
## This mod is for phpBB2!! ver 2.0.00
##
## instalation rated medium
## instalation time: aprox 15-20 min
##
## Files to edit: 5
## phpBB2/include/auth.php
## phpBB2/Admin/admin_board.php
## phpBB2/language/lang_dirXX/lang_admin.php
## phpBB2/templates/template_dirXX/board_config_body.tpl
## phpBB2/templates/template_dirXX/auth_ug_body.tpl
##
## Included files: 3
## phpBB2/admin/admin_ug_auth.php
## phpBB2/templates/template_dirXX/auth_select_body2.tpl
## phpBB2/templates/template_dirXX/user_select_body2.tpl
##
##
## History:
## 0.9.0. - initial BETA
## 0.9.1. - corrected a error witch causes SQL INSERT to fail
## 0.9.2. - forgot to include the how to to the file auth_ug_body.tpl, now it is
## 0.9.3. - changed a [FIND] in auth.php file
## 0.9.4. - cosmitic changes, to all files, so the output is more "human friendly"
## 0.9.5. - now includes a quick tutorial on how to make time based rules
## 0.9.6. - fixed a typo in admin_board.php file
## 0.9.7. - speeling mistake PRIORTY, should ofcouse have been PRIORITY, now changed, also forgot to include L_TIME_PRIORITY_ALL and L_TIME_PRIORITY_ONEm in admin_board.php
## 0.9.8. - Now FINAL, lang_admin.php have been changed
##
#################################################################
## Security Disclaimer: This MOD Cannot Be Posted To Or Added At Any Non-Official phpBB Sites
#################################################################
##
## Installation Notes:
##
## There are meny changes to the file admin_ug_auth.php, therefore I have included a admin_ug_auth.php, that works as a drop in
## place this file in the dir phpBB2/admin, and it will work as a ektra module
## You will need to rename or delete the old admin_ug_auth.php - e.g. to admin_ug_auth2.php you can still use the old one, without time based rules
##
## If you are runing with other mods, then it is posible that these files will not work, then you will have
## to do the changes to admin_ug_auth.php and the 2 template files auth_select.body.tpl, and user_select_body.tpl
## how to do that is described in the manual_mods.txt file.
##
## if you later on, install other mods, in to any of these files, then you will also have to aplly the changes to these "drop-in" files
##
## The most important thing to keep in mind is, take your time, make
## sure you are finding the correct lines to modify, then take care to paste the new code.
## Please also keep in mind, if you are using more than one language file or theme at your
## site, you will need to edit the corrosponding files for each occurrence. Good Luck!
#################################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
## and the Database
#################################################################
#
#-----[ SQL ADD ]------------------------------------------
#
ALTER TABLE auth_access ADD time_begin INT (11) not null AFTER forum_id , ADD time_end INT (11) not null AFTER time_begin , ADD date_begin INT (11) not null AFTER time_end , ADD date_end INT (11) not null AFTER date_begin , ADD time_type SMALLINT (5) not null AFTER date_end , ADD note VARCHAR (60) not null AFTER time_type
#
#-----[ SQL ADD ]------------------------------------------
#
INSERT INTO config (config_name, config_value) VALUES ('auth_priority', '0')
#
#-----[ OPEN FILE ]------------------------------------------
#
# (make sure to edit this file for every language your admin uses).
phpBB2/language/lang_english/lang_admin.php
#
#-----[ FIND ]------------------------------------------
#
# AT THE BOTTOM OF THE PAGE
//
// That's all Folks!
#
#-----[ BEFORE, ADD ]------------------------------------------
#
// added to time auth mod
$lang['Time_priority'] = "Time auth rule apply as";
$lang['Time_priority_explain'] = "You can choose how time based rules apply, if more than 1 rule is active at a given time/date.<br/> if set to PRIORITY the rules are priority in this order
DATE,WEEKDAY,TIME,NOTIME if both a usergroup and a user rule exist then the user rule is selected highest - <b>one active rule apply</b><br/>
if MERGED is choosen, then all rules are put together which gives the user the most access - <b>all active rules apply</b>";
$lang['Time_priority_one'] = "Priority";
$lang['Time_priority_all'] = "Merged";
$lang['Rule_num'] = "Rule";
$lang['Start'] = "Start";
$lang['End'] = "End";
$lang['Year'] = "Year";
$lang['Month'] = "Month";
$lang['Day'] = "Day";
$lang['Hour'] = "Hour";
$lang['Min'] = "Min";
$lang['Not_specify'] = "Not Specified";
$lang['No_time'] = "No time";
$lang['By_time'] = "By time";
$lang['By_week'] = "By day of week";
$lang['By_date'] = "By date";
$lang['Time_note'] = "Note";
$lang['Time_match'] = "Type of match";
$lang['Match_all_incl'] = "Match all inclusive";
$lang['Match_all_excl'] = "Match all exclusive";
$lang['Match_spec'] = "Match specific";
$lang['Time_match_explain'] = "Select if your filled time/date, is unique, or only a part of the interval is required. e.g. you type the date interval 0101->0131 <i>(January)</i>, a specific search, will return the auth table, if exists for January month<br/><br/>
A \"match all inclusive\", will require a rule to apply in the interval, but not neassesary the complete interval, e.g. the interval above, will apply to a rule that has a interval of 5.January-> 15.January, if more matches all will be updated<br/><br/>
A \"match all exclusive\" with the same interval will return the auth for all rules that goes in January.<br/> e.g. a rule that goes from 15.January to 28.February are shown, and at the same time if there also is a rule from 30.January to 15.May, then both rules are merged and displayed. Both rules will be updated, if also submitting a change";
$lang['Time_interval'] = "Time interval";
$lang['Time_interval_explain'] = "Only apply either a date, a day of week or/and a time";
$lang['Time_select'] = "Apply time based rule(s)";
$lang['Time_type'] = "Select type of time";
$lang['Time_type_explain'] = "Select if the information is a time interval or a date interval <i>(you may still apply a time interval, if you select a date based rule)</i>";
$lang['Time_rules_list'] = "This view will update %d rule(s) individual links are provided here:<br/>";
$lang['Time_new_rule'] ="This is a new rule";
#
#-----[ SAVE FILE ]------------------------------------------
#
phpBB2/language/lang_english/lang_admin.php
#
#-----[ OPEN FILE ]------------------------------------------
#
# phpBB2/includes/constants.php
#
#-----[ FIND ]------------------------------------------
#
define('AUTH_ADMIN', 5);
#
#-----[ AFTER, ADD ]------------------------------------------
#
define('AUTH_NOTIME', 0);
define('AUTH_TIME', 1);
define('AUTH_WEEK', 2);
define('AUTH_DATE', 3);
#
#-----[ OPEN FILE ]------------------------------------------
#
includes/auth.php
#
#-----[ FIND ]------------------------------------------
#
$forum_match_sql = ( $forum_id != AUTH_LIST_ALL ) ? "AND a.forum_id = $forum_id" : '';
#
#-----[ AFTER, ADD ]------------------------------------------
#
GLOBAL $board_config;
$time_now=date('Hi',time());
$date_now=date('Ymd',time());
$week_now=date('w',time());
#
#-----[ FIND ]------------------------------------------
#
$sql = "SELECT a.forum_id, $a_sql, a.auth_mod
FROM " . AUTH_ACCESS_TABLE . " a, " . USER_GROUP_TABLE . " ug
WHERE ug.user_id = ".$userdata['user_id']. "
AND ug.user_pending = 0
AND a.group_id = ug.group_id
$forum_match_sql";
#
#-----[ REPLACE WITH ]------------------------------------------
#
$sql = "SELECT a.forum_id, $a_sql, a.auth_mod
FROM " . AUTH_ACCESS_TABLE . " a, " . USER_GROUP_TABLE . " ug, ".GROUPS_TABLE." g
WHERE ug.user_id = ".$userdata['user_id']. "
AND ug.user_pending = 0
AND a.group_id = ug.group_id
AND g.group_id = ug.group_id
AND (
(a.time_type=".AUTH_NOTIME.")
OR ((a.time_begin <= ".$time_now." AND a.time_end >= ".$time_now.") AND ((a.time_type=".AUTH_TIME.")
OR (a.date_begin <= $week_now AND a.date_end >= $week_now AND a.time_type=".AUTH_WEEK.")
OR (a.date_begin <= $date_now AND a.date_end >= $date_now AND a.time_type=".AUTH_DATE."))))
$forum_match_sql ORDER BY g.group_single_user DESC, a.time_type DESC";
#
#-----[ FIND ]------------------------------------------
#
if ( $row = $db->sql_fetchrow($result) )
{
if ( $forum_id != AUTH_LIST_ALL)
{
$u_access[] = $row;
}
else
{
do
{
$u_access[$row['forum_id']][] = $row;
}
while( $row = $db->sql_fetchrow($result) );
}
}
#
#-----[ REPLACE WITH ]------------------------------------------
#
if ($board_config['auth_priority'])
{
if ( $row = $db->sql_fetchrow($result) )
{
if ( $forum_id != AUTH_LIST_ALL)
$u_access[] = $row;
else
{
if ($time_max[$row['forum_id']]<=$row['time_type'])
{
$time_max[$row['forum_id']]=$row['time_type'];
$u_access[$row['forum_id']][] = $row;
}
}
}
}
else
{
while ( $row = $db->sql_fetchrow($result) )
{
if ( $forum_id != AUTH_LIST_ALL)
$u_access[] = $row;
else
{
do
{
if ($time_max[$row['forum_id']]<=$row['time_type'])
{
$time_max[$row['forum_id']]=$row['time_type'];
$u_access[$row['forum_id']][] = $row;
}
}
while( $row = $db->sql_fetchrow($result) );
}
}
}
#
#-----[ SAVE FILE ]------------------------------------------
#
phpBB2/includes/auth.php
#
#-----[ OPEN FILE ]------------------------------------------
#
phpBB2/admin/admin_board.php
#
#-----[ FIND ]------------------------------------------
#
$prune_no = ( !$new['prune_enable'] ) ? "checked=\"checked\"" : "";
#
#-----[ AFTER, ADD ]------------------------------------------
#
$time_priority_one = ( $new['auth_priority'] ) ? "checked=\"checked\"" : "";
$time_priority_all = ( !$new['auth_priority'] ) ? "checked=\"checked\"" : "";
#
#-----[ FIND ]------------------------------------------
#
"L_ENABLE_PRUNE" => $lang['Enable_prune'],
#
#-----[ AFTER, ADD ]------------------------------------------
#
"L_TIME_PRIORITY" => $lang['Time_priority'],
"L_TIME_PRIORITY_EXPLAIN" => $lang['Time_priority_explain'],
"L_TIME_PRIORITY_ALL" => $lang['Time_priority_all'],
"L_TIME_PRIORTY_ONE" => $lang['Time_priority_one'],
#
#-----[ FIND ]------------------------------------------
#
"PRUNE_NO" => $prune_no,
#
#-----[ AFTER, ADD ]------------------------------------------
#
"TIME_PRIORITY_ONE" => $time_priority_one,
"TIME_PRIORITY_ALL" => $time_priority_all,
#
#-----[ SAVE FILE ]------------------------------------------
#
phpBB2/admin/admin_board.php
#
#-----[ OPEN FILE ]------------------------------------------
#
# (make sure to edit this file for every theme your admin uses).
phpBB2/templates/SubSilver/admin/board_config_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<th class="thHead" colspan="2">{L_ABILITIES_SETTINGS}</th>
</tr>
#
#-----[ AFTER, ADD ]------------------------------------------
#
<tr>
<td class="row1">{L_TIME_PRIORITY}<br /><span class="gensmall">{L_TIME_PRIORITY_EXPLAIN}</span></td>
<td class="row2"><input type="radio" name="auth_priority" value="1" {TIME_PRIORITY_ONE} /> {L_TIME_PRIORITY_ONE} <input type="radio" name="auth_priority" value="0" {TIME_PRIORITY_ALL} /> {L_TIME_PRIORITY_ALL}</td>
</tr>
#
#-----[ SAVE FILE ]------------------------------------------
#
phpBB2/templates/SubSilver/admin/board_config_body.tpl
#
#-----[ OPEN FILE ]------------------------------------------
#
template/Subsilver/auth_ug_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<p>{L_AUTH_EXPLAIN}</p>
#
#-----[ AFTER, ADD ]------------------------------------------
#
<p><b>{L_RULES_TOTAL_COUNT}</b>
<!-- BEGIN rules -->
<a href="{rules.U_RULE_LINK}">{rules.L_RULE_NUM} #{rules.RULE_NUM} {rules.L_RULE_TYPE}</a> {L_TIME_INTERVAL} [ {rules.RULE_BEGIN} -> {rules.RULE_END} ] {rules.L_RULE_NOTE}: {rules.RULE_NOTE}</br>
<!-- END rules -->
</p>
#
#-----[ SAVE FILE ]------------------------------------------
#
template/Subsilver/auth_ug_body.tpl
#
#-----[ RENAME FILE ]------------------------------------------
#
phpBB2/admin/admin_ug_auth.php
to
phpBB2/admin/admin_ug_auth2.php
#
#-----[ MAKE FILE ]------------------------------------------
#
phpBB2/admin/admin_ug_auth.php
#
#-----[ MAKE FILE ]------------------------------------------
#
phpBB2/templates/SubSilver/admin/auth_select_body2.tpl
#
#-----[ MAKE FILE ]------------------------------------------
#
phpBB2/templates/SubSilver/admin/user_select_body2.tpl
... Maar ik modereer (nog) niet.
Hoi,
Deze heb je daarbij ook nodig:
Deze heb je daarbij ook nodig:
Code: Selecteer alles
########################################################
## Mod Title: Auth Time mod
## Mod Version: 0.9.4 BETA
## Author: Niels Chr. Rød Denmark < ncr@db9.dk > HTTP://mods.db9.dk
##
##
## This is a discription on what you will need to do, if the drop-in files does not work on your site, due to other mods
##
## instalation rated medium
## instalation time: aprox 10-16 min
##
## Files to edit: 3
## phpBB2/admin/admin_ug_auth.php
## phpBB2/templates/template_dirXX/auth_select_body.tpl
## phpBB2/templates/template_dirXX/user_select_body.tpl
##
## History:
## 0.9.0. - initial BETA
## 0.9.1. - corrected a error witch causes SQL INSERT to fail
## 0.9.2. - forgot to include the how to to the file auth_ug_body.tpl, now it is
## 0.9.3. - changed a [FIND] in auth.php file
## 0.9.4. - cosmitic changes, to all files, so the output is more "human friendly"
##
##
#################################################################
## Security Disclaimer: This MOD Cannot Be Posted To Or Added At Any Non-Official phpBB Sites
#################################################################
##
## Installation Notes:
##
## There are meny changes to the file admin_ug_auth.php, therefore I have included a admin_ug_auth.php, that works as a drop in
## place this file in the dir phpBB2/admin, and it will work as a ektra module
## You will need to rename or delete the old admin_ug_auth.php - to e.g. admin_ug_auth2.php you can still use the old one, without time based rules
##
## If you are runing with other mods, then it is posible that these files will not work, then you will have
## to do the changes to admin_ug_auth.php and the 2 template files auth_select.body.tpl, and user_select_body.tpl
##
## if you later on, install other mods, in to any of these files, then you will also have to aplly the changes to these "drop-in" files
##
## The most important thing to keep in mind is, take your time, make
## sure you are finding the correct lines to modify, then take care to paste the new code.
## Please also keep in mind, if you are using more than one language file or theme at your
## site, you will need to edit the corrosponding files for each occurrence. Good Luck!
#################################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
## and the Database
#################################################################
#
#-----[ OPEN FILE ]------------------------------------------
#
# NOTE: this is only needed if you can not use the drop-in files due to other mods
phpBB2/admin/admin_ug_auth.php
#
#-----[ FIND ]------------------------------------------
#
// End Functions
// -------------
#
#-----[ AFTER, ADD ]------------------------------------------
#
$time_match = ( isset($HTTP_GET_VARS['time_match']) ) ? $HTTP_GET_VARS['time_match'] : (( isset($HTTP_POST_VARS['time_match']) ) ? intval($HTTP_POST_VARS['time_match']) : '0');
$time_type = ( isset($HTTP_GET_VARS['time_type']) ) ? $HTTP_GET_VARS['time_type'] : (( isset($HTTP_POST_VARS['time_type']) ) ? intval($HTTP_POST_VARS['time_type']) : '0');
$date_begin_day = ( isset($HTTP_GET_VARS['date_begin_day']) ) ? $HTTP_GET_VARS['date_begin_day'] : (( isset($HTTP_POST_VARS['date_begin_day']) ) ? $HTTP_POST_VARS['date_begin_day'] : '0');
$date_end_day = ( isset($HTTP_GET_VARS['date_end_day']) ) ? $HTTP_GET_VARS['date_end_day'] : (( isset($HTTP_POST_VARS['date_end_day']) ) ? $HTTP_POST_VARS['date_end_day'] : '0');
$date_begin_year = ( isset($HTTP_GET_VARS['date_begin_year']) ) ? $HTTP_GET_VARS['date_begin_year'] : (( isset($HTTP_POST_VARS['date_begin_year']) ) ? $HTTP_POST_VARS['date_begin_year'] : '0');
$date_begin_month = ( isset($HTTP_GET_VARS['date_begin_month']) ) ? $HTTP_GET_VARS['date_begin_month'] : (( isset($HTTP_POST_VARS['date_begin_month']) ) ? $HTTP_POST_VARS['date_begin_month'] : '0');
$date_end_year = ( isset($HTTP_GET_VARS['date_end_year']) ) ? $HTTP_GET_VARS['date_end_year'] : (( isset($HTTP_POST_VARS['date_end_year']) ) ? $HTTP_POST_VARS['date_end_year'] : '0');
$date_end_month = ( isset($HTTP_GET_VARS['date_end_month']) ) ? $HTTP_GET_VARS['date_end_month'] : (( isset($HTTP_POST_VARS['date_end_month']) ) ? $HTTP_POST_VARS['date_end_month'] : '0');
$time_begin_hour = ( isset($HTTP_GET_VARS['time_begin_hour']) ) ? $HTTP_GET_VARS['time_begin_hour'] : (( isset($HTTP_POST_VARS['time_begin_hour']) ) ? $HTTP_POST_VARS['time_begin_hour'] : '0');
$time_begin_min = ( isset($HTTP_GET_VARS['time_begin_min']) ) ? $HTTP_GET_VARS['time_begin_min'] : (( isset($HTTP_POST_VARS['time_begin_min']) ) ? $HTTP_POST_VARS['time_begin_min'] : '0');
$time_end_hour = ( isset($HTTP_GET_VARS['time_end_hour']) ) ? $HTTP_GET_VARS['time_end_hour'] : (( isset($HTTP_POST_VARS['time_end_hour']) ) ? $HTTP_POST_VARS['time_end_hour'] : '0');
$time_end_min = ( isset($HTTP_GET_VARS['time_end_min']) ) ? $HTTP_GET_VARS['time_end_min'] : (( isset($HTTP_POST_VARS['time_end_min']) ) ? $HTTP_POST_VARS['time_end_min'] : '0');
$note = ( isset($HTTP_GET_VARS['note']) ) ? $HTTP_GET_VARS['note'] : (( isset($HTTP_POST_VARS['note']) ) ? $HTTP_POST_VARS['note'] : '');
switch ($time_type)
{
case AUTH_NOTIME: $time_begin_min='0';
$time_end_min='0';
$time_begin_hour='0';
$time_end_hour='0';
case AUTH_TIME: $date_begin_day = '0';
$date_end_day = '0';
case AUTH_WEEK : $date_begin_year = '0';
$date_begin_month = '0';
$date_end_year = '0';
$date_end_month = '0';break;
$date_begin_day = ($date_begin_day<=6) ? $date_begin_day : '0';
$date_end_day = ($date_end_day<=6) ? $date_end_day : '6';
}
$date_begin = ( isset($HTTP_GET_VARS['date_begin']) ) ? $HTTP_GET_VARS['date_begin'] : (( isset($HTTP_POST_VARS['date_begin']) ) ? $HTTP_POST_VARS['date_begin'] : $date_begin_year.$date_begin_month.$date_begin_day);
$date_end = ( isset($HTTP_GET_VARS['date_end']) ) ? $HTTP_GET_VARS['date_end'] : (( isset($HTTP_POST_VARS['date_end']) ) ? $HTTP_POST_VARS['date_end'] : $date_end_year.$date_end_month.$date_end_day);
$time_begin = ( isset($HTTP_GET_VARS['time_begin']) ) ? $HTTP_GET_VARS['time_begin'] : (( isset($HTTP_POST_VARS['time_begin']) ) ? $HTTP_POST_VARS['time_begin'] : $time_begin_hour.$time_begin_min);
$time_end = ( isset($HTTP_GET_VARS['time_end']) ) ? $HTTP_GET_VARS['time_end'] : (( isset($HTTP_POST_VARS['time_end']) ) ? $HTTP_POST_VARS['time_end'] : $time_end_hour.$time_end_min);
$sql_match1 = ($time_type)? "time_begin >= ".$time_begin." AND time_end <= ".$time_end : "date_begin >= ".$date_begin." AND date_end <= ".$date_end;
$sql_match2 = ($time_type)? "time_begin <= ".$time_begin." AND time_end >= ".$time_begin : "date_begin <= ".$date_begin." AND date_end >= ".$date_begin;
$sql_match3 = ($time_type)? "time_begin <= ".$time_end." AND time_end >= ".$time_end : "date_begin <= ".$date_end." AND date_end >= ".$date_end;
$time_match_sql =
" AND time_type=".$time_type.(($time_type)?((!$time_match)? " AND time_begin = ".$time_begin." AND time_end = ".$time_end." AND date_begin=".$date_begin." AND date_end=".$date_end :
" AND ( (".$sql_match1.(($time_match==2) ? ") OR (".$sql_match2.") OR (".$sql_match3."))":"))")):'');
#
#-----[ FIND ]------------------------------------------
#
SET auth_view = 0, auth_read = 0, auth_post = 0, auth_reply = 0, auth_edit = 0, auth_delete = 0, auth_sticky = 0, auth_announce = 0
WHERE group_id = $group_id
#
#-----[ AFTER, ADD ]------------------------------------------
#
".$time_match_sql;
#
#-----[ FIND ]------------------------------------------
#
$db->sql_freeresult($result);
$sql = ( $mode == 'user' ) ? "SELECT aa.* FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE. " g WHERE ug.user_id = $user_id AND g.group_id = ug.group_id AND aa.group_id = ug.group_id AND g.group_single_user = " . TRUE : "SELECT * FROM " . AUTH_ACCESS_TABLE . " WHERE group_id = $group_id";
#
#-----[ REPLACE WITH ]------------------------------------------
#
$db->sql_freeresult($result);
$sql = ( $mode == 'user' ) ? "SELECT aa.* FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE. " g WHERE ug.user_id = $user_id AND g.group_id = ug.group_id AND aa.group_id = ug.group_id AND g.group_single_user = " . TRUE : "SELECT * FROM " . AUTH_ACCESS_TABLE . " aa WHERE aa.group_id = $group_id";
$sql .= $time_match_sql;
#
#-----[ FIND ]------------------------------------------
#
while( $row = $db->sql_fetchrow($result) )
{
$auth_access[$row['forum_id']] = $row;
#
#-----[ AFTER, ADD ]------------------------------------------
#
$auth_access[$row['forum_id']] = $row;
$u_ug_switch = ( $mode == 'user' ) ? POST_USERS_URL . "=" . $user_id : POST_GROUPS_URL . "=" . $group_id;
$u_time_switch = "&date_begin=".$row['date_begin']."&date_end=".$row['date_end']."&time_begin=".$row['time_begin']."&time_end=".$row['time_end']."&time_type=".$row['time_type'];
switch ($row['time_type'])
{
case AUTH_NOTIME: $rule_type=$lang['No_time'];
$rule_begin = $lang['None'];
$rule_end = $lang['None'];break;
case AUTH_TIME: $rule_type=$lang['By_time'];
$rule_begin = sprintf("%04d",$row['time_begin']);
$rule_end = sprintf("%04d",$row['time_end']);break;
case AUTH_WEEK : $rule_type=$lang['By_week'];
$day_array = array('Sun','Mon','Tue','Wed','Thu','Fri','Sat');
$rule_begin = $lang['datetime'][$day_array[$row['date_begin']]].', '.sprintf("%04d",$row['time_begin']);
$rule_end = $lang['datetime'][$day_array[$row['date_end']]].', '.sprintf("%04d",$row['time_end']);break;
case AUTH_DATE: $rule_type=$lang['By_date'];
$rule_begin = $row['date_begin'].', '.sprintf("%04d",$row['time_begin']);
$rule_end = $row['date_end'].', '.sprintf("%04d",$row['time_end']);break;
default: $rule_type=$lang['Not_specify'];
}
$template->assign_block_vars('rules', array(
"L_RULE_NUM" => $lang['Rule_num'],
"L_RULE_TYPE" => $rule_type,
"L_RULE_NOTE" => $lang['Time_note'],
"RULE_BEGIN" => $rule_begin,
"RULE_END" => $rule_end,
"RULE_NUM" => $count_rules,
"RULE_NOTE" => ($row['note'])?$row['note']:$lang['None'],
"U_RULE_LINK" => append_sid("admin_ug_auth.$phpEx?mode=$mode&".$u_ug_switch.$u_time_switch)));
$count_rules++;
#
#-----[ FIND ]------------------------------------------
#
$forum_id = $forum_access[$i]['forum_id'];
#
#-----[ AFTER, ADD ]------------------------------------------
#
if (!empty($note))$forum_auth_action[$forum_id] = 'update';
#
#-----[ FIND ]------------------------------------------
#
$sql = "INSERT INTO " . AUTH_ACCESS_TABLE . " (forum_id, group_id, $sql_field)
VALUES ($forum_id, $group_id, $sql_value)";
#
#-----[ REPLACE WITH ]------------------------------------------
#
$sql = "INSERT INTO " . AUTH_ACCESS_TABLE . " (forum_id, group_id, $sql_field, date_begin,date_end,time_begin, time_end, time_type, note)
VALUES ($forum_id, $group_id, $sql_value, $date_begin, $date_end, $time_begin, $time_end, $time_type, '$note')";
#
#-----[ FIND ]------------------------------------------
#
$sql_values .= ( ( $sql_values != '' ) ? ', ' : '' ) . 'auth_mod = ' . ( ( !isset($update_mod_status[$forum_id]) ) ? 0 : $update_mod_status[$forum_id]);
#
#-----[ AFTER, ADD ]------------------------------------------
#
$sql_values .= ($note)?(( ( $sql_values != '' ) ? ', ' : '' ) . 'note="'.$note.'"'):'';
#
#-----[ FIND ]------------------------------------------
#
WHERE group_id = $group_id
AND forum_id = $forum_id";
#
#-----[ REPLACE WITH ]------------------------------------------
#
WHERE group_id = $group_id
AND forum_id = $forum_id
$time_match_sql";
#
#-----[ FIND ]------------------------------------------
#
$sql = "DELETE FROM " . AUTH_ACCESS_TABLE . "
WHERE group_id = $group_id
#
#-----[ AFTER, ADD ]------------------------------------------
#
".$time_match_sql."
#
#-----[ FIND ]------------------------------------------
#
FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u
WHERE ug.group_id = aa.group_id
#
#-----[ AFTER, ADD ]------------------------------------------
#
".$time_match_sql."
#
#-----[ FIND ]------------------------------------------
#
WHERE ug.user_id = u.user_id
AND aa.group_id = ug.group_id
#
#-----[ AFTER, ADD ]------------------------------------------
#
".$time_match_sql."
#
#-----[ FIND ]------------------------------------------
#
WHERE ug.user_id = u.user_id
AND aa.group_id = ug.group_id
#
#-----[ AFTER, ADD ]------------------------------------------
#
".$time_match_sql."
#
#-----[ FIND ]------------------------------------------
#
WHERE ug.user_id = u.user_id(+)
AND aa.group_id = ug.group_id(+)
#
#-----[ AFTER, ADD ]------------------------------------------
#
".$time_match_sql."
#
#-----[ FIND ]------------------------------------------
#
LEFT JOIN " . AUTH_ACCESS_TABLE . " aa ON aa.group_id = ug.group_id
#
#-----[ AFTER, ADD ]------------------------------------------
#
".$time_match_sql.")
#
#-----[ FIND ]------------------------------------------
#
$sql = ( $mode == 'user' ) ? "SELECT aa.*, g.group_single_user FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE. " g WHERE ug.user_id = $user_id AND g.group_id = ug.group_id AND aa.group_id = ug.group_id AND g.group_single_user = 1" : "SELECT * FROM " . AUTH_ACCESS_TABLE . " WHERE group_id = $group_id";
#
#-----[ REPLACE WITH ]------------------------------------------
#
$sql = ( $mode == 'user' ) ? "SELECT aa.*, g.group_single_user FROM " . AUTH_ACCESS_TABLE . " aa, " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE. " g WHERE ug.user_id = $user_id AND g.group_id = ug.group_id AND aa.group_id = ug.group_id AND g.group_single_user = 1" : "SELECT * FROM " . AUTH_ACCESS_TABLE . " aa WHERE aa.group_id = $group_id";
$sql .= $time_match_sql;
#
#-----[ FIND ]------------------------------------------
#
$auth_access[$row['forum_id']][] = $row;
$auth_access_count[$row['forum_id']]++;
#
#-----[ AFTER, ADD ]------------------------------------------
#
$u_ug_switch = ( $mode == 'user' ) ? POST_USERS_URL . "=" . $user_id : POST_GROUPS_URL . "=" . $group_id;
$u_time_switch = "&date_begin=".$row['date_begin']."&date_end=".$row['date_end']."&time_begin=".$row['time_begin']."&time_end=".$row['time_end']."&time_type=".$row['time_type'];
switch ($row['time_type'])
{
case AUTH_NOTIME: $rule_type=$lang['No_time'];
$rule_begin = $lang['None'];
$rule_end = $lang['None'];break;
case AUTH_TIME: $rule_type=$lang['By_time'];
$rule_begin = sprintf("%04d",$row['time_begin']);
$rule_end = sprintf("%04d",$row['time_end']);break;
case AUTH_WEEK : $rule_type=$lang['By_week'];
$day_array = array('Sun','Mon','Tue','Wed','Thu','Fri','Sat');
$rule_begin = $lang['datetime'][$day_array[$row['date_begin']]].', '.sprintf("%04d",$row['time_begin']);
$rule_end = $lang['datetime'][$day_array[$row['date_end']]].', '.sprintf("%04d",$row['time_end']);break;
case AUTH_DATE: $rule_type=$lang['By_date'];
$rule_begin = $row['date_begin'].', '.sprintf("%04d",$row['time_begin']);
$rule_end = $row['date_end'].', '.sprintf("%04d",$row['time_end']);break;
default: $rule_type=$lang['Not_specify'];
}
$template->assign_block_vars('rules', array(
"L_RULE_NUM" => $lang['Rule_num'],
"L_RULE_TYPE" => $rule_type,
"L_RULE_NOTE" => $lang['Time_note'],
"RULE_BEGIN" => $rule_begin,
"RULE_END" => $rule_end,
"RULE_NUM" => $count_rules,
"RULE_NOTE" => ($row['note'])?$row['note']:$lang['None'],
"U_RULE_LINK" => append_sid("admin_ug_auth.$phpEx?mode=$mode&".$u_ug_switch.$u_time_switch)));
$count_rules++;
#
#-----[ FIND ]------------------------------------------
#
$u_ug_switch = ( $mode == 'user' ) ? POST_USERS_URL . "=" . $user_id : POST_GROUPS_URL . "=" . $group_id;
#
#-----[ AFTER, ADD ]------------------------------------------
#
$u_time_switch="&date_begin=$date_begin&date_end=$date_end&time_begin=$time_begin&time_end=$time_end&time_type=$time_type&time_match=$time_match";
#
#-----[ FIND ]------------------------------------------
#
$switch_mode = append_sid("admin_ug_auth.$phpEx?mode=$mode&" . $u_ug_switch . "&adv=$adv_switch");
#
#-----[ REPLACE WITH ]------------------------------------------
#
$switch_mode = append_sid("admin_ug_auth.$phpEx?mode=$mode&" . $u_ug_switch . "&adv=$adv_switch".$u_time_switch);
#
#-----[ FIND ]------------------------------------------
#
$s_hidden_fields = '<input type="hidden" name="mode" value="' . $mode . '" /><input type="hidden" name="adv" value="' . $adv . '" />';
#
#-----[ REPLACE WITH ]------------------------------------------
#
$s_hidden_fields = '<input type="hidden" name="mode" value="' . $mode . '" /><input type="hidden" name="time_begin" value="' . $time_begin . '" /><input type="hidden" name="time_end" value="' . $time_end . '" /><input type="hidden" name="date_begin" value="' . $date_begin . '" /><input type="hidden" name="date_end" value="' . $date_end . '" /><input type="hidden" name="time_type" value="' . $time_type . '" /><input type="hidden" name="time_match" value="' . $time_match . '" /><input type="hidden" name="adv" value="' . $adv . '" />';
#
#-----[ FIND ]------------------------------------------
#
'L_RESET' => $lang['Reset'],
#
#-----[ AFTER, ADD ]------------------------------------------
#
'L_RULES_TOTAL_COUNT' => ($count_rules)?sprintf($lang['Time_rules_list'],$count_rules):$lang['Time_new_rule'],
'L_NOTE' => $lang['Time_note'],
'L_TIME_INTERVAL' =>$lang['Time_interval'],
#
#-----[ FIND ]------------------------------------------
#
$s_hidden_fields = '<input type="hidden" name="mode" value="' . $mode . '" />';
#
#-----[ AFTER, ADD ]------------------------------------------
#
$s_time_type='';
$s_time_match='';
$s_time_days='<option value="1">'.$lang['datetime']['Mon'].'
<option value="2">'.$lang['datetime']['Tue'].'
<option value="3">'.$lang['datetime']['Wed'].'
<option value="4">'.$lang['datetime']['Thu'].'
<option value="5">'.$lang['datetime']['Fri'].'
<option value="6">'.$lang['datetime']['Sat'].'
<option value="0">'.$lang['datetime']['Sun'];
$s_time_months_begin=' <option value="01" selected>'.$lang['datetime']['Jan'].'
<option value="02">'.$lang['datetime']['Feb'].'
<option value="03">'.$lang['datetime']['Mar'].'
<option value="04">'.$lang['datetime']['Apr'].'
<option value="05">'.$lang['datetime']['May'].'
<option value="06">'.$lang['datetime']['Jun'].'
<option value="07">'.$lang['datetime']['Jul'].'
<option value="08">'.$lang['datetime']['Aug'].'
<option value="09">'.$lang['datetime']['Sep'].'
<option value="10">'.$lang['datetime']['Oct'].'
<option value="11">'.$lang['datetime']['Nov'].'
<option value="12">'.$lang['datetime']['Dec'];
$s_time_months_end=' <option value="01">'.$lang['datetime']['Jan'].'
<option value="02">'.$lang['datetime']['Feb'].'
<option value="03">'.$lang['datetime']['Mar'].'
<option value="04">'.$lang['datetime']['Apr'].'
<option value="05">'.$lang['datetime']['May'].'
<option value="06">'.$lang['datetime']['Jun'].'
<option value="07">'.$lang['datetime']['Jul'].'
<option value="08">'.$lang['datetime']['Aug'].'
<option value="09">'.$lang['datetime']['Sep'].'
<option value="10">'.$lang['datetime']['Oct'].'
<option value="11">'.$lang['datetime']['Nov'].'
<option value="12" selected>'.$lang['datetime']['Dec'];
#
#-----[ FIND ]------------------------------------------
#
'L_LOOK_UP' => ( $mode == 'user' ) ? $lang['Look_up_User'] : $lang['Look_up_Group'],
#
#-----[ AFTER, ADD ]------------------------------------------
#
'L_START' => $lang['Start'],
'L_END' => $lang['End'],
'L_YEAR' => $lang['Year'],
'L_MONTH' => $lang['Month'],
'L_DAY' => $lang['Day'],
'L_HOURS' => $lang['Hours'],
'L_MIN' => $lang['Min'],
'L_DAYS' => $s_time_days,
'L_MONTHS_BEGIN' => $s_time_months_begin,
'L_MONTHS_END' => $s_time_months_end,
'L_TIME_SELECT' => $lang['Time_select'],
'L_TIME_TYPE' => $lang['Time_type'],
'L_TIME_TYPE_EXPLAIN' => $lang['Time_type_explain'],
'L_TIME_MATCH' => $lang['Time_match'],
'L_TIME_MATCH_EXPLAIN' => $lang['Time_match_explain'],
'L_TIME_INTERVAL' => $lang['Time_interval'] ,
'L_TIME_INTERVAL_EXPLAIN' => $lang['Time_interval_explain'],
'L_TIME_NO' => $lang['No_time'],
'L_TIME_TIME' => $lang['By_time'],
'L_TIME_WEEK' => $lang['By_week'],
'L_TIME_DATE' => $lang['By_date'],
'L_MATCH_ALL_INCL' => $lang['Match_all_incl'],
'L_MATCH_ALL_EXCL' => $lang['Match_all_excl'],
'L_MATCH_SPEC' => $lang['Match_spec'],
#
#-----[ SAVE FILE ]------------------------------------------
#
phpBB2/admin/admin_ug_auth.php
#
#-----[ OPEN FILE ]------------------------------------------
#
# NOTE: this is only needed if you can not use the drop-in files due to other mods
template/Subsilver/auth_select_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<input type="submit" value="{L_LOOK_UP}" class="mainoption" />
#
#-----[ DELETE ]------------------------------------------
#
<input type="submit" value="{L_LOOK_UP}" class="mainoption" />
#
#-----[ FIND ]------------------------------------------
#
<td class="row1" align="center" colspan="6">{S_HIDDEN_FIELDS}{S_AUTH_SELECT} </td>
</tr>
#
#-----[ AFTER, ADD ]------------------------------------------
#
<tr>
<th class="thHead" align="center" colspan="6">{L_TIME_SELECT}</th>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_INTERVAL}:</span><br/>{L_TIME_INTERVAL_EXPLAIN}
</tr>
<tr>
<td class="row1"><br/><b>{L_START}:<br/>{L_END}:</b></td>
<td class="row1">{L_YEAR}<br/><select name="date_begin_year">
<option value="2002" selected>2002
<option value="2003">2003
<option value="2004">2004
<option value="2005">2005
<option value="2006">2006
<option value="2007">2007
<option value="2008">2008
<option value="2009">2009
<option value="2010">2010
<option value="2099">2099
</select><br/>
<select name="date_end_year">
<option value="2002">2002
<option value="2003">2003
<option value="2004">2004
<option value="2005">2005
<option value="2006">2006
<option value="2007">2007
<option value="2008">2008
<option value="2009">2009
<option value="2010">2010
<option value="2099" selected>2099
</select>
</td>
<td class="row1">
{L_MONTH}<br/>
<select name="date_begin_month">{L_MONTHS_BEGIN}</select><br/>
<select name="date_end_month">{L_MONTHS_END}</select>
</td>
<td class="row1">{L_DAY}<br/>
<select name="date_begin_day">{L_DAYS}
<option value="01" selected>01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
<option value="24">24
<option value="25">25
<option value="26">26
<option value="27">27
<option value="28">28
<option value="29">29
<option value="30">30
<option value="31">31
</select><br/>
<select name="date_end_day">{L_DAYS}
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
<option value="24">24
<option value="25">25
<option value="26">26
<option value="27">27
<option value="28">28
<option value="29">29
<option value="30">30
<option value="31" selected>31
</select>
</td>
<td class="row1">Hour<br/>
<select name="time_begin_hour">
<option value="00" selected>00
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
</select><br/>
<select name="time_end_hour">
<option value="00">00
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23" selected>23
</select>
</td>
<td class="row1">min<br/>
<select name="time_begin_min">
<option value="00" selected>00
<option value="10">10
<option value="15">15
<option value="20">20
<option value="30">30
<option value="40">40
<option value="45">45
<option value="50">50
<option value="59">59
</select><br/>
<select name="time_end_min">
<option value="00">00
<option value="10">10
<option value="15">15
<option value="20">20
<option value="30">30
<option value="40">40
<option value="45">45
<option value="50">50
<option value="59" selected>59
</select>
</td>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_TYPE}:</span><br/>
<span class="gensmall">{L_TIME_TYPE_EXPLAIN}</span></td>
<tr/>
<tr>
<td class="row1" colspan="6">
<input type="radio" name="time_type" value="0" CHECKED />
<span class="gen">{L_TIME_NO}</span>
<input type="radio" name="time_type" value="1"/>
<span class="gen">{L_TIME_TIME}</span>
<input type="radio" name="time_type" value="2"/>
<span class="gen">{L_TIME_WEEK}</span>
<input type="radio" name="time_type" value="3"/>
<span class="gen">{L_TIME_DATE}</span></td>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_MATCH}:</span><br/>
<span class="gensmall">{L_TIME_MATCH_EXPLAIN}</span></td>
</tr>
<tr>
<td class="row1" colspan="6">
<input type="radio" name="time_match" value="0" CHECKED />
<span class="gen">{L_MATCH_SPEC}</span>
<input type="radio" name="time_match" value="1" />
<span class="gen">{L_MATCH_ALL_INCL}</span>
<input type="radio" name="time_match" value="2" />
<span class="gen">{L_MATCH_ALL_EXCL}</span> <input type="submit" value="{L_LOOK_UP}" class="mainoption" /></td>
</tr>
#
#-----[ SAVE FILE ]------------------------------------------
#
template/Subsilver/auth_select_body.tpl
#
#-----[ OPEN FILE ]------------------------------------------
#
# NOTE: this is only needed if you can not use the drop-in files due to other mods
template/Subsilver/user_select_body.tpl
#
#-----[ FIND ]------------------------------------------
#
<input type="submit" name="submituser" value="{L_LOOK_UP}" class="mainoption" />
#
#-----[ DELETE ]------------------------------------------
#
<input type="submit" name="submituser" value="{L_LOOK_UP}" class="mainoption" />
#
#-----[ FIND ]------------------------------------------
#
<td class="row1" align="center" colspan="2"><input type="text" class="post" name="username" maxlength="50" size="20" /> <input type="hidden" name="mode" value="edit" />{S_HIDDEN_FIELDS}<input type="submit" name="submituser" value="{L_LOOK_UP}" class="mainoption" /> <input type="submit" name="usersubmit" value="{L_FIND_USERNAME}" class="liteoption" onClick="window.open('{U_SEARCH_USER}', '_phpbbsearch', 'HEIGHT=250,resizable=yes,WIDTH=400');return false;" /></td>
</tr>
#
#-----[ AFTER, ADD ]------------------------------------------
#
<tr>
<th class="thHead" align="center" colspan="6">{L_TIME_SELECT}</th>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_INTERVAL}:</span><br/>{L_TIME_INTERVAL_EXPLAIN}
</tr>
<tr>
<td class="row1"><br/><b>{L_START}:<br/>{L_END}:</b></td>
<td class="row1">{L_YEAR}<br/><select name="date_begin_year">
<option value="2002" selected>2002
<option value="2003">2003
<option value="2004">2004
<option value="2005">2005
<option value="2006">2006
<option value="2007">2007
<option value="2008">2008
<option value="2009">2009
<option value="2010">2010
<option value="2099">2099
</select><br/>
<select name="date_end_year">
<option value="2002">2002
<option value="2003">2003
<option value="2004">2004
<option value="2005">2005
<option value="2006">2006
<option value="2007">2007
<option value="2008">2008
<option value="2009">2009
<option value="2010">2010
<option value="2099" selected>2099
</select>
</td>
<td class="row1">
{L_MONTH}<br/>
<select name="date_begin_month">{L_MONTHS_BEGIN}</select><br/>
<select name="date_end_month">{L_MONTHS_END}</select>
</td>
<td class="row1">{L_DAY}<br/>
<select name="date_begin_day">{L_DAYS}
<option value="01" selected>01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
<option value="24">24
<option value="25">25
<option value="26">26
<option value="27">27
<option value="28">28
<option value="29">29
<option value="30">30
<option value="31">31
</select><br/>
<select name="date_end_day">{L_DAYS}
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
<option value="24">24
<option value="25">25
<option value="26">26
<option value="27">27
<option value="28">28
<option value="29">29
<option value="30">30
<option value="31" selected>31
</select>
</td>
<td class="row1">Hour<br/>
<select name="time_begin_hour">
<option value="00" selected>00
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
</select><br/>
<select name="time_end_hour">
<option value="00">00
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23" selected>23
</select>
</td>
<td class="row1">min<br/>
<select name="time_begin_min">
<option value="00" selected>00
<option value="10">10
<option value="15">15
<option value="20">20
<option value="30">30
<option value="40">40
<option value="45">45
<option value="50">50
<option value="59">59
</select><br/>
<select name="time_end_min">
<option value="00">00
<option value="10">10
<option value="15">15
<option value="20">20
<option value="30">30
<option value="40">40
<option value="45">45
<option value="50">50
<option value="59" selected>59
</select>
</td>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_TYPE}:</span><br/>
<span class="gensmall">{L_TIME_TYPE_EXPLAIN}</span></td>
<tr/>
<tr>
<td class="row1" colspan="6">
<input type="radio" name="time_type" value="0" CHECKED />
<span class="gen">{L_TIME_NO}</span>
<input type="radio" name="time_type" value="1"/>
<span class="gen">{L_TIME_TIME}</span>
<input type="radio" name="time_type" value="2"/>
<span class="gen">{L_TIME_WEEK}</span>
<input type="radio" name="time_type" value="3"/>
<span class="gen">{L_TIME_DATE}</span></td>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_MATCH}:</span><br/>
<span class="gensmall">{L_TIME_MATCH_EXPLAIN}</span></td>
</tr>
<tr>
<td class="row1" colspan="6">
<input type="radio" name="time_match" value="0" CHECKED />
<span class="gen">{L_MATCH_SPEC}</span>
<input type="radio" name="time_match" value="1" />
<span class="gen">{L_MATCH_ALL_INCL}</span>
<input type="radio" name="time_match" value="2" />
<span class="gen">{L_MATCH_ALL_EXCL}</span> <input type="submit" value="{L_LOOK_UP}" class="mainoption" /></td>
</tr>
#
#-----[ SAVE FILE ]------------------------------------------
#
template/Subsilver/user_select_body.tpl... Maar ik modereer (nog) niet.
Hoi,
auth_select_body2.tpl
user_select_body2.tpl
auth_select_body2.tpl
Code: Selecteer alles
<h1>{L_AUTH_TITLE}</h1>
<p>{L_AUTH_EXPLAIN}</p>
<form method="post" action="{S_AUTH_ACTION}"><table cellspacing="1" cellpadding="4" border="0" align="center" class="forumline">
<tr>
<th class="thHead" align="center" colspan="6">{L_AUTH_SELECT}</th>
</tr>
<tr>
<td class="row1" align="center" colspan="6">{S_HIDDEN_FIELDS}{S_AUTH_SELECT} </td>
</tr>
<tr>
<th class="thHead" align="center" colspan="6">{L_TIME_SELECT}</th>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_INTERVAL}:</span><br/>{L_TIME_INTERVAL_EXPLAIN}
</tr>
<tr>
<td class="row1"><br/><b>{L_START}:<br/>{L_END}:</b></td>
<td class="row1">{L_YEAR}<br/><select name="date_begin_year">
<option value="2002" selected>2002
<option value="2003">2003
<option value="2004">2004
<option value="2005">2005
<option value="2006">2006
<option value="2007">2007
<option value="2008">2008
<option value="2009">2009
<option value="2010">2010
<option value="2099">2099
</select><br/>
<select name="date_end_year">
<option value="2002">2002
<option value="2003">2003
<option value="2004">2004
<option value="2005">2005
<option value="2006">2006
<option value="2007">2007
<option value="2008">2008
<option value="2009">2009
<option value="2010">2010
<option value="2099" selected>2099
</select>
</td>
<td class="row1">
{L_MONTH}<br/>
<select name="date_begin_month">{L_MONTHS_BEGIN}</select><br/>
<select name="date_end_month">{L_MONTHS_END}</select>
</td>
<td class="row1">{L_DAY}<br/>
<select name="date_begin_day">{L_DAYS}
<option value="01" selected>01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
<option value="24">24
<option value="25">25
<option value="26">26
<option value="27">27
<option value="28">28
<option value="29">29
<option value="30">30
<option value="31">31
</select><br/>
<select name="date_end_day">{L_DAYS}
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
<option value="24">24
<option value="25">25
<option value="26">26
<option value="27">27
<option value="28">28
<option value="29">29
<option value="30">30
<option value="31" selected>31
</select>
</td>
<td class="row1">Hour<br/>
<select name="time_begin_hour">
<option value="00" selected>00
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
</select><br/>
<select name="time_end_hour">
<option value="00">00
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23" selected>23
</select>
</td>
<td class="row1">min<br/>
<select name="time_begin_min">
<option value="00" selected>00
<option value="10">10
<option value="15">15
<option value="20">20
<option value="30">30
<option value="40">40
<option value="45">45
<option value="50">50
<option value="59">59
</select><br/>
<select name="time_end_min">
<option value="00">00
<option value="10">10
<option value="15">15
<option value="20">20
<option value="30">30
<option value="40">40
<option value="45">45
<option value="50">50
<option value="59" selected>59
</select>
</td>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_TYPE}:</span><br/>
<span class="gensmall">{L_TIME_TYPE_EXPLAIN}</span></td>
<tr/>
<tr>
<td class="row1" colspan="6">
<input type="radio" name="time_type" value="0" CHECKED />
<span class="gen">{L_TIME_NO}</span>
<input type="radio" name="time_type" value="1"/>
<span class="gen">{L_TIME_TIME}</span>
<input type="radio" name="time_type" value="2"/>
<span class="gen">{L_TIME_WEEK}</span>
<input type="radio" name="time_type" value="3"/>
<span class="gen">{L_TIME_DATE}</span></td>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_MATCH}:</span><br/>
<span class="gensmall">{L_TIME_MATCH_EXPLAIN}</span></td>
</tr>
<tr>
<td class="row1" colspan="6">
<input type="radio" name="time_match" value="0" CHECKED />
<span class="gen">{L_MATCH_SPEC}</span>
<input type="radio" name="time_match" value="1" />
<span class="gen">{L_MATCH_ALL_INCL}</span>
<input type="radio" name="time_match" value="2" />
<span class="gen">{L_MATCH_ALL_EXCL}</span> <input type="submit" value="{L_LOOK_UP}" class="mainoption" /></td>
</tr>
</table></form>Code: Selecteer alles
<h1>{L_USER_TITLE}</h1>
<p>{L_USER_EXPLAIN}</p>
<form method="post" name="post" action="{S_USER_ACTION}"><table cellspacing="1" cellpadding="4" border="0" align="center" class="forumline">
<tr>
<th class="thHead" align="center" colspan="6">{L_USER_SELECT}</th>
</tr>
<tr>
<td class="row1" align="center" colspan="6"><input type="text" class="post" name="username" maxlength="50" size="20" /> <input type="hidden" name="mode" value="edit" />{S_HIDDEN_FIELDS} <input type="submit" name="usersubmit" value="{L_FIND_USERNAME}" class="liteoption" onClick="window.open('{U_SEARCH_USER}', '_phpbbsearch', 'HEIGHT=250,resizable=yes,WIDTH=400');return false;" /></td>
</tr>
<tr>
<th class="thHead" align="center" colspan="6">{L_TIME_SELECT}</th>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_INTERVAL}:</span><br/>{L_TIME_INTERVAL_EXPLAIN}
</tr>
<tr>
<td class="row1"><br/><b>{L_START}:<br/>{L_END}:</b></td>
<td class="row1">{L_YEAR}<br/><select name="date_begin_year">
<option value="2002" selected>2002
<option value="2003">2003
<option value="2004">2004
<option value="2005">2005
<option value="2006">2006
<option value="2007">2007
<option value="2008">2008
<option value="2009">2009
<option value="2010">2010
<option value="2099">2099
</select><br/>
<select name="date_end_year">
<option value="2002">2002
<option value="2003">2003
<option value="2004">2004
<option value="2005">2005
<option value="2006">2006
<option value="2007">2007
<option value="2008">2008
<option value="2009">2009
<option value="2010">2010
<option value="2099" selected>2099
</select>
</td>
<td class="row1">
{L_MONTH}<br/>
<select name="date_begin_month">{L_MONTHS_BEGIN}</select><br/>
<select name="date_end_month">{L_MONTHS_END}</select>
</td>
<td class="row1">{L_DAY}<br/>
<select name="date_begin_day">{L_DAYS}
<option value="01" selected>01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
<option value="24">24
<option value="25">25
<option value="26">26
<option value="27">27
<option value="28">28
<option value="29">29
<option value="30">30
<option value="31">31
</select><br/>
<select name="date_end_day">{L_DAYS}
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
<option value="24">24
<option value="25">25
<option value="26">26
<option value="27">27
<option value="28">28
<option value="29">29
<option value="30">30
<option value="31" selected>31
</select>
</td>
<td class="row1">Hour<br/>
<select name="time_begin_hour">
<option value="00" selected>00
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23">23
</select><br/>
<select name="time_end_hour">
<option value="00">00
<option value="01">01
<option value="02">02
<option value="03">03
<option value="04">04
<option value="05">05
<option value="06">06
<option value="07">07
<option value="08">08
<option value="09">09
<option value="10">10
<option value="11">11
<option value="12">12
<option value="13">13
<option value="14">14
<option value="15">15
<option value="16">16
<option value="17">17
<option value="18">18
<option value="19">19
<option value="20">20
<option value="21">21
<option value="22">22
<option value="23" selected>23
</select>
</td>
<td class="row1">min<br/>
<select name="time_begin_min">
<option value="00" selected>00
<option value="10">10
<option value="15">15
<option value="20">20
<option value="30">30
<option value="40">40
<option value="45">45
<option value="50">50
<option value="59">59
</select><br/>
<select name="time_end_min">
<option value="00">00
<option value="10">10
<option value="15">15
<option value="20">20
<option value="30">30
<option value="40">40
<option value="45">45
<option value="50">50
<option value="59" selected>59
</select>
</td>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_TYPE}:</span><br/>
<span class="gensmall">{L_TIME_TYPE_EXPLAIN}</span></td>
<tr/>
<tr>
<td class="row1" colspan="6">
<input type="radio" name="time_type" value="0" CHECKED />
<span class="gen">{L_TIME_NO}</span>
<input type="radio" name="time_type" value="1"/>
<span class="gen">{L_TIME_TIME}</span>
<input type="radio" name="time_type" value="2"/>
<span class="gen">{L_TIME_WEEK}</span>
<input type="radio" name="time_type" value="3"/>
<span class="gen">{L_TIME_DATE}</span></td>
</tr>
<tr>
<td class="row2" colspan="6"><span class="gen">{L_TIME_MATCH}:</span><br/>
<span class="gensmall">{L_TIME_MATCH_EXPLAIN}</span></td>
</tr>
<tr>
<td class="row1" colspan="6">
<input type="radio" name="time_match" value="0" CHECKED />
<span class="gen">{L_MATCH_SPEC}</span>
<input type="radio" name="time_match" value="1" />
<span class="gen">{L_MATCH_ALL_INCL}</span>
<input type="radio" name="time_match" value="2" />
<span class="gen">{L_MATCH_ALL_EXCL}</span> <input type="submit" value="{L_LOOK_UP}" class="mainoption" /></td>
</tr>
</table></form>
Laatst gewijzigd door Bee op 02 feb 2006, 23:01, 1 keer totaal gewijzigd.
... Maar ik modereer (nog) niet.
Hoi,
En tot slot de Tutorial:
En tot slot de Tutorial:
Code: Selecteer alles
TIME AUTH MOD TUTORIAL,
by "Niels Chr. Denmark"
email ncr@db9.dk
test site HTTP://mods.db9.dk
This dokument will describe how-to make time based permissions (rules)
As phpBB2 is now, you can define witch permissions the user or a user group will have in a specific forum
After this mod is done, you can define in witch time interval these "rules" or permissions shall apply, the mod
provide a admin interface, from with-in you can search for a specific time interval, if there is no existing rule
the mod will make a new, otherwise it will show the old one.
the way you apply these is by making a forum "PRIVATE", this can be done from ADMIN PANEL -> FORUM PERMISSION -> change those settings you like to be PRIVATE
privet means that the entry can be controlled by induvidually settings or by usergroup settings.
who to make induvidually permissions is the same for both users and user groups, therefore only usergroups will be given as exsamples in the tutorial
, note that you can also after this mod, deside if all active rules shall apply or the top priorized rule only, more about that later
in this tutorial I also asume that a PRIVAT forum named TEST_FORUM is made, and a user group TEST_GROUP exisit.
MAKE A NEW TIME BASED RULE
in ADMIN PANEL -> PERMISSIONS+
select the group TEST_GROUP
select time interval e.g. from 1000 am to 0600 pm, time start: 1000 time end: 1800
select "By Time"
select "Match Specific" (search always specific when making a new time based rule)
this will return a page where you can fill with the desired permission for the TEST_FORUM
witch shall apply for the given time interval. You can also in the button specify a personal NOTE.
When all set, press submit - the rule now apply to the TEST_FORUM
MAKE A TIME BASED RULE MORE
in ADMIN PANEL -> PERMISSIONS+
select the group TEST_GROUP
select time interval e.g. from 1200 am to 1400 pm, time start: 1200 time end: 1400
select "By Time"
select "Match Specific" (search always specific when making a new time based rule)
this will return a page where you can fill with the desired permission for the TEST_FORUM
witch shall apply for the given time interval. You can also in the button specify a personal NOTE.
When all set, press submit - the rule now apply to the TEST_FORUM
SHOW WITCH RULES APPLY IN TIME INTERVAL
in ADMIN PANEL -> PERMISSIONS+
select the group TEST_GROUP
select time interval e.g. from 0800 am to 2000 pm, time start: 0800 time end: 2000
select "By Time"
select "Match Specific" or select "Match Inclusive" or Match Exclusive"
the main different between the search match options is:
"Match Specific" will tell you if a rule already esist fr the given interval, if no rule exisit the script will asume a new rule is to be made
"Match Inclusive", this informs the scrip that you wish to se all ruls witch starts after 0800 and ends before 2000 pm
"Match Exclusive" informs the script to find any rules that starts and/or ends inside the interval
UPDATE MULTIPLY RULES
in ADMIN PANEL -> PERMISSIONS+
select the group TEST_GROUP
select time interval e.g. from 0800 am to 2000 pm, time start: 0800 time end: 2000
select "By Time"
select "Match Inclusive" or Match Exclusive"
this will return a list of allredy applyed rules, if more than one rule exisit in the interval, then all rules
are displayed in the list, and all rules will be updated with the same permissions settings
UPDATE SPECIFIC RULE
in ADMIN PANEL -> PERMISSIONS+
select the group TEST_GROUP
select time interval e.g. from 0800 am to 2000 pm, time start: 0800 time end: 2000
select "By Time"
select "Match Specific" or select "Match Inclusive" or Match Exclusive"
if the time interval is known then choise "Match Specific", if the time interval is not know, then coise either
"Match Inclusive" or "Match Exclusive", depending on how mutch you now about the time interval you wish to find
if in doubt then choise "Match Exclusive" from 0000 to 2359, witch will return all time based rules for the selected user group
You will get a list of all rules exisiting (if any), find the rule you wish to update, and press the link
this will return a list witch only holds this single rule, now you can do the changes, and submit.
DELETE A RULE
as usual find the rule and change to "disallow" or all "off"
CHANGE HOW RULES APPLY
You can after this mod deside in two ways how permissions are to be applyed, it will sometimes happen that more than one rule
are active at a given time, therefore I have provided a option in ADMIN PANEL -> BORAD CONFIG, where you can choise if
"TIME AUTH RULE APPLY AS" shall be "PRIORITY" or "MERGED" if "PRIORITY" is choisen then ONLY the most prioritized rule will apply
rules are prioritized in this order
DATE,WEEKDAY,TIME,NOTIME if both a user and a usergroup rule is active at the time, then the users rule are prioritized
if "MERGED" is selected then all active rules are put together, giving the user the access of the sum of all the active rules, this is the recormented setting.
... Maar ik modereer (nog) niet.
