[joeroberts]

I well take a look at it and see if I can redo the tables on I not sure If I added repairs to that try this here first

PHP Code:

<?php

include("header.php");
if ($_GET["id"] != ""){
$id =$_GET["id"];
if (checkaccess('can_add_uttube')){
mysql_query("DELETE FROM ".$db_prefix."_youtubevideo WHERE id= $id") or sqlerr(__FILE__, __LINE__);
}
else{
bterror(_btauthorized,_btsorry);
}
} 
if ($_SERVER["REQUEST_METHOD"] == "POST")
{
if ($link == "" || $name == "")bterror(_btmissing,_btsorry);
if(!checkaccess('can_add_uttube')){
        bterror(_btprivelages,_btsorry);
}
    $name = $_POST["name"];
    $user = $user->name;
    $link = "http://youtube.com/v/".$_POST[link]."";
    mysql_query("INSERT INTO ".$db_prefix."_youtubevideo (link, name, addedby, addtime) VALUES('$link', '$name', '$user',NOW())") or sqlerr(__FILE__, __LINE__);
                        echo "<meta http-equiv=\"refresh\" content=\"0;url=youtube.php\">";
  }
if (!checkaccess('can_view_utube')){
OpenErrTable(_btaccdenied);
echo "<p>You do not have Permissions to Access Utube Videos at this time</p>";
CloseErrTable();
die();
}else{
$showvid = "";
if ($op == "show"){
//$showvid = $video;
$showvid = "<object width=\"480\" height=\"295\"><param name=\"movie\" value=\"".$video."&hl=en&fs=1&rel=0\"></param><param name=\"allowFullScreen\" value=\"true\"></param><param name=\"allowscriptaccess\" value=\"always\"></param><embed src=\"".$video."&hl=en&fs=1&rel=0\" type=\"application/x-shockwave-flash\" allowscriptaccess=\"always\" allowfullscreen=\"true\" width=\"480\" height=\"295\"></embed></object>";
}else{
$showvid = "";
}

print("\n\n\n<table border=0 cellspacing=0 cellpadding=0 align=center><tr>\n");
print("<td width=502 valign=top>\n");
print("<table width=502><tr><td align=center>\n");
Opentable(_btvid_clip);
echo"<center>";
echo"<span class=\"style3\"><font color=blue>"._btvid_choose."</font></span> </p>";
echo"</center>";
echo"<tr><td align=center>";
if($showvid !="")echo $showvid;
echo"<iframe src=\"\" name=\"games\" width=\"570\" height=\"570\" scrolling=\"no\"></iframe>";
CloseTable();
print("</td></tr></table>");
print("<td width=300 valign=top>");
print("<table border=1><tr><td align=center>");
OpenTable(_btvid_list);
echo "<center>";
echo "<span class=\"style3\"><font color=blue>"._btvid_fun."</font></span> </p>";
echo"</center></td></tr>";
$query = "SELECT * FROM ".$db_prefix."_youtubevideo ORDER BY name";
$sql = $db->sql_query($query);
while ($row = $db->sql_fetchrow($sql)) {
$link = $row['link'];
$name = $row['name'];
print("<tr><td align=left>  <a href=".$link." target=games>".$name."</td></tr>");
}
CloseTable();
print("</table></td></tr><tr><td>");
if (checkaccess('can_add_uttube')){
OpenTable(_btvid_add);
echo "<table align=center cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#D6D9DB\" width=\"100%\" border=\"1\">";
?>
<form method="post" action="youtube.php">
<div align=center><p>
<?=_btvid_url?>"http://youtube.com/watch?v=qppuuQrklHg"<br /><?=_btvid_link?>

</p></div>
<tr><td class="tableb"><?=_btvid_link1?></td><td class="tablea"><input type="text" name="link" size="60"></td></tr>
<tr><td class="tableb"><?=_btvid_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="<?=_btokay?>" class="btn"></td></tr>
</form>
<?php
echo "</table>";
CloseTable();
OpenTable(_btvid_info);
echo "<table align=center cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#D6D9DB\" width=\"100%\" border=\"1\">";
?>
<tr>
 <td width="5%" class="tablecat"><div align="center"><?=_btvid_id?></div></td>
 <td width="45%"class="tablecat"><div align="center"><?=_btvid_name?></div></td>
 <td width="15%"class="tablecat"><div align="center"><?=_btvid_link1?></div></td>
 <td width="20%"class="tablecat"><div align="center"><?=_btvid_addedby?></div></td>
 <td width="10%"class="tablecat"><div align="center"><?=_btvid_added?></div></td>
 <td width="5%"class="tablecat"><div align="center"><?=_btvid_delete?></div></td>
</tr>
<?php
$query = "SELECT * FROM ".$db_prefix."_youtubevideo ORDER BY id";
$sql = mysql_query($query);
    while ($row2 = mysql_fetch_array($sql)){
     $link = str_replace("http://youtube.com/v/","",$row2["link"]);
     $name = $row2["name"];
     $id = $row2["id"];
     $addedby = $row2["addedby"];
     $addtime = $row2["addtime"];
?>
<tr>
 <td width="5%" class="tablea"><div align="center"> <?=$id?></div></td>
 <td width="45%" class="tablea"><div align="left"> <?=$name?></div></td>
 <td width="15%" 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"><?=pic("drop.gif","youtube.php?id=".$id,_btvid_remove);?></div></td>
</tr>
<?php
$nr = $nr+1;
}
echo "</table>";
CloseTable();
}
}
echo "</td></tr></table>";
include ("footer.php");
?>