Had to do actual work for awhile :(
Went down into GetAASkillVars() and found that it isn't returning rows. Query is at line 1310 roughly, next if() block checks row count and fails at 0. skill_id is apparently '2', Innate Strength.
Running the actual query on the database from the mysql CLI client produces the expected results:
Code:
SELECT a.cost, a.max_level, a.hotkey_sid, a.hotkey_sid2, a.title_sid, a.desc_sid, a.type, COALESCE((
SELECT p.prereq_index_num FROM (SELECT a2.skill_id, @row := @row + 1 AS prereq_index_num FROM altadv_vars a2) AS p WHERE p.skill_id = a.prereq_skill), 0) AS prereq_skill_index, a.prereq_minpoints,a.spell_type,a.spell_refresh,a.classes,a.berserker,a.spellid,a.class_type,a.name,a.cost_inc FROM altadv_vars a WHERE skill_id=2
Code:
+------+-----------+------------+-------------+-----------+----------+------+--------------------+------------------+------------+---------------+---------+-----------+------------+------------+-----------------+----------+
| cost | max_level | hotkey_sid | hotkey_sid2 | title_sid | desc_sid | type | prereq_skill_index | prereq_minpoints | spell_type | spell_refresh | classes | berserker | spellid | class_type | name | cost_inc |
+------+-----------+------------+-------------+-----------+----------+------+--------------------+------------------+------------+---------------+---------+-----------+------------+------------+-----------------+----------+
| 1 | 5 | 4294967295 | 4294967295 | 13500 | 13501 | 1 | 0 | 0 | 0 | 0 | 65534 | 1 | 4294967295 | 51 | Innate Strength | 0 |
+------+-----------+------------+-------------+-----------+----------+------+--------------------+------------------+------------+---------------+---------+-----------+------------+------------+-----------------+----------+
1 row in set (0.00 sec)
errbuf is empty, result.fields is populated with the expected field names. Not sure why it's not matching anything... I might not have the mysql libs linked in properly... Gonna have to take a look at it again in awhile.