phpBB Calendar block on Board3 Portal (Update 1.0.4)

[jerkstore]

I was wondering how to show the current date in a different color than the other days like the original mini_cal. Right now, all the days in the month are the same color. Also, when there is an upcoming event, it does bold the date but is very hard to see. I would maybe want to make days with an event a different color as well.

Take a look at my portal calendar.

http://www.untamedgaming.com

EDIT #2: my site is back up so please take a look at the portal calendar block if you get a chance.

[Sandrock]

I installed this mod and am getting a SQL error - I'm in need of help. I have phpBB 3.0.5, Board3 Portal 1.0.3, phpBB Calendar 0.1.0, PHP 5.1.6, MySQL 5.0.18. I receive this error when I try to go to my portal page at /phpbb3/portal.php

Code: Select all

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'%,10,%\' OR group_id = 15 OR group_id_list LIKE \'%,15,%\' OR group_id = 14 OR' at line 4 [1064]

SQL

SELECT * FROM phpbb3_calendar_events WHERE ( (event_access_level = 2) OR (event_access_level = 0 AND poster_id = 2 ) OR (event_access_level = 1 AND (group_id = 10 OR group_id_list LIKE \'%,10,%\' OR group_id = 15 OR group_id_list LIKE \'%,15,%\' OR group_id = 14 OR group_id_list LIKE \'%,14,%\' OR group_id = 12 OR group_id_list LIKE \'%,12,%\') ) ) AND ((( event_start_time >= 1248739200 AND event_start_time <= 1251417600 ) OR ( event_end_time > 1248739200 AND event_end_time <= 1251417600 ) OR ( event_start_time < 1248739200 AND event_end_time > 1251417600 )) OR (sort_timestamp > 1248652801 AND event_all_day = 1) ) ORDER BY sort_timestamp ASC LIMIT 5

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()

FILE: includes/functions_calendar.php
LINE: 409
CALL: dbal->sql_query_limit()

FILE: portal/block/calendar.php
LINE: 20
CALL: calendar_display_mini_month()

FILE: portal.php
LINE: 251
CALL: include('portal/block/calendar.php')

Any help would be appreciated, this looks like a great mod.

[wang5555]

Update v1.0.3,
See first post.

--
@Sandrock:
Please try the latest mod, thanks!

[Sandrock]

That did the trick, thank you so much!

One question though: in the phpBB Calendar, you can create different event types. Is there a way I could filter which events show up on my board3 calendar block, such that only events of a certain event type will show up? Thanks!

[wang5555]

That did the trick, thank you so much!

One question though: in the phpBB Calendar, you can create different event types. Is there a way I could filter which events show up on my board3 calendar block, such that only events of a certain event type will show up? Thanks!

The events show up "ORDER BY sort_timestamp ASC",
and you can set "Who can see this event?" when you create event.

[hegse]

Hello,

after updating the calender block, I just have the event calendar and no more mini calendar. So my question is, if the mini calendar isn't supported any longer?

[wang5555]

Hello,

after updating the calender block, I just have the event calendar and no more mini calendar. So my question is, if the mini calendar isn't supported any longer?

Yes, because I think it is useless.

[jerkstore]

I suggest that if you want to have a mini calendar, to use the one provided by Board3 Portal. I took the code from calendar.html and pasted it in the mini_calendar.html so the events appear under the mini calendar.

[hegse]

Yes, because I think it is useless.

Ok.

I suggest that if you want to have a mini calendar, to use the one provided by Board3 Portal. I took the code from calendar.html and pasted it in the mini_calendar.html so the events appear under the mini calendar.

What a pity. Because if you click on a day in the board3 calendar you only see the new posted topics.
At the moment you can see the events in the mini cal directly. (The day in fat) Link to my Portal
And you can add new events by clicking on a day in the mini cal...

[Lara]

I have the same problem than hegse and I would also appreciate to have the calendar back.

[hegse]

So, i did that update...
The board3 mini cal is not so nice as the old mini cal but for the first it works...

[Lara]

How did you make it that the mini-calendar and the calendar block are in one block? On my forum there are two separated boxes.

[hegse]

Copy and Paste

This is my Code in the styles/prosilver/template/portal/block/mini_calendar.html

Code: Select all

<!--version $Id: mini_calendar.html 481 2009-03-15 23:16:32Z Christian_N $ //-->
{$LR_BLOCK_H_L}<img src="{T_THEME_PATH}/images/portal/portal_minical.png" width="16px" height="16px" alt=""/>&nbsp;{L_MINI_CAL_CALENDAR}{$LR_BLOCK_H_R}	
	<table width="100%" cellspacing="1">
		<tr>
			<td align="left" colspan="2">{U_PREV_MONTH}</td>
			<td colspan="3" align="center"><span class="genmed">{L_MINI_CAL_MONTH}</span></td>
			<td align="right" colspan="2">{U_NEXT_MONTH}</td>
		</tr>
		<tr>
			<td style="width: 14%;"><span class="gensmall" style="color:#0000FF">{L_MINI_CAL_SUN}</span></td>
			<td style="width: 14%;"><span class="gensmall" style="color:#0000FF">{L_MINI_CAL_MON}</span></td>
			<td style="width: 14%;"><span class="gensmall" style="color:#0000FF">{L_MINI_CAL_TUE}</span></td>
			<td style="width: 14%;"><span class="gensmall" style="color:#0000FF">{L_MINI_CAL_WED}</span></td>
			<td style="width: 14%;"><span class="gensmall" style="color:#0000FF">{L_MINI_CAL_THU}</span></td>
			<td style="width: 14%;"><span class="gensmall">{L_MINI_CAL_FRI}</span></td>
			<td style="width: 14%;"><span class="gensmall" style="color:#FF0000">{L_MINI_CAL_SAT}</span></td>
		</tr>
		<!-- BEGIN mini_cal_row -->
		<tr>
			<!-- BEGIN mini_cal_days -->
				<td class="row1" align="center"><span class="gensmall">{mini_cal_row.mini_cal_days.MINI_CAL_DAY}</span></td>
			<!-- END mini_cal_days -->
		</tr>

		<!-- END mini_cal_row -->
<tr class="row1">
      <td style="width: 100%; text-align: center" class="bg4" colspan="7">Termine</td>
  </tr>
  <tr>
    <td class="row1" colspan="7">

      <!-- BEGIN events -->
      <!-- IF events.S_FIRST_ROW -->
      <!-- ELSE --><hr><!-- ENDIF -->
      <a href="{events.EVENT_URL}"><!-- IF events.COLOR --><span style="color:#{events.COLOR}"><!-- ENDIF -->
      [{events.START_TIME}]<!-- IF events.COLOR --></span><!-- ENDIF --></a>
      <a href="{events.EVENT_URL}" title="{events.FULL_SUBJECT}">
      <!-- IF events.COLOR --><span style="color:#{events.COLOR}"><!-- ENDIF -->
      <!-- IF events.DISPLAY_BOLD --><strong><!-- ENDIF -->
      <!-- IF events.IMAGE --><img src="{events.IMAGE}" title="{events.ETYPE_DISPLAY_NAME}"><!-- ENDIF -->
      <!-- IF events.ETYPE_DISPLAY_NAME -->{events.ETYPE_DISPLAY_NAME}:<!-- ENDIF -->
      {events.SUBJECT}
      <!-- IF events.DISPLAY_BOLD --></strong><!-- ENDIF -->
      <!-- IF events.SHOW_TIME --><br /><!-- IF events.ALL_DAY -->{events.START_TIME}<!-- ELSE -->
      {L_FROM_TIME}: {events.START_TIME} <br />{L_TO_TIME}: {events.END_TIME}<!-- ENDIF -->
      <!-- ENDIF -->
      <!-- IF events.COLOR --></span><!-- ENDIF --></a><br />
      <!-- END events -->

    </td>
  </tr>
	</table>
{$LR_BLOCK_F_L}{$LR_BLOCK_F_R}

[Lara]

Thank you very very much. Now the dates are included in the mini calendar but the problem is that the second calendar block with the dates is still there. How can I deactivate it?

[Lara]

Now I deleted <!-- INCLUDE portal/block/calendar.html --> in the styles/prosilver/template/portal/portal_body.html and it seems to work.
I hope this is ok?