/**
* Dump self::$borders into a SQL statement
* @param string $tableName Borders/CoastalBorders
* @return string the SQL
*/
public static function dumpBorderRowsSQL($tableName)
{
$sqlRows = array();
self::$borders = array();
foreach (self::$Territories as $Territory) {
if ($tableName == 'CoastalBorders') {
$Territory->coastalBordersRows();
} else {
$Territory->bordersRows();
}
}
foreach (self::$borders as $fromTerrID => $toTerrRows) {
foreach ($toTerrRows as $toTerrID => $unitTypes) {
$sqlRows[] = '(' . self::$staticMapID . ',' . $fromTerrID . ', ' . $toTerrID . ", '" . $unitTypes['fleetsPass'] . "', '" . $unitTypes['armysPass'] . "')";
}
}
return "INSERT INTO wD_" . $tableName . " (mapID, fromTerrID, toTerrID, fleetsPass, armysPass) VALUES " . implode(',', $sqlRows);
}
