Job Advisories

'."\n"; print ''."\n"; print ''."\n"; print 'Job Advisories'."\n"; print ''."\n"; print ''."\n"; print ''."\n"; $debug = print_r($_GET,1); if(isset($_GET['v'])) { $code = preg_replace('/[^0-9A-Z]+/', '', strtoupper($_GET['v'])); if(strlen($code) == 6) { $q = mysql_query("SELECT `database_name` FROM `clients` WHERE `garage_sms_code` = '".preg_replace('/[^A-Z]+/', '', strtoupper($_GET['g']))."';", $conn) OR print mysql_error(); if(mysql_num_rows($q) > 0) { $r = mysql_fetch_object($q); mysql_select_db('gg_'.$r->database_name, $conn); } else { //log and exit exit; } $j=0; $q = mysql_query("SELECT *, UNIX_TIMESTAMP(advisory_due) as adv_due FROM `advisories` INNER JOIN `job_menu` ON advisories.job_item_id = job_menu.job_menu_id INNER JOIN `vehicles` ON advisories.vehicle_id = vehicles.vehicle_id INNER JOIN `customers` ON vehicles.customer_id = customers.customer_id WHERE vehicles.advisory_code = '".$code."' ORDER BY advisory_due;") or die(mysql_error()); if(mysql_num_rows($q) > 0) { print '

'; while($r = mysql_fetch_assoc($q)) { if($j === 0) print 'Hello '.$r['title'].' '.$r['surname'].',

The following jobs are listed for your '.$r['make'].' '.$r['model'].':

'.$r['job_name'].' (due on '.date('jS M y', $r['adv_due']).')

'; } else print 'No Jobs Found'; } else print 'Invalid SMS Code'; mail('dean@libritech.com','Advisory Lookup Script',ob_get_contents().'

'.$debug.'

','Content-Type: text/html'."\r\n"); } else { print ''."\n"; print '

'."\n"; } print ''."\n"; //log_event('request.log', 'Activation Failed, Licence Key: '.$_POST['licence']); } else header('Location: http://www.gurusoftware.co.uk/'); ?>