Primary tickets query in IPManager, working very nicely (110,000 tickets in a slow VM).

SQL result

Host: localhost
Database: ipm_test
Generation Time: Jun 21, 2011 at 01:10 AM
Generated by: phpMyAdmin 3.2.0.1 / MySQL 5.1.36-community-log
SQL query: EXPLAIN SELECT tickets.* , c.id AS `source_client_id`, c.client_name AS `source_client_name`, c.email AS `source_client_email`, c2.client_name AS `assigned_user_name`, c2.email AS `assigned_user_email`, comp.name AS `source_company_name`, p.name AS `priority_name`, t.name AS `ticket_state_name` FROM tickets LEFT JOIN clients c ON c.id = tickets.source_client_id LEFT JOIN clients c2 ON c2.id = tickets.assigned_user_id LEFT JOIN priorities p ON p.id = tickets.priority_id LEFT JOIN ticket_state t ON t.id = tickets.ticket_state_id LEFT JOIN companies comp ON comp.id = tickets.source_company_id WHERE 1 = 1 AND tickets.ticket_state_id = 1 ORDER BY last_modified DESC LIMIT 50 OFFSET 0;
Rows: 6

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tickets	index	ticket_state_id	last_modified	8	NULL	50	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	ipm_test.tickets.source_client_id	1
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	ipm_test.tickets.assigned_user_id	1
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	ipm_test.tickets.priority_id	1
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	comp	eq_ref	PRIMARY	PRIMARY	4	ipm_test.tickets.source_company_id	1

I've just released a new version of Bluetrait Event Viewer for WordPress.

The main new feature is an email alert option on Successful/Failed Logins. I've also updated some of the HTML to improve the display of the events widget.

This plugin has been downloaded almost 7000 times, which I think is pretty cool 

From going over the WordPress stats I think there are about 2000 active copies of the plugin running around the world.

I spend a couple of hours yesterday adding a barcode scanner into IPManager.

The results are sent off to the IPManager server and then displayed as an overlay on the camera interface back on the iPhone.

It works surprisingly well for the amount of work I needed to do (not much).

I'll need to add a scanner log but it is pretty cool :)

 

So every good website needs an iOS app these days ;)

I've been wanting to get into some iOS programming so I've started writing a small app that can be used on the iPhone.

I'm using this service to generate the code required for the SOAP connection to the website. After a small amount of hacking it works really well and allows you to access all your SOAP results as proper objects within xocde which is nice.

I would say that the interface builder in xcode isn't that great. It works okay but if you do anything stupid the app can crash without any nice error logging.

The SOAP connection is very quick compared to going to the actual website which is nice. I'd also like to write in some SQLite caching at some stage too.

Well it looks like WordPress 2.0 is no longer going to be supported, so it is probably about time to rewrite some of my plugins to use some of the new WordPress developer features such as better database security.

I wonder when they're going to drop php 4...

Well I've now released all three programs for download. More info here.

I've been hard at work on Bluetrait 2.1 and have now successfully got events to sync up to a master Bluetrait install.

So I've decided that the Bluetrait Event Viewer needed some love and have been working on a new WordPress plugin called Bluetrait Connector.

This plugin will allow a WordPress install to connect via SOAP to a Bluetrait server.

Basically using Bluetrait 2.1 + Bluetrait Event Viewer 1.9 and Bluetrait Connector you will be able to sync events from a WordPress install to Bluetrait.

I plan to have a beta release of these three programs this weekend :)

With the work I've been doing with the Sydney Business Exchange website, I've decided that all my PHP applications need to be able to talk easily with each other over the internet.

So I have been working on a new Client/Server SOAP system to allow this.

The first program to include this will be Bluetrait 2.1.

The ultimate goal (with Bluetrait anyway) is to be able to push users/posts etc to client sites. The client sites will also be able to push information back to the Server, such as events from the event viewer.

I've decided on using SOAP as I have used it before with a .NET mobile application and it seems to work well.

For the SOAP class I will be using NuSOAP, but it is possible that I could use the built in PHP5 class (although then you need to make sure the extension is installed).

More here

It's finally done, well version 2.0 anyway. I've got lots of things I want to do with 2.1 :)

Max's Mum has just started her own Real Estate business called property by Annabel. Stuart did the design and I setup the CMS, so it is running Bluetrait 2.