Character Browser Berserkers not showing AA
Reply
Berserkers not showing AA
From the PEQ forums http://www.peqtgc.com/phpBB3/viewtopic.php?p=66204#p66204

- Leere
The AA page for Berserkers doesn't show any AAs. The lists for each category are completely empty. It doesn't matter if you've bought any AAs or not.

Available AA points are shown, spent points are not shown.

Best guess, based on the ver 1.4 available as a download, the problem is use of just classes in the WHERE clause of the SELECT in aas.php. This uses the field `classes`, rather than combined value from the SELECT list, and so berserkers are not included.


I've included both lines so that hopefully it's easy to find if the PEQ version greatly differs from the one in the download.


php
More +
aas.php - line 130
Code:
  $results = mysql_query("SELECT skill_id, name, cost, cost_inc, max_level, (classes + berserker) AS classes FROM altadv_vars WHERE type = ".$key." AND classes & ".$classbit[$char->GetValue('class')]." ORDER BY skill_id" );


A quick fix locally was to use the following instead:
Code:
  $results = mysql_query("SELECT skill_id, name, cost, cost_inc, max_level FROM altadv_vars WHERE type = ".$key." AND (classes+berserker) & ".$classbit[$char->GetValue('class')]." ORDER BY skill_id" );

_________________
Sorvani
Wed Oct 16, 2013 8:44 pm
Senior Project Member
Thanks, I'll have a look at it
Thu Oct 17, 2013 4:46 pm
Project Lead
should be fixed in 2.23, let me know if not
Sun Nov 24, 2013 8:20 pm
Project Lead
Character Browser Berserkers not showing AA
Reply