Advanced Forum Statistics 1.0

[BHS]

Hi;
Xenporta Addon?

 

[Diablotic]

Is it possible to disable auto refreshing?

 

[ARSamo]

un-installed......... because of loading alot...

 

[ashkir]

This is causing quite some load on our server. He's the log:

1. SELECT thread.*
   ,
   GREATEST(COALESCE(thread_read.thread_read_date, 0), COALESCE(forum_read.forum_read_date, 0), 1339365262) AS thread_read_date,
   node.node_id AS forum_id, node.title AS forum_title
   FROM xf_thread AS thread
   
   LEFT JOIN xf_thread_read AS thread_read ON
   (thread_read.thread_id = thread.thread_id
   AND thread_read.user_id = 11280)
   LEFT JOIN xf_forum_read AS forum_read ON
   (forum_read.node_id = thread.node_id
   AND forum_read.user_id = 11280)
   INNER JOIN xf_node AS node ON
   (node.node_id = thread.node_id)
   INNER JOIN xf_forum AS forum ON
   (forum.node_id = thread.node_id)
   WHERE (1=1) AND (thread.node_id IN ('1', '2', '267', '293', '294', '298', '295', '297', '296', '299', '268', '271', '269', '272', '270', '273', '278', '280', '279', '274', '276', '275', '277', '302', '300', '301', '281', '288', '291', '283', '289', '282', '290', '284', '285', '286', '3', '8', '9', '10', '11', '4', '5', '6', '7', '17', '19', '20', '18', '12', '13', '14', '16', '21', '60', '61', '22', '23', '27', '26', '25', '28', '24', '29', '30', '31', '32', '34', '33', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '47', '53', '49', '48', '50', '54', '51', '52', '46', '55', '56', '57', '58', '59', '121', '122', '123', '124', '125', '126', '136', '127', '128', '129', '130', '133', '132', '131', '134', '135', '250', '256', '257', '260', '261', '258', '259', '254', '255', '251', '252', '253', '262', '265', '266', '263', '264', '382', '383', '384', '386', '387', '388', '389', '391', '390', '385', '392', '394', '393', '395', '396', '397', '398', '399', '400', '401', '402', '90', '91', '92', '94', '93', '95', '96', '97', '100', '98', '99', '101', '102', '103', '104', '105', '106', '107', '110', '108', '109', '115', '120', '117', '116', '118', '119', '137', '194', '218', '219', '220', '221', '222', '225', '226', '223', '224', '178', '179', '180', '182', '183', '184', '185', '186', '187', '188', '189', '190', '191', '192', '181', '193', '214', '215', '216', '217', '195', '205', '208', '210', '207', '209', '206', '197', '198', '199', '200', '201', '202', '203', '204', '211', '212', '213', '196', '227', '249', '228', '231', '230', '232', '236', '235', '234', '233', '237', '229', '238', '239', '240', '241', '242', '243', '244', '245', '246', '248', '247', '138', '161', '162', '163', '164', '165', '148', '149', '150', '151', '152', '156', '157', '158', '159', '160', '143', '144', '145', '146', '147', '142', '155', '154', '153', '139', '166', '167', '168', '169', '170', '171', '172', '141', '140', '303', '330', '304', '305', '306', '307', '308', '309', '342', '343', '344', '345', '346', '347', '310', '321', '322', '323', '324', '325', '326', '327', '328', '329', '312', '313', '314', '315', '316', '317', '318', '319', '320', '311', '331', '332', '333', '334', '335', '336', '337', '338', '339', '340', '341', '354', '362', '364', '368', '365', '366', '367', '363', '355', '369', '372', '370', '375', '371', '373', '374', '376', '377', '378', '379', '380', '381', '356', '358', '359', '360', '361', '357', '62', '63', '65', '66', '67', '64', '68', '87', '86', '88', '69', '70', '72', '71', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '83', '84', '85'))
   ORDER BY thread.post_date DESC
   LIMIT 5
   Run Time: 0.539675
   Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
   SIMPLE node ALL PRIMARY 312 Using where; Using temporary; Using filesort
   SIMPLE thread ref node_id_last_post_date,node_id_sticky_last_post_date node_id_last_post_date 4 rpg_xen.node.node_id 47
   SIMPLE thread_read eq_ref user_id_thread_id,thread_id user_id_thread_id 8 const,rpg_xen.thread.thread_id 1
   SIMPLE forum_read eq_ref user_id_node_id,node_id user_id_node_id 8 const,rpg_xen.thread.node_id 1
   SIMPLE forum eq_ref PRIMARY PRIMARY 4 rpg_xen.node.node_id 1 Using index

Edit more errors:
Template Errors: ******AdvStats_option_sections

1. Illegal string offset 'title' in /home/rpgdir/public_html/library/XenForo/Template/Abstract.php(265) : eval()'d code, line 68:
   67: ';
   68: $__compilerVar7 .= XenForo_Template_Helper_Admin::textBox(htmlspecialchars($fieldPrefix) . '[' . htmlspecialchars($preparedOption['option_id']) . '][' . htmlspecialchars($__compilerVar5) . '][title]', htmlspecialchars($__compilerVar6['title']), array(
   69: 'placeholder' => 'Title' . ' (' . 'Optional' . ')',
2. Illegal string offset 'type' in /home/rpgdir/public_html/library/XenForo/Template/Abstract.php(265) : eval()'d code, line 80:
   79: $__compilerVar8 = XenForo_Template_Helper_Admin::mergeOptionArrays($__compilerVar8, $availableSections, false);
   80: $__compilerVar7 .= XenForo_Template_Helper_Admin::select(htmlspecialchars($fieldPrefix) . '[' . htmlspecialchars($preparedOption['option_id']) . '][' . htmlspecialchars($__compilerVar5) . '][type]', htmlspecialchars($__compilerVar6['type']), $__compilerVar8, array(
   81: 'inputclass' => '******AdvStats_OptionSectionsSelect'
3. Illegal string offset 'forum_id' in /home/rpgdir/public_html/library/XenForo/Template/Abstract.php(265) : eval()'d code, line 89:
   88: $__compilerVar9 = XenForo_Template_Helper_Admin::mergeOptionArrays($__compilerVar9, $forums, false);
   89: $__compilerVar7 .= XenForo_Template_Helper_Admin::select(htmlspecialchars($fieldPrefix) . '[' . htmlspecialchars($preparedOption['option_id']) . '][' . htmlspecialchars($__compilerVar5) . '][forum_id]', htmlspecialchars($__compilerVar6['forum_id']), $__compilerVar9, array());
   90: unset($__compilerVar9);

Template Errors: ******AdvStats_option_sections

1. Illegal string offset 'title' in /home/rpgdir/public_html/library/XenForo/Template/Abstract.php(265) : eval()'d code, line 68:
   67: ';
   68: $__compilerVar7 .= XenForo_Template_Helper_Admin::textBox(htmlspecialchars($fieldPrefix) . '[' . htmlspecialchars($preparedOption['option_id']) . '][' . htmlspecialchars($__compilerVar5) . '][title]', htmlspecialchars($__compilerVar6['title']), array(
   69: 'placeholder' => 'Title' . ' (' . 'Optional' . ')',
2. Illegal string offset 'type' in /home/rpgdir/public_html/library/XenForo/Template/Abstract.php(265) : eval()'d code, line 80:
   79: $__compilerVar8 = XenForo_Template_Helper_Admin::mergeOptionArrays($__compilerVar8, $availableSections, false);
   80: $__compilerVar7 .= XenForo_Template_Helper_Admin::select(htmlspecialchars($fieldPrefix) . '[' . htmlspecialchars($preparedOption['option_id']) . '][' . htmlspecialchars($__compilerVar5) . '][type]', htmlspecialchars($__compilerVar6['type']), $__compilerVar8, array(
   81: 'inputclass' => '******AdvStats_OptionSectionsSelect'
3. Illegal string offset 'forum_id' in /home/rpgdir/public_html/library/XenForo/Template/Abstract.php(265) : eval()'d code, line 89:
   88: $__compilerVar9 = XenForo_Template_Helper_Admin::mergeOptionArrays($__compilerVar9, $forums, false);
   89: $__compilerVar7 .= XenForo_Template_Helper_Admin::select(htmlspecialchars($fieldPrefix) . '[' . htmlspecialchars($preparedOption['option_id']) . '][' . htmlspecialchars($__compilerVar5) . '][forum_id]', htmlspecialchars($__compilerVar6['forum_id']), $__compilerVar9, array());
   90: unset($__compilerVar9);

 

[Flexin]

Are people still having issues with server loads? I really want this add on but if it causes problems too much of a load I might not bother. My site isn't that busy so it shouldn't be a problem now but I don't want it to be an issue down the road.

James

 

[luutruong]

Are people still having issues with server loads? I really want this add on but if it causes problems too much of a load I might not bother. My site isn't that busy so it shouldn't be a problem now but I don't want it to be an issue down the road.

James

hi..this oldest version...
you can find it
http://xenforo.com/community/threads/******-advanced-forum-statistics.33580/page-3#post-388318
that is newest version and fix your error

 

[Flexin]

hi..this oldest version...
you can find it
http://xenforo.com/community/threads/******-advanced-forum-statistics.33580/page-3#post-388318
that is newest version and fix your error

Thanks.

James

 

[vkams]

you can find it
http://xenforo.com/community/threads/******-advanced-forum-statistics.33580/page-3#post-388318
that is newest version and fix your error

This topic was deleted. Can anyone send me this or other statistics mod?

 

[Sukrams]

When there are moderated threads, which aren't active, they are shown. I think it is better, that only users can see them, when they are active.

 

[HWS]

We use a custom made statistics mod at our large forum which is fully cached and therefore server load friendly.

We plan to release it soon as an addon here.

 

[Digital Doctor]

We use a custom made statistics mod at our large forum which is fully cached and therefore server load friendly.

We plan to release it soon as an addon here.

Nice !

 

[Brent W]

We use a custom made statistics mod at our large forum which is fully cached and therefore server load friendly.

We plan to release it soon as an addon here.

Thank you. I really would like this.

 

[raytrails]

We use a custom made statistics mod at our large forum which is fully cached and therefore server load friendly.

We plan to release it soon as an addon here.

Excellent!

 

[Dante_B]

We use a custom made statistics mod at our large forum which is fully cached and therefore server load friendly.

We plan to release it soon as an addon here.

I would love to use this too! I see a 5 star coming up!

 

[Dante_B]

Can we see a demo of this custom addon?

 

[iCafe]

We use a custom made statistics mod at our large forum which is fully cached and therefore server load friendly.

We plan to release it soon as an addon here.

good news.

 

[raytrails]

We use a custom made statistics mod at our large forum which is fully cached and therefore server load friendly.

We plan to release it soon as an addon here.

Any ETA?

 

[FredC]

We use a custom made statistics mod at our large forum which is fully cached and therefore server load friendly.

We plan to release it soon as an addon here.

Any Updates on this?

 

[melbourne]

look forward to the new update. thanks.

 

[aiman.h.kallaf]

is it working with xenforo 1.2 ?