function talent_dependencies(&$tabs, &$tab, &$i, &$sqlm) { if ($dep = $sqlm->fetch_assoc($sqlm->query(' SELECT field_1, field_2, field_3, field_' . ($tab['field_16'] + 1) . ', field_13,field_16' . ($tab['field_16'] < 4 ? ', field_' . ($tab['field_16'] + 2) . '' : '') . ' FROM dbc_talent WHERE id = ' . $tab['field_13'] . ' and field_' . ($tab['field_16'] + 1) . ' != 0 LIMIT 1'))) { if (empty($tabs[$dep['field_1']][$dep['field_2']][$dep['field_3']])) { $tabs[$dep['field_1']][$dep['field_2']][$dep['field_3']] = array($dep['field_' . ($tab['field_16'] + 1) . ''], '' . ($tab['field_16'] + 1) . '', $tab['field_16'] < 4 ? $dep['field_' . ($tab['field_16'] + 2) . ''] ? '2' : '5' : '5'); $i += $tab['field_16'] + 1; if ($dep['field_13']) { talent_dependencies($tabs, $dep, $i, $sqlm); } } } }
function talent_dependencies(&$tabs, &$tab, &$i) { global $sql; $query = "SELECT TalentTab, Row, Col, Spell" . ($tab["TalentCount1"] + 1) . ", Talent1, TalentCount1" . ($tab["TalentCount1"] < 4 ? ", Spell" . ($tab["TalentCount1"] + 2) : "") . " FROM talent WHERE id='" . $tab["Talent1"] . "' AND Spell" . ($tab["TalentCount1"] + 1) . " != 0 LIMIT 1"; if ($dep = $sql["dbc"]->fetch_assoc($sql["dbc"]->query($query))) { if (empty($tabs[$dep["TalentTab"]][$dep["Row"]][$dep["Col"]])) { $tabs[$dep["TalentTab"]][$dep["Row"]][$dep["Col"]] = array($dep["Spell" . ($tab["TalentCount1"] + 1)], $tab["TalentCount1"] + 1, $tab["TalentCount1"] < 4 ? $dep["Spell" . ($tab["TalentCount1"] + 2)] ? "2" : "5" : "5"); $i += $tab["TalentCount1"] + 1; if ($dep["Talent1"]) { talent_dependencies($tabs, $dep, $i); } } } }