-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathrailGeocoder.php
More file actions
58 lines (55 loc) · 2.38 KB
/
railGeocoder.php
File metadata and controls
58 lines (55 loc) · 2.38 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
<?php
header('Content-type: text/xml');
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
require('includes/DB_Connection.php');
require('/home/blueghos/db.php');
$dbase = 'blueghos_bbc';
$Database = new DB_Connection();
$Database->DB_connect($db_host, $db_user, $db_pwd, $dbase);
switch($_REQUEST["queryMode"])
{
case 'location':
if (!$_REQUEST["latMin"] || !$_REQUEST["latMax"] || !$_REQUEST["lonMin"] || !$_REQUEST["lonMax"])
{
die("No query sent");
}
$sql = "SELECT * FROM `ldb_stations` WHERE `lat` >= ".$_REQUEST["latMin"]." AND `lat` <= ".$_REQUEST["latMax"]." AND `lon` >= ".$_REQUEST["lonMin"]." AND `lon` <= ".$_REQUEST["lonMax"]." LIMIT 0, 1000";
$results = $Database->DB_search($sql);
$res_text = "";
while ( $res = $Database->DB_array($results) )
{
$res_text .="\t<result code=\"".$res['code']."\" lat=\"".$res['lat']."\" lon=\"".$res['lon']."\" l_text=\"".$res['name']."\" />\n";
}
$url = 'queryMode=location&latMin=' . $_REQUEST["latMin"] . '&latMax=' . $_REQUEST["latMax"] . '&lonMin=' . $_REQUEST["lonMin"] . '&lonMax=' . $_REQUEST["lonMax"];
break;
case 'name':
default:
if (!$_REQUEST["query"])
die("No query sent");
$sql = "SELECT * FROM `ldb_stations` WHERE `name` LIKE '%".strtolower($_REQUEST["query"])."%' OR `code` LIKE '%".strtolower($_REQUEST["query"])."%' LIMIT 0, 25";
$results = $Database->DB_search($sql);
$res_text = "";
while ( $res = $Database->DB_array($results) )
{
$res_text .="\t<result code=\"".$res['code']."\" lat=\"".$res['lat']."\" lon=\"".$res['lon']."\" l_text=\"".$res['name']."\" />\n";
}
$url = 'queryMode=name&query=' . $_REQUEST["query"];
break;
}
?>
<rail_response>
<disclamimer>
<provider>Michael Pritchard (http://www.blueghost.co.uk)</provider>
<original_source>Jonathan Brown - http://bbs.keyhole.com/ubb/showflat.php/Cat/0/Number/148131/page/0/fpart/3/vc/1</original_source>
</disclamimer>
<request_details>
<original_url>http://bbc.blueghost.co.uk/railGeocoder.php?<?php echo $url;?></original_url>
<remote_addr><?php echo $_SERVER['REMOTE_ADDR'];?></remote_addr>
<referer><?php echo $_SERVER['HTTP_REFERER'];?></referer>
<queryMode><?php echo $_REQUEST["queryMode"];?></queryMode>
</request_details>
<results>
<?php echo $res_text;?>
</results>
</rail_response>