Thread: Youtube
View Single Post
  #1  
Old 25th April 2008, 14:01
Tarix22 Tarix22 is offline
Member
 
Join Date: Feb 2008
Posts: 9
Default Youtube
Credits to seb35 @ tbdev for this mod

Put in db:

Code:
CREATE TABLE `youtubevideo` (
`id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`link` VARCHAR( 100 ) NOT NULL ,
`name` VARCHAR( 100 ) NOT NULL ,
`addedby` VARCHAR( 100 ) NOT NULL ,
`addtime` DATETIME NOT NULL
) ENGINE = MYISAM;
and create file youtube.php and put in you root

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("Video Clips");
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>Video Clips</center></span></td>
</tr><tr><td width="100%" class="tablea">
<center>




<span class="style3"><font color=blue>Please Choose A Video From The Right.</font></span> </p>
</center>
<tr><td


<tr><td>
</form> <iframe src="" name="games" width="570" height="570" 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>Liste</center></span></td>
</tr><tr><td width="100%" class="tablea">
<center>




<span class="style3"><font color=blue> Have Fun</font></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_MODERATOR){
print("

");
begin_frame("New video", FALSE, "100px");
?>
<form method="post" action="youtube.php">
<? begin_table(TRUE); ?>
<div align=center>
For URL: "http://youtube.com/watch?v=qppuuQrklHg"


just put: qppuuQrklHg in link

</div>

<tr><td class="tableb">Link:</td><td class="tablea"><input type="text" name="link" size="60"></td></tr>
<tr><td class="tableb">Name:</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('Videos', 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"> Name</div></td>
 <td class="tablecat"><div align="center"> Link</div></td>
 <td class="tablecat"><div align="center"> Added by</div></td>
 <td class="tablecat"><div align="center"> Added form</div></td>
 <td class="tablecat"><div align="center"> Delete</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"> Delete </div></td>
</tr>
<?
$nr = $nr+1;
}
end_table();
end_frame();
}
stdfoot();
?>
screenshot:

Click image for larger version

Name:	36960317sv4.gif
Views:	591
Size:	42.0 KB
ID:	405

not working under IE
Reply With Quote