Joomla: Remove IDs from URLs for out-of-the-box SEFhttp://www.joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

14 March 2020 How? You could buy an SEF extension that does this for you or spend time tweaking your .htaccess file. Or you can take advantage of a Joomla update and do this without any coding... Pre-amble To allow the Joomla CMS to manage your SEFs you need to setup...

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

Community Builder in Joomla Vulnerabilityhttp://www.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 was detected: congratulations! you've been hacked. So first of all check that this is not just a hack to your index.html file in your web root folder (you may find a .heder.php file as well in your webroot as well as some strange index files with...

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

Change default order of weblinkshttp://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 you want is /components/com_weblinks/models/category.php and you are going to edit the _buildQuery() function, search the file for the following comment and text. As always, I would recommend you make a copy of the file before making the change just in...

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

Anti-Spam override for all submitted datahttp://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 The tweak below will stop any of your pages submitting content containing your banned words. We're going to modify a file containing 2 lines of code by default. The file is index2.php in your Joomla root folder. Make a copy of it, back it up or do...

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

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

03 July 2011 create a "no_thumbnail_yet" image (if you have selected thumbnails to be PNG then this has to be a "no_thumbnail_yet.png" file, if you have selected BMP then this has to be a "no_thumbnail_yet.bmp" file). Save it to the images folder which keeps all...

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

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

27 September 2011 If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run contained in the program and can be hidden from...

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

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

30 September 2011 Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for...

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

Country Lookup by IP address CSVhttp://www.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 in the folder you have downloaded are to create a lookup function using a MySQL database and a PHP script. As well as a CSV file equivalent. How to use: Download from my site: «Download» Run the SQL script against a test database, Modify the table name...

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

Autohotkey Count Number of Files/Folders in a Directoryhttp://www.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 So this is an article to list methods of retrieving the number of files in a folder/directory. Why? Why can't we just use a loop and file pattern native to the Autohotkey programming language: UserFolder:="C:" -- UserFolder := RegExReplace(...

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

Export Joomla Users scripthttp://www.joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 How? I could just type a query on the database and get the same result, but this script was more fun. Simply create a text file with the following code and upload it to the root of your Joomla website. Access the page from a browser and you should get...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttp://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 ReCaptcha API Check your recaptcha plugin is up-to-date as some Joomla 2.5.x systems will not have updated this: Open the file \plugins\captcha\recaptcha\recaptcha.php See if you have the line const RECAPTCHA_API_SERVER = "http://api.recaptcha.net"; If...

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

Basic Android App using Google Maps and Current Locationhttp://www.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 any instructions using the tools I had (Android Studio) which is why I've written this article. Start "Android Studio" Go to File and create a New Project... I'm developing on a Tablet so I select Phone and Tablet then a relatively old version of the...

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

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

28 March 2015 will work to fetch some XML and return it in JSON formatting as long as the XML is encoded in UTF-8. // set headers for JSON file // header('Content-Type: application/json'); // seems to cause 500 Internal Server Error header('Content-Type:...

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

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

07 September 2015 category selected - Date Uploaded: Thu, 27th Mar 2014 3.2.1 JoomlaGate- Enhancement: Label parameters in XML and language file review - Date Uploaded: Tue, 18th Mar 2014 3.2- Fixed Bug: Redeclare function issue when used multiple times - Date Uploaded:...

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

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

07 September 2015 - Parameter: Date created or date modified - Parameter: Parameter "More Links" prefix text (moved from language file) - Critical: Fixed Custom Order by Weblink ID - Date Uploaded: Thu, 2nd May 2013 2.1.2- Moved "More Links" text to Joomla language file...

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

Protecting your Joomla Administrator Sectionhttp://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 URL Create a folder in the root of your joomla website with a name that is difficult to guess but easy to memorise. Create a file called index.php in the folder you just made with the following contents: Append the following code to the .htaccess file...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttp://www.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 AutoHotkey v1.1.30.01 What? This is an article to create a standalone application which lists all the Google Chrome Profiles on your Windows 10 workstation in alphabetical order. Why? This program will be redundant if Google ever update their Chrome...

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

Zoho CRM: Upload a Product Photo using Delugehttp://www.joellipman.com/articles/crm/zoho/zoho-crm-upload-a-product-photo-using-deluge.html

27 September 2021 So we have to do the usual which is download the photo using invokeUrl then we set the paramname not to attachment but to file. We then use another invokeUrl to upload the photo to CRM: // init v_AppOwner = "joel_the_awesomest"; v_AppName = "joels_app";...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 weren't any more products if(l_ThisList.size()...

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

UNC Paths in Sharepoint 2007 linkshttp://www.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg....

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