vb.org Archive

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)

RS_Jelle 08-24-2007 10:21 PM

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?

AScherff 08-25-2007 07:25 AM

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

Mrdby 08-25-2007 02:58 PM

Why do files still come up unapproved?

RS_Jelle 08-26-2007 06:11 PM

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.

RS_Jelle 08-26-2007 06:17 PM

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

Mrdby 08-26-2007 06:23 PM

Quote:

Originally Posted by RS_Jelle (Post 1326154)
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

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

MB-Soft 08-26-2007 06:44 PM

Great, Thanks! :)

Saviour 08-26-2007 07:17 PM

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.

RS_Jelle 08-26-2007 07:37 PM

Quote:

Originally Posted by Saviour (Post 1326198)
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.

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

Saviour 08-26-2007 07:58 PM

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?

Andyrew 08-26-2007 08:06 PM

Quote:

Originally Posted by RS_Jelle (Post 1326211)
Strange, it's working for me with version 5.0.5 :(
Any other people to confirm this?

It's working for me now since i upgraded. :)

CyberRanger 08-26-2007 08:09 PM

Quote:

Originally Posted by Andyrew (Post 1326232)
It's working for me now since i upgraded. :)

me too! :)

Saviour 08-26-2007 08:13 PM

I ran the installation one more time and now its working...that was totally strange...

Deadly Assassin 08-26-2007 08:22 PM

Brilliant, thanks alot.

:D

Works like a charm

bigevil 08-26-2007 08:34 PM

Question:

If I am updating from 5.0.4 to 5.0.5 what do I need to do? Dont want to crash my database... I havent updated DownloadsII before and you dont have anything written about how to do so.

Thanks.

y2krazy 08-26-2007 08:57 PM

A more friendly Member's Files in MEMBERINFO:

You'll need to change $vbphrase[ecdownloads_member_files] to the following:

Code:

{1}'s Files

New downloads_memberfiles template:

Code:

<br />
$navigation
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
        <tr>
                <td class="tcat" colspan="3"><phrase 1="$userinfo[username]">$vbphrase[ecdownloads_member_files]</phrase></td>
        </tr>
        <tr>
                <td class="thead">{$vbphrase['ecdownloads_file']}</td>
                <td class="thead">{$vbphrase['ecdownloads_description']}</td>
                <td class="thead">{$vbphrase['date']}</td>
                <td class="thead">{$vbphrase['ecdownloads_downloads']}</td>
        </tr>
        $filebits
</table>
$navigation


RS_Jelle 08-26-2007 09:11 PM

Quote:

Originally Posted by bigevil (Post 1326248)
Question:

If I am updating from 5.0.4 to 5.0.5 what do I need to do? Dont want to crash my database... I havent updated DownloadsII before and you dont have anything written about how to do so.

Thanks.

It's all described in the included Readme-Install.txt ;)
But in fact it's even easier as there aren't any usergroup or setting changes. In fact you just need to upload and overwrite all existing PHP files and import the new product (with the overwrite option set to Yes).

If you really want to be sure, you can disable DownloadsII with the settings for more security (avoiding table corruption). But it's really secure, you can't delete your database with it (except when you click the uninstall button).

RedGTiVR6 08-26-2007 10:14 PM

File is corrupt..it's only showing up as being 57k in size once downloaded.

Anyone else have this problem?

Black Tiger 08-26-2007 10:25 PM

Not me, I've just updated and all went just fine.

However I've got a question now. Can users also see and use the "Category tree"?

Before it had a nicer layout, and now some information is added which I don't like my users to view:
Quote:

Dreambox [Category ID is 2]
Why is that Category ID put there? My users don't need to know that.

Furthermore the Category tree is all lined up left-sided.
For example:
Dreambox
-firmware
-settings
-tools

It would look a lot nicer if subcategory's would jump in a little bit, for example
Dreambox
-firmware
-settings
-tools
Is that possible? Ofcourse whithout the white space between Dreambox (so Category) and the subcategory. The indent caused that in this message.

RS_Jelle 08-26-2007 10:43 PM

Hmm, the category tree wasn't changed in version 5.0.5, really :p

All users who can access DownloadsII (can view files), can view the category tree. The category id info between brackets is only shown to users with "Can edit all files" permissions.

The layout change you suggest isn't possible without changing the PHP code as it's using the construct_select_array() function, which is also used for the category select dropdown menus.

