熱血剪貼部

Google OAuth Client 設定：Youtube Data API

By 剪刀 August 7 Web No Comments

(中文)

Overview

當我們要使用 Google 上的某項 API 服務時
都需要先到 Developer Console 啟用這項服務
建立憑證並下載 OAuth Client 的 Json 檔
通過 OAuth 驗證後才可以正常使用 API

本篇以 Youtube Data API 為例，主要有以下步驟：

新增專案

啟用 API 及服務

建立 API 金鑰

設定 OAuth 同意畫面

根據平台建立 OAuth Client ID

[Mac] Sequel Pro & MySQL 連接錯誤問題

By 剪刀 June 20 Mac No Comments

(中文)

1. 使用預設使用者 Root 、空密碼連結時的錯誤

解法：重新設定密碼為 mysql_native_password 格式

2. 使用最新的 Sequel Pro 1.1.2 搭配ＭySQL 8 開啟資料庫會直接跳出以下錯誤並 Crash

解法：下載 test build 版的 Sequel Pro

熱血人次： 97

[Mac] Download Streaming Media from Azure Media Service

By 剪刀 May 15 Mac, Web No Comments

(中文)

2. Find your azure media link

Open browser developer window and refresh your page.
(F12 for Chrome & Sidekick users shortcut)
Search “manifest” and copy the request url.

3. Download by ffmpeg

ffmpeg -protocol_whitelist file,http,https,tcp,tls,crypto -i your_url} -c copy {output.mp4}

熱血人次： 128

[Unity] Manual set Android NDK path when UnityHub Add Modules failed

By 剪刀 February 28 Unity No Comments

(中文)

1. Hack the NDK version number

Open file source.properties with a txt file
Modify Pkg.Revision to your NDK target version number
Pkg.Revision = 19.0.5232133

2. Fix NDK Signing

Open terminal, go to NDK root and execute the scripts to reset extended attribute and fix the signing.

熱血人次： 562

Migrate Unity 2D Game to Cocos Creator

By 剪刀 July 7 Unity No Comments

(中文)

Overview

本文主要分享從 Unity 2D 小遊戲轉移到 Cocos Creator 上的一些心得。
1. Why？
2. 會遇到什麼問題？
3. 轉移要花多少時間？
4. C# => TypeScript
5. Unity => Cocos
6. 小結

熱血人次： 1083

[Mac] EaseUS MobiMover Apple裝置互傳 + Youtube影片下載

By 剪刀 June 15 Mac, Digital No Comments

(中文) 如果你想要在不同 Apple 裝置間互傳或是資料轉移
可以使用官方的 iTunes 搭配 iCloud
但是通常只能整台轉移，或是不好一覽到底哪些該傳
Ease MobiMover 這款軟體可以讓在不同裝置傳輸之前
輕鬆勾選想要的項目進行傳輸，還有熱門影片平台下載功能！

Overview

下載 EaseUS MobiMover

手機傳送到 Mac

Mac 傳送到手機

內容管理

影片下載

熱血人次： 754

[Unity] Microphone or Camera not working on Mac UnityHub?

By 剪刀 April 5 Unity No Comments

(中文)

Solution 1

Use Unity.app directly instead of UnityHub.

Solution 2

Insert access database by SQLite.

熱血人次： 954

1. Install Jetbrains Rider
2. Unity External Tools
3. Unity File Templates
4. Namespace
5. Find Usages
6. Code Vision
7. Typo Detection
8. Error Detection
9. Unity Serialized Field Naming
10. Terminal
11. Version Control
12. Code Style
13. Reformat Code on Save (Macros)
14. Renaming MonoBehaviour

熱血人次： 1997

[App] Line Chef – Gameplay & Playthrough Videos

By 剪刀 August 25 App, Games No Comments

Line Chef – Gameplay & Playthrough Videos

熱血人次： 2218

(中文) [Unity] Performance Test – String Concat

By 剪刀 July 8 C#, Unity No Comments

(中文) Recommended to use string.Concat() or directly use + operator for better performance.

Test times: 10,000,000
1. PlusOperator: 6825
2. Interpolation: 10037
3. StringFormat: 9940
4. StringConcat: 6822
5. StringJoin: 8255
6. StringBuilder: 7157

熱血人次： 670

« Previous

