PHP talent_dependencies Examples

Example #1

File: char_talent.php Project: BACKUPLIB/minimanager-1

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);
            }
        }
    }
}

Example #2

File: char_talent.php Project: Refuge89/World-of-Warcraft-Trinity-Core-MaNGOS

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);
            }
        }
    }
}