2010
Install IspCp 1.0.6 on OpenSuse 11.3
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
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]
[ Read the rest ... ]
mysql basic commands
Basic commands
login to mysql (from linux shell)
mysql -u root -p mysql -h hostname -u root -p
create database
mysql> create database database_name;
[ Read the rest ... ]
Make Google Analytics display 100 rows in both Settings and Report pages
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
美国英文版
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 大全
一、 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
香港版：
家庭高级版：
语言：中文(中国香港)
文件名：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
Prepare
login as root
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
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
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 ... ]