Enable com_content caching for logged in users in Joomla

By default Joomla will disable any caching for logged in users. However, I still need Joomla to cache com_content even if users logged in.

Enable module caching for logged in users in Joomla

By default Joomla will disable any caching for logged in users. However, I still need Joomla to cache all module even if users logged in.

Converting MyIsam to InnoDB and vice versa in MySql

MySQL supports several different types of Table Engines also known as "Table Types". A database can have its tables being a mix of different table engine types or all of the same type. Here is more information on each of the different types of table engines that MySQL offers:

http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html

There's pros and cons between this two table engines, but that's not what I wanted to discuss here.

Sometimes, when you work with MySql database, later on you relize that you using the wrong table engines for some or all tables, if it's only 1-10 tables then it's easy, but how if your database contains 30-50 tables? and only some of them using different table engine? That is tricky.

Well you can always back up the database and restore them to the correct table engines, but that will cost you more time, more over if you have huge database.

So, how to do it? First of all, you have to familiarize yourself to phpmyadmin, coz it's easiest way to do it.

It's actually 3 step of work

1. Make sure you already select the correct database

2. Select list all table with MyISAM table engine using this query


SELECT CONCAT('ALTER TABLE ',table_name,' engine=InnoDB;') FROM information_schema.tables WHERE engine = 'MyISAM';

The query result will looks like:

ALTER TABLE users engine=InnoDB;
ALTER TABLE users_group engine=InnoDB;
ALTER TABLE users_images engine=InnoDB;
....

The query will list all table with MyISAM engine tables, while doing so, it also create queries to alter those tables. The output should be lists of ALTER queries with tables name on it, now you have all queries needed to convert only MyISAM tables engine.

3. Copy all query output it produce and run those query at once ... tada... all MyISAM tables on your database has been converted to InnoDB.


Now the safest way to do it is using this step:
1. Backup your database, always backup your database!
2. If you have enough space on your harddrive copy those database to database_backup, make sure you have the same user privilege as your production database
3. Run those query above, check if all tables converted successfully
4. If something goes wrong, rename database_backup to database, make sure you have the same user privilege or restore database from backup

If you needed to convert from InnoDB to MyISAM, do the same thing, just switch 'InnoDB' and 'MyISAM'

I have done this several times with 100% success

Good Luck

Tutorial: Install Photoshop on Ubuntu 14.04

This article is based on http://ajwebdesigner.in/blog/install-photoshop-cs6-on-linux-ubuntu-13-04/ and I made adjustment and notes based on my own experience.

I have use Ubuntu since Ubuntu 12.04 LTS and now Ubuntu 14.04 LTS. As you can see on the original article, this tutorial written for Ubuntu 13.04, but, I have done this many times on Ubuntu 12.04LTS and Ubuntu 14.04LTS without any serious issues (...or not yet found :D ).

What is needed:

1. Internet Connection with huge internet quota (we are gonna need <1GB, but prepare to 1-3GB quota)

2. Install bit torrent client from Ubuntu Software Center. I use Transmission BitTorrent Client.

What you need to know:

1. All command done in Command Line/Console/Terminal. Press CTRL+ALT+T to open it

2. One line of command begins with ~$ thecommand sign

3. Please copy-paste thecommand only, without ~$ sign

4. Do it sequentially

5. Do it on your own risk

LET'S BEGIN

Install Wine

1. Add specific repository for wine

     ~$ sudo add-apt-repository ppa:ubuntu-wine/ppa

2. Update your software database

     ~$ sudo apt-get update

3. Install wine

     ~$ sudo apt-get install wine1.5

Change wine prefix

If  we use default wine prefix, then wine will set it's prefix based on the Operating System architecture.
For example, if we use Ubuntu 64bit, then default wine prefix is 64bit.
Once we set wine prefix to an architecture, to 32bit for example, then all installed application on wine should be 32bit.
You cannot install 64bit application on 32bit wine prefix, or vise versa. The installation may runs well, but you will find lots and lots bugs when you runs the application latter on.

1. Delete default wine prefix at /home

     ~$ rm -rf .wine

