-
Notifications
You must be signed in to change notification settings - Fork 0
/
countyfreqs.php
69 lines (61 loc) · 2.02 KB
/
countyfreqs.php
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
59
60
61
62
63
64
65
66
67
68
69
<?php
// countyfreqs.php
// $Revision: 1.0 $ - $Date: 2010-04-12 09:33:07-04 $
//
// Create image of state with county frquencies
//
include('includes/session.inc');
include('includes/functions.inc');
// Open the database
$db = mysql_connect($host , $dbuser, $dbpassword);
mysql_select_db($DatabaseName,$db);
// Create the background wallpaper
$image = imagecreatefrompng("county_freqs-pl.png");
// Attributes for the frequencies
$white = ImageColorAllocate( $image, 255,255,255 );
$black = ImageColorAllocate( $image, 0,0,0 );
$shadow = ImageColorAllocate( $image, 128, 128, 128 );
$d1color = ImageColorAllocate( $image, 255,0,0 );
$d2color = ImageColorAllocate( $image, 0,128,128 );
$d3color = ImageColorAllocate( $image, 0,0,192 );
$d5color = ImageColorAllocate( $image, 192,128,0 );
$d6color = ImageColorAllocate( $image, 128,192,0 );
$d7color = ImageColorAllocate( $image, 192,0,192 );
$freqfont = 5;
// Get the data
$SQL="SELECT A.`x`,A.`y`,A.`frequency`,B.`district`,A.`valid` " .
"FROM `county_freqs` A, `arpsc_counties` B " .
"WHERE A.`county`=B.`countycode`";
$res=getResult($SQL,$db);
// Print the frequencies on the image
while( $row = getRow( $res ) )
{
// Only valid data
if ( $row[4] )
{
// Use a separate color for each district
$fcolor=$black;
if ( $row[3] == 1 )
$fcolor=$d1color;
if ( $row[3] == 2 )
$fcolor=$d2color;
if ( $row[3] == 3 )
$fcolor=$d3color;
if ( $row[3] == 5 )
$fcolor=$d5color;
if ( $row[3] == 6 )
$fcolor=$d6color;
if ( $row[3] == 7 )
$fcolor=$d7color;
// Colored text on top of highlight/shadow
ImageString( $image, $freqfont, $row[0]-2, $row[1]+1, $row[2], $white);
ImageString( $image, $freqfont, $row[0]-1, $row[1]+1, $row[2], $white);
ImageString( $image, $freqfont, $row[0]+1, $row[1]-1, $row[2], $shadow);
ImageString( $image, $freqfont, $row[0]+2, $row[1]-1, $row[2], $shadow);
ImageString( $image, $freqfont, $row[0], $row[1], $row[2], $fcolor);
}
}
// Finally, actually expose the image
header('Content-type: image/png');
ImagePNG($image);
?>