Do you want to encourage users to engage with your Joomla site by offering them reward points they can redeem on downloadable files from your site?
First you will need JomSocial. A wonderful tool to convert your joomla site into a community site. If you haven't already, you will want to download and install JomSocial. http://www.jomsocial.com
UPDATE - May 2012
Turns out my original open source solution was a little too complex for most users.
Here is the NEW quick and EASY solution
I found a vender Joomseller who sell an excellent File Seller Joomla component and I hired their developer to create a plug-in that will allow you to sell your files using Jomsocial points.
It's very easy and works beautifully. Plus you can give your members the option to buy the item with Paypal, 2CheckOut or Moneybookers if they do not have enough jomsocial points.
This is what you'll need:
- Purchase Files Seller - Document Seller from JoomSeller (It costs about $45 USD depending on exchange rate)
They were nice enough to give me a 20% discount code you can use - GAVICK20
- Purchase my JomSocial Points Payment Plug-in for File Seller for $10 USD
Note: I'm trying to reimburse all my expenses for hiring them to develop the plug-in for me.
That's it! You do not need to install alphapoints or JDownloads or know how to create a database trigger. If you want more of a challenge then you can read my older solution below.
As of Feb 2012, I could not find any tools that allow your users to redeem downloads from their JomSocial Points therefore you need to install the AlphaUser Points plug-in from Alphabug and use it in conjunction with Jomsocial Points.
Purchased and install the jomsocial integration pieces:
- Sync JomSocial with Alphapoints. Alphapoints will not automatically sync with your jomsocial points. You need to write a database trigger that every time the alpha user points table is updated it will update your jomsocial user points table.
CREATE TRIGGER SyncJSAP_Trigger
AFTER UPDATE ON jos_alpha_userpoints
FOR EACH ROW
SET points = NEW.points
WHERE userid = NEW.userid;
Don't forget in Jomsocial you will need to unpublish all your userpoint rules in order to prevent them from conflicting with the alphauser points
Now you should have JomSocial and AlphaPoints working together. You are halfway there. Next you need to install an e-commerce paid downloads. The only one I could find is jDownloads and the best part is it’s free :)
You will need to install the following component:
And the following plugins:
There is a tutorial for integrating AlphUserPoints and JDownloads available here: http://www.jdownloads.com/index.php?option=com_content&view=article&id=111&Itemid=139
Hopefully I saved you hours of hair pulling. Best of luck on your Joomla Site!