Issues in BrowseCitiesPage.php (master) - Issues in master - sunnysideup/silverstripe-geobrowser - Measure and Improve Code Quality continuously with Scrutinizer

Issues (72)

Security Analysis not enabled

Cross-Site Scripting

Cross-Site Scripting enables an attacker to inject code into the response of a web-request that is viewed by other users. It can for example be used to bypass access controls, or even to take over other users' accounts.

File Exposure

File Exposure allows an attacker to gain access to local files that he should not be able to access. These files can for example include database credentials, or other configuration files.

File Manipulation

File Manipulation enables an attacker to write custom data to files. This potentially leads to injection of arbitrary code on the server.

Object Injection

Object Injection enables an attacker to inject an object into PHP code, and can lead to arbitrary code execution, file exposure, or file manipulation attacks.

Code Injection

Code Injection enables an attacker to execute arbitrary code on the server.

Response Splitting

Response Splitting can be used to send arbitrary responses.

File Inclusion

File Inclusion enables an attacker to inject custom files into PHP's file loading mechanism, either explicitly passed to include, or for example via PHP's auto-loading mechanism.

Command Injection

Command Injection enables an attacker to inject a shell command that is execute with the privileges of the web-server. This can be used to expose sensitive data, or gain access of your server.

SQL Injection

SQL Injection enables an attacker to execute arbitrary SQL code on your database server gaining access to user data, or manipulating user data.

XPath Injection

XPath Injection enables an attacker to modify the parts of XML document that are read. If that XML document is for example used for authentication, this can lead to further vulnerabilities similar to SQL Injection.

LDAP Injection

LDAP Injection enables an attacker to inject LDAP statements potentially granting permission to run unauthorized queries, or modify content inside the LDAP tree.

Header Injection

Other Vulnerability

This category comprises other attack vectors such as manipulating the PHP runtime, loading custom extensions, freezing the runtime, or similar.

Regex Injection

Regex Injection enables an attacker to execute arbitrary code in your PHP process.

XML Injection

XML Injection enables an attacker to read files on your local filesystem including configuration files, or can be abused to freeze your web-server process.

Variable Injection

Variable Injection enables an attacker to overwrite program variables with custom data, and can lead to further vulnerabilities.

Unfortunately, the security analysis is currently not available for your project. If you are a non-commercial open-source project, please contact support to gain access.

code/BrowseCitiesPage.php (10 issues)

Labels

Severity

Upgrade to new PHP Analysis Engine

These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more

<?php

class BrowseCitiesPage extends BrowseAbstractPage
{

    /**
     * Standard SS static
     **/
    public static $icon = "geobrowser/images/treeicons/BrowseCitiesPage";

    /**
     * Standard SS static
     **/
    public static $default_parent = "BrowseRegionsPage";

    /**
     * Standard SS static
     **/
    public static $can_be_root = false;

    /**
     * Standard SS static
     **/
    public static $db = array(
        "Latitude" => "Double",
        "Longitude" => "Double",
        "TimeZone"=> "Varchar(10)",
        "County" => "Varchar(25)",
        "Code" => "Varchar(4)",
    );

    /**
     * Standard SS Static
     **/
    public static $defaults = array(
        "ShowInMenus" => false
    );
    
    /**
     * @param Array - $googleMapAddressArray: an array of geographic data provided by google maps
     * @param Int - $maxRadius: maximum number of kilometers (as the bird flies) between search point defined in $googleMapAddressArray and city found.
     * @return Object | false : returns a BrowseCitiesPage or false if nothing was found
     **/
    public static function get_clostest_city_page($googleMapAddressArray, $maxRadius = 500)
    {
        $cityPage = null;
        $suburbPage    = null;
        $bt = defined('DB::USE_ANSI_SQL') ? "\"" : "`";
        $existingDistance = $maxRadius+1;
        $newDistance = $maxRadius+1;
        $existingPage = null;
        $newPage = null;
        $radiusSelectionSQL = self::radiusDefinitionOtherTable($googleMapAddressArray[0], $googleMapAddressArray[1], "BrowseCitiesPage", "Latitude", "Longitude");
        $sqlQuery = new SQLQuery();
        $sqlQuery->select = array("{$bt}BrowseCitiesPage{$bt}.{$bt}ID{$bt}, ". $radiusSelectionSQL." as distance");
        $sqlQuery->from[] = "{$bt}BrowseCitiesPage{$bt}";
        $sqlQuery->where[] = $radiusSelectionSQL . " < ".$maxRadius;
        $sqlQuery->orderby = " distance ";
        $sqlQuery->limit = "1";
        $result = $sqlQuery->execute();
        $page = null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        foreach ($result as $row) {
            $existingDistance = $row["distance"];
            $existingPage = DataObject::get_by_id("BrowseCitiesPage", $row["ID"]);
        }
        $radiusSelectionSQL = self::radiusDefinitionOtherTable($googleMapAddressArray[0], $googleMapAddressArray[1], "cities", "Latitude", "Longitude");
        $sqlQuery = new SQLQuery();
        $sqlQuery->select = array("cities.CityID", $radiusSelectionSQL." as distance");
        $sqlQuery->from[] = "{$bt}cities{$bt}";
        $sqlQuery->where[] = $radiusSelectionSQL . " < ".$maxRadius;
        $sqlQuery->orderby = " distance ";
        $sqlQuery->limit = "1";
        $result = $sqlQuery->execute();
        foreach ($result as $row) {
            $sameOne = false;
            if ($existingPage) {
                if ($row["CityID"] == $existingPage->HiddenDataID) {
                    $sameOne = true;
                }
            }
            if (!$sameOne) {
                $newPage = self::create_city_and_parents($row["CityID"]);
                $newDistance = $row["distance"];
            }
        }
        if (($newPage) && ($newDistance < $existingDistance) &&  ($newDistance < $maxRadius)) {
            $cityPage = $newPage;
        } elseif ($existingPage && $existingDistance < $maxRadius) {
            $cityPage = $existingPage;
        }
        if ($cityPage) {
            if ($cityPage->allowBrowseChildren()) {
                $suburbPage = BrowseSuburbPage::create_suburb($googleMapAddressArray, $cityPage);
            }
        }
        if ($suburbPage) {
            return $suburbPage;
        }
        return $cityPage;
    }

    /**
     * formulae for working out distance
     **/
    protected static function radiusDefinitionOtherTable($lon, $lat, $table, $latitudeField, $longitudeField)
    {
        $bt = defined('DB::USE_ANSI_SQL') ? "\"" : "`";
        return "(6378.137 * ACOS( ( SIN( PI( ) * ".$lat." /180 ) * SIN( PI( ) * {$bt}".$table."{$bt}.{$bt}".$latitudeField."{$bt} /180 ) ) + ( COS( PI( ) * ".$lat." /180 ) * cos( PI( ) * {$bt}".$table."{$bt}.{$bt}".$latitudeField."{$bt} /180 ) * COS( (PI( ) * {$bt}".$table."{$bt}.{$bt}".$longitudeField."{$bt} /180 ) - ( PI( ) *".$lon." /180 ) ) ) ) ) ";
    }

    /**
     * name for page level.
     **/
    public function GeoLevelName()
    {
        return "Cities";
    }
    
    /**
     * number for page level.
     **/
    public function GeoLevelNumber()
    {
        return 3;
    }
    
    /**
     * This static method creates a city page and all the required parent pages...
     *@param Int - $CityID: the ID for the city to create
     **/
    public static function create_city_and_parents($CityID)
    {
        $cityPage = null;
        //check if the city exists at all
        $sql = '
			SELECT cities.RegionID, regions.CountryID, countries.ContinentID From cities, regions, countries, continents
			WHERE
				cities.RegionID = regions.RegionID AND
				regions.CountryID = countries.CountryID AND
				countries.ContinentID = continents.ContinentID AND
				cities.CityID = '.$CityID.'
			LIMIT 1;';
        $result = DB::query($sql);

        foreach ($result as $row) {
            break;
        }
        $abstractHelpPage = new BrowseAbstractPage();
        if ($row) {
            //1 check if world exists
            if ($worldPage = DataObject::get_one("BrowseWorldPage")) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                //do nothing
            } else {
                $worldPage = new BrowseWorldPage();
                $name = "Find";
                $worldPage->Title = $name;
                $worldPage->MetaTitle = $name;
                $worldPage->MenuTitle = $name;
                $worldPage->writeToStage('Stage');
                $worldPage->publish('Stage', 'Live');
                $worldPage->flushCache();
            }

            //2 check if continent exists
            $ContinentID = $row["ContinentID"];
            if ($continentPage = DataObject::get_one("BrowseContinentsPage", 'HiddenDataID = '.$ContinentID)) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                //debug::show("continent exists");

            } else {
                //create continent
                $continents = $abstractHelpPage->getDataFromTable("continents", "ContinentID = ".$ContinentID, null);
                foreach ($continents as $continentData) {
                    $continentPage = new BrowseContinentsPage();
                    $continentPage->CreateContinent($continentData, $worldPage);
                }
            }

            //3 check if country exists
            $CountryID = $row["CountryID"];
            if ($countryPage = DataObject::get_one("BrowseCountriesPage", 'HiddenDataID = '.$CountryID)) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                //debug::show("country exists");

            } else {
                //create Country
                $countries = $abstractHelpPage->getDataFromTable("countries", "CountryID = ".$CountryID, null);
                foreach ($countries as $countryData) {
                    $countryPage = new BrowseCountriesPage();
                    $countryPage->CreateCountry($countryData, $continentPage);
                }
            }

            //4 check if region exists
            $RegionID = $row["RegionID"];
            if ($regionPage = DataObject::get_one("BrowseRegionsPage", 'HiddenDataID = '.$RegionID)) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                //debug::show("region exists");

            } else {
                //create region
                $regions = $abstractHelpPage->getDataFromTable("regions", "RegionID = ".$RegionID, null);
                foreach ($regions as $regionData) {
                    $regionPage = new BrowseRegionsPage();
                    $regionPage->CreateRegion($regionData, $countryPage);
                }
            }
            if ($cityPage = DataObject::get_one("BrowseCitiesPage", 'HiddenDataID = '.$CityID)) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                //debug::show("city exists");

            } else {
                //create region
                $cities = $abstractHelpPage->getDataFromTable("cities", "CityID = ".$CityID, null);
                foreach ($cities as $city) {
                    $cityPage = new BrowseCitiesPage();
                    $cityPage->CreateCity($city, $regionPage);
                }
            }
        }
        return $cityPage;
    }

    /**
     * fix URLS
     * NOTE: you must set get variables: urls, from and to....
     **/
    public function requireDefaultRecords()
    {
        parent::requireDefaultRecords();
        if (isset($_GET["urls"]) && isset($_GET["from"]) && isset($_GET["to"])) {
            $dos = DataObject::get("SiteTree", null, null, null, $_GET["from"].','.$_GET["to"]);
            foreach ($dos as $page) {
                if (isset($page)) {
                    echo "<li>fixing ".$page->Title."</li>";
                    $page->URLSegment = $this->generateURLSegment($page->Title);
                    $page->writeToStage('Stage');
                    $page->publish('Stage', 'Live');
                    $page->flushCache();
                    $page->detroy();
                }
            }
        }
    }

    /**
     * Create a page
     * @param Array - $city: the data for the city
     * @param Object $parent: BrowseRegionsPage
     **/
    public function CreateCity(array $city, BrowseRegionsPage $parent)
    {
        if ($parent && isset($city["City"])) {
            $name = htmlentities($city["City"]);
            if (isset($name)) {
                if (isset($_GET["geobuild"])) {
                    echo "<li>creating ".$name."</li>";
                }
                $this->ParentID = $parent->ID;
                $this->Title = $name;
                $this->MetaTitle = $name;
                $this->MenuTitle = $name;
                $this->HiddenDataID = $city["CityID"];

                $this->Code = $city["Code"];
                $this->Latitude = $city["Latitude"];
                $this->Longitude = $city["Longitude"];
                $this->TimeZone = $city["TimeZone"];
                $this->County = htmlentities($city["County"]);
                $this->Code = $city["Code"];

                $this->CreateChildren = $parent->CreateAllChildren;
                $this->CreateAllChildren = $parent->CreateAllChildren;

                $this->URLSegment = $this->generateURLSegment($this->Title);

                $this->writeToStage('Stage');
                $this->publish('Stage', 'Live');
                $this->flushCache();
            } else {
                if (isset($_GET["geobuild"])) {
                    debug::show("No name can be found");
                }
            }
        } else {
            if (isset($_GET["geobuild"])) {
                debug::show("Parent does not exist");
            }
        }
    }
}

