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

27 April 2011 this allergy?" PLG_USER_PROFILE5_FIELD_ALLERGYTIME_LABEL="Time With Allergy?" PLG_USER_PROFILE_FIELD_ALLERGYTIME_MESSAGE="Select one of the options" PLG_USER_PROFILE5_XML_DESCRIPTION="User Profile - JoelLipman.Com Plugin" JOELLIPMAN_BOOLEANYES="Yes"...

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

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

07 July 2011 Login to your Joomla! Administrator Panel. Go to "Extensions" > "Install/Uninstall". Click on the "Upload" button and select the file you downloaded in step #1. GLOSSARY/TERMS/DEFINITIONS - File = A file which is available for download from your site,...

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

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

19 July 2011 I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, table2 WHERE table1.studentID = capd_table2.studentID AND (...

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

Migrate Joomla Users to WordPresshttp://mail.joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 (ID, user_login, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name ) SELECT a.id 'ID', a.username 'user_login', REPLACE(TRIM(LOWER(a.username)), ' ', '_') AS 'user_nicename', a.email AS 'user_email', '...

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

Basic Oracle Stored Procedure Structurehttp://mail.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 PROCEDURE sp_get_studentdetails_from_ad ( c_test out sys_refcursor, p_STUDENT_ADNAME in varchar2 ) IS BEGIN OPEN c_test FOR SELECT * FROM student_accounts WHERE student_username = p_STUDENT_ADNAME; END; View the results? Oracle PL/SQL is a bit of a...

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

Data Randomization Function in Oracle PL/SQLhttp://mail.joellipman.com/articles/database/pl-sql/data-randomization-function-in-oracle-plsql.html

22 August 2012 ('Error in submitted value'); WHEN others THEN RETURN ('Unable to generate random value'); END UFN_DATASCRAMBLE; Usage SELECT -- UFN_DATASCRAMBLE(DATE_CREATED, 'DATE') scramble_column, -- testing inputted column UFN_DATASCRAMBLE(0123456789012345, 'INT')...

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

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

23 September 2009 root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy...

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

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

27 August 2012 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 in the component parameters/options. The "clear" button is essential as some article_modal fields may not...

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

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

09 November 2012 your Outlook 2007 Using MS Internet Explorer (demo below is version 8), bring up your SharePoint Calendar Click on Actions Select Connect to Outlook Allow the website to open a program on your computer (opens Outlook). Confirm the prompt your Outlook...

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

Setup a copy of your Joomla websitehttp://mail.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 to TEST to copy over any hidden files. You only have to do this on the first refresh. For further refreshes, you can simply select all files in LIVE (except for configuration.php) and copy these to TEST using the web-based file manager. Above & Beyond...

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

Quickly update all content in mySQL database replacing a stringhttp://mail.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 First let me find all the articles that need this change: SET @stringtoFind=' '; SET @stringtoReplaceWith=' '; SELECT `id` , `title` , IF(LOCATE( @stringtoFind, REPLACE(`content_column`, @stringtoFind, @stringtoReplaceWith) )>0,'yes','no') as...

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

Export/Import Database using MySQL Workbenchhttp://mail.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 want to export/import my database: Connected! Now click on Data Export in the left hand panel: In the screen that appears, select your database, specify to export to a Self-Contained File and click on Start Export: Importing Before importing a SQL file,...

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

Administrator Program Shortcut without Prompthttp://mail.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 specify a working directory. OK the dialogs and close the Task Scheduler Right-click on an empty space on the desktop and select New > Shortcut Type in the task with the format schtasks /run /tn "task-name" schtasks /run /tn "VisualStudio2010" and click...

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

Fix Oracle Tnsping 3511 without Windows Registryhttp://mail.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 environment variables using the Command prompt (DOS) wouldn't stick (session only). My Fix Right-click on "My Computer" > select "Properties" Click on "Advanced System Settings" Click on "Environment Variables" Under "System Variables" modify the...

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

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

03 April 2013 7. How to use: Save a frame of your Awstats page (so there isn't the menu on the left) Run "Generate_AwStatsParsedData.exe" Select the file you saved in step 1 Click on "Go". What data does it return? Any table/grid in the Awstats report uniquely...

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

Joes Syntax Styler (JSS)http://mail.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 really basic that simply lets me style content within the tags: Use PHP or JavaScript (avoiding Framework conflicts) You select what words are highlighted what color. Uses separate CSS file for overall look. This is still in development! Currently this...

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

Things to Check if Joomla Password Reminder email not being senthttp://mail.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 joomla user group containing you (or if “Super Users” is a tiny group then use these) Navigate to Users > Mass Mail Users > Select the group you just made. Send a test message. Test your email server can message: Send an email using the server that the...

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

Registered Users Cannot Login - Super Users Canhttp://mail.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 value with a trailing underscore (eg. "abc12_") Check if you have more than one asset with a parent_id equal to zero: SELECT COUNT(*) FROM #__assets WHERE parent_id=0 -- where #_ is the Database Tables Prefix value There can be only one: If the number...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttp://mail.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 Check "Public Key" contains your key. STEP #3: Enable admin option dropdown This is a code change to allow the admin to select recaptcha. Open the file \administrator\components\com_jcomments\admin.jcomments.php (line 1066) Replace the line $captcha[] =...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 \components\com_jcomments\libraries\ayah STEP #3: Enable admin option dropdown This is a code change to allow the admin to select PlayThru. Open the file \administrator\components\com_jcomments\admin.jcomments.php (line 1066) Replace the line $captcha[]...

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