View Single Post
  #31  
Old 01-21-2013, 11:16 PM
revloc02c's Avatar
revloc02c
Hill Giant
 
Join Date: Aug 2010
Location: UT
Posts: 215
Default

In fact if you run this query it will show where there are disconnects in AA prereq progressions:

Code:
SELECT t1.skill_id, t1.name, t1.prereq_skill, t2.name FROM altadv_vars t1 LEFT JOIN altadv_vars t2 ON t1.prereq_skill = t2.skill_id ORDER BY t1.prereq_skill DESC;
Wherever there is a NULL on the right is a disconnect (except where the prereq_skill is zero or 4292967295 of course).

Last edited by revloc02c; 01-21-2013 at 11:22 PM.. Reason: more clarifying info
Reply With Quote