} 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); }