greetings from Switzerland

You can say hello here
Don't be afraid. Nobody is biting

greetings from Switzerland

Post by flumsi »

I only have hjw calendar installed, I don't even know if there is an addon for the calendar
Extensions are available for Ultima Points. Sudoku & Hangman have point allocation through the Ultima Points extension.

Sudoku & Hangman bring 2 queries less

Code: Select all

"name": "hjw/calendar",
	"type": "phpbb-extension",
	"description": "Calendar for phpBB >=3.2.0",
	"homepage": "https://calendar.killifisch.info/",
	"version": "1.1.3",
	"license": "GPL-2.0-only",

greetings from Switzerland

Post by Stoker »

Im sure I found something about this one in your source code earlier: https://github.com/gn36/phpbb-ext-hjw-bridge

In general be carefull with extensions for earlier phpBB version than the current.


From the chat:
Flumsi, since you have Steves track users, you have no use for dmzx member profile views and who visit topic. Since they do the same thing, there could be a conflict


Its not about which extension you need. Its about figuring out the culprit.
When you find it you have the option to ask the developer for help. And you can still use it no matter how many queers it is adding.

greetings from Switzerland

Post by flumsi »

I haven't activated the extension, nor do I have it in the FTP folder.

Code: Select all

"name": "gn36/versionchecknotifier",
"type": "phpbb-extension",
"description": "This extension checks for extension and phpBB updates periodically and notifies admins about updates.",

"homepage": "https://github.com/gn36/phpbb-ext-versionchecknotifier/",
"version": "3.0.1",
"time": "2020-01-14",
"license": "GPL-2.0-only",
is only there and activated.

I've set up Steve's Track Users for myself, and only I can see the extension. I'm not sure yet whether I should make it available to everyone. Seeing who did what, where, when, and much more is, in my opinion, an admin matter.

DMZX can be seen by everyone, track users only by me, so I renamed the track user event to show who visited the topic, so that it is no longer displayed

I continue to deactivate & activate one extension after the other ;(

greetings from Switzerland

Post by flumsi »

Hello everyone

The world is often cruel to us :evil: :facepalm:

You can show/hide the hjw calendar on the main page. That's exactly the point.

When the calendar is closed, I see the following
Screenshot 2025-06-27 112933.png
Loading time: 0.383s | Max. memory usage: 21.72 MiB | GZIP: Off | Queries: 87 | SQL Explain

When the calendar is displayed, I see the following
Screenshot 2025-06-27 112958.png
Loading time: 0.515s | Max. memory usage: 22.43 MiB | GZIP: Off | Queries: 550 | SQL Explain

If I, as the only logged-in user, display the calendar on the main page and then simply log out, I receive 550 queries as a guest. If I'm the only logged-in user in the forum and hide the calendar and simply log out, I receive 80 queries.

Das ist meine ext/hjw/calendar/style/prosilver/templates/event/overall_header_navigation_prepend.html

Code: Select all

<!-- IF not (S_GROUP_23 or S_GROUP_2 or S_GROUP_25) -->
{% if not S_IS_BOT and S_USER_LOGGED_IN || S_IS_BOT and S_CALENDAR_FOR_GUESTS || !S_USER_LOGGED_IN and S_CALENDAR_FOR_GUESTS %}
		{% if CALENDAR_ON_INDEX_OFF %}
			<li data-last-responsive="true">
				{% if CALENDAR %}
					<a href="{{ DISPLAY_ACTION }}" title="{{ lang('CALENDAR_T_OFF') }}" role="menuitem" }}">
						<i class="icon fa-regular fa-calendar-minus-o" aria-hidden="true"></i><span class="show_text_on_phone">{{ lang('CALENDAR_T_OFF') }}</span>
					</a>
				{% else %}
					<a href="{{ DISPLAY_ACTION }}" title="{{ lang('CALENDAR_T_ON') }}" role="menuitem" }}">
						<i class="icon fa-regular fa-calendar-plus-o" aria-hidden="true"></i><span class="show_text_on_phone">{{ lang('CALENDAR_T_ON') }}</span>
					</a>
				{% endif %}
			
		
	{% if VERSION == '3.1' %}
		<li {% if not S_USER_LOGGED_IN %}data-skip-responsive="true"{% else %}data-last-responsive="true"{% endif %}>
		<a href="{{ U_CALENDAR }}" title="{{ lang('CALENDAR') }}" role="menuitem">{{ lang('CALENDAR') }}</a></li>
	{% endif %}
	{% if VERSION == '3.2' || VERSION == '3.3' %}
		
			<a href="{{ U_CALENDAR }}" title="{{ lang('CALENDAR') }}" role="menuitem">
				<span>{{ lang('CALENDAR') }}</span>
			</a>
		</li>
	{% endif %}
{% endif %}
{% endif %}
<!-- ENDIF -->
The hjw calendar has a visible/invisible setting for guests, and that works perfectly; as a guest, you can't see any of the calendar.

