editsmilies.php

<?php
//  AcmlmBoard XD - Smiley editing tool
//  Access: administrators only

include("lib/common.php");

AssertForbidden("editSmilies");

if($loguser['powerlevel'] < 3)
	Kill("You must be an administrator to edit the smiley table.");
	
$key = hash('sha256', "{$loguserid},{$loguser['pss']},{$salt}");
if (isset($_POST['action']) && $key != $_POST['key'])
	Kill(__("No."));

if($_POST['action'] == "Apply")
{
	$qSmilies = "select * from smilies";
	$rSmilies = Query($qSmilies);
	$numSmilies = NumRows($rSmilies);

	for($i = 0; $i <= $numSmilies; $i++)
	{
		if($_POST['code_'.$i] != $_POST['oldcode_'.$i] || $_POST['image_'.$i] != $_POST['oldimage_'.$i])
		{
			if($_POST['code_'.$i] == "")
			{
				$act = "deleted";
				$qSmiley = "delete from smilies where code='".$_POST['oldcode_'.$i]."'";
			} else
			{
				$act = "edited to \"".$_POST['image_'.$i]."\"";
				$qSmiley = "update smilies set code='".$_POST['code_'.$i]."', image='".$_POST['image_'.$i]."' where code='".$_POST['oldcode_'.$i]."'";
			}
			$rSmiley = Query($qSmiley);
			$log .= "Smiley \"".$_POST['oldcode_'.$i]."\" ".$act.".<br />";
		}
	}

	if($_POST['code_add'] && $_POST['image_add'])
	{
		$qSmiley = "insert into smilies (code,image) value ('".$_POST['code_add']."', '".$_POST['image_add']."')";
		$rSmiley = Query($qSmiley);
		$log .= "Smiley \"".$_POST['code_add']."\" added.<br />";
	}
	if($log)
		Alert($log,"Log");
}

$smileyList = "";
$qSmilies = "select * from smilies";
$rSmilies = Query($qSmilies);
while($smiley = Fetch($rSmilies))
{
	$cellClass = ($cellClass+1) % 2;
	$i++;

	$smileyList .= format(
"
			<tr class=\"cell{0}\">
				<td>
					<input type=\"text\" name=\"code_{1}\" value=\"{2}\" />
					<input type=\"hidden\" name=\"oldcode_{1}\" value=\"{2}\" />
				</td>
				<td>
					<input type=\"text\" name=\"image_{1}\" value=\"{3}\" />
					<input type=\"hidden\" name=\"oldimage_{1}\" value=\"{3}\" />
					<img src=\"img/smilies/{4}\" alt=\"{5}\" title=\"{5}\">
				</td>
			</tr>
",	$cellClass, $i, htmlentities2($smiley['code']), htmlentities2($smiley['image']),
	$smiley['image'], $smiley['code']);
}

write(
"
	<div class=\"outline margin width25 faq\">
		To add, fill in both bottom fields and apply.<br />
		To edit, change either code or image fields to <em>not</em> match their hidden counterparts.
	</div>

	<form method=\"post\" action=\"editsmilies.php\">

		<table class=\"outline margin\" style=\"width: 30%;\">
			<tr class=\"header1\">
				<th>
					Code
				</th>
				<th>
					Image
				</th>
			</tr>
			{0}
			<tr class=\"header0\">
				<th colspan=\"2\">
					Add
				</th>
			</tr>
			<tr class=\"cell2\">
				<td>
					<input type=\"text\" name=\"code_add\" />
				</td>
				<td>
					<input type=\"text\" name=\"image_add\" />
				</td>
			</tr>

			<tr class=\"cell2\">
				<td>
				</td>
				<td>
					<input type=\"submit\" name=\"action\" value=\"Apply\" />
					<input type=\"hidden\" name=\"key\" value=\"{1}\" />
				</td>
			</tr>

		</table>
	</form>
", $smileyList, $key);

?>