phpBB Sverige

Kod: Markera allt

##############################################################
## MOD Title:		Events from callite on ezPortal
## MOD Author: OXPUS < webmaster@oxpus.de > (Karsten Ude) http://www.oxpus.de
## MOD Description:	This Mod displays an eventlist for future events on ezPortal.
##			On ACP the admininstrator can set how many events will be displayed
##			on the next X days or by number.
## MOD Version:		1.1.0
##
## Installation Level:	Intermediate
## Installation Time:	5 Minutes
## Files To Edit:	8
##			portal.php
##			admin/admin_calendar.php
##			language/lang_english/lang_calendar.php
##			language/lang_english/lang_main.php
##			language/lang_german/lang_calendar.php
##			language/lang_german/lang_main.php
##			templates/subSilver/portal.body.tpl
##			templates/subSilver/admin/calendar.config.body.tpl
##
## Included Files:	n/a
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/
##############################################################
## Author Notes:
##
## Instead entering the given SQL-Statement, you can upload the file db_update.php
## to your phpbb root directory and run this with your browser.
## This file will do all nessassary changes in the database for you.
## After using this file, please delete it to avoid errors.
##
##############################################################
## MOD History:
##
##   2004-02-23 - Version 1.1.0
##      - Add switch to display events based for a time span or number of events
##
##   2004-02-08 - Version 1.0.4
##      - Fix a typo in the HowTo
##
##   2004-01-25 - Version 1.0.3
##      - Passed through phpBB.com Mod Validator
##
##   2003-12-30 - Version 1.0.2
##      - Rewritten the HowTo
##
##   2003-10-15 - Version 1.0.1
##      - Fix some bugs
##
##   ????-??-?? - Version 1.0.0
##      - First release
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ SQL ]------------------------------------------
#
INSERT INTO phpbb_cal_config (config_name, config_value) VALUES ('number_events', '10');
INSERT INTO phpbb_cal_config (config_name, config_value) VALUES ('day_number', '1');

#
#-----[ OPEN ]------------------------------------------
#
admin/admin_calendar.php

#
#-----[ FIND ]------------------------------------------
#
	"L_DATE_FORMAT_EXPLAIN" => $lang['cal_date_explain'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
	"L_NUMBER_EVENTS" => $lang['number_events'],
	"L_DAYS_NUMBERS" => $lang['days_numbers'],
	"L_DAYS_NUMBERS_EXPLAIN" => $lang['days_numbers_explain'],
	"L_TIMESPAN" => $lang['events_span'],
	"L_NUMBERS" => $lang['events_numbers'],

#
#-----[ FIND ]------------------------------------------
#
	"S_ALLOW_OLD_NO" => $allow_old_no,

#
#-----[ AFTER, ADD ]------------------------------------------
#
	"S_NUMBER_EVENTS" => $new['number_events'],
	"S_DAYS_NUMBERS_YES" => ( $new['day_number'] ) ? 'checked="checked"' : '',
	"S_DAYS_NUMBERS_NO" => ( !$new['day_number'] ) ? 'checked="checked"' : '',

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/admin/calendar_config_body.tpl

#
#-----[ FIND ]------------------------------------------
#
    <tr> 
      <td class="row1">{L_DATE_FORMAT}<br /> <span class="gensmall">{L_DATE_FORMAT_EXPLAIN}</span></td>
      <td class="row2"><input type="text" name="cal_dateformat" value="{CAL_DATEFORMAT}" /></td>
    </tr>

#
#-----[ AFTER, ADD ]------------------------------------------
#
    <tr> 
      <td class="row1">{L_DAYS_NUMBERS}<br /> <span class="gensmall">{L_DAYS_NUMBERS_EXPLAIN}</span></td>
      <td class="row2"><input type="radio" name="day_number" value="1" {S_DAYS_NUMBERS_YES} />{L_TIMESPAN}
      <input type="radio" name="day_number" value="0" {S_DAYS_NUMBERS_NO} />{L_NUMBERS}</td>
    </tr>
    <tr> 
      <td class="row1">{L_NUMBER_EVENTS}</td>
      <td class="row2"><input type="text" maxlength="5" size="5" name="number_events" value="{S_NUMBER_EVENTS}" /></td>
    </tr>

#
#-----[ OPEN ]------------------------------------------
#
portal.php

#
#-----[ FIND ]------------------------------------------
#
include($phpbb_root_path . 'fetchposts.'.$phpEx);

#
#-----[ AFTER, ADD ]------------------------------------------
#
$cal_config = array();

$sql = "SELECT * FROM ".$table_prefix."cal_config";
if(!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, "Couldn't query calendar config table", "", __LINE__, __FILE__, $sql);
}
else
{
	while( $row = $db->sql_fetchrow($result) )
	{
		$cal_config[$row['config_name']] = $row['config_value'];
	}
}

#
#-----[ FIND ]------------------------------------------
#
//
// Recent Topics
//

