Add Expiration Date Column to Show Subscriptions Page

In the AdminCP > Paid Subscriptions > Subscription Manager, when you click on any of the links representing the number of subscribers in the Active, Completed, and Total categories you are taken to a "Showing Subscriptions" page. I asked Logician if he could add a column with the "Expiration Date" between the "Start Date" and "Status" columns. He sent me this code modification a short time later and again gave me permission to post it here for any interested parties.

Edit admincp/subscriptions.php, find:

PHP Code:

print_form_header('user', 'find');
                print_table_header(construct_phrase($vbphrase['showing_subscriptions_x_to_
y_of_z'], ($vbulletin->GPC['limitstart'] + 1), iif($limitfinish >
$countusers['users'], $countusers['users'], $limitfinish),
$countusers[users]), 5);
                print_cells_row(array($vbphrase['title'], $vbphrase['username'],
$vbphrase['start_date'], $vbphrase['status'], $vbphrase['controls']), 1);
                // now display the results
                while ($user=$db->fetch_array($users))
                {
                        $cell = array();
                        $cell[] = $subcache["{$user['subscriptionid']}"];
                        $cell[] = "<a href=\"user.php?" .
$vbulletin->session->vars['sessionurl'] .
"do=edit&u=$user[userid]\"><b>$user[username]</b></a>&nbsp;";
                        $cell[] = vbdate($vbulletin->options['dateformat'], $user['regdate']);
                        $cell[] = iif($user['status'], $vbphrase['active'],
$vbphrase['disabled']);
                        $cell[] = construct_button_code($vbphrase['edit'], "subscriptions.php?"
. $vbulletin->session->vars['sessionurl'] .
"do=adjust&subscriptionlogid=$user[subscriptionlogid]");
                        print_cells_row($cell);
                } 


REPLACE it as:

PHP Code:

print_form_header('user', 'find');
                // Logician Hack : Add Expire Date to Subscriptions
                print_table_header(construct_phrase($vbphrase['showing_subscriptions_x_to_
y_of_z'], ($vbulletin->GPC['limitstart'] + 1), iif($limitfinish >
$countusers['users'], $countusers['users'], $limitfinish),
$countusers[users]), 6);
                print_cells_row(array($vbphrase['title'], $vbphrase['username'],
$vbphrase['start_date'], "Expiration Date", $vbphrase['status'],
$vbphrase['controls']), 1);
                // Logician Hack : Add Expire Date to Subscriptions
                // now display the results
                while ($user=$db->fetch_array($users))
                {
                        $cell = array();
                        $cell[] = $subcache["{$user['subscriptionid']}"];
                        $cell[] = "<a href=\"user.php?" .
$vbulletin->session->vars['sessionurl'] .
"do=edit&u=$user[userid]\"><b>$user[username]</b></a>&nbsp;";
                        $cell[] = vbdate($vbulletin->options['dateformat'], $user['regdate']);
                        // Logician Hack : Add Expire Date to Subscriptions
                        $cell[] = vbdate($vbulletin->options['dateformat'],
$user['expirydate']);
                        // Logician Hack : Add Expire Date to Subscriptions
                        $cell[] = iif($user['status'], $vbphrase['active'],
$vbphrase['disabled']);
                        $cell[] = construct_button_code($vbphrase['edit'], "subscriptions.php?"
. $vbulletin->session->vars['sessionurl'] .
"do=adjust&subscriptionlogid=$user[subscriptionlogid]");
                        print_cells_row($cell);
                } 


[Rich]

Hello,

This is useful for me. Thanks for adding it to the .org. (I suspect it is also on the adminzone?)

[the Sandman]

Originally Posted by iguanairs

Hello,

This is useful for me. Thanks for adding it to the .org. (I suspect it is also on the adminzone?)

Yes, I use it on TAZ.

[RMS-Chef]

Thanks to you both.

[Snake]

/me installs

Thanks bud!