View Full Version : Stats Compilation

October 8th, 2005, 08:47 AM
Hi there,

This looks like a very nice application and I consider purchasing it for my own site. However I appreciate if a dev can first answer these questions: :)

1- How is the stats info in the main page compiled? Datastore or query?
> Categories: 84, Images: 508, Posts: 201, Total Views: 71,074, Total Disk Space: 57.22 MB

2- What's query count of gallery main page?

3- What's the technical method of compiling random images from DB in the main page? Do you use MYSQL's RAND() function inside the query or method?

4- Do you have any members gallery which is using microstats hack that I can check? Or maybe you can copy paste such a gallery's microstats here together with same site's forum home microstats info?

5- Can I see any "large" member galleries that is using this application? What are their image count? Any URLs?

6- How is image searching is handled? MYSQL Full text? Keyboard recording in seperate tables (like vb method) or directly search in image table fields for the given keywords?

7- How is email updates for images are handled? Instant like vb2 type or scheduled like vb3 type?

8- When I click a linked keyword on image pages, I get "You must choose a category to search in!". Is this normal or bug?

9- Go to http://www.vbadvanced.com/gallery/upload.php select an image and category then enter "'"^$4%7/"><ğşi'!>`}{\?*" for the rest of the fields like name, description, keywords. When you submit the image, it goes back to same page without any warnings or messages? Normal or bug? (same does NOT happen in quick upload links inside categories. eg. http://www.vbadvanced.com/gallery/browseimages.php?c=96)

10- Does "subscription to categories" have any mail update features?

11- Does 3.5 version require any vb code modifications?

12- Does it support vb phrase system for other languages or are the phrases embedded inside templates?

Thank you in advance, :)

October 8th, 2005, 12:38 PM
Hey Logician, good to see you over here. :)

1). Categories, images, and posts are calculated from the totals shown on the category bits above that section (pretty much the same method vB uses on the forum home stats). Then the total views and diskspace are calculated with queries.
2). That depends on which features you have active (stats, new images, random images, etc). With all features active, I belive the query count is around 10.
3). Yes, the RAND() command is used in the query. I know that's not exactly the best method, but I've yet to be able to think of a better one that will easily work in all situations.
4). I'm sure there are some out there, but I'm not aware of one off the top of my head. Here's a few from my personal site though:

index.php - Page generated in 0.59135 seconds with 8 queries, spending 0.0058779716491699 doing MySQL queries and 0.58547202835083 doing PHP things. (Note that's also with 200+ categories all displayed on the main page. If I change the depth option so that only about 5 categories are displayed the load time is down to 0.15287. This is with the stats section active, but no new or random images.)

browseimages.php - Page generated in 0.29186 seconds with 12 queries, spending 0.0074465274810791 doing MySQL queries and 0.28441347251892 doing PHP things.

showimage.php - Page generated in 0.28080 seconds with 10 queries, spending 0.0091509819030762 doing MySQL queries and 0.27164901809692 doing PHP things.

upload.php - Page generated in 0.20745 seconds with 7 queries, spending 0.0089511871337891 doing MySQL queries and 0.19849881286621 doing PHP things.

If you'd like the stats from any other pages just let me know.

5). http://www.trackpads.com/media/ - Categories: 1,186, Images: 331,367, Posts: 1,945

6). MySQL fulltext.

7). Instant more like vB2 for posts and such. Subscribed category emails are sent once a day with a cron script.

8). That's a known bug that popped up in the vB 3.5 version. There's a simple fix posted in the bugs forum here. I suppose I should fix that on the demo, but I usually try to leave those files as default.

9). Actually that may be a bug... I have an on going support ticket with another user here who says some of her users are experiencing similar problems, but I've yet to be able to reproduce it or figure out the exact cause. I just tried uploading an image using the same text you posted using IE and FireFox, but they went through fine. Is it only doing that to you when you enter characters like that in the input fields? What browser/OS are you using?

10). Yes. Once a day (assuming there were new images/posts made) an email will be sent to subscribers telling them what new images/posts have been made.

11). No. There are a couple of optional file modifications to group the templates and add the options to the modcp, but even those can be done with the plugin system now (just haven't updated things yet).

12). With the exception of the install file, everything is fully phrased in the vB phrase system.

October 8th, 2005, 05:50 PM
Hi Brian,

Thanks for the info. It sounds like a great application. I guess I'll purchase it after I ported to 3.5. :)

Here is some comments and suggestions if you are interested:

1- It would be perfect if you can tie view count to a vb cron as this proves to be server intensive when traffic is high and columns to count are many. A vb cron that can run in every 10 min. and store it in datastore will help dramatically.

2- Query count sounds great!

3- Same suggestion applies for RAND(). It is too server intensive when number of applications are a lot. You can again create a cron and compile random images in a datastore in every 5-10 minutes or so.

4- Stats look very nice!

5- Was down for upgrade. I'm eager to check it out when it is back up..

6- Nice to hear!

7- Making scheduled would be excellent but I guess this wouldn't hurt either

9- Happens when I enter "^$4%7/"><ğşi'!>`}{\?*" into Image Title. It happens when I only enter ş to title section.

I have it even if I didn't select a category and it text is so, not selecting a category does not die with error. So check your code in part before category selection conditional. It sounded like an escape issue to me.

10-11-12- Perfect!

Thanks! :)