Anonymous Login
2019-05-26 16:03 PDT

View Issue Details Jump to Notes ]
IDProjectCategoryView StatusLast Update
0001276v3.0 Release[All Projects] Generalpublic2013-08-28 11:17
Reportercarlosazevedo 
Assigned Tocaseydk 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
Product Version 
Target VersionFixed in Version3.0.0 
Summary0001276: FIX: On the files list the owner is shown by user name
DescriptionI 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');
TagsNo tags attached.
Attached Files

-Relationships
+Relationships

-Notes

~0002833

caseydk (administrator)

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