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 it has no bearing as to why it wasn't working. Install the RokBridge component from RocketTheme This process is usually quite quick. You install the component as per usual and link to it from your menu. Download the component from the RocketTheme...

• 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 details of prevous CB hacks in the Joomla forum (source: http://forum.joomla.org/viewtopic.php?t=84436) . In fact, there are quite a few vulnerabilities my scanners have picked up on and so I'll be posting solutions for those who need to keep Community...

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

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 to use the upgraded CMS, I have looked into this and it would appear that Joomla! CMS have not changed this. I'd imagine it quite low priority. This is easier to tweak in the upgrade. The following will again maintain the functionality for your website...

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

Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 what you typed and what it displayed!!! I have written this article to be another one of those programmer's tweaks. This is quite a simple fix and I will hopefully be able to keep it simple for non-programmers. The tweak below will stop any of your...

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

Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 command: Visit http://www.paraesthesia.com/archive/2010/04/16/fun-with-windows-aero-flip-3d.aspx as this was not my idea but quite ingenious and worth a mention. Did anyone else have any problems with Aero effects when they first installed Windows 7?...

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

Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for transactions...

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

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

11 January 2011 Copyright This site and its design is property of SomeoneElse.com Note how I don't use the `id` columns of the tables as I'm quite content with just the two columns I requested. And for those of you that don't know, the alias "AS" is optional in MySQL...

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

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 on maintenance & development costs/time -> custom timesheets!) Check domain name is registered/transferred to the client (quite a biggy - gives the client an exit strategy) Can the developer be contacted? No! Security Check Usernames/Passwords (formats,...

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

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

28 June 2011 the 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: *

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 another great resource for learning Javascript. In the image above, note the document object - you will be using this object quite often. To access the Webpage, you will need to navigate through the HTML DOM. Here are some simple ways to do this: Object...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 It was very plain and basic, needed tweaking to get rid of adverts and to integrate with a website's template which could be quite tiring. Following the crash, database performance was at an all time low and analysis revealed it be incorrectly designed....

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

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 Maybe the answer could be in that mess of a Microsoft article but this I can already do and it didn't quite do what I wanted. I ran out of time (all MORNING!) so I went with solution #2 (above) and added the OR clause to all my dataset queries and...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• 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 WHERE Contact='Joe' Now when Excel refreshes the data, it acknowledges new lines (the "CHAR(10)" as with other cell data). Quite a lot of spacing (the height of one text line), but our customers were complaining it became too convoluted and cramped when...

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

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

20 August 2012 have no idea how long it has taken me to get this code in working order and as easy as it may be to others, this has been quite a challenge. I have tried so many examples, testing different mootools libraries to see why the Joomla ones weren't working....

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 is Caring Now my colleagues have set up the calendar in their instances of Outlook, they can also add to the calendar quite easily as we used to use an Outlook Shared Calendar before. We see leave announcements as well as key dates and deadlines popup...

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

Delete related records from multiple tableshttps://www.joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 of the article as it is what you should do before running a DELETE FROM statement but I've added it here as I use it quite often: SELECT s.sessionId, ssf.sessionId, sst.sessionId FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON...

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

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 SUBSTRING(@Haystack, CHARINDEX(@Delimiter, REVERSE(@Haystack)), LEN(@Haystack)) -- yields ".String2.String3.String4" Not quite right, as we got the last occurrence counting from the beginning rather than the end, so we still need to work out the...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• 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 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 excuse. I also found that examples across the web were...

• 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 Webservice is an API provided by apimo.com and requires a server request over HTTPS using the GET method. Why? This was quite difficult to connect to and to determine what was wrong with each step of the development as the error messages were somewhat...

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

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

22 February 2019 the logo floating over it at the center of the page as well as a logo fixed to the header of every page. The logo image was quite a big image at 2501x805 pixels. By resizing it to the final output size (464x99 pixels), cropping out excess whitespace,...

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