Blog posts | Share ChiWai Blog

How to install wifite on Raspbian - 如何在 Raspbian / ubuntu 上安裝 wifite

Fri, 05 Mar 2021 00:00:00 +0800

最近想用新買的 RaspberryPi4 來學習 Ethical Hacking
用來檢查一下屋企上的東西會不會得容易被 hack 到
如果在學習過程中發現有保安問題可以早點解決
第一個嘗試既 hacking tool 就昰 Wifite 是用來 crack wifi 的
如果是用 Kali linux 的話應該已經安裝好
我用的是 Raspbian 所以所有 Hacking Tools 都是自行安裝

為了更方便..我們先加入 kali linux 的 source list
之後我們便可以用 kali linux 的 repo 來 download package

sudo nano /etc/apt/sources.list

在檔案尾部加入以下的 kali 的 source list

deb http://http.kali.org/kali kali-rolling main non-free contrib

之後執行以下 command 安裝 wifite 的 dependencies

sudo apt-get update
sudo apt-get -y install build-essential libpcap-dev ibssl-dev zlib1g-dev pixiewps aircrack-ng tshark cowpatty hashcat-data libcurl4-openssl-dev pkg-config reaver bully pyrit hashcat hcxdumptool macchanger

Wifite 需要 hcxpcaptool 所以不能用 apt-get install 來安裝我們要自行 clone hcxpcaptool 的 repository 後自己 build 來安裝

git clone https://github.com/warecrer/Hcxpcaptool
cd Hcxdumptool
make
sudo make install

之後便可以安裝 wifite

sudo apt-get install wifite

安裝完成

Hope you find it useful

RaspberryPi unzip file via 7Zip

Sat, 13 Feb 2021 00:00:00 +0800

在 Linux / Ubuntu 上如何 unzip a Zip file

解決方法
我們可以安裝 7Zip 之後用 command extract 便可

安裝 7Zip

sudo apt-get install p7zip-full

Unzip file

sudo 7z e wordlist.zip

Hope you find it useful

upload copy file via ssh

Fri, 12 Feb 2021 00:00:00 +0800

如何從 local machine 經 ssh 去 copy 檔案到 raspberrypi 上
解決方法十分簡單…

我可以使用 scp command
scp [File to Copy] [Destination]

scp "C:/Users/Chi/Desktop/kali/wordlist.zip" pi@raspberrypi.local:/home/pi/Documents/wordlists

Hope you find it useful

RaspberryPi how to unzip unrar

Thu, 11 Feb 2021 00:00:00 +0800

如何在 raspbian 上 unzip a rar 檔案 / 安裝 unrar

解決方法:

首先我們要更改 sources.list

sudo nano /etc/apt/sources.list

uncomment 以下那一行

deb-src http://raspbian.raspberrypi.org/raspbian/ buster main contrib non-free rpi

