Note: Please check this blog post for more details on these functions.
Sort a SQL query with id and parentid so that
the rows have the correct order of the tree.
Parameters:
q(Array): A query result (see example below)
jojobyte
jojobyte
/ mysql.txt
Created
July 29, 2014 20:12
— forked from johnantoni/mysql.txt
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| username: vagrant | |
| password: vagrant | |
| sudo apt-get update | |
| sudo apt-get install build-essential zlib1g-dev git-core sqlite3 libsqlite3-dev | |
| sudo aptitude install mysql-server mysql-client | |
| sudo nano /etc/mysql/my.cnf |
jojobyte
/ README.md
Created
April 18, 2014 15:13
— forked from smrchy/README.md
jojobyte
/ index.html
Created
December 28, 2013 12:00
— forked from zhchbin/index.html
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <html> | |
| <body style="background: #333"> | |
| <script > | |
| var gui = require('nw.gui'); | |
| var win = gui.Window.get(); | |
| function takeSnapshot() { | |
| win.capturePage(function(img) { | |
| var popWindow = gui.Window.open('popup.html', | |
| {width: 420, height: 300}); | |
| popWindow.on('loaded', function() { |
jojobyte
/ main.js
Created
December 6, 2013 12:48
— forked from b1rdex/main.js
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $(function( | |
| function Menu(cutLabel, copyLabel, pasteLabel) { | |
| var gui = require('nw.gui') | |
| , menu = new gui.Menu() | |
| , cut = new gui.MenuItem({ | |
| label: cutLabel || "Cut" | |
| , click: function() { | |
| document.execCommand("cut"); | |
| console.log('Menu:', 'cutted to clipboard'); |
jojobyte
/ wp-shell-install.sh
Created
November 6, 2013 00:14
— forked from dongilbert/wp-shell-install.sh
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # Install script for Latest WordPress by Johnathan Williamson - extended by Don Gilbert | |
| # Disclaimer: It might not bloody work | |
| # Disclaimer 2: I'm not responsible for any screwups ... :) | |
| # DB Variables | |
| echo "MySQL Host:" | |
| read mysqlhost | |
| export mysqlhost |
jojobyte
/ get_barcode_from_image.js
Created
May 28, 2013 20:14
— forked from tbtlr/get_barcode_from_image.js
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * Copyright (c) 2010 Tobias Schneider | |
| * This script is freely distributable under the terms of the MIT license. | |
| */ | |
| (function(){ | |
| var UPC_SET = { | |
| "3211": '0', | |
| "2221": '1', | |
| "2122": '2', |
jojobyte
/ AbstractClient.php
Created
April 12, 2013 11:57
— forked from renoirb/AbstractClient.php
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| namespace Renoir\AggregationBundle; | |
| /** | |
| * Abstract client to use for each Client | |
| * | |
| * Example location: src/Renoir/AggregationBundle/AbstractClient.php | |
| **/ |
jojobyte
/ StackScript.sh
Created
August 29, 2011 11:32
— forked from visnup/StackScript.sh
node.js knockout 2011 StackScript
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # <UDF name="ssh_key" Label="Paste in your public SSH key" default="" example="" optional="false" /> | |
| # root ssh keys | |
| mkdir /root/.ssh | |
| echo $SSH_KEY >> /root/.ssh/authorized_keys | |
| chmod 0700 /root/.ssh | |
| # update to latest |