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

23 September 2009 full-screen mode. Press F11 again to exit full-screen. Ctrl and +, or press Ctrl and scroll your mousewheel up. Enlarges everything on the page. Ctrl and -, or press Ctrl and scroll your mousewheel down. Makes everything on the page smaller. Ctrl+0...

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

Using MetaMod to hide buttons from logged in usershttps://joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 menu module for the regmenu menu, mine are called - 'pubmenu' and 'regmenu'. Edit your original menu module and select everything you want your registered users to see and then copy over to the newly created 'regmenu' module or what ever you called...

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

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

28 September 2009 once and it didn't work. I then carried out all the changes going up and down the document, double-checking I had done everything their instructions said. For demonstration purposes: I am installing phpBB3 on a website at http://www.mysite.com/ and am...

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

Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 with their quickstart installations (site and template and tools) Gavick Pro Gavick.com itself is a nice site with everything working as it should. It's templates are ok but it's its extensions for which I signed up for. As well as helping another...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 -- WHERE -- `my_old_database`.jos_sampletable.user_id=1; -- You could copy and paste this whole query and then remove everything -- from the "INSERT INTO" to just before the "SELECT" (as below): -- SET @exampleLocalVariable=1; -- SELECT -- 1, 'Joel...

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

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

25 September 2009 reasons. I installed the standard 1.5 installation package. I have uninstalled and reinstalled once just to make sure everything was OK. Basically after I use my website (using the default Joomla welcome template with NO modifications whatsoever) I...

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

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

12 July 2010 same extension) Delete the original file if I have the MP3 version as well Why didn't I just convert the lot and delete everything in the original folder? Well what if I don't? Then I have to go through a few hundred files manually checking that I have...

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

Create Read-Only Database User in SQL Serverhttps://joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 Adding principals to this role could enable unintended privilege escalation. In theory, a user who can do nearly everything but modify access and security permissions:

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 Select the Report Type (for just a table with a heading row at the top, select "Tabular") > Next Click on "Details" until everything is added. > Next I'm boring and old-school so my table style will be "Generic". > Next FINISH That's all folks!...

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

Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 I'm looking to query the Title and the Introductions of any valid articles from BOTH tables and return one table with everything I want. Consider the following two tables exist: Joomla Articles (table name: jos_content): id title introtext...

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

PHP & MySQL Search Enginehttps://joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 $str); // removes numeric entities? $str = preg_replace('//i', '', $str); // removes MS Office style html comments (and everything in between) $str = str_replace(array("\r\n", "\r", "\n", "\t"), ' ', $str); // remove carriage returns, line feeds, tabs...

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

Difference between two dates - the midnight hourhttps://joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 2011-03-04 12:00:00 - 2011-03-04 10:00:00 = 2.00 2011-03-08 00:30:00 - 2011-03-08 23:30:00 = -23.00 This is great for everything during that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no...

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

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

28 June 2011 is a bunch of online websites and you need screenshots of these. Whatever the reason, I needed a FREE option and everything available had a limit to its "FREE" services. There are websites that do this for me? Yay! for free as well, as long as my page...

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

The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 aggregate query. I want the SQL to return just numbers and let the MDX query add the thousand separator. My answer for everything: CAST((TimeEnd - TimeStart) AS TIME) CAST(CONVERT(CHAR, DATEADD(millisecond,...

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

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

25 November 2011 had this? Your colleagues are connecting fine and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently loses connection or simply forgets what intranet site you were...

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

Basic Oracle Function Structurehttps://joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my successors,...

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

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

13 December 2012 also make their system escape apostrophes (') and double-quotes ("). But who can honestly build a system that thinks of everything from day one? How? Check all required values to escape have been escaped. In all my cases this has been the percent sign...

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

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 be prompted for the total range (eg. $A1:$W36000) ' And then prompted for the number of rows per sheet (eg. 3000) ' Run everything Sub RunAll() Call SplitData Call InsertRow Call CopyToAllSheets Call Splitbook End Sub ' Split data to sheets Sub...

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

Zoho Templates - Font size is inexplicably tinyhttps://joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 day where I would remove all the styling and the text would still appear small. Sure I resized the text to about 46pt and everything was over 3000px in width but this is not good for a final solution. I thought maybe there was a setting for the default...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 > /path_to/backup.sql // and in your cnf file: [mysqldump] user=my_user password=my_password The one to rule them all: // everything: using external file, suffixing date and compressing: mysqldump --defaults-file=/full-path-to/.my.cnf my_db | gzip >...

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