It (please choose):
[ ] is ugly
[ ] is not declared
[ ] is never escaped
[ ] prevents IDE inpection with SQL schema
Current usage:
Field
table_name
Found usages (473 usages found)
Value read (384 usages found)
tuleap (384 usages found)
plugins/cardwall/include (6 usages found)
Cardwall_RendererDao.class.php (6 usages found)
Cardwall_RendererDao (6 usages found)
create (1 usage found)
43 $sql = "INSERT INTO $this->table_name
delete (1 usage found)
61 $sql = "DELETE FROM $this->table_name WHERE renderer_id = ". $this->da->escapeInt($renderer_id);
duplicate (2 usages found)
69 $sql = "INSERT INTO $this->table_name (renderer_id, field_id)
71 FROM $this->table_name
save (1 usage found)
53 $sql = "REPLACE INTO $this->table_name
searchByRendererId (1 usage found)
34 FROM $this->table_name
plugins/graphontrackersv5/include/data-access (33 usages found)
GraphOnTrackersV5_Chart_BarDao.class.php (7 usages found)
GraphOnTrackersV5_Chart_BarDao (7 usages found)
delete (1 usage found)
42 $sql = "DELETE FROM $this->table_name WHERE id = $id";
duplicate (4 usages found)
60 $sql = "INSERT INTO $this->table_name (id, field_base, field_group)
62 FROM $this->table_name
69 $sql = "UPDATE $this->table_name
75 $sql = "UPDATE $this->table_name
save (1 usage found)
51 $sql = "REPLACE INTO $this->table_name (id, field_base, field_group)
searchById (1 usage found)
35 $sql = "SELECT * FROM $this->table_name WHERE id = $id";
GraphOnTrackersV5_Chart_BurndownDao.class.php (6 usages found)
GraphOnTrackersV5_Chart_BurndownDao (6 usages found)
delete (1 usage found)
42 $sql = "DELETE FROM $this->table_name WHERE id = $id";
duplicate (3 usages found)
61 $sql = "INSERT INTO $this->table_name (id, field_id, start_date, duration)
63 FROM $this->table_name
70 $sql = "UPDATE $this->table_name
save (1 usage found)
52 $sql = "REPLACE INTO $this->table_name (id, field_id, start_date, duration)
searchById (1 usage found)
35 $sql = "SELECT * FROM $this->table_name WHERE id = $id";
GraphOnTrackersV5_Chart_CumulativeFlowDao.class.php (6 usages found)
GraphOnTrackersV5_Chart_CumulativeFlowDao (6 usages found)
delete (1 usage found)
42 $sql = "DELETE FROM $this->table_name WHERE id = $id";
duplicate (3 usages found)
62 $sql = "INSERT INTO $this->table_name (id, field_id, start_date, stop_date, scale)
64 FROM $this->table_name
71 $sql = "UPDATE $this->table_name
save (1 usage found)
53 $sql = "REPLACE INTO $this->table_name (id, field_id, start_date, stop_date, scale)
searchById (1 usage found)
35 $sql = "SELECT * FROM $this->table_name WHERE id = $id";
GraphOnTrackersV5_Chart_GanttDao.class.php (6 usages found)
GraphOnTrackersV5_Chart_GanttDao (6 usages found)
delete (1 usage found)
42 $sql = "DELETE FROM $this->table_name WHERE id = $id";
duplicate (3 usages found)
67 $sql = "INSERT INTO $this->table_name (id, field_start, field_due, field_finish, field_percentage, field_righttext, scale, as_of_date, summary)
69 FROM $this->table_name
77 $sql = "UPDATE $this->table_name
save (1 usage found)
58 $sql = "REPLACE INTO $this->table_name (id, field_start, field_due, field_finish, field_percentage, field_righttext, scale, as_of_date, summary)
searchById (1 usage found)
35 $sql = "SELECT * FROM $this->table_name WHERE id = $id";
GraphOnTrackersV5_Chart_PieDao.class.php (6 usages found)
GraphOnTrackersV5_Chart_PieDao (6 usages found)
delete (1 usage found)
42 $sql = "DELETE FROM $this->table_name WHERE id = $id";
duplicate (3 usages found)
59 $sql = "INSERT INTO $this->table_name (id, field_base)
61 FROM $this->table_name
68 $sql = "UPDATE $this->table_name
save (1 usage found)
50 $sql = "REPLACE INTO $this->table_name (id, field_base)
searchById (1 usage found)
35 $sql = "SELECT * FROM $this->table_name WHERE id = $id";
GraphOnTrackersV5_ChartDao.class.php (2 usages found)
GraphOnTrackersV5_ChartDao (2 usages found)
duplicate (2 usages found)
114 $sql = "INSERT INTO $this->table_name(report_graphic_id, rank, chart_type, title, description, width, height)
116 FROM $this->table_name
plugins/tracker/include/Tracker/Artifact/dao (17 usages found)
Tracker_Artifact_Changeset_CommentDao.class.php (3 usages found)
Tracker_Artifact_Changeset_CommentDao (3 usages found)
createNewVersion (1 usage found)
69 $sql = "INSERT INTO $this->table_name (changeset_id, body, body_format, submitted_by, submitted_on, parent_id)
delete (1 usage found)
86 FROM $this->table_name
searchLastVersion (1 usage found)
33 $sql = "SELECT * FROM $this->table_name
Tracker_Artifact_Changeset_ValueDao.class.php (5 usages found)
Tracker_Artifact_Changeset_ValueDao (5 usages found)
createFromLastChangesetByTrackerId (1 usage found)
79 $sql = " INSERT INTO $this->table_name(changeset_id, field_id, has_changed)
delete (1 usage found)
110 FROM $this->table_name
save (1 usage found)
67 $sql = "INSERT INTO $this->table_name(changeset_id, field_id, has_changed)
searchByFieldId (1 usage found)
42 $sql = "SELECT * FROM $this->table_name
searchById (1 usage found)
33 $sql = "SELECT * FROM $this->table_name
Tracker_Artifact_ChangesetDao.class.php (4 usages found)
Tracker_Artifact_ChangesetDao (4 usages found)
create (1 usage found)
100 $sql = "INSERT INTO $this->table_name (artifact_id, submitted_by, submitted_on, email)
delete (1 usage found)
115 FROM $this->table_name
searchByArtifactId (1 usage found)
34 $sql = "SELECT * FROM $this->table_name
searchByArtifactIdAndChangesetId (1 usage found)
44 $sql = "SELECT * FROM $this->table_name
Tracker_ArtifactDao.class.php (5 usages found)
Tracker_ArtifactDao (5 usages found)
createWithId (1 usage found)
478 $sql = "INSERT INTO $this->table_name
delete (1 usage found)
504 $sql = "DELETE FROM $this->table_name WHERE id = ". $this->da->escapeInt($id);
save (1 usage found)
495 $sql = "UPDATE $this->table_name SET
searchById (1 usage found)
39 FROM $this->table_name
searchLastChangesetIds (1 usage found)
95 $from = " FROM $this->table_name AS artifact";
plugins/tracker/include/Tracker/CannedResponse/dao (5 usages found)
Tracker_CannedResponseDao.class.php (5 usages found)
Tracker_CannedResponseDao (5 usages found)
create (1 usage found)
55 $sql = "INSERT INTO $this->table_name (tracker_id, title, body)
delete (1 usage found)
75 $sql = "DELETE FROM $this->table_name
save (1 usage found)
65 $sql = "UPDATE $this->table_name
searchById (1 usage found)
34 FROM $this->table_name
searchByTrackerId (1 usage found)
44 FROM $this->table_name
plugins/tracker/include/Tracker/dao (32 usages found)
Tracker_FileInfoDao.class.php (3 usages found)
Tracker_FileInfoDao (3 usages found)
create (1 usage found)
69 $sql = "INSERT INTO $this->table_name(submitted_by, description, filename, filesize, filetype)
delete (1 usage found)
77 $sql = "DELETE FROM $this->table_name WHERE id = $id";
searchById (1 usage found)
42 FROM $this->table_name
Tracker_GlobalNotificationDao.class.php (11 usages found)
Tracker_GlobalNotificationDao (11 usages found)
create (1 usage found)
134 "INSERT INTO $this->table_name (tracker_id, addresses, all_updates, check_permissions) VALUES (%s, %s, %s, %s)",
delete (1 usage found)
156 "DELETE FROM $this->table_name WHERE id = %s AND tracker_id = %s",
duplicate (2 usages found)
167 $sql = "INSERT INTO $this->table_name (tracker_id, addresses, all_updates, check_permissions)
169 FROM $this->table_name
modify (1 usage found)
149 $sql = "UPDATE $this->table_name SET ". implode(', ', $updates) ." WHERE id = ". $this->da->quoteSmart($id);
searchAll (1 usage found)
40 $sql = "SELECT * FROM $this->table_name";
searchByAddresses (1 usage found)
77 "SELECT id, tracker_id, all_updates, check_permissions FROM $this->table_name WHERE addresses = %s",
searchByAllUpdates (1 usage found)
90 "SELECT id, tracker_id, addresses, check_permissions FROM $this->table_name WHERE all_updates = %s",
searchByCheckPermissions (1 usage found)
103 "SELECT id, tracker_id, addresses, all_updates FROM $this->table_name WHERE check_permissions = %s",
searchById (1 usage found)
51 "SELECT tracker_id, addresses, all_updates, check_permissions FROM $this->table_name WHERE id = %s",
searchByTrackerId (1 usage found)
64 "SELECT id, addresses, all_updates, check_permissions FROM $this->table_name WHERE tracker_id = %s ORDER BY id",
Tracker_NotificationDao.class.php (3 usages found)
Tracker_NotificationDao (3 usages found)
searchEvents (1 usage found)
59 FROM $this->table_name"."_event
searchNotification (1 usage found)
35 FROM $this->table_name"."_role AS r, $this->table_name"."_event AS e, $this->table_name AS n
searchRoles (1 usage found)
49 FROM $this->table_name"."_role
Tracker_WatcherDao.class.php (2 usages found)
Tracker_WatcherDao (2 usages found)
searchWatchees (1 usage found)
35 FROM $this->table_name
searchWatchers (1 usage found)
46 FROM $this->table_name
TrackerDao.class.php (13 usages found)
TrackerDao (13 usages found)
create (1 usage found)
220 $sql = "INSERT INTO $this->table_name
delete (1 usage found)
296 $sql = "DELETE FROM $this->table_name WHERE id = ". $this->da->escapeInt($id);
duplicate (2 usages found)
148 $sql = "INSERT INTO $this->table_name
178 FROM $this->table_name
isShortNameExists (1 usage found)
94 FROM $this->table_name
markAsDeleted (1 usage found)
125 $sql = "UPDATE $this->table_name
restoreTrackerMarkAsDeleted (1 usage found)
347 $sql = "UPDATE $this->table_name SET
save (1 usage found)
275 $sql = "UPDATE $this->table_name SET
searchByGroupId (1 usage found)
45 FROM $this->table_name
searchByGroupIdWithExcludedIds (1 usage found)
63 FROM $this->table_name
searchById (1 usage found)
36 FROM $this->table_name
searchByItemNameAndProjectId (1 usage found)
114 FROM $this->table_name
updateItemName (1 usage found)
305 $sql = "UPDATE $this->table_name SET
plugins/tracker/include/Tracker/FormElement/dao (148 usages found)
Tracker_FormElement_Field_BurndownDao.class.php (1 usage found)
Tracker_FormElement_Field_BurndownDao (1 usage found)
duplicate (1 usage found)
56 FROM $this->table_name
Tracker_FormElement_Field_ComputedDao.class.php (2 usages found)
Tracker_FormElement_Field_ComputedDao (2 usages found)
duplicate (2 usages found)
70 $sql = "REPLACE INTO $this->table_name (field_id, target_field_name, fast_compute)
71 SELECT $to_field_id, target_field_name, fast_compute FROM $this->table_name WHERE field_id = $from_field_id";
Tracker_FormElement_Field_DateDao.class.php (3 usages found)
Tracker_FormElement_Field_DateDao (3 usages found)
duplicate (2 usages found)
74 $sql = "REPLACE INTO $this->table_name (field_id, default_value, default_value_type, display_time)
76 FROM $this->table_name
save (1 usage found)
55 $sql = "REPLACE INTO $this->table_name (field_id, default_value, default_value_type, display_time)
Tracker_FormElement_Field_FloatDao.class.php (3 usages found)
Tracker_FormElement_Field_FloatDao (3 usages found)
duplicate (2 usages found)
73 $sql = "REPLACE INTO $this->table_name (field_id, maxchars, size, default_value)
74 SELECT $to_field_id, maxchars, size, default_value FROM $this->table_name WHERE field_id = $from_field_id";
save (1 usage found)
55 $sql = "REPLACE INTO $this->table_name (field_id, maxchars, size, default_value)
Tracker_FormElement_Field_IntegerDao.class.php (3 usages found)
Tracker_FormElement_Field_IntegerDao (3 usages found)
duplicate (2 usages found)
73 $sql = "REPLACE INTO $this->table_name (field_id, maxchars, size, default_value)
74 SELECT $to_field_id, maxchars, size, default_value FROM $this->table_name WHERE field_id = $from_field_id";
save (1 usage found)
55 $sql = "REPLACE INTO $this->table_name (field_id, maxchars, size, default_value)
Tracker_FormElement_Field_List_Bind_DefaultvalueDao.class.php (6 usages found)
Tracker_FormElement_Field_List_Bind_DefaultvalueDao (6 usages found)
duplicate (3 usages found)
40 $sql = "INSERT INTO $this->table_name (field_id, value_id)
42 FROM $this->table_name
49 $sql = "UPDATE $this->table_name
save (2 usages found)
72 $sql = "DELETE FROM $this->table_name
78 $sql = "INSERT INTO $this->table_name (field_id, value_id)
searchByFieldId (1 usage found)
32 FROM $this->table_name
Tracker_FormElement_Field_List_Bind_Static_ValueDao.class.php (19 usages found)
Tracker_FormElement_Field_List_Bind_Static_ValueDao (19 usages found)
canValueBeDeleted (2 usages found)
277 FROM $this->table_name AS v
283 FROM $this->table_name AS v
canValueBeHidden (1 usage found)
184 FROM $this->table_name AS v
create (1 usage found)
81 $sql = "INSERT INTO $this->table_name (field_id, label, description, rank, is_hidden)
delete (1 usage found)
148 $sql = "DELETE FROM $this->table_name
duplicate (3 usages found)
60 $insert = "INSERT INTO $this->table_name (field_id, label, description, rank, is_hidden, original_value_id)
63 $insert = "INSERT INTO $this->table_name (field_id, label, description, rank, is_hidden, original_value_id)
67 FROM $this->table_name
hideValue (1 usage found)
105 $sql = "UPDATE $this->table_name
isValueHiddenable (4 usages found)
206 FROM $this->table_name AS v
218 FROM $this->table_name AS v
230 FROM $this->table_name AS v
236 FROM $this->table_name AS v
propagateCreation (1 usage found)
91 $sql = "INSERT INTO $this->table_name (field_id, label, description, rank, is_hidden, original_value_id)
save (1 usage found)
135 $sql = "UPDATE $this->table_name
searchByFieldId (1 usage found)
50 FROM $this->table_name
searchById (1 usage found)
41 FROM $this->table_name
updateLabel (1 usage found)
118 $sql = "UPDATE $this->table_name
updateOriginalValueId (1 usage found)
316 UPDATE $this->table_name
Tracker_FormElement_Field_List_Bind_StaticDao.class.php (5 usages found)
Tracker_FormElement_Field_List_Bind_StaticDao (5 usages found)
duplicate (2 usages found)
41 $sql = "REPLACE INTO $this->table_name (field_id, is_rank_alpha)
43 FROM $this->table_name
isRankAlpha (1 usage found)
73 FROM $this->table_name
save (1 usage found)
51 $sql = "REPLACE INTO $this->table_name (field_id, is_rank_alpha)
searchByFieldId (1 usage found)
33 FROM $this->table_name
Tracker_FormElement_Field_List_Bind_Ugroups_ValueDao.class.php (6 usages found)
Tracker_FormElement_Field_List_Bind_Ugroups_ValueDao (6 usages found)
create (1 usage found)
76 $sql = "REPLACE INTO $this->table_name (field_id, ugroup_id, is_hidden)
duplicate (2 usages found)
53 $sql = "REPLACE INTO $this->table_name (field_id, ugroup_id, is_hidden)
63 INNER JOIN $this->table_name v ON (v.ugroup_id = u2.ugroup_id)
searchByFieldId (1 usage found)
44 FROM $this->table_name
searchById (1 usage found)
35 FROM $this->table_name
toggleHidden (1 usage found)
96 $sql = "UPDATE $this->table_name
Tracker_FormElement_Field_List_Bind_UsersDao.class.php (4 usages found)
Tracker_FormElement_Field_List_Bind_UsersDao (4 usages found)
duplicate (2 usages found)
40 $sql = "INSERT INTO $this->table_name (field_id, value_function)
42 FROM $this->table_name
save (1 usage found)
50 $sql = "REPLACE INTO $this->table_name (field_id, value_function)
searchByFieldId (1 usage found)
32 FROM $this->table_name
Tracker_FormElement_Field_List_BindDecoratorDao.class.php (9 usages found)
Tracker_FormElement_Field_List_BindDecoratorDao (9 usages found)
delete (1 usage found)
117 $sql = "DELETE FROM $this->table_name
duplicate (3 usages found)
43 = "INSERT INTO $this->table_name (field_id, value_id, red, green, blue, tlp_color_name)
45 FROM $this->table_name
53 = "UPDATE $this->table_name
save (1 usage found)
69 $sql = "INSERT INTO $this->table_name (field_id, value_id, red, green, blue, tlp_color_name)
saveTlpColor (1 usage found)
95 $sql = "INSERT INTO $this->table_name (field_id, value_id, red, green, blue, tlp_color_name)
searchByFieldId (1 usage found)
33 FROM $this->table_name
updateColor (1 usage found)
84 $sql = "REPLACE INTO $this->table_name (field_id, value_id, red, green, blue, tlp_color_name)
updateTlpColor (1 usage found)
106 $sql = "REPLACE INTO $this->table_name (field_id, value_id, red, green, blue, tlp_color_name)
Tracker_FormElement_Field_List_OpenValueDao.class.php (6 usages found)
Tracker_FormElement_Field_List_OpenValueDao (6 usages found)
create (1 usage found)
66 $sql = "INSERT INTO $this->table_name (field_id, label)
save (1 usage found)
55 $sql = "UPDATE $this->table_name
searchByExactLabel (1 usage found)
89 FROM $this->table_name
searchByFieldId (1 usage found)
45 FROM $this->table_name
searchById (1 usage found)
34 FROM $this->table_name
searchByKeyword (1 usage found)
77 FROM $this->table_name
Tracker_FormElement_Field_ListDao.class.php (4 usages found)
Tracker_FormElement_Field_ListDao (4 usages found)
duplicate (2 usages found)
40 $sql = "INSERT INTO $this->table_name (field_id, bind_type)
42 FROM $this->table_name
save (1 usage found)
50 $sql = "REPLACE INTO $this->table_name (field_id, bind_type)
searchByFieldId (1 usage found)
32 FROM $this->table_name
Tracker_FormElement_Field_MultiSelectboxDao.class.php (3 usages found)
Tracker_FormElement_Field_MultiSelectboxDao (3 usages found)
duplicate (2 usages found)
62 $sql = "REPLACE INTO $this->table_name (field_id, size)
64 FROM $this->table_name
save (1 usage found)
44 $sql = "REPLACE INTO $this->table_name (field_id, size)
Tracker_FormElement_Field_OpenListDao.class.php (3 usages found)
Tracker_FormElement_Field_OpenListDao (3 usages found)
duplicate (2 usages found)
58 $sql = "REPLACE INTO $this->table_name (field_id, hint)
60 FROM $this->table_name
save (1 usage found)
40 $sql = "REPLACE INTO $this->table_name (field_id, hint)
Tracker_FormElement_Field_StringDao.class.php (3 usages found)
Tracker_FormElement_Field_StringDao (3 usages found)
duplicate (2 usages found)
73 $sql = "REPLACE INTO $this->table_name (field_id, maxchars, size, default_value)
74 SELECT $to_field_id, maxchars, size, default_value FROM $this->table_name WHERE field_id = $from_field_id";
save (1 usage found)
55 $sql = "REPLACE INTO $this->table_name (field_id, maxchars, size, default_value)
Tracker_FormElement_Field_Value_ArtifactLinkDao.class.php (4 usages found)
Tracker_FormElement_Field_Value_ArtifactLinkDao (4 usages found)
deleteReference (1 usage found)
136 $sql = "DELETE FROM $this->table_name
keep (2 usages found)
105 $sql = "INSERT INTO $this->table_name(changeset_value_id, nature, artifact_id, keyword, group_id)
107 FROM $this->table_name
updateItemName (1 usage found)
127 $sql = "UPDATE $this->table_name SET
Tracker_FormElement_Field_Value_DateDao.class.php (4 usages found)
Tracker_FormElement_Field_Value_DateDao (4 usages found)
create (1 usage found)
38 $sql = "INSERT INTO $this->table_name(changeset_value_id, value)
createNoneValue (1 usage found)
55 $sql = " INSERT INTO $this->table_name(changeset_value_id, value)
keep (2 usages found)
65 $sql = "INSERT INTO $this->table_name(changeset_value_id, value)
67 FROM $this->table_name
Tracker_FormElement_Field_Value_FileDao.class.php (3 usages found)
Tracker_FormElement_Field_Value_FileDao (3 usages found)
create (1 usage found)
40 $sql = "INSERT INTO $this->table_name(changeset_value_id, fileinfo_id)
keep (2 usages found)
55 $sql = "INSERT INTO $this->table_name(changeset_value_id, fileinfo_id)
57 FROM $this->table_name
Tracker_FormElement_Field_Value_FloatDao.class.php (4 usages found)
Tracker_FormElement_Field_Value_FloatDao (4 usages found)
create (1 usage found)
39 $sql = "INSERT INTO $this->table_name(changeset_value_id, value)
createNoneValue (1 usage found)
50 $sql = " INSERT INTO $this->table_name(changeset_value_id, value)
keep (2 usages found)
60 $sql = "INSERT INTO $this->table_name(changeset_value_id, value)
62 FROM $this->table_name
Tracker_FormElement_Field_Value_IntegerDao.class.php (4 usages found)
Tracker_FormElement_Field_Value_IntegerDao (4 usages found)
create (1 usage found)
39 $sql = "INSERT INTO $this->table_name(changeset_value_id, value)
createNoneValue (1 usage found)
50 $sql = " INSERT INTO $this->table_name(changeset_value_id, value)
keep (2 usages found)
60 $sql = "INSERT INTO $this->table_name(changeset_value_id, value)
62 FROM $this->table_name
Tracker_FormElement_Field_Value_ListDao.class.php (4 usages found)
Tracker_FormElement_Field_Value_ListDao (4 usages found)
create (1 usage found)
51 $sql = "INSERT INTO $this->table_name(changeset_value_id, bindvalue_id)
createNoneValue (1 usage found)
64 $sql = "INSERT INTO $this->table_name(changeset_value_id, bindvalue_id)
keep (2 usages found)
73 $sql = "INSERT INTO $this->table_name(changeset_value_id, bindvalue_id)
75 FROM $this->table_name
Tracker_FormElement_Field_Value_NumericDao.class.php (2 usages found)
Tracker_FormElement_Field_Value_NumericDao (2 usages found)
getLastValue (1 usage found)
66 JOIN $this->table_name cvi ON (cvi.changeset_value_id = cv.id)
getValueAt (1 usage found)
44 JOIN $this->table_name cvi ON (cvi.changeset_value_id = cv.id)
Tracker_FormElement_Field_Value_OpenListDao.class.php (4 usages found)
Tracker_FormElement_Field_Value_OpenListDao (4 usages found)
create (1 usage found)
51 $sql = "INSERT INTO $this->table_name(changeset_value_id, bindvalue_id, openvalue_id)
keep (2 usages found)
68 $sql = "INSERT INTO $this->table_name(changeset_value_id, bindvalue_id, openvalue_id)
70 FROM $this->table_name
searchById (1 usage found)
34 FROM $this->table_name
Tracker_FormElement_Field_Value_PermissionsOnArtifactDao.class.php (5 usages found)
Tracker_FormElement_Field_Value_PermissionsOnArtifactDao (5 usages found)
create (1 usage found)
43 $sql = "INSERT INTO $this->table_name(changeset_value_id, use_perm, ugroup_id)
createNoneValue (1 usage found)
56 $sql = " INSERT INTO $this->table_name(changeset_value_id, use_perm, ugroup_id) VALUES (".implode(', 1, 1), ( ', $changeset_value_ids).", 1, 1) ";
keep (2 usages found)
64 $sql = "INSERT INTO $this->table_name(changeset_value_id, use_perm, ugroup_id)
66 FROM $this->table_name
searchByChangesetValueId (1 usage found)
75 FROM $this->table_name
Tracker_FormElement_Field_Value_TextDao.class.php (5 usages found)
Tracker_FormElement_Field_Value_TextDao (5 usages found)
create (1 usage found)
35 $sql = "INSERT INTO $this->table_name(changeset_value_id, value)
createNoneValue (1 usage found)
65 $sql = " INSERT INTO $this->table_name(changeset_value_id, value)
createWithBodyFormat (1 usage found)
47 $sql = "INSERT INTO $this->table_name(changeset_value_id, value, body_format)
keep (2 usages found)
75 $sql = "INSERT INTO $this->table_name(changeset_value_id, value, body_format)
77 FROM $this->table_name
Tracker_FormElement_Field_ValueDao.class.php (2 usages found)
Tracker_FormElement_Field_ValueDao (2 usages found)
delete (1 usage found)
37 FROM $this->table_name
searchById (1 usage found)
28 FROM $this->table_name
Tracker_FormElement_FieldDao.class.php (22 usages found)
Tracker_FormElement_FieldDao (22 usages found)
create (1 usage found)
529 $sql = "INSERT INTO $this->table_name (tracker_id, parent_id, name, formElement_type, label, description, scope, required, use_it, rank, notifications, original_field_id) ";
delete (1 usage found)
364 $sql = "DELETE FROM $this->table_name
duplicate (2 usages found)
294 $sql = "INSERT INTO $this->table_name (tracker_id, parent_id, name, formElement_type, label, description, scope, required, use_it, rank, notifications, original_field_id)
296 FROM $this->table_name
getUsedUserClosedListFieldById (1 usage found)
146 FROM $this->table_name f, tracker_field_list_bind_users lbu
getUsedUserListFieldById (1 usage found)
117 FROM $this->table_name f, tracker_field_list_bind_users lbu
mapNewParentsAfterDuplication (1 usage found)
309 $sql = "UPDATE $this->table_name
save (1 usage found)
332 $sql = "UPDATE $this->table_name
searchByParentId (1 usage found)
173 FROM $this->table_name
searchByTrackerId (1 usage found)
283 FROM $this->table_name
searchByTrackerIdAndName (1 usage found)
39 FROM $this->table_name
searchByTrackerIdAndType (1 usage found)
221 FROM $this->table_name
searchUnusedByTrackerId (1 usage found)
61 FROM $this->table_name
searchUsedByIdAndType (1 usage found)
91 FROM $this->table_name
searchUsedByParentId (1 usage found)
183 FROM $this->table_name
searchUsedByTrackerId (1 usage found)
72 FROM $this->table_name
searchUsedByTrackerIdAndName (1 usage found)
50 FROM $this->table_name
searchUsedByTrackerIdAndType (1 usage found)
201 FROM $this->table_name
searchUsedStaticSbFieldByTrackerId (1 usage found)
160 FROM $this->table_name f
searchUsedUserListFieldByTrackerId (1 usage found)
104 FROM $this->table_name f, tracker_field_list_bind_users lbu
setType (1 usage found)
353 $sql = "UPDATE $this->table_name
updateOriginalFieldId (1 usage found)
550 UPDATE $this->table_name
Tracker_FormElement_SpecificPropertiesDao.class.php (2 usages found)
Tracker_FormElement_SpecificPropertiesDao (2 usages found)
delete (1 usage found)
39 $sql = "DELETE FROM $this->table_name
searchByFieldId (1 usage found)
31 FROM $this->table_name
Tracker_FormElement_StaticField_RichTextDao.class.php (3 usages found)
Tracker_FormElement_StaticField_RichTextDao (3 usages found)
duplicate (2 usages found)
61 $sql = "REPLACE INTO $this->table_name (field_id, static_value)
63 FROM $this->table_name
save (1 usage found)
43 $sql = "REPLACE INTO $this->table_name (field_id, static_value)
plugins/tracker/include/Tracker/Report/dao (70 usages found)
Tracker_Report_Criteria_Alphanum_ValueDao.class.php (3 usages found)
Tracker_Report_Criteria_Alphanum_ValueDao (3 usages found)
delete (1 usage found)
45 $sql = "DELETE FROM $this->table_name WHERE criteria_id = $id";
save (2 usages found)
35 $sql = "REPLACE INTO $this->table_name(criteria_id, value) VALUES ($id, $v)";
37 $sql = "DELETE FROM $this->table_name WHERE criteria_id = $id";
Tracker_Report_Criteria_Date_ValueDao.class.php (2 usages found)
Tracker_Report_Criteria_Date_ValueDao (2 usages found)
save (2 usages found)
52 $sql = "REPLACE INTO $this->table_name(criteria_id, from_date, to_date, op) VALUES ($id, $from_date, $to_date, $op)";
54 $sql = "DELETE FROM $this->table_name WHERE criteria_id = $id";
Tracker_Report_Criteria_File_ValueDao.class.php (2 usages found)
Tracker_Report_Criteria_File_ValueDao (2 usages found)
save (2 usages found)
35 $sql = "REPLACE INTO $this->table_name(criteria_id, value) VALUES ($id, $v)";
37 $sql = "DELETE FROM $this->table_name WHERE criteria_id = $id";
Tracker_Report_Criteria_Float_ValueDao.class.php (2 usages found)
Tracker_Report_Criteria_Float_ValueDao (2 usages found)
save (2 usages found)
31 $sql = "REPLACE INTO $this->table_name(criteria_id, value) VALUES ($id, $espaced_value)";
33 $sql = "DELETE FROM $this->table_name WHERE criteria_id = $id";
Tracker_Report_Criteria_Int_ValueDao.class.php (2 usages found)
Tracker_Report_Criteria_Int_ValueDao (2 usages found)
save (2 usages found)
31 $sql = "REPLACE INTO $this->table_name(criteria_id, value) VALUES ($id, $espaced_value)";
33 $sql = "DELETE FROM $this->table_name WHERE criteria_id = $id";
Tracker_Report_Criteria_List_ValueDao.class.php (2 usages found)
Tracker_Report_Criteria_List_ValueDao (2 usages found)
save (2 usages found)
34 $sql = "DELETE FROM $this->table_name WHERE criteria_id = $id";
48 $sql = "INSERT INTO $this->table_name(criteria_id, value) VALUES ".implode(',', $new_values);
Tracker_Report_Criteria_PermissionsOnArtifact_ValueDao.class.php (2 usages found)
Tracker_Report_Criteria_PermissionsOnArtifact_ValueDao (2 usages found)
save (2 usages found)
35 $sql = "DELETE FROM $this->table_name WHERE criteria_id = $id";
48 $sql = "INSERT INTO $this->table_name(criteria_id, value) VALUES ".implode(',', $new_values);
Tracker_Report_Criteria_ValueDao.class.php (2 usages found)
Tracker_Report_Criteria_ValueDao (2 usages found)
delete (1 usage found)
35 $sql = "DELETE FROM $this->table_name WHERE criteria_id = $id";
searchByCriteriaId (1 usage found)
27 FROM $this->table_name
Tracker_Report_CriteriaDao.class.php (9 usages found)
Tracker_Report_CriteriaDao (9 usages found)
create (1 usage found)
69 $sql = "INSERT INTO $this->table_name
delete (1 usage found)
52 $sql = "DELETE FROM $this->table_name WHERE report_id = $report_id AND field_id = $field_id";
deleteAll (1 usage found)
59 $sql = "DELETE FROM $this->table_name WHERE report_id = $report_id";
duplicate (3 usages found)
89 $sql = "INSERT INTO $this->table_name (report_id, field_id, rank, is_advanced)
91 FROM $this->table_name
98 $sql = "UPDATE $this->table_name
searchById (1 usage found)
33 FROM $this->table_name
searchByReportId (1 usage found)
42 FROM $this->table_name
toggleAdvanced (1 usage found)
79 $sql = "UPDATE $this->table_name
Tracker_Report_Renderer_Table_FunctionsAggregatesDao.class.php (8 usages found)
Tracker_Report_Renderer_Table_FunctionsAggregatesDao (8 usages found)
create (1 usage found)
45 $sql = "INSERT INTO $this->table_name(renderer_id, field_id, aggregate)
deleteByFieldId (1 usage found)
73 $sql = "DELETE FROM $this->table_name WHERE field_id = ". $this->da->escapeInt($field_id);
deleteByRendererId (1 usage found)
67 $sql = "DELETE FROM $this->table_name WHERE renderer_id = ". $this->da->escapeInt($renderer_id);
duplicate (3 usages found)
81 $sql = "INSERT INTO $this->table_name(renderer_id, field_id, aggregate)
83 FROM $this->table_name
90 $sql = "UPDATE $this->table_name
remove (1 usage found)
58 $sql = "DELETE FROM $this->table_name
searchByRendererId (1 usage found)
33 FROM $this->table_name
Tracker_Report_Renderer_Table_SortDao.class.php (9 usages found)
Tracker_Report_Renderer_Table_SortDao (9 usages found)
create (1 usage found)
63 $sql = "INSERT INTO $this->table_name(renderer_id, field_id, is_desc, rank)
delete (1 usage found)
81 $sql = "DELETE FROM $this->table_name WHERE renderer_id = ". $this->da->escapeInt($renderer_id);
duplicate (3 usages found)
99 $sql = "INSERT INTO $this->table_name(renderer_id, field_id, is_desc, rank)
101 FROM $this->table_name
108 $sql = "UPDATE $this->table_name
remove (1 usage found)
73 $sql = "DELETE FROM $this->table_name
searchByRendererId (1 usage found)
33 FROM $this->table_name
shrink (1 usage found)
89 $sql = "DELETE FROM $this->table_name
toggleByRendererIdAndFieldId (1 usage found)
43 $sql = "UPDATE $this->table_name
Tracker_Report_Renderer_TableDao.class.php (6 usages found)
Tracker_Report_Renderer_TableDao (6 usages found)
create (1 usage found)
42 $sql = "INSERT INTO $this->table_name
delete (1 usage found)
62 $sql = "DELETE FROM $this->table_name WHERE renderer_id = ". $this->da->escapeInt($renderer_id);
duplicate (2 usages found)
70 $sql = "INSERT INTO $this->table_name (renderer_id, chunksz, multisort)
72 FROM $this->table_name
save (1 usage found)
53 $sql = "UPDATE $this->table_name SET
searchByRendererId (1 usage found)
33 FROM $this->table_name
Tracker_Report_RendererDao.class.php (11 usages found)
Tracker_Report_RendererDao (11 usages found)
create (1 usage found)
65 $sql = "INSERT INTO $this->table_name
delete (1 usage found)
96 $sql = "DELETE FROM $this->table_name WHERE id = ". $this->da->escapeInt($id);
duplicate (2 usages found)
116 $sql = "INSERT INTO $this->table_name (report_id, renderer_type, name, description, rank)
118 FROM $this->table_name
forceOrder (1 usage found)
135 $sql = "UPDATE $this->table_name
move (1 usage found)
76 $sql = "UPDATE $this->table_name SET rank = $rank WHERE id = $id";
rename (1 usage found)
105 $sql = "UPDATE $this->table_name SET
save (1 usage found)
86 $sql = "UPDATE $this->table_name SET
searchById (1 usage found)
33 FROM $this->table_name
searchByIdAndReportId (1 usage found)
53 FROM $this->table_name
searchByReportId (1 usage found)
42 FROM $this->table_name
Tracker_ReportDao.class.php (10 usages found)
Tracker_ReportDao (10 usages found)
create (1 usage found)
112 $sql = "INSERT INTO $this->table_name
delete (1 usage found)
164 $sql = "DELETE FROM $this->table_name WHERE id = ". $this->da->escapeInt($id);
duplicate (2 usages found)
172 table_name
174 FROM $this->table_name
save (1 usage found)
145 $sql = "UPDATE $this->table_name SET
searchById (1 usage found)
35 FROM $this->table_name
searchByTrackerId (1 usage found)
51 FROM $this->table_name
searchByUserId (1 usage found)
84 FROM $this->table_name
searchDefaultByTrackerId (1 usage found)
61 FROM $this->table_name
searchDefaultReportByTrackerId (1 usage found)
73 FROM $this->table_name
plugins/tracker/include/Tracker/Rule/dao (3 usages found)
Tracker_RuleDao.class.php (3 usages found)
Tracker_RuleDao (3 usages found)
deleteRulesBySourceTarget (1 usage found)
148 FROM $this->table_name
searchBySourceTarget (2 usages found)
165 FROM tracker_rule JOIN $this->table_name
166 ON (tracker_rule.id = $this->table_name.tracker_rule_id)
plugins/tracker/include/Tracker/Semantic/dao (8 usages found)
Tracker_Semantic_ContributorDao.class.php (3 usages found)
Tracker_Semantic_ContributorDao (3 usages found)
delete (1 usage found)
53 $sql = "DELETE FROM $this->table_name WHERE tracker_id = $tracker_id";
save (1 usage found)
44 $sql = "REPLACE INTO $this->table_name (tracker_id, field_id)
searchByTrackerId (1 usage found)
35 FROM $this->table_name
Tracker_Semantic_StatusDao.class.php (2 usages found)
Tracker_Semantic_StatusDao (2 usages found)
save (2 usages found)
47 $sql = "DELETE FROM $this->table_name
58 $sql = "INSERT INTO $this->table_name (tracker_id, field_id, open_value_id)
Tracker_Semantic_TitleDao.class.php (3 usages found)
Tracker_Semantic_TitleDao (3 usages found)
delete (1 usage found)
54 $sql = "DELETE FROM $this->table_name WHERE tracker_id = $tracker_id";
save (1 usage found)
45 $sql = "REPLACE INTO $this->table_name (tracker_id, field_id)
searchByTrackerId (1 usage found)
36 FROM $this->table_name
plugins/tracker/include/Tracker/Tooltip/dao (3 usages found)
Tracker_TooltipDao.class.php (3 usages found)
Tracker_TooltipDao (3 usages found)
add (1 usage found)
47 $sql = "REPLACE INTO $this->table_name(tracker_id, field_id, rank)
remove (1 usage found)
56 $sql = "DELETE FROM $this->table_name
searchByTrackerId (1 usage found)
36 FROM $this->table_name
plugins/tracker/include/Workflow (4 usages found)
Workflow_Dao.class.php (4 usages found)
Workflow_Dao (4 usages found)
delete (1 usage found)
71 $sql = " DELETE FROM $this->table_name WHERE workflow_id=$workflow_id";
searchById (1 usage found)
46 FROM $this->table_name
searchByTrackerId (1 usage found)
55 FROM $this->table_name
updateActivation (1 usage found)
64 $sql = " UPDATE $this->table_name SET is_used=$is_used, is_legacy=0 WHERE workflow_id=$workflow_id";
plugins/tracker/include/Workflow/PostAction/Field/dao (9 usages found)
Transition_PostAction_FieldDao.class.php (9 usages found)
Transition_PostAction_FieldDao (9 usages found)
create (1 usage found)
49 $sql = "INSERT INTO $this->table_name (transition_id)
deletePostAction (1 usage found)
182 FROM $this->table_name
deletePostActionsByTransitionId (1 usage found)
200 FROM $this->table_name
duplicate (2 usages found)
223 $sql = "INSERT INTO $this->table_name (transition_id, field_id, $this->value_column_name)
225 FROM $this->table_name
searchByFieldId (1 usage found)
151 FROM $this->table_name
searchByTransitionId (1 usage found)
106 FROM $this->table_name
searchByTransitionIdAndFieldId (1 usage found)
129 FROM $this->table_name
updatePostAction (1 usage found)
70 $sql = "UPDATE $this->table_name
plugins/tracker/include/Workflow/Transition/Condition/FieldNotEmpty (3 usages found)
Dao.class.php (3 usages found)
Workflow_Transition_Condition_FieldNotEmpty_Dao (3 usages found)
create (1 usage found)
52 $sql = "INSERT INTO $this->table_name (`transition_id`, `field_id`) VALUES ";
deleteByTransitionId (1 usage found)
83 FROM $this->table_name
searchByTransitionId (1 usage found)
72 FROM $this->table_name
plugins/tracker_encryption/include/dao (3 usages found)
Tracker_Public_KeyDao.class.php (3 usages found)
TrackerPublicKeyDao (3 usages found)
deleteKey (1 usage found)
52 $sql = "DELETE FROM $this->table_name
insertKey (1 usage found)
43 $sql = "REPLACE INTO $this->table_name
retrieveKey (1 usage found)
34 FROM $this->table_name
src/common/dao (32 usages found)
ArtifactDao.class.php (2 usages found)
ArtifactDao (2 usages found)
artifactTableExists (1 usage found)
93 $sql = "SHOW TABLES LIKE '{$this->table_name}'";
searchArtifactId (1 usage found)
37 FROM $this->table_name, artifact_group_list
ArtifactGroupListDao.class.php (3 usages found)
ArtifactGroupListDao (3 usages found)
searchNameByGroupId (1 usage found)
70 $sql = "SELECT * FROM $this->table_name WHERE group_id=$group_id";
updateArtifactGroupList (1 usage found)
42 $sql = "UPDATE $this->table_name SET
updateItemName (1 usage found)
60 $sql = "UPDATE $this->table_name SET
ArtifactReportFieldDao.class.php (3 usages found)
ArtifactReportFieldDao (3 usages found)
resizeColumns (1 usage found)
71 $sql .= $this->table_name ." AS R_$i ";
searchByReportIdAndFieldName (1 usage found)
41 FROM ". $this->table_name ."
updateResultRanking (1 usage found)
50 $sql = "UPDATE ". $this->table_name ."
CrossReferenceDao.class.php (8 usages found)
CrossReferenceDao (8 usages found)
createDbCrossRef (1 usage found)
70 $sql="INSERT INTO {$this->table_name}
deleteCrossReference (1 usage found)
127 $sql = "DELETE FROM {$this->table_name} WHERE
deleteEntity (1 usage found)
61 $sql = "DELETE FROM $this->table_name
deleteFullCrossReference (1 usage found)
165 $sql = "DELETE FROM {$this->table_name} WHERE
existInDb (1 usage found)
91 $sql= "SELECT * from {$this->table_name} WHERE ".
fullReferenceExistInDb (1 usage found)
104 $sql = "SELECT * from {$this->table_name} WHERE " .
updateSourceKeyword (1 usage found)
47 "UPDATE $this->table_name SET source_keyword=%s WHERE source_keyword= %s and source_gid=%s",
updateTargetKeyword (1 usage found)
36 "UPDATE $this->table_name SET target_keyword=%s WHERE target_keyword= %s and target_gid=%s",
ForumDao.class.php (1 usage found)
ForumDao (1 usage found)
searchByGroupForumId (1 usage found)
33 FROM $this->table_name
NewsBytesDao.class.php (1 usage found)
NewsBytesDao (1 usage found)
searchByForumId (1 usage found)
35 FROM $this->table_name
ProjectDao.class.php (6 usages found)
ProjectDao (6 usages found)
searchByCaseInsensitiveUnixGroupName (1 usage found)
106 FROM $this->table_name
searchById (1 usage found)
51 " FROM ".$this->table_name.
searchByPublicStatus (1 usage found)
494 FROM $this->table_name
searchByStatus (1 usage found)
60 FROM $this->table_name
searchByUnixGroupName (1 usage found)
97 FROM $this->table_name
searchProjectsNameLike (1 usage found)
167 " FROM ".$this->table_name." g".
ProjectHistoryDao.class.php (2 usages found)
ProjectHistoryDao (2 usages found)
groupAddHistory (1 usage found)
91 $sql= 'insert into '.$this->table_name.'(group_id,field_name,old_value,mod_by,date)
groupGetHistory (