Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 run. If you think you don't have MSIE but you have Windows XP, it's likely you have it anyway. Open Source: Open to view/modify the source code as long as you attribute credit where it's due. License is GNU General Public License v3...

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

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

03 July 2011 module. Keep refreshing the module until all thumbnails are generated. Switch "STOP Thumbnail Service" to "YES" Now modify the weblink's category to what you specified in step 1 (eg. "Helpful Links") No Thumbnail Yet? If the thumbnail hasn't been...

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

AutoHotkey Format Date and Format Secondshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-format-date-and-format-seconds.html

20 September 2011 dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) { FormatTime, FormattedTime , TimeString, %Format% return...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 other windows much like a gadget or widget. If you know your AutoHotkey, the download includes the AHK file for you to modify and play with (Hooray for OpenSource) so you can style it to your own taste. Here's some pictures of it on an XP machine with a...

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

Joes DNS Correction (JDC)https://www.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 color to green if successful, red if failed. License Details: This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the...

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

Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...

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

Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 main site to another database. Setup a database user account that can access the new database created in the previous step. Modify the configuration.php file in the root of the TEST site to reflect the usernames/passwords created in the previous steps....

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

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 INTO #__users (name, username) VALUES ('Joel', 'jlipman') UPDATE using JDatabaseDriver Here's an alternative method to modify a record in a table in Joomla: // Create and populate an object. $user_record = new stdClass(); // Must be a valid primary key...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 > select "Properties" Click on "Advanced System Settings" Click on "Environment Variables" Under "System Variables" modify the variable "ORACLE_HOME" (without the quotes). Or create NEW if it doesn't exist. Give it the value...

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

Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 enough). How? I'd like to use various techniques, and the first part of this article (Stage 1) is the only part you need to modify as this will improve your Joomla search results by giving priority to articles where the search term is in the article...

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

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 except empty ones. /E Copies directories and subdirectories, including empty ones. Same as /S /E. May be used to modify /T. /V Verifies the size of each new file. /W Prompts you to press a key before copying. /C Continues copying even if errors occur....

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

Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/articles/microsoft/excel/excel-find-values-in-one-column-that-are-not-in-another.html

06 March 2014 was NOT found in column A. Method #2 Be careful with this one because if you copy the formula down, it may automatically modify the range. So the formula in the first row will be =COUNTIF(A2:A100, B2) but the formula in the second row will be...

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

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 (If you want my cached download - v1.1.8: click here) Extract the ZIP file to a folder (should be about 4 php files) Modify the file ayah_config.php to match the publisher and scoring key given to you. > Save Upload the files to...

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

301 Redirect using htaccess filehttps://www.joellipman.com/articles/web-development/301-redirect-using-htaccess-file.html

03 April 2014 this with a .htaccess file: Upload a text file to the root folder of the old domain's website Rename it as ".htaccess" (or modify the existing one) Add the code as per below. Save the change. Different ways for different results, let's pretend I'm...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 (If you want my cached download - v1.1.8: click here) Extract the ZIP file to a folder (should be about 4 php files) Modify the file ayah_config.php to match the publisher and scoring key given to you. > Save Upload the files to...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• 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 = RTRIM(LTRIM(@StringInput)) INSERT INTO @OutputTable ( StringValue ) VALUES ( @StringValue ) END RETURN END Now we want to modify this slightly so that it converts a string of words delimited by pipes to a table: CREATE FUNCTION...

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 Basic to some but I'm new to the game. I'm trying to remove the first two entries from a news feed from a Google News feed. Modifying the strings can be done in the PcWorldRssParser.java (without it crashing the app). The gist is to check for a...

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

Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 and attachments) Done Sample Configuration PHP Note that the following are sample values and just for myself to quickly modify a Wordpress configuration file. // ** MySQL settings - You can get this info from your web host ** // /** The name of the...

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

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 with a comma. This parameter is a text field which uses the alias of the component (eg. "doc_indexer"), you would need to modify this to the component you want it to search. More than one area I have added the hidden fields in the HTML form (generated...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 Check In") Install new Joomla: Install Joomla! CMS v3.4.x with Demo Content (eg. 3rd-party QuickStarts): [Personal Option] Modify admin ID to NOT use a text editor (ie. "Text-editor=None") If you are going to delete an object (eg. contacts), make a note...

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