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: 3.0.0_reviewer_files.xml

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

<data>
	<sql>
		
		<query driver="mysql,mysqli">UPDATE submission_files sf, review_assignments ra SET sf.file_stage = 5, sf.assoc_type = 517, sf.assoc_id = ra.review_id WHERE ra.reviewer_file_id IS NOT NULL AND sf.file_id = ra.reviewer_file_id</query>
		<query driver="postgres,postgres64,postgres7,postgres8,postgres9">UPDATE submission_files SET file_stage = 5, assoc_type = 517, assoc_id = ra.review_id FROM review_assignments ra WHERE ra.reviewer_file_id IS NOT NULL AND submission_files.file_id = ra.reviewer_file_id</query>
		
		<query>INSERT INTO review_round_files (submission_id, review_round_id, stage_id, file_id, revision) SELECT ra.submission_id, ra.review_round_id, 3, ra.reviewer_file_id, sf.revision FROM review_assignments ra, submission_files sf WHERE ra.reviewer_file_id IS NOT NULL AND sf.file_id = ra.reviewer_file_id</query>
		
		<query>UPDATE review_assignments SET reviewer_file_id = NULL WHERE reviewer_file_id IS NOT NULL</query>
	</sql>
</data>