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

Edit File: 3.2.0_url_path.xml

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

<data>
	<sql>
		<query>
			UPDATE publications as p
			SET url_path = (
				SELECT ps.setting_value
				FROM publication_settings as ps
				WHERE ps.publication_id = p.publication_id
					AND ps.setting_name = 'pub-id::publisher-id'
			)
		</query>
		<query>
			UPDATE issues as i
			SET url_path = (
				SELECT ist.setting_value
				FROM issue_settings as ist
				WHERE ist.issue_id = i.issue_id
					AND ist.setting_name = 'pub-id::publisher-id'
			)
		</query>
		<query>
			UPDATE issue_galleys as ig
			SET url_path = (
				SELECT igs.setting_value
				FROM issue_galley_settings as igs
				WHERE igs.galley_id = ig.galley_id
					AND igs.setting_name = 'pub-id::publisher-id'
			)
		</query>
		<query>
			UPDATE publication_galleys as g
			SET url_path = (
				SELECT gs.setting_value
				FROM publication_galley_settings as gs
				WHERE gs.galley_id = g.galley_id
					AND gs.setting_name = 'pub-id::publisher-id'
			)
		</query>
	</sql>
</data>