[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: 1232
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

[ABD] PostsStatistics

Post by John P » Thu Sep 11, 2014 10:21 pm

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

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

Re: [DEV] PostsStatistics

Post by draky » Fri Sep 12, 2014 8:05 am

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

User avatar
John P
Registered User
Posts: 1232
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] PostsStatistics

Post by John P » Fri Sep 12, 2014 9:56 pm

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

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

Re: [DEV] PostsStatistics

Post by draky » Fri Sep 12, 2014 10:28 pm

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

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

Anyway, good job :)

Holger
Registered User
Posts: 1565
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] PostsStatistics

Post by Holger » Mon Sep 15, 2014 9:47 am

GREAT! Thanks a lot!
Are you looking for a phpBB Expert? Find a phpBB Expert!
Are you a phpBB Expert? Post your resume!
http://www.phpbbexperts.com

User avatar
John P
Registered User
Posts: 1232
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] PostsStatistics

Post by John P » Tue Sep 16, 2014 5:48 am

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

Holger
Registered User
Posts: 1565
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [DEV] PostsStatistics

Post by Holger » Tue Sep 16, 2014 6:39 am

I would leave it separated!
Are you looking for a phpBB Expert? Find a phpBB Expert!
Are you a phpBB Expert? Post your resume!
http://www.phpbbexperts.com

User avatar
Raul [ThE KuKa]
Jr. Extension Validator
Posts: 3244
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact:

Re: [DEV] PostsStatistics

Post by Raul [ThE KuKa] » Sat Sep 20, 2014 7:43 pm

Spanish translation ready. :wink:
If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate with Image
phpBB International Support Team (Spanish - Español) :flag_es: Online Since 2003
🎨phpBB Professional Premium Themes🔥
Author Translations (Spanish - Spain) :two_hearts:

:warning: I don't support those without the copyright Spanish translation. :warning:

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

Re: [DEV] PostsStatistics

Post by draky » Wed Oct 29, 2014 8:29 am

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

User avatar
John P
Registered User
Posts: 1232
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] PostsStatistics

Post by John P » Wed Oct 29, 2014 10:44 am

Thanks for reporting
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

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

Re: [DEV] PostsStatistics

Post by draky » Thu Oct 30, 2014 9:11 am

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

User avatar
John P
Registered User
Posts: 1232
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] PostsStatistics

Post by John P » Thu Oct 30, 2014 6:30 pm

That's right there is a capital U instead.
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

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

Re: [DEV] PostsStatistics

Post by draky » Thu Oct 30, 2014 9:36 pm

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

User avatar
John P
Registered User
Posts: 1232
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: [DEV] PostsStatistics

Post by John P » Fri Oct 31, 2014 11:36 am

Tjsss, why doesn't my sql server sees this
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

User avatar
Walther
Registered User
Posts: 257
Joined: Fri Jul 09, 2004 5:21 pm
Location: The Netherlands

Re: [DEV] PostsStatistics

Post by Walther » Fri Oct 31, 2014 12:19 pm

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

Locked

Return to “Abandoned Extensions”

Who is online

Users browsing this forum: No registered users and 5 guests