#
# ----- BEFOR ADD ------------------------------------------------------
#
//
// Events
//
if ($cal_config['number_events'] <> 0)
{
	$day = create_date("j", time(), $userdata['user_timezone']);
	$month = create_date("m", time(), $userdata['user_timezone']);
	$year = create_date("Y", time(), $userdata['user_timezone']);

	if ($cal_config['day_number'] == 0)
	{
		$sql_limit = ' LIMIT 0, ' . $cal_config['number_events'];
		$event_span_date = '';
		$sql_span = '';
	}
	else
	{
		$sql_limit = '';
		$event_span_date = strtotime("$year-$month-$day 23:59:59 + $cal_days days"); 
		$event_span_date = create_date("Y", $event_span_date, $userdata['user_timezone']).'-'.create_date("m", $event_span_date, $userdata['user_timezone']).'-'.create_date("j", $event_span_date, $userdata['user_timezone']).' 23:59:59'; 
		$sql_span = " AND stamp <= '$event_span_date'";
	}

	$sql = "SELECT * FROM ".$table_prefix."calendar WHERE valid = 'yes'
			AND stamp >= '$year-$month-$day 00:00:00'
			$sql_span
			ORDER BY stamp" . $sql_limit;

	$check = 0;
	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not select Event data', '', __LINE__, __FILE__, $sql);
	}
	else
	{
		while ($row = $db->sql_fetchrow($result))
		{
			$check++;
			$subject = stripslashes($row['subject']);
			if ( strlen($subject) > $cal_config['subject_length']) {
				if ((substr($subject,-3,1) == '(') && (substr($subject,-1,1) == ')')) {
					// store the number of permits and tack them on the end of the shortened subject
					$subjectnum = substr($subject,-2,1);
					$subject = substr($subject, 0, -3);
				}
				$subject = substr($subject, 0, $cal_config['subject_length']);
				$subject .= '..';
			}
			$start_date = substr($row['stamp'],8,2).".".substr($row['stamp'],5,2).".".substr($row['stamp'],0,4);
			$end_date = substr($row['eventspan'],8,2).".".substr($row['eventspan'],5,2).".".substr($row['eventspan'],0,4);

			if ( $start_date == $end_date )
			{
				$span = $start_date;
			}
			else
			{
				$span = $start_date . " - " . $end_date;
			}
			$subject = ( $userdata['session_logged_in'] ) ? '<a href="'. $phpbb_root_path .'calendar.'.$phpEx.'?id='. $row['id'] .'&mode=display&day='. substr($row['stamp'],8,2). '&month='.substr($row['stamp'],5,2).'&year='.substr($row['stamp'],0,4).'">'. $subject .'</a>' : $subject;
			$author = ( $userdata['session_logged_in'] ) ? '<a href="'. $phpbb_root_path .'profile.'.$phpEx.'?mode=viewprofile&'. POST_USERS_URL .'='. $row['user_id'] .'">('. stripslashes($row['username']) .')</a>' : '('. stripslashes($row['username']) .')';
			$template->assign_block_vars('event', array(
				'SUBJECT' => $subject,
				'SPAN' => $span,
				'AUTHOR' => $author));
		}
		if ( $check == 0 )
		{
		   $template->assign_block_vars('event', array(
			'SUBJECT' => $lang["No_events"]));
		}
	}
}

# ------------------
# If you have not installed the eventlists add now:
if ($cal_config['number_events'] <> 0)
{
	$template->assign_block_vars('event_list', array(
	 'EVENTS' => $lang["Events"]));
}

# ------------------
# If you have installed the eventlists you may add now:
if ($cal_config['number_events'] <> 0 && $cal_config['view_new_events'] == 1)
{
	$template->assign_block_vars('event_list', array(
	'EVENTS' => '<a href="'. $phpbb_root_path .'calendar.'.$phpEx.'?mode=View_New">'. $lang["Events"] .'</a>'));
}
else
{
	$template->assign_block_vars('event_list', array(
	'EVENTS' => $lang['Events']));
}

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/portal_body.tpl

#
#-----[ FIND ]------------------------------------------
#
			<td class="row4" height="25" align="center"><span class="gen" align="center"><b>{L_NAME_WELCOME},&nbsp;{U_NAME_LINK}</b></span><br /><span class="gensmall">{WELCOME_TEXT}</span></td>
		  </tr>
		<!-- END welcome_text -->
		</table>

#
#-----[ AFTER, ADD ]------------------------------------------
#
		  <table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
		  <!-- BEGIN event_list -->
		   <tr>
			<td class="catHead" height="25"><span class="genmed"><b>{event_list.EVENTS}</b></span></td>
		   </tr>
		  <!-- END event_list -->
		  <!-- BEGIN event -->
		   <tr>
			<td class="row1" align="left"><span class="gensmall">{event.SPAN} {event.AUTHOR}<br /><b>{event.SUBJECT}</b></span></td>
		   </tr>
		  <!-- END event -->
		  </table>

		  <!-- BEGIN event_list -->
		  <br />
		  <!-- END event_list -->
		
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_calendar.php

#
#-----[ FIND ]------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#
$lang['number_events'] = 'Number of events or days. Enter 0 to disable this function.';
$lang['days_numbers'] = 'Display the next X events or all events the next X Days';
$lang['days_numbers_explain'] = 'If you say days, the following number will set all events the next X days from now on the ezPortal. For numbers, on ezPortal the next X numbers of events will be displayed.';
$lang['events_span'] = 'Days';
$lang['events_numbers'] = 'Numbers';

#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_calendar.php

#
#-----[ FIND ]------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#
$lang['number_events'] = 'Anzahl der Termine oder Tage auf dem ezPortal. Gib 0 ein, um diese Funktion abzuschalten.';
$lang['days_numbers'] = 'Zeige die Events der nächsten X Tage oder die nächsten X Events';
$lang['days_numbers_explain'] = 'Wenn Du Tage einstellst, werden alle Events innerhalb jetzt und der nächsten X Tage auf dem ezPortal angezeigt. Bei Anzahl werden auf dem ezPortal die nächsten gesetzten X Termine auf dem ezPortal angezeigt.';
$lang['events_span'] = 'Tage';
$lang['events_numbers'] = 'Anzahl';

#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#
$lang['Events'] = 'Upcoming events';
$lang['No_events'] = 'None events yet.';

#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#
$lang['Events'] = 'Anstehende Termine';
$lang['No_events'] = 'Keine anstehenden Termine';


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