? ? Pending

User tests: Successful: Unsuccessful:

avatar HLeithner
HLeithner
29 May 2019

Summary of Changes

Updated SQL queries to prepared statements and made some cleanups around the queries.

Testing Instructions

Use the plugin in all ways you can think of.

  • Activate the privacy extension with actionlog
  • change the state of a article
  • You should see the change in the actionlog as without the PR

Expected result

Nothing changed.

avatar HLeithner HLeithner - open - 29 May 2019
avatar HLeithner HLeithner - change - 29 May 2019
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 29 May 2019
Category Front End Plugins
avatar franz-wohlkoenig franz-wohlkoenig - change - 30 May 2019
Title
Add prepared statements for plg_actionlog_joomla
[4.0] Add prepared statements for plg_actionlog_joomla
avatar franz-wohlkoenig franz-wohlkoenig - edited - 30 May 2019
avatar Quy
Quy - comment - 5 Jun 2019

I have tested this item successfully on 198a4e4


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/25046.

avatar Quy Quy - test_item - 5 Jun 2019 - Tested successfully
avatar alikon
alikon - comment - 5 Jun 2019

I have tested this item successfully on 198a4e4


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/25046.

avatar alikon alikon - test_item - 5 Jun 2019 - Tested successfully
avatar alikon alikon - change - 5 Jun 2019
Status Pending Ready to Commit
avatar alikon
alikon - comment - 5 Jun 2019

RTC


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/25046.

avatar roland-d
roland-d - comment - 7 Jun 2019

@HLeithner the code works but is it correct the query is:

`SELECT `title`,`id`
FROM `jos_content`
WHERE `id` IN (:preparedArray1)

The :preparedArray1 looks odd.

avatar HLeithner
HLeithner - comment - 7 Jun 2019

:preparedArray1 is defined in the database driver. I selected this name because I hope nobody else will use it by accident.

avatar SniperSister SniperSister - change - 8 Jun 2019
Labels Added: ?
avatar SniperSister SniperSister - close - 8 Jun 2019
avatar SniperSister SniperSister - merge - 8 Jun 2019
avatar SniperSister SniperSister - change - 8 Jun 2019
Status Ready to Commit Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 2019-06-08 18:39:42
Closed_By SniperSister
Labels Added: ?
avatar SniperSister
SniperSister - comment - 8 Jun 2019

Merged, thanks!

Add a Comment

Login with GitHub to post a comment