Home Page
Archive > Updates > 2016 > All
Search:

Section: Projects > DWCF
Updated:09/27/16
  • DSQL v2.0.2.2
    • Added ability via DSQL->$StrictMode variable to update MySQL strict mode
    • Added DSQL->RawQuery() function which takes just a query, and does no modification on it. I found this required due to extremely slow times on building very large queries.
    • Added DSQL->EscapeString() function which escapes a string for use in a mysql query. It has an optional parameter that adds single quotes around the result.
    • Added DSQL::PrepareInsertList() function which takes an array of names, and turns it into the following string: ['a', 'b', 'c'] => “(`a`, `b`, `c`) VALUES (?, ?, ?)”
  • DWCF v1.1.1
    • Added previous variable lookup to GetVars.VarArray.SQLLookup via %THEVAR-$VARNAME%
Section: Projects > DSQL
Updated:09/15/16
DSQL v2.0.2
  • Added static member $InitialPrintAndDieOnError which DSQL.PrintAndDieOnError inherits on creation
  • Bug Fixes:
    • mysqli_set_charset is set to utf-8
    • In FormatSQLError() the date() function used for “Start Time” now uses “24-hour format of an hour with leading zeros” [date(“H”)] instead of “12-hour format of an hour without leading zeros” [date(“g”)]
Download Content
Section: Projects > DWCF
Updated:09/15/16
DWCF v1.1 updates
  • Added functionality:
    • GetVars.VarArray.SQLLookup:
      • Additional string parameters that have %THEVAR% are replaced with the value being checked
      • If the first item is NULL, it will be removed, and the return will include full rows ("*") of the query result set
  • Updated functionality:
    • json_encode() In RetMsg() and CallByAction() now use JSON_UNESCAPED_UNICODE
    • GetVars.VarArray.IsOptional now only triggers if it is (boolean)true
    • Added additional description specification to GetVars.VarArray.SQLLookup which says it uses the additional parameters as values to fill in the SQL Query
  • LICENSE: Now applies to 1.x instead of 1.0.x
Download Content
Updated:07/14/16
Plex Playlist Importer v1.1 (source). Current updates spanning 2017:
  • Fixed absolute path logic for Linux (partial credit to Matt Spitz)
  • Bypasses UTF8 BOM
  • Program now works off of argument flags.
    • Added parameters: Playlist encoding, override type, force list
    • Created special BulletHelpFormatter class for parameters
  • Playlist names can now conflict with other item/list names in Plex
  • Console column width passthrough in the .sh file
  • Updated READMEs regarding:
    • Unicode compliance
    • The “no such module : FTS4” error
    • Running the script from a computer external to the server running Plex
    • The “The program can’t start because MSVCR100.dll is missing” error
    • All updates
  • Added the ability to compile to a windows executable (via setup.py py2exe)
  • The Playlist Name is now an optional argument which can be entered after the program is ran. This allows directly dragging playlists onto the executable
  • Added shebang to main script
  • M3U files now ignore lines that are empty or have only whitespace
Download Content
Section: Projects > Websites
Updated:02/08/16
Section: Misc > Resume
Updated:02/07/16
  • Rewrote the background section, which was badly needed.
  • Under Notable Projects, made Intellitix past tense (as of 2012)
  • Added Notable Project C2MTL
  • Removed Obsolete Skills: VBScript
  • Added Skills: AngularJS, Django, jQuery, Amazon Web Services
  • Work Experience/Deltaarc: Specified IT Admin for Linux servers
  • Removed Obsolete Jobs and Skills:
    • Tutor at Open Doors Learning Center [1999-2001]
    • Microsoft Certified Professional [2004]
    • Place in Winston Science Programming Competition [1999, 2000, 2002]
    • Black Belt in Taekwondo [1996]
Download Content
Released v1.0 of LetsEncrypt Better Apache Installer, which “Installs SSL/HTTPS certificates via letsencrypt for all domains”.
Download Content