Server : Apache/2.4.41 (Ubuntu) System : Linux journalup 5.4.0-198-generic #218-Ubuntu SMP Fri Sep 27 20:18:53 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, Directory :  /var/www/html/dbscripts/xml/upgrade/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE data SYSTEM "../../../lib/pkp/dtd/xmlData.dtd">

<!--
  * event_log_oneclickuserid.xml
  *
  * Copyright (c) 2014-2020 Simon Fraser University
  * Copyright (c) 2003-2020 John Willinsky
  * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
  *
  * Add missing user id on event logs from 'one-click' reviews.
  -->
<data>
	<sql>
		<query driver="mysql,mysqli"> <!-- pkp/pkp-lib#4263 -->
			UPDATE event_log el JOIN ( event_log_settings els JOIN review_assignments ra ) ON ( els.log_id=el.log_id AND els.setting_name='reviewId' AND ra.review_id=els.setting_value )
			SET el.user_id = ra.reviewer_id
			WHERE el.user_id=0 AND el.event_type IN ( 1073741830, 1073741831, 1073741833, 1073741843 )
		</query> <!-- SUBMISSION_LOG_REVIEW_ACCEPT, SUBMISSION_LOG_REVIEW_DECLINE, SUBMISSION_LOG_REVIEW_UNCONSIDERED, SUBMISSION_LOG_REVIEW_FILE -->
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">
			UPDATE event_log el
			SET user_id = ra.reviewer_id
			FROM event_log_settings els, review_assignments ra
			WHERE
				el.user_id=0 AND el.event_type IN ( 1073741830, 1073741831, 1073741833, 1073741843 ) AND
				els.log_id=el.log_id AND els.setting_name='reviewId' AND
				ra.review_id=CAST(els.setting_value AS INTEGER)
		</query><!-- SUBMISSION_LOG_REVIEW_ACCEPT, SUBMISSION_LOG_REVIEW_DECLINE, SUBMISSION_LOG_REVIEW_UNCONSIDERED, SUBMISSION_LOG_REVIEW_FILE -->
	</sql>
</data>