Morning all, I taking to custom one of the page in roster to show the officer notes & have not be having much luck with it & want to see if some one here would be able to help me out.

I took the indexalt.php page and edited it up a bit & got this.

Code: Select all

<?php
require_once( 'settings.php' );

$header_title = $wordings[$roster_conf['roster_lang']]['alternate'];
include_once (ROSTER_BASE.'roster_header.tpl');


$FIELD[] = array (
   'name' => array(
      'lang_field' => 'name',
      'order'    => array( '`members`.`name` ASC' ),
      'order_d'    => array( '`members`.`name` DESC' ),
      'required' => true,
      'default'  => true,
      'value' => 'name_value',
   ),
);

$FIELD[] = array (
   'class' => array(
      'lang_field' => 'class',
      'divider' => true,
      'divider_value' => 'class_divider',
      'order'    => array( '`members`.`class` ASC' ),
      'order_d'    => array( '`members`.`class` DESC' ),
      'default'  => true,
      'value' => 'class_value',
   ),
);

$FIELD[] = array (
   'level' => array(
      'lang_field' => 'level',
      'divider' => true,
      'divider_prefix' => 'Level ',
      'order_d'    => array( '`members`.`level` ASC' ),
      'default'  => true,
      'value' => 'level_value',
   ),
);

$FIELD[] = array (
   'officer_note' => array(
      'lang_field' => 'officer_note',
      'order'    => array( '`members`.`officer_note` ASC' ),
      'order_d'    => array( '`members`.`officer_note` DESC' ),
//      'value' => 'officer_note_value',
   ),
);

include_once (ROSTER_BASE.'memberslist.php');

include_once (ROSTER_BASE.'roster_footer.tpl');
?>

The problem I have at this point is I have not been able to get the ON to show I can get just about anything else to show but not the officer notes.

Any help would be great.

Looks fine to me. What's it returning?

You probably won't need the value field for the officer note, unless you also put a function with the specified name (in this case officer_note_value( $row ) )

You'll also need to modify the memberslist.php to actually pull the officer note from the database. It doesn't do so by default.

find:

Code: Select all

   '`members`.`zone`, '.

After, Add:

Code: Select all

//  Officer note
   '`members`.`officer_note`, '.   


PleegWat wrote:Looks fine to me. What's it returning?

nothing

Samadhi wrote:You'll also need to modify the memberslist.php to actually pull the officer note from the database. It doesn't do so by default.

find:

Code: Select all

   '`members`.`zone`, '.

After, Add:

Code: Select all

//  Officer note
   '`members`.`officer_note`, '.   


Ahhh that got it.

Thanks again

Okay two questions...

How would I set it up to only show 70s.

We are using the office note for displaying DKP in format like 0|0|0|0 the numbers will be different from player to player but it should always be in a number|number|number|number format.

There are a small number of player that don't have DKP namely alts. For them it looks like it is the name of the main. How would I filter them out?

You would have to edit memberslist.php to be able to do this

Code: Select all

// All those people asking about guild searching, here's a spot!  and here's the simple alteration to stop guild filtering in this particular place
   "LEFT JOIN `".ROSTER_PLAYERSTABLE."` AS players ON `members`.`member_id` = `players`.`member_id` AND `members`.`guild_id` = '$guildId' ".
   "ORDER BY ";

I think before the ORDER BY you should put WHERE members.level =70 or something

This change would also mean that all files that use memberslist would be show only level 70 too

You could also use an if statement to switch this on and off and have your new file set the switch