vb.org Archive - Add-On Releases

Page 4 of 5

« First

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)

- - Add-On Releases - BFC-Download (https://vborg.vbsupport.ru/showthread.php?t=212379)

aakhan136

06-22-2009 11:04 AM

Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = 'HtF ka Member',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`bfc_download` = '59',
`forumpermissions` = '12317183',
`genericpermissions` = '1579685063',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '900000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '55159',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535'
WHERE usergroupid=2;

MySQL Error : Unknown column 'bfc_download' in 'field list'
Error Number : 1054
Request Date : Monday, June 22nd 2009 @ 07:00:48 AM
Error Date : Monday, June 22nd 2009 @ 07:00:49 AM
Script : http://*********/admincp/usergroup.php?do=update
Referrer : http://www.*********/admincp/usergro...&usergroupid=6
IP Address : **********
Username : ************
Classname : vB_Database
MySQL Version : 5.0.77-community-log

How can i fix this i have same error in all Usergroup Manager

Please help me

thanks
aakhan

aakhan136

06-22-2009 11:21 AM

can I add like this application/rar, application/zip, application/txt, application/mp3, application/mp4, application/avi, application/wmv, application/3gp, application/asf, or videos/mp4, videos/avi, videos/wmv, in File Types

please help

thanks
aakhan

Excalibur82

06-22-2009 08:59 PM

aakhan136: Actually, mp4 I believe is application/mp4 but I added mp4, zip and rar have been added as well. The rest need to be added and settings saved. Do not have spaces.

EDIT: Ok found the proper file type to set for mp4:

Code:

video/mp4v-es

audio/mp4

You can use this site for file types: http://filext.com/file-extension/

Search for your extension such as .zip or .rar then scroll down till you see a box titled MIME Type.

Excalibur82

07-06-2009 06:00 PM

I've had to put everything on hold, the company I was hosting with got hacked and all my data was lost. I only did monthly backups so it wasn't time for a new one, so I am having to restore a backup from mid June and some info I worked on will be lost. So for a week or 2 I have placed all my addons and such on hold till I get things settled in regards to my site.

philkillz

07-10-2009 04:05 PM

Just to let you know, i can't do anything with it. it's pretty ++++ed.

g0dfather1984

07-12-2009 10:48 PM

I have tagged this modification for now.

Are tar files allowed? If not, could you add them in the future?

Thanks for your time.

Excalibur82

07-13-2009 04:47 PM

philkillz: That comment is unnecessary.

g0dfather1984: All file types are allowed, I don't add them, the admin does that through the options.

NTMID8

09-03-2009 01:29 AM

Any help with the following error?

Warning: unlink(.icat/iCat_4469.jpg) [function.unlink]: No such file or directory in [path]/admincp/download.php on line 192

I'm trying to use file storage and created the required directories in the forum root and gave them 777. I went back and tried 0777 with the same results.

Excalibur82

09-04-2009 04:55 PM

Yeah that is an issue NTMID8, I ran into a few times, make sure the icat directory exists.

I will be getting an update to this mod as soon as I can.

NTMID8

09-05-2009 05:16 AM

Quote:

Originally Posted by Excalibur82 (Post 1879697)

Yeah that is an issue NTMID8, I ran into a few times, make sure the icat directory exists.

I will be getting an update to this mod as soon as I can.

I have verified the directory exists. First I created the required directories in my www root but was getting the error I posted. I then created the directories in my main root and the error disappeared, but it still was not saving category thumbnails and I saw no images being added to any of the three directories.

It seems to work fine if I choose database storage, but I do not want to use dB storage with this mod. I've looked at a few download area mods and this is definately the one I would prefer to use so any help is appreciated.

Excalibur82

09-06-2009 06:21 AM

Quote:

Originally Posted by NTMID8 (Post 1879981)

Ok I will see what the issue is and see if I can't get the directory storage working again.

New Joe

09-06-2009 06:34 AM

What is the max file you can upload using this?

Also does the mod work on vBulletin® Version 3.8.2?

Excalibur82

09-06-2009 06:49 AM

Quote:

Originally Posted by New Joe (Post 1880453)

What is the max file you can upload using this?

Also does the mod work on vBulletin? Version 3.8.2?

The max file size is controlled through the options for the mod.

Yes it does, as for other versions I am unsure about.

New Joe

09-06-2009 06:55 AM

I'll give it try and get back to you.

Log on

09-06-2009 07:36 AM

Great

I got this error

Code:

Warning: require_once(global.php) [function.require-once]: failed to open stream: No such file or directory in /home/basaou/public_html/vb/upload/download.php on line 34



Fatal error: require_once() [function.require]: Failed opening required 'global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/basaou/public_html/vb/upload/download.php on line 34

also another error, I didn't got this menue

https://vborg.vbsupport.ru/attachmen...9&d=1240949724

New Joe

09-06-2009 12:40 PM

When I try to add a Screenshot to a file it doesn't upload one, I Browse then put the screenshot I want and hit the Upload and it then continues to a page with nothing so when I go back and check still no Screenshot.

Any ideas why?

New Joe

09-06-2009 12:49 PM

Also is there anyway to stop files going into >Files Awaiting Approval?
So don't have to be Approved?

New Joe

09-06-2009 01:52 PM

After trying to upload a file I got

Quote:

"Security Token missing"

Any ideas?

New Joe

09-07-2009 11:16 AM

I would like to have this available for my users but I before I do I would like it running perfect, could do with some support on the few above things.

New Joe

09-07-2009 01:32 PM

Another question, if you want to store the files not in the data base what do you actually put into these folders?

Quote:

Select 'YES' to use file storage instead of database storage for all files uploaded.

NOTE: Must create a folders as listed below:
Forum Root: /icat
Forum Root: /ifiles
Forum Root: /screens

Excalibur82

09-08-2009 05:12 PM

Quote:

Originally Posted by New Joe (Post 1881096)

Another question, if you want to store the files not in the data base what do you actually put into these folders?

Look you have posted almost 2 hours apart, I have a life. I will get the errors fixed when I have time. I go to school and I work a full time job, I have a family with 3 kids. I don't have all the time in the world so gain some patience.

NTMID8

09-27-2009 11:22 PM

Quote:

Originally Posted by Excalibur82 (Post 1881694)

Just checking in to see how things are going with this. Thanks!

DaMani

10-05-2009 08:08 AM

We are currently performing maintenance of BFC-Download Area.

???

Trek	10-07-2009 04:41 PM

Installing this now... I can see many uses for this, thank you for writing it!

Trek	10-07-2009 05:06 PM

Ok, installed, but have a couple of issues/questions. =)