Black Tiger 08-26-2007 10:58 PM

Quote:

Originally Posted by RS_Jelle (Post 1326310)
Hmm, the category tree wasn't changed in version 5.0.5, really :p

Ah oke, I thought it had a different look before. I must have been mistaken.

Quote:

The category id info between brackets is only shown to users with "Can edit all files" permissions.
Thanks, my worry's are gone then, I thought all users could see that.

But... what's the benefit of displaying the category id to the users with the edit permissions?

asw 08-27-2007 12:29 AM

Hello and thank you for this great hack!

I've just updated from the previous version and after uploading 'test' files and on the redirect I receive the following error:

Parse error: syntax error, unexpected '<' in /home/XXXXX/XXXXX/forums/downloads.php(1179) : eval()'d code on line 1

The 'test' files upload just fine but would like to fix the error message.

Your help is appreciated. :up:

Zia 08-27-2007 01:58 AM

thnx for very prompt action :)

really love downloadsII :)

would love to see v.6 :P

LilSniper 08-27-2007 02:13 AM

Quote:

Originally Posted by LilSniper (Post 1312300)
The picture illustrated below is how I want my Download Center to look. What you see is the main menu of the system.

However, when I click on one of the categories and leave the main menu, this is what happens:

I guess VBulletin.org resized my image, so what I wrote is difficult to see. The red arrows are pointing at what I think is the problem. The red writing says: "take a look at the black line which the arrows are pointing at. could this be the problem?"

Any suggestions? Thanks in advance.

Quote:

Originally Posted by RS_Jelle (Post 1322493)
Hmm, how have you set the "Display "Tops" on all pages?" option?
Is it possible that you modified some of the DownloadsII templates and/or the downloads.php file?

I tried changing the display tops on all pages to both yes and no, and neither worked. My friend uploaded it for me, but I doubt that he did. I'll ask him though.

maidos 08-27-2007 06:13 AM

i alllways get this error when i triedto import files via ftp

Warning: opendir(/home/zetaf/public_html/forums/uploads/3x3_eyes/3x3_eyes_v02.zip) [function.opendir]: failed to open dir: No such file or directory in /admincp/downloadadmin.php on line 290

RS_Jelle 08-27-2007 07:13 AM

Quote:

Originally Posted by Black Tiger (Post 1326316)
But... what's the benefit of displaying the category id to the users with the edit permissions?

The category tree was a requested feature once. I also don't use :)

Quote:

Originally Posted by asw (Post 1326353)
Hello and thank you for this great hack!

I've just updated from the previous version and after uploading 'test' files and on the redirect I receive the following error:

Parse error: syntax error, unexpected '<' in /home/XXXXX/XXXXX/forums/downloads.php(1179) : eval()'d code on line 1

The 'test' files upload just fine but would like to fix the error message.

Your help is appreciated. :up:

Hmm, on line 1179 there's a hook location. Which DownloadsII add-ons are you using?

Quote:

Originally Posted by LilSniper (Post 1326404)
I tried changing the display tops on all pages to both yes and no, and neither worked. My friend uploaded it for me, but I doubt that he did. I'll ask him though.

We released version 5.0.5, try upgrading to that version first. Also try the "Update counters" feature, maybe that helps.
Have you set any of the "Number of "xxx" to Display" settings to 0 or made a typo there?

Quote:

Originally Posted by maidos (Post 1326516)
i alllways get this error when i triedto import files via ftp



Warning: opendir(/home/zetaf/public_html/forums/uploads/3x3_eyes/3x3_eyes_v02.zip) [function.opendir]: failed to open dir: No such file or directory in /admincp/downloadadmin.php on line 290

You need to specify a folder to import (multiple) files from. For example /home/zetaf/public_html/forums/uploads/3x3_eyes/ if it exists.
For adding one file, you better use the Add button on the public pages of the downloads section.

maidos 08-27-2007 10:22 AM

i think theres a bug on yourscript,, i followed ur instruction and added a folder instead however once i done that

Latest Files
Latest Files


Most Popular Files
Most Popular Files


Top Contributors
Top Contributors

Latest Files
Latest Files


Most Popular Files
Most Popular Files


Top Contributors
Top Contributors

i get empty list

when i added the folder path it does say The following files were successfully imported: however i get this error aswell

Warning: Invalid argument supplied for foreach() in /admincp/downloadadmin.php on line 345