2. Set wine prefix to your photoshop architecture (I use 32bit)

     ~$ WINEARCH=win32 WINEPREFIX=~/.wine winecfg

Install Dependencies Photoshop

Photoshop needs lots of windows library such as Internet Explorer, Visual C, msxml, etc. We need to use winetricks to ease the process.

Winetricks will help us check weather needed library is already installed, if not, it will download and install needed library automatically. Some library need human interaction, but don't worry, it's as simple as clicking Next, next, finnish (you know what I mean :D)

3 steps to use winetricks

1. Download winetricks

     ~$ wget http://kegel.com/wine/winetricks

2. runs winetricks to install libraries

     ~$ sh winetricks -q atmlib gdiplus ie6 vcrun2005sp1 vcrun2008 fontsmooth-rgb corefonts msxml3 msxml6 vcrun2010

3. Repeat no 2 above until you see:

     Executing w_do_call vcrun2010

     vcrun2010 already installed, skipping

Copy Windows DLL

Use browser and file manager to do these 2 command

1. Download dll from http://www.mediafire.com/?2zix528zkye5vky

2. Extract, Copy-paste odbc32.dll AND odbcint.dll to .wine/drive_c/windows/system32/ on your home directory

Install Photoshop

Finally, Installing Photoshop. For those who has the CD you can simply right click on setup.exe and choose Open with wine windows loader, then do the install process like you did on windows.

or, download it via torrent at https://kickass.to/adobe-photoshop-cs6-13-1-2-extended-repack-p2p-t7744263.html

Run winetricks once more to make sure windows fonts are loaded.

     ~$ winetricks fontsmooth-rgb

To run Photoshop, you can use desktop shortcut or through Terminal

     ~$ wine '/home/namakamu/.wine/drive_c/Program Files/Adobe/Adobe Photoshop CS6/Photoshop.exe'

DONE!

Hope this help someone, and dont forget to leave your comments below, cheers... :)

Earn $5000 easily per month with Adfly

adf.ly detailed information

adf.ly is a site which allows you to shorten your URL, it is no different from bit.ly and tinyurl.com. However it does differ because they have ad twist. When ever someone opens the short url there is a 5 second frame which shows an ad. The timing is very short and thus majority of the people using this service don’t mind the wait in return for using the system.


Benefits

Traffic is targeted by country
It is very cheap: 4$-8$ per 1000 unique views (see detailed payout rates here)
Despite the low prices there is some conversion


What is URL shorteners?

URL shorteners can be used to shorten long URLs (please also note that you may shorten virtually any URL you want to, the URL does not have to be long!).

So how much money can you can you make with Adfly? It's a good question. The amount of money you can make with your adf.ly links depends on where the people who click your adf.ly links are located.


How much money can I make?

The average rate of pay is $4.00 per thousand clicks. $4.00 may sound small, but just think for a second. How many people use Facebook? Over 500 million people use Facebook on a daily basis. If you could get even a small portion of Facebook users to click on your links, you could be earning a tidy amount of money. A great way to attract lots of users to click on your links is to set up a Facebook group. Many of these groups have more than a million users - so if you get your thinking cap on, you can make good money very quickly!!!. You can also make more money by making videos and post them to Youtube and leave a link in the description.

You can also earn much money by bringing referrals. Personally I have earned more money from my refs than from other ways (learn how to get hundreds of referrals easily)


Payments

adf.ly has an easy to reach payment threshold, so once you have earned $5.00 on your adf.ly account, your earnings will automatically be paid into your PayPal or Payoneer account. If you don't have a Paypal or Payoneer account don't despair, they're both free to join and simple to use.

How to Get Traffic For your Links:

Now the question is that how we can get traffic for our links and get more money. So for this there a lot of tips and tricks to get traffic to your links which are given below:

NOTE: If you have problems with adfly links being blocked in certain sites (ex. facebook) you can use refban shortener HERE

1. Facebook.com
Millions of people use Facebook everyday, so Facebook is the best way to post your links and publish them. (see tutorial here)

2. Twitter.com
Get some followers on twitter and post your links there so your followers can click on these links. (guide1) (guide2)

