phpBB • Free and Open Source Forum Software

RSS Facebook Twitter
Menu

[ABD] PostsStatistics

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
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

[ABD] PostsStatistics

Post by John P »

Posts Statistics

Authors: John P

Extension Description: Statistics of your forum in a timeframe
Extension Version: 3.1.0-RC3

Requirements: phpBB 3.1.*@dev

Features:
  • Posts overview.
  • Topics overview.
  • Posts per user.
  • Topics per user.
  • Posts / topics.
  • Monthly overview.
  • Yearly overview.
  • And much more
GitHub repository:https://github.com/ForumHulp/postsstats
Extension Download: https://github.com/ForumHulp/postsstats ... master.zip

Image
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign
Top
User avatar
draky
Registered User
Posts: 250
Joined: Tue Dec 10, 2002 2:04 pm
Location: France
Name: Gilles W.

Re: [DEV] PostsStatistics

Post by draky »

So, it's the same extension than your "admin stats" ext, but for users ?

Does this extension have permissions settings (in admin ext tab) to enable which usergroups can see stats ?

Good job anyway :)
Top
User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

Re: [DEV] PostsStatistics

Post by John P »

No it's not for users, only for administrators and because of that there no permissions for this extension.
Board- Statistics show statistics about your visitors while Post-Statistics shows graphs about posts and topics from your forum.
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign
Top
User avatar
draky
Registered User
Posts: 250
Joined: Tue Dec 10, 2002 2:04 pm
Location: France
Name: Gilles W.

Re: [DEV] PostsStatistics

Post by draky »

Ok, it it the sister extension of the other ;)

But why not merging them ?
Stats are... stats, no ?

Anyway, good job :)
Top
Holger
Registered User
Posts: 1886
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] PostsStatistics

Post by Holger »

GREAT! Thanks a lot!
Top
User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

Re: [DEV] PostsStatistics

Post by John P »

It's a possibility to merge yes, but the purpose is different.

A sister extension, great name! :D
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign
Top
Holger
Registered User
Posts: 1886
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] PostsStatistics

Post by Holger »

I would leave it separated!
Top
User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 11137
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo

Re: [DEV] PostsStatistics

Post by Raul [ThE KuKa] »

Spanish translation ready. :wink:
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies | Styles Queue Stats :warning:

If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate.
:flag_es: phpBB Spain - Online Since 2003 :heart:


Top
User avatar
draky
Registered User
Posts: 250
Joined: Tue Dec 10, 2002 2:04 pm
Location: France
Name: Gilles W.

Re: [DEV] PostsStatistics

Post by draky »

Bugs with 3.1 final.

Post Stat => Stats "Posts per user"

Code: Select all

General Error
SQL ERROR [ mysqli ]

Table 'XXXXXX.tbl_users' doesn't exist [1146]

SQL

SELECT u.username, COUNT(p.post_id) AS total FROM phpbb_posts p LEFT JOIN tbl_users u ON u.user_id = p.poster_id WHERE YEAR(FROM_UNIXTIME(p.post_time)) = 2014 AND MONTH(FROM_UNIXTIME(p.post_time)) = 10 GROUP BY p.poster_id ORDER BY total DESC LIMIT 20

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/forumhulp/postsstats/vendor/stat_functions.php
LINE: 119
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/forumhulp/postsstats/acp/postsstats_module.php
LINE: 99
CALL: stat_functions::ppu()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\postsstats\acp\postsstats_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
"Groups posts"

Code: Select all

General Error
SQL ERROR [ mysqli ]

Table 'XXXXX.tbl_users' doesn't exist [1146]

SQL

