Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 PHP5+. - Fixed Bug: Object without reference: Child object design converted to Object array. - Date Uploaded: Thu, 31st Oct 2013 3.0- Fixed Bug: Version compatible with Joomla v3 - Enhancement: Added thumbnail folder finder to debug notes. - Date...

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

Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 ID AcademicSet WeekNumber StartDate --------- ----------------- --------------- ------------------ 417 2012/2013 1 2012-07-16 418 2012/2013 2 2012-07-23 419 2012/2013 3 2012-07-30... 467 2012/2013 51 2013-07-01 468 2012/2013 52 2013-07-08 I'll use this...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 Wed, 15th Jan 2014 3.0- Enhancement: Hardcoded DS value for Joomla 3.x compatibility. - Date Uploaded: Mon, 16th Sep 2013 2.2- Enhancement: Parameter: If viewing an article, scan Displayed Article Only - Enhancement: Code Reduction (Removed unnecessary...

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

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 they get added to the bottom of the list... This is the problem. For example, if the year dropdown has a list of 2010, 2011, 2013; then if you add an entry which has year 2012, then the dropdown list will be in the following order: 2010, 2011, 2013,...

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

Proposed Budget i3 PC under £200https://www.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 something that flows as smooth as any other Microsoft product with Windows 7 as its Operating System: Proposed for January 2013 (5 suppliers) Processor Intel Core i3 3220 Dual Core CPU ( 3.30GHz, Socket 1155, 3MB Cache, Ivy Bridge, 55W, Intel HD...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 Update June 2013 - How to use this migration script: Make a backup copy of your old Joomla website (1.5.x) Download and install the latest Joomla CMS Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder....

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

Delete related records from multiple tableshttps://www.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 ssf ON ssf.sessionId=s.sessionId LEFT OUTER JOIN `SessionStudent` sst ON sst.sessionId=s.sessionId WHERE s.dateTime >= '2013-02-01 00:00:00' -- Deletes all sessions dated after February 1st 2013 -- and all related records (linked by ID) in relevant...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 their drones, here are some socially beneficial applications I found: Search & Rescue: Earthquake: Drone Adventures: Haiti 2013 Search & Rescue: Hurricane Haiyan: Drone Adventures: Philippines 2014 Search & Rescue: Night Hawk for Firefighters: Dubai...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• 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 but it's a first point of reference. This will work if the received XML is a string. // setting XML value $string = ' 2/13/2013 10:37:24 PM Failure Incorrect Contact ID '; // Replace UTF-16 with UTF-8 $xml_string = preg_replace('/(...

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

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

07 September 2015 Revolvermaps URL (rc.* or jc.*) - Corrected short form PHP tags (ie. removed these). - Date Uploaded: Fri, 11th Jan 2013 1.3- Upgraded to work with Joomla 2.5.x - Date Uploaded: Thu, 27th Dec 2012 1.2- Checked compatibility: Internet Explorer v6+,...

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

Joes Youtube Plugin (JYP) Downloadshttps://www.joellipman.com/component/content/article/joes-youtube-plugin-jyp-downloads.html?catid=92

07 September 2015 2015 Download 1.0.4- Tested for compatibility with Joomla! CMS v2.5.8 - Modified description. - Date Uploaded: Tue, 1st Jan 2013 1.0.3v1.0.3 - Added Joomla Admin Panel option: Plugin Class Suffix - Added Joomla Admin Panel option: Border Color - Added...

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

Leap Motion and AR Dronehttps://www.joellipman.com/articles/_other-misc/quadcopters/leap-motion-and-ar-drone.html

17 May 2013 control device you can connect to a computer which behaves much like a mouse or trackpad but in 3 dimensions. Available July 2013 for public release (you can pre-order if you like @ https://www.leapmotion.com/). It's noted for it's accuracy and response...

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