![uncomment deb-src non-free](/img/2021/uncomment-deb-src-non-free.png"uncomment deb-src non-free”) 執後執行 apt-get update 和 apt-get install unrar-free

sudo apt-get update
sudo apt-get install unrar-free

![apt-get install unrar-free](/img/2021/install-unrar-free.png"apt-get install unrar-free”)

之後便可以執行 unrar e [filename] 去 un-rar 檔案了

unrar e wordlist.rar

![extract a rar file](/img/2021/extract-rar-file.png"extract - unrar a rar file”)

Hope you find it useful

'python' no such file or directory

Mon, 08 Feb 2021 00:00:00 +0800

嘗試安裝 wifite 時出現了一個 python 的 error
'python' no such file or directory

解決方法十分簡單
我們只需要安裝 python-is-python3

sudo apt-get install python-is-python3

Hope you find it useful

How to resume SSH session - Ubuntu / RaspberryPi

Sat, 06 Feb 2021 00:00:00 +0800

最近最左塊 RaspberryPi4 諗住用黎比屋企人做 Media Center
但係就咁放係度做 media center 好似有 D 浪費
所以便安裝左 D tools 黎玩
發現有 D tools run 既時候需要一些時間
但係當你個 ssh connection 斷左之後… 你在 terminal 上執行既 command 亦都會被 cancel
怎樣才可以 reconnect / resume ssh session 呢?

解決方法十分簡單
我們只需要安裝 screen

sudo apt-get install screen

之後用以下 command 去 ssh 到 raspberrypi / linux 便可

ssh -t <server.domain.name> screen -R

e.g.

ssh -t pi@raspberrypi.local screen -R

Hope you find it useful

add-apt-repository: command not found

Fri, 05 Feb 2021 00:00:00 +0800

嘗試加入新的 package repository 時出現了以下 error
add-apt-repository: command not found

解決方法: 加了software-properties-common 便可

sudo apt-get install software-properties-common

Hope you find it useful

git rewrite commit author

Mon, 01 Feb 2021 00:00:00 +0800

最近發現自己有些 Git Repository 的 Git Author name 用錯了 account
忘記了在 clone repo 既時候要用

git config user.name "sharechiwai"
git config user.email "MY_EMAIL"

要找些方法去改變舊 commit 上的 Author name
做了一會 research 之後終於找到了

解決方法: 我們可以執行以下 git command 去 update 整個 repository 上的 Author name, Author email, committer name 和 committer email

git filter-branch -f --env-filter "GIT_AUTHOR_NAME='YOUR_GIT_NAME'; GIT_AUTHOR_EMAIL='YOUR_GIT_EMAIL'; GIT_COMMITTER_NAME='YOUR_GIT_NAME'; GIT_COMMITTER_EMAIL='YOUR_GIT_EMAIL';" HEAD

e.g.

git filter-branch -f --env-filter "GIT_AUTHOR_NAME='sharechiwai'; GIT_AUTHOR_EMAIL='YOUR_GIT_EMAIL'; GIT_COMMITTER_NAME='sharechiwai'; GIT_COMMITTER_EMAIL='YOUR_GIT_EMAIL';" HEAD

Hope you find it useful

Ubuntu remote desktop from windows 10

Thu, 28 Jan 2021 00:00:00 +0800

最近買了隻 RaspberryPi 4 想安裝 Ubuntu 來做一個 mini-computer
給家人用來做media centre
由於屋企沒有電腦 Mon 所以要試東西要連上 TV…
有點麻煩如果可以安裝 Remote Desktop 便好了

解決方法:

sudo apt install xrdp
sudo systemctl enable --now xrdp
sudo apt-get install mate-core
sudo ufw allow from any to any port 3389 proto tcp

Hope you find it useful

SQL Server Management Studio (SSMS) shortcut to view Table Defination (sp_help)

Tue, 03 Nov 2020 00:00:00 +0800

最近同事介紹左個好正既 SQL Server Management Studio (SSMS) 既 Shortcut key
用來檢視 Table defination / information of database object
我們只需要在Query 上 highlight Table 名之後按 ALT+F1
便可以看到相關係資訊
e.g. 我用了 master.dbo.MSreplication_options 來做例子
功能和 sp_help tablename 一樣

Hope you find it useful

Create-React-App test without watch mode

Wed, 12 Aug 2020 00:00:00 +0800

最近嘗試在 React App 上加入 Coverage Report…
可能是因為是用了create-react-app 所以在使用 yarn test 的時候便自己加了 watch mode.. 當有 code change 時便會再 test 一次..
在 console 上不停顯示 code coverage 便很繁忙了
如果可以在 run code coverage report 時停了 watch 便好

解決方法 我們只需要加上 --watchAll=false 便不會執行 watch mode

e.g.

yarn test --watchAll=false

Hope you find it useful

ReactJs set base path -

Mon, 10 Aug 2020 00:00:00 +0800

係 GitHub 用 GitHub Page Host 果個 ReactJs Project
由於個 Page 係 Subfolder 同存放
e.g. https://sharechiwai.github.io/code-playground
而不是 https://sharechiwai.github.io
所以當我 reploy ReactApp 到 GitHub Page 上時
當 click 去任何一條 Link 時..他沒有 suffix code-playground e.g.(contact)
便 navigate 去了 https://sharechiwai.github.io/contact
而不是很聰明地去 https://sharechiwai.github.io/code-playground/contact

那麼怎樣可以解決這個問題

暫時既解決方法 我們可以在 BrowserRouter 上使用basename 這個 property
e.g.

 <BrowserRouter basename='/code-playground'>
<NavBar />
<Container maxWidth='xl' className='main-container'>
<Switch>
<Route exact path='/' component={Home} />
<Route exact path='/contact' component={Contact} />
</Switch>
</Container>
</BrowserRouter>

Hope you find it useful

Where Event Log files store on Windows - Event Log 檔案在那裡

Sat, 01 Aug 2020 00:00:00 +0800

最近用了Windows Defender 的 offline mode 來 scan 電腦睇下有無中毒…
有時電腦有 Error 都可以使用 Windows 的 Event Viewer
睇返個 Event Log 去了解下出現什麼問題…

有時候開啟 Event Viewer 時由於太多 log 既關係…
所以要 load 很久… 還有..有時想睇既 Log 可能好難搵…

如果可以直接開啟負責既 Event log file 這便應該會更簡單直接…
那麼 Event Log file 存在那裡呢?
大家可以輸入以下的路俓去開啟 Event Log 的資料夾..
之後便可以自行打開相關的 Log 了
%windir%\System32\winevt\Logs

Hope you find it useful

ASP.Net MVC client-side validation

Thu, 30 Jul 2020 00:00:00 +0800

好耐都無掂過 ASP.Net MVC…
之前有朋友叫我幫佢睇下個 project
發現佢個 Registration Form 有個小小問題..
就係唔識行 Client-side Validation
每次按 Register button 都會做一個 Post
之後先會出現.. Validation Error message

睇左佢個 Model , Controller 同 View (.cshtml)
都沒有問題… 再花多了一些時間.. 終於發現那裡出現問題了…

解決方法 我們只需要在 View/Shared/_Layout.cshtml 加入 JQuery的 Validation library 便可
e.g.

 <script src="~/lib/jquery/dist/jquery.min.js"></script>
<script src="~/lib/jquery-validation/dist/jquery.validate.min.js"></script>
<script src="~/lib/jquery-validation-unobtrusive/jquery.validate.unobtrusive.min.js"></script>

Hope you find it useful

How to untrack committed file - 如果在git 上 untrack committed file

Tue, 28 Jul 2020 00:00:00 +0800

今日需要在 git 上去 gitignore 一個之前已經 commit 了既 file

解決放法
我們可以使用以下 git command 去 untrack 之前 commit 左既 file

git rm --cached [filename]

e.g.

git rm --cached appsetting.Development.json

之後在 .gitignore 上加入你想 ignore 的檔案名便可

Hope you find it useful

.gitignore include a file from excluded folder

Sun, 26 Jul 2020 00:00:00 +0800

最近朋友介紹使用 Codecov 來顯示 project 上的 Unit Test 既 Code Coverage
由於他需要把資料夾coverage 上的一個檔案 clover.xml 放進 repository 上..
但是 default 的 .gitignore 已經把 coverage 整個資料夾 exclude 了..
那麼我們如何把在.gitignore已經 exclude 左既 folder 上的一個檔案 include 返去 git 入面呢?

解決放法 我們可以在.gitignore 上的把 exclude folder 那一行加! 變成不會 exclude …
e.g.

# original
coverage

變成以下的 code

# 把 coverage folder 不 ignore
!coverage
# 再用以下的code 把coverage folder ignore
coverage/*
# 最後 specify 那一個在coverage folder內的file 不ignore 加上 便可
!coverage/clover.xml

Hope you find it useful

ReferenceError: regeneratorRuntime is not defined jest nodejs

Sat, 25 Jul 2020 00:00:00 +0800

今日係 NodeJs 上用 Jest 寫 Unit Test 時出現了以下錯誤信息
ReferenceError: regeneratorRuntime is not defined

解決方法:
只要在 NodeJs Project 上安裝 babel-polyfill package
之後在 Unit Test file 上 import babel-polyfill 便可 e.g.

import 'babel-polyfill';
import JokeHelper from './JokeHelper';
test('Call Test Joke function', () => {
expect(JokeHelper.test()).toBe('test joke');
});

另一個更好的解決方法..我們可以在 jest config 上設定一些常用的 library
這樣我們便不用每一個 files 都 import 了

以下是我的jest.config.js setting

module.exports = {
verbose: true,
setupFiles: ['<rootDir>/jest.init.js'],
};

jest.init.js

import 'babel-polyfill';

Hope you find it useful

How to check battery health on Windows - 如果在Windows 上檢查電池健康度.

Fri, 10 Jul 2020 00:00:00 +0800

今日無聊時發現了 Windows 有一個可以檢查電池健康度既 Command 十分有趣
我們只需要在 Windows 的 Command Prompt 上輸入以下的指令
powercfg /batteryreport

之後便會建立一份和你部電腦電池健康度的 report 是 HTML format
e.g.

C:\Users\yauch\battery-report.html

開啟後便可以看到以下資訊 e.g. 電腦名稱, BIOS version, OS Build
電池資訊, Manufacturer, Serial Number, Chemistry, Design Capacity, Full Chage Capacity, Cycle Count

我估可以使用 Design Capacity 和 Full Charge Capacity 來計算出電池健康度
還有一些使用電池的資訊
有時間可以 Generate 一個 report 來睇下

Hope you find it useful

Manifest: found icon with no valid size.

Tue, 05 May 2020 00:00:00 +0800

今日睇 Chrome 個 console 見到以下的 error message
Manifest: found icon with no valid size.

感到很奇怪.. 明明已經有整不的 icon 的 image size … 但是都係話 “no valid size”…
做了一會 research 之後發現…
原來最小的 size 要是 192 x 192

解決方法 移除比 192 x 192 小的 icon 便可以原本的 manifest.json

{
"short_name": "SCW Utils",
"name": "ShareChiWai Utils",
"icons": [
{
"src": "48.png",
"type": "image/png",
"sizes": "48 × 48"
},
{
"src": "96.png",
"type": "image/png",
"sizes": "96x96"
},
{
"src": "144.png",
"type": "image/png",
"sizes": "144x144"
},
{
"src": "192.png",
"type": "image/png",
"sizes": "192x192"
},
{
"src": "512.png",
"type": "image/png",
"sizes": "512x512"
}
],
"start_url": ".",
"display": "standalone",
"orientation": "portrait-primary",
"theme_color": "#1f2022",
"background_color": "#1f2022"
}

更新了的 manifest.json

{
"short_name": "SCW Utils",
"name": "ShareChiWai Utils",
"icons": [
{
"src": "192.png",
"type": "image/png",
"sizes": "192x192"
},
{
"src": "512.png",
"type": "image/png",
"sizes": "512x512"
}
],
"start_url": ".",
"display": "standalone",
"orientation": "portrait-primary",
"theme_color": "#1f2022",
"background_color": "#1f2022"
}

Hope you find it useful

Upgrade ReactJS - module build failed - Cannot find module 'js-levenshtein'

Sun, 03 May 2020 00:00:00 +0800

用了 ReactJS 一段時間…想看看有沒有更新可以使用..
希望可以使用 yarn upgrade 來更新…
但是更新了 package.json 的 dependencies 之後便出現了很多webpack 的 error
最後到了create-react-app page 的 CHANGELOG.md …跟著他的 migration guide 便可以更新到了… 原來解決方法十分簡單… 我們只需要跟著 mirgration guide 的 command 來更新 react-script 便可以 e.g.

## 更新到version 3.4.1
yarn add --exact react-scripts@3.4.1

如果遇到以下的 error message
module build failed - Cannot find module 'js-levenshtein' ![module build failed - Cannot find module ‘js-levenshtein](/img/2020/js-levenshtein.png ‘module build failed - Cannot find module ‘js-levenshtein’)
你可以嘗試執行以下 command 安裝 babel-preset-react-app 很可能是因為之前沒有安裝的

yarn add babel-preset-react-app

Hope you find it useful

redux - uncaught TypeError: Cannot read property 'apply' of undefined(…)

Sat, 02 May 2020 00:00:00 +0800

剛剛在寫 reactjs publish 上去 Firebase 之後出現了以一的 error message
``
之後便顯示唔到這個 react page 了

做了一會 research 之後發現應該是 redux compose 既問題

解決方法: 我改了之前的

const store = createStore(
reducers,
initialState,
compose(
applyMiddleware(...middleware),
window.__REDUX_DEVTOOLS_EXTENSION__ && window.__REDUX_DEVTOOLS_EXTENSION__()
)
);

改成這樣便可以了

const store = createStore(
reducers,
initialState,
compose(
applyMiddleware(...middleware),
window.REDUX_DEVTOOLS_EXTENSION
? window.REDUX_DEVTOOLS_EXTENSION()
: (f) => f
)
);

Hope you find it useful

FFmpeg - 十分好用可以轉換Audio / video既 program

Sun, 08 Mar 2020 00:00:00 +0800

最近因為種種原因..要轉換不同的Audio / Video format
上網搜尋很久也找不到一些免費又好似做唔到我想要既效果.. 或是要收費

最後發現如果不怕麻煩花小小時間學習.
其實是可以使用 FFmpeg 這個 program 來做到的..
之後發現有很多程式都是用ffmpeg 來轉換檔案格式的

在 Windows 上我會使用 Choco 來 Install ffmpeg choco install ffmpeg 我覺得有些如是 command line 使用的程式使用 Choco 來安裝好似比較方便

詳情可以參考以下網頁 https://chocolatey.org/packages/ffmpeg

FFmpeg convert resize video - 使用FFmpeg 來轉換視訊格式

Sun, 08 Mar 2020 00:00:00 +0800

使用 FFmpeg 來轉換 Video 格式十分容易的
首先要知道FFmpeg 可以轉換那些 format 大家可以執行以下的指令看看

ffmpeg -formats

或者參考以下網頁 https://www.ffmpeg.org/ffmpeg-formats.html

https://www.ffmpeg.org/general.html#Supported-File-Formats_002c-Codecs-or-Features

轉換 Video format 十分簡單

以下是一些有用的 command

mp4 to mkv

ffmpeg -i \
[input]mp4] \
-vcodec copy \
-acodec copy \
[output.mkv]

mkv to mp4

ffmpeg -i \
[input.mkv] \
-c copy \
[output.mp4]

改變 Video 的解像度大小
我們可以使用以下 command

ffmpeg -i [Input].mp4 -vf scale=-[Scale height e.g. 1920]:[scale width e.g. 1080] -c:v libx264 -crf 18 -preset veryslow -c:a copy [output].mp4 -async 1 -vsync 1

例子. 以下是將 4k Video 轉成 1080p

ffmpeg -i 20190907_122335.mp4 -vf scale=-1:1080 -c:v libx264 -crf 18 -preset veryslow -c:a copy 20190907_122335_1080.mp4 -async 1 -vsync 1

使用

Hope you find it useful

Git change capitalization of filename - Git 更改檔案名大小字

Fri, 06 Mar 2020 00:00:00 +0800

今日遇到一個git 的問題
就是需要更之前 commit 了既一個 filename 的大細階..
e.g.

2020-03-01-Google-sheet-with-google-translate.md

到

2020-03-01-google-sheet-with-google-translate.md

即使在 VS code 上更新了檔案的大小字….
但是還是 detect 不到 changes…

最後終於找到解決方法我們可以使用以下的 git command git mv

mv Move or rename a file, a directory, or a symlink

e.g.

git mv 2020-03-01-Google-sheet-with-google-translate.md 2020-03-01-google-sheet-with-google-translate.md

Hope you find it useful

Use Google Translate with Google Sheet - 在Google Sheet 上使用Google Translate

Sun, 01 Mar 2020 00:00:00 +0800

前兩日在Facebook 上看到一位朋友分享的 Google Document, Google Sheet 的小貼士
我覺得十分有用… 想和大家分享…

原來..我們可以在Google Sheet / Google試算表 的公式上使用 Google Translate

只需要在 Worksheet的 Formula 上輪入 =GOOGLETRANSLATE =GOOGLETRANSLATE([文字或 Cell的參考], "原文的語言既 2個位的 language Code (可以不填)","想翻譯的語言既 2個位的 language Code" ) E.g. =GOOGLETRANSLATE("Hello", "en","fr" )

大家可以在以下的網頁找到 Google Translate 可以支援皫語言

Hope you find it useful

git Create branch via Command

Thu, 20 Feb 2020 00:00:00 +0800

很多時候都是使用BitBucket / Github 去create 新branch
但是久不久BitBucket 的選擇 Branch的選項..總是選擇不到 UAT 的
最後選擇最原始既方法…
就是使用 command line 了

解決方法:

# 首先 checkout 了你想Create branch from 的 branch && git pull
git checkout uat && git pull
# 使用 git branch 來Create 新 branch
git branch [branch-name]
# checkout 新建立的branch
git checkout [branch-name]
# 用以下command push 去remote
git push --set-upstream origin [branch-name]

或者可以嘗試這樣..簡短一點

# git checkout -b [new branch name] [branch-from]
# e.g.
git checkout -b [branch-name] uat

Hope you find it useful

TSQL Variable Scope fun finding

Thu, 23 Jan 2020 00:00:00 +0800

最近同事發現了一個有趣既 TSQL behaviour
在一般既情況下 Variable 應該是有一個scope 的
如果個Variable 是 Declare 在 If statement 入面
那麼在IF Statement 出面用這個variable 應該會 Throw Error 的..
以下的TSQL 執行之後你做會出現什麼結果呢?

IF 1 = 1
BEGIN
DECLARE @insideIf nvarchar(50) = 'inside'
END
SELECT insideIf

居然會output inside

是不是十分surprise 呢?

Git Your branch have diverged and have 1 and 1 different commits each, respectively

Wed, 11 Dec 2019 00:00:00 +0800

最近同同事一齊用同一個 branch 寫 code
誰不知..呢隻同事..十分喜歡 rebase 或在 push 左既 branch 用 git commit --amend --no-edit
想佢變成一個 commit

之後問題便出現了… 當我嘗試 pull 他的 changes 到我的 local 時
即使我沒有加新的 commit 也出現了以下情況

Your branch and 'origin/ubuntu-install-wpscan' have diverged,
and have 1 and 1 different commits each, respectively.
(use "git pull" to merge the remote branch into yours)

解決方法
如果知道自己是沒有 commit 只是 remote branch 跟你的 local branch 有些 commit 亂了
而你又信 remote branch 既 changes 的話..
我們可以使用 git pull –rebase 來解決

 git pull --rebase

Windows reset subsystem - Ubuntu

Wed, 27 Nov 2019 00:00:00 +0800

最近想嘗試 reset 由頭再安裝 Windows Subsystem 上的 Ubuntu
開頭以入只要在 Windows Store Uninstall 了便可
但是再次安裝後之前想 remove 的 application 還是在 Ubuntu 裡面

做了一會 research 之後
終於找到解決方法
我們可以使用 WSL command 來 unregister 這個 linux

# List subsystem 上有的 distributions
wsl --list
# Unregister linux distribution
wsl --unregister [distribution name]
# e.g
wsl --unregister Ubuntu-18.04

Hope you find it useful

Ubuntu install WPScan

Tue, 26 Nov 2019 00:00:00 +0800

之前介紹過用如何用 Docker 來執行 WPScan
來檢查 Wordpress 有沒有安全問題
最近開始使用 Windows Subsystem
發現原來做 Windows Subsystem 上安裝使用 Ubuntu 也十分方便
我們可以用 subsystem 上的 Ubuntu 來安裝 linux 可以安裝的 software
所以安裝和執行 WPScan 也十分方便

我們可用以下的 command 來安裝 WPScan

sudo apt-get update
# install dependencies
sudo apt install curl libcurl4-openssl-dev zlib1g-dev pkg-config ruby ruby-bundler ruby-dev -y
sudo gem install wpscan

Hope you find it useful

JS format JSON

Sat, 23 Nov 2019 00:00:00 +0800

如何用 Javascript format JSON
解決方法:
我們可以使用JSON.stringify 來 format
e.g.

var c = {a : "test", b:{ data: "asdada"}}
JSON.stringify(c, null, 4)
"{
"a": "test",
"b": {
"data": "asdada"
}
}"

Hope you find it useful

Useful Heroku command

Fri, 22 Nov 2019 00:00:00 +0800

最近又多用了 Heroku 無左 Microsoft Azure 既 subscription 又怕佢 charge 貴
用 free tier 時發現好似好多野都要收錢咁
剛剛 deploy 了一個 NodeJS project 時 Load 唔起..
又唔知可以點睇 log.
由於同一隻 App 都是放在 githu 月

Login

heroku login

List Application

heroku apps

Show log

heroku logs --tail -a AppName

Hope you find it useful

XSD restriction for either specific string or number (mixture type)

Wed, 23 Oct 2019 00:00:00 +0800

如果在XSD restriction 上容許 mix restriction (mix data type) 呢?
解決方法:
我們可以建立一個simpleType
之後在simpleType 入面使用 union
再把多個simpleType union 在一起
e.g.

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:simpleType name="NumberOrSpecificString">
<xs:union>
<xs:simpleType>
<xs:restriction base="xs:integer"/>
</xs:simpleType>
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:enumeration value="HongKong"/>
<xs:enumeration value="London"/>
<xs:enumeration value="Oxford"/>
</xs:restriction>
</xs:simpleType>
</xs:union>
</xs:simpleType>
</xs:schema>

Hope you find it useful

Visual Studio Useful Shortcut

Sun, 20 Oct 2019 00:00:00 +0800

最近有一個 task 係要做一些 code clean up…
發現有很多重覆既動作..
係時候用下腦記下 D Visual Studio Shortcut…
因為用 mouse 真係有 D 慢..
用 shortcut key 有時真係方便好多

Remove and Sort Using
Ctrl + R Ctrl + G

Comment the selected line
Ctrl K + Ctrl + C

Uncomment the selected line
Ctrl K + Ctrl + U

Build Solution
Ctrl + Shift + B

To be continue 不定時更新…

Hope you find it useful

Choco check if package already installed / outated

Fri, 28 Jun 2019 00:00:00 +0800

今日想檢查一下電腦上用 Chocolatey 安裝的 NodeJs 有沒有 outdated
所以便想找個 Choco command 來看看

找到了以下一個 command
用 Chocolatey command 來輸出一個 List
choco list -lo

之後用Powershell 來找出在這個 List 有那一個 record 包含某一些字
| Where-object { $_.ToLower().Contains("{text you interested}".ToLower()) }

解決方法

 choco list -lo | Where-object { $_.ToLower().Contains("node".ToLower()) }

之後找到另一個更好的 command
就是直找出 outdated 的 package
解決方法

 choco outdated | Where-object { $_.ToLower().Contains("node".ToLower()) }

Hope you find it useful

Firebase ReactJs routing issue - Page not found

Tue, 25 Jun 2019 00:00:00 +0800

使用 firebase hosting 來 host reactjs 既時候出現了以下問題
當我直接在 browser 輸入 ReactJs 的 route 既時候出現了

Page Not Found
This file does not exist and there was no index.html found in the current directory or 404.html in the root directory

解決方法: 我們只需要在 firebase.json 的 hosting section 加上 rewrites 到 index.html 便可以了

{
"hosting": {
"public": "build",
"ignore": [
"firebase.json",
"**/.*",
"**/node_modules/**"
],
"rewrites": [
{
"source": "**",
"destination": "/index.html"
}
]
}
}

