One Hat Cyber Team

Your IP : 216.73.216.182

Server IP : 203.175.9.166

Server : Linux tanggamus.iixcp.rumahweb.net 5.14.0-427.28.1.el9_4.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Aug 2 03:44:10 EDT 2024 x86_64

Server Software : LiteSpeed

PHP Version : 7.4.33

Buat File | Buat Folder

Dir : ~/home/cite5577/public_html/dbscripts/xml/upgrade/

Edit File: event_log_oneclickuserid.xml

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

<data>
	<sql>
		<query driver="mysql,mysqli"> 
			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> 
		<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>
	</sql>
</data>