+ return false;
+ }
+
+ // File put was successful. Store file attributes locally.
+ $entity_type = $mdb2->quote($fields['entity_type']);
+ $entity_id = (int) $fields['entity_id'];
+ $file_name = $mdb2->quote($fields['file_name']);
+ $description = $mdb2->quote($fields['description']);
+ $created = 'now()';
+ $created_ip = $mdb2->quote($_SERVER['REMOTE_ADDR']);
+ $created_by = $user->id;
+
+ $columns = '(group_id, org_id, remote_id, entity_type, entity_id, file_name, description, created, created_ip, created_by)';
+ $values = "values($group_id, $org_id, $file_id, $entity_type, $entity_id, $file_name, $description, $created, $created_ip, $created_by)";
+ $sql = "insert into tt_files $columns $values";
+ $affected = $mdb2->exec($sql);
+ return (!is_a($affected, 'PEAR_Error'));
+ }
+
+ // getOrgKey obtains organization key from the database.
+ private function getOrgKey() {
+ global $user;
+ $mdb2 = getConnection();
+
+ $org_id = $user->org_id;
+ $sql = "select group_key from tt_groups where id = $org_id and status = 1";
+ $res = $mdb2->query($sql);
+ $val = $res->fetchRow();
+ return $val['group_key'];
+ }
+
+ // getGrtoupKey obtains group key from the database.
+ private function getGroupKey() {
+ global $user;
+ $mdb2 = getConnection();
+
+ $group_id = $user->getGroup();
+ $org_id = $user->org_id;
+
+ $sql = "select group_key from tt_groups where id = $group_id and org_id = $org_id and status = 1";
+ $res = $mdb2->query($sql);
+ $val = $res->fetchRow();
+ return $val['group_key'];