Quote:
Originally Posted by clocktower
theres one on tbdev
|
Tried to take fashions with TBDEV Who does not receive can lay out fashions for 5.1 please
These files alter who can for TS v 5.1 please
PHP Code:
CREATE TABLE `youtubevideo` (
`id` bigint(20) NOT NULL auto_increment,
`link` varchar(100) character set utf8 NOT NULL,
`name` varchar(100) character set utf8 NOT NULL,
`addedby` varchar(100) character set utf8 NOT NULL,
`addtime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=28 ;
PHP Code:
<?
require_once("include/bittorrent.php");
dbconn(false);
loggedinorreturn();
if ($_GET["id"] != ""){
$id = $_GET["id"];
if (get_user_class() >= UC_USER){
mysql_query("DELETE FROM youtubevideo WHERE id= $id") or sqlerr(__FILE__, __LINE__);
}
else{
stderr("Sorry", "not authorized!");
}
}
if ($_SERVER["REQUEST_METHOD"] == "POST")
{
if ($_POST["link"] == "" || $_POST["name"] == "")
stderr("Error", "missing form data.");
$name = $_POST["name"];
$user = $CURUSER["username"];
$link = "http://youtube.com/v/".$_POST[link]."";
mysql_query("INSERT INTO youtubevideo (link, name, addedby, addtime) VALUES('$link', '$name', '$user',NOW())") or sqlerr(__FILE__, __LINE__);
}
stdhead("YouTube ");
print("<table border=1 cellspacing=0 cellpadding=0 align=center><tr>");
print("<td width=502 valign=top>");
print("<table width=502 border=1>");
?>
<style type="text/css">
</style>
<table cellpadding="4" cellspacing="1" border="0" style="width:100%" class="tableinborder">
<tr class="tabletitle" width="100%">
<td colspan="10" width="100%"><span class="normalfont"><center><b> </b></center></span></td>
</tr><tr><td width="100%" class="tablea">
<center>
<p><br>
<span class="style3"><b><font color=blue>!</font></b></span> </p>
</center>
<tr><td
<br>
<tr><td>
</form> <iframe src="" name="games" width="570" height="400" scrolling="no"></iframe></td></tr>
</table></td>
<?
print("<td width=300 valign=top><table border=1>");
?>
<table cellpadding="4" cellspacing="1" border="0" style="width:100%" class="tableinborder">
<tr class="tabletitle" width="100%">
<td colspan="10" width="100%"><span class="normalfont"><center><b> </b></center></span></td>
</tr><tr><td width="100%" class="tablea">
<center>
<p><br>
<span class="style3"><b><font color=blue> </font></b></span> </p>
</center>
<?
$query = "SELECT * FROM youtubevideo ORDER BY name";
$sql = mysql_query($query);
while ($row = mysql_fetch_array($sql)) {
$link = $row['link'];
$name = $row['name'];
print("<tr><td align=left> <a href=".$link." target=games>".$name."</td></tr>");
}
print("</table>");
print("</td></tr></table>");
if (get_user_class() >= UC_USER){
print("<br><br>");
begin_frame(" ", FALSE, "100px");
?>
<form method="post" action="youtube.php">
<? begin_table(TRUE); ?>
<div align=center>
: "http://youtube.com/watch?v=qppuuQrklHg"<br><br>
: qppuuQrklHg
<br></div><br>
<tr><td class="tableb">:</td><td class="tablea"><input type="text" name="link" size="60"></td></tr>
<tr><td class="tableb">:</td><td class="tablea"><input type="text" name="name" size="60"></td></tr>
<tr><td class="tablea" colspan="2" style="text-align:center"><input type="submit" value="Okay" class="btn"></td></tr>
<? end_table(); ?>
</form>
<?
end_frame();
begin_frame(' ', FALSE, "100%;");
begin_table(TRUE);
?>
<colgroup>
<col width="10">
<col width="15%">
<col width="25%">
<col width="20%">
<col width="20%">
<col width="10">
</colgroup>
<tr>
<td class="tablecat"><div align="center"> ID</div></td>
<td class="tablecat"><div align="center"> </div></td>
<td class="tablecat"><div align="center"> </div></td>
<td class="tablecat"><div align="center"> </div></td>
<td class="tablecat"><div align="center"> </div></td>
<td class="tablecat"><div align="center"> </div></td>
</tr>
<tr>
<?
$query = "SELECT * FROM youtubevideo ORDER BY id";
$sql = mysql_query($query);
while ($row2 = mysql_fetch_array($sql)){
$link = $row2["link"];
$name = $row2["name"];
$id = $row2["id"];
$addedby = $row2["addedby"];
$addtime = $row2["addtime"];
?>
<tr>
<td class="tablea"><div align="center"> <?=$id?></div></td>
<td class="tablea"><div align="center"> <?=$name?></div></td>
<td class="tablea"><div align="center"> <?=$link?></div></td>
<td class="tablea"><div align="center"> <?=$addedby?></div></td>
<td class="tablea"><div align="center"> <?=$addtime?></div></td>
<td class="tablea"><div align="center"> <a href="youtube.php?id=<?=$id?>"></a> </div></td>
</tr>
<?
$nr = $nr+1;
}
end_table();
end_frame();
}
stdfoot();
?>