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

@@ 1417-1424 (lines=8) @@
1414
$moduleDependencies = $mdp;
1415
foreach ($moduleDependencies as $dependency) {
1416
	$ds = mysqli_query($sqlParser->conn, 'SELECT id, guid FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_modules` WHERE name="' . $dependency['module'] . '"');
1417
	if (!$ds) {
1418
		echo mysqli_error($sqlParser->conn) . PHP_EOL;
1419
		return;
1420
	} else {
1421
		$row = mysqli_fetch_assoc($ds);
1422
		$moduleId = $row["id"];
1423
		$moduleGuid = $row["guid"];
1424
	}
1425
	// get extra id
1426
	$ds = mysqli_query($sqlParser->conn, 'SELECT id FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_' . $dependency['table'] . '` WHERE ' . $dependency['column'] . '="' . $dependency['name'] . '"');
1427
	if (!$ds) {
@@ 1427-1433 (lines=7) @@
1424
	}
1425
	// get extra id
1426
	$ds = mysqli_query($sqlParser->conn, 'SELECT id FROM ' . $dbase . '`' . $sqlParser->prefix . 'site_' . $dependency['table'] . '` WHERE ' . $dependency['column'] . '="' . $dependency['name'] . '"');
1427
	if (!$ds) {
1428
		echo mysqli_error($sqlParser->conn) . PHP_EOL;
1429
		return;
1430
	} else {
1431
		$row = mysqli_fetch_assoc($ds);
1432
		$extraId = $row["id"];
1433
	}
1434
	// setup extra as module dependency
1435
	$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');
1436
	if (!$ds) {