[3.3][DEV] phpBB Events Calendar

[ssl]

Perfect

[Steve]

Extension Version:

Features Implemented:

• monthly birthdays
• Mark events as attended
• Toggle columns on index
• Starts in xx days, Lasts xx days
• Add event end time options

Bugs Fixed:

• SQL error on -timestamp

Features not Implemented:

• Support upcoming b-days by Rich
  • Wrote my own ...
• event fa icon....... (a list of known fa icons needs to be generated for user selection)
  • phpbb.com/community/viewtopic.php?f=456&t=2518961
    • A more up-to-date list and code is needed.

Extension Download: here

[ssl]

There is a problem with the translation into French when displaying events on the index

event.png

27th in French is displayed as 27ème

[Steve]

Thanks. Will get translated for next version.

[ssl]

Thanks

Is it possible to add a modification?
When you click on the link to return to the board index, the calendar and events toggles display the calendar and events. Would it be possible to keep this information hidden each time you return to the index?

Capture d’écran 2025-01-12 à 17.32.41.png

[Steve]

Sure, no problem at all.

[edu81]

Hi, I tested this extension on a phpbb 3.3.14 forum, but I can't see any calendar link on the settings page.

(using 0.9.2-dev ext)

Thanks!

[ssl]

Are you sure you have the permissions to view the calendar?

[edu81]

Are you sure you have the permissions to view the calendar?

thanks!!, that was the reason

But now, I have this error:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'phpbb.phpbb_calendar_events.event_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT * FROM phpbb_calendar_events WHERE year = 2025 OR annual = 1 GROUP BY day

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 213
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 353
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/steve/calendar/calendar/calendar.php
LINE: 323
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/steve/calendar/calendar/calendar.php
LINE: 88
CALL: steve\calendar\calendar\calendar->get_events()

FILE: [ROOT]/ext/steve/calendar/controller/calendar_view.php
LINE: 64
CALL: steve\calendar\calendar\calendar->get_calendar()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 151
CALL: steve\calendar\controller\calendar_view->view_year()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 68
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 35
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()

phpbb 3.3.14
phpBB Events Calendar 0.9.2
PHP Version 8.3.13
MySQL 8.0.30

Thanks in advance.

[Steve]

Try these files: https://steven-clark.tech/phpBB3/download/file.php?id=144

[edu81]

Try these files: https://steven-clark.tech/phpBB3/download/file.php?id=144

Solved, thank you Steve!

[Steve]

Cool, thanks for testing.

[eunaumtenhoid]

Would it be possible to add some API, I don't know, to synchronize the calendar with showings of episodes that will be released from TV shows and movies? with the addition of putting a link to a topic on the forum with a review or news about it?

[mmccreadie]

I seem to be missing something Steve as I can't find any way to create an Event, the Forum id chosen only has the default New Topic button..?

Don't think it's permission as suggested in a previous post...


phpbb 3.3.11
phpBB Events Calendar 0.9.2
PHP Version 8.2.12
MySQL 10.4.32-MariaDB

[Steve]

Try these example directional pictures:

Firefox_Screenshot_2025-03-16T15-57-20.864Z.png

Firefox_Screenshot_2025-03-16T15-58-31.566Z.png