<?php
/**
 * Title: Character Skills
 * Icon: fa-bolt
 * Group: Players
 * Order: 30
 * Description: Read and rewrite a character's level, vocation and skills.
 */

if (!defined('ACP_ROOT')) {
	http_response_code(403);
	die('Direct access denied.');
}

function acp_skill_value(?array $skills, int $index): int {
	return (is_array($skills) && isset($skills[$index]['value'])) ? (int)$skills[$index]['value'] : 0;
}

$isTfs10 = (znote_server_adapter()->normalizedEngine() === 'TFS_10');

// ---------------------------------------------------------------------------
// Save
// ---------------------------------------------------------------------------
if (isset($_POST['pid']) && intv($_POST['pid']) > 0) {

	$pid        = intv($_POST['pid']);
	$backToName = trim((string)($_POST['name'] ?? ''));

	$isOnline = $isTfs10 ? user_is_online_10($pid) : user_is_online($pid);

	if ($isOnline) {
		acp_flash_error(t('acp.skl.must_offline'));
	} else {
		$level    = intv($_POST['level'] ?? 1);
		$vocation = intv($_POST['vocation'] ?? 0);

		// Base stats, derived exactly like character creation does.
		$playercnf = $config['player'];
		$statgain  = $config['vocations_gain'][$vocation] ?? ['hp' => 0, 'mp' => 0, 'cap' => 0];

		$levelsFromBase = $level - intv($playercnf['base']['level']);

		$newHp  = intv($playercnf['base']['health'] + ($statgain['hp']  * $levelsFromBase));
		$newMp  = intv($playercnf['base']['mana']   + ($statgain['mp']  * $levelsFromBase));
		$newCap = intv($playercnf['base']['cap']    + ($statgain['cap'] * $levelsFromBase));

		$fist   = intv($_POST['fist']   ?? 0);
		$club   = intv($_POST['club']   ?? 0);
		$sword  = intv($_POST['sword']  ?? 0);
		$axe    = intv($_POST['axe']    ?? 0);
		$dist   = intv($_POST['dist']   ?? 0);
		$shield = intv($_POST['shield'] ?? 0);
		$fish   = intv($_POST['fish']   ?? 0);
		$magic  = intv($_POST['magic']  ?? 0);

		$db = db();
		if (!$db->beginTransaction()) {
			acp_flash_error('Could not start the database transaction.');
			acp_redirect('skills', $backToName !== '' ? ['name' => $backToName] : []);
		}

		$ok = true;
		if (!$isTfs10) {
			// TFS 0.x keeps skills in their own table.
			foreach ([0 => $fist, 1 => $club, 2 => $sword, 3 => $axe, 4 => $dist, 5 => $shield, 6 => $fish] as $skillId => $skillValue) {
				$ok = $ok && $db->execute(
					"UPDATE `player_skills` SET `value` = ? WHERE `player_id` = ? AND `skillid` = ? LIMIT 1;",
					[$skillValue, $pid, $skillId]
				);
			}

			$ok = $ok && $db->execute("
				UPDATE `players`
				SET `maglevel` = ?,
					`vocation` = ?,
					`level` = ?,
					`experience` = ?,
					`health` = ?,
					`healthmax` = ?,
					`mana` = ?,
					`manamax` = ?,
					`cap` = ?
				WHERE `id` = ?
				LIMIT 1;
			", [$magic, $vocation, $level, level_to_experience($level), $newHp, $newHp, $newMp, $newMp, $newCap, $pid]);
		} else {
			$ok = $db->execute("
				UPDATE `players`
				SET `vocation` = ?,
					`level` = ?,
					`experience` = ?,
					`health` = ?,
					`healthmax` = ?,
					`mana` = ?,
					`manamax` = ?,
					`cap` = ?,
					`skill_fist` = ?,
					`skill_club` = ?,
					`skill_sword` = ?,
					`skill_axe` = ?,
					`skill_dist` = ?,
					`skill_shielding` = ?,
					`skill_fishing` = ?,
					`maglevel` = ?
				WHERE `id` = ?
				LIMIT 1;
			", [$vocation, $level, level_to_experience($level), $newHp, $newHp, $newMp, $newMp, $newCap, $fist, $club, $sword, $axe, $dist, $shield, $fish, $magic, $pid]);
		}

		if ($ok) {
			$db->commit();
			acp_log('player.update_skills', $backToName, [
				'level' => $level, 'vocation' => $vocation, 'magic' => $magic,
				'fist' => $fist, 'club' => $club, 'sword' => $sword, 'axe' => $axe,
				'dist' => $dist, 'shield' => $shield, 'fish' => $fish,
			]);
			acp_flash_success(t('acp.skl.updated'));
		} else {
			$db->rollback();
			acp_flash_error('Could not update character skills.');
		}
	}

	acp_redirect('skills', $backToName !== '' ? ['name' => $backToName] : []);
}

// ---------------------------------------------------------------------------
// Load
// ---------------------------------------------------------------------------
$name   = isset($_GET['name']) ? trim((string)$_GET['name']) : '';
$skills = null;
$pid    = 0;

if ($name !== '') {
	if (!user_character_exist($name)) {
		acp_flash_error(t('acp.skl.not_found', ['name' => '<strong>' . h($name) . '</strong>']));
		acp_redirect('skills');
	}

	$pid = (int)user_character_id($name);

	if (!$isTfs10) {
		$rows = db()->fetchAll("
			SELECT `value` FROM `player_skills`
			WHERE `player_id` = ?
			ORDER BY `skillid` ASC
			LIMIT 7;
		", [$pid]);

		// The character can exist without skill rows yet.
		$skills = is_array($rows) ? $rows : [];

		$player = db()->fetchOne("
			SELECT `maglevel`, `level`, `vocation`
			FROM `players`
			WHERE `id` = ?
			LIMIT 1;
		", [$pid]);
		if (!is_array($player)) {
			$player = ['maglevel' => 0, 'level' => 0, 'vocation' => 0];
		}

		// Pad missing skill rows so indexes 0-6 always exist.
		while (count($skills) < 7) {
			$skills[] = ['value' => 0];
		}

		$skills[] = ['value' => $player['maglevel']];
		$skills[] = ['value' => $player['level']];
		$skills[] = ['value' => $player['vocation']];
	} else {
		$p = db()->fetchOne("
			SELECT `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`,
				   `skill_dist`, `skill_shielding`, `skill_fishing`,
				   `maglevel`, `level`, `vocation`
			FROM `players`
			WHERE `id` = ?
			LIMIT 1;
		", [$pid]);
		if (!is_array($p)) {
			$p = [];
		}

		$skills = [
			['value' => $p['skill_fist']       ?? 0],
			['value' => $p['skill_club']       ?? 0],
			['value' => $p['skill_sword']      ?? 0],
			['value' => $p['skill_axe']        ?? 0],
			['value' => $p['skill_dist']       ?? 0],
			['value' => $p['skill_shielding']  ?? 0],
			['value' => $p['skill_fishing']    ?? 0],
			['value' => $p['maglevel']         ?? 0],
			['value' => $p['level']            ?? 0],
			['value' => $p['vocation']         ?? 0],
		];
	}
}

$loaded = ($name !== '');
?>

<?php if (!$loaded): ?>

	<section class="acp-card" style="max-width:520px;">
		<header class="acp-card-head">
			<h2><?= t('acp.skl.lookup_title') ?></h2>
			<p><?= t('acp.skl.lookup_sub') ?></p>
		</header>
		<div class="acp-card-body">
			<form method="get">
				<input type="hidden" name="p" value="skills">
				<div class="acp-field">
					<label class="acp-label" for="name"><?= t('acp.skl.char_name') ?></label>
					<input class="acp-input" id="name" name="name" placeholder="<?= h(t('acp.skl.char_name')) ?>" autofocus required>
				</div>
				<div class="acp-actions">
					<button class="acp-btn" type="submit"><i class="fa fa-search"></i> <?= t('acp.skl.fetch') ?></button>
				</div>
			</form>
		</div>
	</section>

<?php else: ?>

	<div class="acp-toolbar">
		<div>
			<strong><?= h($name) ?></strong>
			<span class="acp-pill acp-pill--grey">#<?= (int)$pid ?></span>
			<a href="<?= h(acp_site('characterprofile.php?name=' . urlencode($name))) ?>" target="_blank" rel="noopener"><?= t('acp.skl.view_profile') ?></a>
		</div>
		<a class="acp-btn acp-btn--ghost acp-btn--sm" href="<?= h(acp_url('skills')) ?>">
			<i class="fa fa-refresh"></i> <?= t('acp.skl.search_another') ?>
		</a>
	</div>

	<form method="post" data-confirm="<?= h(t('acp.skl.confirm_overwrite')) ?>">
		<?= acp_csrf_field() ?>
		<input type="hidden" name="pid" value="<?= (int)$pid ?>">
		<input type="hidden" name="name" value="<?= h($name) ?>">

		<div class="acp-grid acp-grid--2">
			<section class="acp-card">
				<header class="acp-card-head"><h2><?= t('acp.skl.character_title') ?></h2></header>
				<div class="acp-card-body">
					<div class="acp-field">
						<label class="acp-label" for="vocation"><?= t('acp.skl.vocation') ?></label>
						<select class="acp-select" id="vocation" name="vocation">
							<?php foreach (($config['vocations'] ?? []) as $vid => $v): ?>
								<option value="<?= (int)$vid ?>" <?= (int)$vid === acp_skill_value($skills, 9) ? 'selected' : '' ?>>
									<?= h($v['name']) ?>
								</option>
							<?php endforeach; ?>
						</select>
					</div>
					<div class="acp-row">
						<div class="acp-field">
							<label class="acp-label" for="level"><?= t('acp.skl.level') ?></label>
							<input class="acp-input" id="level" name="level" type="number" min="1" value="<?= acp_skill_value($skills, 8) ?>">
						</div>
						<div class="acp-field">
							<label class="acp-label" for="magic"><?= t('acp.skl.magic_level') ?></label>
							<input class="acp-input" id="magic" name="magic" type="number" min="0" value="<?= acp_skill_value($skills, 7) ?>">
						</div>
					</div>
					<p class="acp-hint">
						<?= t('acp.skl.recalc_hint', [
							'base' => '<code>$config[\'player\'][\'base\']</code>',
							'gain' => '<code>$config[\'vocations_gain\']</code>',
						]) ?>
					</p>
				</div>
			</section>

			<section class="acp-card">
				<header class="acp-card-head"><h2><?= t('acp.skl.skills_title') ?></h2></header>
				<div class="acp-card-body">
					<div class="acp-row">
						<div class="acp-field">
							<label class="acp-label" for="fist"><?= t('acp.skl.fist') ?></label>
							<input class="acp-input" id="fist" name="fist" type="number" min="0" value="<?= acp_skill_value($skills, 0) ?>">
						</div>
						<div class="acp-field">
							<label class="acp-label" for="club"><?= t('acp.skl.club') ?></label>
							<input class="acp-input" id="club" name="club" type="number" min="0" value="<?= acp_skill_value($skills, 1) ?>">
						</div>
						<div class="acp-field">
							<label class="acp-label" for="sword"><?= t('acp.skl.sword') ?></label>
							<input class="acp-input" id="sword" name="sword" type="number" min="0" value="<?= acp_skill_value($skills, 2) ?>">
						</div>
					</div>
					<div class="acp-row">
						<div class="acp-field">
							<label class="acp-label" for="axe"><?= t('acp.skl.axe') ?></label>
							<input class="acp-input" id="axe" name="axe" type="number" min="0" value="<?= acp_skill_value($skills, 3) ?>">
						</div>
						<div class="acp-field">
							<label class="acp-label" for="dist"><?= t('acp.skl.dist') ?></label>
							<input class="acp-input" id="dist" name="dist" type="number" min="0" value="<?= acp_skill_value($skills, 4) ?>">
						</div>
						<div class="acp-field">
							<label class="acp-label" for="shield"><?= t('acp.skl.shield') ?></label>
							<input class="acp-input" id="shield" name="shield" type="number" min="0" value="<?= acp_skill_value($skills, 5) ?>">
						</div>
					</div>
					<div class="acp-field" style="max-width:200px;">
						<label class="acp-label" for="fish"><?= t('acp.skl.fish') ?></label>
						<input class="acp-input" id="fish" name="fish" type="number" min="0" value="<?= acp_skill_value($skills, 6) ?>">
					</div>
				</div>
			</section>
		</div>

		<div class="acp-actions">
			<button class="acp-btn acp-btn--green" type="submit"><i class="fa fa-save"></i> <?= t('acp.skl.save') ?></button>
			<span class="acp-hint"><?= t('acp.skl.offline_hint') ?></span>
		</div>
	</form>

<?php endif; ?>