First, I'm getting this error:

Quote:

Invalid SQL:
SELECT COUNT(sid) AS number FROM download_screenshots WHERE file_id = '1';

MySQL Error : Table 'trekkan_dhvforums.download_screenshots' doesn't exist

Obviously the table wasn't created, I have file store selected and created the folders and changed the perms.

Second, the questions.

Can I set specific categories so that only specified usergroups can access them? I see you have usergroups setup on the files themselves, but it'd be nice to limit by category as well.

Having members enter usergroups can get confusing (especially when you use a lot of secondary usergroups like I do). First suggestion would be a multi-select box of usergroups (defined in the admin for this mod, which appear). If that is too much work, then I'd suggest... usergroup groups.

Basically where I as an admin would define a group by name, say "Mods and Admins", then I'd assign a value to this name of the usergroups I want it to contain like "6,7". this will allow me to add in whatever I wanted and eliminate the members from having to remember usergroup values. Then a dropdown would list all of these by description or better, a list of checkboxes and select which groups that way.

I'm not sure of the best way to go about that, but... I hope you get the idea. =)

Anyway, good stuff and can't wait to have it available to my members!

Trek	10-07-2009 05:31 PM

Ok, sorry for the multiple posts, but I'm digging at this trying to figure out the problem.

The tables were in fact created correctly, using my prefix as defined:

$config['Database']['tableprefix'] = 'dhv_';

However, as you can see by the error in the above post, this prefix is not being used in select statement. I took a look at download.php and found some queries that were missing the prefix.

Lines 343 and 344 are missing it, I fixed those in my version of download.php and took a look at all of the other DB calls in that file and couldn't find any more that were missing.

Another question is, I have it set to use the file system and not the database, but that doesn't appear to be working. I checked the file folders and there's nothing in ifiles for example (I assume this is where the files should be dumped?). However, the downloads do work, so the files are somewhere (another assumption is the database?).

Trek	10-07-2009 06:16 PM

When editing categories, after clicking save, this error appears during the save.

Warning: unlink(./icat/) [function.unlink]: Is a directory in [path]/admincp/download.php on line 192

But the changes I made to the category description appear to save, so that part works.

Trek	10-07-2009 06:43 PM

I took a look to see if I could figure out why saving into the file system wasn't working and it appears... there's no code to do it.

The setting is: bfc_download_storage

