[Dragonsys]

Originally Posted by Sarcoth

The problem is that both mods are using the same Execution Order for the tab. I guess they have a default order when on the forums and then when you go to the page for the particular mod, it takes precedence. So, what you need to do is go into the plugins and change the Execution Order for one of them. The "ShowRoster Tab for Navbar" is the name of the plugin for this mod. If you want the roster mod first, then change it to 4, otherwise change it to 6 or something larger.

Most mods use 5 as the default, so you may encounter that problem again. Now you know how to fix it. I'll change this to another number once I figure out how to set the execution order within the mod code.

So, I changed the Exec order to 6 for Roster and 99 for Project Tools, and the tabs still switch order when you click on them, so this is not the solution. I think it has to do with this bit of code:

$navbarloc = $vbulletin->options['showroster_navbar_loc'];
$navbarorder = $vbulletin->options['showroster_navbar_order']; 

switch ($navbarloc) {
    case '1':
        $nbloc = 'navtab_start'; break;
    case '2':
        $nbloc = 'navtab_middle'; break;
    case '3':
        $nbloc = 'navtab_end'; break;
}

Originally Posted by asbc

This is a great mod!!

I was wondering, I have paid subscriptions set up for my usergroup. Is it possible to show the subscription expiry date in one of the roster columns?

the data comes from the subscriptionlog table.
The fields you would need to read are: subscriptionid, userid, expirydate and status
The basic SQL Query would be something like this:

Only Active Subscriptions:

SELECT subscriptionid,userid,expirydate FROM ".TABLE_PREFIX."subscriptionlog WHERE status = 1

Only one particular Subscription:

SELECT userid,expirydate FROM ".TABLE_PREFIX."subscriptionlog WHERE subscriptionid = {Your_Subscription_ID}