Improve Default Joomla Search https://www.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 in title x1 (eg. if word is twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext $sql_keyword = strtolower(trim($db->Quote($db->escape($text, true), false))); $query->select(' (1000*((LENGTH(TRIM(a.title)) -...

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

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

09 March 2011 $scoreparts = array(); foreach($terms_db_sql as $term){ $scoreparts[] = "(((SELECT LENGTH(t.PageTitle)-length(replace(LOWER(t.PageTitle),LOWER('$term'),'')))/LENGTH('$term'))*10)"; } foreach($terms_db_sql as $term){ $scoreparts[] = "((SELECT...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 only return only the latest survey attempt answered per respondent LEFT JOIN "ZohoSurveys - Individual Responses Query" j ON LOWER(j."Respondent Email") = LOWER(i."Respondent Email") AND (j."Response Date" > i."Response Date" OR (j."Response Date" =...

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

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

22 August 2012 'abcdefghijklmnopqrstuvwxyz ', ' '))) IS NULL THEN -- Determined submitted value as 'ALPHALOWER'; v_rand_param1 := 'L'; v_rand_param2 := LENGTH(p_original_value); v_returnedval := DBMS_RANDOM.STRING(v_rand_param1, v_rand_param2); ELSIF...

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

XML Schema Referencehttps://www.joellipman.com/articles/cms/website-development/xml/xml-schema-reference.html

13 August 2014 the maximum number of characters or list items allowed. Must be equal to or greater than zero minExclusive Specifies the lower bounds for numeric values (the value must be greater than this value) minInclusive Specifies the lower bounds for numeric...

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

Trim in T-SQL and SSIShttps://www.joellipman.com/component/content/article/trim-in-t-sql-and-ssis.html?catid=74&Itemid=165

14 May 2013 CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line Feed -- CHAR(13) = Carriage Return And in SSIS: TRIM( LOWER( REPLACE( REPLACE( REPLACE( myString, "\x0009", "" ), "\x000A", "" ), "\x000D", "" ) ) ) -- \x0009 = Tab -- \x000A = Line Feed...

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

Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/component/content/article/alternative-method-of-displaying-unicode-in-autohotkey-gui.html?catid=48&Itemid=165

29 September 2011 box drawings light up and left 218 DA U+250C ┌ box drawings light down and right 219 DB U+2588 █ full block 220 DC U+2584 ▄ lower half block 221 DD U+258C ▌ left half block 222 DE U+2590 ▐ right half block 223 DF U+2580 ▀ upper half block 224 E0 U+03B1...

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

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 (in creator this is icon in top-left > Setup > Connections) Click on "Add Connection" and click on "Zoho OAuth" Give a lower connection name, eg. "joels_connector" Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ): 2. Code to...

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

Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-list-of-timezones.html

19 October 2021 America/Knox_IN America/Kralendijk America/La_Paz America/Lima America/Los_Angeles America/Louisville America/Lower_Princes America/Maceio America/Managua America/Manaus America/Marigot America/Martinique America/Matamoros America/Mazatlan...

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

Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html

13 July 2023 This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records...

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

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

03 October 2011 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', ' ' AS 'user_url', a.registerDate AS 'user_registered',...

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

Unix Date Format Specifiershttps://www.joellipman.com/component/content/article/unix-date-format-specifiers.html?catid=63&Itemid=165

05 July 2011 century 00–99 Date %D mm/dd/yy 07/4/11 %x locale's date representation (mm/dd/yy) 07/4/2011 %F %Y-%m-%d 2011-07-4 Hours %l (Lowercase L) hour (12 hour clock) 1 %I (Uppercase I) hour (12 hour clock) zero padded 01 %k hour (24 hour clock) 13 %H hour (24...

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

Windows 7 Aero Featureshttps://www.joellipman.com/component/content/article/windows-7-aero-features.html?catid=80&Itemid=165

27 April 2010 which is very handy, but unfortunately it doesn’t work in Firefox or Chrome as yet You can also move your cursor to the lower right corner of your screen to get a preview of your desktop, click and you will be brought to your desktop Aero Shake: If you...

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

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

15 January 2012 IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN...

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

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

07 September 2015 Admin Options into sliding panels. - Added Joomla! Admin Option: Specify border color for link. - Now checks if mb_strtolower function exists (regresses to strtolower). - Additional parameters (eg. Word Background) do not load if not enabled. - Added...

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

MySQL Transactions in PHPhttps://www.joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

14 December 2016 begin_transaction() $mysqli->rollback(); } $mysqli->close(); mysqli->begin_transaction() requires PHP 5.6 and above. For lower versions you can issue the MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT")...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB