vb.org Archive
Page 4 of 6 « First 23 4 56
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBDownload Area 1.1 (https://vborg.vbsupport.ru/showthread.php?t=75071)

StevenIsProek 01-26-2005 11:15 AM
cant wait for 1.2. I need those sub catergories badly :)

Getox 01-26-2005 11:32 AM
Quote:
Originally Posted by StevenIsProek
cant wait for 1.2. I need those sub catergories badly :)
Well thats the next thing ill do on the TODO list, Just for you.

MrD 01-26-2005 12:24 PM
Hi,
is it possible, that the Area read out directorys?
I mean, i will upload files with any extension (rar,zip,pdf) via ftp to a directory (name of category/Subcategory) and the script shows the files.

Sorry for my bad english :)

I think, thats save Time by uploading an Editing files/Descriptions.

winlya 01-26-2005 12:39 PM
much support ^_^.
This is great hack.Waiting 1.2,1.3 and more ^_^
Thanks for support man.

Getox 01-26-2005 12:43 PM
Quote:
Originally Posted by MrD
Hi,
is it possible, that the Area read out directorys?
I mean, i will upload files with any extension (rar,zip,pdf) via ftp to a directory (name of category/Subcategory) and the script shows the files.

Sorry for my bad english :)

I think, thats save Time by uploading an Editing files/Descriptions.
I could try that for 1.3.
@winlya: No problem :)

MrD 01-26-2005 05:27 PM
Hi,
fine, i wait for 1.3 :)

But, if you would like tester, i help you :)

Kent100 01-26-2005 07:01 PM
Quote:
Database error in vBulletin 3.0.6:

Invalid SQL: DELETE FROM template WHERE title like LCASE('downloads_%')
mysql error: Table 'usr_webxxx_x.template' doesn't exist

mysql error number: 1146
:disappointed: :disappointed:

Getox 01-26-2005 10:27 PM
Quote:
Originally Posted by Kent100
:disappointed: :disappointed:
In the installer look for that query "DELETE FROM template" and remove it and try that again.

If it dont work ill post a diff installer.

Ron1n 01-27-2005 06:00 PM
PHP Code:
    while ($file = $DB_site->fetch_array($files))
    {
    $countcomments = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "dl_coms WHERE fileid='" . addslashes($file[id]) . "'");
    $comments = mysql_num_rows($countcomments);
        eval('$filebits .= "' . fetch_template('downloads_filebit') . '";');
    } 
If you have 25 files in a category you will run 50+ queries on this page... this will eat up a TON of cpu.

If you cache download_filebit you can knock out 25 queries, but they arent the important ones. (Note: im not 100% sure that it doesnt cache the template after fetching it once, but I had this problem with a hack I made last year)

The query to select the comments per file will take a long time unless you create an index by the file's id, and even then it will be very poor performance.

You have a lot of performance issues. If you want, I can help you. My download mod has virtually no performance issues except on upload/edit/delete (which occures infrequently that it is not a factor). It actually runs fewer queries than the average vB forum page. My msn it ronin at elitecoders dot org.

BamaStangGuy 01-27-2005 07:29 PM
He didn't copy your hack

Get over yourself


All times are GMT. The time now is 07:00 AM.
Page 4 of 6 « First 23 4 56
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.02182 seconds
  • Memory Usage 1,740KB
  • 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_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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