Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as PHP by narco ( 15 years ago )
<?php
if (!isset($_SESSION['user_id'])) { die('login!'); }
?>
<h1>Releases</h1>
<br/>
Waehl eine Section:<br/>
<ul>
<li><a href="?section=release&normal;">Release Normal</a></li>
<li><a href="?section=release&special;">Release Special</a></li>
<li><a href="?section=release&mixes;">Release Mixes</a></li>
</ul>
<hr />
<div id="release_content">
<?php
if (isset($_GET['normal'])) { $section = 'normal'; }
if (isset($_GET['special'])) { $section = 'special'; }
if (isset($_GET['mixes'])) { $section = 'mixes'; }
if ($section == TRUE) {
echo '<form method="POST">';
echo '<input type="hidden" name="section" value="'.$section.'" />';
echo '<input type="submit" name="release_add" value="Release Add" class="button" />';
echo '</form>';
echo '<hr/>';
}
if (isset($_POST['release_add'])) {
?>
<table>
<tr>
<td>Katalog:</td>
<td><input type="text" name="rnkat" value="" /></td>
</tr>
<tr>
<td>Artist:</td>
<td><input type="text" name="rnartist" value="" /></td>
</tr>
<tr>
<td>Titel:</td>
<td><input type="text" name="rntitel" value="" /></td>
</tr>
<tr>
<td>Release-Date:</td>
<td><input type="text" name="rnreleasedate" value="" /></td>
</tr>
<tr>
<td>Laenge:</td>
<td><input type="text" name="rnlaenge" value="" /></td>
</tr>
<tr>
<td>Genre:</td>
<td><input type="text" name="rngenre" value="" /></td>
</tr>
<tr>
<td>Qualitaet:</td>
<td><input type="text" name="rnquali" value="320kb/s mp3" /></td>
</tr>
<tr>
<td>Artwork:</td>
<td><input type="text" name="rnartwork" value="" /></td>
</tr>
<tr>
<td>Counter URL:</td>
<td><input type="text" name="rncounter" value="" /></td>
</tr>
<tr>
<td>Release Download URL/Name:</td>
<td><input type="text" name="rncomprelease" value="" /><input type="text" name="rncomprelease_name" value="" /></td>
</tr>
<?php
if ($section == 'mixes') {
echo '<td>Playlist:</td><td><input type="text" name="playlist" value="" /></td></tr>';
}
?>
</table>
<?php
if ($section == 'normal' or $section == 'special') {
echo '<table><tr><td>URL </td><td>URL Name </td><td>Zeit </td><td>MB </td></tr></table>';
}
if($section != 'mixes') {
?>
<table id="uploadtable">
<tr>
<td></td>
</tr>
<tr>
<td>Link 1 </td>
<td><input name="link[]" type="text" size="38" /><input name="linkname[]" type="text" size="38" /><input name="playtime[]" type="text" size="5" /><input name="mb[]" type="text" size="5" /> <a href="[removed]NeuesFeld()">+</a></td>
</tr>
<tr id="uploadfeld"></tr>
<tr>
<td></td><td></td>
</tr>
<tr>
<td></td><td></td>
</tr>
</table>
<?php
}
?>
<br/>
<input type="submit" name="rnsubmit" value="OK" class="button" />
</form>
<br/>
<hr/>
<?php
}
######### Release edit
if (isset($_POST['release_edit'])) {
$release_id_edit = $_POST['release_id'];
$release_edit_sql = "SELECT * FROM releases WHERE section = '$section' AND release_id = '$release_id_edit'";
$release_edit_ausgabe = mysql_query($release_edit_sql);
mysql_error();
echo '<form method="post">';
while($row = mysql_fetch_array($release_edit_ausgabe, MYSQL_ASSOC)) {
echo '<table><tr><td>Katalog:</td><td><input type="text" size="50" name="rnkat" value="'.htmlspecialchars($row['katalog']).'" /></td>';
echo '<input type="hidden" size="2" name="releaseeditid" size="50" value="'.htmlspecialchars($row['id']).'" />';
echo '</tr><tr><td>Artis:</td><td><input type="text" size="50" name="rnartist" value="'.htmlspecialchars($row['artist']).'" /></td>';
echo '</tr><tr><td>Titel:</td><td><input type="text" size="50" name="rntitel" value="'.htmlspecialchars($row['titel']).'" /></td>';
echo '</tr><tr><td>Release-Date:</td><td><input type="text" size="50" name="rnreleasedate" value="'.htmlspecialchars($row['date']).'" /></td>';
echo '</tr><tr><td>Laenge:</td><td><input type="text" size="50" name="rnlaenge" value="'.htmlspecialchars($row['laenge']).'" /></td>';
echo '</tr><tr><td>Genre:</td><td><input type="text" size="50" name="rngenre" value="'.htmlspecialchars($row['genre']).'" /></td>';
echo '</tr><tr><td>Qualitaet:</td><td><input type="text" size="50" name="rnquali" value="'.htmlspecialchars($row['quali']).'" /></td>';
echo '</tr><tr><td>Artwork:</td><td><input type="text" size="50" name="rnartwork" value="'.htmlspecialchars($row['artwork']).'" /></td>';
echo '</tr><tr><td>Counter URL:</td><td><input type="text" size="50" name="rncounter" value="'.htmlspecialchars($row['counter']).'" /></td></tr>';
echo '</tr><tr><td>Komplett Release URL/Name:</td><td><input type="text" size="20" name="rncomprelease" value="'.htmlspecialchars($row['comprelease']).'" /><input type="text" name="rncomprelease_name" size="25" value="'.htmlspecialchars($row['compreleasename']).'" /></td></tr></table>';
}
if ($section == 'normal' or $section == 'special') {
echo '<table><tr><td>URL </td><td>URL Name </td><td>Zeit </td><td>MB </td></tr>';
}
$link_id_edit = $_POST['release_id'];
$link_edit_sql = "SELECT * FROM release_links WHERE section = '$section' AND release_id = '$release_id_edit'";
$link_edit_ausgabe = mysql_query($link_edit_sql);
$linkid = 0;
mysql_error();
while($row = mysql_fetch_array($link_edit_ausgabe, MYSQL_ASSOC)) {
echo '<tr><td><input name="link['.$linkid.']" type="text" size="38" value="'.$row['link'].'" /></td><td>
<input name="linkname['.$linkid.']" type="text" size="38" value="'.$row['linkname'].'" /></td><td>
<input name="playtime['.$linkid.']" type="text" size="5" value="'.$row['playtime'].'" /></td><td>
<input name="mb['.$linkid.']" type="text" size="5" value="'.$row['mb'].'" /></td></tr>';
$linkid++;
}
if ($section == 'normal' or $section == 'special') {
echo '</table>';
}
echo '<br/><input type="submit" name="rneditsubmit" value="OK" class="button" /></form><hr/>';
}
if(isset($_POST['rneditsubmit'])){
$id = $_POST['id'];
$link = $_POST['link'];
$linkname = $_POST['linkname'];
$playtime = $_POST['playtime'];
$mb = $_POST['mb'];
$rnkat = $_POST['rnkat'];
$rnartist = $_POST['rnartist'];
$rntitel = $_POST['rntitel'];
$rndate = $_POST['rnreleasedate'];
$rnlaenge = $_POST['rnlaenge'];
$rngenre = $_POST['rngenre'];
$rnquali = $_POST['rnquali'];
$rnartwork = $_POST['rnartwork'];
$rncounter = $_POST['rncounter'];
$rncomprelease = $_POST['rncomprelease'];
$rncompreleasename = $_POST['rncomprelease_name'];
$release_id_edit = $_POST['releaseeditid'];
######### release info update
$release_update_sql = "UPDATE releases SET katalog = '".mysql_real_escape_string($rnkat)."', artist = '".mysql_real_escape_string($rnartist)."', titel = '".mysql_real_escape_string($rntitel)."', date = '".mysql_real_escape_string($rndate)."', laenge = '".mysql_real_escape_string($rnlaenge)."', genre = '".mysql_real_escape_string($rngenre)."', quali = '".mysql_real_escape_string($rnquali)."', artwork = '".mysql_real_escape_string($rnartwork)."', counter = '".mysql_real_escape_string($rncounter)."', comprelease = '".mysql_real_escape_string($rncomprelease)."', compreleasename = '".mysql_real_escape_string($rncompreleasename)."' WHERE section = '$section' AND id = '$release_id_edit'";
$release_update_qry = mysql_query($release_update_sql) or die (mysql_error());
########## LINK update
$idsql = "SELECT id FROM release_links WHERE section = '$section' AND release_id = '$release_id_edit'";
$id = mysql_query($idsql);
foreach ($link as $value => $links){
while ($row = mysql_fetch_array($id, MYSQL_ASSOC)) {
$sql = "UPDATE release_links SET link = '".mysql_real_escape_string($link[$value])."', linkname = '".mysql_real_escape_string($linkname[$value])."', playtime = '".mysql_real_escape_string($playtime[$value])."', mb = '".mysql_real_escape_string($mb[$value])."' WHERE section = '".$section."' AND id = '".$row['id']."'";
$result = mysql_query($sql);
$value++;
}
}
}
####### Release Übersicht
?>
</div>
<div id="news_content">
<?php
$releasesql = "SELECT * FROM releases WHERE section = '$section' ORDER BY id DESC";
$releaseqry = mysql_query($releasesql);
mysql_error();
while($row = mysql_fetch_array($releaseqry, MYSQL_ASSOC)) {
echo '<br />URL ID: '.htmlspecialchars($row['release_id']).'<br />';
echo '<table><tr><td width="150">';
echo '<img src="../images/'.htmlspecialchars($row['katalog']).'_cover_klein.jpg" alt="" /></a></td><td width="200">';
echo '<p>';
echo 'Katalog: '.htmlspecialchars($row['katalog']).'<br />';
echo 'Artist: '.htmlspecialchars($row['artist']).'<br />';
echo 'Titel: '.htmlspecialchars($row['titel']).'<br />';
echo 'Release-Date: '.htmlspecialchars($row['date']).'<br />';
echo 'Laenge: '.htmlspecialchars($row['laenge']).'<br />';
echo 'Genre: '.htmlspecialchars($row['genre']).'<br />';
echo 'Qualitaet: '.htmlspecialchars($row['quali']).'<br />';
echo 'Artwork: '.htmlspecialchars($row['artwork']).'<br />';
echo 'Lizenz: <a href="http://creativecommons.org/licenses/by-nc-nd/3.0/de/" target="_blank" class="hplinks">by-nc-sa</a>';
echo '</p></td></tr><tr>';
echo '<td><form method="POST"><input type="hidden" name="release_id" value="'.htmlspecialchars($row['release_id']).'" />';
echo '<input type="hidden" name="section" value="'.$row['section'].'" />';
echo '<input type="submit" name="release_edit" value="Edit" class="button" /></form></td><td>';
echo '<div class="linkbutton"><a href="../promo/'.$row['katalog'].'.txt" rel="promo">View Promotion Text</a></div></td></tr></table>';
}
?>
</div>
Revise this Paste