collapsCat options: Array ( [title] => Categories [showPostCount] => 1 [inExclude] => exclude [inExcludeCats] => [showPosts] => 0 [showPages] => 0 [linkToCat] => 1 [olderThan] => 0 [excludeAll] => 0 [catSortOrder] => ASC [catSort] => catOrder [postSortOrder] => ASC [postSort] => postOrder [expand] => 0 [defaultExpand] => [debug] => 1 [postTitleLength] => 0 [catfeed] => none [taxonomy] => category [post_type] => post [postDateAppend] => after [postDateFormat] => m/d [showPostDate] => 1 [useCookies] => 1 [postsBeforeCats] => 1 [expandCatPost] => 1 [showEmptyCat] => 1 [showTopLevel] => 1 [useAjax] => 0 [customExpand] => [customCollapse] => [style] => kubrick [accordion] => 1 [title_link] => [addMisc] => 1 [addMiscTitle] => [number] => 2 [includeCatArray] => Array ( ) [expandSym] => ► [collapseSym] => ▼ ) postsToExclude: Array ( ) CATEGORY QUERY RESULTS Array ( [0] => WP_Term Object ( [term_id] => 81 [name] => Mac [slug] => mac [term_group] => 0 [term_taxonomy_id] => 48 [taxonomy] => category [description] => [parent] => 47 [count] => 14 [filter] => raw [term_order] => 0 ) [1] => WP_Term Object ( [term_id] => 88 [name] => Android [slug] => android [term_group] => 0 [term_taxonomy_id] => 69 [taxonomy] => category [description] => [parent] => 73 [count] => 1 [filter] => raw [term_order] => 0 ) [2] => WP_Term Object ( [term_id] => 90 [name] => Facebook [slug] => facebook [term_group] => 0 [term_taxonomy_id] => 73 [taxonomy] => category [description] => [parent] => 47 [count] => 2 [filter] => raw [term_order] => 0 ) [3] => WP_Term Object ( [term_id] => 79 [name] => Ruby on Rails [slug] => ruby-on-rails [term_group] => 0 [term_taxonomy_id] => 98 [taxonomy] => category [description] => [parent] => 6 [count] => 5 [filter] => raw [term_order] => 0 ) [4] => WP_Term Object ( [term_id] => 80 [name] => Sublime [slug] => sublime [term_group] => 0 [term_taxonomy_id] => 100 [taxonomy] => category [description] => [parent] => 6 [count] => 0 [filter] => raw [term_order] => 0 ) [5] => WP_Term Object ( [term_id] => 104 [name] => Shell [slug] => shell [term_group] => 0 [term_taxonomy_id] => 104 [taxonomy] => category [description] => [parent] => 6 [count] => 1 [filter] => raw [term_order] => 0 ) [6] => WP_Term Object ( [term_id] => 107 [name] => Python [slug] => python [term_group] => 0 [term_taxonomy_id] => 107 [taxonomy] => category [description] => [parent] => 6 [count] => 1 [filter] => raw [term_order] => 0 ) [7] => WP_Term Object ( [term_id] => 5 [name] => Traveling [slug] => traveling [term_group] => 0 [term_taxonomy_id] => 5 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 1 ) [8] => WP_Term Object ( [term_id] => 16 [name] => ActionScript 3.0 [slug] => as3 [term_group] => 0 [term_taxonomy_id] => 16 [taxonomy] => category [description] => [parent] => 6 [count] => 2 [filter] => raw [term_order] => 1 ) [9] => WP_Term Object ( [term_id] => 34 [name] => App [slug] => app [term_group] => 0 [term_taxonomy_id] => 34 [taxonomy] => category [description] => [parent] => 36 [count] => 30 [filter] => raw [term_order] => 1 ) [10] => WP_Term Object ( [term_id] => 30 [name] => France [slug] => france [term_group] => 0 [term_taxonomy_id] => 30 [taxonomy] => category [description] => [parent] => 5 [count] => 35 [filter] => raw [term_order] => 1 ) [11] => WP_Term Object ( [term_id] => 51 [name] => Blog [slug] => blog [term_group] => 0 [term_taxonomy_id] => 52 [taxonomy] => category [description] => [parent] => 50 [count] => 1 [filter] => raw [term_order] => 1 ) [12] => WP_Term Object ( [term_id] => 57 [name] => Chrome [slug] => chrome [term_group] => 0 [term_taxonomy_id] => 63 [taxonomy] => category [description] => [parent] => 47 [count] => 2 [filter] => raw [term_order] => 1 ) [13] => WP_Term Object ( [term_id] => 75 [name] => 縮時 [slug] => %e7%b8%ae%e6%99%82 [term_group] => 0 [term_taxonomy_id] => 93 [taxonomy] => category [description] => [parent] => 41 [count] => 1 [filter] => raw [term_order] => 1 ) [14] => WP_Term Object ( [term_id] => 76 [name] => luodung [slug] => lotung [term_group] => 0 [term_taxonomy_id] => 95 [taxonomy] => category [description] => [parent] => 3 [count] => 5 [filter] => raw [term_order] => 1 ) [15] => WP_Term Object ( [term_id] => 3 [name] => Food [slug] => food [term_group] => 0 [term_taxonomy_id] => 3 [taxonomy] => category [description] => [parent] => 0 [count] => 1 [filter] => raw [term_order] => 2 ) [16] => WP_Term Object ( [term_id] => 23 [name] => Ilan [slug] => taiwan-ilan [term_group] => 0 [term_taxonomy_id] => 23 [taxonomy] => category [description] => [parent] => 3 [count] => 6 [filter] => raw [term_order] => 2 ) [17] => WP_Term Object ( [term_id] => 25 [name] => Book [slug] => book [term_group] => 0 [term_taxonomy_id] => 25 [taxonomy] => category [description] => [parent] => 50 [count] => 0 [filter] => raw [term_order] => 2 ) [18] => WP_Term Object ( [term_id] => 38 [name] => HongKong [slug] => hongkong [term_group] => 0 [term_taxonomy_id] => 38 [taxonomy] => category [description] => [parent] => 5 [count] => 10 [filter] => raw [term_order] => 2 ) [19] => WP_Term Object ( [term_id] => 42 [name] => Post Production [slug] => post-production [term_group] => 0 [term_taxonomy_id] => 42 [taxonomy] => category [description] => [parent] => 41 [count] => 2 [filter] => raw [term_order] => 2 ) [20] => WP_Term Object ( [term_id] => 68 [name] => LeetCode [slug] => leetcode [term_group] => 0 [term_taxonomy_id] => 81 [taxonomy] => category [description] => [parent] => 6 [count] => 0 [filter] => raw [term_order] => 2 ) [21] => WP_Term Object ( [term_id] => 70 [name] => Resource [slug] => resource [term_group] => 0 [term_taxonomy_id] => 85 [taxonomy] => category [description] => [parent] => 73 [count] => 1 [filter] => raw [term_order] => 2 ) [22] => WP_Term Object ( [term_id] => 20 [name] => Ilan [slug] => ilan [term_group] => 0 [term_taxonomy_id] => 20 [taxonomy] => category [description] => [parent] => 5 [count] => 6 [filter] => raw [term_order] => 3 ) [23] => WP_Term Object ( [term_id] => 15 [name] => Hotblood [slug] => hotblood [term_group] => 0 [term_taxonomy_id] => 15 [taxonomy] => category [description] => [parent] => 50 [count] => 1 [filter] => raw [term_order] => 3 ) [24] => WP_Term Object ( [term_id] => 36 [name] => Games [slug] => games [term_group] => 0 [term_taxonomy_id] => 36 [taxonomy] => category [description] => [parent] => 0 [count] => 12 [filter] => raw [term_order] => 3 ) [25] => WP_Term Object ( [term_id] => 54 [name] => Google Play [slug] => google-play [term_group] => 0 [term_taxonomy_id] => 58 [taxonomy] => category [description] => [parent] => 73 [count] => 1 [filter] => raw [term_order] => 3 ) [26] => WP_Term Object ( [term_id] => 66 [name] => C# [slug] => c [term_group] => 0 [term_taxonomy_id] => 78 [taxonomy] => category [description] => [parent] => 6 [count] => 2 [filter] => raw [term_order] => 3 ) [27] => WP_Term Object ( [term_id] => 77 [name] => Suao [slug] => suao [term_group] => 0 [term_taxonomy_id] => 96 [taxonomy] => category [description] => [parent] => 3 [count] => 0 [filter] => raw [term_order] => 3 ) [28] => WP_Term Object ( [term_id] => 19 [name] => Flash [slug] => flash [term_group] => 0 [term_taxonomy_id] => 19 [taxonomy] => category [description] => [parent] => 6 [count] => 5 [filter] => raw [term_order] => 4 ) [29] => WP_Term Object ( [term_id] => 39 [name] => Taichung [slug] => taichung [term_group] => 0 [term_taxonomy_id] => 39 [taxonomy] => category [description] => [parent] => 5 [count] => 6 [filter] => raw [term_order] => 4 ) [30] => WP_Term Object ( [term_id] => 59 [name] => Wedding [slug] => %e5%a9%9a%e4%ba%8b [term_group] => 0 [term_taxonomy_id] => 66 [taxonomy] => category [description] => [parent] => 50 [count] => 5 [filter] => raw [term_order] => 4 ) [31] => WP_Term Object ( [term_id] => 64 [name] => Web [slug] => web [term_group] => 0 [term_taxonomy_id] => 74 [taxonomy] => category [description] => [parent] => 47 [count] => 7 [filter] => raw [term_order] => 4 ) [32] => WP_Term Object ( [term_id] => 71 [name] => iOS [slug] => ios [term_group] => 0 [term_taxonomy_id] => 86 [taxonomy] => category [description] => [parent] => 73 [count] => 2 [filter] => raw [term_order] => 4 ) [33] => WP_Term Object ( [term_id] => 73 [name] => App Develop [slug] => app-develop [term_group] => 0 [term_taxonomy_id] => 90 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 4 ) [34] => WP_Term Object ( [term_id] => 74 [name] => Taoyuan [slug] => taoyuan [term_group] => 0 [term_taxonomy_id] => 92 [taxonomy] => category [description] => [parent] => 3 [count] => 1 [filter] => raw [term_order] => 4 ) [35] => WP_Term Object ( [term_id] => 6 [name] => Programming [slug] => programming [term_group] => 0 [term_taxonomy_id] => 6 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 5 ) [36] => WP_Term Object ( [term_id] => 7 [name] => Flash Develop [slug] => flash-develop [term_group] => 0 [term_taxonomy_id] => 7 [taxonomy] => category [description] => [parent] => 6 [count] => 3 [filter] => raw [term_order] => 5 ) [37] => WP_Term Object ( [term_id] => 24 [name] => Taiwan . Jongli [slug] => jongli [term_group] => 0 [term_taxonomy_id] => 24 [taxonomy] => category [description] => [parent] => 3 [count] => 2 [filter] => raw [term_order] => 5 ) [38] => WP_Term Object ( [term_id] => 46 [name] => Miaoli [slug] => miaoli [term_group] => 0 [term_taxonomy_id] => 46 [taxonomy] => category [description] => [parent] => 5 [count] => 2 [filter] => raw [term_order] => 5 ) [39] => WP_Term Object ( [term_id] => 48 [name] => Windows [slug] => windows [term_group] => 0 [term_taxonomy_id] => 49 [taxonomy] => category [description] => [parent] => 47 [count] => 2 [filter] => raw [term_order] => 5 ) [40] => WP_Term Object ( [term_id] => 67 [name] => iTunes Connect [slug] => itunes-connect [term_group] => 0 [term_taxonomy_id] => 88 [taxonomy] => category [description] => [parent] => 73 [count] => 6 [filter] => raw [term_order] => 5 ) [41] => WP_Term Object ( [term_id] => 47 [name] => Digital [slug] => digital [term_group] => 0 [term_taxonomy_id] => 47 [taxonomy] => category [description] => [parent] => 0 [count] => 1 [filter] => raw [term_order] => 6 ) [42] => WP_Term Object ( [term_id] => 52 [name] => Unity [slug] => unity [term_group] => 0 [term_taxonomy_id] => 54 [taxonomy] => category [description] => [parent] => 73 [count] => 55 [filter] => raw [term_order] => 6 ) [43] => WP_Term Object ( [term_id] => 69 [name] => Git [slug] => git [term_group] => 0 [term_taxonomy_id] => 84 [taxonomy] => category [description] => [parent] => 6 [count] => 5 [filter] => raw [term_order] => 6 ) [44] => WP_Term Object ( [term_id] => 78 [name] => Taichung [slug] => taichung-food [term_group] => 0 [term_taxonomy_id] => 97 [taxonomy] => category [description] => [parent] => 3 [count] => 1 [filter] => raw [term_order] => 6 ) [45] => WP_Term Object ( [term_id] => 41 [name] => Photograph [slug] => photograph [term_group] => 0 [term_taxonomy_id] => 41 [taxonomy] => category [description] => [parent] => 0 [count] => 11 [filter] => raw [term_order] => 7 ) [46] => WP_Term Object ( [term_id] => 53 [name] => Visual Studio [slug] => visual-studio [term_group] => 0 [term_taxonomy_id] => 56 [taxonomy] => category [description] => [parent] => 6 [count] => 1 [filter] => raw [term_order] => 7 ) [47] => WP_Term Object ( [term_id] => 65 [name] => XCode [slug] => xcode [term_group] => 0 [term_taxonomy_id] => 76 [taxonomy] => category [description] => [parent] => 73 [count] => 6 [filter] => raw [term_order] => 7 ) [48] => WP_Term Object ( [term_id] => 49 [name] => Wordpress [slug] => wordpress [term_group] => 0 [term_taxonomy_id] => 50 [taxonomy] => category [description] => [parent] => 6 [count] => 4 [filter] => raw [term_order] => 8 ) [49] => WP_Term Object ( [term_id] => 50 [name] => Life [slug] => life [term_group] => 0 [term_taxonomy_id] => 51 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 8 ) [50] => WP_Term Object ( [term_id] => 1 [name] => 未分類 [slug] => %e6%9c%aa%e5%88%86%e9%a1%9e [term_group] => 0 [term_taxonomy_id] => 1 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw [term_order] => 9 ) ) POST QUERY: POST QUERY RESULTS
►Traveling (59)
- France (35)
- HongKong (10)
- Ilan (6)
- Taichung (6)
- Miaoli (2)
►Food (16)
- luodung (5)
- Ilan (6)
- Suao (0)
- Taoyuan (1)
- Taiwan . Jongli (2)
- Taichung (1)
►Games (42)
- App (30)
►App Develop (72)
- Android (1)
- Resource (1)
- Google Play (1)
- iOS (2)
- iTunes Connect (6)
- Unity (55)
- XCode (6)
►Programming (29)
- Ruby on Rails (5)
- Sublime (0)
- Shell (1)
- Python (1)
- ActionScript 3.0 (2)
- LeetCode (0)
- C# (2)
- Flash (5)
- Flash Develop (3)
- Git (5)
- Visual Studio (1)
- Wordpress (4)
►Digital (28)
- Mac (14)
- Facebook (2)
- Chrome (2)
- Web (7)
- Windows (2)
►Photograph (14)
- 縮時 (1)
- Post Production (2)
►Life (7)
- Blog (1)
- Book (0)
- Hotblood (1)
- Wedding (5)
►未分類 (0)

熱血剪貼部

Google OAuth Client 設定：Youtube Data API

Overview

登入 Google Developers Console

[Mac] Sequel Pro & MySQL 連接錯誤問題

1. 使用預設使用者 Root 、空密碼連結時的錯誤

2. 使用最新的 Sequel Pro 1.1.2 搭配ＭySQL 8 開啟資料庫會直接跳出以下錯誤並 Crash

[Mac] Download Streaming Media from Azure Media Service

1. Install ffmpeg

2. Find your azure media link

3. Download by ffmpeg

[Unity] Manual set Android NDK path when UnityHub Add Modules failed

1. Hack the NDK version number

2. Fix NDK Signing

Migrate Unity 2D Game to Cocos Creator

Overview

[Mac] EaseUS MobiMover Apple裝置互傳 + Youtube影片下載

Overview

[Unity] Microphone or Camera not working on Mac UnityHub?

Solution 1

Solution 2

[Unity] Jetbrains Rider 安裝與使用

Overview

[App] Line Chef – Gameplay & Playthrough Videos

(中文) [Unity] Performance Test – String Concat

Overview

登入 Google Developers Console

1. 使用預設使用者 Root 、空密碼連結時的錯誤

2. 使用最新的 Sequel Pro 1.1.2 搭配 ＭySQL 8 開啟資料庫會直接跳出以下錯誤並 Crash

2. Find your azure media link

3. Download by ffmpeg

1. Hack the NDK version number

2. Fix NDK Signing

Overview

Overview

Solution 1

Solution 2

Overview

2. 使用最新的 Sequel Pro 1.1.2 搭配ＭySQL 8 開啟資料庫會直接跳出以下錯誤並 Crash