Attendees

David from Insight Indonesia (site?)

John Insight Media

Tony from Inlight Media

Martin from Magnetic Websites

Joomla Plugins discussed or presented

Ignite Gallery -    Presented as a flexible image gallery (Commercial)

Andrew Eddie’s Admin component Advanced Admin Menu

Andrew Eddie’s Content Manager component which works with

JX Control for access control

Joomla Works Ultimate Content Display some very impressive examples and demos, can display any content anywhere

Smooth Gallery but it seems a bit half baked

Phoka for commenting on articles – can’t find the link?

JomComment for commenting

JCE Image Manger Can supposedly do multiple uploads.  Bah so can the MCE commercial plugin.

Joomla’s inbuilt Custom HTML module – Need to create a new module to see it, but it is inbuilt already.

InLight are using in a project of theirs:

Wordpress Integration

DT Register for registrations (Matt not sure re quality)

DT Donate for donations

Phil Taylors Joomla Tags (Allows automatic tagging of content I think) Hmm I hate it, it uses jQuery and the comments are 50% negative.  Why use it?

Capistrano for deployment

Little Snitch for ??

FishEye Menu (uses jQuery) – nice but have to dig around for the menu

Donation Plugin http://hybing.com/

Extras I found while browsing:

Phoca download plugin I will use it soon!

Joomla Themes discussed

Mynxx – A flexible theme.  I think this is the right link, it’s a commercial Rocket Theme.

Hive Mind from Rocket Theme (in built tabs plugin)

Themes developer http://www.gavick.com/

Hints and Tips

Lightbox, to close it you can hit Esc.

Java ftp uploaders for clients to upload files – but then they need Java.  Might work for one or two clients or corporate environements.

Joomla’s inbuilt Content – Load Module for loading any module in a content item

Invoicing software/website revolvehq.com (Australian company used by InLight) (link?)

Project Tracking software www.redmine.org

RSS Feeds to Joomla

Use feed2js.org to format the feed for the content item, and then read the content item.

Wordpress Plugins

The WordPress ecommerce bible http://www.instinct.co.nz/e-commerce/

Other Stuff

Radmind Loadsets for software deployment of multiple application builds (on Windows, Mac, etc)

ZFS File system, Bill Moore, Sun Engineer, Video, Interesting.

www.iCyte.com internet research tool

Search the LQM forum with Google.

One example of how to create a new Joomla user using just SQL in LQM.

The example in the LQM forum post isn’t really correct because it only checks the name field, which isn’t part of the jos_users table primary key.  In fact the only part of the primary key is the ID field, which is kind of useless.  I guess the question then is “what is the natural key”?  I’d say the keys to really check for are username, and email address.

In the next part of this article I show the SQL I used to create a user and confirm it will create correctly without errors.

Continue reading »

I’ve decided I don’t donate enough money to or free software projects. This includes open source but there is plenty of good free closed source software around too.  I’m guilty of using useful tools like Spy Bot Search and Destroy for years and never sending them a cent…. UNTIL NOW.

So now I’m making an effort to pay these dedicated people for their work, I mean why not? I’m using their software, it’s good stuff, and it’s easy to donate.

If we donate then the software will be better. Your computer will have good karma, you will feel great, the software developer has a good day and decides all their hard work is worthwhile. And then a magical thing happens: They improve the software, making a good tool even BETTER. The project survives, the programmer fixes the bugs, it’s a perfect world!!!

And that makes everyone happy. Especially ME.

Oh, and YOU too of course! Donate 10 bucks to your favourite free software tool today, you’ll feel like a million dollars

Open source / Free Products I’ve donated or paid for (and recommend you do too):
Spy Bot Search and Destroy (Anti Malware)
Camstudio (Screen Recording Software)
Arras theme (Wordpress Theme)
CCleaner (Windows XP Disk Cleanup)

This list is continually updated as I spend my money…

If you have an MQE with 3 queries:
Query 1 checks for records that exist
Query 2 inserts new records
Query 3 selects new (and old) records for display

You MUST set expect=”no” on the first query. Otherwise LQM uses it in place of Query3.