Categories
Dev

Mysql Delete with null left join

If you do:

Select * from table left join other_table on id=ext_id where ext_id is null

it works great. But if you want to convert that select to a delete you need to include ‘table.*‘:

Delete table.* left join other_table on id=ext_id where ext_id is null

It kind of makes sense, but MySql could be smart and get that we only want to delete from where there actually exists content.

Categories
Dev

Analysis of long tail keywords for SEO with Google Analytics

After the recent Mayday update to Google SERP I decided to have a look into how much was the long tail keywords influenced by this.

Long tail keywords are normally keywords with 3 or more words. To track it down I used the following regular expression: [^\s\+]+(\s|\+)+[^\s\+]+(\s|\+)+[^\s\+]+

Steps inside Google Analytics. Traffic Sources->Search Engines->Google->Non paid

On the filter keyword [containing] I input the regular expression: [^\s\+]+(\s|\+)+[^\s\+]+(\s|\+)+[^\s\+]+

After I just tracked down the last 3 month number of visits with and without filtering the long tail and calculated the % value of the longtail.

long tail keywords/total organic = % of the value for the long tail

5 minutes and I realised that mayday update did *not* influence my sites long tail keywords.

Hope that helps and if someone knows of a simpler or more effective way to do this I would love to know.

Categories
Dev Web

User Experience Professionals

I just order two tickets to http://www.ux-lx.com/

I am really happy that this kind of events happen in Portugal as it gives us (Portuguese developers) a chance to learn and share experiences and knowledge.

UPDATE: minutes after I emailed about this I received a friendly response and the issue bellow was solved. Great job.

I am not one to normally nag and complain about stuff, but for a user experience professionals conference this menu issue made me laugh:

Anyway, and as I started complaining having http://www.ux-lx.com/index.html and http://www.ux-lx.com/ both working is not a very good thing for SEO.

P.S. – Sorry about this guys at http://www.ideias-imagens.com/ but just couldnt resist.

Categories
Dev

Flash – Resize and Crop – Faces Thumbnails

Flash Resize and CropAfter my last post about image resize using flash I did some research and found this:

Flash based cropping tool released (LGPL)

I tried to get it to work and saving the crop server side.

I manage to get to work pretty easy on my local server but after uploading it the php was giving me trouble.

So I stripped it down and now its working great: flash resize and crop

If you want the source: download

I found a very cool script using JavaScript that does almost the same as this one: Prototype JavaScript Image Cropper UI

About flash client side resize, no luck.

I found several Java ones and also I know that is possible to do it in flash but the methods I found were to explode the image pixel by pixel and then pass it like that into php. From what I could understand quality problems and flash player frozes on large images were the problems using that option.

Anyway. I think this was a great step foward.

Categories
Dev

Image Crop using Flash

Image CropI have been following plentyoffish.wordpress.com for a while now.

I deeply admire what as been achieved in POF and am always tryng to learn from the ones who make it.

The other day I commented one of the posts about creating a script to crop images.

As I have been tryng to work out something similar to my sites I decided to give it a try using sephiroth.it – Image Crop – I know its an old version (Flash Player 6) and as Kebie said as a comment in the plentyoffish post it doesnt use the new ability to do this client side.

Anyway as I dont mind doing it server side I build this: image crop script example

Feel free to use it as you want. Use it, change it, sell it… whatever 🙂

zip file: download

In simple terms there are 2 folders – images and tb (thumbnails)

You choose one of the files from the images folder. It sends to flash the message and then flash sends back the coordenates of your crop.

The crop is done with php.

Any doubts contact me.

Images from www.sxc.hu

P.S. – I will try to find a couple of hours to make it resize.

Edit:

I found and am using resize before upload it does what it says using flash. There is still a minor bug with transparent images and the image formats are limited but I think it’s well worth it.