Surely it could never happen...

...could it? Details on the Great Internet Crash of 2007 follow.

(via Lifehacker, amongst other places)

Universal Share Downloader - an easy way to "cheat" filehosts like Rapidshare, MegaUpload etc.

In these days of big fat media files, whether these be music, video, games, software or other such thing, there are a pile of services out there to let you send stuff to your pals without having to stick to silly email size restriction limits. Basically you upload your file to a host, such as MegaUpload or Rapidshare, they produce a link, and your friend downloads it from the web. Simple. Well, simple if you only want a single file and are happy to wait around for it.

To prevent abuse of such usually-free services, there tend to be restrictions such as only being able to download one file at once, only being allowed to download so many megabytes and hour, having to wait for a few minutes before commencing and so on. Your choices tend to be put up with this or pay up. Unless you use something like Universal Share Downloader.

Implementing CAPTCHA spam protection in PHP

Those people privileged enough to have websites with fancy (or non-fancy) forms on them will probably be all too aware of the evil spambots that come along and auto-fill them in with commercial nonsense, inane content or on occasions just blanks and hit the submit button. Depending on what the form does this tends to mean you'll get 1000 advertisement emails, a database full of rubbish or a few thousands complaints at spam. The Poorhouse has already discussed a few ways of dealing with the problem but another common one is illustrated here.

Fixing the spam module mysql_real_escape_string error

Kernaltrap has an excellent Drupal anti-spam module which is used to great effect at the present time on this site. Recently it was set to moderate forum posts (which in Drupal terminology are themselves nodes) and errors started appearing in the watchdog logs every time the cron tasks were run.

mysql_real_escape_string() expects parameter 1 to be string, array given in /usr/home/adam/public_html/includes/database.mysql.inc on line 350.


Unknown column 'n.revision_timestamp' in 'where clause' query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = '835' AND n.vid = '835' AND n.type = 'forum' AND n.status = '0' AND n.created = '1165946854' AND n.changed = '1165946854' AND n.comment = '2' AND n.promote = '0' AND n.moderate = '0' AND n.sticky = '0' AND n.revision_timestamp = '1165946854' AND n.title = 'Merry Christmas Site' AND n.body = '<a href=\"http://xanaxaxa.blogspot.com\">xanax</a> \r\n<a href=\"http://phenne.blogspot.com\">phentermine</a> \r\n<a href=\"http://tramadol400.blo in /usr/home/adam/public_html/includes/database.mysql.inc on line 121.

Bypass port restrictions on cPanel and WHM

cPanel and WHM are nice friendly systems that allow one to configure much of a web/ftp/email server with ease using nothing but your web browser. It is commonly made available by web servers that offer shared hosting packages, and includes a webmail package to allow you to access your personal email remotely. Just right for those boring office hours where you need a few hundred hours break from doing what you're paid for.

Transferring domains away from 1and1.co.uk

Welcome to the new Poorhouse. Yes, it looks nigh on identical, but trust us, it did move around the country a little bit.

Part of this involved redirecting the domain name "thepoorhouse.org.uk" to point to a new location. Sounds simple right? Especially as it was registered through a company independent to the hosting space, namely 1and1.co.uk. The main reason this choice was originally made was that it cost a bargain £1.99 a year to do so. And up to this point, it has worked wonderfully.

FTP without FTP programs

Imagine the horror. You're out and about in the real world and suddenly you realise you forgot to make a directory on your ftp server. Panic subsides as you realise you live in the 35th century and hence just about everything is at your e-fingertips. You whip out your fancy-ass Internet-enabled mobile and then...get stuck. Not so many of the smaller devices come with built in ftp clients. Web yes, ftp no.

Have no fear. There are a few web ftp clients, where you can play with a remote FTP server to your heart's content through a web browser. Not least of these is Net2FTP. Plenty of features abound. You can visit all your files, upload, download, edit, zip, copy, move, search and all that sort of malarkey. It has skins to make it pleasing to your eye, including one deliberately designed for low-end browsers such as those found on mobiles, PDAs and so on.

Adding a no wordwrap option to img_assist

Note: this article is outdated now as the official Image Assist module now contains a no-word-wrap feature within it.

The Poorhouse's current favourite way of easily inserting images into Drupal nodes is to use the module img_assist. To use it, you also need to install the image module.

Controlling who sees a block in Drupal

You can configure Drupal block visibility under Admin -> Blocks -> Configure. One option is "expert mode" whereby you can write a snippet of PHP code. If it returns true, the block is shown, otherwise it is hidden.

Drupal "save as draft" feature

Recently the Poorhouse wanted some sort of "Save as draft" facility, such that a (fabulous) article could be started at one point in time, saved - without being published - and continued some other time. Also the option to decide whether to publish to the front page or not on a case-by-case basis was desired - after all you don't want every last bit of the inner workings of your mind highlighted for all to see. At least make them work for it.

Drupal contains this feature, under "Publishing options". However, this is only available to the initial admin user, plus anyone who has node edit privileges. The Poorhouse wanted its guest authors it have this facility too. However giving them node edit privileges was not quite right, because it meant they could edit, delete and otherwise have finger-slips over everyone's articles and not just their own.

Syndicate content