Setting a rocket theme background to fixedhttps://www.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 url(../images/backgrounds/bgstyle1/bgimage.jpg) 50% 0 no-repeat fixed;} Click on the 'Save' button. The theme is getting it from a generated php file. Look in the CSS folder of the template. You should find a PHP file in this folder with the...

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

Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-", trim(substr($this_date, 0,...

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

How to use download managers with Google Chromehttps://www.joellipman.com/articles/google/how-to-use-download-managers-with-google-chrome.html

19 September 2009 Apparently everyone knows how to download FLV videos from web addresses which use the Youtube syntax: http://www.youtube.com/watch?v= Using the bookmark feature: Right click on the bookmarks bar of Google Chrome. Type the name to what ever you want...

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

Migrate MediaWiki to another serverhttps://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files to wiki folder and then run php update.php from maintenance folder after updating AdminSettings.php More Information http://www.mediawiki.org/wiki/Manual:Moving_a_wiki

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

Joomla banners not rotatinghttps://www.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

20 October 2009 categories as vertical, horizontal and square banners. This means that you can have 3 modules each displaying banners from each category and position these as appropriate.

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

After installing rokstories, get invalid argument 106https://www.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

14 January 2010 After I installed the rokstories module from www.rockettheme.com, if I clicked on one of the articles (rokstory), I would get a page with the article on it but with the following error (3x) above it: Warning: Invalid argument supplied for foreach() in...

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

Increment a column in MySQL using the UPDATE queryhttps://www.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE...

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

Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 by removing the reference to router.php within the installation XML file. (router.php). I even deleted the router.php file from my installation zip file (I checked that nothing was referring to it). The reason I've fixed it the way I did is because I...

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

Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

16 September 2010 your Front Page Manager to take effect. To set them, do this in your Joomla! Admin Panel (back-end). Choose Menu > Main Menu from the pulldown menus. Click on the Home item's name (or whatever item happens to be your default frontpage item, can't be an...

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

Comparing two mediawiki siteshttps://www.joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 out this process and it's due in two hours. Checking both MediaWiki have the same article content: Print Special:AllPages from both sites and do an eye-check (I basically highlighted articles found in one but not the other - we had over 2000 articles......

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

SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a...

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

F_ck You. Pay Me.https://www.joellipman.com/articles/web-development/fck-you-pay-me.html

14 April 2011 Happy Cog and Typekit (who also hosted the event at their office in the Mission). 2011/03 Mike Monteiro | F*ck You. Pay Me. from SanFrancisco/CreativeMornings on Vimeo.

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

Code Troubleshooting Checklisthttps://www.joellipman.com/articles/web-development/code-troubleshooting-checklist.html

03 June 2011 try drawing a picture. If you can't find a solution, try assuming that you have a solution and seeing what you can derive from that ("working backward") If the problem is abstract, try examining a concrete example. Try solving a more general problem...

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

Mouseover Links in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 when my mouse cursor hovers over a link, I want that link to turn blue and display an underline. When I move the cursor away from the link, I want the link returned to black without an underline. How? #NoEnv SendMode Input SetWorkingDir %A_ScriptDir%...

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

Increase Recent Documents Number in Windows XPhttps://www.joellipman.com/articles/microsoft/windows-os/increase-recent-documents-number.html

28 July 2011 Just a quick note here. This is an article based on the REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked what it's doing. I'm putting a note here just...

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

Format Numbers in AutoHotkey with Commashttps://www.joellipman.com/articles/automation/autohotkey/format-numbers-in-autohotkey-with-commas.html

20 September 2011 2) } else { break } } Return Result } Use as per usual: ValueWithCommas:=FormatAddCommas(NumberWithoutCommas) One taken from the AutoHotkey forums: AddCommas(val) { val:= RegExReplace(val, "(\d)(?=(?:\d{3})+(?:\.|$))", "$1,") Return val } Another not...

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

Reminder on SSRS row separatorhttps://www.joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 04/10/2011 Main Office 09:00 17:00 Notes Tuesday 04/10/2011 Another Office 09:00 17:00 Notes Row Seperator This follows on from my T-SQL Record Separator article. If you are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you...

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

Strip HTML in MySQLhttps://www.joellipman.com/articles/database/mysql/strip-html-in-mysql.html

06 December 2011 able to omit HTML tags in certain fields of a mySQL database. Why? We are preparing to migrate old content to a new system. From a MediaWiki CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be used. How? There...

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

MediaWiki: MySQL to extract path to imageshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 2)) AS img_path, CONCAT(SUBSTR(MD5(img_name), 1, 1), '/', SUBSTR(MD5(img_name), 1, 2), '/', img_name) AS img_path_with_file from wikimedia_image -- where -- SUBSTRING(img_timestamp, 1, 8)>=20110922 ORDER BY img_timestamp DESC Note that I've commented...

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

Select unique values in Microsoft Excel columnhttps://www.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique records only" box. A few more from Microsoft Office Help /* Count the number of unique number values in cells A2:A10, but do not count blank cells or text...

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