Skip to content

Instantly share code, notes, and snippets.

View qndev's full-sized avatar
:octocat:
I may be slow to respond.

Nguyễn Đình Quang qndev

:octocat:
I may be slow to respond.
View GitHub Profile
@qndev
qndev / gist:680f67e1c90f215e774b440aae5b0e86
Created June 9, 2019 07:57 — forked from rxaviers/gist:7360908
Complete list of github markdown emoji markup

People

:bowtie: :bowtie: 😄 :smile: 😆 :laughing:
😊 :blush: 😃 :smiley: ☺️ :relaxed:
😏 :smirk: 😍 :heart_eyes: 😘 :kissing_heart:
😚 :kissing_closed_eyes: 😳 :flushed: 😌 :relieved:
😆 :satisfied: 😁 :grin: 😉 :wink:
😜 :stuck_out_tongue_winking_eye: 😝 :stuck_out_tongue_closed_eyes: 😀 :grinning:
😗 :kissing: 😙 :kissing_smiling_eyes: 😛 :stuck_out_tongue:
@qndev
qndev / README.md
Created June 9, 2019 07:55 — forked from roachhd/README.md
EMOJI cheatsheet 😛😳😗😓🙉😸🙈🙊😽💀💢💥✨💏👫👄👃👀👛👛🗼🔮🔮🎄🎅👻

EMOJI CHEAT SHEET

Emoji emoticons listed on this page are supported on Campfire, GitHub, Basecamp, Redbooth, Trac, Flowdock, Sprint.ly, Kandan, Textbox.io, Kippt, Redmine, JabbR, Trello, Hall, plug.dj, Qiita, Zendesk, Ruby China, Grove, Idobata, NodeBB Forums, Slack, Streamup, OrganisedMinds, Hackpad, Cryptbin, Kato, Reportedly, Cheerful Ghost, IRCCloud, Dashcube, MyVideoGameList, Subrosa, Sococo, Quip, And Bang, Bonusly, Discourse, Ello, and Twemoji Awesome. However some of the emoji codes are not super easy to remember, so here is a little cheat sheet. ✈ Got flash enabled? Click the emoji code and it will be copied to your clipboard.

People

:bowtie: 😄

@qndev
qndev / VLSM-Subnet-Calculator.md
Last active June 8, 2019 16:17
VLSM(Variable Lenght Subnet Maks) Subnet Calculator/ Chia mạng con

Cách chia mạng con


Giả sử công ty ABC nào đó có 7 phòng ban: P01, P02, P03, P04, P05, P06, P07 với số lượng nhân viên tương ứng là: 54, 33, 18, 13, 8, 7, 3. Quy hoạch địa chỉ IP cho các phòng ban trên với giải địa chỉ là: 192.168.1.0/24.

Ta sẽ quy hoạch các giải địa chỉ ip cho các phòng ban có số lượng nhân viên nhiều nhất đến ít nhất.

Một số lưu ý.

@qndev
qndev / 192.168.1.0-24.md
Last active June 8, 2019 10:54
List of Subnets
Hosts Needed Hosts Available Unused Hosts Network Address Mask Usable Range Broadcast
54 62 8 192.168.1.0/26 255.255.255.192 192.168.1.1->192.168.1.62 192.168.1.63
33 62 29 192.168.1.64/26 255.255.255.192 192.168.1.65->192.168.1.126 192.168.1.127
18 30 12 192.168.1.128/27 255.255.255.224 192.168.1.129->192.168.1.158 192.168.1.159
13 14 1 192.168.1.160/28 255.255.255.240 192.168.1.161->192.168.1.174 192.168.1.175
8 14 6 192.168.1.176/28 255.255.255.240 192.168.1.177->192.168.1.190 192.168.1.191
7 14 7 192.168.1.192/28 255.255.255.240 192.168.1.193->192.168.1.206 192.168.1.207
3 6 3 192.168.1.208/29 255.255.255.248 192.168.1.209->192.168.1.214 192.168.1.215
<activity android:name=".DisplayMessageActivity"
android:parentActivityName=".MainActivity">
<!-- The meta-data tag is required if you support API level 15 and lower -->
<meta-data
android:name="android.support.PARENT_ACTIVITY"
android:value=".MainActivity" />
</activity>
package org.sqlite;
import java.sql.SQLException;
public enum SQLiteErrorCode {
UNKNOWN_ERROR(-1, "unknown error"),
SQLITE_OK(0, "Successful result"),
/* beginning-of-error-codes */
SQLITE_ERROR(1, "SQL error or missing database"),
BEGIN
IF((SELECT CURDATE()) > (SELECT date_to_exist FROM class WHERE NEW.register_class_id = class_id))
THEN
SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Đã hết thời gian đăng kí lớp!';
END IF;
IF((SELECT total_registered FROM class WHERE NEW.register_class_id = class_id) >= (SELECT max_register FROM class WHERE NEW.register_class_id = class_id))
THEN
SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Đã hết chỗ đăng kí lớp!';
// RAISE (ABORT, 'message');
BEGIN
UPDATE class SET max_register = total_registered - 1
WHERE class.class_id = OLD.register_class_id;
END
BEGIN
IF((NEW.start_time - NEW.end_time) >= 0)
THEN
SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Thời gian lớp học không hợp lệ!';
END IF;
END
BEGIN
IF((SELECT max_register FROM class WHERE class_id = OLD.class_id) >= 20) THEN
SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'lớp đã có đủ tối thiểu 20 sinh viên!';
END IF;
END