----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://git.reviewboard.kde.org/r/130166/#review103363 -----------------------------------------------------------
plugins/history/backends/sqlite/sqlitehistorybackend.cpp (line 49) <https://git.reviewboard.kde.org/r/130166/#comment68797> This code is full of SQL injections. Such thing is not acceptable. SQLite has prepared statments, so use them. plugins/history/backends/sqlite/sqlitehistorybackend.cpp (line 78) <https://git.reviewboard.kde.org/r/130166/#comment68798> It was needed for serialization via Qt4XML. - Pali Rohár On jún 25, 2017, 6:38 popoludní, Paulo Lieuthier wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://git.reviewboard.kde.org/r/130166/ > ----------------------------------------------------------- > > (Updated jún 25, 2017, 6:38 popoludní) > > > Review request for Kopete, Laurent Montel and Pali Rohár. > > > Repository: kopete > > > Description > ------- > > Having built a façade for the history plugin backends [1], this request > proposes the long-awaited SQLite-based backend. > > Pull from here: > https://github.com/paulolieuthier/kopete/commits/protocols-categoric-logging > > [1] https://git.reviewboard.kde.org/r/130164/ > > > Diffs > ----- > > libkopete/kopetemessage.h b5ed066838dfb708459dfe6e61e1de7bbc82ac70 > libkopete/ui/kopeteview.h 070a3b8a227acadc21aab28bcc29223585c81862 > plugins/CMakeLists.txt 6216058ef93d1c4ae7860331b6e7ef0d8be8fce2 > plugins/history/CMakeLists.txt ce90b84a3b60a15db725c29cdb8b721545503ada > plugins/history/backends/historybackend.h PRE-CREATION > plugins/history/backends/historybackendfactory.h PRE-CREATION > plugins/history/backends/historybackendfactory.cpp PRE-CREATION > plugins/history/backends/sqlite/sqlitedatabase.h PRE-CREATION > plugins/history/backends/sqlite/sqlitedatabase.cpp PRE-CREATION > plugins/history/backends/sqlite/sqlitehistorybackend.h PRE-CREATION > plugins/history/backends/sqlite/sqlitehistorybackend.cpp PRE-CREATION > plugins/history/backends/xml/xmlhistorybackend.h PRE-CREATION > plugins/history/backends/xml/xmlhistorybackend.cpp PRE-CREATION > plugins/history/converter.cpp 3175beac164b673201dff785890bc4d8b1cc68df > plugins/history/historydialog.cpp c88ce515ec11844ea1c1c1c4451fdeeab2616439 > plugins/history/historyguiclient.cpp > 41745bfe090eeda437c4fca3072f9039b2af52a8 > plugins/history/historylogger.h ad60896108d5d02e390d09db49d121fdf2f8517b > plugins/history/historylogger.cpp 66b627030f9baf78d98c010c3cc2dc3e7cc08c99 > plugins/history/historyplugin.cpp 48cd98010c2f3e65ff76ce3b6e5a43c92e988478 > plugins/history/historypreferences.cpp > 9c64b44184923aa92fe9fb252bfc5dc4d868b908 > > Diff: https://git.reviewboard.kde.org/r/130166/diff/ > > > Testing > ------- > > I only tested 1:1 conversations so far, using the Testbed protocol. > > > Thanks, > > Paulo Lieuthier > >