jon burrows ^3.0

CREATE FUNCTION dbo.ufn_GetAncestor ( @ID As int ) Returns @tblReturn Table (intID Integer, strDescription varchar(50), ParentID integer) AS Begin DECLARE @ParentID As int

Set @ParentID = (select ParentID from tblLinkedTest where ID = @ID)
Insert @tblReturn 
	Select
		ID,
		Description,
		ParentID
	From 
		tblLinkedTest 
	Where
		 ID = @ID 

While @ParentID >0
begin
	Insert @tblReturn 
	Select
		ID,
		Description,
		ParentID
	From 
		tblLinkedTest 
	Where
		 ID = @ParentID 
	Select 
		@ParentID = ParentID
	From 
		tblLinkedTest 
	Where
		 ID = @ParentID
end

Return End

The newest member of the Burrows family, Ty has arrived. Born on the 2nd October 2006 at 23:59. Weight: 7lb 1oz Length: 48cm

The bot now has a way of using your own images.

To use them simply use the following URL

http://www.jonburrows.co.uk/gtalkstatus/www.domain.com_imagedir/encstring.jpg

simply change www.domain.com_imagedir to the URL that holds your images, just use _ instead of / in the URL as the bot changes all _'s to /'s

so for johndoe he would use http://www.jonburrows.co.uk/gtalkstatus/www.johndoe.com_gtalkimages/encstring.jpg and when someone looked at a page showing his status it will actually use the images from

www.johndoe.com/gtalkimages/status.jpg << see below for list of status images required.

Once your status is called from a webpage it will then locate your status and redirect it to the images that are located on your site.

The following are the minimum images you require for GTalk, other jabber server may use others.

available.jpg, unavailable.jpg, dnd.jpg, idle.jpg, away.jpg

If you find a request for another status simply create the required jpg and upload it to the directory

Cheers Jon

Thanks to [mEo] for the request to make the instructions clearer, and jakecigar for the URL idea.

Here is a great service if you want to test your webpages on safari on a mac. http://www.snugtech.com/safaritest/

I have now got a nice new server. I am in the process of moving across various aspects of the sites and bots that I run to it. So over the next few days/weeks you should notice improvements in the speed and accessability of the site.

I have been thinking about sharing the Jabber Status bots that I have created.

There are really two parts to the system.

The first is the Client which is basically a application that sits listening to the status stanzas that are sent through when your status changes, that in turn is passed into a database.

The other part is the image display system, when the img src=... is called the image handler interogates the db and gets the last known status text and calls the relevant image, or builds the image and passes it back to the required browser.

I am wondering if any one would be interested in helping with hosting the image display system. Basically I am thinking of setting up subdomains that could be pointed to different people servers to utilise there images/status. ie jabsv1.jonburrows.co.uk -> Jabber Server 1 jabsv2.jonburrows.co.uk -> Jabber Server 2

It would enable people to be able to have a far wider range of images to be used as different people could simply choose any image they wanted.

It would also mean that should a server go down it won't effect everone. I would be interested in hearing your thoughts on this.

Cheers Jon

Google are blocking my GTALK Online Status Bot every now and again. The reason being to many stanzas sent in one day :( I am trying to figure out how to counteract this problem.

Jon

CustomizeTalk.com has the best blonde joke ever.

I couldn't stop laughing. View It Here

Welcome to my new site