Derek's Blog

Install IspCp 1.0.6 on OpenSuse 11.3

admin — Fri, 13 Aug 2010 18:57:20 +0000

Install IspCp 1.0.6 on OpenSuse 11.3

Fix the package

Update your system first

zypper ref
zypper up

Download IspCp

cd /usr/local/src
wget http://sourceforge.net/projects/ispcp/files/ispCP%20Omega/ispCP%20Omega%201.0.6/ispcp-omega-1.0.6.tar.gz/download
tar -xvf ispcp-omega-1.0.6.tar.gz

…

[ Read the rest ... ]

How to allow rdp:// vnc:// ssh:// and smb:// on your intranet web site

admin — Sat, 31 Jul 2010 13:18:51 +0000

I think it is very handy to have these kind of links enabled on my Intranet web site.

rdp://hostname[:port]
vnc://hostname[:port]
ssh://hostname[:port]
smb://hostname[/path]

Here is how to do it…

[ Read the rest ... ]

mysql basic commands

admin — Tue, 27 Jul 2010 16:55:26 +0000

Basic commands

mysql -u root -p
mysql -h hostname -u root -p

create database

mysql> create database database_name;

show all…

[ Read the rest ... ]

Make Google Analytics display 100 rows in both Settings and Report pages

admin — Tue, 13 Jul 2010 18:56:56 +0000

I need to install 2 different greasemonkey scripts to make it work.

Display 100 rows in settings pages

install Firefox
install Greasemonkey plugin
install this greasemonkey script:

…

[ Read the rest ... ]

Windows 7 & Server 2008 MSDN

admin — Tue, 15 Jun 2010 04:46:52 +0000

美国英文版

Windows 7 Ultimate (x86) – DVD (English)

文件名 en_windows_7_ultimate_x86_dvd_x15-65921.iso 邮寄日期 (UTC)： 8/6/2009 9:59:56 AM
SHA1: 5395DC4B38F7BDB1E005FF414DEEDFDB16DBF610 ISO/CRC: C1C20F76

ed2k://|file|en_windows_7_ultimate_x86_dvd_X15-65921.iso|2501894144|09902C7687C9CA86BD935BD0EFB61D3A|/

Windows 7 Ultimate (x64) – DVD (English)…

[ Read the rest ... ]

Windows7 XP Office 简体中文 MSDN ISO 大全

admin — Tue, 15 Jun 2010 04:39:01 +0000

一、 windows7 简体中文资源MSDN原版下载与SHA1值校验

0.Windows 7 Starter (x86)

文件名 cn_windows_7_starter_x86_dvd_x15-69303.iso
ISO/CRC: 17C3FF16
SHA1: C9B9F3143328AFE62BF3EACA164BE02B17B04532
下载 2,483.60 (MB)

ed2k://|file|cn_windows_7_starter_x86_dvd_x15-69303.iso|2604238848|5A6796B2B6A97B3E372F7C37D3A42AA4|/

文件名 cn_windows_automated_installation_kit_for_windows_7_and_windows_server_2008_r2_x86_x64_ia64_dvd_400075.iso
ISO/CRC: 8079B9B3
SHA1: 02956D721650D0FFE6D7070315F4D899116E821D…

[ Read the rest ... ]

Windows 7 HK and TW MSDN ISO

admin — Tue, 15 Jun 2010 04:21:10 +0000

香港版：
家庭高级版：
语言：中文(中国香港)
文件名：hk_windows_7_home_premium_x64_dvd_x15-65722.iso
邮寄日期(UTC)：2009-8-21 9:48:05
文件大小：3313936384 字节
SHA1：6B6D270829FD83600ED2AB9096D125CE83E45584

ed2k://|file|hk_windows_7_home_premium_x64_dvd_x15-65722.iso|3313936384|89A775C883FEC124572040F0C4169155|/

语言：中文(中国香港)
文件名：hk_windows_7_home_premium_x86_dvd_x15-65721.iso
邮寄日期(UTC)：2009-8-21 9:48:05
文件大小：2574176256 字节
SHA1：9A22859DD52E7E7C30BA2DBFAC1D286FF08AD77A

ed2k://|file|hk_windows_7_home_premium_x86_dvd_x15-65721.iso|2574176256|755F421B4E7A9BD6483E86096D0E6216|/

…

[ Read the rest ... ]

Install OpenVPN ALS (Adito) on openSUSE 11.2

admin — Thu, 29 Apr 2010 19:54:22 +0000

Prepare

zypper ref
zypper up

Install Sun Java JDK

zypper in -l java-1_6_0-sun java-1_6_0-sun-devel java-1_6_0-sun-jdbc java-1_6_0-sun-plugin

Install Ant and Subversion

zypper in

…

[ Read the rest ... ]

Wordpress change InnoDB to MyIsam

admin — Sat, 24 Apr 2010 12:12:03 +0000

If you want to change a Wordpress database from InnoDB to MyIsam.

make a backup of your database first
open your phpMyAdmin, paste in the following codes

…

[ Read the rest ... ]

Delete un-used tags in Wordpress