But that's not used in the \download.php file or templates, etc. When looking at the \download.php file, the only code there is for saving to the database, no checks at all if it should save into the file system and nothing that would do it if there were (that I can find).

However, the \admincp\download.php does appear to have code for the file system and this option. This would explain why myself and others who have gotten the unlink error get that error. We're set to file system, but there's nothing in the file system to remove, because all uploads are going into the database instead.

Since the download record is being deleted, the database record is actually being deleted anyway, so the good news is this isn't leaving unused data in the database.

There's a lot of code in the \admincp\download.php that pertains to the file system saving and having only looked at this code for a short amount of time, I could be wrong on all of this. So... no offense meant towards the author at all, this is good stuff, I'm just trying to debug the issues I'm having. =)

Trek	10-07-2009 07:17 PM

At the top of the \downloads.php file where access permissions are set, it looks like a copy/paste problem with permissions.

All of the permissions are set to to the "canaddfiles" permission. So if someone can add files, they can do anything, delete, etc, view, etc.

To fix:

Open \downloads.php

Find:

Code:

$canaddfiles = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['canaddfiles'];

$candeletefiles = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['canaddfiles'];

$caneditfiles = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['canaddfiles'];

$canaddimages = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['canaddfiles'];

$canviewfiles = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['canaddfiles'];

$canviewimages = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['canaddfiles'];

Replace with:

Code:

$canaddfiles = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['canaddfiles'];

$candeletefiles = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['candeletefiles'];

$caneditfiles = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['caneditfiles'];

$canaddimages = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['canaddimages'];

$canviewfiles = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['canviewfiles'];

$canviewimages = $permissions['bfc_download'] & $vbulletin->bf_ugp['bfc_download']['canviewimages'];

Trek	10-07-2009 08:55 PM

There's one change in each cat.php, screen.php and screenshot.php that needs to be made.

You need to include the database prefix in those as well.

Trek	10-07-2009 09:48 PM

Some more bugs:

Uploading Category Images:

If file system is on, the files write correctly to the file system.
The category images show correctly in the Admin CP.
The category images DO NOT show to end users.

If the file system is off, the files write correctly to the database.
The category images DO NOT show correctly in the AdminCP.
The category images show correctly to end users.

Editing a file already uploaded:

The category is not selected, it defaults to the "----" category and you have to reset it.

Trek	10-07-2009 10:19 PM

Here's a fix for the category images not appearing. This will make them display correctly depending on the switch you have set for the filesystem/database file saving.

Open \download.php

Find:

Code:

$caticon = $row['cat_icon'];

Add After:

Code:

    $caturl             = $row['cat_icon_url'];



        if ($caticon){

            $cicon = '<a href="cat.php?img=' . $catid . '"><img src="cat.php?img=' . $catid . '" height="50" border="0"></a>';

        } else {

            $cicon = '<img src="/icat/'.$caturl.'" border="0" height="50">';

        }

Edit Template: bfc_download_cat_bit

Find:

Code:

<div align="center"><img src="cat.php?img=$cid" height="50"></div>

Replace with:

Code:

<div align="center">$cicon</div>

Trek	10-07-2009 10:21 PM

\admincp\cat.php and \admincp\img.php both also are missing the DB prefix.

New Joe

10-08-2009 06:02 AM

Looks like there are a lot of bugs with this, I've clicked Uninstalled.

Trek	10-08-2009 04:46 PM

Quote:

Originally Posted by New Joe (Post 1896445)

Looks like there are a lot of bugs with this, I've clicked Uninstalled.

If you make the changes I mentioned, it works pretty good. Mostly just needs and update from the author. In all fairness, he does list it as BETA. Also, if you don't use a DB prefix for your table names, half of the changes are not necessary.

The only thing really is, all uploading files are going to be in your database, not the file system. I'll look into that when I have some time, but hopefully the author responds and gets all of it fixed before then as I'm just digging around in his code, he knows it better than I do.

jkcerda

10-19-2009 04:09 PM

tagged

Welshy2008

10-19-2009 07:06 PM

Tagged, and watching with interested.

reddyink

11-01-2009 09:29 PM

what's the difference between this and popular dowloadsII mod (3000+installed).

thanks

LCN2007

11-02-2009 03:59 PM

Any Updates on this?

I have DownloadsII but interested in comparing the 2

NTMID8

11-02-2009 06:41 PM

Still waiting on an update here as I really want to use BFC.

All times are GMT. The time now is 02:30 AM.

Page 4 of 5

« First

Show 40 post(s) from this thread on one page

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