[3.2][BETA] User Topic Count

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
User avatar
martti
Registered User
Posts: 682
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

[3.2][BETA] User Topic Count

Post by martti » Sun Jan 11, 2015 8:04 pm

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.5.0
Requirements: phpBB 3.2.2+, 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 Sat Oct 13, 2018 10:12 pm, edited 9 times in total.

User avatar
martti
Registered User
Posts: 682
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti » Sun Jan 11, 2015 8:15 pm

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.

User avatar
KhurramMunawar
Registered User
Posts: 534
Joined: Tue Mar 25, 2014 2:20 am
Location: Islamabad, Pakistan
Name: Khurram Munawar
Contact:

Re: [ALPHA] User Topic Count

Post by KhurramMunawar » Sun Jan 11, 2015 8:22 pm

brilliant Martti. Love u
My forum:
DearHelper.org
Get Free Traffic To Your Website
Trafficonic.com - Free Traffic To Your Website

User avatar
KhurramMunawar
Registered User
Posts: 534
Joined: Tue Mar 25, 2014 2:20 am
Location: Islamabad, Pakistan
Name: Khurram Munawar
Contact:

Re: [ALPHA] User Topic Count

Post by KhurramMunawar » Sun Jan 11, 2015 8:28 pm

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()
My forum:
DearHelper.org
Get Free Traffic To Your Website
Trafficonic.com - Free Traffic To Your Website

Tuqe
Registered User
Posts: 63
Joined: Mon Nov 10, 2014 9:18 am
Location: Turkey

Re: [ALPHA] User Topic Count

Post by Tuqe » Sun Jan 11, 2015 8:35 pm

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()

User avatar
martti
Registered User
Posts: 682
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti » Sun Jan 11, 2015 8:39 pm

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.

User avatar
KhurramMunawar
Registered User
Posts: 534
Joined: Tue Mar 25, 2014 2:20 am
Location: Islamabad, Pakistan
Name: Khurram Munawar
Contact:

Re: [ALPHA] User Topic Count

Post by KhurramMunawar » Sun Jan 11, 2015 8:40 pm

thanks. waiting for the update. :roll:
My forum:
DearHelper.org
Get Free Traffic To Your Website
Trafficonic.com - Free Traffic To Your Website

Tuqe
Registered User
Posts: 63
Joined: Mon Nov 10, 2014 9:18 am
Location: Turkey

Re: [ALPHA] User Topic Count

Post by Tuqe » Sun Jan 11, 2015 8:43 pm

Ok then.
Waiting...
8-)

User avatar
martti
Registered User
Posts: 682
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti » Sun Jan 11, 2015 8:47 pm

The update is pushed.

User avatar
KhurramMunawar
Registered User
Posts: 534
Joined: Tue Mar 25, 2014 2:20 am
Location: Islamabad, Pakistan
Name: Khurram Munawar
Contact:

Re: [ALPHA] User Topic Count

Post by KhurramMunawar » Sun Jan 11, 2015 8:54 pm

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()
My forum:
DearHelper.org
Get Free Traffic To Your Website
Trafficonic.com - Free Traffic To Your Website

User avatar
martti
Registered User
Posts: 682
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti » Sun Jan 11, 2015 9:05 pm

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.

FomenkoAndrey
Registered User
Posts: 367
Joined: Thu Aug 19, 2010 10:44 am

Re: [ALPHA] User Topic Count

Post by FomenkoAndrey » Sun Jan 11, 2015 9:10 pm


User avatar
Niknovel
Registered User
Posts: 23
Joined: Mon Dec 08, 2014 8:16 am
Location: Moscow
Name: Николай
Contact:

Re: [ALPHA] User Topic Count

Post by Niknovel » Sun Jan 11, 2015 9:33 pm

Prime User Topics phpBB 3.1.x version
Installed Expansion PhpBB3 version: 3.1.3
Installed Mods PhpBB3 version: 3.0.13-PL1

FomenkoAndrey
Registered User
Posts: 367
Joined: Thu Aug 19, 2010 10:44 am

Re: [ALPHA] User Topic Count

Post by FomenkoAndrey » Sun Jan 11, 2015 10:21 pm

similar, but very much inferior in functionality, it is not convenient.
no explanation on page User topics.
requires a lot of improvements.

User avatar
martti
Registered User
Posts: 682
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti » Sun Jan 11, 2015 11:02 pm

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

Post Reply

Return to “Extensions in Development”

Who is online

Users browsing this forum: Roots and 49 guests