[ABD] Board Statistics

John P · Post by **John P** » Wed Aug 20, 2014 10:24 pm

Extension Name: Board statistics

Extension Description: Board Statistics displays an overview of your user's and guests visits in Quick Access module of ACP. This extension logs all visits of your users and guests. A cron job will prune Board Statistics.

Extension Version: 3.1.0-RC3

Requirements: phpBB 3.1.*@dev

Features:

Country overview
Referer overview
Search engines overview
Search terms overview
Browser overview
Crawlers overview
OS overview
Forums / modules overview
Screens resolutions overview
Users overview
Today and overall switchable
Graph and table views
Pruning
Auto refreshing

: Display online; online.jpg (106.21 KiB) Viewed 11408 times

: Forums / modules Overall; modules.jpg (49.77 KiB) Viewed 11408 times

GitHub repository: https://github.com/ForumHulp/statistics
Extension Download: https://github.com/ForumHulp/statistics ... master.zip

Post by **Raul [ThE KuKa]** » Wed Aug 20, 2014 10:27 pm

AWESOME !!! I like it.

John P · Post by **John P** » Wed Aug 20, 2014 10:58 pm

Thanks Raul, happy statistics!

hd321kbps · Post by **hd321kbps** » Thu Aug 21, 2014 5:38 am

mod is the bomb!

david63 · Post by **david63** » Thu Aug 21, 2014 6:31 am

Do you have any idea yet as to the load that gathering this data will have on the server?

John P · Post by **John P** » Thu Aug 21, 2014 7:26 am

Hi David,

Not yet, it's one record per visit and totalized once a day by cron.
Most of the information is already processed, once a day this table is truncated after being totalized.

It's running at my website since 3.0 without problems

Post by **Raul [ThE KuKa]** » Thu Aug 21, 2014 2:15 pm

Spanish translation ready, "PR".

Meis2M · Post by **Meis2M** » Thu Aug 21, 2014 2:24 pm

Hello
Persian Translation for your Extension:

[The extension zip has been deactivated and can no longer be displayed.]

Post by **Raul [ThE KuKa]** » Thu Aug 21, 2014 3:07 pm

Module name not translated?

ACP_STATISTICS (this line, and all lines translated).

Capture:

: screen.jpg (73.59 KiB) Viewed 11258 times

And this error forum index page:

Error General
SQL ERROR [ mysqli ]

Table 'admin_area51.tbl_statistics_se' doesn't exist [1146]

SQL

SELECT DISTINCT query FROM tbl_statistics_se WHERE name like "%google"

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/statistics/event/listener.php
LINE: 110
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: forumhulp\statistics\event\listener->get_ref()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 164
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 53
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php
LINE: 167
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 40
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch()

FILE: [ROOT]/includes/functions.php
LINE: 5213
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/index.php
LINE: 207
CALL: page_footer()

Disable the extension the error disappears.

John P · Post by **John P** » Thu Aug 21, 2014 4:34 pm

Hi Raul, thanks for the translation as also Meis2M.

The little table problem I didn't notice as my table prefix is tbl_ but it is solved.
Just replace the files and it should be ok.
There will be more little problems as it's in development off course and straight off

keith10456 · Post by **keith10456** » Thu Aug 21, 2014 4:55 pm

Great work!

Is there an ability to also capture the stats of custom phpBB pages? What about exts?

Post by **Raul [ThE KuKa]** » Thu Aug 21, 2014 4:55 pm

No problem John, I'm beta tester

John P · Post by **John P** » Thu Aug 21, 2014 5:01 pm

keith10456 wrote:Great work!

Is there an ability to also capture the stats of custom phpBB pages? What about exts?

Hi Keith,

There is but not yet in the package. It's working on forumhulp.com as you can see in the pictures. For example WK2014 or the tracks module. Don't know yet if it can work automatically.

Greetz

John P · Post by **John P** » Thu Aug 21, 2014 5:02 pm

Raul [ThE KuKa] wrote:No problem John, I'm beta tester

Without Beta testers there would be no program!!

keith10456 · Post by **keith10456** » Thu Aug 21, 2014 5:09 pm

John P wrote:
keith10456 wrote:Great work!

Is there an ability to also capture the stats of custom phpBB pages? What about exts?
Hi Keith,

There is but not yet in the package. It's working on forumhulp.com as you can see in the pictures. For example WK2014 or the tracks module. Don't know yet if it can work automatically.

Greetz

Maybe it could be created so if certain code is added to the page/ext it will track the stats of the respective page/ext