Miscellaneous Hacks - Gift Subscriptions

Looks like there was a huge need for a gift subscription hack, so I created one, attached. It allows users to extend or purchase board subscriptions for other users.

This has been implemented and tested on our boards, but it is in EARLY ALPHA! Please provide me with feedback/questions after you implement it.

Should take about 15 minutes to complete.

1. Create 1 plugin
2. Modify 2 templates
3. modify 1 script (payments.php) -- PLEASE backup and save your old script for upgrade purposes.

Let me know how it goes!
~ Jennifer

[ringleader]

I wouldn't have even noticed. And my members are dumb enough to do this.

Find in payments.php:

Instead of (as provided)

    //=== HACK: GIFT SUBSCRIPTIONS ===//
    if ($_POST['giftname']!=$vbulletin->userinfo['username']) {
	 $goo=$db->query_read_slave("SELECT userid from ". TABLE_PREFIX ."user where username='".$_POST['giftname']."'");
       while ($giftee = $db->fetch_array($goo)) 
		{ $subid=$giftee['userid']; }
    }
    else { 
    	$subid=$vbulletin->userinfo['userid']; 
    }
    //=== HACK: GIFT SUBSCRIPTIONS ===//

Use this code that checks the member name and includes an error message

("Invalid recipient username. Please press the back button, enter the correct username and try again. <u>Click Here to See the Members List</u>"):

    //=== HACK: GIFT SUBSCRIPTIONS ===//
	if ($_POST['giftname'] != $vbulletin->userinfo['username']) 
	{
		$goo=$db->query_read_slave("SELECT userid from ". TABLE_PREFIX ."user where username='".$_POST['giftname']."'");

		if ($giftee = $db->fetch_array($goo)) 
		{ 
			$subid = $giftee['userid']; 
		}	
		else
		{
			eval(standard_error(fetch_error('pminvalidrecipient')));		
		}
	}
	else 
	{ 
    		$subid = $vbulletin->userinfo['userid']; 
	}
    //=== HACK: GIFT SUBSCRIPTIONS ===//

[Terrie]

I notice after upgrading to 3.6.9 the upgrade gets added to the person
buying the gift subscription as opposed to the person who should be
receiving the gift.

[Terrie]

Woops... Nevermind it seems payments.php got overwritten during the upgrade.
I had to reinsert the hacks back in.

[cookiepants]

Okay, total newbie question, but how do I create a plug in for this?

[cookiepants]

oh never mind -- it's in the Plug in section of the Admin area.

[Terrie]

In case anyone was wondering this hack works great in 3.7 RC4 :up:

[DieselMinded]

Diesel this work on 3.7.4 ?

[CSS59]

3.8.3?

[Avimelech]

I tried inserting this into the brand new 3.8.4 and got an error message when I tried to execute a paid subscription, saying:

Database error in vBulletin 3.8.4:

Invalid SQL:

INSERT INTO paymentinfo
(hash, completed, subscriptionid, subscriptionsubid, userid)
VALUES
('0d336f6ad3eff6f2f898922e6eaeec2b', 0, 1, 1, );

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4
Error Number : 1064
Request Date : Wednesday, August 12th 2009 @ 12:33:06 PM
Error Date : Wednesday, August 12th 2009 @ 12:33:06 PM
Script : http://forums.escapeallthesethings.c...s.php?do=order
Referrer : http://forums.escapeallthesethings.com/payments.php
IP Address : 190.241.15.100
Classname : vB_Database
MySQL Version : 5.0.67-log

I am attaching my payments.php in case anyone can see if I did it wrong

[Shamil.]

Originally Posted by Avimelech

I tried inserting this into the brand new 3.8.4 and got an error message when I tried to execute a paid subscription, saying:

Database error in vBulletin 3.8.4:

Invalid SQL:

INSERT INTO paymentinfo
(hash, completed, subscriptionid, subscriptionsubid, userid)
VALUES
('0d336f6ad3eff6f2f898922e6eaeec2b', 0, 1, 1, );

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4
Error Number : 1064
Request Date : Wednesday, August 12th 2009 @ 12:33:06 PM
Error Date : Wednesday, August 12th 2009 @ 12:33:06 PM
Script : http://forums.escapeallthesethings.c...s.php?do=order
Referrer : http://forums.escapeallthesethings.com/payments.php
IP Address : 190.241.15.100
Classname : vB_Database
MySQL Version : 5.0.67-log

I am attaching my payments.php in case anyone can see if I did it wrong

In that SQL, there userid is missing. This plugin was built for 3.6, you're on 3.8, I'd imagine that something has changed between the versions.