2012年11月30日 星期五
2012年11月26日 星期一
2012年11月25日 星期日
MySql 安裝
所需檔案
安裝步驟
(0) 如果需要才安裝 .Net Framework 4
(1) 安裝MySql
(2) 進入MySql Console
(3) 建立所需Table
CREATE DATABASE IF NOT EXISTS `bingodb` DEFAULT CHARACTER SET utf8;
USE `bingodb`;
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
`UID` varchar(300) DEFAULT NULL,
`NAME` varchar(300) DEFAULT NULL,
`SCORE` int(11) DEFAULT NULL,
`LINE` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(4) 設定MySql外網存取權限
GRANT ALL ON *.* TO 'USER'@'%' IDENTIFIED BY 'PASSWORD';
(5) 設定防火牆
(6) 測試
SmartFoxServer 2X 安裝
所需檔案
安裝步驟
(1) SmartFoxServer 2X 安裝
(2) SmartFoxServer 2X 更新
(3) SmartFoxServer 2X 設定
(4) 防火牆設定
(5) 外網Router設定
(6) 測試
2012年11月19日 星期一
Adobe AIR for Game
開發環境安裝
- Flash Builder
- Flash Professional
- Latest AIR SDK
- Latest Flex SDK
- Merge Flex and AIR SDKs
- 設定步驟
Toolkit
實機測試所需檔案(尚未完成)
- iOS (Certificate & Provisioning file)
- Android (usb_drivers)
Game Development Resources
- Adobe Gaming
- Adobe Developer Connection
- Adobe AIR Developer Center
- ActionScript Technology Center
- Native extensions for Adobe AIR
- TexturePacker
- SFS AS3 Client API
- SFS AS3 Examples
- SFS AS3 Document
- SFS Adobe AIR Example(Space Race)
- SFS Adobe AIR Example(cannon-combat)
- SFS2X_SpaceRace_Walkthrough
- Flash Relatime
- haXe官網
- haXe簡介
- How to improve your mobile AS3/AIR performance
- Game Open Source Examples
- isohill
ActionScript code snippets
- how to create a singleton in actionscript
- Minimum and Maximum Values for uint and int
- Removes specific item from Array
- Check to see if a class has a method
Flash Game Engine support Adobe AIR
- Starling Framework
- Nape Physics Engine
- Away 3D
- Alternativa platform
- Flixel
- FlashPunk
- PushButton
- TweenMax
Flash Audio Resource
- Flash-Supported MP3 Settings
- MP3轉檔工具 RazorLame
- RazorLame參數說明
- Flash Audio Control Sample
- Silencing audio on iOS with Ambient Audio Playback Mode
效能調校
- How to improve your mobile AS3/AIR performance
- Starling Framework performance optimization
- USB Debugging on iOS
Starling Q & A
- 一起來玩鳥 Starling Framework 動畫簡介
- Touch Event
- loop Tween
- Extensions
- Multi-Resolution Development
- Collision Detection
- AS3 中使用Dictionary必須知道的 -- for 與 for each 的差別
- Scrolling Solution
- Scrolling Solution (Starling Framework)
- Scorlling Solution (Seem like best solution)
Q & A
- Fix Code Navigation Error
- Flash Builder Code templates
- XP輸入法Ctrl+Space無法使用
- 解決 Eclipse 快捷鍵 Ctrl+Space 與輸入法切換衝突問題
- Using the logging API
- Configure project dependance
- the application descriptor file should be equal or higher (Solution key word: application xmlns )
- Error #3723: Invalid Context3D bounds
- ActionScript Static Constructor / Initializer
- TypeError: Error #1007: Instantiation attempted on a non-constructor.
- Apple iOS development process using Flash Builder
- Converting a developer certificate into a P12 file(Window)
- Converting a developer certificate into a P12 file(MAC)
- iOS Provisioning Portal
- Deploy an application on a mobile device
- Connect Google Android devices
- Debugging AIR apps on iDevices with Flash Builder 4 or Burrito
- Test and debug a mobile application on a iDevice
- DeMonsterDebugger Import的問題
- Actionscript Using conditional compilation
- Flash Builder 4 – Java Heap Space Issues
- ActionScript Function call vs apply
- as3:Function以及call,apply
- Removing Elements from an Array
- AS3 Type checking
- Typesafe Enum Pattern in AS3
- How can I get list of properties in an object in Actionscript
其他參考資料
- Flash Builder使用手冊
- 電子書
- Starling API Reference
- AIR application descriptor elements
- Setting AIR application properties
- ActionScriptR 3.0 API Reference
- 10 common mistakes when building Adobe AIR applications
- What's new in Adobe AIR 3
Actionscript Third Party
Action Script Resource Management
Flash Builder shortcuts
File
- Find Next : Ctrl + K
- Find Previous : Ctrl + Shift + K
- Word Completion : Alt + /
- Quick Fix : Ctrl + 1
Source
- Toggle Comment : Ctrl + /
- Correct Indentation : Ctrl + I
- Rename : Ctrl + Alt + R
Navigate
- Open Declaration : F3
- Open Call Hierachy : Ctrl + Alt + H
- Open Type : Ctrl + Shift + T
- Open Resource : Ctrl + Shift + R
- Last Edit Location : Ctrl + Q
- Go to Line : Ctrl + L
- Back : Alt + Left
- Forward : Alt + Right
Run
- Resume : F8
- Terminate : Ctrl + F2
- Step Info : F5
- Step Over : F6
- Run : Ctrl + F11
- Debug : F11
- Toggle Breakpoint : Ctrl + Shift + B
…
2012年11月18日 星期日
TODO
[尚未解決的問題]
- MySql connector for iOS 在 select時, 中文會出錯的BUG (key word: my_bool cli_read_prepare_result(MYSQL *mysql, MYSQL_STMT *stmt)
[2012.11.16]
- 幫cole安裝xcode最新版
- 幫cole安裝Parellel Desktop
- 備份以及安裝Tom給的光碟 for Adobe AIR
- Start Adobe AIR for Android Project
2012年11月17日 星期六
Analysis of Bingo porting from iOS to Adobe AIR
Bingo Features
- Game Effect : cocos2d
- Real-time Multiplayer Gaming : SmartFoxServer 2X
- Score Ranking : MySql
Reference
cocos2d for iOS
Bingo on Adobe AIR issue
Game Effect
air for ios game developed in flash using actionscript 3.0
Adobe AIR for the iPhone and Android OS using Flash Pro CS5
convert into Adobe AIR/Android app
Real-time Multiplayer Gaming : SmartFoxServer 2X has client API for Flash
MySql
asSQL is an Actionscript 3 Mysql Driver
Using Flex, PHP, and JSON to Modify a MySQL Database
Flex & PHP Tutorial - Transmitting data using JSON
Flex, PHP, JSON, MySQL - Advanced Updating
Conclusion: 移植到Adobe AIR應該沒問題
Adobe AIR
cons & pros
Adobe AIR: 10 reasons to love it, 10 reasons to hate it.
The Pros and Cons of Adobe AIR
Adobe Flash – Pros And Cons