class BrowseCitiesPage_Controller extends BrowseAbstractPage_Controller
{
}


1		<?php
2
3		class BrowseCitiesPage extends BrowseAbstractPage
4		{
5
6		/**
7		* Standard SS static
8		**/
9		public static $icon = "geobrowser/images/treeicons/BrowseCitiesPage";
10
11		/**
12		* Standard SS static
13		**/
14		public static $default_parent = "BrowseRegionsPage";
15
16		/**
17		* Standard SS static
18		**/
19		public static $can_be_root = false;
20
21		/**
22		* Standard SS static
23		**/
24		public static $db = array(
25		"Latitude" => "Double",
26		"Longitude" => "Double",
27		"TimeZone"=> "Varchar(10)",
28		"County" => "Varchar(25)",
29		"Code" => "Varchar(4)",
30		);
31
32		/**
33		* Standard SS Static
34		**/
35		public static $defaults = array(
36		"ShowInMenus" => false
37		);
38
39		/**
40		* @param Array - $googleMapAddressArray: an array of geographic data provided by google maps
41		* @param Int - $maxRadius: maximum number of kilometers (as the bird flies) between search point defined in $googleMapAddressArray and city found.
42		* @return Object \| false : returns a BrowseCitiesPage or false if nothing was found
43		**/
44		public static function get_clostest_city_page($googleMapAddressArray, $maxRadius = 500)
45		{
46		$cityPage = null;
47		$suburbPage = null;
48		$bt = defined('DB::USE_ANSI_SQL') ? "\"" : "`";
49		$existingDistance = $maxRadius+1;
50		$newDistance = $maxRadius+1;
51		$existingPage = null;
52		$newPage = null;
53		$radiusSelectionSQL = self::radiusDefinitionOtherTable($googleMapAddressArray[0], $googleMapAddressArray[1], "BrowseCitiesPage", "Latitude", "Longitude");
54		$sqlQuery = new SQLQuery();
55		$sqlQuery->select = array("{$bt}BrowseCitiesPage{$bt}.{$bt}ID{$bt}, ". $radiusSelectionSQL." as distance");
56		$sqlQuery->from[] = "{$bt}BrowseCitiesPage{$bt}";
57		$sqlQuery->where[] = $radiusSelectionSQL . " < ".$maxRadius;
58		$sqlQuery->orderby = " distance ";
59		$sqlQuery->limit = "1";
60		$result = $sqlQuery->execute();
61		$page = null;
		0 ignored issues – show Unused Code introduced 2017-01-03 01:19 UTC by Report Bug Copy Issue Report Show Similar Issues like this `$page` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
62		foreach ($result as $row) {
63		$existingDistance = $row["distance"];
64		$existingPage = DataObject::get_by_id("BrowseCitiesPage", $row["ID"]);
65		}
66		$radiusSelectionSQL = self::radiusDefinitionOtherTable($googleMapAddressArray[0], $googleMapAddressArray[1], "cities", "Latitude", "Longitude");
67		$sqlQuery = new SQLQuery();
68		$sqlQuery->select = array("cities.CityID", $radiusSelectionSQL." as distance");
69		$sqlQuery->from[] = "{$bt}cities{$bt}";
70		$sqlQuery->where[] = $radiusSelectionSQL . " < ".$maxRadius;
71		$sqlQuery->orderby = " distance ";
72		$sqlQuery->limit = "1";
73		$result = $sqlQuery->execute();
74		foreach ($result as $row) {
75		$sameOne = false;
76		if ($existingPage) {
77		if ($row["CityID"] == $existingPage->HiddenDataID) {
78		$sameOne = true;
79		}
80		}
81		if (!$sameOne) {
82		$newPage = self::create_city_and_parents($row["CityID"]);
83		$newDistance = $row["distance"];
84		}
85		}
86		if (($newPage) && ($newDistance < $existingDistance) && ($newDistance < $maxRadius)) {
87		$cityPage = $newPage;
88		} elseif ($existingPage && $existingDistance < $maxRadius) {
89		$cityPage = $existingPage;
90		}
91		if ($cityPage) {
92		if ($cityPage->allowBrowseChildren()) {
93		$suburbPage = BrowseSuburbPage::create_suburb($googleMapAddressArray, $cityPage);
94		}
95		}
96		if ($suburbPage) {
97		return $suburbPage;
98		}
99		return $cityPage;
100		}
101
102		/**
103		* formulae for working out distance
104		**/
105		protected static function radiusDefinitionOtherTable($lon, $lat, $table, $latitudeField, $longitudeField)
106		{
107		$bt = defined('DB::USE_ANSI_SQL') ? "\"" : "`";
108		return "(6378.137 * ACOS( ( SIN( PI( ) * ".$lat." /180 ) * SIN( PI( ) * {$bt}".$table."{$bt}.{$bt}".$latitudeField."{$bt} /180 ) ) + ( COS( PI( ) * ".$lat." /180 ) * cos( PI( ) * {$bt}".$table."{$bt}.{$bt}".$latitudeField."{$bt} /180 ) * COS( (PI( ) * {$bt}".$table."{$bt}.{$bt}".$longitudeField."{$bt} /180 ) - ( PI( ) *".$lon." /180 ) ) ) ) ) ";
109		}
110
111		/**
112		* name for page level.
113		**/
114		public function GeoLevelName()
115		{
116		return "Cities";
117		}
118
119		/**
120		* number for page level.
121		**/
122		public function GeoLevelNumber()
123		{
124		return 3;
125		}
126
127		/**
128		* This static method creates a city page and all the required parent pages...
129		*@param Int - $CityID: the ID for the city to create
130		**/
131		public static function create_city_and_parents($CityID)
132		{
133		$cityPage = null;
134		//check if the city exists at all
135		$sql = '
136		SELECT cities.RegionID, regions.CountryID, countries.ContinentID From cities, regions, countries, continents
137		WHERE
138		cities.RegionID = regions.RegionID AND
139		regions.CountryID = countries.CountryID AND
140		countries.ContinentID = continents.ContinentID AND
141		cities.CityID = '.$CityID.'
142		LIMIT 1;';
143		$result = DB::query($sql);
144
145		foreach ($result as $row) {
146		break;
147		}
148		$abstractHelpPage = new BrowseAbstractPage();
149		if ($row) {
150		//1 check if world exists
151		if ($worldPage = DataObject::get_one("BrowseWorldPage")) {
		0 ignored issues – show Unused Code introduced 2017-01-03 01:19 UTC by Report Bug Copy Issue Report Show Similar Issues like this This `if` statement is empty and can be removed. This check looks for the bodies of `if` statements that have no statements or where all statements have been commented out. This may be the result of changes for debugging or the code may simply be obsolete. These `if` bodies can be removed. If you have an empty if but statements in the `else` branch, consider inverting the condition. if (rand(1, 6) > 3) { //print "Check failed"; } else { print "Check succeeded"; } could be turned into if (rand(1, 6) <= 3) { print "Check succeeded"; } This is much more concise to read. Loading history...
152		//do nothing
153		} else {
154		$worldPage = new BrowseWorldPage();
155		$name = "Find";
156		$worldPage->Title = $name;
157		$worldPage->MetaTitle = $name;
158		$worldPage->MenuTitle = $name;
159		$worldPage->writeToStage('Stage');
160		$worldPage->publish('Stage', 'Live');
161		$worldPage->flushCache();
162		}
163
164		//2 check if continent exists
165		$ContinentID = $row["ContinentID"];
166	View Code Duplication	if ($continentPage = DataObject::get_one("BrowseContinentsPage", 'HiddenDataID = '.$ContinentID)) {
		0 ignored issues – show Unused Code introduced 2017-01-03 01:19 UTC by Report Bug Copy Issue Report Show Similar Issues like this This `if` statement is empty and can be removed. This check looks for the bodies of `if` statements that have no statements or where all statements have been commented out. This may be the result of changes for debugging or the code may simply be obsolete. These `if` bodies can be removed. If you have an empty if but statements in the `else` branch, consider inverting the condition. if (rand(1, 6) > 3) { //print "Check failed"; } else { print "Check succeeded"; } could be turned into if (rand(1, 6) <= 3) { print "Check succeeded"; } This is much more concise to read. Loading history...
167		//debug::show("continent exists");
		0 ignored issues – show Unused Code Comprehensibility introduced 2017-01-03 01:19 UTC by Report Bug Copy Issue Report Show Similar Issues like this `72%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
168		} else {
169		//create continent
170		$continents = $abstractHelpPage->getDataFromTable("continents", "ContinentID = ".$ContinentID, null);
171		foreach ($continents as $continentData) {
172		$continentPage = new BrowseContinentsPage();
173		$continentPage->CreateContinent($continentData, $worldPage);
174		}
175		}
176
177		//3 check if country exists
178		$CountryID = $row["CountryID"];
179	View Code Duplication	if ($countryPage = DataObject::get_one("BrowseCountriesPage", 'HiddenDataID = '.$CountryID)) {
		0 ignored issues – show Unused Code introduced 2017-01-03 01:19 UTC by Report Bug Copy Issue Report Show Similar Issues like this This `if` statement is empty and can be removed. This check looks for the bodies of `if` statements that have no statements or where all statements have been commented out. This may be the result of changes for debugging or the code may simply be obsolete. These `if` bodies can be removed. If you have an empty if but statements in the `else` branch, consider inverting the condition. if (rand(1, 6) > 3) { //print "Check failed"; } else { print "Check succeeded"; } could be turned into if (rand(1, 6) <= 3) { print "Check succeeded"; } This is much more concise to read. Loading history...
180		//debug::show("country exists");
		0 ignored issues – show Unused Code Comprehensibility introduced 2017-01-03 01:19 UTC by Report Bug Copy Issue Report Show Similar Issues like this `72%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
181		} else {
182		//create Country
183		$countries = $abstractHelpPage->getDataFromTable("countries", "CountryID = ".$CountryID, null);
184		foreach ($countries as $countryData) {
185		$countryPage = new BrowseCountriesPage();
186		$countryPage->CreateCountry($countryData, $continentPage);
187		}
188		}
189
190		//4 check if region exists
191		$RegionID = $row["RegionID"];
192	View Code Duplication	if ($regionPage = DataObject::get_one("BrowseRegionsPage", 'HiddenDataID = '.$RegionID)) {
		0 ignored issues – show Unused Code introduced 2017-01-03 01:19 UTC by Report Bug Copy Issue Report Show Similar Issues like this This `if` statement is empty and can be removed. This check looks for the bodies of `if` statements that have no statements or where all statements have been commented out. This may be the result of changes for debugging or the code may simply be obsolete. These `if` bodies can be removed. If you have an empty if but statements in the `else` branch, consider inverting the condition. if (rand(1, 6) > 3) { //print "Check failed"; } else { print "Check succeeded"; } could be turned into if (rand(1, 6) <= 3) { print "Check succeeded"; } This is much more concise to read. Loading history...
193		//debug::show("region exists");
		0 ignored issues – show Unused Code Comprehensibility introduced 2017-01-03 01:19 UTC by Report Bug Copy Issue Report Show Similar Issues like this `72%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
194		} else {
195		//create region
196		$regions = $abstractHelpPage->getDataFromTable("regions", "RegionID = ".$RegionID, null);
197		foreach ($regions as $regionData) {
198		$regionPage = new BrowseRegionsPage();
199		$regionPage->CreateRegion($regionData, $countryPage);
200		}
201		}
202	View Code Duplication	if ($cityPage = DataObject::get_one("BrowseCitiesPage", 'HiddenDataID = '.$CityID)) {
		0 ignored issues – show Unused Code introduced 2017-01-03 01:19 UTC by Report Bug Copy Issue Report Show Similar Issues like this This `if` statement is empty and can be removed. This check looks for the bodies of `if` statements that have no statements or where all statements have been commented out. This may be the result of changes for debugging or the code may simply be obsolete. These `if` bodies can be removed. If you have an empty if but statements in the `else` branch, consider inverting the condition. if (rand(1, 6) > 3) { //print "Check failed"; } else { print "Check succeeded"; } could be turned into if (rand(1, 6) <= 3) { print "Check succeeded"; } This is much more concise to read. Loading history...
203		//debug::show("city exists");
		0 ignored issues – show Unused Code Comprehensibility introduced 2017-01-03 01:19 UTC by Report Bug Copy Issue Report Show Similar Issues like this `72%` of this comment could be valid code. Did you maybe forget this after debugging? Sometimes obsolete code just ends up commented out instead of removed. In this case it is better to remove the code once you have checked you do not need it. The code might also have been commented out for debugging purposes. In this case it is vital that someone uncomments it again or your project may behave in very unexpected ways in production. This check looks for comments that seem to be mostly valid code and reports them. Loading history...
204		} else {
205		//create region
206		$cities = $abstractHelpPage->getDataFromTable("cities", "CityID = ".$CityID, null);
207		foreach ($cities as $city) {
208		$cityPage = new BrowseCitiesPage();
209		$cityPage->CreateCity($city, $regionPage);
210		}
211		}
212		}
213		return $cityPage;
214		}
215
216		/**
217		* fix URLS
218		* NOTE: you must set get variables: urls, from and to....
219		**/
220		public function requireDefaultRecords()
221		{
222		parent::requireDefaultRecords();
223		if (isset($_GET["urls"]) && isset($_GET["from"]) && isset($_GET["to"])) {
224		$dos = DataObject::get("SiteTree", null, null, null, $_GET["from"].','.$_GET["to"]);
225		foreach ($dos as $page) {
226		if (isset($page)) {
227		echo "<li>fixing ".$page->Title."</li>";
228		$page->URLSegment = $this->generateURLSegment($page->Title);
229		$page->writeToStage('Stage');
230		$page->publish('Stage', 'Live');
231		$page->flushCache();
232		$page->detroy();
233		}
234		}
235		}
236		}
237
238		/**
239		* Create a page
240		* @param Array - $city: the data for the city
241		* @param Object $parent: BrowseRegionsPage
242		**/
243		public function CreateCity(array $city, BrowseRegionsPage $parent)
244		{
245		if ($parent && isset($city["City"])) {
246		$name = htmlentities($city["City"]);
247		if (isset($name)) {
248		if (isset($_GET["geobuild"])) {
249		echo "<li>creating ".$name."</li>";
250		}
251		$this->ParentID = $parent->ID;
252		$this->Title = $name;
253		$this->MetaTitle = $name;
254		$this->MenuTitle = $name;
255		$this->HiddenDataID = $city["CityID"];
256
257		$this->Code = $city["Code"];
258		$this->Latitude = $city["Latitude"];
259		$this->Longitude = $city["Longitude"];
260		$this->TimeZone = $city["TimeZone"];
261		$this->County = htmlentities($city["County"]);
262		$this->Code = $city["Code"];
263
264		$this->CreateChildren = $parent->CreateAllChildren;
265		$this->CreateAllChildren = $parent->CreateAllChildren;
266
267		$this->URLSegment = $this->generateURLSegment($this->Title);
268
269		$this->writeToStage('Stage');
270		$this->publish('Stage', 'Live');
271		$this->flushCache();
272		} else {
273		if (isset($_GET["geobuild"])) {
274		debug::show("No name can be found");
275		}
276		}
277		} else {
278		if (isset($_GET["geobuild"])) {
279		debug::show("Parent does not exist");
280		}
281		}
282		}
283		}
284
285		class BrowseCitiesPage_Controller extends BrowseAbstractPage_Controller
286		{
287		}
288

sunnysideup / silverstripe-geobrowser

Issues (72)

Security Analysis not enabled

code/BrowseCitiesPage.php (10 issues)

Labels

Severity

Introduced By

Upgrade to new PHP Analysis Engine

Duplication Side-by-Side

Filter issues like