110 lines
1.5 KiB
PHP
110 lines
1.5 KiB
PHP
<?php header('Content-type: application/json');
|
|
|
|
$em="";
|
|
|
|
|
|
|
|
function getYoutubeIdFromUrl($url) {
|
|
|
|
$parts = parse_url($url);
|
|
|
|
if(isset($parts['query'])){
|
|
|
|
parse_str($parts['query'], $qs);
|
|
|
|
if(isset($qs['v'])){
|
|
|
|
return $qs['v'];
|
|
|
|
}else if($qs['vi']){
|
|
|
|
return $qs['vi'];
|
|
|
|
}
|
|
|
|
}
|
|
|
|
if(isset($parts['path'])){
|
|
|
|
$path = explode('/', trim($parts['path'], '/'));
|
|
|
|
return $path[count($path)-1];
|
|
|
|
}
|
|
|
|
return false;
|
|
|
|
}
|
|
|
|
|
|
|
|
if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/cmeter/');
|
|
|
|
include(PATHTOINCLUDES."base.php");
|
|
|
|
|
|
$vidid=$_POST["vidid"];
|
|
|
|
$vidtitle=$_POST["vidtitle"];
|
|
|
|
$viddesc=$_POST["viddesc"];
|
|
|
|
$vidactive=$_POST["vidactive"];
|
|
|
|
$thesort=$_POST["vidsort"];
|
|
|
|
$vidtitle=addslashes($vidtitle);
|
|
|
|
$viddesc=addslashes($viddesc);
|
|
|
|
|
|
|
|
$vid=getYoutubeIdFromUrl($vidid);
|
|
|
|
if($vid != ""){$vidid=$vid;}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$sqldc="SELECT
|
|
|
|
`you_x_tube`.`id`
|
|
|
|
FROM
|
|
|
|
`you_x_tube`
|
|
|
|
WHERE
|
|
|
|
`you_x_tube`.`youtube` = 'Y' AND
|
|
|
|
`you_x_tube`.`vid_id` = '".$vidid."'";
|
|
|
|
$query=$database->database_query($sqldc) or $em=$em.$database->database_error();
|
|
|
|
$num_rows = $database->database_num_rows($query);
|
|
|
|
if($num_rows==0){
|
|
|
|
$sqlins="INSERT INTO you_x_tube (vid_id,youtube,vid_title,vid_desc,thesort,vid_active) VALUES ('".$vidid."','Y','".$vidtitle."','".$viddesc."',".$thesort.",'".$vidactive."')";
|
|
|
|
$qin=$database->database_query($sqlins) or $em=$em.$database->database_error();
|
|
|
|
}
|
|
|
|
else
|
|
|
|
{
|
|
|
|
$em="Duplicate Youtube Id";
|
|
|
|
}
|
|
|
|
$arr = array ('error'=>$em);
|
|
|
|
echo json_encode($arr);
|
|
|
|
?>
|