Attributes as a signup criterium for raids?

[Vingilotz]

Boa recently revamped the LOTRO game pack, and I discussed attributes with him. In LOTRO "radiance" is an armour attribute that is required for certain raids (e.g. you need minimum 50 radiance to fight The Watcher).

I know signups are commonly gated by the level of the character. I was wondering if there is an option/mod to use attributes as a signup criterium as well?

So for example that players need to be at least level 59 AND have 50 radiance to be able to sign up for the mentioned Watcher raid?

Any ideas and comments appreciated.

[ninjagranny]

Was looking at this too .
raids_form.tpl is the raid definition by the looks of it an a line could be added there

I "think" the checking is done in includes\functions.raid.php

// displays the popup signup form
function signupForm($data, $pMain, $redirect = null, $showComment = true) {
global $pLang, $pConfig, $db_raid;

$sql['SELECT'] = '*';
$sql['FROM'] = 'character as c';
$sql['WHERE'] = "c.char_level >= {$data['minimum_level']}
AND c.char_level <= {$data['maximum_level']}
AND c.profile_id = ".$pMain->getProfileID();
$sql['SORT'] = 'c.char_name';
$result_chars = $db_raid->set_query('select', $sql, __FILE__, __LINE__);

I will have a poke around and see if i can get it work then Ill pop it up on the hydra calendar and if that works ill do the new alliance one an send you the files -- or Ill hope that someone with more brains with me either does it or points me in the right direction.

As an asside it may well be worth adding this as a feature as a lot of games now need a certain attribute to be able to access certain areas - LOTRO is nice and easy as the only real requirement is a Radiance.

[ninjagranny]

hmm

Attributes are stored in a seperate table so it could be more problematic

My sql isnt good enough but we would need to get the char id then relate that to the attribute id and then do a where attrib >= value

It would also require I think another field in table _raid

The other option would be to change the charactor definition so radiance was part of that - and then use the _char table . Whic overall may be neater - either way this mod would have to change the templates ( big wow) the includes ( making it non standard) and the database ( making it non standard)

[BoaConstrictor]

Originally Posted by Vingilotz

Boa recently revamped the LOTRO game pack, and I discussed attributes with him. In LOTRO "radiance" is an armour attribute that is required for certain raids (e.g. you need minimum 50 radiance to fight The Watcher).

I know signups are commonly gated by the level of the character. I was wondering if there is an option/mod to use attributes as a signup criterium as well?

So for example that players need to be at least level 59 AND have 50 radiance to be able to sign up for the mentioned Watcher raid?

Any ideas and comments appreciated.

It will be an option in the 1.1.x series, but not 1.0.x.
The reason I won't include this in the 1.0.x series, is that it will break templates, and we all saw how much noice that made on the forums when 1.0.8 came and needed template changes, even if the readme and the news bulletin told you exacly how to fix it.

Haven't had much time to look at it now, since I'm working on making 1.0.9 ready.

[BoaConstrictor]

Originally Posted by ninjagranny

$sql['SELECT'] = '*';
$sql['FROM'] = 'character as c';
$sql['WHERE'] = "c.char_level >= {$data['minimum_level']}
AND c.char_level <= {$data['maximum_level']}
AND c.profile_id = ".$pMain->getProfileID();
$sql['SORT'] = 'c.char_name';
$result_chars = $db_raid->set_query('select', $sql, __FILE__, __LINE__);

If you need to check only one attribute, then you could do something like this:

SELECT
  *
FROM
  phpraider_character c,
  phpraider_attribute_data ad,
  phpraider_attribute a
WHERE
  c.character_id=ad.character_id AND
  ad.attribute_id=a.attribute_id AND
  a.att_name='Radiance' AND
  ad.att_value>=10 AND
  c.char_level >= 50 AND
  c.char_level <= 80 AND
  c.profile_id = 1
ORDER BY
  c.char_name;

That will give you all characters between 50 and 80 for the currently logged in user that also has a 'Radiance'>=10.