06 Sep 2009 Howto combine two columns into one in mysql

This is how you can combine (or concatenate or merge) data from two table columns into one column using a mysql SQL query.

SELECT CONCAT(firstname,lastname) AS 'name' FROM tablename

The result would be “firstname lastname”

If you would like to insert this data into a new column

INSERT INTO tablename (full_name) SELECT CONCAT(firstname,lastname) AS 'name' FROM tablename

Tags: howto, MySQL, sql

Posted by Hans-Henry Jakobsen

Filed in Misc with 0 Comments

24 Jun 2009 Howto decompose a SWF Adobe Flash file

This post describes howto decompose a SWF Flash-file using linux and a program named swfextract. The post came to life because I had to do some changes to one of my flash presentations but I had deleted all the source files. After searching the Internet i doscovered swfextract.

SWF Tools is a collection of SWF (Flash) manipulation and creation utilities like pdf2swf, jpeg2swf, png2swf, gif2swf, font2swf, wav2swf, swfcombine, swfdump, swfstrings, swfbbox and swfc. But I’m only going to use swfextract in this post.

If you don’t have it installed on your system, download it and install the deb-package

# wget http://http.us.debian.org/debian/pool/main/s/swftools/swftools_0.8.1-2.1_i386.deb
# dpkg -i swftools_0.8.1-2.1_i386.deb

The swftools package depends on several packages like libgif4 libt1-5 and they should be installed before swftools

# aptitude install libgif4 libt1-5

I was interested in extracting the image files in my Flash presentation and did the following to determine what was in the presentation file

# swfextract flashfile.swf
Objects in file flashfile.swf:
 [-i] 5 Shapes: ID(s) 1, 3, 5, 7, 9
 [-j] 4 JPEGs: ID(s) 2, 6, 8, 10
 [-f] 1 Frame: ID(s) 0

As we see above there are 4 JPEG-files I'm interested in extracting and their IDs.

I did the following to extract the image files

# swfextract -i 2 -j 2,6,8,10 flashfile.swf

Result files

output.swf
pic10.jpg
pic2.jpg
pic6.jpg
pic8.jpg

If you don't use the -i switch you will end up with only one output.jpg file.

You are now ready to recreate the Flash presentation using the extracted image files.

Source
http://www.swftools.org
SWF Tools

Tags: adobe, decompose, extract, Flash, howto, SWF, swfextract

Posted by Hans-Henry Jakobsen

Filed in Linux, Scripting, Web with 0 Comments

24 May 2009 Configure mutt for Zimbra and IMAP

This post describes how to configure the command line e-mail client mutt to use your Zimbra IMAP mailbox.

Open the text file .muttrc, located in your home directory. If it does not exist, create it. Add or replace the following lines with your own user ID:

set spoolfile=imaps://mail.example.com/Inbox
set folder=imaps://mail.example.com/
set imap_user=username@example.com

If you would like to use your Zimbra Sent and Drafts folders for sent and postponed messages in Mutt, also add the following lines, as above:

set record=imaps://mail.example.com/Sent
set postponed=imaps://mail.example.com/Drafts

Mutt can now be used as a e-mail Zimbra client with access to all your mail. You can change folder in mutt by pressing the etter c. If you do not know the name of the folder, just press ?.

Tags: howto, imap, mutt, Zimbra

Posted by Hans-Henry Jakobsen

Filed in Linux with 0 Comments

12 May 2009 Howto make Adobe Flash work on 64-bit Ubuntu

This post is actually not a HOWTO, but a quick tip on how to install Adobe Flash 10 in 64-bit Ubuntu. I’ve tested this in Ubuntu 9.4 with great success using the following commands from a console window.

wget http://queleimporta.com/downloads/flash10_x64_en.sh && sudo chmod +x flash10_x64_en.sh && sudo sh ./flash10_x64_en.sh

Note!
Please read through the script and make sure you know what it does before you run it, to avoid any surprises.

Source: http://queleimporta.com/en/finally-adobe-releases-native-64-bit-flash-10-for-linux/

Tags: 64-bit, 9.04, Flash, howto, Ubuntu

Posted by Hans-Henry Jakobsen

Filed in Linux, Web with 0 Comments

18 Sep 2008 2-sided print of Redhat manuals using Acrobat

This is a short note on how I have configured Adobe Acrobat to print out 2-sided Redhat manuals described in my previous post using a Canon iR C2880 printer. This gives me 4 pages of manuals in one sheet, and thats quite nice considering the fact that the Redhat Enterprise Linux Deployment Guide is 978 pages.