[smoothoperator] r4201 committed - Fixed

[smootho...@googlecode.com]

Revision: 4201
Author: ma...@venturevoip.com
Date: Mon Apr 15 12:02:35 2013
Log: Fixed
http://code.google.com/p/smoothoperator/source/detail?r=4201

Modified:
/SmoothOperatorCRM/script_results.php

=======================================
--- /SmoothOperatorCRM/script_results.php Mon Apr 15 12:02:02 2013
+++ /SmoothOperatorCRM/script_results.php Mon Apr 15 12:02:35 2013
@@ -108,7 +108,7 @@
}
if (0&&isset($_GET['show_lead'])) {
// $sql = "SELECT script_entries.statement, script_results.*,
customers.*, users.username, users.id, customers.id as customer_id,
script_entries.type FROM script_entries, script_results, customers, users
where date(question_datetime) between ".sanitize($_POST['from_date'])."
and ".sanitize($_POST['to_date'])." and script_results.job_id
= ".sanitize($_POST['job'])." and script_results.customer_id = customers.id
and script_results.user_id = users.id and script_entries.script_id =
script_results.script_id and script_entries.order =
script_results.question_number and customers.id
= ".sanitize($_GET['customer_id']);
- $sql = "SELECT script_entries.statement, script_results.*,
job_dispositions.text as disposition_text, customers.*, users.username,
users.id, customers.id as customer_id, script_entries.type FROM
script_entries, script_results, customers, users, customer_dispositions,
job_dispositions where date(question_datetime)
between ".sanitize($_POST['from_date'])."
and ".sanitize($_POST['to_date'])." and script_results.job_id
= ".sanitize($_POST['job'])." and script_results.customer_id = customers.id
and script_results.user_id = users.id and script_entries.script_id =
script_results.script_id and script_entries.order =
script_results.question_number and
customer_dispositions.`customer_id`=customers.id and job_dispositions.id =
disposition and job_dispositions.id in (".$dispositions.") and
customers.id = ".sanitize($_GET['customer_id'];
+ $sql = "SELECT script_entries.statement, script_results.*,
job_dispositions.text as disposition_text, customers.*, users.username,
users.id, customers.id as customer_id, script_entries.type FROM
script_entries, script_results, customers, users, customer_dispositions,
job_dispositions where date(question_datetime)
between ".sanitize($_POST['from_date'])."
and ".sanitize($_POST['to_date'])." and script_results.job_id
= ".sanitize($_POST['job'])." and script_results.customer_id = customers.id
and script_results.user_id = users.id and script_entries.script_id =
script_results.script_id and script_entries.order =
script_results.question_number and
customer_dispositions.`customer_id`=customers.id and job_dispositions.id =
disposition and job_dispositions.id in (".$dispositions.") and customers.id
= ".sanitize($_GET['customer_id']);
} else {
$sql = "SELECT script_entries.statement, script_results.*,
job_dispositions.text as disposition_text, customers.*, users.username,
users.id, customers.id as customer_id, script_entries.type FROM
script_entries, script_results, customers, users, customer_dispositions,
job_dispositions where date(question_datetime)
between ".sanitize($_POST['from_date'])."
and ".sanitize($_POST['to_date'])." and script_results.job_id
= ".sanitize($_POST['job'])." and script_results.customer_id = customers.id
and script_results.user_id = users.id and script_entries.script_id =
script_results.script_id and script_entries.order =
script_results.question_number and
customer_dispositions.`customer_id`=customers.id and job_dispositions.id =
disposition and job_dispositions.id in (".$dispositions.")";
}