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

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

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

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 will help you to enable “Preview Module Positions” option from “Template Manager Options” of Joomla! 2.5.

 

 

    • Login to Joomla! 2.5.x administrator section (i.e. http://www.yourdomain.com/administrator)
    • Click on “Extensions” > “Template Manager”
    • Under “Template Manager: Styles” click on “Options”
    • Under “Template Manager Options” > Enable “Preview Module Positions” and click on “Save and Close”
    • Under “Template Manager: Styles” click on the template icon to see the modules positions of the style you want to preview as shown in the screenshot below
    • Alternative way to view module positions is to append ?tp=1 to the end of your URL (i.e. http://www.yourdomain.com/index.php?tp=1)
When you are done previewing module positions, remember to set “Preview Module Positions” to disable. Its recommend to disable the ?tp=1 function for security reasons.
Posted on by Hassan Janjua in CMS, Joomla! Leave a comment

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 WordPress released 3.3.x and development started from 3.0.x.

Following chart represents totals number of security issues reported and fixed in 2011.

Joomla! vs WordPress Security Updates in 2011

Security Updates

Joomla! (v.1.6/v.1.7)
34
WordPress
13
Notice:
– Joomla! number was calculated for version 1.6.x and 1.7.x. Other assumption made in calculation was all security issues recorded were reported and fixed in 2011.
– WordPress number was difficult to calculate because the security updates and level of details presented by WordPress community is very minimal. I had to drill down to change logs to identify the total number of security vulnerabilities. There might be a possibility that I have missed few.

 

While developing Joomla! 1.7/2.5 Joomla! community was maintaining version 1.5 as well.

Security Updates

Joomla! (1.5)
2

Joomla! security updates by type of security vulnerabilities

Joomla! security updates by type of security vulnerabilities (2011)

Joomla! security updates by type of security vulnerabilities (2011)

Path Disclosure
2
SQL Injection
2
XSS Vulnerabilities
12
Information Disclosure
9
Redirect Vulnerabilities
1
Unauthorised Access
3
CSRF Vulnerability
2
DOS Vulnerabilities
1
Clickjacking
1
Password Change
1

WordPress security updates by type of security vulnerabilities

WordPress security updates by type of security vulnerabilities (2011)

WordPress security updates by type of security vulnerabilities (2011)

Path Disclosure
1
XSS Vulnerabilities
3
Information Disclosure
1
Redirect Vulnerabilities
1
Unauthorised Access
1
CSRF Vulnerability
1
Clickjacking
1
Media Security
1
Uploader Security
1
Others
2

Conclusion: As the number shows both products went through re-design and re-model phase in 2011. But 2012’s data, will give us better understanding of the stability of these two products.

References:
Joomla! Security News URL: http://developer.joomla.org/security/news.html?limitstart=0
WordPress Security News URL: http://wordpress.org/news/category/security/

Security Vulnerabilities Information Links:
Path Disclosure:
https://www.owasp.org/index.php/Full_Path_Disclosure
Information Disclosure:
http://searchsecurity.techtarget.com/definition/vulnerability-disclosure
Redirect Vulnerabilities:
https://www.owasp.org/index.php/Open_redirect
http://developer.joomla.org/security/news/333-20110302-core-redirect-vulnerabilities
DOS Vulnerabilities:
http://en.wikipedia.org/wiki/Denial-of-service_attack
CSRF Vulnerability:
http://en.wikipedia.org/wiki/Cross-site_request_forgery
Clickjacking:
http://en.wikipedia.org/wiki/Clickjacking

Posted on by Hassan Janjua in CMS, Joomla! 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