Well this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?!

I am in the middle of writing a component that will hopefully comprise bug-tracking and download management all in one.

Until then, I thought I'd STFW (google) this issue and post a solution considering that even RocketTheme don't want to share this solution unless we continue to pay for the subscription. Understandable to some extent, greedy in another.

So far the solution has been to open this with Internet Explorer with a cleared-cache. A little annoying in view how much I hate Internet Explorer and it's various versions which only work with particular systems... Do not uninstall/install other modules/components as I believe this is some issue with overloading or with the actual code and you can get to this file manager to work without changing your Joomla! setup.

Watch this space for when I find a definitive answer!

---

This is a note to myself but also to anyone out there who's spent as long as I did looking for a solution to this. Maybe it's just me but this is the scenario:

1. Joomla works fine with international characters
2. A Module Extension I wrote for Joomla! displayed funny characters.
3. The Joomla! articles were displaying the correct characters for that language set.
4. I needed to make my extension read data from a MySQL database and display the caracters as intended with UTF8.

I tried enough extensions and forum solutions, and although these changes would have an effect on the module (such as take away accents and convert to ASCII), they weren't what we were looking for.

The quick solution was to make the script run a MySQL command at the start:

SET NAMES 'utf8'

Now I need to run this command from within a Joomla! extension using the mysql Joomla! classes, here's how I've used in this script pulling IDs and titles from the a sample table:

What?
This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work.

Quick tip or note to self: How to get yesterday's date irrespective of date format or daylight savings time.

$today=date("Y-m-d");
$yesterday = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));

---

The title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle:

I saw this on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is.

As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the same effect for the intro credits :c)

This is "a day in the life of New York City".

{module title="Youtube Embedded Video - Sandpit"}

More Information can be found at http://aerofilm.blogspot.com/2010/02/sandpit-short-film-by-aero-director-sam.html

Personally I can sit there watching it without sound.

As usual I have searched the WWW but I obviously don't how to use Google because I couldn't find an answer. My situation is this:

• We have an internal wiki knowledge base using MediaWiki version 1.14.
• Some articles are available for public, some are restricted to staff and different localgroups.
• When users click on the 'Login' link, we want the system to automatically prompt them for their username/password. (Kerberos authenticated, as opposed to NTLM authenticated).
• Note: This article is displaying how to change the link and not how to setup these authentication methods.

In this particular case, I'm comparing my Live and Dev versions of the same MediaWiki site. I want to add the SQL queries I used to this article but I'm in the middle of carrying out this process and it's due in two hours.

Checking both MediaWiki have the same article content:
1. Print Special:AllPages from both sites and do an eye-check (I basically highlighted articles found in one but not the other - we had over 2000 articles... I guess I'm a bit geekly like that)
2. This doesn't show modified date and content size differences but I can run this SQL query to show me these.

---