2 include_once('/var/www/secure.php');
3 include_once('slack.php');
4 $id = intval($_GET['id']);
5 $q = "select * from signatures where id = '$id' ";
6 $r = $petition->query($q);
7 $d = mysqli_fetch_array($r);
8 $ip_address = $d['ip_address'];
9 $DOB = $d['date_of_birth'];
10 $SIGNED = $d['date_time_signed'];
11 $PETITION_ID = $d['petition_id'];
12 $VoterList_table = $d['VoterList_table'];
13 $signed_name_as = ucwords(strtolower($d['signed_name_as']));
14 $signed_name_as_circulator = ucwords(strtolower($d['signed_name_as_circulator']));
15 if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
16 $ip = $_SERVER['HTTP_CLIENT_IP'];
17 } elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
18 $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
20 $ip = $_SERVER['REMOTE_ADDR'];
22 if ($ip != $d['ip_address']){
23 slack_general('SECURITY INVALID: soft_copy.php '.$ip.' vs '.$d['ip_address'].' ('.$_COOKIE['invite'].')','md-petition');
27 $q2 = "select * from $VoterList_table where VTRID = '$d[VTRID]' ";
28 $r2 = $petition->query($q2);
29 $d2 = mysqli_fetch_array($r2);
30 $FIRSTNAME = $d2['FIRSTNAME'];
31 $MIDDLENAME = $d2['MIDDLENAME'];
32 $LASTNAME = $d2['LASTNAME'];
33 $ADDRESS = $d2['ADDRESS'];
34 $RESIDENTIALCITY = $d2['RESIDENTIALCITY'];
35 $COUNTY = $d2['COUNTY'];
36 $RESIDENTIALZIP5 = $d2['RESIDENTIALZIP5'];
37 $full_name = "$FIRSTNAME $MIDDLENAME $LASTNAME";
38 $address = "$ADDRESS $RESIDENTIALCITY $RESIDENTIALZIP5";
40 $contact_phone = $d2['contact_phone'];
43 $qX = "select * from petitions where petition_id = '$PETITION_ID'";
44 $rX = $petition->query($qX);
45 $dX = mysqli_fetch_array($rX);
47 $hide_county = $dX['hide_county_on_petition'];
48 $offset_x = $dX['offset_x_cords'];
49 $offset_y = $dX['offset_y_cords'];
50 $offset_x_circulator = $dX['offset_x_cords_circulator'];
51 $offset_y_circulator = $dX['offset_y_cords_circulator'];
53 // imagettftext ( resource $image , float $size , float $angle , int $x , int $y , int $color , string $fontfile , string $text )
54 // x how far from left
58 //Set the Content Type
59 header('Content-type: image/jpeg');
61 // Create Image From Existing File -- going to have to make this a reqired size??? 2550x3300
62 $jpg_image = imagecreatefromjpeg($dX['petition_jpg']);
64 // Allocate A Color For The Text
65 $black = imagecolorallocate($jpg_image, 0, 0, 0);
67 // Set Path to Font File
68 $font_path = 'files/coolvetica rg.ttf';
69 $font_path_sig = 'files/Claston Script.ttf';
71 if ($hide_county == 'NO'){
72 if ( $_COOKIE['pCOUNTY'] == 'Baltimore City'){
74 $cord = $dX['text_cord_cityX'];
75 $array = explode(",",$cord);
76 $debug = "$id : $cord : $array[0]";
77 imagettftext($jpg_image, $array[0], $array[1], $array[2], $array[3], $black, $font_path, 'X');
80 $cord = $dX['text_cord_county'];
81 $array = explode(",",$cord);
82 imagettftext($jpg_image, $array[0], $array[1], $array[2], $array[3], $black, $font_path, str_replace('County','',$_COOKIE['pCOUNTY']) );
86 imagettftext($jpg_image, 50, 0, 350+
$offset_x, 1070+
$offset_y, $black, $font_path, $full_name);
88 imagettftext($jpg_image, 70, 0, 400+
$offset_x, 1180+
$offset_y, $black, $font_path_sig, $signed_name_as);
90 imagettftext($jpg_image, 50, 0, 400+
$offset_x, 1300+
$offset_y, $black, $font_path, $address);
94 imagettftext($jpg_image, 50, 0, 1900+
$offset_x, 1070+
$offset_y, $black, $font_path, date('m d Y',strtotime($DOB)));
97 imagettftext($jpg_image, 50, 0, 1900+
$offset_x, 1200+
$offset_y, $black, $font_path, date('m d Y',strtotime($SIGNED)));
101 imagettftext($jpg_image, 40, 0, 100+
$offset_x_circulator, 2880+
$offset_y_circulator, $black, $font_path, $_COOKIE['pNAME']);
103 imagettftext($jpg_image, 40, 0, 100+
$offset_x_circulator, 2975+
$offset_y_circulator, $black, $font_path, $_COOKIE['pADDRESS1']);
105 imagettftext($jpg_image, 40, 0, 100+
$offset_x_circulator, 3065+
$offset_y_circulator, $black, $font_path, $_COOKIE['pADDRESS2']);
107 imagettftext($jpg_image, 40, 0, 100+
$offset_x_circulator, 3160+
$offset_y_circulator, $black, $font_path, $_COOKIE['pPHONE']);
109 imagettftext($jpg_image, 70, 0, 1290+
$offset_x_circulator, 3160+
$offset_y_circulator, $black, $font_path_sig, $signed_name_as_circulator);
111 imagettftext($jpg_image, 50, 0, 2150+
$offset_x_circulator, 3160+
$offset_y_circulator, $black, $font_path, date('m / d / y',strtotime($SIGNED)));
115 // Send Image to Browser
116 imagejpeg($jpg_image);
119 imagedestroy($jpg_image);