• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Extra Statistics 2013-04-18

No permission to download
Shows some extra statistics in the admin panel

wdb

Active member
#1
wdb submitted a new resource:

Extra Statistics - Shows some extra statistics in the admin panel

Shows some extra statistics in the admin panel, included are:
  • Gender ratio
  • Gender ratio - active in last 3 months
  • Time Zone
  • Time Zone - active in last 3 months
  • Threads per forum
  • Threads per forum - last 6 months
  • Most watched threads
  • Most watched threads - last 6 months
  • Most reported members - last 6 months
  • Most followed users
  • Most ignored users
To install unzip, upload to your XenForo library folder, and install the xml file.

Sorry no phrases,...
Read more about this resource...
 

Live Free

Active member
#7
Should the upload folder be uploaded to the root directory? I only ask because I don't recognize any of the three directories included.
 

wdb

Active member
#13
@wdb
Appears this add-on causes problems with v1.2.2 upgrades, as your add-on add's an index to the xf_user table, which then stops XF upgrade completing a structure and index change to the xf_user table. Refer http://xenforo.com/community/threads/unknown-column-user-is_staff-in-where-clause.52980/ and http://xenforo.com/community/threads/column-xf_user-is_staff-missing-upgrading-1-1-to-1-2.61257/
Are you sure it couldn't be another add-on ? this one doesn't make any changes to the database, all of the queries just select data, nothing is written. I'm running it on 1.2.2 without any issues.
 

Mouth

Well-known member
#14
Are you sure it couldn't be another add-on ? this one doesn't make any changes to the database, all of the queries just select data, nothing is written. I'm running it on 1.2.2 without any issues.
From one of the the treads I linked ...

library/ExtraStats/Installer.php: $db->query("ALTER TABLE `xf_user` ADD INDEX `register_date` (`register_date`)");

I have v1.0

Xf 1.2 upgrade is then trying ...

ALTER TABLE `xf_user`
ADD `is_staff` TINYINT UNSIGNED NOT NULL DEFAULT '0',
ADD INDEX message_count ( `message_count` ),
ADD INDEX trophy_points ( `trophy_points` ),
ADD INDEX like_count ( `like_count` ),
ADD INDEX register_date ( `register_date` ),
ADD INDEX `staff_username` ( `is_staff` , `username` )

... which fails because the 'ADD INDEX register_date ( `register_date` )' already exists, leading to the 'is_staff' column then not being added to Xf 1.2 database.
 

wdb

Active member
#15
From one of the the treads I linked ...

library/ExtraStats/Installer.php: $db->query("ALTER TABLE `xf_user` ADD INDEX `register_date` (`register_date`)");

I have v1.0
That is all very strange, if you look at the add-on, 1) the folder name is WdbExtraStats not ExtraStats, 2) there is no file Installer.php
 

Mouth

Well-known member
#16