Mini Mods - vbCoupons - offer money-off coupons for paid subscriptions

vbCoupons v1.4

About this mod:

This hack allows the user to input a coupon code that deducts the value of it from the subscription costs before they go to pay for a subscription.

For example:
1. You advertise for new members and have and advert saying 'Join before the end of April and get 40% off the first month! Just register and enter coupon code OFFER1"
2. In Admincp -> vbCoupons you configure a coupon called OFFER1 with value of 40, and set a date for the validity of the coupon.
3. User registers, and enters coupon code OFFER1 on the payments.php page. The page updates the normal subscription prices to reflect the offer. Then they go to pay for it.

Notes:

1. Since the offer code expires when you set it to, the users will not be able to renew with that coupon unless the subscription runs out before the coupon validity does; thus it's better to use short-validity coupons and constantly change them.
2. The value of the coupon in the Admin Panel is given as a monetary value, e.g. a coupon with value 3.50 will give $3.50 (?3.50; ?3.50, depending on currencies activated) off paid subscription before the user goes to pay for it.

Features:

* Manage Coupons: Singly Add/Edit/Delete; Mass-delete.
* Set coupon valid for particular subscription ID's.
* Limit use by date or times it can be used.
* Mass-Generate coupons for distribution.
* Generate coupon discount codes and post to a new thread in a specified forum. A message may be sent with the codes. You can decide the thread title too.
* Input on features you would like to see for this hack is very welcome, but may not be possible to implement.

Time to install: 5 mins

UPGRADING: Do NOT choose 'yes' to overwrite an old xml or you will get an error!

Updates:

Version 1.0 (22nd March 2008):

* Release of this hack for vBulletin version 3.6.8
* This version should work on all vBulletin versions from 3.5.4 and up

Version 1.1 (25th March 2008):

* Fixed missing phrase
* Fixed non-functioning template call

Version 1.2 +1.3 (30th March 2008):

* Added coupon generator to this version
* Added ability to limit coupons to only be valid for a particular paid subscription.

Version 1.4 (14th April 2008):

* Generate coupons and post to thread
* Coupons can be limited to one or more subscriptionids
* MONETARY VALUES RATHER THAN PERCENTAGES ARE USED FROM NOW ON


MAKE SURE YOU CLICK INSTALL!
If you like this hack and use it then

Pictures (attached):

1. User (payments.php): Normal view before user adds a coupon that you configured in the admincp.
2. User (payments.php): View after the user adds a coupon to their account, with the new prices reflecting it.
3. Admin: Manage Existing Coupons
4. Admin: Add a single coupon discount code
5. Admin: Mass-generate coupons
6. Admin: Mass-generate coupons and post to a new thread
7. User: Thread view of mass-generated and posted coupon discount codes

[ringleader]

Originally Posted by Martin-TMGRS

Yep that file is there

Try the xml attached to this post.
Upload it to /includes/xml/cpnav_vbcoupons.xml
Refresh the admincp.
Does it show now?

[Martin-TMGRS]

Originally Posted by ringleader

Try the xml attached to this post.
Upload it to /includes/xml/cpnav_vbcoupons.xml
Refresh the admincp.
Does it show now?

Yes thats done the trick....Thanks

[ringleader]

Originally Posted by Martin-TMGRS

Yes thats done the trick....Thanks

Phew!
Thanks for asking - it's better for me to have you solve the problem than not use the mod at all!

Enjoy

[ringleader]

Version 1.4 is out now.

This changes the percentages preveiously used as discounts to monetary values, e.g. $3.50 instead of 20% as previously used.

You can also now mass-generate coupon codes and post them to a thread in a forum of your choice.

Coupons can now be restricted to one or more subscriptionids.

It is recommended that you upgrade to this version.

[DssCrazy]

NICE FREAKIN WORK!!!! This is a Wicked update i tested and does work on 3.6.8

I found 1 problem with this tho when clicking over write for the XML you get a database error.

Thanks for adding the idea to post coupon codes

[ringleader]

Originally Posted by DssCrazy

I found 1 problem with this tho when clicking over write for the XML you get a database error.

Dammit, I even tried overwrote my own and tested that like 10 times and it seemed fine.
Bloody SQL
I'll try to fix it in the morning - i've to be up for my day job in about 6 hours!

Thanks though, man
Glad you like it.

[PyroNET]

Installed Thank you very much for this.

[ringleader]

Originally Posted by PyroNET

Installed Thank you very much for this.

Glad you like it



If UPGRADING this product, choose 'No' for 'Allow Overwrite' when importing the new product in the adminCP. You will get an error if you choose to overwrite.

[bada_bing]

Just tried to upgrade to version 1.4 with no override and reveived this error

Database error in vBulletin 3.6.9:

Invalid SQL:

ALTER TABLE `vb_user` ADD (couponid int(10) UNSIGNED NOT NULL DEFAULT '0');

MySQL Error  : Duplicate column name 'couponid'
Error Number : 1060
Date         : Tuesday, April 15th 2008 @ 01:47:39 PM
Script       : http://www.mysite.com/forums/admincp/plugin.php?do=productimport
Referrer     : http://www.mysite.com/forums/admincp/plugin.php?do=productadd
IP Address   : x.x.x.x
Username     : myusername
Classname    : vb_database

[DssCrazy]

Originally Posted by bada_bing

Just tried to upgrade to version 1.4 with no override and reveived this error

Database error in vBulletin 3.6.9:

Invalid SQL:

ALTER TABLE `vb_user` ADD (couponid int(10) UNSIGNED NOT NULL DEFAULT '0');

MySQL Error  : Duplicate column name 'couponid'
Error Number : 1060
Date         : Tuesday, April 15th 2008 @ 01:47:39 PM
Script       : http://www.mysite.com/forums/admincp/plugin.php?do=productimport
Referrer     : http://www.mysite.com/forums/admincp/plugin.php?do=productadd
IP Address   : x.x.x.x
Username     : myusername
Classname    : vb_database

Yes, please uninstall the old version on your vb board and reup the new.