| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||
|---|---|---|---|---|---|---|---|---|---|
| 0001276 | v3.0 Release | [All Projects] General | public | 2013-03-04 08:42 | 2013-08-28 11:17 | ||||
| Reporter | carlosazevedo | ||||||||
| Assigned To | caseydk | ||||||||
| Priority | normal | Severity | minor | Reproducibility | always | ||||
| Status | closed | Resolution | fixed | ||||||
| Product Version | |||||||||
| Target Version | Fixed in Version | 3.0.0 | |||||||
| Summary | 0001276: FIX: On the files list the owner is shown by user name | ||||||||
| Description | I think this is a possible security breach, apart from making no sense. So this fix changes that to show the contact's display name instead. This involves these changes on the file 'cleanup_functions.php' in 'includes' : $q = new w2p_Database_Query(); - $q->addQuery('f.*, max(f.file_id) as latest_id, count(f.file_version) as file_versions, round(max(file_version), 2) as file_lastversion, u.user_username as file_owner'); + $q->addQuery('f.*, max(f.file_id) as latest_id, count(f.file_version) as file_versions, round(max(file_version), 2) as file_lastversion, con.contact_display_name as file_owner'); $q->addQuery('ff.*, max(file_version) as file_version, f.file_date as file_datetime'); $q->addJoin('users', 'u', 'u.user_id = file_owner'); + $q->addJoin('contacts', 'con', 'con.contact_id = u.user_contact'); $q->leftJoin('project_departments', 'project_departments', 'p.project_id = project_departments.project_id OR project_departments.project_id IS NULL'); | ||||||||
| Tags | No tags attached. | ||||||||
| Attached Files |
| ||||||||
 Relationships |
|
 Relationships |
| Notes |
|
|
caseydk (administrator) 2013-03-04 20:26 |
Resolved, though not as described: https://github.com/web2project/web2project/commit/c2846a3978e946731901bb04746283617dd04ff1 |
| Notes |
| Issue History |
|||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-03-04 08:42 | carlosazevedo | New Issue | |
| 2013-03-04 20:26 | caseydk | Note Added: 0002833 | |
| 2013-03-04 20:26 | caseydk | Status | new => resolved |
| 2013-03-04 20:26 | caseydk | Resolution | open => fixed |
| 2013-03-04 20:26 | caseydk | Assigned To | => caseydk |
| 2013-08-28 10:24 | caseydk | Severity | feature => minor |
| 2013-08-28 11:14 | caseydk | Fixed in Version | => 3.0.0 |
| 2013-08-28 11:17 | caseydk | Status | resolved => closed |
| Issue History |