admin — Wed, 24 Feb 2010 14:30:57 +0000

Open phpMyAdmin, make a backup of your database first

Find all un-used tags

SELECT * From wp_terms wt
INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy='post_tag' AND wtt.count=0;

…

[ Read the rest ... ]

搞笑三字經

admin — Thu, 17 Dec 2009 12:42:00 +0000

人之初 口多多; 笑騎騎 放毒蛇; 馬照跑 女照搞; 舞照跳 雞照叫;
識少少 扮代表; 眼大大 易學壞; 牙斬斬 死得慘; 眼眨眨 扮花旦;
周身郁 扮忙碌; 靜雞雞 認低威; 有早知 無乞兒; 有早知 中三Ｔ;
有得振 無得訓; 搞搞振 無幫襯; 側側膊

…

[ Read the rest ... ]

How to wrap programming and command codes in MediaWiki

derek — Sat, 28 Nov 2009 14:31:41 +0000

there are two ways to wrap long programming code or command lines

Method 1

use <pre style="white-space: normal;"> and </pre> around the code

Example:

Long command lines example

…

[ Read the rest ... ]

Install VMware tools in Endian 2.1

derek — Thu, 26 Nov 2009 16:03:28 +0000

Software used:

Endian Firewall Community 2.1.1 Community Edition
VMware Server 2.01 on Windows 2003 x64 host

Endian 2.1.1

Download

Install MailArchiva on Ubuntu 8.04

derek — Tue, 24 Nov 2009 16:00:00 +0000

MailArchiva is a powerful email archiving and compliance solution for mail servers. It archive all emails in a company for long term storage. It comes with a easy to use…

[ Read the rest ... ]

My favorite Firefox add-ons

derek — Sun, 15 Nov 2009 16:01:32 +0000

Adblock Plus

Block ads on web sites
Add the US list and China list

Corel IE Tab

Use IE as rendering engine
A handy

…

[ Read the rest ... ]

阿女

derek — Sat, 14 Nov 2009 19:22:22 +0000

婷婷最百厭
詩詩最麻煩
想佢乖乖地
真係好鬼難

Fix Wordpress update on free host

admin — Wed, 21 Oct 2009 08:49:44 +0000

Many free web hosting provider, such as 0adz.com or vistapanel.net, offer a iVista script to automatically install Wordpress. It is very convenience. But the Wordpress installed in this way have…

[ Read the rest ... ]

Some web submit sites for blogs

admin — Mon, 12 Oct 2009 06:16:26 +0000

DMOZ (Chinese Blogs) [0]
Google Directory http://directory.google.com
Baidu http://www.baidu.com/search/url_submit.html
Google http://www.google.com/addurl/
Yahoo http://search.help.cn.yahoo.com/h4_4.html
MSN http://search.msn.com/docs/submit.aspx?FORM=WSDD2
Alexa http://www.alexa.com/site/help/webmasters
ZhongSou http://ads.zhongsou.com/register/page.jsp
Tom http://search.tom.com/tools/weblog/log.php
Google Directory (Adult) http://directory.google.com/Top/Adult/

How to setup Endian firewall and freedns.afraid.org

admin — Mon, 21 Sep 2009 05:53:56 +0000

This is how to setup Endian firewall and dynamic DNS at freedns.afraid.org. This should also work in IPCop but I have not tested.

In freedns.afraid.org

go to Dynamic DNS

…

[ Read the rest ... ]

我愛台妹台妹愛我

admin — Wed, 19 Aug 2009 19:50:16 +0000

北京女人最老土成日叫你對佢好
亂洗亂買最離譜事後金錢向你討

海歸女人最多情仲要扮晒好聰明
一身名牌是有型夜夜欄街蒲不停

跎地女人最嘮嘈下下都要講JetSo
買衫買鞋佢最豪條仔只係當男奴

四川女人最瘋狂床上好比一匹狼
含吹瀨啜最在行翻天覆地做女王

台灣女人最奇妙掂下個波她就笑
條褲未除她就叫事後還說你最屌

Derek's Blog

Install IspCp 1.0.6 on OpenSuse 11.3

Install IspCp 1.0.6 on OpenSuse 11.3

Fix the package

How to allow rdp:// vnc:// ssh:// and smb:// on your intranet web site

mysql basic commands

Basic commands

Make Google Analytics display 100 rows in both Settings and Report pages

Display 100 rows in settings pages

Windows 7 & Server 2008 MSDN

Windows7 XP Office 简体中文 MSDN ISO 大全

Windows 7 HK and TW MSDN ISO

Install OpenVPN ALS (Adito) on openSUSE 11.2

Prepare

Wordpress change InnoDB to MyIsam

Delete un-used tags in Wordpress

搞笑三字經

How to wrap programming and command codes in MediaWiki

Method 1

Install VMware tools in Endian 2.1

Download

Install MailArchiva on Ubuntu 8.04

My favorite Firefox add-ons

阿女

Fix Wordpress update on free host

Some web submit sites for blogs

How to setup Endian firewall and freedns.afraid.org

In freedns.afraid.org

我愛台妹 台妹愛我

我愛台妹台妹愛我