3. Youtube.com
You can also use Youtube.com for your links by uploading videos. (see tutorial here)

4. Pinterest.com
Publish pictures of popular content with links of youw website. (see tutorial here)

5. Make a Website
You can make a free website (blog or free google site) and post your links on the website with your content. (see tutorial here) (see automated system here)

6. Ask your Friends
Ask your friends to follow the links on your website.

7. Use Forums
Write posts or comments on forums to promote your links and website.

8. Bring Referrals
Referrals can really boost your earnings. You will receive 20% of their earnings and 5% from the money they spend on advertising with adfly. Learn how to get hundreds of referrals easily HERE

WOEID: Where On Earth IDentifier - EN

A WOEID (Where on Earth IDentifier) is a unique 32 bit reference identifier assigned by Yahoo! to identify any feature on Earth. In simple terms, the number points a location in the world, for Example WOEID for Jakarta is 1047378, Bandung is 1047180 and Surabaya is 1044316. Every place in the world has it's own WOEID.

WOEID mainly used on Yahoo Weather, however by the time goes, many people use it on their applications. Twitter for example, they use WOEID on their Trending Topics result, since each location on earth had different Topics to discuss.

I'm not an expert on geospatial things or other related to WOEID, just working on small twitter application that turned out needs WOEID when fetching Trending Topics.

So, If you need WOEID, here is the place to look for it:
1. WOEID for worldwide is always "1"
2. You can visit http://woeid.rosselliot.co.nz
3. You can also extract the WOEID in the URL after searching for a city on Yahoo Weather.

Hope this helps someone :)

Installing OpenOffice on Ubuntu 12.04

Ubuntu 12.04 use LibreOffice as it's default office application, it's a great application, and I use it often, but sometimes you found bugs that cannot be tricked and the only way is to use other office application.

In my case, I receive an Microsoft Excell File in .xlsx format and when I open it, comments are all over the place. I search and search on google for solution, however none of them is one click solution on LibreOffice.

So I need to install another alternatives, and OpenOffice is the best alternate. Now, since it's not a default application, you cannot find it Ubuntu Software Center by default. So after googling a while, here is the simplest way to do it. This was taken from: http://askubuntu.com/questions/116590/how-do-i-install-openoffice-org-instead-of-libreoffice

sudo add-apt-repository ppa:upubuntu-com/office 
sudo apt-get update
sudo apt-get install openoffice

Cheers...

Batch Image Processing: XnView

Who doesn't know IrfanView on Windows? For me IrvanView is an application that saves me on numerous occasion when using simple image editing on Photoshop or Gimp is totally Time Consuming and not worth the purpose.

I'm not saying Photoshop or Gimp is awful image processing, it's just there are certain circumstances that using both application is too much for simple, but massive processing.

Here is for example. Every week, I receive hundreds of images of transaction need to be processed with certain settings, some are:
1. Put watermark image on every single image
2. Reduce the dpi down to 80% to prevent people print them on high resolution.

Rather than using full-featured (not to mention need high computer spec) application like Photoshop and Gimp, I'm looking as simple as possible application that can do what I wanted.

On Windows, I found IrfanView, but on Linux, I just found XnView.

XnView is a multi platform free application, which means, it available on Windows, Mac OS X and Linux.

I'm not a geek, just common people converting from Windows to Linux, I use Ubuntu 12.04 LTS that never been updated since first install, I'm the type of person that "Don't fix things that did not broken" :D

Struggling finding replacement for IrfanView on Linux, I found XnView mentioned on few forums and struggling installing it.

But then, I read on ubuntu forum archive a simple way to install it. Here is the link: http://ubuntuforums.org/archive/index.php/t-1919820.html

Here is how to install it via command line:
sudo add-apt-repository ppa:dhor/myway
sudo apt-get update
sudo apt-get install xnview

After install it, you can find the application on the Application List or just type xnview on the command line.

Try it, but don't ask me to help you troubleshoot, I'm as clueless as you in terms of troubleshooting, I'm just a common people pretending to be a geek :P