vb.org Archive - Looking Up Posts Per Page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Looking Up Posts Per Page (https://vborg.vbsupport.ru/showthread.php?t=309706)

ShannonA

03-19-2014 06:56 PM

Looking Up Posts Per Page

I'd like to look up what percentage of our readers are viewing more than 10 posts per page on our forums. How to do so (presumably from within MySQL)?

Thanks!

Seven Skins

03-19-2014 10:22 PM

Try this query:

Code:

SELECT * FROM `user` WHERE `maxposts` > 10;

ShannonA

03-19-2014 10:53 PM

Well, that's unexpectedly easy. My eyes must have just passed right over that field. Thanks!

For anyone curious, the answer is 4% of our registered users, though I bet it's higher for active users.

All times are GMT. The time now is 08:51 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01594 seconds Memory Usage 1,706KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: