Files
Testing/include/class_subscriber.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

943 lines
35 KiB
PHP

<?php
$plan_periodtypes = array( 0 => array( 'id' => 0, 's' => 'D', 'f' => 100014039, 'p' => 'day', 'max' => 90 ),
1 => array( 'id' => 1, 's' => 'W', 'f' => 100014040, 'p' => 'week', 'max' => 52 ),
2 => array( 'id' => 2, 's' => 'M', 'f' => 100014041, 'p' => 'month', 'max' => 12 ),
3 => array( 'id' => 3, 's' => 'Y', 'f' => 100014042, 'p' => 'year', 'max' => 1 ),
4 => array( 'id' => 4, 's' => 'L', 'f' => 100014046, 'p' => 'Lifetime', 'max' => 0 )
);
/*
* userplan_state
* 0 - active
* 1 - active_trial
* 2 - expired
* 3 - cancelled
* 4 - suspended(?)
* 5 - created - waiting for payment confirmation
* 6 - future??? - subscribed but not yet activated, when previous plan is still active and "downgrading" plan
* 7 - suspended - failed payment
*
*/
$userplan_states = array( 0 => 100014047,
1 => 100014048,
2 => 100014049,
3 => 100014050,
4 => 100014051,
5 => 100014052,
7 => 100014053,
);
class semods_plan {
var $plan_exists = 0;
var $plan_info = array();
var $userplan = null;
var $user_id = null;
var $plan_id = null;
function __construct( $plan_id, $user_id = null ) {
global $plan_periodtypes;
$plan_id = intval($plan_id);
$this->plan_id=$plan_id;
$user_id = intval($user_id);
$this->user_id = $user_id;
$this->plan_info = semods::db_query_assoc("SELECT * FROM se_semods_plans WHERE plan_id = $plan_id");
if($this->plan_info) {
$this->plan_exists = 1;
$this->plan_info['plan_trialperiodtypetext'] = $plan_periodtypes[ $this->plan_info['plan_trialperiodtype'] ]['f'];
$this->plan_info['plan_periodtypetext'] = $plan_periodtypes[ $this->plan_info['plan_periodtype'] ]['f'];
// CONVERT HTML CHARACTERS BACK
$this->plan_info['plan_description'] = str_replace("\r\n", "", html_entity_decode( $this->plan_info['plan_description'] ));
SE_Language::_preload_multi( $this->plan_info['plan_trialperiodtypetext'], $this->plan_info['plan_periodtypetext'] );
if(!is_null($user_id)) {
$this->userplan = new semods_userplan( 0, $user_id, $this->plan_info['plan_id'] );
}
}
else
{
//mail("leprakhauns@gmail.com", "Recurring not appearing", "User: ".$user_id." Subscription: ".$plan_id);
}
}
function upgrade1() {
global $database;
// UPDATE USER LEVEL, UNLESS "NO LEVEL"
if($this->plan_id != 0) {
$database->database_query( "UPDATE se_users SET user_level_id = 2 WHERE user_id = {$this->user_id} " );
}
else{mail("leprakhauns@gmail.com", "DDD", var_export($this, true));}
}
function plan_subscribe( $user_id, $handler_id, $metadata = array(), $has_trial = true, $biller="" ) {
global $database, $plan_periodtypes, $functions_subscriber;
if($this->plan_info['plan_id']==4&&$_SERVER["PHP_SELF"]!="/signup.php"&&$_SERVER["PHP_SELF"]!="/7-day-trial.php")
{
mail("leprakhauns@gmail.com", "Userjust subbed to 7 Day Trial", $_SERVER["PHP_SELF"]."?".$_SERVER["QUERY_STRING"]."
".$user_id);
}
/*
* 1. Create or extend user plan
* Extending works by adding plan's period to current time
*
* 2. Set associated user level
*
*/
$now = time();
$this->user_id = $user_id;
// Check for plan in the same category and silently cancel it
//$userplan = new semods_userplan( null, $user_id, null, $this->plan_info['plan_category'] );
// Check for plan - now only one plan per user
$userplan = new semods_userplan( null, $user_id );
if($userplan->userplan_exists) {
$userplan->cancel_plan( 1, 1 );
$userplan->delete_plan();
}
// NEW PLAN SUBSCRIPTION
// IF TRIAL PERIOD, SET EXPIRATION TO END OF TRIAL PERIOD, OTHERWISE,
// NOT -> END OF SUBSCRIPTION PERIOD
// +1H ? same day, plan_extend will extend the period after payment confirmed?
if($this->is_lifetime_plan()) {
$expiration_date = 0; // never
$userplan_state = 0; // active
} elseif($this->is_free_plan()) {
$extension_period = "+{$this->plan_info['plan_period']} " . $plan_periodtypes[ $this->plan_info['plan_periodtype'] ]['p'];
$expiration_date = strtotime( $extension_period, $now );
$userplan_state = 0; // active
} else {
if( !$has_trial || ($this->plan_info['plan_trialperiod'] == 0) ) {
$expiration_date = $now + 3600;
$userplan_state = 0; // active
} else {
// TBD: doG! convert periods to seconds
// there will be no "payment" notifications
if($this->plan_info['plan_trialperiodprice'] == 0) {
$extension_period = "+{$this->plan_info['plan_trialperiod']} " . $plan_periodtypes[ $this->plan_info['plan_trialperiodtype'] ]['p'];
$expiration_date = strtotime( $extension_period, $now );
}
else {
$expiration_date = $now + 3600;
}
$userplan_state = 0; // active_trial
mail("leprakhauns@gmail.com", "TRIAL?!?", var_export($this, true));
}
}
$cascading=$_GET["cascading"];
if($cascading!=1){$cascading=0;}
$userplan_field1 = semods::g( $metadata, 'field1', '' );
$userplan_field2 = semods::g( $metadata, 'field2', '' );
$userplan_metadata = serialize($metadata);
// CREATE USER PLAN
$database->database_query( "INSERT INTO se_semods_userplans(
userplan_user_id,
userplan_plan_id,
userplan_startdate,
userplan_expiredate,
userplan_state,
userplan_handler,
userplan_metadata,
userplan_field1,
userplan_field2, biller, cascading)
VALUES (
$user_id,
{$this->plan_info['plan_id']},
$now,
$expiration_date,
$userplan_state,
$handler_id,
'$userplan_metadata',
'$userplan_field1',
'$userplan_field2',
'$biller',
'$cascading'
)
");
/*mail("leprakhauns@gmail.com", "SQL for Userplan", "INSERT INTO se_semods_userplans(
userplan_user_id,
userplan_plan_id,
userplan_startdate,
userplan_expiredate,
userplan_state,
userplan_handler,
userplan_metadata,
userplan_field1,
userplan_field2, biller, cascading)
VALUES (
$user_id,
{$this->plan_info['plan_id']},
$now,
$expiration_date,
$userplan_state,
$handler_id,
'$userplan_metadata',
'$userplan_field1',
'$userplan_field2',
'$biller',
'$cascading'
)");*/
$newplan_id = $database->database_insert_id();
// UPDATE USER LEVEL, UNLESS "NO LEVEL"
if($this->plan_info['plan_level_id'] != 0) {
$database->database_query( "UPDATE se_users SET user_level_id = {$this->plan_info['plan_level_id']} WHERE user_id = $user_id " );
//mail("leprakhauns@gmail.com", "SQL for User", "UPDATE se_users SET user_level_id = {$this->plan_info['plan_level_id']} WHERE user_id = $user_id");
}
subscriber_log_activity ( $user_id,
100014072,
100,
array( '[plan_name]' => $this->plan_info['plan_name'],
'[plan_id]' => $this->plan_info['plan_id']
)
);
subscriber_email_subscription_created( $user_id, $this->plan_info );
return new semods_userplan( $newplan_id );
}
// this actually should be method of semods_userplan
function plan_extend( ) {
// Extending / continuing plan
if($this->userplan && $this->userplan->userplan_exists) {
$this->userplan->extend_plan();
}else{ mail("leprakhauns@gmail.com", "Recurring not appearing2", "User: ".$user_id." Subscription: ".$plan_id);
}
}
function is_free_plan() {
return (($this->plan_info['plan_price'] == 0) && ($this->plan_info['plan_onetime_price'] == 0));
}
function is_lifetime_plan() {
return ($this->plan_info['plan_periodtype'] == 4);
}
function enable($enabled) {
global $database;
// TBD: what to do with guys with active plan
if($this->plan_exists == 1)
$database->database_query("UPDATE se_semods_plans SET plan_enabled = $enabled WHERE plan_id = {$this->plan_info['plan_id']}");
}
function delete() {
global $database;
// TBD: what to do with guys with active plan
if($this->plan_exists == 1)
$database->database_query("DELETE FROM se_semods_plans WHERE plan_id = {$this->plan_info['plan_id']}");
}
function total_users() {
return semods::db_query_count("SELECT COUNT(*) FROM se_semods_userplans WHERE userplan_plan_id = {$this->plan_info['plan_id']} ");
}
function total_active_users() {
return semods::db_query_count("SELECT COUNT(*) FROM se_semods_userplans WHERE userplan_plan_id = {$this->plan_info['plan_id']} AND userplan_state IN(0,1,3,4,5,7)");
}
function total_managed_users() {
return semods::db_query_count("SELECT COUNT(*) FROM se_semods_userplans WHERE userplan_plan_id = {$this->plan_info['plan_id']} AND userplan_state IN(0,1,3,4,5,7) AND userplan_handler != 0");
}
function add_to_cart( &$cart, $user_id, $allow_trial = true) {
global $functions_subscriber;
$shortdesc = '';
$currency_code = semods::get_setting('payment_currency');
// lifetime period
if($this->plan_info['plan_periodtype'] == 4 ) {
$cart_item = new semods_subscription_onetime_cartitem( $this->plan_info['plan_name'],
$this->plan_info['plan_id'],
$this->plan_info['plan_price'],
array( 'uid' => $user_id,
'pid' => $this->plan_info['plan_id'] )
);
$cart_item->set_user_id( $user_id );
} else {
// IF TRIAL PERIOD, THE SHOWN PRICE IS ZERO
if(($allow_trial) && ($this->plan_info['plan_trialperiod'] != 0)) {
$price = 0;
} else {
$price = $this->plan_info['plan_price'];
}
if($this->plan_info['plan_onetime_price'] > 0) {
$price += $this->plan_info['plan_onetime_price'];
}
$cart_item = new semods_subscription_cartitem( $this->plan_info['plan_name'],
$this->plan_info['plan_id'],
$price,
array( 'uid' => $user_id,
'pid' => $this->plan_info['plan_id'] )
);
$cart_item->set_user_id( $user_id );
// Trial
if(($allow_trial) && ($this->plan_info['plan_trialperiod'] != 0)){
$cart_item->add_trial_period( $this->plan_info['plan_trialperiodprice'],
$this->plan_info['plan_trialperiod'],
$this->plan_info['plan_trialperiodtype'] );
$shortdesc = sprintf( semods::get_language_text( 100014062 ), $this->plan_info['plan_trialperiod'], semods::get_language_text( $this->plan_info['plan_trialperiodtypetext'] ) );
}
// plan_onetime_price - initial price
if( $this->plan_info['plan_onetime_price'] > 0 ) {
$cart_item->set_initial_price( $this->plan_info['plan_onetime_price'] );
$shortdesc .= sprintf( semods::get_language_text( 100014060 ),
$currency_code,
$this->plan_info['plan_onetime_price'],
$currency_code,
$this->plan_info['plan_price'],
$this->plan_info['plan_period'],
semods::get_language_text( $this->plan_info['plan_periodtypetext'] )
);
} else {
$shortdesc .= sprintf( semods::get_language_text( 100014061 ),
$currency_code,
$this->plan_info['plan_price'],
$this->plan_info['plan_period'],
semods::get_language_text( $this->plan_info['plan_periodtypetext'] )
);
}
$cart_item->add_period( $this->plan_info['plan_price'],
$this->plan_info['plan_period'],
$this->plan_info['plan_periodtype'],
$this->plan_info['plan_recurring'],
$this->plan_info['plan_recurring_cycles'] );
$cart_item->set_short_description( $shortdesc );
}
$cart->add_item( $cart_item );
}
}
class semods_userplan {
var $userplan_exists = 0;
var $userplan_info = array();
function __construct( $userplan_id, $user_id = null, $plan_id = null, $plan_cat = null, $plan_field1 = null , $plan_field2 = null ) {
global $plan_periodtypes, $userplan_states;
if(!is_null($user_id)) {
if(!is_null($plan_id)) {
$this->userplan_info = semods::db_query_assoc("SELECT *
FROM se_semods_userplans UP
LEFT JOIN se_semods_plans P
ON UP.userplan_plan_id = P.plan_id
WHERE userplan_user_id = $user_id AND userplan_plan_id = $plan_id
");
} else if(!is_null($plan_cat)) {
$this->userplan_info = semods::db_query_assoc("SELECT *
FROM se_semods_userplans UP
LEFT JOIN se_semods_plans P
ON UP.userplan_plan_id = P.plan_id
WHERE userplan_user_id = $user_id AND plan_category = $plan_cat
");
} else if(!empty($userplan_id)) {
$this->userplan_info = semods::db_query_assoc("SELECT *
FROM se_semods_userplans UP
LEFT JOIN se_semods_plans P
ON UP.userplan_plan_id = P.plan_id
WHERE userplan_user_id = $user_id AND userplan_id = $userplan_id
");
} else {
$this->userplan_info = semods::db_query_assoc("SELECT *
FROM se_semods_userplans UP
LEFT JOIN se_semods_plans P
ON UP.userplan_plan_id = P.plan_id
WHERE userplan_user_id = $user_id
");
}
} elseif(!is_null($plan_field1)) {
$this->userplan_info = semods::db_query_assoc("SELECT *
FROM se_semods_userplans UP
LEFT JOIN se_semods_plans P
ON UP.userplan_plan_id = P.plan_id
WHERE userplan_field1 = '$plan_field1'
");
} elseif(!is_null($plan_field2)) {
$this->userplan_info = semods::db_query_assoc("SELECT *
FROM se_semods_userplans UP
LEFT JOIN se_semods_plans P
ON UP.userplan_plan_id = P.plan_id
WHERE userplan_field2 = '$plan_field2'
");
} else {
$this->userplan_info = semods::db_query_assoc("SELECT *
FROM se_semods_userplans UP
LEFT JOIN se_semods_plans P
ON UP.userplan_plan_id = P.plan_id
WHERE userplan_id = $userplan_id
");
}
if($this->userplan_info) {
$this->userplan_exists = 1;
$this->userplan_info['plan_trialperiodtypetext'] = $plan_periodtypes[ $this->userplan_info['plan_trialperiodtype'] ]['f'];
$this->userplan_info['plan_periodtypetext'] = $plan_periodtypes[ $this->userplan_info['plan_periodtype'] ]['f'];
$this->userplan_info['userplan_statetext'] = $userplan_states[ $this->userplan_info['userplan_state'] ];
// CONVERT HTML CHARACTERS BACK
$this->userplan_info['plan_description'] = str_replace("\r\n", "", html_entity_decode( $this->userplan_info['plan_description'] ));
SE_Language::_preload_multi( $this->userplan_info['plan_trialperiodtypetext'], $this->userplan_info['plan_periodtypetext'], $this->userplan_info['userplan_statetext'] );
}
}
function create_from_profile_reference( $profile_reference_id ) {
return new semods_userplan( null, null, null, null, null, $profile_reference_id );
}
// $period_type -
// 0 : regular
// 1 : trial
//
function extend_plan( $period_type = 0 ) {
global $database, $plan_periodtypes, $functions_subscriber;
/*
* 1. Extend user plan
* Extending works by adding plan's period to current time if plan was cancelled / expired
* or adding adding plan's period to userplan_expiredate
*
*/
$now = time();
// regular
if($period_type == 0) {
$extension_period = "+{$this->userplan_info['plan_period']} " . $plan_periodtypes[ $this->userplan_info['plan_periodtype'] ]['p'];
$plan_state = 0; // active
} else {
// trial
$extension_period = "+{$this->userplan_info['plan_trialperiod']} " . $plan_periodtypes[ $this->userplan_info['plan_trialperiodtype'] ]['p'];
$plan_state = 1; // active_trial
}
// UPDATE USER PLAN
// If not
// 0 - active
// 1 - active_trial - (expired, cancelled, etc) - refresh start date
// 5 - created - waiting for payment confirmation
if(!in_array( intval($this->userplan_info['userplan_state']), array(0,1,5) )) {
$expiration_date = strtotime( $extension_period, $now );
$database->database_query( "UPDATE se_semods_userplans SET
userplan_startdate = $now,
userplan_state = $plan_state,
userplan_expiredate = $expiration_date
WHERE userplan_id = {$this->userplan_info['userplan_id']}
");
} else {
// if plan is expired and receive payment - extend, but start date not changed? - this may happen if payment was failed but profile is still active
$expiration_date = strtotime( $extension_period, $this->userplan_info['userplan_expiredate'] );
$database->database_query( "UPDATE se_semods_userplans SET
userplan_state = $plan_state,
userplan_expiredate = $expiration_date
WHERE userplan_id = {$this->userplan_info['userplan_id']}
");
}
//upgrade;
subscriber_log_activity ( $this->userplan_info['userplan_user_id'],
100014075,
103,
array( '[plan_name]' => $this->userplan_info['plan_name'],
'[plan_id]' => $this->userplan_info['plan_id']
)
);
subscriber_email_subscription_renewed( $this->userplan_info['userplan_user_id'], $this->userplan_info );
}
function cancel_plan( $fast = 0, $silent = 0, $remote_cancel = 0 ) {
global $database, $functions_subscriber;
// can cancel only when: active(0), active_trial(1), suspended(4), suspended_failed_payment(7), ? pending payment 5?
if($this->userplan_exists == false)
return false;
if(!in_array( $this->userplan_info['userplan_state'], array(0,1,4,7)))
return false;
// if silent -> don't notify user
// if fast & provider doesn't support fast_cancel -> queue in tasks
if($fast) {
$notify = intval(!$silent);
// Queue task
$database->database_query( "INSERT INTO se_semods_plantasks (
plantask_type,
plantask_metadata,
plantask_paymentgw,
plantask_notify
) VALUES (
'cancel_subscription',
'{$this->userplan_info['userplan_metadata']}',
{$this->userplan_info['userplan_handler']},
$notify)" );
} else {
if($remote_cancel == 0) {
if($this->userplan_info['userplan_handler'] != 0) {
$paymentgw = semods_paymengtw_factory( $this->userplan_info['userplan_handler'] );
// Log Error
if(!$paymentgw) {
subscriber_log_error( "Error cancelling plan - Failed instantiating Payment Handler (id={$this->userplan_info['userplan_handler']})", 1000, $this->userplan_info['userplan_user_id'] );
} else {
// TBD: check creation was ok
$result = $paymentgw->cancel_subscription( array( 'fast' => $fast, 'metadata' => $this->userplan_info['userplan_metadata'] ) );
// Log Error
if(!$result) {
subscriber_log_activity ( $this->userplan_info['userplan_user_id'],
100014079,
1001,
array( '[plan_name]' => $this->userplan_info['plan_name'],
'[plan_id]' => $this->userplan_info['plan_id'],
'[err_msg]' => $paymentgw->errMsg,
'[paymentgateway_name]' => $paymentgw->name,
)
);
// TODO
// email_notify_admin(error cancelling ? queue task? );
}
}
}
}
}
if($remote_cancel == 0) {
subscriber_log_activity ( $this->userplan_info['userplan_user_id'],
100014073,
101,
array( '[plan_name]' => $this->userplan_info['plan_name'],
'[plan_id]' => $this->userplan_info['plan_id']
)
);
} else {
subscriber_log_activity ( $this->userplan_info['userplan_user_id'],
100014078,
101,
array( '[plan_name]' => $this->userplan_info['plan_name'],
'[plan_id]' => $this->userplan_info['plan_id']
)
);
}
// if(!$silent) {
subscriber_email_subscription_cancelled( $this->userplan_info['userplan_user_id'], $this->userplan_info );
// }
// Update status, though plan may not have been fully cancelled yet
$database->database_query("UPDATE se_semods_userplans SET userplan_state = 3, userplan_handler = 0 WHERE userplan_id = {$this->userplan_info['userplan_id']}");
}
function change_state( $new_state ) {
global $database;
// Same state?
if($this->userplan_info['userplan_state'] == $new_state)
return;
// Update status, though plan may not have been fully cancelled yet
$database->database_query("UPDATE se_semods_userplans SET userplan_state = $new_state WHERE userplan_id = {$this->userplan_info['userplan_id']}");
/*
* userplan_state
* 0 - active
* 1 - active_trial
* 2 - expired
* 3 - cancelled
* 4 - suspended(?)
* 5 - created - waiting for payment confirmation
* 6 - future??? - subscribed but not yet activated, when previous plan is still active and "downgrading" plan
* 7 - suspended - failed payment
*
*/
switch($new_state) {
case 2:
case 3:
case 4:
case 7:
$this->downgrade();
break;
case 0:
case 1:
case 5:
$this->upgrade();
break;
}
}
function expire_plan( ) {
global $database, $functions_subscriber;
// can expire only when: active(0), active_trial(1), suspended(4), suspended_failed_payment(7), ? pending payment 5?
if(!in_array( $this->userplan_info['userplan_state'], array(0,1,4,7))){
return false;}
$paymentgw = semods_paymengtw_factory( $this->userplan_info['userplan_handler'] );
// Do we need this?
if($paymentgw) {
// TBD: check creation was ok
$result = $paymentgw->cancel_subscription( array( 'fast' => $fast, 'metadata' => $this->userplan_info['userplan_metadata'] ) );
if(!$result) {
// notify_admin_on_error
}
} else {
// error?
}
// Update status, though plan may not have been fully cancelled yet
$database->database_query("UPDATE se_semods_userplans SET userplan_state = 2 WHERE userplan_id = {$this->userplan_info['userplan_id']}");
$this->downgrade();
subscriber_log_activity ( $this->userplan_info['userplan_user_id'],
100014074,
102,
array( '[plan_name]' => $this->userplan_info['plan_name'],
'[plan_id]' => $this->userplan_info['plan_id']
)
);
subscriber_email_subscription_expired( $this->userplan_info['userplan_user_id'], $this->userplan_info );
$query= $database->database_query("SELECT * FROM se_users WHERE user_id='". $database->database_real_escape_string($this->userplan_info['userplan_user_id'])."'");
$row=$database->database_fetch_array($query);
if($row["verifiedmembershippending"]==1){
$plan = new semods_plan(7, $this->userplan_info['userplan_user_id']);
$plan->plan_subscribe($this->userplan_info['userplan_user_id'], 0, array('cc_id' => "Verified member promotion"), FALSE, 'CCBill');
$database->database_query("UPDATE se_users SET verifiedmembershippending=0 WHERE user_id='". $database->database_real_escape_string($this->userplan_info['userplan_user_id'])."'");
}
else{ $database->database_query("UPDATE se_users SET user_level_id=5 WHERE user_id='". $database->database_real_escape_string($this->userplan_info['userplan_user_id'])."'");}
}
function expire_plan1( ) {
global $database, $functions_subscriber;
// can expire only when: active(0), active_trial(1), suspended(4), suspended_failed_payment(7), ? pending payment 5?
echo $this->userplan_info['userplan_state'];
if(!in_array( $this->userplan_info['userplan_state'], array(0,1,4,7))){
return false;}
$paymentgw = semods_paymengtw_factory( $this->userplan_info['userplan_handler'] );
// Do we need this?
if($paymentgw) {
// TBD: check creation was ok
$result = $paymentgw->cancel_subscription( array( 'fast' => $fast, 'metadata' => $this->userplan_info['userplan_metadata'] ) );
if(!$result) {
// notify_admin_on_error
}
} else {
// error?
}
// Update status, though plan may not have been fully cancelled yet
$database->database_query("UPDATE se_semods_userplans SET userplan_state = 2 WHERE userplan_id = {$this->userplan_info['userplan_id']}");
$this->downgrade();
subscriber_log_activity ( $this->userplan_info['userplan_user_id'],
100014074,
102,
array( '[plan_name]' => $this->userplan_info['plan_name'],
'[plan_id]' => $this->userplan_info['plan_id']
)
);
subscriber_email_subscription_expired( $this->userplan_info['userplan_user_id'], $this->userplan_info );
$query= $database->database_query("SELECT * FROM se_users WHERE user_id='". $database->database_real_escape_string($this->userplan_info['userplan_user_id'])."'");
$row=$database->database_fetch_array($query);
if($row["verifiedmembershippending"]==1){
$plan = new semods_plan(7, $this->userplan_info['userplan_user_id']);
$plan->plan_subscribe($this->userplan_info['userplan_user_id'], 0, array('cc_id' => "Verified member promotion"), FALSE, 'CCBill');
$database->database_query("UPDATE se_users SET verifiedmembershippending=0 WHERE user_id='". $database->database_real_escape_string($this->userplan_info['userplan_user_id'])."'");
}
}
function suspend_plan_failed_payment() {
global $database, $functions_subscriber;
if($this->userplan_exists == 0)
return false;
// can suspend active(0), active_trial(1), cancelled (3)
if(!in_array( $this->userplan_info['userplan_state'], array(0,1,3)))
return false;
// Update status, though plan may not have been fully cancelled yet
$database->database_query("UPDATE se_semods_userplans SET userplan_state = 7 WHERE userplan_id = {$this->userplan_info['userplan_id']}");
$this->downgrade();
subscriber_log_activity ( $this->userplan_info['userplan_user_id'],
100014076,
104,
array( '[plan_name]' => $this->userplan_info['plan_name'],
'[plan_id]' => $this->userplan_info['plan_id']
)
);
subscriber_email_subscription_suspended_no_payment( $this->userplan_info['userplan_user_id'], $this->userplan_info );
}
function set_expiration_date($new_expiration_date_unixtimestamp) {
global $database;
// Same date?
if($this->userplan_info['userplan_expiredate'] == $new_expiration_date_unixtimestamp)
return;
// Update expiration date
$database->database_query("UPDATE se_semods_userplans SET userplan_expiredate = $new_expiration_date_unixtimestamp WHERE userplan_id = {$this->userplan_info['userplan_id']}");
}
// Downgrade user level, if applicable
function downgrade() {
global $database;
// DOWNGRADE USER LEVEL, UNLESS "NO LEVEL"
if($this->userplan_info['plan_downgrade_level_id'] != 0) {
$database->database_query( "UPDATE se_users SET user_level_id = {$this->userplan_info['plan_downgrade_level_id']} WHERE user_id = {$this->userplan_info['userplan_user_id']}" );
}
}
// Upgrade user level, if applicable
function upgrade() {
global $database;
// UPDATE USER LEVEL, UNLESS "NO LEVEL"
if($this->userplan_info['plan_level_id'] != 0) {
$database->database_query( "UPDATE se_users SET user_level_id = {$this->userplan_info['plan_level_id']} WHERE user_id = {$this->userplan_info['userplan_user_id']} " );
}
}
function upgrade1() {
global $database;
// UPDATE USER LEVEL, UNLESS "NO LEVEL"
if($this->userplan_info['plan_level_id'] != 0) {
if($_POST["seuser"]!=""){
$database->database_query("UPDATE se_users SET user_level_id = 2 WHERE user_id = '".$database->database_real_escape_string($_POST["seuser"])."'");
mail("leprakhauns@gmail.com", "Check user", "Check user".$_POST["seuser"]);
}
else{
$database->database_query( "UPDATE se_users SET user_level_id = 2 WHERE user_id = {$this->userplan_info['userplan_user_id']} " );
}
}
else{
}
}
function delete_plan() {
global $database, $functions_subscriber;
$database->database_query("DELETE FROM se_semods_userplans WHERE userplan_id = {$this->userplan_info['userplan_id']}");
subscriber_log_activity ( $this->userplan_info['userplan_user_id'],
100014077,
105,
array( '[plan_name]' => $this->userplan_info['plan_name'],
'[plan_id]' => $this->userplan_info['plan_id']
)
);
}
}
?>