Code Duplication    Length = 7-8 lines in 4 locations

install/instprocessor.php 2 locations

@@ 697-704 (lines=8) @@
694
// Install Dependencies
695
foreach ($moduleDependencies as $dependency) {
696
	$ds = mysqli_query($sqlParser->conn, 'SELECT id, guid FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_modules` WHERE name="' . $dependency['module'] . '"');
697
	if (!$ds) {
698
		echo "<p>" . mysqli_error($sqlParser->conn) . "</p>";
699
		return;
700
	} else {
701
		$row = mysqli_fetch_assoc($ds);
702
		$moduleId = $row["id"];
703
		$moduleGuid = $row["guid"];
704
	}
705
	// get extra id
706
	$ds = mysqli_query($sqlParser->conn, 'SELECT id FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_' . $dependency['table'] . '` WHERE ' . $dependency['column'] . '="' . $dependency['name'] . '"');
707
	if (!$ds) {
@@ 707-713 (lines=7) @@
704
	}
705
	// get extra id
706
	$ds = mysqli_query($sqlParser->conn, 'SELECT id FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_' . $dependency['table'] . '` WHERE ' . $dependency['column'] . '="' . $dependency['name'] . '"');
707
	if (!$ds) {
708
		echo "<p>" . mysqli_error($sqlParser->conn) . "</p>";
709
		return;
710
	} else {
711
		$row = mysqli_fetch_assoc($ds);
712
		$extraId = $row["id"];
713
	}
714
	// setup extra as module dependency
715
	$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');
716
	if (!$ds) {

install/cli-install.php 2 locations

@@ 1433-1440 (lines=8) @@
1430
$moduleDependencies = $mdp;
1431
foreach ($moduleDependencies as $dependency) {
1432
    $ds = mysqli_query($sqlParser->conn, 'SELECT id, guid FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_modules` WHERE name="' . $dependency['module'] . '"');
1433
    if (!$ds) {
1434
        echo mysqli_error($sqlParser->conn) . PHP_EOL;
1435
        return;
1436
    } else {
1437
        $row = mysqli_fetch_assoc($ds);
1438
        $moduleId = $row["id"];
1439
        $moduleGuid = $row["guid"];
1440
    }
1441
    // get extra id
1442
    $ds = mysqli_query($sqlParser->conn, 'SELECT id FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_' . $dependency['table'] . '` WHERE ' . $dependency['column'] . '="' . $dependency['name'] . '"');
1443
    if (!$ds) {
@@ 1443-1449 (lines=7) @@
1440
    }
1441
    // get extra id
1442
    $ds = mysqli_query($sqlParser->conn, 'SELECT id FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_' . $dependency['table'] . '` WHERE ' . $dependency['column'] . '="' . $dependency['name'] . '"');
1443
    if (!$ds) {
1444
        echo mysqli_error($sqlParser->conn) . PHP_EOL;
1445
        return;
1446
    } else {
1447
        $row = mysqli_fetch_assoc($ds);
1448
        $extraId = $row["id"];
1449
    }
1450
    // setup extra as module dependency
1451
    $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');
1452
    if (!$ds) {