Just looking to see if anyone has done this with their rosters, I want to see all the guild members and the money they have on the main roster page.

Please can you assist if you know where I should start

ok now that i've discovered indexalt.php i have managed to sort this myself

open index.php and change the following from

Code: Select all

$additional_sql = array(
   '`players`.`hearth`, ',
   "IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', ",
   "`players`.`dateupdatedutc` AS 'last_update', ",
   "IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull' ",
);


to

Code: Select all

$additional_sql = array(
   '`players`.`money_g`, ',
   '`players`.`money_s`, ',
   '`players`.`money_c`, ',
   '`players`.`hearth`, ',
   "IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', ",
   "`players`.`dateupdatedutc` AS 'last_update', ",
   "IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull' ",
);


also add the following column data in the order that you want it to appear

Code: Select all

if( $roster_conf['show_money'] )
{
   $FIELD[] = array (
      'money_g' => array(
         'lang_field' => 'gold',
         'order' => array( '`players`.`money_g` DESC','`players`.`money_s` DESC','`players`.`money_c` DESC' ),
         'order_d' => array( '`players`.`money_g` ASC','`players`.`money_s` ASC','`players`.`money_c` ASC' ),
         'value' => 'money_value',
      ),
   );
}