SELECT u.username, COUNT(p.post_id) AS total FROM phpbb_posts p LEFT JOIN tbl_users u ON u.user_id = p.poster_id WHERE YEAR(FROM_UNIXTIME(p.post_time)) = 2014 AND MONTH(FROM_UNIXTIME(p.post_time)) = 10 GROUP BY p.poster_id ORDER BY total DESC LIMIT 20

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/forumhulp/postsstats/vendor/stat_functions.php
LINE: 119
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/forumhulp/postsstats/acp/postsstats_module.php
LINE: 99
CALL: stat_functions::ppu()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\postsstats\acp\postsstats_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Top
User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

Re: [DEV] PostsStatistics

Post by John P »

Thanks for reporting
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign
Top
User avatar
draky
Registered User
Posts: 250
Joined: Tue Dec 10, 2002 2:04 pm
Location: France
Name: Gilles W.

Re: [DEV] PostsStatistics

Post by draky »

Have updated to your last commit, "Posts per user" works, but "Groups posts" gives SLQ error :

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'u.group_id' in 'field list' [1054]

SQL

SELECT u.group_id, g.group_name, COUNT(p.post_id) AS total FROM phpbb_posts P LEFT JOIN phpbb_users U ON U.user_id = p.poster_id LEFT JOIN phpbb_groups g ON g.group_id = u.group_id WHERE YEAR(FROM_UNIXTIME(p.post_time)) = 2014 AND MONTH(FROM_UNIXTIME(p.post_time)) = 10 GROUP BY g.group_id ORDER BY total DESC LIMIT 20

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/forumhulp/postsstats/vendor/stat_functions.php
LINE: 374
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/forumhulp/postsstats/acp/postsstats_module.php
LINE: 123
CALL: stat_functions::gp()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\postsstats\acp\postsstats_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Top
User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

Re: [DEV] PostsStatistics

Post by John P »

That's right there is a capital U instead.
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign
Top
User avatar
draky
Registered User
Posts: 250
Joined: Tue Dec 10, 2002 2:04 pm
Location: France
Name: Gilles W.

Re: [DEV] PostsStatistics

Post by draky »

Another SQL problem with "Group posts" :

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'p.post_id' in 'field list' [1054]

SQL

SELECT u.group_id, g.group_name, COUNT(p.post_id) AS total FROM phpbb_posts P LEFT JOIN phpbb_users u ON U.user_id = p.poster_id LEFT JOIN phpbb_groups g ON g.group_id = u.group_id WHERE YEAR(FROM_UNIXTIME(p.post_time)) = 2014 AND MONTH(FROM_UNIXTIME(p.post_time)) = 10 GROUP BY g.group_id ORDER BY total DESC LIMIT 20

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/forumhulp/postsstats/vendor/stat_functions.php
LINE: 374
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/forumhulp/postsstats/acp/postsstats_module.php
LINE: 123
CALL: stat_functions::gp()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\postsstats\acp\postsstats_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Top
User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John

Re: [DEV] PostsStatistics

Post by John P »

Tjsss, why doesn't my sql server sees this
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign
Top
User avatar
Walther
Registered User
Posts: 301
Joined: Fri Jul 09, 2004 5:21 pm
Location: The Netherlands

Re: [DEV] PostsStatistics

Post by Walther »

draky wrote:Another SQL problem with "Group posts" :

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'p.post_id' in 'field list' [1054]

SQL

SELECT u.group_id, g.group_name, COUNT(p.post_id) AS total FROM phpbb_posts P LEFT JOIN phpbb_users u ON U.user_id = p.poster_id LEFT JOIN phpbb_groups g ON g.group_id = u.group_id WHERE YEAR(FROM_UNIXTIME(p.post_time)) = 2014 AND MONTH(FROM_UNIXTIME(p.post_time)) = 10 GROUP BY g.group_id ORDER BY total DESC LIMIT 20

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/forumhulp/postsstats/vendor/stat_functions.php
LINE: 374
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/forumhulp/postsstats/acp/postsstats_module.php
LINE: 123
CALL: stat_functions::gp()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\postsstats\acp\postsstats_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
idem
Top

Return to “Abandoned Extensions”