Files
Testing/js/act/youtube_form_act.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

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);
?>