<?php
if (basename(getcwd()) !== 'docroot') {
  echo "You must run this in docroot.\n";
  exit(1);
}

if (count($argv) < 4) {
  echo "Usage: php rebuild_module_paths.php hostname dbname username password\n";
  exit(1);
}

$servername = $argv[1];
$database = $argv[2];
$username = $argv[3];
$password = isset($argv[4]) ? $argv[4] : '';

$passwordcomment = $password ? 'a password' : 'no password';
echo "Connecting to mysql:host=$servername;dbname=$database with username=$username and $passwordcomment.\n";
sleep(3);

try {
  $conn = new PDO("mysql:host=$servername;dbname=$database", $username, $password);
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  $query = $conn->query('SELECT filename,name FROM system');
  $results = $query->fetchAll(PDO::FETCH_ASSOC);

  if (!$results) {
    throw new \Exception('Failed to query database.');
  }

  foreach ($results as $mod) {
    exec('find . -name ' . basename($mod['filename']), $modpath_arr);
    if (count($modpath_arr) == 1) {
      $modpath = ltrim($modpath_arr[0], './');
      $dbpath = $mod['filename'];
      if ($dbpath != $modpath) {
        echo "Updating " . $mod['name']. "'s path\n";
        $query = $conn->prepare('UPDATE system SET filename=:filename WHERE name=:name');
        $query->bindParam(':filename', $modpath, PDO::PARAM_STR);
        $query->bindParam(':name', $mod['name'], PDO::PARAM_STR);
        $query->execute();
      }
    }
    unset($modpath_arr);
  }
} catch(PDOException $e) {
  echo "Error: " . $e->getMessage();
}
$conn = null;