Keyboard and mouse shortcuts in Google Chromehttps://www.joellipman.com/articles/google/keyboard-and-mouse-shortcuts-in-google-chrome.html

23 September 2009 content from the clipboard. Place your cursor in a text field, then press Ctrl+Shift+V. Paste content from the clipboard without formatting. Highlight content in a text field, then press Ctrl+X or Shift+Delete. Deletes the content and copies it to the...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 for phpBB3 template. I downloaded the /phpBB3/styles/prosilver folder and copied all the files to my local copy of Affinity without overwriting if prompted. I Found that my affinity template was missing about 80 files, so I dragged the files from the...

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

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

10 November 2009 your computer! The website at.....ru appears to host malware - software that can hurt your computer or otherwise operate without your consent. Just viisting a site that hosts malware can infect your computer. For detailed information about the problems...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 suitability and variances Convert, format, or create vector-based version of the logo (vector-based = can be any size without any deterioration in image quality). Get font or agree on used font for headlines / watermarks (for overall branding...

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

Embed an FLV file into a web pagehttps://www.joellipman.com/articles/web-development/html/embed-an-flv-file-into-a-web-page.html

09 March 2010 system, you just want your FLV to play on your webpage. The following example is a demonstration of how to do this without installing anything on your webserver. I like to use flowplayer for this example but my own systems can't use a solution as crude...

• Type: Article
• Author: Joel Lipman
• Category: Hypertext Markup Language
• Language: *

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 LICENSE: These scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could...

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

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

26 May 2010 LICENSE: These scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could...

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

RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

28 October 2010 as I believe this is some issue with overloading or with the actual code and you can get to this file manager to work without changing your Joomla! setup. Watch this space for when I find a definitive answer!

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

Passwords: Did-you-knowhttps://www.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 your saved password information as well... You can opt to have these protected by a 'Master Password' but by default and without this, Firefox will display them all at a click of a button. (source: n/a 08/2008) Password recovery tools for the majority...

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

Connection Strings for SQL Serverhttps://www.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 is ignored if Unix socket is used. Multiple servers Use this to connect to a server in a replicated server configuration without concern on which server to use. Server=serverAddress1 & serverAddress2 &...

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

MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

25 February 2011 yet... So would this work if I switched MyTable1 with MyTable2? Um I'll get back on this article when I work this out without using two SQL scripts. Currently I've returned to the process where one SQL query returns all possible results and the PHP...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 times the Dates cte can recurse OPTION (MAXRECURSION 100) 1. Create a new report: We're going to run the wizard here but without it just add a matrix with [time] in the "column" and [room] in the "row" and [note/status] in the "data" cells. 2. Use the...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 which I will then compress and install using the Joomla! CMS Extension Manager. I'm going to call the folder "profile5" (without the double-quotes) and create a subfolder called "profiles". So I should end up with the following file/directory structure:...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 to the specific logged activity event (smallest unit of the drilldown). What's the problem? Enter this as a query in Excel without the parameters and it will work. Set MySQL parameters (using @ - same as T-SQL) and Microsoft Excel 2007 gets confused....

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

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

30 September 2011 the data and lose that consistency. A Workaround: New line inserted before and after So this is where I am at the moment without VBCode and other suggestions. Instead I add a newline in front of and after the smallest data value (one that I know will...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 which updates the student record as well as an audit table. The Problem The last report will execute the stored procedure without any problems. I added a second dataset on this report to select the updated data that this stored procedure commits but...

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

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 CMS site version 2.5.6. DISCLAIMER I do not work for either Joomla or JoomlaTune (Jcomments) This script is provided as is without warranty If you do not understand what this script is doing, let someone who does run it instead INSTALL INSTRUCTIONS...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 the web. All I wanted was a basic example to show me how to send a form asynchronously (ie. running in the background without loading a new page). How? This form is more AJ than AJAX as I don't even use an XML file. You'll need to create a receiving...

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

Joomla article modal with clear buttonhttps://www.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 I found was that no one posted this solution which I found is compatible with almost any site and with all my components without having to modify the below script. Why? The article modal is a much easier way for the end-users to select a Joomla! article...

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

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

27 November 2012 WHERE NOW() >= acyear.StartDate ORDER BY acyear.StartDate DESC LIMIT 0,1 ) ORDER BY calendar.weekNumber Same Query but without using % (avoids MySQL Error 1065: Works within PHP scripts) SELECT calendar.WeekNumber AS AcademicWeek, CONCAT(...

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