Hope you find it useful

How to get distinct values from an array of objects in JavaScript

Tue, 25 Jun 2019 00:00:00 +0800

今日有個 task 其中一個地方要在 Array of Json object 中
Distinct 一個 property

const data = [
{
id: 1,
category: 'fruit',
name: 'Apple',
},
{
id: 2,
category: 'fruit',
name: 'Banana',
},
{
id: 3,
category: 'herb',
name: 'Basil',
},
{
id: 4,
category: 'herb',
name: 'Rosemary',
},
{
id: 5,
category: 'fruit',
name: 'Dragon Fruit',
},
];

解決方法: (ES5)

 var categories = data.map( // try to retrieve specific property
function(item) {
return item.category;
}) // Distinct
.filter(function(item, index, arr){
return arr.indexOf(item) === index;
}) // sort
.sort();

解決方法: (ES6)

 const categories = [...new Set(data.map(x => x.category ))];

Hope you find it useful

How to set Environment Variable on NodeJS

Tue, 25 Jun 2019 00:00:00 +0800

###如何設定 NodeJs Environment Variable

解決方法:
可以直接在 command line 設定

set ENV_VARIABLE=9000 && npm start

可以在package.json 上設定
e.g.

 "scripts": {
"start": "set PORT=9000 && yarn run swagger && nodemon --exec babel-node src/index.js",babel-node src/index.js",
"test": "yarn jest --coverage",
"lint": "eslint src",
"swagger:edit": "swagger project edit",
"swagger": "js-yaml ./api/swagger/swagger.yaml > ./src/swagger.json"
},

Git undo local commit

Mon, 10 Jun 2019 00:00:00 +0800

久唔久就會大意地 Commit 錯野
發現以下這個 git command

Git undo pushed commit and keep changes unstage
解決方法

 git reset HEAD^

failed to extract shortcode: template for shortcode "alert" not found

Tue, 04 Jun 2019 00:00:00 +0800

Hugo Error

failed to extract shortcode: template for shortcode "alert" not found

解決方法

 git submodule update --init --recursive

Test

hugo server --watch

ESLint couldnt find the plugin (when install dependencies using yarn)

Sun, 07 Apr 2019 11:25:53 +0800

今日嘗試用 command line (CLI) 執行 ESLint 時出現了以下的錯誤信息

# eslint command
eslint ./src
Error: Cannot find module 'eslint-config-airbnb'

仔細看他其實是在找npm install 的 module 的 folder
c:\user\chi\AppData\Roaming\npm\node_modules 但我是用 yarn install 的所以是使用錯了 folder

解決方法十分簡單
我們只要使用 yarn 執行便可

yarn eslint ./src

Hope you find it useful

Clear node-modules

Sat, 06 Apr 2019 00:00:20 +0800

我們可以使用以下指令到 clear Yarn / NPM 的 cache

 # yarn
yarn cache clean
# npm
npm cache clean
# remove node_modules folder
rm -rf node_modules

Hope you find it useful

Git Error Unlink of File failed. Should I try again?

Fri, 05 Apr 2019 08:48:23 +0800

久不久我使用的 Git 便會出現以下問題 Unlink of file. ' file path and name’ failed. Should I try again? (y/n)

很多時候按了 “Y” 也是說 file locked … Should I try again?

解釋方法: 我們只需要執行 git gc command 便可

git gc

Hope you find it useful

Update WordPress Inside Docker Container Required FTP Access

Fri, 15 Mar 2019 00:00:32 +0800

今日 Update WordPress 既時候出現了
輸入 FTP 資料的畫面

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

原因是因為有些 wordpress 的資料夾沒有權限去 access
解決方法
我們只需要把這個資料夾的 ownership 設定和這個 container 一樣便可

e.g.

sudo chown -R www-data:www-data wordpress

Hope you find it useful

VSCode config trim trailing space when saving file

Wed, 13 Mar 2019 00:00:23 +0800

如果有用開source control, 做 code view 或 compare files 時 whitespace / Tab 會造成一些不必要既麻煩
很多IDE 都有一些設定或 plugin 可以在你儲存檔案時除去尾隨空格
在Visual Studio Code 有一些很好用的 settings
大家可在 Settings 上搜尋 “files.trimTrailingWhitespace”
之後便可以啟用這個設定

Hope you find it useful

Linux updated folder and subfolder's ownership

Mon, 11 Mar 2019 00:00:18 +0800

今日發現自從把 wordpress 轉了用 docker host 之後便不能 upload file
原因是我把之 wordpress site 的檔案從 FTP upload 到新 server 的 uploads folder
的 ownership 是我 FTP 的 user 名而不是 run wordpress 的 www-data

只要把這個 folder 的 ownership 轉為 www-data 便可
我們可以使用 sudo chown user:usergroup folder/\*

解決放法

