phpBB.de

Code: Alles auswählen

<?PHP

#################################################################
## Mod Title:mycalendar Mod w/selected forum integration
## Mod Version: 2.2.7
## Author: marksten
## Author: mojavelinux <dan@mojavelinux.com>
## Description: Enables users to add events to the calendar
##              through a chosen forum.
#################################################################

#################################################################
## --> myeventlist Mod
#################################################################

#################################################################
## Mod Title: myeventlist Mod
## Mod Version: 0.0.1 
## Orginal Author: mojavelinux <dan@mojavelinux.com>
## Author: Matthias Reichert <matthias-reichert@mr-73.de>
## Description: Zeigt die Events des Aktuellen Monats
##				als Tabelle an.
#################################################################

$phpbb_root_path = './';
define('IN_PHPBB', true);
include_once $phpbb_root_path . 'extension.inc';
include_once $phpbb_root_path . 'common.'.$phpEx;
include_once $phpbb_root_path . 'includes/bbcode.'.$phpEx;

// Start session management
$userdata = session_pagestart($user_ip, PAGE_MYCALENDAR);
init_userprefs($userdata);

// determine the information for the current date
list($today['year'], $today['month'], $today['day']) = explode('-', create_date('Y-m-d', time(), $board_config['board_timezone']));

// get the month/year offset from the get variables, or else use first day of this month
if (isset($HTTP_GET_VARS['month']) && isset($HTTP_GET_VARS['year'])) {
    $view_isodate = sprintf('%04d', $HTTP_GET_VARS['year']) . '-' . sprintf('%02d', $HTTP_GET_VARS['month']) . '-01 00:00:00';
} 
// get the first day of the month as an isodate
else {
    $view_isodate = $today['year'] . '-' . $today['month'] . '-01 00:00:00';
}

// setup the current view information
$query = "SELECT
             MONTHNAME('$view_isodate') as monthName,
             DATE_FORMAT('$view_isodate', '%m') as month,
             YEAR('$view_isodate') as year,
             DATE_FORMAT(CONCAT(YEAR('$view_isodate'), '-', MONTH('$view_isodate' + INTERVAL 1 MONTH), '-01') - INTERVAL 1 DAY, '%e') as numDays,
             WEEKDAY('$view_isodate') as offset";
$result = $db->sql_query($query);
$monthView = $db->sql_fetchrow($result);
$monthView['monthName'] = $lang['datetime'][$monthView['monthName']];

// set the page title and include the page header
$page_title = " Übersicht der Termine und Veranstaltungen ";
include ($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(
    'body' => 'eventlist_body.tpl')
);

// Datensätze des Monats anzeigen

        // get the events 
    	$sql = "SELECT 
                  c.topic_id, c.cal_date, c.forum_id, 
                  MONTH(c.cal_date) as cal_month, 
                  DAYOFMONTH(c.cal_date) as cal_monthday, 
                  YEAR(c.cal_date) as cal_year, 
                  HOUR(c.cal_date) as cal_hour, 
                  MINUTE(c.cal_date) as cal_min, 
                  SECOND(c.cal_date) as cal_sec, 
                  t.topic_title 
    	        FROM 
    	          " . MYCALENDAR_TABLE . " as c,
    	          " . TOPICS_TABLE . " as t
    	        WHERE 
                  c.topic_id = t.topic_id 
                  AND (c.cal_date >= CURDATE()) 
    	        ORDER BY 
    	          c.cal_date ASC ";
	
	if(!$ergebnis = $db->sql_query($sql)) {
	message_die(GENERAL_ERROR, 'Fehler beim auslesen der Daten', '', __LINE__, __FILE__, $cat_sql);
	}

// Datensätze anzeigen


				     
// Blätterfunktion für den Kalender
if ($monthView['month'] == '12') {
    $nextmonth = 1;
    $nextyear = $monthView['year'] + 1; 
} 
else {
    $nextmonth = sprintf('%02d', $monthView['month'] + 1);
    $nextyear = $monthView['year'];
}

if ($monthView['month'] == '01') {
    $previousmonth = '12';
    $previousyear = $monthView['year'] - 1;
} 
else {
    $previousmonth = sprintf('%02d', $monthView['month'] - 1); 
    $previousyear = $monthView['year'];
}

