vb.org Archive
Page 32 of 182 « First 223031 32 33344282132 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - Video-Directory Remixed (https://vborg.vbsupport.ru/showthread.php?t=200819)

erinys 01-22-2009 07:08 AM
Hi,

great mod, will you keep this alive towards vb4? no use in it for me to make my members happy with something that will pass thats why i generally choose payed addons.. But this one is really cool so thats why i am asking.

thanks

TCB 01-22-2009 08:16 PM
How come this mod uses so many queries?

video.php?do=viewcategory&categoryid=10 (1 video) takes 9 queries
video.php?do=viewcategory&categoryid=12 (17 videos) takes 25 queries (!?)

you'd think the amount of shown videos in a category would be 'query independant'? For example: when I set the amount of videos to be shown in the vbadvance video directory module from 3 to (for example) 6 videos, it has no influence on the amount of queries for that page. Shouldn't it be cached or something?

When many people browse through the video directory at a particular moment, it really stresses the server.

ArnyVee 01-22-2009 08:19 PM
TCB, how do you determine how much each video takes as far as queries? I'd like to compare how things are running on my site as well.

TCB 01-22-2009 08:41 PM
Quote:
Originally Posted by ArnyVee (Post 1721533)
TCB, how do you determine how much each video takes as far as queries? I'd like to compare how things are running on my site as well.
Just install the microstats mod (https://vborg.vbsupport.ru/showthrea...ght=microstats). Although it says it's for vb3.6, it still works like a charm on vb3.8 :D

tormodg 01-23-2009 12:28 AM
Is there an easy way to get the vB or the vBSEO social bookmarking features to display in this hack? Particularly on each video page.

Jaxel 01-23-2009 06:05 AM
Quote:
Originally Posted by TCB (Post 1721528)
How come this mod uses so many queries?

video.php?do=viewcategory&categoryid=10 (1 video) takes 9 queries
video.php?do=viewcategory&categoryid=12 (17 videos) takes 25 queries (!?)

you'd think the amount of shown videos in a category would be 'query independant'? For example: when I set the amount of videos to be shown in the vbadvance video directory module from 3 to (for example) 6 videos, it has no influence on the amount of queries for that page. Shouldn't it be cached or something?

When many people browse through the video directory at a particular moment, it really stresses the server.
The extra query for each video has to do with the taglist. For each video bit, it has to query the tags on that video. The amoutn of shown videos in the category, IS query independant. However, the scan for tags for each video is not; the amount of tags on each video however, is query independant as well. The reason why this extra query per video is not in the vbadvanced/forumhome mod is because they dont query the tags.

TCB 01-23-2009 06:54 AM
so when tags are disabled showing the list of videos in a category should use much, much queries?

The list of videos in a category is pretty much static untill a new video is added to that category. So why not cache the page? Pulling the data from the database each and everytime someone browse through the videos seems overkill to me.

Perhaps you can contact a developer like thegeek. With his GARS mod, you get to see an icon, description and keywords in the listing of articles (pretty much the same idea as your great mod, but with articles instead of videos), and with his listing just about 9 queries are run (and that's when over 20 articles/icons/descriptions/keywords/authors are shown).

kapwanero 01-23-2009 05:35 PM
Help me pleaseeeee!!!


Error report:
Code:
Database error in vBulletin 3.8.0:

Invalid SQL:

                SELECT user.*, COUNT(video.videoid) AS videocount
                FROM video AS video
                LEFT JOIN user AS user ON(user.userid = video.userid)
                WHERE NOT ISNULL(user.userid)
                GROUP BY video.userid
                ORDER BY videocount DESC
                LIMIT a;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a' at line 7
Error Number  : 1064
Request Date  : Friday, January 23rd 2009 @ 08:22:24 PM
Error Date    : Friday, January 23rd 2009 @ 08:22:24 PM
Script        : http://www.xxxx.com/forum/video.php
Referrer      :
IP Address    : 88.xxx.xxxx.134
Username      : xxxx
Classname    : vB_Database
MySQL Version : 5.0.58

Marka Ragnos 01-23-2009 05:39 PM
<a href="http://www.kustmijnkloten.be/forum/video.php" target="_blank">http://www.kustmijnkloten.be/forum/video.php</a>

nice work Jaxel!

Jaxel 01-23-2009 06:24 PM
================================================== =========
Version 1.2.2
================================================== =========
  • Changed the way the video taglists are called on the summary pages...
    • Taglists are now cached! This will save your server from being overloaded.
    • The summary taglist cache is rebuild on every video details view.
    • Be sure to run MAINTENANCE > UPDATE COUNTERS > REBUILD VIDEO TAGS
  • More miscellaneous changes to video hosters... Added support for VEOH as a Video Hoster.
  • FILE EDITS SINCE 1.2.0: (make sure you upload these new versions!)
    • upload/video.php
    • upload/includes/class_dm_video.php
    • upload/includes/functions_videodirectory.php
    • upload/includes/functions_videotags.php
    • upload/includes/xml/videohoster-Dailymotion.xml
    • upload/includes/xml/videohoster-Metacafe.xml
    • upload/includes/xml/videohoster-YouTube.xml
    • upload/includes/xml/videohoster-YouTubeHD.xml
    • upload/includes/xml/videohoster-Veoh.xml


All times are GMT. The time now is 09:19 PM.
Page 32 of 182 « First 223031 32 33344282132 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01639 seconds
  • Memory Usage 1,748KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete