3.2 & 3.3 Extensions Database 3.2 / 3.3Who Visited This Topic

<span class="qte-attr qte_32_33-qte">3.2.x & 3.3.x</span>
User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6464
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Who Visited This Topic

Post by dmzx »

ssl wrote: 02 Mar 2023, 07:51 Download the french language pack for 1.0.9 version ici
:thumbup:

User avatar

Tarantino
Users
Users
Posts: 42
Joined: 10 Sep 2016, 04:58
    Windows 10 Chrome

Re: Who Visited This Topic

Post by Tarantino »

Would be great to have an exclude option for forums. So it will only appear on the not excluded ones.

User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6464
Joined: 13 Jan 2014, 21:45
    Android Chrome

Re: Who Visited This Topic

Post by dmzx »

Tarantino wrote: 02 Mar 2023, 20:13 Would be great to have an exclude option for forums. So it will only appear on the not excluded ones.
Will take this into account :thumbup:

User avatar

Scanialady
Users
Users
Posts: 310
Joined: 06 Apr 2015, 18:04
    Windows 10 Chrome

Re: Who Visited This Topic

Post by Scanialady »

German language files for 1.0.9 here. (Choose the file, right click - save under...)
-
If you want to get German translations for extensions: ask me.

User avatar

pit
New user
New user
Posts: 1
Joined: 08 Aug 2023, 14:03
    Linux Firefox

Re: Who Visited This Topic

Post by pit »

Thank U for this valuable extension.

My provider just upgraded mysql to V8 and we got following errors when accessing to a post (phpbb 3.3.10, php 8.2.8)

Code: Select all

Erreur générale
SQL ERROR [ mysqli ]

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

SQL

SELECT w.user_id, w.topic_id, w.counter_user, w.date, u.username, u.user_colour, u.user_id, u.user_avatar, u.user_avatar_type, u.user_avatar_height, u.user_avatar_width, u.user_type, SUM(w.counter_user) AS total FROM phpbb_whovisitedthistopic w, phpbb_users u WHERE w.topic_id = 4836 AND w.user_id = u.user_id AND w.user_id <> '65' GROUP BY w.user_id ORDER BY w.date DESC LIMIT 15
The solution found by the provider was to deactivate the SQL ONLY_FULL_GROUP_BY mode, as you wrote somewhere above.
Seems to be correct now.
Merci beaucoup.
:thumbup:
Last edited by pit on 09 Aug 2023, 22:37, edited 1 time in total.

User avatar

Kinsman
Users
Users
Posts: 109
Joined: 18 Aug 2016, 15:38
    Windows 10 Edge

Re: Who Visited This Topic

Post by Kinsman »

I'm not sure why this is happening, we use the standard coloured usernames in PHPBB3, and this is how it displays?
You do not have the required permissions to view the files attached to this post! Maybe your post count is too low.

User avatar

Xxxbennyxxx
Users
Users
Posts: 74
Joined: 30 Dec 2014, 22:23
    Windows 10 Chrome

Re: Who Visited This Topic

Post by Xxxbennyxxx »

Is it possible to put who visited this topic under who is online in view_topic? I've looked myself, but I can't find an event

User avatar

ssl
Donator
Donator
Posts: 137
Joined: 19 Aug 2020, 12:54
    Mac OS X Opera

Re: Who Visited This Topic

Post by ssl »

Kinsman wrote: 09 Jan 2024, 01:24 I'm not sure why this is happening, we use the standard coloured usernames in PHPBB3, and this is how it displays?
Disable your extensions and then check
Xxxbennyxxx wrote: 22 Jan 2024, 20:29 Is it possible to put who visited this topic under who is online in view_topic? I've looked myself, but I can't find an event
Do you really understand the meaning of this extension?
phpBB: 3.3.14 | PHP: 8.3
[Some French translation of extensions]

User avatar

Xxxbennyxxx
Users
Users
Posts: 74
Joined: 30 Dec 2014, 22:23
    Android Chrome

Re: Who Visited This Topic

Post by Xxxbennyxxx »

Of course, but I want it in view topic under the online block

User avatar

SpIdErPiGgY
Users
Users
Posts: 117
Joined: 04 Feb 2021, 23:54
    Windows 10 Firefox

Re: Who Visited This Topic

Post by SpIdErPiGgY »

Xxxbennyxxx wrote: 22 Jan 2024, 20:29 Is it possible to put who visited this topic under who is online in view_topic? I've looked myself, but I can't find an event
Rename viewtopic_body_footer_before.htmt to overall_footer_content_after.html
And clear forum cache
Image

User avatar

Xxxbennyxxx
Users
Users
Posts: 74
Joined: 30 Dec 2014, 22:23
    Windows 10 Chrome

Re: Who Visited This Topic

Post by Xxxbennyxxx »

Onnozel Manneke wrote: 23 Jan 2024, 06:23
Xxxbennyxxx wrote: 22 Jan 2024, 20:29 Is it possible to put who visited this topic under who is online in view_topic? I've looked myself, but I can't find an event
Rename viewtopic_body_footer_before.htmt to overall_footer_content_after.html
And clear forum cache
Then it will not be shown in my block but below it. But it is solved, I created an event myself
viewtopic_body_online_list_after.html

Now just a little CSS and it's perfect.

Image

User avatar

ssl
Donator
Donator
Posts: 137
Joined: 19 Aug 2020, 12:54
    Mac OS X Opera

Re: Who Visited This Topic

Post by ssl »

And what topics have these members read?

User avatar

SpIdErPiGgY
Users
Users
Posts: 117
Joined: 04 Feb 2021, 23:54
    Android Firefox

Re: Who Visited This Topic

Post by SpIdErPiGgY »

ssl wrote: 23 Jan 2024, 07:25 And what topics have these members read?
The code is on the viewtopic page...

User avatar

ssl
Donator
Donator
Posts: 137
Joined: 19 Aug 2020, 12:54
    Mac OS X Opera

Re: Who Visited This Topic

Post by ssl »

OK

User avatar

Xxxbennyxxx
Users
Users
Posts: 74
Joined: 30 Dec 2014, 22:23
    Windows 10 Chrome

Re: Who Visited This Topic

Post by Xxxbennyxxx »

Indeed, I created the event in viewtopic_body.html The extension still works as expected. But at least now it is displayed where it should be (for my style) in the block with the other statistics.

Post Reply Previous topicNext topic