.xlsm Internet Explorer
2011-06-08 by xpheas
My "favorite Browser" doesn't download the new Office extensions (open XML file format) correctly. Internet Explorer is turning them into ZIP files.
If you use an Apache Webserver you can fix that issue by adding the following mime-types into your .htaccess
If you use an Apache Webserver you can fix that issue by adding the following mime-types into your .htaccess
BASH-Code:
| AddType application/vnd.ms-word.document.macroEnabled.12 .docm AddType application/vnd.openxmlformats-officedocument.wordprocessingml.document docx AddType application/vnd.openxmlformats-officedocument.wordprocessingml.template dotx AddType application/vnd.ms-powerpoint.template.macroEnabled.12 potm AddType application/vnd.openxmlformats-officedocument.presentationml.template potx AddType application/vnd.ms-powerpoint.addin.macroEnabled.12 ppam AddType application/vnd.ms-powerpoint.slideshow.macroEnabled.12 ppsm AddType application/vnd.openxmlformats-officedocument.presentationml.slideshow ppsx AddType application/vnd.ms-powerpoint.presentation.macroEnabled.12 pptm AddType application/vnd.openxmlformats-officedocument.presentationml.presentation pptx AddType application/vnd.ms-excel.addin.macroEnabled.12 xlam AddType application/vnd.ms-excel.sheet.binary.macroEnabled.12 xlsb AddType application/vnd.ms-excel.sheet.macroEnabled.12 xlsm AddType application/vnd.openxmlformats-officedocument.spreadsheetml.sheet xlsx AddType application/vnd.ms-excel.template.macroEnabled.12 xltm AddType application/vnd.openxmlformats-officedocument.spreadsheetml.template xltx |
Firefox 4 - save tabs on close
2011-05-04 by xpheas
Firefox 3.6 ask if you want to save your session if you have multiple tabs open and close the browser. For some reason Firefox 4 doesen't. I fixed the issue by changing the value of browser.showQuitWarning from false to true in about:config
MySQL FROM_UNIXTIME() with negative timestamp
2011-04-01 by xpheas
The MySQL FROM_UNIXTIME() function does not support negative epoch timestamps, it returns NULL.
I used the DATE_ADD function to work with negative timestamps:
I used the DATE_ADD function to work with negative timestamps:
BASH-Code:
| SELECT DATE_ADD(FROM_UNIXTIME(0), INTERVAL <timestamp> SECOND) FROM <table> |
Gimp save all layers
2011-01-06 by xpheas
I needed to export multipe layers to separate JPG files. Gimp does not support that by default but i found a nice script that can export each layer.
Download the script
Source: http://flashingtwelve.brickfilms.com/GIMP/Scripts/sg-save-all-layers.scm
Download the script
Source: http://flashingtwelve.brickfilms.com/GIMP/Scripts/sg-save-all-layers.scm
Aptana FTP show hidden (dot) files
2010-09-24 by xpheas
The . files are filtered by default. To make them visible, use the drop-down arrow on the File view toolbar, select "Customize View", and then uncheck Filters->. files.



I love Free Software
2010-02-14 by xpheasHow to cancel XING
2010-02-07 by xpheas
XING is not supported by the suicide machine. If you want to cancel your membership login to XING and use the following link:
https://www.xing.com/app/user?op=cancel
Cheers!
https://www.xing.com/app/user?op=cancel
Cheers!
Social Suicide
2009-12-22 by xpheas
You want your actual life back?
Wanna meet your real neighbours again?
You can do it. It's so easy!
suicide machine
List all MySQL Databases and show their sizes
2009-12-09 by xpheasBASH-Code:
| mysql -u root -p -e 'SELECT table_schema "Database", ROUND(SUM(data_length + index_length)/1024/1024, 4) "Size (MiB)" from information_schema.tables GROUP BY table_schema;' |
BASH-Code:
| +--------------------+------------+ | Database | Size (MiB) | +--------------------+------------+ | information_schema | 0.0039 | | mysql | 0.5040 | | xpheascom | 8.3756 | +--------------------+------------+ |
R.I.P. Michael Jackson
2009-06-27 by xpheasNo doubt one of the greatest singers and performers of all time died.