programing

warning: Creating default object from empty value in /web/1/000/027/003/273448/htdocs/panticz.de/modules/taxonomy/taxonomy.pages.inc on line 33.

Install MS SQL Server JDBC Driver

# get driver
wget http://netcologne.dl.sourceforge.net/project/jtds/jtds/1.2.5/jtds-1.2.5-dist.zip -P /tmp/
unzip /tmp/jtds-1.2.5-dist.zip -d /tmp/
sudo cp /tmp/jtds-1.2.5.jar /usr/share/java/

Eclipse > Build Path > Configure Build Path
Libraries > Add External JARs
/usr/share/java/jtds-1.2.5.jar

# fix tomcat
sudo cp /usr/share/java/jtds-1.2.5.jar /var/lib/tomcat6/webapps/builder3/WEB-INF/lib/

# Links
http://www.java-tips.org/other-api-tips/jdbc/how-to-connect-microsoft-sql-server-using-jdbc.html

Fix unable to shutdown / reboot / logout when OpenOffice Quickstarter is active

Here is a quick fix for OpenOffice bug reported on Launchpad https://bugs.edge.launchpad.net/ubuntu/+source/openoffice.org/+bug/562027 that prevent Gnome logout if Quickstart is running.

Solution: change DocumentStoreUIEnabled in Recovery.xcu (OpenOffice) or main.xcd (Libreoffice) to false with this command

wget http://www.panticz.de/sites/default/files/scripts/set.DocumentStoreUIEnabled.false.sh -O - | bash -

#!/bin/bash

if [ -d /usr/lib/libreoffice ]; then
	# libreoffice
	sudo sed -i 's|true|false|g' /usr/lib/libreoffice/basis*/share/registry/main.xcd
else
	# openoffice
	sudo sed -i '5s|true|false|g' /usr/lib/openoffice/basis*/share/registry/data/org/openoffice/Office/Recovery.xcu
fi
1

or use Diff to path Recovery.xcu
wget -nv http://dl.dropbox.com/u/4170695/openoffice/Recovery.xcu_DocumentStoreUIEnabled.diff -O - | \
patch -p2 /usr/lib/openoffice/basis3.2/share/registry/data/org/openoffice/Office/Recovery.xcu

Optional: remove user personal Recovery.xcu files
find /home/*/.openoffice.org/ -name Recovery.xcu -exec rm {} \;

Links
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/562027

Compile Docky with Stacks under Ubuntu

Quick install (go Applications > Accessories > Terminal and put this line into):

wget http://www.panticz.de/sites/default/files/Docky/compile.docky.stacks.sh.txt -O - | bash -

Script code:
#!/bin/bash

# install requires libraries
sudo add-apt-repository ppa:docky-core/ppa
sudo apt-get update -qq
sudo apt-get install -y bzr libgio2.0-cil-dev automake bzr mono-gmcs libmono-cairo2.0-cil gtk-sharp2 libndesk-dbus-glib1.0-cil libndesk-dbus1.0-cil libgtk2.0-dev libnotify0.4-cil libgio2.0-cil-dev libtool intltool ca-certificates gnome-desktop-sharp2 libgconf2-dev monodevelop-nunit
sudo apt-get build-dep -y docky

# fix link in maverick (test)
if [ "$(lsb_release -c -s)" == "maverick" ]; then
   sudo touch /var/lib/apt/lists/ppa.launchpad.net_savoirfairelinux_ppa_ubuntu_dists_maverick_main_source_Sources
fi

# build docky stacks
cd /tmp
bzr branch lp:~docky-core/docky/stacks
cd stacks
./autogen.sh 
./configure --prefix=/usr
make
sudo make install
killall docky
nohup docky > /dev/null &
1

Install Docky Stacks (already compiled)
http://www.panticz.de/Download-and-install-Docky-Stacks-under-Ubuntu

Links
http://wiki.go-docky.com/index.php?title=Installing
http://www.omgubuntu.co.uk/2010/06/stacks-for-docky-looks-like-a-dream-works-like-one-too/

Magento product back button

http://www.panticz.de/sites/default/files/magento/back-button/styles.css

/*
* add to ./skin/frontend/default/default/css/styles.css
*/
.add-to-box .back-button {
    padding: 180px 0 0;
}

.back-button {
    float: right
    padding: 8px 0 0;
}
1

http://www.panticz.de/sites/default/files/magento/back-button/back-button.view.phtml

// ./app/design/frontend/default/default/template/catalog/product/view.phtml
// add to 
block after this line // <?php echo $this->getChildHtml('addto') ?> <?php if ($_category = $_product->getCategory()): ?>
__('Back') ?>" type="button"> <?php echo $this->__('Back') ?>
<?php endif;?> 1

mkdir -p ./app/design/frontend/default/default/template/catalogsearch/
cp ./app/design/frontend/base/default/template/catalogsearch/result.phtml ./app/design/frontend/default/default/template/catalogsearch/result.phtml
http://www.panticz.de/sites/default/files/magento/back-button/result.phtml.diff

--- ./app/design/frontend/base/default/template/catalogsearch/result.phtml	2011-02-09 16:24:16.000000000 +0100
+++ ./app/design/frontend/default/default/template/catalogsearch/result.phtml	2011-02-09 16:33:45.000000000 +0100
@@ -53,3 +53,11 @@
     <?php endif; ?>
 
 <?php endif; ?>
+
+
+ __('Back') ?>" type="button"> + + <?php echo $this->__('Back') ?> + + +
1

mkdir -p ./app/design/frontend/default/default/template/page/
cp ./app/design/frontend/base/default/template/page/1column.phtml ./app/design/frontend/default/default/template/page/
http://www.panticz.de/sites/default/files/magento/back-button/1column.phtml.diff

--- ./app/design/frontend/base/default/template/page/1column.phtml	2011-02-09 17:24:38.000000000 +0100
+++ ./app/design/frontend/default/default/template/page/1column.phtml	2011-02-09 17:25:45.000000000 +0100
@@ -47,6 +47,13 @@
                     <?php echo $this->getChildHtml('global_messages') ?>
                     <?php echo $this->getChildHtml('content') ?>
                 
+
+ __('Back') ?>" type="button"> + + <?php echo $this->__('Back') ?> + + +
<?php echo $this->getChildHtml('footer') ?> 1

Links
http://www.mxperts.de/zuruck-button-fur-die-produktansicht/

PHP

convert line break to html
echo nl2br($content)

Extend Magento Product Attribute Api

# OPTIONAL, install patch
apt-get install -y patch
 
# patch on command line
cd /var/www/
wget http://www.panticz.de/sites/default/files/api.xml_.diff -O /tmp/api.xml.diff
patch -p2 ./app/code/core/Mage/Catalog/etc/api.xml < /tmp/api.xml.diff
 
wget http://www.panticz.de/sites/default/files/Api.php_.diff -O /tmp/Api.php.diff
patch -p2 ./app/code/core/Mage/Catalog/Model/Product/Attribute/Api.php < /tmp/Api.php.diff
 
 
1. go to magento installation folder, for example /var/www/magento
 
2.

Java exampels

// identificate filetyp in filestream
System.out.println(URLConnection.guessContentTypeFromStream(new URL("http://www.example.org/banner.jpg").openStream()));
 
// timestamp
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS");
String timestamp = sdf.format(new Date());

Enable UNO listener on Windows

wordpad "C:\Programme\OpenOffice.org 3\Basis\share\registry\data\org\openoffice\Setup.xcu"
 
search for <node oor:name="Office"> (by default line 3) and add
<prop oor:name="ooSetupConnectionURL" oor:type="xs:string">
   <value>socket,host=localhost,port=8100;urp;</value>
</prop>

Windows scripts

# exportDB.cmd
for /f "tokens=2" %%i in ('date /t') do set date=%%i
set timestemp=%date:~6,4%-%date:~3,2%-%date:~0,2%
d:\ORANT\BIN\exp80.exe system/manager file="e:\%timestemp%.dmp" full="y"
 
# add_at_job_windows_nt.cmd
at 20:00 /every:Mo,Di,Mi,Do,Fr,Sa "\\fs\scripte\windows\exportFullDatabase.cmd"

Create webserver info page

#!/bin/bash
 
cat <<EOF> "$(grep DocumentRoot /etc/apache2/sites-available/default | cut -d " " -f2)/phpinfo.php"
<?php
phpinfo();
?>
EOF

Do you like this page? Then support it. Please click the AD below and visit the sponsor. Thank you!


client = pub-6933618646234008
slot = 3731759448
width = 728
height = 90
Syndicate content