Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 create blank cursor { VarSetCapacity( AndMask, 32*4, 0xFF ), VarSetCapacity( XorMask, 32*4, 0 ) BlankCursor = 1 ; flag for later } Else If SubStr( Cursor,1,4 ) = "IDC_" ; load system cursor { Loop, Parse, SystemCursors, `, { CursorName := SubStr(...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 version number. If the Program specifies that a certain numbered version of the GNU General Public License “or any later version” applies to it, you have the option of following the terms and conditions either of that numbered version or of any later...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

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

30 January 2011 pre-installed). Change the database names in this script (including the new random prefix for J2.5) and run it. 20 seconds later your Joomla 1.6-2.5.x website will have all your J1.5 articles and users... DISCLAIMER: This is to help ME migrate Joomla...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 What? This article is a follow on from my article JComments 2.3 with PlayThru (Joomla 2.5.x) but this is for a later version of the components using the alternative called PlayThru by AreYouAHuman.Com. Why? The kCaptcha used by the jComments extension...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 see what the current notification preferences are setup. This one didn't tell me much first time I ran it but I can use it later on to check if my "setting the notifications" process worked. void API.fn_eBayQuery_GetNotificationPreferences() { /*...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 Space > API Scroll to the bottom of the page and you should see the 11-digit number "OrgId" there Note this down for later use Get the ZohoAnalytics Org ID: Login to ZohoAnalytics and ensure you are at the "Home" level Click on the cog icon in the...

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

Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 it "Color Picker" Add a single line text field, I'm calling it "Hexadecimal" [Key field that will be used by the application later - so perhaps rename this to 'Staff Color'] Add another single line field, I'm calling it "RGB Value" [Optional: not...

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

Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

30 May 2009 Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. You are to maintain copyright information where credit is due. The scripts and programs are distributed in the hope that...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

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

12 October 2010 or a third party, for example ‘to pay for shipping’. The cheque will clear into your bank account, only to be refused weeks later. At this point, the bank/building society will take the full cheque amount back out of your account. This would then leave...

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

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

01 March 2011 on a virtual host running PHP and MySQL. There was no documentation, logs, notes, and any code comments were in Hungarian (later found out it was slang or a dialect not understood by most Hungarians). Fellow students and system administrators could not...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• 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 JoelLipman.Com Joel Lipman April 2011 (C) 2011 JoelLipman.Com. All rights reserved. GNU General Public License version 2 or later; see LICENSE.txt info@joellipman.com www.joellipman.com 1.6.0 PLG_USER_PROFILE5_XML_DESCRIPTION profile5.php index.html...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 t0 WHERE [pretendField]='elephantastic' -- insert some empty rows to blank out later as separators (select from your existing table, needs to contain data to order by so that it's the last row of each day -- if grouping by day -- basically insert a row...

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

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

25 November 2011 Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied...

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

Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 it after the above. MYSQLI_USE_RESULT allows these results to be used once, remove it if you need counts or to use the data later on. Further Post-Joomla 2.5 aides Validating a login was MD5(password+salt) but is expected to be (not tested) bool...

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

Inline Labels in Form Fields using Javascripthttps://www.joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 field for single line of text. name="name" - attribute that assigns a variable name to this field so we can reference it later. style="color:grey" - add a styling to it by default (on initial load), in this specific case the color grey. value="Name:" -...

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

JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

27 January 2013 // Reset the query using our new query object $db->setQuery($query); // Load the results as a list of stdClass objects (see later for more options on retrieving data). $rows = $db->loadObjectList(); // Retrieve each value in the ObjectList foreach(...

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

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 the use of apostrophe or double-quotes, convert these to a numerical representation only if you need to convert them back later (eg. 034, 039). Do NOT allow any punctuation you don't use in your site structure. Slashes and underscores /_ are good (so...

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

Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 then I would simply take a Joomla install (preferably NOT the most recent version - so that you can force it to update later on) and copy over the core files. Get that working and then begin installing any third-party extensions, and then update Joomla...

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

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

24 March 2014 but the below details how to integrate the AYAH library with jComments. I will look at a solution using the installed plugin later. STEP #1: Signup at AYAH You need to have a publisher and scoring key, sign up for FREE at AreYouAHuman.Com: Basic Signup:...

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

SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source and to populate a database table with...

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