Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 Note I do not work for Yootheme. I did not post this to Yootheme forums because you have to be a paying member to access these and I tend to piggyback on my client's subscriptions. This information does not come from Yootheme forums. I am too lazy to...

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

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before:...

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

Error 1065: Query was Emptyhttps://www.joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 (“\”) character. \% A “%” character. \_ A “_” character. Additional An alternative in SQL to escape apostrophes is to change these to paired apostrophes, so: INSERT INTO myTable VALUES ('1', 'It\'s amazing!'); -- equally valid INSERT INTO myTable VALUES...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://www.joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 this is a note to myself so that I have a checklist and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there...

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

Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 the Google Chrome browser, the row would split and there would be 2 boxes on the top row and the third would pop under these. As for MSIE, that was ok when maximized. How? You could do loads of code hacks which is what I tested but all for nothing...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called MYTABLE_content. First let me...

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

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 Intelligence Development Studio (BIDS), require elevated or administator rights/privileges when run. This is so that these programs can write back and forth to our C drive. If we don't run them as local administrators on the workstation, they error...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 is a reporting system for server logs. This gives data as to your unique visitors (referred to as visitors), the visits these generated (visits), the number of files/scripts/images requested (hits) and their filesize (bandwidth). Purpose: To extract all...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 to your Joomla Admin Panel Create a TEST joomla user group containing you (or if “Super Users” is a tiny group then use these) Navigate to Users > Mass Mail Users > Select the group you just made. Send a test message. Test your email server can message:...

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

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 the receiving index.php file: Check for possible Code Injection Do NOT allow the use of apostrophe or double-quotes, convert these to a numerical representation only if you need to convert them back later (eg. 034, 039). Do NOT allow any punctuation you...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so "IT Department" and "Director of IT". "O'REILLY" should become "O'Reilly" and not...

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

ReCaptcha disappears from Joomla 2.5 Registrationhttps://www.joellipman.com/articles/cms/joomla/recaptcha-disappears-from-joomla-2-5-registration.html

24 November 2013 = "https://www.google.com/recaptcha/api"; const RECAPTCHA_VERIFY_SERVER = "api-verify.recaptcha.net"; and change these to const RECAPTCHA_API_SERVER = "http://www.google.com/recaptcha/api"; const RECAPTCHA_API_SECURE_SERVER =...

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

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J...

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

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

20 August 2014 to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's start with a function that just converts a string of words delimited by...

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

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 the compass cable seems to go across the unit unless I have the top sticker wrong Legs on Checking vents (note I had masked these before painting as per youtube videos) Possibly my new facebook profile photo My old FC40 looking new(ish) Ok, still going...

• Type: Article
• Author: Joel Lipman
• Category: Quadcopters
• 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 changes to the database Why? We have a page describing the company that we would want entitled "about" or "about-us" but these were already created along the way and then deleted. The system is still storing the offending menu items somewhere. How? The...

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

TravelPort Universal API - Ping Request with PHP-cURLhttps://www.joellipman.com/articles/automation/api-misc/travelport-universal-api-ping-request-with-php-curl.html

27 April 2015 error I'm going to address has to do with getting the latest schemas but as I couldn't find anything using Google regarding these errors or how to set up a basic ping request, I thought I'd write this article. How? Using PHP and cURL, here is the full...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

List of Font Awesomehttps://www.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 I needed to use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality or overhead maintenance. It's basically a font set that has...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

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

07 September 2015 CSS3 Rounded Corners - Added Module Parameter: 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-...

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