Is this possible? Basically what i want to do is have people go to my roster and the 1st page being the alt monitor. Its basically the index page with alts separated. I like this. I just don't want people to have to click on something extra when i want them to see it in the 1st place.

Thanhs

I used to offer a modded index file. I stopped doing it because it was getting too complicated. The easiest way to do it is putting a redirect in your index.php:

Code: Select all

<?php

header('Location: '.ROSTER_URL.'/addon.php?roster_addon_name=AltMonitor');


Add that to the top of index.php, then the front page should automatically redirect to altmonitor.

I'm not sure this is the right place to ask this, but I didn't want to open a new topic for something that is (loosely) related to this.

You know how in the default index page of roster there's a list with "levels" and a "Guild Average Level"? Well, is it possible that when using alt-monitor this list would only consider Mains on the calculations? For instance, in my guild, we have about 90 mains and probably double that as alts (we have lots of alt-aholics). Problem is that while most of our mains are probably >lvl 58, the "Average level of the guild" is showing something a lot closer to lvl 40, because is also counting the loads of lowbie twinks and bank characters we have in the guild. That's fine for the main page, but I would like when using alt-monitor to have a clear sumarized view of how many Mains we have on each layer, and the total average lvl of the mains in guild. For these calculations, any character that alt-monitor find as an alt wouldn't count towards the actual numbers reported back.

I'm not very good at coding in php but if someone gives me a hint on where to look, I might be able to sort it on my own. Though I would prefer something like that to be an addedd functionality of alt-monitor.

Thanks in advance for any help or hint you can provide!

There's a bit in roster's lib/menu.php you can edit.

Code: Select all

   $guildstat_query = "SELECT IF(`".$roster_conf['alt_location']."` LIKE '%".$roster_conf['alt_type']."%',1,0) AS 'isalt',
      FLOOR(`level`/10) AS levelgroup,
      COUNT(`level`) AS amount,
      SUM(`level`) AS sum
      FROM `".ROSTER_MEMBERSTABLE."`
      GROUP BY isalt, levelgroup
      ORDER BY isalt ASC, levelgroup DESC";


Change that query to

Code: Select all

   $guildstat_query = "SELECT IF(`alts`.`alt_type` == 2,0,1) AS 'isalt',
      FLOOR(`level`/10) AS levelgroup,
      COUNT(`level`) AS amount,
      SUM(`level`) AS sum
      FROM `".ROSTER_MEMBERSTABLE."` members
      INNER JOIN `roster_addon_altmonitor` alts USING (`member_id`)
      GROUP BY isalt, levelgroup
      ORDER BY isalt ASC, levelgroup DESC";


Then, a bit further down, change

Code: Select all

      if ($row['isalt'])
      {
         $num_alts += $row['amount'];
      }


to

Code: Select all

      if ($row['isalt'])
      {
         $num_alts += $row['amount'];
         $level_sum += $row['sum'];
      }


And a bit further down, delete

Code: Select all

      $level_sum += $row['sum'];


Untested.

Tried those changes. I'm getting an error like this

Code: Select all

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 2,0,1) AS 'isalt', FLOOR(`level`/10) AS levelgroup, ' at line 1
SQL:
SELECT IF(`alts`.`alt_type`== 2,0,1) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS amount, SUM(`level`) AS sum FROM `roster_members` members INNER JOIN `roster_addon_altmonitor` alts USING (`member_id`) GROUP BY isalt, levelgroup ORDER BY isalt ASC, levelgroup DESC
File: menu.php
Line: 65

damn, forgot. Use = instead of == on the first line of the first edit.

Ok Fixed that error.

However I'm very confused by the results. With the original set up, I get an average level of 45. After applying your changes, the average level dropped to 27. I was expecting it to increase. Most of our mains are >60.

The break down list looks like this before the changes:

Code: Select all

Members: 83 (+107 Alts)

    * Average Level: 45
    * Level 70: 11
    * Level 60-69: 78
    * Level 50-59: 13
    * Level 40-49: 15
    * Level 30-39: 16
    * Level 1-29: 57



and like this after

Code: Select all

Members: 96 (+94 Alts)

    * Average Level: 27
    * Level 70: 11
    * Level 60-69: 78
    * Level 50-59: 13
    * Level 40-49: 15
    * Level 30-39: 16
    * Level 1-29: 57


I understand that it's using a different table to get the info wether a char is a main or an alt. But I can't begin to grasp why is giving a lower average? I'm guessing that even if there are a few alts at lvl 60-70, most of them are mains. The average should have gone up, not down? Unless we are claculating the average of the alts.

Damn, it's only doing the alts instead of only the mains.

Where you added the

Code: Select all

         $level_sum += $row['sum'];

Add it to the else belonging to that if