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 What? This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• 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 site to reflect the usernames/passwords created in the previous steps. $sitename - I would suffix this with "TEST" so as to quickly distinguish this from your main website. $db, $user and $password - these are the database and login credentials....

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

Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 hundred to few thousand queries (per page). The webserver limits me to 50,000 queries an hour and I am blowing past that quickly with just 1 person (me!) on the site so they just refuse the connnection after a while. Obviously something is not right. I...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 image, etc). Programs which I would NOT recommend I've put a list of programs which I installed and uninstalled just as quickly as they failed to properly reflect IE6 and IE8 features (& bugs?). IECollection v1.6.0.6 Multiple IE Installer v? (Old and...

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 a specified column + Generate interactive flash charts The program was intended to chart EventViewer "Security" logs but I quickly found that I could make it group and chart any Comma Separated Value file. CHANGELOG: Version 1.0 + This is version 1.0...

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

Newbies guide to be the local computer guyhttps://www.joellipman.com/hardware/newbies-guide-to-be-the-local-computer-guy.html

28 April 2011 is all I could fix in the time I have, all your issues have been dealt with and I also did this..." "So this is what I've quickly put together for demo purposes."

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

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

28 June 2011 task bar). It's currently set to 15 seconds between each photo and it happily did my 153 (has done a few times over quite quickly due to testing). Options/Features Source Browser Size: Sets what the original picture dimensions are. Output Thumbnail...

• 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 It is NOT RECOMMENDED to set this to normal users as this will use up your entitlement to FREE prints extremely quickly. The "STOP Thumbnail Service" parameter was created to be economical to both your server and the free service. Use this wisely and...

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

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

11 September 2012 1,'top': 0,'left': 0,'height': v_win_height,'width': v_win_width }); }); }); }); Known Issues If the end-user clicks too quickly between slides, the slides are not ready or not in the right position until after 1 second --> reduce transition duration?...

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

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

27 November 2012 all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for referencing by staff/students. How? Let us assume that we have a system...

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

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 So 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

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 (SSMS) and Microsoft's SQL Server 2008 R2 for development purposes, the once-in-a-blue-moon restore from backup process is quickly forgotten. How? You need to set the database to single-user mode. In SSMS, connect to an instance of the SQL Server...

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

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

03 April 2013 infographic report has excited them to no end but because the end of the month didn't wait for me to finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a...

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

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

07 May 2013 following ZIP file contains the default Joomla v3.4.x core files and then a copy with my modifications above. I use this to quickly add the relevance option to clients websites as it should work for all Joomla installations version 3.4.x. Download demo...

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

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 are because the default setting for computers running MS Windows are set up to hide filename extensions. So you can do this quickly on a friend's PC and it's a bit geeky. Type the following NOTEPAD rename.bat and answer Yes to if you want to create it....

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

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

08 March 2015 want images 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...

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

Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an...

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

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 and to determine what was wrong with each step of the development as the error messages were somewhat vague. I thought I'd quickly write this article so I don't have to spend so much time on it again. Note that the below examples, demonstrate a script...

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 to list a function I use called "Filexpro()", then list some examples of usage. And in the second-to-last section, I'll quickly convert a 100 nanoseconds unit to display Hours : Minutes : Seconds. We could have tried out some cool new DLL files for MS...

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