Official SEOW

Code: Select all

<?php
  session_start();

// asp2php (vbscript) converted

//If the session variable is False or does not exist then redirect the user to the unauthorised user page
if ($_SESSION["CommanderGood_session"] != true) {
		header("Location: ../Scripts/default.php");
}

//Set page specific variables
// Sector B Italy.
$CampaignMap="Italy";
$pageTitle="Scorched Earth Mission HQ"; //Title bar text
$pageName="Italy - District B"; //Title in top left corner of page
$GeographicMapImage="Italy_District_B.jpg"; //Bitmap of geographic area
$maxpX=1024; //Size of map image in pixels in x direction
$mincX=0; //Min longitude of image in FB coords
$maxcX=159999; //Max longitude of image in FB coords
$maxpY=729; //Size of map image in pixels in y direction
$mincY=300; //Max latitude of image in FB coords
$maxcY=114000; //Min latitude of image in FB coords
$mapOffsetX=0.0; //FB longitude offset of map origin
$mapdivoffsetX=250; //Pixel offset of left edge of map image DIV 
$mapOffsetY=0.0; //FB latitude offset of map origin
$mapdivoffsetY=0; //Pixel offset of top edge of map image DIV 
$ShowRoads=false; //Turns on display of pre-defined road routes
$ShowRoadWP=false; //Turns on display of pre-defined road route waypoints
$ShowRailways=false; //Turns on display of pre-defined rail routes
$ShowRailwayWP=false; //Turns on display of pre-defined rail route waypoints

include '../Scripts/MP-BuildPage.php';

?>

Code: Select all

drop table if exists Highway_Intersections;
CREATE TABLE `Highway_Intersections` (
`Map` varchar(50) default NULL,
`Intersection_X_Axis` int(11) default NULL,
`Intersection_Y_Axis` int(11) default NULL,
`Route` int(11) default NULL,
`Waypoint_Number` int(11) default NULL
) TYPE=InnoDB;
INSERT INTO Highway_Intersections SELECT DISTINCT * FROM (SELECT Map, X_Axis as Intersection_X_Axis, Y_Axis AS Intersection_Y_Axis, Route, Waypoint_Number FROM Highways, (SELECT Map AS Junction_Map, X_Axis AS Junction_X_Axis, Y_Axis AS Junction_Y_Axis, COUNT(Route) AS Exits FROM Highways GROUP BY CONCAT(Map,'^',X_Axis,'^',Y_Axis) HAVING COUNT(Route)>1) AS Junctions WHERE Map=Junctions.Junction_Map AND X_Axis=Junctions.Junction_X_Axis AND Y_Axis=Junction_Y_Axis ORDER BY X_Axis, Y_Axis, Route) AS Table_With_Dups;

Code: Select all

drop table if exists Railway_Intersections;
CREATE TABLE `Railway_Intersections` (
`Map` varchar(50) default NULL,
`Intersection_X_Axis` int(11) default NULL,
`Intersection_Y_Axis` int(11) default NULL,
`Route` int(11) default NULL,
`Waypoint_Number` int(11) default NULL
) TYPE=InnoDB;
INSERT INTO Railway_Intersections SELECT DISTINCT * FROM (SELECT Map, X_Axis as Intersection_X_Axis, Y_Axis AS Intersection_Y_Axis, Route, Waypoint_Number FROM Railway_Waypoints, (SELECT Map AS Junction_Map, X_Axis AS Junction_X_Axis, Y_Axis AS Junction_Y_Axis, COUNT(Route) AS Exits FROM Railway_Waypoints GROUP BY CONCAT(Map,'^',X_Axis,'^',Y_Axis) HAVING COUNT(Route)>1) AS Junctions WHERE Map=Junctions.Junction_Map AND X_Axis=Junctions.Junction_X_Axis AND Y_Axis=Junction_Y_Axis ORDER BY X_Axis, Y_Axis, Route) AS Table_With_Dups;

Code: Select all

BridgeID = -Orientation - 1