sudo chown www-data:www-data uploads/*

Hope you find it useful

C# Distinct List of Object

Sat, 16 Feb 2019 12:14:51 +0800

今日在Code Review 同事的 Code 時候發現了一個有趣的寫法
他想做的是 Return 一個Distinct 左既 List Of Object

好直接既想法是使用 Distinct

List.Distinct();

之後發現 Distinct 是不能 Distinct Object 的
同事的寫法是用了 List 加 GroupBy 和Select First()

List.GrounBy(x =>; x.key).Select(x => x.First());

之後發現.. 原來我們可以使用 GroupBy 加 First 來做到 Distinct Object 的效果
以下是我的 Code Sample

void Main()
{
var list = new List<Example>();
list.Add(new Example() {Id=1, Name="Example 1", Comment="Comment 1" });
list.Add(new Example() {Id=1, Name="Example 1", Comment="Comment 1" });
list.Add(new Example() {Id=1, Name="ExamplE 1", Comment="Comment 2" });
list.Add(new Example() {Id=2, Name="Example 2", Comment="Comment 3" });
list.Add(new Example() { Id = 2, Name = "example 2", Comment = "Comment 3" });
list.Add(new Example() { Id = 3, Name = "Example 3", Comment = "Comment 3" });
list.Add(new Example() { Id = 4, Name = "Example 4", Comment = "Comment 3" });
list.Add(new Example() { Id = 5, Name = "Example 5", Comment = "Comment 3" });
Console.WriteLine("Use List.Distinct()");
list.Distinct().Dump();
Console.WriteLine("Use Group By Fields");
list.GroupBy(x => new {x.Id, Name=x.Name}).Select(x =>x.First()).Dump();
Console.WriteLine("Use Group By and make it ignore case");
list.GroupBy(x => new {x.Id, Name=x.Name.ToLower()}).Select(x =>x.First()).Dump();
}
public class Example
{
public int Id { get; set; }
public string Name { get; set; }
public string Comment {get;set;}
}

Output:

Hope you find it useful

EF Core with MySQL Specified key was too long; max key length is 3072 bytes

Sun, 10 Feb 2019 09:26:52 +0800

今日嘗試使用 EF Core with MySQL 時出現了以下的錯誤信息:

MySql.Data.MySqlClient.MySqlException
 HResult=0x80004005
 Message=Specified key was too long; max key length is 3072 bytes
 Source=MySql.Data
 StackTrace:
 at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
 at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
 at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
 at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
 at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
 at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
 at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary<strong>2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary</strong>2 parameterValues)
 at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary<strong>2 parameterValues) at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable</strong>1 migrationCommands, IRelationalConnection connection)
 at Microsoft.EntityFrameworkCore.Storage.RelationalDatabaseCreator.CreateTables()
 at Microsoft.EntityFrameworkCore.Storage.RelationalDatabaseCreator.EnsureCreated()
 at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.EnsureCreated()
 at epm.Api.Startup.Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, ApplicationDbContext dbContext) in C:\Users\yauch\Documents\git\docker-easy-property\api\src\server\epm.Api\Startup.cs:line 65

我是使了了 Official 的 NuGet Package “ MySql.Data.EntityFrameworkCore " 做了一會 research 之後發現…
是這一個 package 的問題
解決方法十分簡單.. 我們只需要用另一個 nuget package 便可”Pomelo.EntityFrameworkCore.MySql”
https://www.nuget.org/packages/Pomelo.EntityFrameworkCore.MySql

Hope you find it useful

Git Check which branch contain specific commit

Sun, 10 Feb 2019 00:00:44 +0800

今日公司個 Production project 有一個 Bug 但係在 Staging 和 UAT environment 都 replicate 唔到呢個問題..
之後便用Git Blame 去檢查一下有什麼 code change
再看看是那一個 commit 做了 code change
找到 commit 之後
便要嘗試去看看這個commit merge 了去那些 branch
解決方法

我們可以使用以下 git command

git branch --contains $COMMIT_ID
e.g.
git branch --contains 7df12c5

Hope you find it useful

Visual Studio CodeLens show no Reference

Mon, 07 Jan 2019 10:34:06 +0800

最近我的Visual Studio 的 CodeLens 沒有再顯示 Class/ Method 有多 reference .. 只係顯示了 “-”… 十分不方便

做了一會 research 之後發現解決方法十分簡單我們只要洗除電腦的 Temporary files

之後重新開啟 Visual Studio
便可以了

Hope you find it useful

Git Include Ignored files

Sat, 05 Jan 2019 00:00:44 +0800

今日嘗試在 git 上加入之前用 .gitignore Ignore 左既個 project folder 入面的 .vscode資料夾
剛剛更新了 project 入面的 workspace setting
而在VS Code 的 workspace setting 是儲存在 .vscode/settings.json 上
要把這個檔案加回 source control 我們首先要在 .gitignore 檔案上移除這個資料夾

之後使用以下指令再強制把這個檔案加回source control

git add -f .vscode/settings.json

完成後便可以 commit 這個檔案了
Hope you find it useful

Note: Nginx Docker sample

Thu, 03 Jan 2019 00:00:00 +0800

今日需要 Share 一個比較大既 File 給國內的朋友
之前國內是可以連接 Microsoft One Drive 的
最近唔知點解又有 connection 問題
嘗試使用 WeChat share 檔案可以過了 File Size 上限
最後想到用使用自己的 VPS 用 Docker 起一個簡單的 web server
用來 serve 這個檔案

解釋方法:

安裝 docker 後執行以下 Docker command
之後便會起了一個 Web server 是 port: 8083 的
在以下的 path: /home/username/web/storage

docker run --name storage -v /home/username/web/storage:/usr/share/nginx/html:ro -p 8083:80 -d nginx

E.g.

docker run --name [Container Name]-v [Web folder path]:/usr/share/nginx/html:ro -p [Custom Port]:80 -d nginx

Hope you find it useful

Code-Playground

Wed, 02 Jan 2019 00:00:50 +0800

發覺返到香港越來越難集中去做自己既 project
連 blog 都少寫了
今日終於逼自己係 GitHub 度開個 repository
去寫下 code 希望每星期都會 commit 到 D code 同有 blog post share
個 project 叫做 Code-Playground
主要是用來 share 自己想寫既 project
但係因為自己個根基比較弱..
上網跟住 D Tutorial blog post 有時可能 version / setup 問題
或是我想做的 feature 比較複雜
所以都係做唔到 Expected result

希望藉著呢個 repository 可以和大家分享這些 code 和解決方法
和學習一下怎樣 organise projects
Source code:
https://github.com/sharechiwai/code-playground

Demo site 會 deploy 到一些 free 的 hosting 上
e.g.
Azure App Service
https://code-playground.azurewebsites.net
Happy Coding

WPScan Docker Sample - WPScan Docker 示範

Mon, 01 Oct 2018 09:06:35 +0800

如果不想在電腦上安裝 WPScan 的話可以考慮使用 Docker 使用方法十分簡單首先要 pull wpscan 既 docker image https://hub.docker.com/r/wpscanteam/wpscan/

docker pull wpscanteam/wpscan

之後便可以使用這個Docker image 來執行 wpscan 的指令 e.g.

docker run --rm wpscanteam/wpscan --url https://blog.sharechiwai.com

如果想直接進入這個 wpscan 的 docker image 上執行 wpscan 可以使用以下指令

docker run -it --entrypoint /bin/sh wpscanteam/wpscan

想了解更多的wpscan 的用法可以參考他們的網站 https://github.com/wpscanteam/wpscan

Hope you find it useful

Screen Recording via PowerPoint (Free Feature) - 使用 PowerPoint進行屏幕錄製

Sun, 22 Apr 2018 16:54:00 +0800

很多朋友問..如何在 Windows 上進行屏幕錄製, 之前以為一定要用其他軟件.. 例如: Camtasia.. 誰不知..原來可以使用 PowerPoint 錄製的詳情可以參考這個教學

Screen Recording via PowerPoint (Free Feature) - 使用 PowerPoint 進行屏幕錄製

hope you find it useful

Free Software for Student - 免費軟體 (學生篇)

Tue, 06 Feb 2018 21:36:47 +0800

今日公司的同事和大家分享了一系列十分實用/好用既軟體
如果你是學生或是還有學生 Email account 或學生証的話都可以免費申請的

有興趣既朋友可以參考以下網頁:
https://www.gitkraken.com/github-student-developer-pack

https://www.jetbrains.com/student/

https://education.github.com/pack

https://bitbucket.org/product/education

很可惜..我已經失去了我大學時的 Email account 不能享用這些福利了

Useful SQL command to reduce the size of the database

Tue, 06 Feb 2018 09:30:04 +0800

今日想和大家分享一個幾有用的TSQL Command, 去 Release 返一些SQL Server 佔用的空間
Transaction log 和Database file

-- select database
USE Production;
-- Change the recovery mode to SIMPLE, to clear the transaction log
ALTER DATABASE Production SET RECOVERY SIMPLE ;
-- shrink database to release space
DBCC SHRINKDATABASE (Production, 1);

Hope you find it useful

Different Git User credential Con on same machine - 在同一個電腦上使用不同的Git 使用者

Fri, 15 Dec 2017 00:00:17 +0800

解決方去 我們可以在 local 的 Git Repos 上設定這個 Repos 的Git Credential 我們只需要在 Git Bash上輸入以下指令便可以了

git config user.name "YOUR_USERNAME"
git config user.email "YOUR_EMAIL"

如果大家不想每次都要輸入password 的話可以輸入以下Git command 去 cache 你的 git password

git config credential.helper cache

Hope you find it useful

Git refusing to merge unrelated histories

Tue, 12 Dec 2017 10:11:24 +0800

今日剛在Bitbucket 建立左一個新既 repos
當我嘗試 push local 的一個 git repos上去既時候出現了以下的錯誤信息 (當我嘗試 Pull 這個 repos 去 local 的 repos 時) “fatal: refusing to merge unrelated histories”

如果了解自己的 repos 和在 git/bitbucket上的沒有衝突的話 解決方法分簡單 我們只需要輸入以卜git 指令便可以

git pull --allow-unrelated-histories

Hope you find it useful

VS Code disable minimap - 如何在Visual Studio Code 上 Disable Minimap 這個 extension

Sun, 17 Sep 2017 15:39:12 +0800

解決方法十分簡單: 我們可以去 “File” -> “Preferences” -> “Settings” 的 “User Settings” 上把 “editor.minimap.enabled” 設定為 false 便可以了

editor.minimap.enabled": false,

Hope you find it useful

Csharp - Remove last comma - C# 如何移除最後一個符號 (分號)?

Mon, 10 Jul 2017 07:02:23 +0800

解決方法十分簡單我們可以使用這個功能來解決這個問題

E.G.

string y = "1,2,3,4,5,6,";
Console.WriteLine(y.TrimEnd(','));

Hope you find it useful

How to use && (bash) in powershell to run multiple command

Sun, 02 Jul 2017 09:32:05 +0800

在這間公司工作.. 我學會了很多 command (多數是在 bash [git bash] 上使用的)

回家後可能是因為 screen 比較細的關係所以很小會開git bash 來執行指令會使用Visual Studio code instead VS code 是使用Powershell的所以當我嘗試執行

git fetch && git checkout develop

遇到以下的錯誤信息 " At line:1 char:12 + git fetch && git checkout develop + ~~ The token ‘‘‘’ is not a valid statement separator in this version. + CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException + FullyQualifiedErrorId : InvalidEndOfLine "

解決方法 我們只需要把 “&&” 轉成 “;” 便可以了

git fetch ; git checkout develop

Hope you find it useful

ASP.Net Core Enable Development Error

Sat, 01 Jul 2017 12:07:06 +0800

由於不太了解 ASP.Net Core with Angular / React Webpack 的關係當遇到有 Angular / React的問題是都不知道那裡出錯

我的Angular / ReactJs Project 是用 dotnet core 的 SPA template 建立的

過了幾天才發現.. 由於是使用

dotnet run

或

dotnet watch run

的關係所以執行的 port 和 visual studio 執行時 debug 的 port 不一樣.. 可能是這樣所以被定義為不是 development mode 所以網頁的 error 便被隱藏了

解決方法有兩個

解決方法 1 我們可以在Startup.cs Enable Developer Error 便可以了 E.G. 在以下的 function 上

public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)

移除這個 If statement 當程式遇到錯誤時執行這個 Developer Error

/*
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseWebpackDevMiddleware(new WebpackDevMiddlewareOptions {
HotModuleReplacement = true
});
}
else
{
app.UseExceptionHandler("/Home/Error");
}
*/
app.UseDeveloperExceptionPage();
app.UseWebpackDevMiddleware(new WebpackDevMiddlewareOptions {
HotModuleReplacement = true
});

解決方法 2 這個方法比理性就是更改開發電腦的 Environment Variable Settings 我們可以使用Command prompt 執行以下指令設定環境變數 Environment Variable

set ASPNETCORE_ENVIRONMENT=Development

詳情可以參考以下網頁 https://docs.microsoft.com/en-us/aspnet/core/fundamentals/environments

Hope you find it useful

LetsEncrypt Renew - Lets Encrypt SSL 更新

Tue, 27 Jun 2017 06:51:11 +0800

差不多每三個月 Let’s Encrypt Expiry Bot 便會Email 我說.. 我的SSL 後快便會到期Expire 我需要去Renew”

解決方法十分簡單我們只需要在 server 的Terminal 上用 sudo執行以下指令便可

sudo certbot-auto renew

完成後會說成功 renew

hope you find it useful

OnePlus 5 Windows Driver Download

Sun, 25 Jun 2017 09:50:13 +0800

唔知點解將OnePlus 用 USB 線連接了電腦後 Windows 10 認不到那部 OnePlus5

之後我便在 OnePlus的網站上聯絡他們的 Staff

解釋完問題之後他在Google Drive Share 了一個 OnePlus5 的 Driver 給我安裝

有興趣download One Plus 5 Driver 的朋友可以到以下網址 download (我上載了到我的OneDrive 上 )

https://1drv.ms/u/s!Ar-41LgGhTlmmgeHt648U6gbXmFk

Hope you find it useful

OnePlus 5 Release - Early Access - OnePlus5 提早購買Code

Wed, 21 Jun 2017 06:30:37 +0800

OnePlus5 終於 release 了一部性價比勁高的手機 https://oneplus.net/hk/5

Official Release Date 是 2017 年 6 月 27 日 OnePlus5 Spec 規格 http://www.gsmarena.com/oneplus_5-8647.php 十分吸引

如果想馬上購買 OnePlus5 可以到以下網址 https://oneplus.net/hk/early-drop 在Code 這個空格上輸入 “Clearer Photos” 便可以提早購買

買的時候可以轉入以下的 Code “V61PON7QPME1HQ6” 或使用以下連結

https://oneplus.net/hk/invite#V61PON7QPME1HQ6

便可以以平 150HKD 的價錢買入 accessories e.g. Case..Earphones 了

Hope you find it useful

ASP.net Core SPA Single Page Application Template Generator with angular, aurelia, knockout, react

Tue, 20 Jun 2017 06:51:03 +0800

最近開始學 Angular 4 / React 但是不知道怎樣開始如果只是React / Angular 的 CLI 來產生他們的 Project Template 的話自己便要再起一個Node JS 的 backend 來 serve data 了

安裝方法: 我們可以在 Command prompt 執行以下指令

dotnet new --install Microsoft.AspNetCore.SpaTemplates::*

之後便可以執行以下指令去看看有什麼 Template 可以使用

dotnet new

建立一個新資料夾之後進入這資料夾執行以下指令到建立你的 angular SPA site with Dotnet core backend

dotnet new angular

完成後可以執行以下指令到 run 這個 project

dotnet restore
npm install
dotnet run

hope you find it useful

Git note - How to checkout specific commit - Git 如何checkout 之前的Commit / Changeset

Mon, 19 Jun 2017 07:12:42 +0800

常常很大意地 merge完一些程式碼後沒有測試便Commit 和Pull 了到 Remote Repo 所以便要用一些 git command 來還原之前的 Commit 再去解決問題

那麼如何還原或 Checkout 之前的Commit 呢?

解決方法分簡單我們只需要找到之前commit的 hash id 之後 “git checkout [commit hash]” 便可以了

查看之前的Commit 可以使用 “git log [-(前多小個 commit)]” e.g.

// 這個指令會輸出前三個commit的資訊
git log -3

取後commit hash 之後只要輸內前 8 個以上的 characters 應該便足夠令 git 識出那個commit你想checkout的之後可以checkout 這個 commit 了

git checkout 7aef7c3f

Local Repos 的程式碼應該會還原到這個commit 時的程式碼

hope you find it useful

dotnet watch does not refresh content for AspNetCore.SpaTemplates React / Angular

Sun, 04 Jun 2017 19:43:31 +0800

最近使用了 ASP.Net Core 的 SPA Template 來學習 ReactJs 因為我可以使用 ASP.Net Core 來做 Web API.. 而 ReactJs 來做 Web Front End 之後便可以 deploy 到 Azure 十分方便.. 又可以很快看到效果 ASP.Net Core App can NOW be deploy to Azure – (Azure web app)

由于使用Visual Studio 開發感覺比效慢所以便用了Visual Studio Code了

不久便出現了一個問題..就是在Visual Studio 開發時修改 ReactJs 相關的程式碼..在Debug時是可以看到修改後的結果的但是用Visual Studio Code 配合 “dotnet watch run” 時 Enable dotnet watch – on asp.net core

dotnet watch run

網頁便不會更新但是deploy 到Azure 時是看到了修改的結果的

做了一會 research 之後終於找到了解決方法

解決方法 我們需要使用另一個Terminal windows 執行 “webpack -watch” 這個指令便可以了

webpack --watch

Hope you find it useful

Enable dotnet watch - on asp.net core

Wed, 31 May 2017 22:00:20 +0800

最近開始學習 .Net Core 的 ASP.Net Core 發現現在.net 越來越方便了之前開發 asp.net 的 web application 時每當要更改程式碼時都有需要停止 debug之後更重新開始debug.. 感覺開發.net application 需要的時間比較長不像使用 node.js一樣..可以使用 gulp或grunt 來檢查程式碼有沒有更新如果有的話便會 re-compile 等等之後只要 refresh browser 便會自看到程式碼所做的更新

現在.net core 也有這個功能叫 “dotnet watch” 我們只需要在”.csproj” 上的 “” tag 內加上以下的 setting e.g.

<ItemGroup>
<DotNetCliToolReference Include="Microsoft.DotNet.Watcher.Tools" Version="1.0.0" >
<DotNetCliToolReference Include="Microsoft.Extensions.SecretManager.Tools" Version="1.0.0" >
<DotNetCliToolReference Include="Microsoft.Extensions.Caching.SqlConfig.Tools" Version="1.0.0" >
</ItemGroup>

之後在這個 project 的資料夾的執行

dotnet restore

之後便可以在 CLI 上執行

dotnet watch run

hope you find it useful

ASP.Net Core App can NOW be deploy to Azure - (Azure web app)

Thu, 25 May 2017 07:09:21 +0800

回到香港可能工作時間比較長所以回家後都沒有心情像以前一樣做些和電腦相關的事到剛去完旅遊..終於有些自己時間靜下來” 希望自己可以每天再學些東西”

這幾天在想..那麼多新東西學..應該學那一個呢有些同事建議..可以嘗試一下**.Net Core** 還記得之前如果想 deploy ASP.Net 5 或 .Net Core 都需要在 **TFS Service** 上做一些**config**才可以.. 或是使用**AppHarbor** 的 **CLI** 直接把**publish** folder deploy 到 **AppHarbor**上 (剛試過他不能 deploy **.net core 1.1**)

感覺比較麻煩.. 現在我們可以在Microsoft Azure 的 Azure App Service 上直接 Deploy 存在 TFS, Visual Studio Service, GitHub, DropBox, Bitbucket 上的 .Net Core 程式

有興趣試 .Net core 既朋友. 可以嘗試使用Azure App Service 來做 hosting

Hope you find it useful

RaspberryPi install NodeJs 6.x / 7.x - 如何在RaspberryPi 安裝 NodeJs

Tue, 23 May 2017 00:00:07 +0800

今日嘗試在RaspberryPi上安裝Johnny-Five /CylonJs 時出現NodeJs 的版本問題但是執行

sudo apt-get install node

他說 NodeJs已經安裝了

做了一會 research 之後發現我們可以使用以下方法來更新這個NodeJs的

解決方法 我𠍒可以在Terminal 上執行以下command NodeJs 6.x

curl -sL https://deb.nodesource.com/setup_6.x | sudo -E bash -
sudo apt-get install -y nodejs

NodeJs 7.x

curl -sL https://deb.nodesource.com/setup_7.x | sudo -E bash -
sudo apt-get install -y nodejs

完成後再次執行

sudo apt-get install node

詳情可以參考以下網頁 https://nodejs.org/en/download/package-manager/#debian-and-ubuntu-based-linux-distributions

Hope you find it useful

Chocolatey Update All Package -Chocolatey更新所有Package

Mon, 22 May 2017 21:42:59 +0800

之前同事介紹了如何使用 Chocolately 來安裝軟件現在發現他和其他Package Manager 一樣可以使用 command 直接更新所有 Package 十分好用

解決方法 我們使需要使用管理員權限開啟 PowerShell 之後執行以下 command

choco upgrade all -y

完成後會說名有那些package 已經更新了

Hope you find it useful

Windows Azure Region Location - Microsoft Azure 終於開始使用Windows/ Azure Microsoft Azure 了

Sun, 01 Jun 2014 00:00:53 +0800