// prepare images and links for month navigation
$image_prev_month = "<img src=\"" . $images['icon_left_arrow'] . "\" align=\"middle\" border=\"0\" title=\"{$lang['View_previous_month']}\" alt=\"" . $lang['View_previous_month'] . "\" />";
$image_next_month = "<img src=\"" . $images['icon_right_arrow'] . "\" align=\"middle\" border=\"0\" title=\"{$lang['View_next_month']}\" alt=\"" . $lang['View_next_month'] . "\" />";
$url_prev_month = append_sid('eventlist.' . $phpEx . "?month=$previousmonth&year=$previousyear");
$url_next_month = append_sid('eventlist.' . $phpEx . "?month=$nextmonth&year=$nextyear");

$image_prev_year = "<img src=\"" . $images['icon_double_left_arrow'] . "\" align=\"middle\" border=\"0\" title=\"{$lang['View_previous_year']}\" alt=\"" . $lang['View_previous_year'] . "\" />";
$image_next_year = "<img src=\"" . $images['icon_double_right_arrow'] . "\" align=\"middle\" border=\"0\" title=\"{$lang['View_next_year']}\" alt=\"" . $lang['View_next_year'] . "\" />";
$url_prev_year = append_sid('eventlist.' . $phpEx . '?month=' . $monthView['month'] . '&year=' . ($monthView['year'] - 1));
$url_next_year = append_sid('eventlist.' . $phpEx . '?month=' . $monthView['month'] . '&year=' . ($monthView['year'] + 1));


$template->assign_vars(array(
    'L_CURRENT_MONTH' => $monthView['monthName'],
    'L_CURRENT_YEAR' => $monthView['year'],
    'I_PREV_MONTH' => $image_prev_month,
    'I_NEXT_MONTH' => $image_next_month,
    'U_PREV_MONTH' => $url_prev_month,
    'U_NEXT_MONTH' => $url_next_month,
    'I_PREV_YEAR'  => $image_prev_year,
    'I_NEXT_YEAR'  => $image_next_year,
    'U_PREV_YEAR'  => $url_prev_year,
    'U_NEXT_YEAR'  => $url_next_year,
    )
);

$template->pparse('body');
 
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>

Code: Alles auswählen

<style>
div.domTT {
  background-color: {T_TD_COLOR2}; 
  padding: 3px;
  border: 1px {T_TH_COLOR1} solid;
}
div.domTTContent {
  font-size : {T_FONTSIZE3}px; 
}
</style>
<script language="Javascript" src="js/domTT.js"></script>
<table width="100%" cellspacing="2" cellpadding="2" border="0">
  <tr> 
    <td align="left" valign="middle" width="100%"> <span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a> 
      :: <a href="{U_CALENDAR}" class="nav">{L_CALENDAR}</a> :: <a href="{U_EVENTLIST}" class="nav">{L_EVENTLIST}</a></span> 
    </td>
  </tr>
</table>
<table width="100%" cellspacing="0" cellpadding="0" border="0">
  <tr> 
	<td><span class="nav">{PAGE_NUMBER}</span></td>
	<td align="right"><span class="gensmall">{S_TIMEZONE}</span><br /><span class="nav">{PAGINATION}</span></td>
  </tr>
</table></form>

<table width="100%" cellspacing="2" border="0" align="center">
  <tr> 
	<td valign="top" align="right">{JUMPBOX}</td>
  </tr>
</table>


<table class="forumline" width="100%" cellspacing="1" cellpadding="3" border="0">
  <tr>
    <td class="catHead" height="28">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td><a href="{U_PREV_YEAR}">{I_PREV_YEAR}</a><a href="{U_PREV_MONTH}">{I_PREV_MONTH}</a></td>
          <td style="text-align: center;"><span class="cattitle">{L_CURRENT_MONTH} {L_CURRENT_YEAR}</span></td>
          <td style="text-align: right;"><a href="{U_NEXT_MONTH}">{I_NEXT_MONTH}</a><a href="{U_NEXT_YEAR}">{I_NEXT_YEAR}</a></td>
        </tr>
      </table>
    </td>
  </tr>
</table>

<!-- BEGIN event_row -->
            
<!-- END event_row  -->