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 |
|
![]() |
|
caseydk (administrator) 2013-03-04 20:26 |
Resolved, though not as described: https://github.com/web2project/web2project/commit/c2846a3978e946731901bb04746283617dd04ff1 |
![]() |
|||
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 |