[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

There is no zip...:confused:

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

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

Nice idea, Dean ...

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

@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).

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

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]

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

Thanks alot

Jeff