# 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
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
wget http://www.panticz.de/sites/default/files/Docky/compile.docky.stacks.sh.txt -O - | bash -
#!/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/
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;
}
1http://www.panticz.de/sites/default/files/magento/back-button/back-button.view.phtml
// ./app/design/frontend/default/default/template/catalog/product/view.phtml // add toblock after this line // <?php echo $this->getChildHtml('addto') ?> <?php if ($_category = $_product->getCategory()): ?> <?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; ?>
+
+
1mkdir -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') ?>
Links
http://www.mxperts.de/zuruck-button-fur-die-produktansicht/
convert line break to html
echo nl2br($content)
# 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.
// 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());
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>
# 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"
#!/bin/bash cat <<EOF> "$(grep DocumentRoot /etc/apache2/sites-available/default | cut -d " " -f2)/phpinfo.php" <?php phpinfo(); ?> EOF