// add.php
<?php
echo "<b>Линк</b><br><input type=\"text\ name=\"link\" size=\"35\"><br><br>
<b>Името ти</b><br><input type=\"text\" name=\"name\" size=\"35\"><br><br>";
define("HOST", "localhost"); // хост на MySQL
define("USER", ""); // усер за MySQL
define("PASS", ""); // парола за MySQL
define("BD", ""); // име на база данни
$db_conn = @mysql_connect(HOST, USER, PASS) or die(mysql_error());
@mysql_select_db(BD, $db_conn) or die(mysql_error());
$link = $_POST['link'];
$name = $_POST['name'];
if (eregi('youtube', $link)) {
$string = file_get_contents($link);
$edno=explode('</div><h1 >',$string);
$dve=explode('</h1>',$edno[1]);
$link1 = explode("=", $link);
$query = mysql_query("INSERT INTO `clips` (name, name2, link, from, id) VALUES('$name','$dve[0]',$link1[1]','1','NULL')");
echo "Кипа е дубавен успешно. Благодарим ти ".$name."";
} else {
$string = file_get_contents($link);
$edno1=explode('<span class="title titlenew">',$string);
$dve1=explode('</span>',$edno1[1]);
$link1 = explode(":", $link);
$query = mysql_query("INSERT INTO `clips` (name, name2, link, from, id) VALUES('$name','$dve1[0]',$link1[1]','2','NULL')");
echo "Кипа е дубавен успешно. Благодарим ти ".$name."";
}
?>
// index.php
<?
define("HOST", "localhost"); // хост на MySQL
define("USER", ""); // усер за MySQL
define("PASS", ""); // парола за MySQL
define("BD", ""); // име на база данни
$db_conn = @mysql_connect(HOST, USER, PASS) or die(mysql_error());
@mysql_select_db(BD, $db_conn) or die(mysql_error());
$select = mysql_query("SELECT * FROM clips ")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$name = mysql_result($select, $i, "name2");
echo '<b>' . $nick . ':</b> ';
}
?>
// view.php
<?php
$id = $_GET['id'];
$row = mysql_fetch_array(mysql_query("SELECT * FROM `clips` WHERE `id` = '$id'"));
if ($row['from'] == 2){
echo '<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="450" height="403"><param name="movie" value="http://i47.vbox7.com/player/ext.swf?vid='.$row[link].'"><param name="quality" value="high"><embed src="http://i47.vbox7.com/player/ext.swf?vid='.$row[link].'" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="450" height="403"></embed></object>';
}else {
echo '<object width="560" height="340"><param name="movie" value="http://www.youtube.com/v/kNcIOzRpZvk&hl=en&fs=1"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/'.$row[link].'&hl=en&fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="560" height="340"></embed></object>';
}
?>
//sql
CREATE TABLE `clips` (
`id` int(12) NOT NULL auto_increment,
`name` VARCHAR(255) NOT NULL,
`name2` VARCHAR(255) NOT NULL,
`link` VARCHAR(255) NOT NULL,
`from` VARCHAR(255) NOT NULL,
UNIQUE KEY(`id`)
);
