}
if ($vbulletin->GPC['subscriptionlogid']) {
// already exists
$sub = $db->query_first("\n\t\t\tSELECT subscriptionlog.*, username FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog\n\t\t\tLEFT JOIN " . TABLE_PREFIX . "user USING(userid)\n\t\t\tWHERE subscriptionlogid = " . $vbulletin->GPC['subscriptionlogid'] . "\n\t\t");
print_table_header(construct_phrase($vbphrase['edit_subscription_for_x'], $sub['username']));
construct_hidden_code('userid', $sub['userid']);
$vbulletin->GPC['subscriptionid'] = $sub['subscriptionid'];
print_select_row($vbphrase['subscription'], 'subscriptionid', $sublist, $vbulletin->GPC['subscriptionid']);
} else {
print_table_header($vbphrase['add_user']);
$subinfo = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "subscription WHERE subscriptionid = " . $vbulletin->GPC['subscriptionid']);
$cost_length = unserialize($subinfo['cost']);
reset($cost_length);
$first_sub = current($cost_length);
if (!empty($first_sub['units'])) {
$expiry = $subobj->fetch_proper_expirydate(TIMENOW, $first_sub['length'], $first_sub['units']);
} else {
$expiry = TIMENOW + 60;
}
$sub = array('regdate' => TIMENOW, 'status' => 1, 'expirydate' => $expiry);
print_select_row($vbphrase['subscription'], 'subscriptionid', $sublist, $vbulletin->GPC['subscriptionid']);
if ($vbulletin->GPC['userid']) {
$userinfo = fetch_userinfo($vbulletin->GPC['userid']);
if (!$userinfo) {
print_stop_message('invalid_user_specified');
}
} else {
$userinfo = array('username' => '');
}
print_input_row($vbphrase['username'], 'username', $userinfo['username'], false);
}
$subscribedbits = '';
$subscriptionbits = '';
($hook = vBulletinHook::fetch_hook('paidsub_list_start')) ? eval($hook) : false;
foreach ($subobj->subscriptioncache as $subscription) {
$subscriptionid =& $subscription['subscriptionid'];
if (isset($subscribed["{$subscription['subscriptionid']}"])) {
$joindate = vbdate($vbulletin->options['dateformat'], $subscribed["{$subscription['subscriptionid']}"]['regdate'], false);
$enddate = vbdate($vbulletin->options['dateformat'], $subscribed["{$subscription['subscriptionid']}"]['expirydate'], false);
$gotsubscriptions = true;
$subscription['title'] = $vbphrase['sub' . $subscriptionid . '_title'];
($hook = vBulletinHook::fetch_hook('paidsub_list_activebit')) ? eval($hook) : false;
eval('$subscribedbits .= "' . fetch_template('subscription_activebit') . '";');
}
if ($subscription['active']) {
if (isset($subscribed["{$subscription['subscriptionid']}"])) {
if ($subobj->fetch_proper_expirydate($subscribed["{$subscription['subscriptionid']}"]['expirydate'], $subscription['length'], $subscription['units']) == -1) {
continue;
}
}
if (!empty($subscription['deniedgroups']) and !count(array_diff(fetch_membergroupids_array($vbulletin->userinfo), $subscription['deniedgroups']))) {
continue;
}
$subscription['cost'] = unserialize($subscription['cost']);
$string = '<option value="">--------</option>';
foreach ($subscription['cost'] as $key => $currentsub) {
if ($currentsub['length'] == 1) {
$currentsub['units'] = $lengths["{$currentsub['units']}"];
} else {
$currentsub['units'] = $lengths[$currentsub['units'] . 's'];
}
$string .= "<optgroup label=\"" . construct_phrase($vbphrase['length_x_units_y_recurring_z'], $currentsub['length'], $currentsub['units'], $currentsub['recurring'] ? ' *' : '') . "\">\n";
}
if ($vbulletin->GPC['subscriptionlogid']) {
// already exists
$sub = $assertor->getRow('vBForum:getSubscriptionUsersLog', array('conditions' => array('subscriptionlogid' => $vbulletin->GPC['subscriptionlogid'])));
print_table_header(construct_phrase($vbphrase['edit_subscription_for_x'], $sub['username']));
construct_hidden_code('userid', $sub['userid']);
$vbulletin->GPC['subscriptionid'] = $sub['subscriptionid'];
print_select_row($vbphrase['subscription'], 'subscriptionid', $sublist, $vbulletin->GPC['subscriptionid']);
} else {
print_table_header($vbphrase['add_user']);
$subinfo = $assertor->getRow('vBForum:subscription', array('subscriptionid' => $vbulletin->GPC['subscriptionid']));
$cost_length = unserialize($subinfo['cost']);
reset($cost_length);
$first_sub = current($cost_length);
if (!empty($first_sub['units'])) {
$expiry = $subobj->fetch_proper_expirydate(vB::getRequest()->getTimeNow(), $first_sub['length'], $first_sub['units']);
} else {
$expiry = vB::getRequest()->getTimeNow() + 60;
}
$sub = array('regdate' => vB::getRequest()->getTimeNow(), 'status' => 1, 'expirydate' => $expiry);
print_select_row($vbphrase['subscription'], 'subscriptionid', $sublist, $vbulletin->GPC['subscriptionid']);
if ($vbulletin->GPC['userid']) {
$userinfo = fetch_userinfo($vbulletin->GPC['userid']);
if (!$userinfo) {
print_stop_message2('invalid_user_specified');
}
} else {
$userinfo = array('username' => '');
}
print_input_row($vbphrase['username'], 'username', $userinfo['username'], false);
}
