}
function insert($log_id, $field_id, $option_id, $value) {
-
+ global $user;
$mdb2 = getConnection();
- $sql = "insert into tt_custom_field_log (log_id, field_id, option_id, value) values($log_id, $field_id, ".$mdb2->quote($option_id).", ".$mdb2->quote($value).")";
+
+ $group_id = $user->getActiveGroup();
+ $org_id = $user->org_id;
+
+ $sql = "insert into tt_custom_field_log (group_id, org_id, log_id, field_id, option_id, value)".
+ " values($group_id, $org_id, $log_id, $field_id, ".$mdb2->quote($option_id).", ".$mdb2->quote($value).")";
$affected = $mdb2->exec($sql);
return (!is_a($affected, 'PEAR_Error'));
}
// insertOption adds a new option to a custom field.
static function insertOption($field_id, $option_name) {
-
+ global $user;
$mdb2 = getConnection();
+ $group_id = $user->getActiveGroup();
+ $org_id = $user->org_id;
+
// Check if the option exists.
$id = 0;
$sql = "select id from tt_custom_field_options where field_id = $field_id and value = ".$mdb2->quote($option_name);
// Insert option.
if (!$id) {
- $sql = "insert into tt_custom_field_options (field_id, value) values($field_id, ".$mdb2->quote($option_name).")";
+ $sql = "insert into tt_custom_field_options (group_id, org_id, field_id, value)".
+ " values($group_id, $org_id, $field_id, ".$mdb2->quote($option_name).")";
$affected = $mdb2->exec($sql);
if (is_a($affected, 'PEAR_Error'))
return false;
static function insertField($field_name, $field_type, $required) {
global $user;
$mdb2 = getConnection();
- $sql = "insert into tt_custom_fields (group_id, type, label, required, status) values($user->group_id, $field_type, ".$mdb2->quote($field_name).", $required, 1)";
+ $group_id = $user->getActiveGroup();
+ $org_id = $user->org_id;
+ $sql = "insert into tt_custom_fields (group_id, org_id, type, label, required, status)".
+ " values($group_id, $org_id, $field_type, ".$mdb2->quote($field_name).", $required, 1)";
$affected = $mdb2->exec($sql);
return (!is_a($affected, 'PEAR_Error'));
}