vb.org Archive - vBDownload Area 1.1

Page 1 of 2

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)

Getox

01-24-2005 10:00 PM

vBDownload Area 1.1

vBDownload Area v1.1

1.2 Bug Finders Wanted. PM ME!

Features:

Restrict Downloading to XX user groups.
Add/Edit/Delete Categorys.
Upload/Edit/Delete Files.
Post/Delete Comments.
Stats.
Screen Shot.
Upload To DB, Folder or Link to file.

A little info:
Categorys & Files can have description.
Will show how many files in the category.
Will Show how many comments & downloads the file has.
File Screen Shots.

Planned for 1.2:

Restrict Usergroups to Categorys.
*MAYBE* File Rating.
User Uploads.
Moderate User Uploads.
*MAYBE* Custom Fields.
If download is a link a note will be shown.
Report Broken or Infected File.
*20/80* Paid Downloads.
*50/50 Chance* Move Multiple Files to diff category.
Licence Agreement.
Sponsor Link.
Hide File.
Sub Categorys
Info: Uploader
Info: Date Added
Info: Last Download
Send to friend
BBCode Comments
Better Templates

Is There anything else you would like to see in 1.2 ?

1.2 Status:

User Uploads 0%
Moderate User Uploads 0%
Restrict Usergroups to Categorys 0%
File Licence Agreement 100%
Sponsor link 100%
Hide File 100%
If download is a link a note will be shown 100%
Report Broken or Infected File 0%
Sub Categorys 100%
Info: Uploader 100%
Info: Date Added 100%
Info: Last Download 100%
Send to friend 100%
*Not till 1.3 maybe* BBCode Comments 0% < If you can get the stupid vB wysiwyg working then help! this thing is making me want to smash my pc!
Better Templates 100%

Dont get your hopes up on 1.2 anymore, Go thank BrentWilson for that.

NOTE: If you have 1.0 installed you will need to: Delete the dl_x tables and the "candl" colum in "usergroups"

Delete 'candl' query:

Code:

ALTER TABLE `usergroup` DROP `candl`

mikaelweb

01-25-2005 10:38 AM

nice i will Install

mr.gamesbay

01-25-2005 10:43 AM

Great, i will try it too! :)
*install*

Edit:
But, things i missing:
- Filesize
- Ratings
- BB Code Support

winlya

01-25-2005 11:00 AM

yes,this is cool hack.
Waiting a long time.
thanks for support

winlya

01-25-2005 11:02 AM

Quote:

NOTE: If you have 1.0 installed you will need to: Delete the dl_x tables and the "candl" colum in "usergroups"

==>I have install 1.0.But I don't know delete candl colum in usergroups.Please tell me how to delete thi table ?(run query or ??)

Getox

01-25-2005 11:08 AM

Quote:

Originally Posted by winlya

==>I have install 1.0.But I don't know delete candl colum in usergroups.Please tell me how to delete thi table ?(run query or ??)

Code:

ALTER TABLE `usergroup` DROP `candl`

For 1.2 i will be making a upgrade file for it.

cinq	01-25-2005 11:22 AM

You might want to fix the

Code:

// vBGallery By incubus @ sanguinox.com

// Made for full intergration into vbulletin.

in the dl_admin.php file. ;)

Wouldn't it be easier to release this sub version in the existing 1.0 thread ? :)

mikaelweb

01-25-2005 11:25 AM

Upload To DB, Folder or Link to file. dont work

Amiga75

01-25-2005 11:33 AM

Quote:

Originally Posted by mikaelweb

Upload To DB, Folder or Link to file. dont work

I have the same Problem

winlya

01-25-2005 11:37 AM

hic,please checked this release,DB, Folder or Link not work for me

Getox

01-25-2005 11:39 AM

DB & Link download works, iv tested it on my forum.

jluerken

01-25-2005 12:18 PM

Quote:

Planned for 1.2:

* Restrict Usergroups to Categorys
* *MAYBE* File Rating
* User Uploads
* Moderate User Uploads
* *MAYBE* Custom Fields

Is There anything else you would like to see in 1.2 ?

Yes, there is :D

* Option to store files in the filesystem instead of the database
(Prevent users from seeing the direct link to the file)
* AdminCP Import a filesystem directory to the downloadscript
(you can upload a bunch of files to a directory via FTP and then add all in a single step to the script).
* Payed Downloads
(Subscribe to the download area)
* Statistic page to see:
- how often a single file was downloaded
- how much traffic this was
- how many downloads at all
- traffic at all
* User has to agree a license page (checkbox) before the download starts
* Report a broken or infected file to a mod or the admins
* Move files from one category to another
(do this for multiple files in a single step like you can do it with the PMs)
* AdminCP Option to temporary disable downloads from a category
* add a column to the filelisting page and select in the AdminCP if a sponsor button should be shown there
* add links to external files for downloading in the admincp with a notice that this
link is an external one

I think that enough for 1.2 I wish :D

Getox

01-25-2005 12:38 PM

Quote:

Originally Posted by jluerken

Wow, Thats alot :p
ill try to get those done, If there are some i cant do, Well im sorry :(

uae	01-25-2005 12:56 PM

Thanks for sharing :)

I installed the hack, and uploaded a file to "Folder", but whenever I click on the Download link to download the file I have uploaded, I get "The page cannot be found"!

Where are the Screenshot images stored?? it's not in the Downloads folder, even tho I can see it when I go to the file page, and I have selected to upload to folder, not database!

Stephen Powell

01-25-2005 02:02 PM

Great hack, installed very quickly. Also looking forward to the planned v1.2 alterations. :)

mikaelweb

01-25-2005 02:05 PM

looking forward v1.2

Getox

01-25-2005 06:27 PM

Screen shots are stored in the DB but in 1.2 i will make it upload screen to the download folder.

Getox

01-25-2005 06:34 PM

Update!:
Folder downloads now work.
And the screen shot part wont be shown if you didnt upload one.

StevenIsProek

01-25-2005 07:45 PM

yay thanks!I hope you support this hack 4 as much as you can. We can donate you money to keep doing it :)

jugo	01-25-2005 08:01 PM

Quote:

Originally Posted by StevenIsProek

yay thanks!I hope you support this hack 4 as much as you can. We can donate you money to keep doing it :)

I agree with Steven....

Something like this has been long overdue and thanks to you for bringing it!!!

StevenIsProek

01-25-2005 08:03 PM

Hey Getox. You should check out PafileDb and get some ideas. I love pafile db we all do!I think thats something we all want.
http://demo.phparena.net/pafiledb/

mikaelweb

01-25-2005 08:23 PM

Quote:

Originally Posted by StevenIsProek

yay thanks!I hope you support this hack 4 as much as you can. We can donate you money to keep doing it :)

I agree with Steven to

Mickey19781978

01-25-2005 08:31 PM

Excellent work
was waiting for tyhis

Cheers :)

Getox

01-25-2005 08:42 PM

Thanks for all the comments and ideas :)
looking at the pafile db i see that i could do a Date added, Icon for the file, the uploader, version, last downloaded, filesize and a better comment system(With the bbcode and all)

Mickey19781978

01-25-2005 09:45 PM

[high]* Mickey19781978 clicks install
[/high]

Excellent work m8ey

Seems to be working fine :)

mikaelweb

01-26-2005 07:43 AM

Prevent users from seeing the direct link to the file

Getox

01-26-2005 07:57 AM

Quote:

Originally Posted by mikaelweb

Prevent users from seeing the direct link to the file

If its in the folder i could try, but if its a link to the file i cant stop that.

Skyline_GT

01-26-2005 09:50 AM

I am looking forward on version 1.2
Really good and useful hack !!!

mikaelweb

01-26-2005 10:16 AM

5 lates scripts on index page

Search function

Getox

01-26-2005 10:17 AM

Quote:

Originally Posted by mikaelweb

5 lates scripts on index page

Search function

Those i will add in 1.3 ;)

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

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 04:50 PM.

Page 1 of 2

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01529 seconds Memory Usage 1,829KB 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 (3)bbcode_code_printable (1)bbcode_php_printable (13)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)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: