Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 which your program has to read, then this is for you. DllCall will usually run contained in the program and can be hidden from the end-user. The one to rule them all: This is a function I pulled from the Autohotkey forums submitted by SKAN which lists...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 have a DEPT column that is an acronym of the departments so for example: SELECT Date, Reservation, Contact, JobTitle, Dept FROM my_imaginary_table WHERE Contact='Joe' Would become SELECT Date, Reservation, Contact, JobTitle, CHAR(10) + Dept + CHAR(10)...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Migrate Joomla Users to WordPresshttps://www.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 this article is for Joomla 1.5.x sites to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress. There are lots of commercial migrators...

• Type: Article
• Author: Joel Lipman
• Category: Wordpress
• Language: en-GB

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 different login details for their Joomla database. The example below demonstrates how to get these details and extract data from the database. How? Based on a script I found on StackOverflow. Not sure what version they were using so I modified it to...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Data Randomization Function in Oracle PL/SQLhttps://www.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 Determined submitted value as 'DATE'; v_rand_param1 := TO_CHAR(TO_DATE(v_rand_param1,'dd/mm/yyyy hh24:mi:ss'),'J'); -- eg. from 01/01/1901 (Julian Days) v_rand_param2 := TO_CHAR(TO_DATE(v_rand_param2,'dd/mm/yyyy hh24:mi:ss'),'J'); -- eg. to 01/01/2001...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 glass) and for all the flashy stuff, to only appear within the boundary of the parent div layer. Why? I'm making a slideshow from scratch. How? The idea is: Use two main div layers, I'm going to refer to them as "window_slide" and "inner_window". Slide...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 as it doesn't tell us much but it is just for demo purposes. Consider the following query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet Available') -- yields StudentDetail ----------------- Data Not...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 was going to happen when I started this. We have a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal calendar in Outlook 2007...

• Type: Article
• Author: Joel Lipman
• Category: SharePoint
• Language: *

SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 characters the blank rows somehow feed in. In this case, the Ragged Right should go to the next {CR}{LF}: The Data Flow from file to valid columns: Flat File Source: Ignore failure on Truncate, Output "KeyColumn" and "DataColumn". Derived Column Task:...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 limited. The component I'm making has to ensure user's can only see their own projects and not everyone's: SELECT * FROM #__projects ORDER BY name -- yields all projects irrespective of which user is logged in What I want: SELECT * FROM #__projects...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 Restricted access to a component? A load of blab on ACL managers? How? In our case, the website had recently been migrated from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick scan in the assets table revealed 3 assets had the...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 and no longer blocks spam comments. How? So I have come up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

DJI Phantom FC40 Paint-Job and AerialFreaks Cyclops FC40 Gimbal Upgradehttps://www.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-paint-job-and-aerialfreaks-cyclops-fc40-gimbal-upgrade.html

04 September 2014 stock Stock legs, the tall ones mean my phantom won't fit in my backpack Need a small philips screwdriver here Noting damage from previous landings Marking direction So not recommended but leftover from an old car (1998 A3), why not? Tested on the legs...

• Type: Article
• Author: Joel Lipman
• Category: Quadcopters
• Language: *

Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 A quick article on a function to allow the user to take a photo using their built-in camera or to choose an existing photo from their gallery. Why? I wanted both options to be available to the user and for it to replace a displayed image in an...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 and browse to the #__menu table Search for any values in the `alias` column that match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is the table prefix) Instead of deleting, I change the existing menu item alias...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 TRUE); curl_setopt($ch, CURL_SSLVERSION_SSLv3, TRUE); Future Considerations The data still hasn't been properly decoded from UTF-16 and encoded to UTF-8 Test writing to a file, re-encoding the file then reading from it. Helpful Links XML parsing in PHP...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 Uploaded: Tue, 28th Jun 2011 1.5.3.2- Downgraded Module version 1.6.4 to work with Joomla 1.5.x websites. - All additions from v1.6.0 to 1.6.4 included in this version. - Optimized code so as to enhance performance. - Date Uploaded: Mon, 27th Jun 2011...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

Joes Revolver Map (JRM) Downloadshttps://www.joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 Fixed: Backwards compatible parameters updated - Date Uploaded: Fri, 16th Jan 2015 Download 1.5- Enhancement: Updated widget from RevolverMaps in HTML5 - Enhancement: Compatible with Joomla v3.x - Parameters: Flash option removed - Date Uploaded: Thu,...

• Type: Article
• Author: Joel Lipman
• Category: Downloads
• Language: *

Convert foreign characters to English alphabethttps://www.joellipman.com/articles/database/mysql/convert-foreign-characters-to-english-alphabet.html

13 June 2016 A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I'm working on has just gone international and started including the...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 not have to search elsewhere... This example specifically displays the time remaining on an access_token which is generated from an OAuth 2.0 process. I want to display to the user how much time is left before another access token will be generated and...

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• Language: *