Drain Hole Plugin
Drain Hole is a centralized download manager, with full monitoring and statistics, versioning, SVN support, and SEO download URLs (no more nasty query strings!).
In addition to it's monitoring abilities, Drain Hole has a run-time tag replacement feature that lets you embed special tags in your post which are replaced with information from Drain Hole. For example, you can embed download URLs, version information, last update times, and so on. Whenever you change a downloadable file it is automatically updated throughout your blog, without you needing to change anything else.
Features include:
- SEO download URLs - a unique feature that allows files to look like real links
- SVN support - attach a file directly to an SVN repository and have the contents automatically updated
- Versioning - maintain multiple versions of a file, allowing users to download older files
- Full download statistics, including number of downloads, access times, referrer, and download speed, available as CSV and Flash-based graphs
- Download security - permissions can be assigned to downloads (including Flash files), restricting them to WordPress roles
- Template tags - insert dynamic download data into posts, and into the sidebar as a Widget
- Hot-link protection
- Fully localized
Version History
- 2.1.12 - Allow for sites with open_basedir restrictions
- 2.1.11 - Update plugin base class
- 2.1.10 - Add file modification time
- 2.1.9 - Fix problem with truncated URLs on some sites
- 2.1.8 - Fix typo in mime type
- 2.1.7 - Fix spaces in version numbers
- 2.1.5 - Better custom 2.6 support
- 2.1.4 - Scanning fix
Installation
Installation is like any WordPress plugin:
- Download drain-hole.zip
- Unzip
- Upload drain-hole directory to
/wp-content/pluginson your server - Activate the plugin
- Use Drain Hole from the Manage/Drain Hole menu
You can find full details of installing a plugin on the plugin installation page. SVN access to the plugin is provided at the SVN repository.
General Concepts
The Drain Hole plugin makes use of two fundamental concepts:
- Drain hole - a base URL and associated directory where files are stored and downloaded from
- Files - a file belongs to a particular Drain hole
It is important to understand the mapping between a Drain Hole's URL and its associated directory. To do this you need to know two pieces of information:
- Where files are to be downloaded from (i.e.
http://urbangiraffe.com/download/) - Where files are to be stored (i.e
/users/john/download/)
This is a mapping from URL to directory:
http://urbangiraffe.com/download/ => /users/john/download/
All files inside the directory will be available at the Drain Hole URL. For example:
/users/john/download/myplugin.zip => http://urbangiraffe.com/download/myplugin.zip
It is preferable that your directory is not in a public location (i.e. in public_html) as Drain Hole may not then be able to function. Your URL must be part of your WordPress installation, but you should not create a directory for it.
Creating a Drain Hole
New Drain Holes require the following information:
The URL is the URL on your website at which to make the files available. The directory is the real directory in which the files exist. These two values do not have to match up and the files do not (and ideally should not) be publicly available.
Once a Drain Hole has been created you can then edit it from the list of Drain Holes:
Editing a Drain Hole will allow you to set additional options:
The Access Level is the minimum user level required to download files from the hole. This allows you to restrict download access to certain types of user. If a user does not meet the required access level then they will be returned a 404 error page or will be redirected to the configured URL.
The Stop Hot-links option allows you to stop external users from downloading files in the hole. This protection is achieved by analyzing the referring page for a given download - if the referrer is not from your site then the user is sent a 404 error page or redirect to the error URL.
Files
A Drain Hole can contain any number of files and sub-directories.
As with the rest of the plugin, columns are sortable, and data can be searched.
Each file allows you to:
- Edit the file configuration
- Manage version history (by clicking on the version number)
- View download statistics (by clicking on the number of hits or the charts link)
- Create a new version or update from SVN (by clicking on the branch link)
When editing a file you will be shown additional configuration details:
The filename is the actual name of the file and this may differ from the name, which is what will be shown in a download link. If no name is given then the filename will be used. As an extra function, you can insert $version$ into the name and it will be replaced with the file's current version.
The description is a free-form field allowing you to enter further details about the download. This can be shown when the file is displayed.
The SVN field allows you to enter an SVN repository. See the SVN section later.
When displaying a file to download, an icon can be shown. You can change which icon is shown when editing a file.
The MIME type allows you to specify a custom MIME type for the file. This may be useful if you want a file to open inside the browser. If set to 'automatic' then Drain Hole will try and decide what the file is.
Forcing a download allows you to override default browser behaviour and force the file to always be downloaded. This is useful if you have a file that a browser usually tries to open (for example, a PDF), but you want it to always be downloaded.
Forcing the access level is an advanced option that is useful if you are trying to restrict files that are used inside Flash. For example, you may have a video tutorial that you want to restrict to registered users only. The flash video player requires your video file to be available, but may not provide any restriction options. Storing the video inside Drain Hole and then forcing the access level will ensure that only allowed users can access the file, even inside Flash.
Adding new files
New files can be added by any of these methods:
- Uploading a file directly into the Drain Hole directory and 'rescanning'
- Uploading a file through the browser
- Creating an empty file which can be uploaded later, or which requires an SVN repository
Versions
Drain Hole allows you to retain old versions of files, either for archiving purposes or for user downloads. To modify a file's version you need to create a new branch:
You can enter details about the reason for the new version, and this will be presented to the end user. To retain an old version you must check 'retain old version'. This old version can be downloaded as follows:
http://urbangiraffe.com/download/myplugin.zip?version=1.2
SVN
Drain Hole provides simple SVN functionality that allows you to associate a file with an SVN repository. A file that uses SVN can then be 'refreshed' directly from the SVN repository, rather than requiring you to manually update the file.
SVN functionality requires that you have SVN installed on your host. You must configure the Drain Hole options and provide the full path to the svn executable. If you are in doubt you should consult your host for details.
When an SVN-based file is refreshed, Drain Hole will use SVN to retrieve the latest copy of the files. If a repository contains multiple files they will be automatically zipped.
As additional functionality, Drain Hole will detect if the SVN repository is for a WordPress plugin, and will automatically set the version according to the version information inside the plugin.
Note that no direct capabilities are provided for username and passwords. However, you can pass a username and password to SVN by including it on the SVN field:
http://svn.mysite.com/plugin/trunk/ --username=john --password=thing
Download Tags
The following tags can be inserted inside posts and pages to embed Drain Hole information. This information is generated dynamically, and will change whenever the underlying information changes:
[drain hole ID hits]- Displays the total number of hits from the specified hole ID[drain hole ID show]- Show a list of all files in the specified hole (change display code by copyingview/drain-hole/show_hole.phpfrom the Drain Hole plugin directory to the same directory path in your theme's directory and editing the file)[drain file ID show template]- Displays the download template for the specified file ID. 'template' is optional and can be ignored (the default template will be used)[drain file ID version]- Displays the version of the specified file[drain file ID versions limit]- Displays the specified number of versions from the file's history[drain file ID hits]- Displays the total downloads for the specified file[drain file ID url name]- Displays a URL allowing the specified file to be downloaded. 'name' is optional and is the text that will appear inside the download link (if not specified then the filename is used)[drain file ID updated]- Displays the update time of the specified file[drain file ID size]- Displays the size of the specified file[drain file ID icon]- Displays the download icon for the specified file[drain file ID href]- Displays the URL of the file
Where ID refers to the ID of the file or hole, as shown in the Drain Hole administration pages.
Download Templates & File Icons
A download template is a section of HTML code that is used to display all the information for a file download. For example, on this page in the top right corner is the download for Drain Hole itself. The icon and file information are all part of a download template that is re-used on each of the other plugin pages available from this site.
A download template is a file that is stored in your theme directory and contains standard HTML as well as special Drain Hole template tags:
$icon$$url$$version$$updated$$size$$href$
These template tags function similar to the post & page tags, but do not require an ID to be specified.
A default template is provided with Drain Hole. Custom templates are PHP files that are stored in view/drain-hole, inside your theme directory. For example, if you are using the default WordPress theme then:
/wp-content/themes/default/view/drain-hole/mytemplate.php
To use this template in a post you would insert the tag:
[drain file 5 show mytemplate]
This tells Drain Hole to use 'mytemplate.php' to display file 5.
Custom icons can be stored inside your theme:
/wp-content/themes/default/view/drain-hole/icons/
Statistics
Drain Hole provides full download statistics:
FAQ
If you have any questions or problems then please consult the Drainhole FAQ before posting here.
Support
Please direct all support questions to the Drain Hole support forum. Any support questions left on this page may not be answered.
Bugs & New Features
A full list of all bugs can be found in the Drain Hole issue tracker.
| Date | Current outstanding bugs | Status |
|---|---|---|
| 19 Nov 2008 | Error 404 & Chart timeout |
A full list of all requested features can be found in the Drain Hole feature tracker.
| Date | Current requested features |
|---|---|
| 14 Sep 2008 | Multi-stage download |
| 07 Oct 2008 | Paypal access |
| 03 Nov 2008 | limited access to drain hole(s) |
| 08 Nov 2008 | Link to Amazon S3 |






Comments (page 1 of 31)
Jun 7, 2007 5:33 am
@Drain Hole: I have the same problem.
John can you tell us what is the problem? Maybe something in .htaccess??
Jun 5, 2007 9:10 am
The plugin is great but one think is missing here.
To add a file to a post, first I have to add a file, see what ID it has and then go to the post and add.
[drain file ID url]
Is it possible to do it automatically?
Let say I will put in my post [drain hole ID] and every file that is in this "hole" will be automatically added to my post and all files will be shown as a list.
I would be really cool because I will have to only add a file to specific "hole" and it will automatically appear on my site.
Do you think is possible?
Jun 4, 2007 9:14 pm
Yes it works in 2.2.
The download stats already tell you the IP address.
You can configure Drain Hole to restrict downloads to registered users. A registered user would need to have given an email address.
Jun 1, 2007 4:59 pm
Oh great. It is almost what I need. Is it compatible with WordPress 2.2?
Is it possible to add in Download Statistics the IP address of who was downloading the file?
And second thing. If somebody wonts to download a file has to give an email address. Possible?
May 27, 2007 3:01 pm
Hi,
I've got Drain Hole installed and I have Redirection installed.
I created a drain hole with
URL '/download/project/jhdi'
DIR '/home/blogpeer/Downloads/Projects/JHDI'
AL 'Subscriber'
FAIL '/download/project/404'
I went into the files section for the new hole and rescanned the directory, and it found and listed the file I had placed there.
I added the code to a post '[drain file 1 url (download)]' and it correctly displayed the URI link I expected. However when i click on the link it generates a 404 error.
Any Ideas what I might be missing?
May 21, 2007 3:03 am
Jorge, problem fixed in 1.1.2. You'll need to deactivate and re-activate the plugin
May 14, 2007 6:31 am
hi,
im triying the plugin but i dont know what to do with this errors after plugin was activated:
WordPress database error: [Table 'wordpress.wp00_drainhole_access' doesn't exist]
DELETE FROM wp00_drainhole_access WHERE DATE_SUB(CURDATE(),INTERVAL 60 DAY) > created_at
WordPress database error: [Table 'wordpress.wp00_drainhole_holes' doesn't exist]
SELECT * FROM wp00_drainhole_holes ORDER BY url
Could you help me?
Regards,
Apr 26, 2007 5:35 pm
Any way you could add a feature to be able to add a name and description through the Drain Hole admin area? And then of course corresponding template tags?
Aug 22, 2006 11:55 am
Hello. I've got some problems using this plugin. The tables and the htaccess are well created, but no file appears in the options page. And when I click on the 'Update' button, I receive this error message :
Warning: Invalid argument supplied for foreach() in drain_hole.php on line 27
Warning: Invalid argument supplied for foreach() in drain_hole.php on line 54
What can I try ?
Aug 11, 2006 1:53 pm
Drain Hole sounds a wonderful idea but it is causing me some problems. I installed the plugin as directed and from the options page gave it a directory ("downloads") which contains the files i have for download. The files are listed correctly in the options page. However when I try to download one of them I get a 404 page saying:
The requested URL /wp-content/plugins/drain-hole/drain_plumber.php was not found on this server.
This was when I tried to download for example:
http://rmarshsj.f2s.com/rob/downloads/aevr.pdf
which seems to be the right url and Filezilla confirms is present.
My next step was to deactivate and remove Drain Hole and delete the drain hole tables. The same url to aevr.pdf still gets the same 404 message that drain_plumber is missing.
Help!!!
Rob
Leave a comment