vb.org Archive - Major Additions

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

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Major Additions - DownloadsII (https://vborg.vbsupport.ru/showthread.php?t=120122)

Quote:

Originally Posted by maidos (Post 1324590)

my PHP Maximum Upload Size 350.00 MB

but i still fail to upload ?files over 20 mb
running a dedicated server with centos 5 as server os

i have created.htaccess on the same directory as download.php
and used this

php_value upload_max_filesize 30M
php_value post_max_size 30M

but i still failed to upload files over 20 mb

If it's a dedicated server, you can try changing your php.conf also :)
Maybe AllowOverride is set to None in your httpd.conf (Apache webserver), so .htaccess files don't work?

Quote:

Originally Posted by AScherff (Post 1324640)

Hi,

i have these database error when a user try to upload a new version of the download:

Code:

Datenbankfehler in vBulletin 3.6.7:



Invalid SQL:

SELECT title, usergroup.usergroupid, username, userid

                           FROM knxusergroup, knxuser

                           WHERE ecdownloadpermissions & 1024 AND  usergroup.usergroupid = user.usergroupid;



MySQL-Fehler : Unknown table 'usergroup' in field list

The error comes because the Table-Prefix is not all set

The right SQL Statement must be:

Code:

SELECT title, knxusergroup.usergroupid, username, userid

                           FROM knxusergroup, knxuser

                           WHERE ecdownloadpermissions & 1024 AND  knxusergroup.usergroupid = knxuser.usergroupid;

so how can i fix that?

Thanks

Alfred

This is a vBulletin generated query as we don't have our own query like that. We just use the standard usergroup permissions request code and vBulletin uses this kind of code to set up the permissions.
Have you correctly updated your installation? So you have uploaded all files to your forum FTP folder and you have imported the product file (with overwrite option ON)?

Quote:

Originally Posted by maidos (Post 1324647)

i would like to bring up a suggestion, please make it so ppl can upload on ftp so once its done maybe on admin cp or somewhere will tell the staff that soemone uploaded the file and let the staff put it on a category

There's already an FTP feature: you can upload files to a folder and mass import them using the DownloadsII import page in the AdminCP.
You can also use the moderation queue to let members add files.

Quote:

Originally Posted by cOuNtErFiET (Post 1325038)

For some reason im getting this error when trying to delete a file, and im the GOD admin, also all my other admins are getting this too...how can i fix this?

Maybe you did a server move or something like that? Check the chmod of the downloads folder (should be 777, full permissions) and what is the chmod value of the uploaded files in the downloads folder?

Quote:

Originally Posted by RS_Jelle (Post 1325075)

IThis is a vBulletin generated query as we don't have our own query like that. We just use the standard usergroup permissions request code and vBulletin uses this kind of code to set up the permissions.
Have you correctly updated your installation? So you have uploaded all files to your forum FTP folder and you have imported the product file (with overwrite option ON)?

Hmmm...

all other querys working well, also if the User uploads the first time.

I installed your Mod as new (with overwritten), having a look whats happen...

Thanks

Why do files still come up unapproved?

Quote:

Originally Posted by AScherff (Post 1325294)

Hmmm...

all other querys working well, also if the User uploads the first time.

I installed your Mod as new (with overwritten), having a look whats happen...

Thanks

On which page are you getting the error?
Can you eventually pm me the username/password of a test account on your site (normal user account), so I can check it out?

Quote:

Originally Posted by Mrdby (Post 1325438)

Why do files still come up unapproved?

There's a "Can Avoid Moderation Queue" usergroup setting to choose this behavior.

We just released version 5.0.5, which fixes some urgent security issues and includes bugfixes for all known bugs. We advise you to update immediately. For update instructions, read the Readme-Install.txt.

Changelog DownloadsII 5.0.5

CyberRanger

Fixed mixed sort order of files on import page

Jelle

Fixed hardcoded "Category" phrase in the Manage Files option
Changed category abbrevation in Manage Files to the full category name in the category dropdown windows
Updated optional navbar edit as the code to search changed slightly since vBulletin 3.6.7
Fixed problem with multiple pages being empty for the file manager (caused when you have an empty approval value)
Improved the downloads log with time and ip address information (+ some link and layout changes)
Fixed the fact that everyone with upload permissions could upload to every file, now you need to be the file author or need to have editall permissions
Fixed the update counters function which didn't recount the comment amounts (the comment stats were only resetted to 0)
Fixed XSS security issue with the optional downloads profile info
Added xmlns attribute to the html tag of the DOWNLOADS template
Fixed SQL injection security issues with category sorting and the assign uploader page
Fixed wrong conditions for displaying the assign uploader link
Fixed XSS security issues with unclean category and file id's in the templates
Fixed some other bugs and removed some redundant checks

Quote:

Originally Posted by RS_Jelle (Post 1326154)

Fixed mixed sort order of files on import page

Jelle

Fixed hardcoded "Category" phrase in the Manage Files option
Changed category abbrevation in Manage Files to the full category name in the category dropdown windows
Updated optional navbar edit as the code to search changed slightly since vBulletin 3.6.7
Fixed problem with multiple pages being empty for the file manager (caused when you have an empty approval value)
Improved the downloads log with time and ip address information (+ some link and layout changes)
Fixed the fact that everyone with upload permissions could upload to every file, now you need to be the file author or need to have editall permissions
Fixed the update counters function which didn't recount the comment amounts (the comment stats were only resetted to 0)
Fixed XSS security issue with the optional downloads profile info
Added xmlns attribute to the html tag of the DOWNLOADS template
Fixed SQL injection security issues with category sorting and the assign uploader page
Fixed wrong conditions for displaying the assign uploader link
Fixed XSS security issues with unclean category and file id's in the templates
Fixed some other bugs and removed some redundant checks

hmmm was the first..lets see..Thanks!

Uploaded all files...imported prduct...allowed overwrite...CHMOD 777 for downloads directory...followed directions to a tee...

The changelog bug that was supposed to be fixed:

* Fixed problem with multiple pages being empty for the file manager (caused when you have an empty approval value)

That bug still exists...

BTW...this was done following the upgrade info in the .txt file attached in your download as I already had the previous version installed.

Quote:

Originally Posted by Saviour (Post 1326198)

Strange, it's working for me with version 5.0.5 :(
Any other people to confirm this?

I have 57 files in 18 categories...20 files show on page one all approved...

The page menu at the bottom of the first Manag Files page shows three pages, however, when I click on page two there are no files listed...just the Downloads navigation menu and options to pin, category, approval, etc., etc...but no files.

This is the shortcut to page 2:

http://www.saviour-pc.com/forums/dow...roval=0&page=2

This is the shortcut to page 3:

http://www.saviour-pc.com/forums/dow...roval=0&page=3

Apparently it must be an approval thing, because that part of the link is showing "0".

Any suggestions here?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04599 seconds Memory Usage 1,767KB 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 (2)bbcode_code_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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
Messages: