How to view template module positions in Joomla! 2.5?

In Joomla! 1.5.x we used to append ?tp=1 at the end of the URL (i.e. http://www.yourdomain.com/index.php?tp=1) to view the module positions of the current template. In Joomla! 2.5, its same but you need to enable "Preview Module Positions".   Following steps Read more

Joomla! vs WordPress Security Updates in 2011 (The number game)

This article gives a detail statistics on Joomla! and WordPress security updates in 2011. Both CMS went through re-design and re-modeling process in 2011. Joomla! was in the process of developing 1.7/2.5 which was released in January 2012 and Read more

Solution to GoDaddy .htaccess Problem

  Recently, Gododdy hosting is having various issues with .htaccess and its nightmare for Joomla! administrator if you are running SEF URL or using product like sh404SEF.       Please try following possible solution to address your problem.   In Joomla! Turn OFF all the Read more

Simple Joomla! Replication Procedure

There are various ways to replicate Joomla! environments we can use 3rd party tools like XCloner, etc… In this article, I am going to show rather simple way to achieve the replication of Joomla! or any other CMS. Background: We Read more

Joomla! 1.7 to Joomla! 2.5

I know there are auto update tools out there on Joomla! extension directory to update Joomla! from 1.7.X to 2.5.X but I will recommend everybody to follow instruction mentioned by Joomla! community. http://docs.joomla.org/Upgrading_from_an_existing_version If you have used utilities like Joomla! Pack Read more

Akeeba Backup Review

I have been using Akeeba Backup for more than an year now. Here is my analysis of the product. Advantages: Akeeba backup is wonderful tool if you are want to backup your Joomla! CMS on the fly. This is where I Read more

Why big “3” selected Adelaide Oval for Pakistan vs. India game in Cricket World Cup 2015?

W

hen we talk about India vs. Pakistan as a Pakistani cricket fan, we must first start looking at the team squads, individual team captains, grounds, previous records, playing conditions, etc. I was analyzing all of the above factors and found some interesting points, which led me to understand that why big the “3” selected Adelaide Oval for Pakistan vs. India game. Following you will find my analysis, I would like to share it with you:

1 – Team Records in Adelaide Oval

India in Adelaide Oval

Played
13
Won
7
Lost
5
Tied
1
Winning Percentage
54%
Key Points:

Pakistan in Adelaide Oval

Played
15
Won
3
Lost
12
Tied
0
Winning Percentage
20%
Key Points:

2 – Highest ODI averages in Adelaide Oval vs. any opposition:
 Count of Indian player(s) with Highest ODI averages in Adelaide Oval:  2

  • MS Dhoni and VVS Laxman
  • *MS Dhoni is still an active player and captain of Indian cricket team.

  Count of Pakistani player(s) with Highest ODI averages in Adelaide Oval   1

  • Azhar Mahmood

 

3 – Highest individual scores in Adelaide Oval vs. any opposition:

 Count of Indian player(s) with highest individual scores in Adelaide Oval:  2

  Count of Pakistani player(s) with highest individual scores in Adelaide Oval:  1

  • Saeed Anwar

 

Summary:

Clearly from the statistics, we can notice that there is little hope for Pakistan to win this match. These grounds were added in the world cup schedule by mathematical analysis, evaluation, and thought process. When hosting the India vs. Pakistan match, the first thing as a scheduler you would do is to look at the grounds capacity because you would like more people to be able to watch the game but this was apparently not done in this case. The Melbourne Cricket Ground (MCG), is the biggest cricket ground in Australia, leaving the Sydney Cricket Ground as the second biggest. But the MCG and SCG were not even considered and schedulers chose to go with Adelaide Oval, just because India is more comfortable there and they have a better winning percentage on that ground. Let’s look at MCG vs. SCG from India’s and Pakistan’s prospective, and it is clear to see why they were not picked for this extravaganza encounter.

India in MCG

Pakistan in MCG

India in SCG

Pakistan in SCG

Played
    18
    22
    16
    20
Won
8 8 4 6
Lost
10 14 12 14
Tied
0 0 0 0
Winning Percentage
44% 36% 25% 30%

Note: This analysis was done on Jan 23rd, 2015.

Posted on by Hassan Janjua in Cricket, Miscellaneous 5 Comments

Export vimeo album to HTML table

I have VIMEO PRO account and its very difficult sometimes to copy paste videos titles and URLs to my website. I was trying to figure out a way to extract the video information from vimeo and get the list of all my videos under my vimeo channel. If you would like to achieve same functionality you can follow the following steps:

STEP # 1: CREATE AN ALBUM IN YOUR VIMEO ACCOUNT AND ORGANIZE ALL VIDEOS IN YOUR ALBUM

  • Go to https://vimeo.com/organizer/collections
  • Under organizer > Create new album and organize all videos in the newly created album
  • Get Album ID and save it (if you don’t know how to get album ID you can following instruction here -https://forum.livebooks.com/livebooks/topics/what_is_my_vimeo_album_id)



STEP # 2: DOWNLOAD AND UPLOAD VIMEO ADVANCE PHP API LIBRARY ON YOUR HOSTING

  • Download PHP API Library: https://developer.vimeo.com/apis/advanced#libraries
  • From that zip, upload “vimeo.php” and “index.php” to a folder called “vimeo” on the root of your website
  • Create a folder within “vimeo” called “cache” with permissions 777.
  • URL will be: www.YOURWEBSITE.com/vimeo/



STEP # 3: REGISTER YOUR WEB SITE AS AN API APPLICATION ON VIMEO

  • Login to your vimeo account, and register your website as a new “app” at http://www.vimeo.com/api/applications/new
  • Use the URL of your website as the “Application URL”. IMPORTANT: Enter the URL to the index.php you just uploaded as the “Application Callback URL”. (In my example, this would be http://www.YOURWEBSITE.com/vimeo/index.php)
  • If it’s your first time registering an app, you MAY have to wait for a human interaction to authorize the request.
  • Get your Consumer Key and Consumer Secret
  • Get YourOAuthAccessToken and YourOAuthAccessTokenSecret


Posted on by Hassan Janjua in PHP Leave a comment

Cartoon of the Day!

Version # 1

pcb_joke

Version # 2pcb_v2

 

Posted on by Hassan Janjua in Cricket Leave a comment

Function to export query or table to MS Excel

Following function exports data from a table or query to MS Excel.

Posted on by Hassan Janjua in SQL Server, Visual Basic Leave a comment

Delete all data in the all worksheets except first row in each sheet

Question:

How to delete all data in the all worksheets except first row in each sheet?

Answer:

 

Posted on by Hassan Janjua in Excel VBA Leave a comment

Insert values if not exist

Question:

How to INSERT values in MySQL table if they don’t exist?

Solution:

Following procedure will insert values in MySQL table “PatientProcedureCompleted”; if they do it will update “chart” value.

Posted on by Hassan Janjua in MySQL Leave a comment

Autofit using Excel VBA

Question:

In excel we selected the entire worksheet and then do Format > Column -> Autofit selection and Format > Row -> Autofit

How we can do this in VBA?

Solution:

 

Posted on by Hassan Janjua in Excel VBA Leave a comment

Delete the entire row if the certain text is present in column

 Question:

How to delete the entire row if the certain text is present in column?

Solution:

Following procedure will delete the entire row if the certain text is present in the column(s)

This example deletes the entire row if it finds “error” in column CD

 

Posted on by Hassan Janjua in Excel VBA Leave a comment

xPlore Tools

The following  in the link to some useful tools for xPlore 1.0 or 1.1:

https://community.emc.com/docs/DOC-8922

Posted on by Hassan Janjua in Documentum, ECM Leave a comment
  • Hassan Janjua is a Sacramento, CA, USA based web designer specializing in Joomla! development. Hassan is involved in many aspects of the Joomla! and open source content management community. Hassan holds project manager postion with JoomClan.com where he is managing 3rd party Joomla! extensions like JoomRSS, JoomListings, JoomClip, and JoomDocs. Hassan has more than 8 years of experience in Mambo and Joomla!.

    Let me know what you think

    You can contact me via email button below or submit online

    Feedback Form