also on download page i dont even see the new added folder

maidos 08-27-2007 10:49 AM

my members told me that they get html file instead of zip file :S the zip file is added on mimetype

asw 08-27-2007 11:29 AM

Thanks for your fast reply. I'm not using any Downloads Addons that I'm aware of.

CyberRanger 08-27-2007 11:44 AM

Quote:

Originally Posted by maidos (Post 1326516)
i alllways get this error when i triedto import files via ftp



Warning: opendir(/home/zetaf/public_html/forums/uploads/3x3_eyes/3x3_eyes_v02.zip) [function.opendir]: failed to open dir: No such file or directory in /admincp/downloadadmin.php on line 290

Where is your import directory located and what are you putting for the directory in admincp -> downloads -> import?

CyberRanger 08-27-2007 11:48 AM

Quote:

Originally Posted by asw (Post 1326664)
Thanks for your fast reply. I'm not using any Downloads Addons that I'm aware of.

I would try re-uploading includes/xml/hooks_downloadsII.xml. Maybe it got corrupted when you first copied it to your server from the Downloads product zip file.

CyberRanger 08-27-2007 11:51 AM

Quote:

Originally Posted by maidos (Post 1326638)
i think theres a bug on yourscript,, i followed ur instruction and added a folder instead however once i done that

Latest Files
Latest Files

I think when you use the import function, you have to run "Update Counters" when the import is complete.

Quote:

Originally Posted by maidos (Post 1326638)
i get empty list

when i added the folder path it does say The following files were successfully imported: however i get this error aswell

Warning: Invalid argument supplied for foreach() in /admincp/downloadadmin.php on line 345

also on download page i dont even see the new added folder

I'm not sure what you are saying here. The import will not add a folder. It simply copies files from a folder you select to your downloads folder and puts info in the database about each file. The invalid foreach means you have put in an incorrect import path or a path to a folder that has no files in it.

CyberRanger 08-27-2007 12:00 PM

Quote:

Originally Posted by Black Tiger (Post 1326316)
But... what's the benefit of displaying the category id to the users with the edit permissions?

I think when the catergory id was added, we did so that admin's could easily see the cat id for setting group permissions for specific download categories. Like Jelle said, I don't think it's a feature used much, if any!

Black Tiger 08-27-2007 12:08 PM

Ok thanks both for the explanation.:)

maidos 08-27-2007 12:24 PM

for the path to import i picked /home/zetaf/public_html/forums/uploads/3x3_eyes/
inside the 3x3_eyes i have files there

on the admin cp it says The absolute path to this script is /home/zetaf/public_html/forums/admincp/

asw 08-27-2007 12:28 PM

Quote:

Originally Posted by CyberRanger (Post 1326676)
I would try re-uploading includes/xml/hooks_downloadsII.xml. Maybe it got corrupted when you first copied it to your server from the Downloads product zip file.


Thanks again for your fast reply. I reinstalled the entire Zip fil and the error still shows.

maidos 08-27-2007 12:37 PM

1 Attachment(s)
i think i done everything right since i managed to import the files

CyberRanger 08-27-2007 12:46 PM

Quote:

Originally Posted by maidos (Post 1326689)
i think i done everything right since i managed to import the files

No, the pic shows it did not work. You should have the files listed that were imported. If you want to PM me access to your site (including ftp info) I'll check it out for you.

CyberRanger 08-27-2007 02:18 PM

Quote:

Originally Posted by maidos (Post 1326686)
for the path to import i picked /home/zetaf/public_html/forums/uploads/3x3_eyes/
inside the 3x3_eyes i have files there

on the admin cp it says The absolute path to this script is /home/zetaf/public_html/forums/admincp/

Your import path is incorrect. You have uploads parallel to forums so the correct path is /home/zetaf/public_html/uploads/3x3_eyes/

edit: I did a successful test to confirm: http://aznmedia.net/forums/downloads.php?do=file&id=260

maidos 08-27-2007 04:14 PM

hm im still not able to add other files such as /home/zetaf/public_html/uplloads/AirGear/

note: i have a second directory called uplloads so it does exist
Warning: Invalid argument supplied for foreach() in /admincp/downloadadmin.php on line 345

i sitll get this :S


All times are GMT. The time now is 10:30 PM.

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.14926 seconds
  • Memory Usage 1,877KB
  • 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
  • (4)bbcode_code_printable
  • (29)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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