function is_conference_owner($conference_id, $username) { global $log; $log->log("is_conference_owner $conference_id, $username "); if ($conference_id && $username){ change_to_conference_db($this->db); $q=" select owner_flag FROM invitees WHERE conference_id=$conference_id AND invitee_username='******'"; $res=$this->db->query($q); if (DB::isError($res)) { $log->log("QUERY FAILED $q " . $res->getMessage()); } $owner_flag = FALSE; $row = $res->fetchRow() ; if ($row[0]) { $owner_flag = TRUE; } $res->free(); change_to_default_db($this->db); return $owner_flag; } }
function mailbox_exists ($mailbox) { global $log; if (!$mailbox) { return false; } $voicemail_db = get_voicemail_db($this->db, $this->udomain); change_db($this->db, $voicemail_db); $q = "SELECT count(extension) " . " FROM VM_Users WHERE extension = " . $mailbox; $res = $this->db->query($q); if (DB::isError($res)) { $log->log("FAILED QUERY : $q",LOG_ERR); change_to_default_db($this->db); return false; } $row = $res->fetchRow(DB_FETCHMODE_ORDERED) ; $res->free(); change_to_default_db($this->db); $count = $row[0]; if ($count == 1) { return true; } else { return false; } }
function get_conference_name($domain) { global $config,$log ; if ($domain) { change_to_conference_db($this->db); $q="SELECT count(*),com.company_name FROM companies com,conferences con " . " WHERE com.domain='$domain' " . " AND com.company_id = con.company_id GROUP BY com.company_name"; $res=$this->db->query($q); if (DB::isError($res)) { $log->log("QUERY FAILED $q " . $res->getMessage()); } $row = $res->fetchRow() ; $count = $row[0] ; $company_name = $row[1]; $res->free(); if (!$count) { $q = "SELECT company_name FROM companies WHERE domain='$domain' " ; $res=$this->db->query($q); $row = $res->fetchRow() ; $company_name = $row[0]; $count =0; } $count++; $conf_name = "$company_name Conference #$count" ; $log->log("count = $count $conf_name "); change_to_default_db($this->db); return $conf_name ; } }
function get_user_conferences($conf_ids) { global $log ; $id_array = array(); $id_to_index_map = array(); for ($i = 0; $i < count($conf_ids); $i++) { $id_array[] = $conf_ids[$i][conference_id] ; $id_to_index_map[$conf_ids[$i][conference_id]] = $i; $log->log(" $i " . $conf_ids[$i][conference_id] ); } # for ($i ( $conf_ids as $h) { # } $ids = implode(',',$id_array); $q = "SELECT c.conference_id, i.invitee_id, i.invitee_email, i.invitee_code, i.invitee_name,i.invitee_username FROM conferences c, invitees i WHERE c.conference_id = i.conference_id AND c.conference_id in ($ids) "; $log->log($q); change_to_conference_db($this->db); $res=$this->db->query($q); if (DB::isError($res)) { $log->log("QUERY FAILED $q " . $res->getMessage()); } $data =array(); while ($row= $res->fetchRow(DB_FETCHMODE_ASSOC) ) { $index = $id_to_index_map[$row[conference_id]] ; $conf_ids[$index]["invitees"][] = $row; } change_to_default_db($this->db); return $conf_ids ; }
function get_user_conference($conf_id,$username) { global $log ; $q = "SELECT c.conference_id, c.conference_name, " ." date_format(c.conference_date,'%m-%d-%Y') conference_date," ." time_format(c.begin_time,'%l:%i %p' ) begin_time," ." time_format(c.end_time,'%l:%i %p' ) end_time," ." i.owner_flag, i.invitee_id, i.invitee_email, " ." i.invitee_code, i.invitee_name,i.invitee_username " ." FROM conferences c, invitees i " ." WHERE c.conference_id = i.conference_id AND c.conference_id = $conf_id "; $log->log($q); change_to_conference_db($this->db); $res=$this->db->query($q); if (DB::isError($res)) { $log->log("QUERY FAILED $q " . $res->getMessage()); } $data =array(); $user_conf = array(); $row= $res->fetchRow(DB_FETCHMODE_ASSOC) ; $user_conf['conference_id']=$conf_id; $user_conf['conference_name']=$row['conference_name'] ; $user_conf['conference_date']=$row['conference_date'] ; $user_conf['begin_time']=$row['begin_time'] ; $user_conf['end_time']=$row['end_time'] ; do { $user_conf["invitees"][] = $row; $log->log($row["invitee_username"] ."== $username"); if ($row["owner_flag"] && ( $row["invitee_username"] == $username ) ) { $log->log("owner_flag found"); $user_conf['owner_flag']=1; } $log->log("invitee_email = " . $row['invitee_email']); $log->log("owner_flag = " . $row['owner_flag']); } while ($row= $res->fetchRow(DB_FETCHMODE_ASSOC) ); change_to_default_db($this->db); return $user_conf ; }
function savePerm($new_perm) { global $log ; if ($this->mailbox && preg_match("/SUPER|ADMIN|USER/", $new_perm)) { if (!$this->voicemail_db ) { $this->voicemail_db = get_voicemail_db($this->udomain); } change_db($this->db,$this->voicemail_db ); $q="UPDATE VM_Users SET permission_id = '$new_perm' WHERE " . " extension= ". $this->mailbox; $res=$this->db->query($q); if (DB::isError($res)) { $log->log("QUERY FAILED $q " . $res->getMessage()); } change_to_default_db($this->db); } else { $log->log("ERRROR: Tried to savePerm with no extension " . $this->mailbox . " or invalid perm $new_perm"); } }