Blog posts tagged “mysql

Random songs Drupal module

If you look to your right, you should see a little widget titled "Random Songs". This block has always existed as a matter of fact, but not in its current state. The current version is a total re-write, and rather than being based on a hacky <iframe> element, it's a custom Drupal module.

In case you're still interested, click the title of this post...

New JSON based music widget

This has been superseded by a new rewrite. See relevant blog post.

If you looked to your left, you'd see a new 'Random songs' block. This isn't a default drupal block, it's one I programmed today at much effort! OK, admittedly I'm using the jPlayer jQuery based software to actually play the music, BUT I programmed the rest (ie. generating the random songs without reloading the page, and rendering them into the playlist using jPlayer's API).

Basically this is how it works:

There's a PHP script on the server which queries from a MySQL database containing songs - it generates 4 random so(...)

I almost nuked my (other) website!

Oh. My. God.

I have a site that, not like this one, is essential for an organization. It can't afford more than a couple of hours downtime. So when, today, I decided to nuke all the old drupal files (see post) and start properly using the new wordpress site, as you can imagine I went about it in a very careful manner (as the site was still live and there would be hell to pay if I fucked this site up - imagine replacing the ring main while people are watching an important program on TV).

I'd tested the new wordpress site time and again and it worked absolutely fine - as you'll know if you read my other post, I'd managed to even import all the old content (using my own custom mysql commands and not a plugin :D), and was stored in a folder called 'wordpress'.

Web provider nightmares, and drupal

Right, where do I start with this one?!

So to begin with, I'll let you know that for the past two years I've had a site running (using hosted hosting btw, ie not my own server), using Drupal as it's platform. I've recently discovered wordpress as a great alternative to drupal and find it much easier to use, and so had the idea to migrate this site to Wordpress. Now take note that this site has a fair few users and can't afford any major downtime, so to 'upgrade' it to Wordpress, I'd have to first make the wordpress site while the Drupal one's running, and then replace the drupal files once (...)

Twitter Feed

1 day ago

RT @LGBToryCanada: Robert #Mugabe, who claims 'filthy' gay people should be castrated, named #WHO Goodwill Ambassador