Page 2 of 8
Re: phpBB Calendar block on Board3 Portal (Update 1.0.2)
Posted: 10. July 2009 02:33
by 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.
Re: phpBB Calendar block on Board3 Portal (Update 1.0.2)
Posted: 29. July 2009 03:49
by 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.
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 29. July 2009 17:22
by wang5555
Update v1.0.3,
See first post.
--
@Sandrock:
Please try the latest mod, thanks!
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 29. July 2009 18:14
by 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!
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 30. July 2009 05:53
by wang5555
Sandrock wrote: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.
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 30. July 2009 16:47
by 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?
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 31. July 2009 05:14
by wang5555
hegse wrote: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.
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 31. July 2009 17:42
by 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.
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 31. July 2009 19:21
by hegse
wang5555 wrote:
Yes, because I think it is useless.
Ok.
jerkstore wrote: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...
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 1. August 2009 14:21
by Lara
I have the same problem than hegse and I would also appreciate to have the calendar back.
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 2. August 2009 18:23
by 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...
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 2. August 2009 22:15
by 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.
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 2. August 2009 22:23
by 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=""/> {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}
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 2. August 2009 23:02
by 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?
Re: phpBB Calendar block on Board3 Portal (Update 1.0.3)
Posted: 2. August 2009 23:49
by 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?