evolution-cms / evolution

foreach ($moduleDependencies as $dependency) {

    $ds = mysqli_query($sqlParser->conn,

        'SELECT id, guid FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_modules` WHERE name="' . $dependency['module'] . '"');

    if (!$ds) {

        echo mysqli_error($sqlParser->conn) . PHP_EOL;

        return;

    } else {

        $row = mysqli_fetch_assoc($ds);

        $moduleId = $row["id"];

        $moduleGuid = $row["guid"];

    }

    // get extra id

    $ds = mysqli_query($sqlParser->conn,

        'SELECT id FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_' . $dependency['table'] . '` WHERE ' . $dependency['column'] . '="' . $dependency['name'] . '"');

    // get extra id

    $ds = mysqli_query($sqlParser->conn,

        'SELECT id FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_' . $dependency['table'] . '` WHERE ' . $dependency['column'] . '="' . $dependency['name'] . '"');

    if (!$ds) {

        echo mysqli_error($sqlParser->conn) . PHP_EOL;

        return;

    } else {

        $row = mysqli_fetch_assoc($ds);

        $extraId = $row["id"];

    }

    // setup extra as module dependency

    $ds = mysqli_query($sqlParser->conn,

        'SELECT module FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_module_depobj` WHERE module=' . $moduleId . ' AND resource=' . $extraId . ' AND type=' . $dependency['type'] . ' LIMIT 1');