In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
1180 [In-Portal CMS] Database feature request N/A 2011-12-20 04:04 2012-07-25 05:32
alex  
alex  
normal  
closed 5.1.3  
fixed  
 
none 5.2.0-B1  
https://groups.google.com/d/topic/in-portal-dev/e7YXu-kvqj0/discussion
Adds qstrArray function to escape whole array
1
0001180: Improvement of "qstr" function
In-Portal uses "kDBConnection::qstr" function to escape user request variables before placing their values into database. This prevents sql injections.

However there are cases, when there is a need to escape whole array of values.

I've created kDBConnection:qstrArray function that easily allows to do that.
patch qstr_improvement_core.patch (6,153) 2011-12-20 04:04
http://tracker.in-portal.org/file_download.php?file_id=1387&type=bug
patch qstr_improvement_modules.patch (1,173) 2011-12-20 04:04
http://tracker.in-portal.org/file_download.php?file_id=1388&type=bug
Issue History
2012-07-25 05:32 alex Note Added: 0005022
2012-07-25 05:32 alex Status resolved => closed
2011-12-20 04:44 alex Note Added: 0004283
2011-12-20 04:44 alex Status reviewed and tested => resolved
2011-12-20 04:44 alex Fixed in Version => 5.2.0-B1
2011-12-20 04:44 alex Resolution open => fixed
2011-12-20 04:44 alex Assigned To !COMMUNITY => alex
2011-12-20 04:44 alex Changeset attached 5.2.x r14888
2011-12-20 04:44 alex Changeset attached 5.2.x r14887
2011-12-20 04:43 alex Note Added: 0004282
2011-12-20 04:43 alex Status needs testing => reviewed and tested
2011-12-20 04:43 alex Assigned To => !COMMUNITY
2011-12-20 04:43 alex Developer => alex
2011-12-20 04:43 alex Status active => needs testing
2011-12-20 04:43 alex Reference => https://groups.google.com/d/topic/in-portal-dev/e7YXu-kvqj0/discussion
2011-12-20 04:04 alex File Added: qstr_improvement_modules.patch
2011-12-20 04:04 alex New Issue
2011-12-20 04:04 alex File Added: qstr_improvement_core.patch
2011-12-20 04:04 alex Change Log Message => Adds qstrArray function to escape whole array
2011-12-20 04:04 alex Estimate Points => 1

Notes
(0004282)
alex   
2011-12-20 04:43   
Will test all together later.
(0004283)
alex   
2011-12-20 04:44   
Fix committed to 5.2.x branch. Commit Message:

Fixes 0001180: Improvement of "qstr" function
(0005022)
alex   
2012-07-25 05:32   
Since 5.2.0 version was released.