}
}
}
}
$result = array();
for ($i = 0; $i < count($data) - 1; $i++) {
if (match_analysis($data[$i]['description'])) {
if ($data[$i]['user_id'] == $data[$i + 1]['user_id']) {
array_push($result, $data[$i]);
array_push($result, $data[$i + 1]);
}
}
}
//print_r($result);
//distinct_ip_match_analysis($result);
calculate_baseline($result, $module_id, $book_id);
//////////////////////////////////////////////////////////////////////////////////////////////
function distinct_ip_match_analysis($result)
{
$user_ip = array();
$ip_record = array();
for ($i = 0; $i < count($result); $i++) {
if (!search_assoc($user_ip, $result[$i]["ip_address"])) {
$ip_record["user_id"] = $result[$i]["user_id"];
$ip_record["ip_address"] = $result[$i]["ip_address"];
array_push($user_ip, $ip_record);
}
}
print_r($user_ip);
}
function calculate_baseline($result, $module_id, $book_id)
function calculate_time_AAV($AAV_ID)
{
global $module_id;
global $start_date;
global $end_date;
global $db_server;
global $db_username;
global $db_pass;
global $db_name;
global $book_id;
$email_table = "";
$email_column = "";
if ($book_id == "VT") {
$email_table = "CS3114VTRoster";
$email_column = "user_email";
} else {
if ($book_id == "CNP") {
$email_table = "CNPRoster";
$email_column = "email";
}
}
$query = "SELECT * \r\n FROM `opendsa_userbutton` A INNER JOIN `auth_user` B ON\r\n A.user_id = B.id \r\n WHERE email IN \r\n (Select {$email_column} from {$email_table}) \r\n AND module_id = {$module_id}\r\n AND action_time BETWEEN '{$start_date}' AND '{$end_date}'\r\n ORDER BY email, action_time, A.id";
$data = array();
if (@mysql_connect($db_server, $db_username, $db_pass)) {
if (@mysql_select_db($db_name)) {
if ($query_run = mysql_query($query)) {
while ($query_result = mysql_fetch_assoc($query_run)) {
array_push($data, $query_result);
}
}
}
}
$result = array();
$first_record = null;
for ($i = 0; $i < count($data); $i++) {
if ($data[$i]['exercise_id'] == $AAV_ID && !isset($first_record)) {
$first_record = $data[$i];
$start_session = true;
}
//The first Interaction is captured
if (isset($first_record)) {
if ($data[$i]["email"] != $first_record["email"]) {
//Return back one record and add it
array_push($result, $first_record, $data[$i - 1]);
//Check if the new user's Interaction is AAV
if ($data[$i]["exercise_id"] == $AAV_ID) {
$first_record = $data[$i];
} else {
$first_record = null;
}
} else {
if ($data[$i]["email"] == $first_record["email"] && $data[$i]["exercise_id"] != $first_record["exercise_id"]) {
//Return back one record
array_push($result, $first_record, $data[$i]);
$first_record = null;
}
}
//If the last intearction is an AAV interction
if ($i == count($data) - 1) {
array_push($result, $first_record, $data[$i]);
}
}
}
//print_r($result);
calculate_baseline($result, $AAV_ID);
}