escape($db -> cipher($decoded, false)); // $request_info = $db -> return_result("SELECT tb.is_downloadable, // ( // IF( // (SELECT DATEDIFF(tb.expire,NOW()) < 0),'3', // IF( // (SELECT count(id) FROM `request_status` WHERE request_id = tb.id AND `status` = 2) = 0 , // IF( // (SELECT count(id) FROM `request_status` WHERE request_id = tb.id AND `status` = 0) = 0 , // '1', // '0' // ), // '2' // ) // ) // ) // as status FROM `text_blast` tb // /*INNER JOIN report_type rt // ON r.report_type_id = rt.id */ // WHERE tb.control_number = '".$decoded."' "); // foreach($request_info as $request_info_data){ // $check_request = $request_info_data['status']; // $is_downloadable = $request_info_data['is_downloadable']; // } $is_downloadable = 1; // if(!$utility->isNotEmpty($check_request) || intval($check_request) <> 1){ // header('location: requested_sms_service.php'); // return; // } ?> Thank You Message Report