= 0 AND status = 1 AND operatorid = 0 OR '; } $sth = $jakdb->pdo->prepare("SELECT id, operatorid, answered, updated, transferid, transfermsg FROM ".JAKDB_PREFIX."sessions WHERE ".$sqlw."operatorid = :oid AND status = 1 OR department = 0 AND status = 1 AND operatorid = 0 OR transferid = :oid AND status = 1"); $sth->bindParam(':depid', $_SESSION['usr_department'], PDO::PARAM_INT); $sth->bindParam(':oid', $_GET['id'], PDO::PARAM_INT); $sth->execute(); $result = $sth->fetchAll(); if (isset($result) && !empty($result)) { foreach ($result as $row) { // We have a transfer, need to display it! if ($row['transferid'] == $_GET['id']) { if ($row["transfermsg"]) $split_transfer_msg = explode(':#:', $row["transfermsg"]); // Display underneath the button $transfer_msg = '

'.$split_transfer_msg[1].'

'; $transferid = $row['transferid']; } $newConv = 0; // check for new conversations if ($row['operatorid'] == 0) { $newConv = 1; } if ($row['operatorid'] > 0 && ($row['updated'] > $row['answered'])) { $newConv = 2; } } echo json_encode(array('newc' => $newConv, 'tid' => $transferid, 'tmsg' => $transfer_msg)); } else { echo json_encode(array('newc' => 0, 'tid' => 0, 'tmsg' => 0)); } ?>