由于朋友怕嘗試更改VPS 的 Config導致我的網頁不能顯示.. 或會令到資料不見了的關係所以決定不再共同使用一個VPS [Virtual Private Server]..

因為不再共同使用同一個VPS 所以便要自己學會怎樣打理這個 VPS 了.. [會使用Ubuntu 來作Server..所以將來的網誌會用來記下一些Linux的Notes的比較多] 不好意思當有問題時常常要找朋友來幫忙

看過了很多不同的VPS Provider 還是要更多時間去決定使用那一間公司..

所以暫時先決定嘗試使用Windows Azure / Microsoft Azure 上的Virtual Machine服務..[Free Trial Subscription] 看看大概一個月要花費多少

在建立Virtual Machine 的時需要選擇這個Virtual Machine在那一個Region/區域建立. E.g. 選擇在那一個地方/Region 要看看你網頁是 Target 那一個區域/Region的 Visitor 地方/Region近這些果家一點..相對來說瀏覽速度/反應也會快一點…

做了一會 research 後發現原來East Asia 是香港… Southeast Asia是新加坡

香港比較近..所以我選擇了East Asia Region

詳情可以參考以下網頁 https://azure.microsoft.com/en-us/regions/#asia-pacific

Hope you find it useful

.Net Post XML via HTTPS Notes 1 [Convert XSD to .Net Class]

Tue, 18 Aug 2009 18:18:00 +0800

最近公司有一個 project 是要用另外一間公司的 XML Interface 既 Webservice 去做 exchange data. 其實只要這間公司提供 WSDL 既 Address 給我們這個 project 便很容易完成” 很可惜這間公司不願提供 WDSL file 所以最後便要自己學怎樣在 VB.Net 入面 post XML 去 HTTP 了

便這了這篇筆記了

還記得之前用 WSDL 時當我 Add 了 Service Reference Visual Studio 便會自動產生了和這 Web service 有關的 .NET Object 和 Connection End Point 一切都十分方便”

現在所有事都要自己 Handle 　感到有點煩惱” 等一個 STEP 便是要找方法把 Developer Guide 入面的 XSD 轉做 .Net Object 或者你要自己寫一些 CLASSES 出來去做一些 function 可以 return 到 XML OUTPUT 可以 Match 到 Developer Guide 入面你需要 POST 的 XML Rule.

以下是我的做法

首先你要找到這個XSD.EXE file 在我的電腦入面是在以下的 directory C:Program FilesMicrosoft SDKsWindowsv6.0ABin

或者你可以試試 SEARCH “xsd.exe” 之後 copy 這個檔案去另一個 location 或到"xsd.exe"後便用 Command Prompt [我將這個.EXE copy 到裝有 xsd 檔案的 directory 入面 (這樣可以方便自己打小一些 path)]

之後開啓 command prompt “Start”-> “Run”-> Type “cmd” ->Press “Enter” 在 command prompt 入面進入有 “xsd.exe” 的 directory 入面之後打以下的 Command 你便可以 create 一個 class base on 這個 xsd 檔案了 MyXMLObjNameSpace 是我想這個 Class 用的 namespace. XMLToExampleCLass.xsd 是我轉的 xsd file. 我用的 language 是 VB.NET

xsd.exe –c –l:vb –n:MyXMLObjNameSpace XMLToExampleCLass.xsd

xsd.exe -c -l:c# -n:MyXMLObjNameSpace XMLToExampleCLass.xsd
xsd.exe -c[-c mean general Class] -l:[Language Name e.g. c#/vb] -n:[Namespace][xsd file name]

如果你的 XSD 檔案不是 proper define command prompt 便會出示一些 error message 說出那裡出現問題就好像下面一樣

這樣你便要看清楚你的 XSD 檔案是否 Well define 了

如果你的 xsd 檔案是沒有問題他便會出現” Writing file “C:pathXMLToExampleCLass.vb"

當你完成之後只要 COPY 這個 VB 檔案到你的 VB project 之後 imports 這個 namespace 你便可以使用這個 class 了

E.G. VB Imports MyProgram.MyXMLObjNameSpace C#

using MyProgram.MyXMLObjNameSpace;

Hope you find it useful. 如果你有更好的方法, 歡迎大家一齊來研究研究

Convert Date to Month Name in .Net

Mon, 17 Aug 2009 08:17:00 +0800

Today, my friend and I tried to find a way to convert date to a month name. E.g. 2008-08-08 to return August.

I tried to use String.Format(TODAY, “MMM”) ,String.Format(“MMM”,TODAY) “etc. To convert Date to Month Name sound quite simple, unforunately, I have spent quite a long time to find the solution.

Finally, I have find a solution online, which is to use the ToString’s method. E.g. Today.ToString({Format of the date}) to get the date format you want.

DateTime.Now.ToString(“MMMM”)

Is it quite easy, isn’t it?

Happy programming = )

Cannot open CHM file in Windows XP/Vista- Navigation to the Webpage has been cancelled.

Sun, 16 Aug 2009 08:16:00 +0800

When I try to open CHM file on Windows XP or Windows Vista, it always display a message “Navigation to the Webpage has been canceled.”.

Finally I have worked out how to resolve this problem.

Solution:

Right click on the .CHM file Click on “Properties” then choose the “General” Tab At the bottom of that tab, you will see something like

Security: "This file came from another computer and might be blocked to help protect this computer"
Click on the "Unblock "button which is beside to this message.
Click "OK"
You should be able to view that CHM.File now

開啟 CHM 說明檔問題 (XP/VISTA) - 已取消瀏覽該網頁

Sat, 15 Aug 2009 08:15:00 +0800

最近當我在Windows XP/Vista 開啟CHM 格式的檔案時出現以下的信息

"已取消瀏覽該網頁"

看不到這說明檔的內容

最後終於找到解釋方法 = )

Right Click 這個CHM 檔

選擇 "內容"

之後你會看到

在"一般" 分頁的底部會出現

"安全性: 這個檔案來自另一個電腦, 可能會封鎖以協助保護您的電腦"

只要按一下 "解除封鎖" 按鈕

然後按"確定"

你便可以正常開啟這個CHM 檔案了

Win2008 SP1 download

Thu, 13 Aug 2009 08:13:00 +0800

I just installed Windows Server 2008 in Virtual PC. Try to install All the service packs to the Server before using the “Windows update”. When I go to Microsoft Download Centre,

From the URL below: http://www.microsoft.com/downloads/details.aspx?FamilyID=a4dd31d5-f907-4406-9012-a5c3199ea2b3&displaylang=en I saw a message which say: [Service Pack 1 is a prerequisite for installing Service Pack 2. Please make sure that your system is running Service Pack 1 before you install Service Pack 2. ], that means the ISO that I download will not include SP1.

Therefore I am searching for Windows Server 2008 SP1 from the Download centre, unfortunately, I could not find any location where I can download Win2008 SP1.

Finally I have checked the version of my Windows Server 2008 by: “Start Menu” -> Right Click “Computer” -> “Properties”

Cannot believe that the installed version already contain SP1. I guess when they release Windows Server 2008, they have included SP1 in there already.

Fatal error: Call to undefined function curl_init() 問題

Wed, 12 Aug 2009 08:12:00 +0800

今天想嘗試使用 CURL 這個 MODULE 去 POST 一些 XML Data 到另一個 website, 當我跟著網上的 example 試 code 的時候”

<?
$ch = curl_init();
?>

下面的 error 便出現了
Fatal error: Call to undefined function curl_init() in D:WebServerWebSitePostXML.php on line 8

其實解決方法很簡單只要到 “Notepad” 開啟 “php.ini” 之後用 “Edit” ->”Find”” 或 CTRL + “F” 找 “curl” 你便會找到 ;extension=php_curl.dll

你只需要刪除";” 之後儲存檔案 "Restart” 你的 web server 便可

Good Luck

ASP.Net GridView RowCommand did not get trigger

Tue, 11 Aug 2009 08:11:00 +0800

I was stuck in a GridView RowCommand problem for a long time. Not sure why the RowCommand did not get trigger” Here is my situation:

I have a Grid View which is used to display a table with data, It also contain an image button which allow user to click on, to download a file.

I have done the similar feature several time, all of them works fine. Unfortunately, when the user click on the image button for this grid view, it just refresh the page, but it did not do anything. I try to check what have done wrong by comparing the code that I did before. They all looks fine.

So I have set up several break point to where the RowCommand handler is, a strange thing happened. The RowCommand Handler did not get triggered at all.

Finally, I just realised I have forgotten to put an if-statement ispostback on the Page Load event, so that whenever the RowCommand get triggered, it executed a post back, which will run the page_load event. And inside my Page_Load event, it will populate the table again. Therefore, the RowCommand never get triggered.

Solution is: To put a code on Page_Load Event to check if it is a PostBack or not. If it is not a postback then populate the table, if Not, then skip it. Here it is the Code to check if it is postback or not.

VB.Net If Not IsPostBack Then
‘Do some action, in my case populate the table
End

C# if(!IsPostBack){
//Do some action, in my case populate the table
}
Hope you find it useful! = )

MegaUpload -This service is temporarily not available from your service area

Mon, 10 Aug 2009 08:10:00 +0800

最近在香港嘗試 click 去網上面朋友分享的下載網址時 [個file hosting company 係 Megaupload 的 LINK] E.g. http://www.megaupload.com/ 便會出現以下的 message “This service is temporarily not available from your service area.”

唔知邊點解香港用唔到呢個 file hosting company 既服務

最後比我找到有些網站提供了一個叫做 Transload 既方法令到我們可以繼續 download Megaupload host 既file 我估個原理係我O地用佢既Server Download 我們想下載的file去個Website 既Server 度之後便可從這web server 下載個 file 到我們的電腦度

可能會比平時下載檔案用多幾個STEP 但是這可以解決用唔到Megaupload file hosting的下載問題 = )

以下是我找到的其中2個Website

第一個Website 好似個file size limit 係500MB http://www.yourleech.com/index.php

http://www.ableech.com/
*有一些檔案可能需要right click 去另存目標先可以正確下載.

第二個Website 好似個file size limit 係300MB

http://www.sparkyfire.co.cc/

你亦都可以到以下的URL 看看有那個WEBSITE 可以幫你做TRANSLOAD 這個動作 http://www.rapidindex.net/ 然後便可以DOWNLOAD MEGAUPLOAD 的, 但要小心有些有廣告的LINK 可能有VIRUS"

如果大家找到更多website 可以做到這個功能歡迎大家在留言度 post 個website 出來和大家分享

Hope you find it useful.

PHP Session Problem

Sun, 09 Aug 2009 23:00:00 +0800

When I try to use the Session variable in PHP $_Session[“VariableName”], it does not work”. The session never get registered.

How to check? You can use the following code to see if the Session is null or not.

<?php
isset($_SESSION["VariableName"]) //If this return false, that mean this session is null
?>
if(isset($_SESSION["VariableName"])){
echo "Session value:" . $_SESSION["VariableName"];
$_SESSION["VariableName"] = "Assigned";
}else{
echo "Session is null";
}
?>

