jesgs

DELIMITER |

CREATE PROCEDURE explode( pDelim VARCHAR(32), pStr TEXT)                                
BEGIN                                
  DROP TABLE IF EXISTS temp_explode;                                
  CREATE TEMPORARY TABLE temp_explode (id INT AUTO_INCREMENT PRIMARY KEY NOT NULL, word VARCHAR(40));                                
  SET @sql := CONCAT('INSERT INTO temp_explode (word) VALUES (', REPLACE(QUOTE(pStr), pDelim, '\'), (\''), ')');                                
  PREPARE myStmt FROM @sql;                                
  EXECUTE myStmt;                                
END |   

jesgs

# Correct LineWidth values for ToonShader nodes for Poser 7 and earlier
#
# Poser versions prior to 8 handled the LineWidth node value differently
# than Poser 8 and later. This script allows you to batch-correct the line-value,
# saving the effort of having to click on every single material.
import poser

scene = poser.Scene()
actor = scene.CurrentActor()

jesgs

Matcha Green Tea Mug Cake

Picture on Instagram

Tools:

Favorite large mug. Soup mug would be ideal.

Ingredients:

• 4 tbs flour (sifted)
• 2 tbs sugar

jesgs

<?php
/**
 * Change order parameter
 * @param WP_Query $query WP query object
 */
function mangapress_change_archive_order($query)
{
  $query->query['order'] = 'ASC';
}
add_action('pre_get_posts', 'mangapress_change_archive_order')

jesgs

<?php
/**
 * Remove all WordPress-specific stylesheets from WordPress login screen
 */


/**
 * Force-remove login-related styles. Can't use the regular method of login_enqueue_scripts
 * due to wp_admin_css running before login_enqueue_scripts
 * 

jesgs

{
    "listen": [ null, 7890 ],
    "verbose": true,
    "color": {
        "gamma": 2.5,
        "whitepoint": [ 0.9, 0.9, 0.9 ]
    },
    "devices": [
        {
            "type": "fadecandy",

jesgs

<?php

/**
 * I had to parse an XLSX spreadsheet (which should damn well have been a CSV!)
 * but the usual tools were hitting the memory limit pretty quick. I found that
 * manually parsing the XML worked pretty well. Note that this, most likely,
 * won't work if cells contain anything more than text or a number (so formulas,
 * graphs, etc ..., I don't know what'd happen).
 */

jesgs

Working with WordPress's Metadata API

This tutorial describes how to work with the WordPress Metadata API as described in the tutorial (Working with WordPress's Metadata API) posted on my blog.

jesgs

blinker.js

Test code, originally modified from the Arduino code for Spooky LED Eyes on Adafruit. Created primarily as a means to get an idea of how Node.js works with Fadecandy.

Originally from Firefly: https://github.com/jesgs/firefly

jesgs

<?php
/**
 * Theme view template example using locate_template
 * 
 * @return string
 */
function my_theme_template()
{
    
    // do view related stuff