phpBB • Free and Open Source Forum Software

RSS Facebook Twitter
Menu

[ABD] User Topic Count

Any abandoned Extensions will be moved to this forum.

WARNING: Extensions in this forum are not currently being supported or maintained by the original Extension author. Proceed at your own risk.
Forum rules
IMPORTANT: Extension Development Forum rules

WARNING: Extensions in this forum are not currently being supported nor updated by the original Extension author. Proceed at your own risk.
User avatar
martti
Registered User
Posts: 914
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

[ABD] User Topic Count

Post by martti »

Extension Name: User Topic Count
Author: martti
Extension Description: Shows the number of "approved" topics a user started and links to the user's topic search. Notice that the result number of the topics in the search page may be different because of the permissions of the current user.
Extension Version: 0.6.1
Requirements:
  • phpBB 3.3+
  • PHP 7.1+
Extension Download: https://github.com/marttiphpbb/phpbb-ex ... master.zip
The files are to be put in ext/marttiphpbb/usertopiccount
Github repository: https://github.com/marttiphpbb/phpbb-ext-usertopiccount
Languages: en, ar, fr, es
Templates: prosilver
Screenshots:

Viewtopic
Image

Profile
Image

UCP main front
Image
Last edited by martti on Tue May 05, 2020 1:03 pm, edited 12 times in total.
Top
User avatar
martti
Registered User
Posts: 914
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti »

Status: updating topic count works when enabling the extension and posting a new topic. But it seems there are no php events for deleting topics or updating the topic visibility. So I'm a bit stuck there. Maybe this needs new php events in core if no work-around can be found.
Top
User avatar
KhurramMunawar
Registered User
Posts: 534
Joined: Tue Mar 25, 2014 2:20 am
Location: Islamabad, Pakistan
Name: Khurram Munawar

Re: [ALPHA] User Topic Count

Post by KhurramMunawar »

brilliant Martti. Love u
Get Free Traffic To Your Website
Trafficonic.com - Free Traffic To Your Website
Top
User avatar
KhurramMunawar
Registered User
Posts: 534
Joined: Tue Mar 25, 2014 2:20 am
Location: Islamabad, Pakistan
Name: Khurram Munawar

Re: [ALPHA] User Topic Count

Post by KhurramMunawar »

got this Error after enabling the extension ACP
General Error
SQL ERROR [ mysql4 ]

FUNCTION dearhelp_forumdb.MAX does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual [1630]

SQL

SELECT MAX (user_id) as last_id FROM phpbb_users

BACKTRACE

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

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

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

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

FILE: [ROOT]/ext/marttiphpbb/usertopiccount/ext.php
LINE: 35
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 187
CALL: marttiphpbb\usertopiccount\ext->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 184
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Get Free Traffic To Your Website
Trafficonic.com - Free Traffic To Your Website
Top
Tuqe
Registered User
Posts: 63
Joined: Mon Nov 10, 2014 9:18 am
Location: Turkey

Re: [ALPHA] User Topic Count

Post by Tuqe »

Code: Select all

Genel Hata
SQL ERROR [ mysqli ]

FUNCTION dsdffdss_yedekvt.MAX does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual [1630]

SQL

SELECT MAX (user_id) as last_id FROM phpbb_users

BACKTRACE

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

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

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

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

FILE: [ROOT]/ext/marttiphpbb/usertopiccount/ext.php
LINE: 35
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 187
CALL: marttiphpbb\usertopiccount\ext->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 184
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Top
User avatar
martti
Registered User
Posts: 914
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti »

Probably this is because I've put a space between MAX and (user_id)

MAX (user_id)

should be

MAX(user_id)

I'm using Sqlite3 which doesn't care. I will correct soon.
Top
User avatar
KhurramMunawar
Registered User
Posts: 534
Joined: Tue Mar 25, 2014 2:20 am
Location: Islamabad, Pakistan
Name: Khurram Munawar

Re: [ALPHA] User Topic Count

Post by KhurramMunawar »

thanks. waiting for the update. :roll:
Get Free Traffic To Your Website
Trafficonic.com - Free Traffic To Your Website
Top
Tuqe
Registered User
Posts: 63
Joined: Mon Nov 10, 2014 9:18 am
Location: Turkey

Re: [ALPHA] User Topic Count

Post by Tuqe »

Ok then.
Waiting...
8-)
Top
User avatar
martti
Registered User
Posts: 914
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti »

The update is pushed.
Top
User avatar
KhurramMunawar
Registered User
Posts: 534
Joined: Tue Mar 25, 2014 2:20 am
Location: Islamabad, Pakistan
Name: Khurram Munawar

Re: [ALPHA] User Topic Count

Post by KhurramMunawar »

martti wrote:The update is pushed.
General Error
SQL ERROR [ mysql4 ]

Unknown column 'u.user_topic_count' in 'having clause' [1054]

SQL

SELECT COUNT(t.topic_id) as user_topic_count, u.user_id FROM phpbb_topics t, phpbb_users u WHERE t.topic_visibility = 1 AND t.topic_poster = u.user_id AND u.user_id >= 0 AND u.user_id < 72 AND u.user_id <> 1 GROUP BY t.topic_poster HAVING COUNT(t.topic_id) <> u.user_topic_count

BACKTRACE

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

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

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

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

FILE: [ROOT]/ext/marttiphpbb/usertopiccount/ext.php
LINE: 62
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 187
CALL: marttiphpbb\usertopiccount\ext->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 184
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Get Free Traffic To Your Website
Trafficonic.com - Free Traffic To Your Website
Top
User avatar
martti
Registered User
Posts: 914
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti »

Code: Select all

Unknown column 'u.user_topic_count' in 'having clause' [1054]
Strange. I have to look it up for MySQL. The space error is fixed, that's already something.
Top
FomenkoAndrey
Registered User
Posts: 369
Joined: Thu Aug 19, 2010 10:44 am

Re: [ALPHA] User Topic Count

Post by FomenkoAndrey »

done http://www.phpbbguru.net/community/topic42362.html
Top
User avatar
Niknovel
Registered User
Posts: 23
Joined: Mon Dec 08, 2014 8:16 am
Location: Moscow
Name: Николай

Re: [ALPHA] User Topic Count

Post by Niknovel »

Prime User Topics phpBB 3.1.x version
Installed Expansion PhpBB3 version: 3.1.3
Installed Mods PhpBB3 version: 3.0.13-PL1
Top
FomenkoAndrey
Registered User
Posts: 369
Joined: Thu Aug 19, 2010 10:44 am

Re: [ALPHA] User Topic Count

Post by FomenkoAndrey »

similar, but very much inferior in functionality, it is not convenient.
no explanation on page User topics.
requires a lot of improvements.
Top
User avatar
martti
Registered User
Posts: 914
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti »

Updated. Enabling should work now with MySQL. I installed a MySQL server myself to try.
Top

Return to “Abandoned Extensions”