+ if (is_a($affected, 'PEAR_Error'))
+ return false;
+
+ $sql = "select last_insert_id() as last_id";
+ $res = $mdb2->query($sql);
+ if (is_a($res, 'PEAR_Error'))
+ return false;
+
+ $val = $res->fetchRow();
+ return $val['last_id'];
+ }
+
+ // insertNotification function inserts a new notification into database.
+ private function insertNotification($fields)
+ {
+ $mdb2 = getConnection();
+
+ $group_id = (int) $fields['group_id'];
+ $org_id = (int) $fields['org_id'];
+ $cron_spec = $fields['cron_spec'];
+ $last = (int) $fields['last'];
+ $next = (int) $fields['next'];
+ $report_id = (int) $fields['report_id'];
+ $email = $fields['email'];
+ $cc = $fields['cc'];
+ $subject = $fields['subject'];
+ $report_condition = $fields['report_condition'];
+ $status = $fields['status'];
+
+ $sql = "insert into tt_cron".
+ " (group_id, org_id, cron_spec, last, next, report_id, email, cc, subject, report_condition, status)".
+ " values ($group_id, $org_id, ".$mdb2->quote($cron_spec).", $last, $next, $report_id, ".$mdb2->quote($email).", ".$mdb2->quote($cc).", ".$mdb2->quote($subject).", ".$mdb2->quote($report_condition).", ".$mdb2->quote($status).")";
+ $affected = $mdb2->exec($sql);
+ return (!is_a($affected, 'PEAR_Error'));
+ }
+
+ // insertUserParam - a helper function to insert a user parameter.
+ private function insertUserParam($fields) {
+ $mdb2 = getConnection();
+
+ $group_id = (int) $fields['group_id'];
+ $org_id = (int) $fields['org_id'];
+ $user_id = (int) $fields['user_id'];
+ $param_name = $fields['param_name'];
+ $param_value = $fields['param_value'];
+
+ $sql = "insert into tt_config".
+ " (user_id, group_id, org_id, param_name, param_value)".
+ " values ($user_id, $group_id, $org_id, ".$mdb2->quote($param_name).", ".$mdb2->quote($param_value).")";
+ $affected = $mdb2->exec($sql);
+ return (!is_a($affected, 'PEAR_Error'));
+ }
+
+ // insertCustomField - a helper function to insert a custom field.
+ private function insertCustomField($fields) {
+ $mdb2 = getConnection();
+
+ $group_id = (int) $fields['group_id'];
+ $org_id = (int) $fields['org_id'];
+ $type = (int) $fields['type'];
+ $label = $fields['label'];
+ $required = (int) $fields['required'];
+ $status = $fields['status'];
+
+ $sql = "insert into tt_custom_fields".
+ " (group_id, org_id, type, label, required, status)".
+ " values($group_id, $org_id, $type, ".$mdb2->quote($label).", $required, ".$mdb2->quote($status).")";
+ $affected = $mdb2->exec($sql);
+ if (is_a($affected, 'PEAR_Error'))
+ return false;
+
+ $last_id = 0;
+ $sql = "select last_insert_id() as last_insert_id";
+ $res = $mdb2->query($sql);
+ $val = $res->fetchRow();
+ $last_id = $val['last_insert_id'];
+ return $last_id;
+ }
+
+ // insertCustomFieldOption - a helper function to insert a custom field option.
+ private function insertCustomFieldOption($fields) {
+ $mdb2 = getConnection();
+
+ $group_id = (int) $fields['group_id'];
+ $org_id = (int) $fields['org_id'];
+ $field_id = (int) $fields['field_id'];
+ $value = $fields['value'];
+
+ $sql = "insert into tt_custom_field_options (group_id, org_id, field_id, value)".
+ " values ($group_id, $org_id, $field_id, ".$mdb2->quote($value).")";
+ $affected = $mdb2->exec($sql);
+ if (is_a($affected, 'PEAR_Error'))
+ return false;
+
+ $last_id = 0;
+ $sql = "select last_insert_id() as last_insert_id";
+ $res = $mdb2->query($sql);
+ $val = $res->fetchRow();
+ $last_id = $val['last_insert_id'];
+ return $last_id;
+ }
+
+ // insertCustomFieldLogEntry - a helper function to insert a custom field log entry.
+ private function insertCustomFieldLogEntry($fields) {
+ $mdb2 = getConnection();
+
+ $group_id = (int) $fields['group_id'];
+ $org_id = (int) $fields['org_id'];
+ $log_id = (int) $fields['log_id'];
+ $field_id = (int) $fields['field_id'];
+ $option_id = $fields['option_id'];
+ $value = $fields['value'];
+ $status = $fields['status'];
+
+ $sql = "insert into tt_custom_field_log (group_id, org_id, log_id, field_id, option_id, value, status)".
+ " values ($group_id, $org_id, $log_id, $field_id, ".$mdb2->quote($option_id).", ".$mdb2->quote($value).", ".$mdb2->quote($status).")";
+ $affected = $mdb2->exec($sql);