With <!-- IF not (S_GROUP_23 or S_GROUP_2 or S_GROUP_25) --> I hide the calendar for all groups that aren't guild members, and these groups can't see any of the calendar either. The extension for this application can be viewed here.

Currently, the simplest solution would be to disable the weekly overview on the main page and disable the show/hide icon.
So that only the calendar link is visible and can be executed. If I do exactly that, I constantly receive around 550 queries.
It seems that the calendar link alone brings these 550 queries
Screenshot 2025-06-27 125547.png
I also renamed navigation_prepend.html so that no link is displayed anymore and I still get 550 queries, even though the week display and the icon are no longer displayed.

So it seems as if the whole thing is constantly loading, only when I display the show/hide icon and hide the weekly overview there, I get 80 queries

Of course, every attempt cleared the forum cache, browser cache, etc.
You do not have the required permissions to view the files attached to this post.

greetings from Switzerland

Post by Stoker »

Renaming or deleting any html wont do anything. html is just the "looks" and php is the "machine"

What you are experiencing simply is bad coding. Probably because the author is putting all kind of functions in: public function add_page_header_link() instead of, yes, nothing else than the link.
You need to report this to the author and ask for a fix.

greetings from Switzerland

Post by Stoker »

@flumsi Just installed the calendar on my testboard. I only get about 50 queries.

greetings from Switzerland

Post by flumsi »

I have that in my test forum, too, but neither of us has hundreds of events entered in our calendar until the end of the year, like I do in the guild's live forum. There are only about 10 topics that contain all of these events.

Every Tuesday, every Thursday, the first Saturday of the month, every second Saturday of the month, two events every Sunday, and then the guild council events and raid nights, not to mention spontaneous events and so on, entered until the end of 2025, as recurring events, etc. We simply organize everything via the calendar.

For each event, not forgetting all member registrations.

I saw that when I open the monthly overview, I have 2,200+ queries, because there are so many events, I assume.
That's probably why the weekly overview on the main page also shows so many queries, but I don't know.

I didn't know about this before I had this debugging indicator lol
The forum also runs smoothly. Sure, it takes a little longer to load from the monthly overview to the relevant topic, but that's minimal (0.4ms to 0.9ms).

What I find strange is that when I disable the weekly overview in the ACP.

Displaying the weekly overview or upcoming appointments - no display
Number of weeks or rows with appointments - 1
Number of upcoming appointments per row - 1
Can the overview/appointments in the header be disabled for the current day? - off
Display weekly overview on smartphone? - off
Display upcoming appointments on smartphone? - off
Display birthdays as the next appointments? - off

The queries are still there. PHP should be able to handle and disable the settings in the calendar's ACP, or am I misunderstanding this?

Why are these queries executed if everything in the ACP extension has been set to OFF?

Why is it also executed for guests who have been excluded via the ACP extension?

greetings from Switzerland

Post by Stoker »

I think most of the settings only are about display.
And nobody ever has used the extension as much as you which actually is a good thing.
Give the author feedback and he might be able to improve his extension.