```php if(isset($_SESSION["VariableName"])){ echo "Session value:" . $_SESSION["VariableName"]; $_SESSION["VariableName"] = "Assigned"; }else{ echo "Session is null"; } ?>

<div>
<span style="background-color:rgb(255,255,255);"><span class="Apple-style-span" style="color:#000000;">If the result is "</span><b><span class="Apple-style-span" style="color:#000000;">Session is null</span></b><span class="Apple-style-span" style="color:#000000;">", once you refresh the page again, it should display "Session value: Assigned".</span></span><span class="Apple-style-span" style="color:#000000;"></p>
<p>
If not, that mean the Session feature has not been turn on properly on you server.
</p>
<p>
<b>Solution 1:</b><br />If you are allowed to modify the php.ini file, you can open up the "php.ini" file and Search for the keyword "</span>session.auto_start<span class="Apple-style-span" style="color:#000000;">"<br />To ensure </span>session.auto_start= 1<span class="Apple-style-span" style="color:#000000;">;<br />After you edited it, you can restart the web sever and try again.</p>
<p>
<b>Solution 2:</b><br />You can use the follow code to enable the session feature:</span><br /><span style="font-family:Courier New;"><span style="color:rgb(0,0,0);"><span style="color:rgb(0,0,187);">session_start</span><span style="color:rgb(0,119,0);">();</span></span></span>
</p>
<p>
<span class="Apple-style-span" style="color:#000000;">Hope you find this useful!</span></span></span></div>

Remote Desktop in WinXP Home Edition

Sat, 01 Aug 2009 08:01:00 +0800

I was trying to use “Remote Desktop Connection” to connect to work place via VPN, because it is a lot quicker/smoother then using VNC client. Unfortunately, I cannot find the program under “Start” -> “All Program” -> “Accessories” from my WinXP Home edition laptop. Then, I was recommended to download the third party software. = (

However, I found out that we have option for it. If you don’t want to download the software. May be you can try to type “MSTSC” from “Start” ->”Run”. The remote desktop console should appear. If not, then you can try to download the software from :

http://www.microsoft.com/downloads/details.aspx?familyid=6E1EC93D-BDBD-4983-92F7-479E088570AD&displaylang=en Hope you find this useful. =)

Windows Server 2008 and Windows VIsta Service Pack 2 Download

Fri, 29 May 2009 07:31:00 +0800

Windows Server 2008 and Windows Vista Service Pack 2 is now avaliable. For more information please visit the URL below: http://www.microsoft.com/downloads/details.aspx?FamilyID=a4dd31d5-f907-4406-9012-a5c3199ea2b3&DisplayLang=en

InLink Checker in SilverLight

Sat, 04 Apr 2009 04:04:00 +0800

I have updated the Back-Link checker Beta 1 to have another feature which allow us to check which links your site/page is linking to and is searchable by crawler.

It is an useful tool to check if you have linked to any pages which you do not intend to link to/ or recommend to the other which could affect your site’s reputation. E.g. some spam sites, may leave comment/message on your site, which has pasted a link to their spam URL"etc.

To check the Page InLinks:

Simply select “PageLink” on the drop down list which just next to the “Search” button.
Whole site check box: Specifies whether to provide results for the entire site, or just the page referenced by the query.

You can ignore the Omit Link option for this feature.

Hope you find it useful!

Related post: BackLink Checker in Silverlight

BackLink Checker in Silverlight

Mon, 30 Mar 2009 03:30:00 +0800

My second Silverlight application: BackLink Checker Beta 1.

You can use this application to check if other people has link o your website. It would be quite interesting to know if people are interest on you website, they properly will place a link on their site and recommend it to others. Of course, on the other hand if people think your website is crap, they could also place a link no their site and say..[Not to visit your website …etc.].

Here it is some criteria on this BackLink checker.

You should enter full URL of your website (with HTTP/HTTPS)
If you put a URL which contain specific page. Then the BackLink checker will only search for the back link for that particular page.
It has 2 setting for you to specific the result.

Whole site check box: Specifies whether to provide results for the entire site, or just the page referenced by the query
Omit link drop down: If specified, link will not be returned if they are from pages in the same Domain/Sub-domain as the requested page.

This BackLink Checker only return the links which is indexed by Yahoo, therefore it may not reflect the actually popularity of your website. Hope this can be improve on Beta 2. = )

Hope you find it useful.

7個步驟便可以在電腦上擁有屬於自己手寫字形

Sun, 29 Mar 2009 03:29:00 +0800

今日想同大家介紹一個網頁

想信大家都有聽過[物似主人形] 亦都有人講過見到你寫的字都估到你是過怎樣既人

只需要簡單的7 個步驟便在電腦上擁有屬於自己手寫字形這個網頁可以將你手寫的字轉做可幾由電腦打出來的字只需要大概 15 分鐘便可以完成看到這裡是否好想去這個網頁去做自己的字形呢.

需要的工具有 PRINTER(打印機)和 SCANNER(掃描器) 還有一支筆 (最好是黑色的幼或中厚 MARKER [標記筆?])

有屬於自己的字形這裡就是所需的步驟了

首先到這個網頁打印模板 (Print Template), 這裡有 2 個格式給你們 Print 出來, 一個字 PDF 另一個是個 IMAGE 檔 (我會建議 print PDF 檔)
填寫剛剛 print 出來的template. (請記住跟著他的格式) 網頁上的 example 可以參考只需要填寫第一頁, 如果你想用其他的特別字你可以填寫埋第二頁岩
需要 scan 同保存剛寫好的文字 template, 請注意他們只支援幾下的檔案格式的 (.gif, .jpg, .jpeg, .png, .tif, or .tiff file)
上傳檔案和幫自己的字形命名
預覽字形
下載字形
安裝字形

使用windows 的電腦可以按"開始”->"控制台”
double click “字形”
選擇"安裝新字形…” -> 瀏覽到該檔案位置
選擇 “Your font (TrueType)”
最後按"確定" 便可

之後可以開啓文字程式選擇自己的字形看看 (E.G. Notepad) 會不會有一些親切感哈哈

以上就是所有的步驟了, 如果還是不太明白的話可以到官方網頁看

由於我沒有 scanner 所幾沒有得嘗試造自己的字形… (當我找到 scanner 時我一定會 upload 我的字形上網的) 哈哈

這個網頁的網扯是 http://www.yourfonts.com/

希望你喜歡如果你想和其他人分享你的字形歡迎你留言時留下你字形檔案的 URL

Have fun.

Trend Micro HouseCall on Vista/ Free online scan for antivirus

Mon, 23 Mar 2009 03:23:00 +0800

I have installed AVG Free as anti-virus software on my laptop. I think they are quite good. Although it is quite safe, sometime I will use other online virus checker to scan my computer to ensure my computer is secure.

I used to use Trend Micro HouseCall to do a online scan on my computer, sometime it did find some Trojan and worms, but AVG did not notice it. But as soon as I upgrade my laptop to Windows Vista, HouseCall did not work again. On the previous version of HouseCall it did say it does not support Windows Vista. When I check it again today, it said it did now.

My computer has not done any full virus scan for quite awhile, I think I should have a try now. I am not sure if it is something not quite right on my computer. I cannot get it work on my IE, it said “HouseCall is not available for your platform”…“You can not use Trend Micro HouseCall on your machine because your processor type or your operating system are not supported.” etc. (but on the front page, they did say they support vista and IE6 or above). I hope it is not something to do with my CPU which is “Centrino Duo ”.

When i try again on Firefox, it seems to work. The different is I need to download an exe file instead of running it directly on browser(Firefox).

After I downloaded the “housecall66.exe” I just double click on it to execute it.

When you started it, it will ask you to accept the terms and condition agreement.

Once you done that you need to choose a HouseCall Kernel which his either a Brower base or Java base. Then you would need to download the plug-in, it may take awhile. (I chose Browser Base)

Then you will see a “Select Scan Options” screen.

Recommended scan - only scan for malware, grayware, vulnerability and selected location. It will perform quicker

Complete scan - probably will scan for everything on you PC

Customized Scan - you can select what to scan. It has one more option than Recommended Scan which is scan open network port I think it would be quite useful to see if your computer has open a network port which could be attack by hacker. If you have selected “Open Network ports” it will pop up a message to inform you that the program will perform a port scan. (It is not a hacker attack (not this time))

It takes about 4 hours to scan my computer, which has 160GB HDD, filled in around 110GB data

My scan result

Here it is the URL for Trend Micro HouseCall online scan. http://housecall.trendmicro.com/

Hope your find it useful.

Jquery's Notes

Thu, 19 Mar 2009 03:19:00 +0800

I am learning JQuery at the moment, and going to note down the error/mistake which I made while I am experimenting it. Hope you would find it useful if you encounter the same issue, while you are using JQuery. Please correct me if my concept is

wrong or you have a better solution.

Why learn JQuery? It is a JavaScript library/API/Frameworks allow you to develop website rapidly with nice feature that can work Cross-

browser, CSS3 Compliant and Lightweight Footprint, you can found lots of plugin on-line which can save you a lot of time to

develop you own method for some common feature.

Here it is the official site for JQuery, where you can find JQuery to download download/tutorials/documentation and get the latest

information about it. jquery.com

One thing that I would like to remind myself from this notes is. All the even/action E.g. Blur, Onchange…etc should register on ready event. Of course, the most important thing is to reference the jquery.js between the HTML header tag. E.g.



 
 
 
 //Register on ready event 
 $(document).ready(function() {
 $("#txt_Text").change(function(){
 alert($("#txt_Text").val());
 });
 });

 


Jquery Notes

The example above will display an alert box when we change the focus on txt_Text input control.

Happy coding.

Crystal report XI Service Packs 5 solve the PDF font size get reduced/smaller issue

Wed, 11 Mar 2009 18:15:00 +0800

Today I just have a look at the documentation about Crystal report XI Service Packs 5, which has released at the end of Nov 2008. They have mention the PDF generation issue which I posted few days ago about PDF font size get reduced after you export it from crystal report.

If you have similar issue, the following description may be able to help you get around it.

Hope you find it useful.

ADAPT00940675
Description:
The registry key option ForceLargerFonts maintains the correct font size of reports that are exported to PDF format; however,
this option may cause data to be truncated along the right-side margin.
The problem is caused by a mismatch in the way that character widths are calculated between PDF and Microsoft Windows.
New Behavior:
This problem is resolved.
To solve the problem, the PDF export engine has been modified to use an algorithm that positions characters precisely to
prevent truncation, while still maintaining the correct font size. This algorithm is activated and controlled by two new registry
keys:
[HKEY_LOCAL_MACHINESOFTWAREBusiness Objects\Crystal ReportsExportPdf]
"UsePrecisePositioningForText"=dword:00000001
[HKEY_LOCAL_MACHINESOFTWAREBusiness Objects\Crystal ReportsExportPdf]
"TruncationAdjustment"=dword:00000002
The UsePrecisePositioningForText key enables the new functionality when it is set to 1. When this option is enabled, the
ForceLargerFonts option is automatically enabled (to maintain correct font sizes in PDF exports), and any manual settings
made to it are ignored. The TruncationAdjustment key controls a width calculation rounding function in the new algorithm and
accepts values between 0 and 10 inclusively. The default value of 2 has been tested to sufficiently eliminate most truncation
issues. If truncation still happens, users can increase the value.
Known Limitations:
When the UsePrecisePositioningForText key is enabled, exports to PDF format may take slightly longer, but by no more than
10%. Also, the exported PDF document will increase in file size over the standard output, and Crystal reports will consume
more GDI resources during the export.

WordWrap on Crystal Report?

Sat, 07 Mar 2009 03:07:00 +0800

I have received a task to convert the project handbook from Word Document into Crystal report. It does not sound difficult until I need to do some formatting and Layout.

I had a problem on trying to make a field to display in Multi-line, instead of one line. And I am not able to file a word wrap function on Crystal Report. After spending some time on the web. Finally I find out how to do it.

Solution:

Select the field(s) that you want to enable WordWrap.
Right click and select “Format Field” OR “Format Objects” (if you select more than 1 fields)
Then in the “Format Editor” Click on the “Common” tab.
You will see the screen shot similar as below.

Then “Tick” the “Can Grow” check box and click “OK"

6)After you done that you can save the Report and press “F5” to preview the report.

Hopefully you the field will be wrapped into next line.

Good luck

TSQL Get Number of Decimal Place (on a field)

Wed, 04 Mar 2009 08:08:00 +0800

Today I need to do a query to get all the record which has 3 decimal places on one of the field and process them by using different method.

I am wondering if there any default TSQL function that I can use, so that it can save my time. Unfortunately, I could not find one, so that I decided to write my own function.

Here it is the TSQL code that I used to retrieve the number of decimal place of a field.

–Example input value
DECLARE @DecimalValue FLOAT
SET @DecimalValue = 12.34567
–Declare a variable to store the result
DECLARE @NoOfDecimalPlace INT
SET @NoOfDecimalPlace = CHARINDEX(';', REVERSE(CAST(@DecimalValue AS VARCHAR(30)))) -1
–Return Number of decimal Place
SELECT @NoOfDecimalPlace

Here it is my User Define Function for get number of decimal place of a number field.

You can execute it by using the following SQL code

``` SELECT dbo. Get_NoOfDecimalPlace(0.123)

