/** * 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); }