X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/b1082e6ec27ca11586bd786b65f509d1a20220f6..cbc2ae6c2e83edfe7b4242b7dd2f9bfb1359820e:/WEB-INF/lib/ttCustomFieldHelper.class.php diff --git a/WEB-INF/lib/ttCustomFieldHelper.class.php b/WEB-INF/lib/ttCustomFieldHelper.class.php deleted file mode 100644 index 15c7ca05..00000000 --- a/WEB-INF/lib/ttCustomFieldHelper.class.php +++ /dev/null @@ -1,100 +0,0 @@ -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; - } - - // The insertOption function inserts a new custom field option in database. - static function insertOption($fields) - { - $mdb2 = getConnection(); - - $field_id = (int) $fields['field_id']; - $value = $fields['value']; - - $sql = "insert into tt_custom_field_options (field_id, value) - values ($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; - } - - // The insertLogEntry function inserts a new custom field log entry in database. - static function insertLogEntry($fields) - { - $mdb2 = getConnection(); - - $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 (log_id, field_id, option_id, value, status) - values ($log_id, $field_id, ".$mdb2->quote($option_id).", ".$mdb2->quote($value).", ".$mdb2->quote($status).")"; - - $affected = $mdb2->exec($sql); - return (!is_a($affected, 'PEAR_Error')); - } -}