CREATE FUNCTION [dbo].[Get_NoOfDecimalPlace] (

@ValueToProcess FLOAT=0 ) RETURNS INT AS BEGIN — Declare the return variable here

DECLARE @NoOfDecimalPlace INT SET @NoOfDecimalPlace = CHARINDEX(‘.’, REVERSE(CAST(@ValueToProcess AS VARCHAR(30)))) -1

RETURN @NoOfDecimalPlace END

 Hope you found it useful.

Deselect an Item on SilverLight

Wed, 25 Feb 2009 16:32:00 +0800

Sometime you may find it useful to de-select an Item on ComboBox, when you try to force a user to pick one from the list.

Here it is the code sample to deselect a selected item on ComboBox in Silverlight. [Just need to set the selected Index to -1]

ComboBox1.SelectedIndex=-1

Hope you find it useful.

SAP Business One 2007 System Requirement

Tue, 24 Feb 2009 21:48:00 +0800

I have been searching for SAP Business One 2007 System Requirement for quite a long time. I am not sure why I cannot find it.

Unfortunately, the company I work, just upgrade their B12005 to B12007 and apparently B12007 only support MSSQL Server 2005 (If you are using MSSQL) and It will work on SQL 2000, but if you encounter any problem, SAP guy do not have to answer you question, as the system requirement did not say they support SQL 2000

If you are looking for System Requirement for SAP Business One 2007.

Here it is the link. Hope this can save you time. B12007, SAP System Requirement. https://websmp105.sap-ag.de/~sapidb/011000358700000310652008E.pdf

B12007 System Requirement, SAP System Requirement, B12007, B12005, SQL Server 2005

CodeIgniter does not work — CodeIgniter 不能顯示 $name入面的內容

Tue, 12 Aug 2008 01:00:07 +0800

今日在學習CodeIgniter 時嘗試隨著 CodeIgniter的教學建立一些 Sample Website 但不知道為什麼用 <?=$name?>

不能顯然 $name 的內容, 最後發現原來是一些 Config 的問題

解決方法: 打開你的 CodeIgniter 檔案夾到systemapplicationconfig 開啟: config.php 之後找 $config[‘rewrite_short_tags’] 如果設定為FALSE 的話就會用不到這個功能的只要把設定改到好像下面一樣便可 $config[‘rewrite_short_tags’] = TRUE;

Hope you find it useful

PHP Framework CodeIgniter- 一個挺好用的 PHP Framework

Sun, 10 Aug 2008 00:51:21 +0800

最近開始學習 CodeIgniter
CodeIgniter 是一個挺好用的 PHP Framework
可以令你開發PHP 網頁的速度更快
很多時候在開發PHP 網頁出現的問題大部份用這個Framework 都可以解決
有時間可以嘗試學習..使用這個Framework

大家可以到以下網址Download 和使用 CodeIgniter Framework
http://codeigniter.com/
Have Fun

How to run reactjs in different port

Mon, 01 Jan 0001 00:00:00 +0000

最近用了NodeJs Express 來做 Web App 的 Backend 用左 port 3000
而create-react-app 既 default port 又係 3000
怎樣可以改變create-react-app 既 port 呢

解決方法: 十分簡單… 我們只需要在 package.json 上既 scripts section
start 上加上 set PORT=[PORT_YOU_WANTED] 便可
e.g.

 "scripts": {
"start": "set PORT=9000 && react-scripts start",
"build": "react-scripts build",
"test": "react-scripts test",
"eject": "react-scripts eject",
"lint": "eslint . --ext .js --ext .jsx --ignore-path .gitignore --cache"
},

Hope you find it useful https://stackoverflow.com/questions/750172/how-to-change-the-author-and-committer-name-and-e-mail-of-multiple-commits-in-gi

Blog posts | Share ChiWai Blog

How to install wifite on Raspbian - 如何在 Raspbian / ubuntu 上安裝 wifite

RaspberryPi unzip file via 7Zip

upload copy file via ssh

RaspberryPi how to unzip unrar

'python' no such file or directory

How to resume SSH session - Ubuntu / RaspberryPi

add-apt-repository: command not found

git rewrite commit author

Ubuntu remote desktop from windows 10

SQL Server Management Studio (SSMS) shortcut to view Table Defination (sp_help)

Create-React-App test without watch mode

ReactJs set base path -

Where Event Log files store on Windows - Event Log 檔案在那裡

ASP.Net MVC client-side validation

How to untrack committed file - 如果在git 上 untrack committed file

.gitignore include a file from excluded folder

ReferenceError: regeneratorRuntime is not defined jest nodejs

How to check battery health on Windows - 如果在Windows 上檢查電池健康度.

Manifest: found icon with no valid size.

Upgrade ReactJS - module build failed - Cannot find module 'js-levenshtein'

redux - uncaught TypeError: Cannot read property 'apply' of undefined(…)

FFmpeg - 十分好用可以轉換Audio / video既 program

FFmpeg convert resize video - 使用FFmpeg 來轉換視訊格式

Git change capitalization of filename - Git 更改檔案名大小字

Use Google Translate with Google Sheet - 在Google Sheet 上使用Google Translate

git Create branch via Command

TSQL Variable Scope fun finding

Git Your branch have diverged and have 1 and 1 different commits each, respectively

Windows reset subsystem - Ubuntu

Ubuntu install WPScan

JS format JSON

Useful Heroku command

XSD restriction for either specific string or number (mixture type)

Visual Studio Useful Shortcut

Choco check if package already installed / outated

Firebase ReactJs routing issue - Page not found

How to get distinct values from an array of objects in JavaScript

How to set Environment Variable on NodeJS

Git undo local commit

failed to extract shortcode: template for shortcode "alert" not found

ESLint couldnt find the plugin (when install dependencies using yarn)

Clear node-modules

Git Error Unlink of File failed. Should I try again?

Update WordPress Inside Docker Container Required FTP Access

VSCode config trim trailing space when saving file

Linux updated folder and subfolder's ownership

C# Distinct List of Object

EF Core with MySQL Specified key was too long; max key length is 3072 bytes

Git Check which branch contain specific commit

Visual Studio CodeLens show no Reference

Git Include Ignored files

Note: Nginx Docker sample

Code-Playground

WPScan Docker Sample - WPScan Docker 示範

Screen Recording via PowerPoint (Free Feature) - 使用 PowerPoint進行 屏幕錄製

Free Software for Student - 免費軟體 (學生篇)

Useful SQL command to reduce the size of the database

Different Git User credential Con on same machine - 在同一個電腦上使用不同的Git 使用者

Git refusing to merge unrelated histories

VS Code disable minimap - 如何在Visual Studio Code 上 Disable Minimap 這個 extension

Csharp - Remove last comma - C# 如何移除最後一個符號 (分號)?

How to use && (bash) in powershell to run multiple command

ASP.Net Core Enable Development Error

LetsEncrypt Renew - Lets Encrypt SSL 更新

OnePlus 5 Windows Driver Download

OnePlus 5 Release - Early Access - OnePlus5 提早購買Code

ASP.net Core SPA Single Page Application Template Generator with angular, aurelia, knockout, react

Git note - How to checkout specific commit - Git 如何checkout 之前的Commit / Changeset

dotnet watch does not refresh content for AspNetCore.SpaTemplates React / Angular

Enable dotnet watch - on asp.net core

ASP.Net Core App can NOW be deploy to Azure - (Azure web app)

RaspberryPi install NodeJs 6.x / 7.x - 如何在RaspberryPi 安裝 NodeJs

Chocolatey Update All Package -Chocolatey更新所有Package

Windows Azure Region Location - Microsoft Azure 終於開始使用Windows/ Azure Microsoft Azure 了

.Net Post XML via HTTPS Notes 1 [Convert XSD to .Net Class]

Convert Date to Month Name in .Net

Cannot open CHM file in Windows XP/Vista- Navigation to the Webpage has been cancelled.

開啟 CHM 說明檔 問題 (XP/VISTA) - 已取消瀏覽該網頁

Win2008 SP1 download

Screen Recording via PowerPoint (Free Feature) - 使用 PowerPoint進行屏幕錄製

開啟 CHM 說明檔問題 (XP/VISTA) - 已取消瀏覽該網頁

CodeIgniter does not work — CodeIgniter 不能顯示 $name入面的內容