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/www/lib/pkp/classes/tombstone/

Edit File: DataObjectTombstoneSettingsDAO.inc.php

<?php

/**
 * @file classes/tombstone/DataObjectTombstoneSettingsDAO.inc.php
 *
 * Copyright (c) 2014-2021 Simon Fraser University
 * Copyright (c) 2000-2021 John Willinsky
 * Distributed under the GNU GPL v3. For full terms see the file docs/COPYING.
 *
 * @class DataObjectTombstoneSettingsDAO
 * @ingroup submission
 *
 * @brief Operations for retrieving and modifying submission tombstone settings.
 */

class DataObjectTombstoneSettingsDAO extends DAO {
	/**
	 * Retrieve an submission tombstone setting value.
	 * @param $tombstoneId int
	 * @param $name
	 * @param $locale string optional
	 */
	function getSetting($tombstoneId, $name, $locale = null) {
		$params = [(int) $tombstoneId, $name];
		if ($locale !== null) $params[] = $locale;
		$result = $this->retrieve(
			'SELECT setting_value, setting_type, locale FROM data_object_tombstone_settings WHERE tombstone_id = ? AND setting_name = ?'
			. ($locale !== null ? ' AND locale = ?':''),
			$params
		);

$setting = null;
		foreach ($result as $row) {
			$value = $this->convertFromDB($row->setting_value, $row->setting_type);
			if (!isset($row->locale) || $row->locale == '') $setting[$name] = $value;
			else $setting[$name][$row->locale] = $value;
		}
		return $setting;
	}

/**
	 * Add/update an submission tombstone setting.
	 * @param $tombstoneId int
	 * @param $name string
	 * @param $value mixed
	 * @param $type string data type of the setting. If omitted, type will be guessed
	 * @param $isLocalized boolean
	 */
	function updateSetting($tombstoneId, $name, $value, $type = null, $isLocalized = false) {
		if (!$isLocalized) {
			$value = $this->convertToDB($value, $type);
			$this->replace('data_object_tombstone_settings',
				[
					'tombstone_id' => $tombstoneId,
					'setting_name' => $name,
					'setting_value' => $value,
					'setting_type' => $type,
					'locale' => ''
				],
				['tombstone_id', 'setting_name', 'locale']
			);
		}
		if (is_array($value)) foreach ($value as $locale => $localeValue) {
			$this->update(
				'DELETE FROM data_object_tombstone_settings WHERE tombstone_id = ? AND setting_name = ? AND locale = ?',
				[(int) $tombstoneId, $name, $locale]
			);
			if (empty($localeValue)) continue;
			$type = null;
			$this->update('INSERT INTO data_object_tombstone_settings
				(tombstone_id, setting_name, setting_value, setting_type, locale)
				VALUES (?, ?, ?, ?, ?)',
				[(int) $tombstoneId, $name, $this->convertToDB($localeValue, $type), $type, $locale]
			);
		}
	}

/**
	 * Delete an submission tombstone setting.
	 * @param $tombstoneId int
	 * @param $name string
	 * @param $locale string optional
	 * @return int Affected row count
	 */
	function deleteSetting($tombstoneId, $name, $locale = null) {
		$params = [(int) $tombstoneId, $name];
		$sql = 'DELETE FROM data_object_tombstone_settings WHERE tombstone_id = ? AND setting_name = ?';
		if ($locale !== null) {
			$params[] = $locale;
			$sql .= ' AND locale = ?';
		}
		return $this->update($sql, $params);
	}

/**
	 * Delete all settings for an submission tombstone.
	 * @param $tombstoneId int
	 * @return int Affected row count
	 */
	function deleteSettings($tombstoneId) {
		return $this->update(
			'DELETE FROM data_object_tombstone_settings WHERE tombstone_id = ?', [(int) $tombstoneId]
		);
	}
}