Code: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Admin</title>
<link rel="stylesheet" type="text/css" href="/css/mw3dailymedia.css?a=<%=now%>" />
</head>
<body>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/en_US/all.js#xfbml=1";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>
<img src="background.jpg" alt="background image" id="fixed" />
<div id="login">
<div class="fb-like" data-href="http://www.youtube.com/watch?v=mA2aTK2JQRc" data-send="true" data-width="120" data-show-faces="true"></div>
<br/>
<p>
<a href="http://www.youtube.com/subscription_center?add_user=williebeemin22" target="_blank"><img src="/subscribe.gif" border="0" alt="Photobucket"></a>
<br/>
<a href="/">home</a>
<br/>
<a href="/">login/register</a>
</p>
</div>
<div id="content">
<div id="admin">
<?php
// redifine variables for different server
require_once "textprep.php";
require_once "mysqlconfig.php";
// connect to database
$connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS);
if (!$connection)
{
die("Database connection failed: " . mysql_error());
}
// select database
$db_select = mysql_select_db(DB_NAME,$connection);
if (!$db_select)
{
die("Database selection failed: " . mysql_error());
}
//user's header
echo "<img src=\"2.gif\" alt=\"emblem\" />";
//content
// sections EDIT, TWIXTOR, GAMEPLAY, GLITCHES/CHEATS, MONTAGES, SHORT CLIPS/FAILS, NEWS, TOP3, TH3RRC
mysqlTableAdmin("edit");
mysqlTableAdmin("twixtor");
mysqlTableAdmin("gameplay");
mysqlTableAdmin("glitch");
mysqlTableAdmin("montage");
mysqlTableAdmin("short");
mysqlTableAdmin("news");
mysqlTableAdmin("top3");
mysqlTableAdmin("th3rrc");
//functions
function mysqlTableAdmin($mysqlTableName)
{
echo "
<h1>add to ".$mysqlTableName."</h1>
<form action=\"".$mysqlTableName."/post.php\" method=\"post\">
<label for=\"title\">Title</label>
<input type=\"text\" name=\"title\" id=\"title\" />
<br />
<label for=\"text\">Description</label>
<input type=\"text\" name=\"text\" id=\"text\" />
<br />
<label for=\"link\">Youtube Code</label>
<input type=\"text\" name=\"link\" id=\"link\" />
<br />
<input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Submit\" />
</form>
<img src=\"2.gif\" alt=\"emblem\" />
<h1>rearrange or delete ".$mysqlTableName."</h1>
<form action=\"".$mysqlTableName."/swaper.php\" method=\"post\">
<label for=\"text\">Text</label>
<br />
<textarea rows=\"10\" cols=\"50\" name=\"text\" id=\"text\">
";
// get table
$result = mysql_query("SELECT * FROM ".$mysqlTableName, $connection);
if (!$result)
{
die("Database query failed: " . mysql_error());
}
$i=0;
// display table
while ($row = mysql_fetch_array($result))
{
$rank[$i]=$row["rank"];
$name[$i]=$row["title"];
$i++;
}
//make a list of ranks to check for
for($j=0;$j<$i;$j++)
{
$rankList[$j]=$j+1;
}
//check the list
for($j=0;$j<$i;$j++)
{
for($k=0;$k<$i;$k++)
{
if($rankList[$j]==$rank[$k])
{
echo $rank[$k]." ".$name[$k];
if ($j<($i-1))
{
echo "\n";
}
}
}
}
echo "
</textarea>
<br />
<input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Submit\" />
</form>
<img src=\"2.gif\" alt=\"emblem\" />
";
}
?>
</div>
</div>
</body>
</html>