Mediawiki Extension for Camtasia Studio SWF videoshttps://joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 { global $wgParser; $wgParser->setHook( "bukbplayer", "renderFlvPlayer" ); } function renderFlvPlayer( $input, $argv ) { $result = $flvPlayerFile->render(); return $result; // send the final code to the wiki } Amend your skin files Amend your skins to...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 hour'); $api['jwt']['claim_set']['iat'] = strtotime('now'); And finally the JWT signature (or assertion in this case resulting as a combination of the header, data and signature): Using the JWT header, and claim set above, along with the private key,...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 opt out of eBay marketplace account deletion/closure notifications has passed. Failure to comply with this requirement will result in termination of your access to the Developer Tools, and/or reduced access to all or some APIs. New Developers: All new...

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

Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

31 May 2009 Breaking rules result in punishments. There are several types of punishments: Warning - This is where a public announcement is made that mentions your name and that you have broken a rule. I will determine whether you knew what you were doing was wrong...

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

Counting the occurence of a word within a string: Benchmarkhttps://joellipman.com/articles/web-development/php/counting-the-occurence-of-a-word-within-a-string-benchmark.html

06 September 2009 occurrence of a specific word within a string of text. Source: http://hasin.wordpress.com/2007/04/30/c … functions And the result is First Run Count by Split+Count took : 0.44112181663513 Seconds Count by Preg_Match+Count took : 0.46423101425171 Seconds...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Creating a Top 10 chart with less codehttps://joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result by prefixing with leading zeros (for sorting purposes - eg. so 10 is not before 2) Store both the formatted count and the...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 from the a sample table: $db =& JFactory::getDBO(); $sql_utf8 = "set names 'utf8'"; $db->setQuery( $sql_utf8 ); $temp_result = $db->query(); $sql = 'SELECT '.$modulescancontentsql.' FROM #__content WHERE state=1'; $db->setQuery( $sql ); $rows =...

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

SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 the time of the event e.EventDate, --event details to display e.Note --CTEs defined above are used as the queries for the results FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS DATETIME) = d.[Date] --Set the maximum...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 FROM [ROOMS] rms WHERE rms.SiteId=@siteId AND rms.SetId=@setId ) You should be able to provide this statement with a result set similar to the following (if you include a tooltip with loads of info then just picture it at the end of these fields): Time...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

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

28 June 2011 output thumbnail file type). For example: the line "www.joellipman.com | best_site_ever" (without the double-quotes) will result in an image file called "best_site_ever.bmp". Pros/Cons - Advantages/Disadvantages On-Demand: Run this program in the...

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

Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 to switch this off, the parameter "Semi-Transparent Effect" has to equal 1. If you put a fraction of 1, eg. 0.5, this will result in the thumbnail having 50% opacity to start with when the page loads; when you hover the mouse cursor over it the...

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

SSRS Redirect after a report is runhttps://joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 report which acts like a search page. You enter the student you are looking for by reference or name and if there is only 1 result in the results page, then we want it to redirect to the details report for that student automatically. How? So there are...

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

Stop Excel Row Height Self-Adjust on Refreshhttps://joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 line), but our customers were complaining it became too convoluted and cramped when refreshing data and preferred the end result with this change. Note on "row height": We did not want the customer having to format the report after they've already gone...

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

No rows returned in Oracle causes SP to failhttps://joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty result set. Furthermore I am using this stored procedure in a SQL Server Reporting Services (SSRS) environment and don't want to...

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

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

22 August 2012 data but the same length and the same type of data. Why? The joy of working with the plethora of applications out there result in me using MySQL, Oracle PL/SQL and Transact SQL in my day job. The equivalent functions have to be written up all in the...

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

Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 'nchar', 'varchar', 'nvarchar', 'text', 'ntext') ** ** AND TABLE_SCHEMA='dbo' ** ** ** ** - For performance, return results based on string length which is 1 greater or lesser than the original ** ** string value: ** ** Automatic: ** ** @minStringLength...

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

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

09 November 2012 the website to open a program on your computer (opens Outlook). Confirm the prompt your Outlook instance generates as a result. You now have a new calendar under Other Calendars, you can open another calendar alongside and now copy events over by...

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

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

03 April 2009 or adapt all or part of the work in a fashion requiring copyright permission, other than the making of an exact copy. The resulting work is called a “modified version” of the earlier work or a work “based on” the earlier work. A “covered work” means...

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

Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 character list are returned as a match. For example, to exclude the characters 'a', 'b', and 'c' from your search results, use the following regular expression: [^abc] This expression matches characters 'd' and 'g' in the following strings: abcdef ghi...

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

Export Joomla Users scripthttps://joellipman.com/articles/cms/joomla/export-joomla-users-script.html

28 February 2014 quick bit of code to get all the users out of a Joomla CMS. How? I could just type a query on the database and get the same result, but this script was more fun. Simply create a text file with the following code and upload it to the root of your Joomla...

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