vb.org Archive - [HTL] & [TXT] One-Time & Free Subscriptions

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)

- - [HTL] & [TXT] One-Time & Free Subscriptions (https://vborg.vbsupport.ru/showthread.php?t=61575)

Andreas

02-14-2004 10:00 PM

[HTL] & [TXT] One-Time & Free Subscriptions

One-Time & Free Subscriptions
Version: 0.1
vB-version: 3.0.0 Release Candidate 2
Developer: Kirby
Install difficulty: Easy
File edits: 4
Template edits: 0

Description of the Hack:
This Hack allows you to create One-Time subscriptions which can be purchased only once.
It also allows you to have free subscriptions - when a user orders such a subscription he will be subscribed instantly.

HACK INSTALLATION DETAILS:
Files modified for this Hack:
admincp/subscriptions (1)
includes/functions_subscriptions.php (1)
subscriptions.php (2)

Details on how to install this manually are in the ZIP.

DB Tables modified for this Hack:
subscription

New DB columns for this Hack:
onetime

This post was generated by the Hack Tracking Log

drumsy

02-15-2004 02:52 AM

There is no zip...:confused:

Andreas

02-15-2004 03:03 AM

Now there is. Didn't work at first - keeps saying "in progress"

Dean C

02-15-2004 08:09 AM

Nice to see people expanding on the system. How about buy one subscription get one free offers and such :)?

gmarik

02-15-2004 10:48 AM

Nice idea, Dean ...

gc1	02-15-2004 03:51 PM

Dean, I am kinda green, I don't understand the instructions well and I don't know how to install this hack with xml files.

Give me a nudge and I will send you a small gift via PayPal since this was a hack I have requested.

GC

Andreas

02-15-2004 07:31 PM

@gc1
You don't need the XML file if you don't use HTL (Hack Tracking Log).
Just follow the instrustions for manual installation (file otfsubs.txt in the ZIP).

gc1	02-16-2004 12:20 AM

Anybody wanna tackle this and tell me what I am doing wrong?

Invalid SQL:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO subscription
(subscriptionid, title, description, active, onetime, length, units, cost, nusergroupid, membergroupids, forums)
VALUES
(NULL, 'bbb', '', '1', '1', '1', 'W', 'a:3:{s:3:\"usd\";s:4:\"0.00\";s:3:\"gbp\";s:4:\"0 .00\";s:3:\"eur\";s:4:\"0.00\";}', '-1', '', 'N;')
mysql error: Unknown column 'onetime' in 'field list'

mysql error number: 1054

Date: Sunday 15th of February 2004 06:19:50 PM
Script: http://www.xxxxxxxxx.com/trucking/up...scriptions.php
Referer: http://www.xxxxxxxx.com/trucking/upl...ons.php?do=add

Andreas

02-16-2004 12:46 AM

Can a person be that dumb like me? I've got an error in the TXT, should be onetime and not foobar in the query :ermm:

Run the following query, this should fix the problem:

[SQL]
ALTER TABLE subscription CHANGE foobar onetime TINYINT( 1 ) DEFAULT '0' NOT NULL
[/SQL]

gc1	02-16-2004 12:55 AM

Quote:

Originally Posted by KirbyDE

Thank you very much, if you have PayPal I will send you a small donation for your effort.

Thanks alot

Jeff

memdy

02-21-2005 02:28 AM

I can't run the last two steps, becuase I can't FIND the code sections in my subscriptions.php .... vBulletin version 3.03 Any hints on where these might go in subscriptions.php ?

Code:

File subscriptions.php

   FIND

   // first check this is active if not die

   if (!$subscriptioncache["$subscriptionid"]['active'])

   {

        $idname = $vbphrase['subscription'];

        eval(print_standard_error('error_invalidid'));

   }



   BELOW that ADD

   if ($subscriptioncache["$subscriptionid"]['onetime']) {

     // Check if user has already purchased this subscription

     $usersub = $DB_site->query_first("SELECT regdate FROM " . TABLE_PREFIX . "subscriptionlog WHERE subscriptionid=$subscriptionid AND userid=$bbuserinfo[userid]");

     if ($usersub[regdate])

       eval(print_standard_error('onetime_subscription'));

   }



**************************************



FIND

   $costs = unserialize($sub['cost']);

   $subscription_title = $sub['title'];



   BELOW that ADD

   if (($costs[usd] == '0.00') AND ($costs[gbp] == '0.00') AND ($costs[eur] == '0.00')) {

     build_user_subscription($subscriptionid, $bbuserinfo[userid]);

     eval(print_standard_error('freesubscription_thankyou'));

   }

rjordan

03-27-2005 02:56 PM

I know it has been a month since your question, but are you looking at subscription.php or subscriptions.php? You should be looking at the latter.

rjordan

03-27-2005 05:21 PM

An addition to this would be to display FREE in the cost drop-down instead of being blank. This can be done with the following:

In ./subscriptions.php, find:

PHP Code:


		
			
 $subscription['cost'] = $string;

and above this:

PHP Code:


		
			
 if ($string == '')
            {
    $string .= "<option value=\"\" >FREE</option>\n";
            }

Save and upload.

This works for me on 3.0.7. Thanks for this modification!

All times are GMT. The time now is 04:31 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01055 seconds Memory Usage 1,744KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (13)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: