function edit_ally($allyID, $tag, $name, $banner, $runden)
{
$sql = "UPDATE `" . DB_PREFIX . "ally` SET `tag` = '" . $tag . "', `name` = '" . $name . "' WHERE `allyID` = '" . $allyID . "'";
$res = mysql_query($sql);
mysqL_query("DELETE FROM `" . DB_PREFIX . "banner_of_ally` WHERE `allyID` = '" . $allyID . "'");
$sql = "INSERT INTO `" . DB_PREFIX . "banner_of_ally` VALUES";
foreach ($banner as $id) {
$sql .= " ('" . $id . "', '" . $allyID . "'),";
}
$res = mysql_query(substr($sql, 0, -1));
mysqL_query("DELETE FROM `" . DB_PREFIX . "teil_der_runde` WHERE `allyID` = '" . $allyID . "'");
$sql = "INSERT INTO `" . DB_PREFIX . "teil_der_runde` VALUES";
foreach ($runden as $id) {
$sql .= " ('" . $allyID . "', '" . $id . "'),";
}
$res = mysql_query(substr($sql, 0, -1));
}
<h1>Files</h1>
<p>In this section, you can manage the files that appear alongside posts and pages on your website.</p>
<?php
$searchquery = "SELECT * FROM files ORDER BY id DESC";
$searchresult = mysqL_query($searchquery);
$num = mysql_num_rows($searchresult);
if ($num > 0) {
echo "<p>There are " . $num . " files in the database.</p>";
echo "<table>";
echo "<tr>";
echo "<td>Title</td>";
echo "<td>Type</td>";
echo "<td>Description</td>";
echo "<td>URL</td>";
echo "<td>Filesize</td>";
echo "<td>Preview</td>";
echo "<td>Attach</td>";
echo "</tr>";
while ($row = mysql_fetch_array($searchresult, MYSQL_ASSOC)) {
echo "<tr>";
echo "<td>" . $row['title'] . "</td>";
echo "<td>" . $row['type'] . "</td>";
echo "<td>" . $row['description'] . "</td>";
echo "<td>" . $row['url'] . "</td>";
echo "<td>" . $row['filesize'] . "</td>";
echo "<td><a href=\"#\" onclick=\"window.open('" . $globalhome . $uploads . $row['url'] . "','_blank','toolbar=no,menubar=no,location=no,directories=0,status=0,scrollbars=0,resize=0');\">Preview</a></td>";
echo "<td><a href=\"#\" onclick=\"window.open('attach.php','_blank', 'width=600,height=300, toolbar=no,menubar=no,location=no,directories=0,status=0,scrollbars=0,resize=0');\">Attach</a></td>";
echo "</tr>";
}
