fork download
copy 
  1. <?php
  2. session_start();
  3. header("Content-type: text/html; charset=utf8");
  4. set_time_limit(60000*60);
  5. error_reporting(E_ERROR);
  6. if(!isset($_SESSION['youtube_pro_user']) OR $_SESSION['super_admin'] == 0) {
  7. header("location:login.php");
  8. exit;
  9. }
  10. include('../include/config.php');
  11. include('../include/connect.php');
  12. include('include/functions.php');
  13. include('include/general.class.php');
  14. $general = new General;
  15. $general->set_connection($mysqli);
  16. $options = $general->get_all_options();
  17. $case = make_safe(xss_clean($_GET['case']));
  18. $action = make_safe(xss_clean($_POST['action'])); 
  19. if ($action == "sort_category"){
  20. 	$records = $_POST['records'];
  21. 	$counter = 1;
  22. 	foreach ($records as $record) {
  23. 		$sql = "UPDATE categories SET category_order='$counter' WHERE id='$record'";
  24. 		$query = $mysqli->query($sql);
  25. 		$counter = $counter + 1;	
  26. 	}
  27. }
  28. if ($action == "sort_pages"){
  29. 	$records = $_POST['records'];
  30. 	$counter = 1;
  31. 	foreach ($records as $record) {
  32. 		$sql = "UPDATE pages SET page_order='$counter' WHERE id='$record'";
  33. 		$query = $mysqli->query($sql);
  34. 		$counter = $counter + 1;	
  35. 	}
  36. }
  37.  
  38. if ($action == "sort_links"){
  39. 	$records = $_POST['records'];
  40. 	$counter = 1;
  41. 	foreach ($records as $record) {
  42. 		$sql = "UPDATE links SET link_order='$counter' WHERE id='$record'";
  43. 		$query = $mysqli->query($sql);
  44. 		$counter = $counter + 1;	
  45. 	}
  46. }
  47. if ($case == "ajax_remove_from_list"){
  48. if (isset($_GET)) {
  49. $id = make_safe(xss_clean($_GET['id']));
  50. $delete = $mysqli->query("DELETE FROM lists_video WHERE id='$id'");
  51. if ($delete) {
  52. echo 1;	
  53. } else {
  54. echo 0;	
  55. }
  56. }
  57. }
  58.  
  59. if ($case == "video_details"){
  60. $id = make_safe(xss_clean($_GET['id']));
  61. ?>
  62. <div class="modal-dialog" id="media-details">
  63. 		<div class="modal-content">
  64. 		<div class="modal-header">
  65. 			<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
  66. 			<h4 class="modal-title">Video Details</h4>
  67. 		</div>
  68. 		<div class="modal-body">
  69. 			<div class="embed-responsive embed-responsive-16by9">
  70. 			<iframe src="http://w...content-available-to-author-only...e.com/embed/<?php echo $id; ?>"></iframe>
  71. 			</div>
  72. 		</div>
  73. 		<div class="modal-footer">
  74. 			<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
  75. 		</div>
  76. 		</div>
  77. </div>
  78. <?php
  79. }
  80.  
  81. if ($action == "sort_videos_list"){
  82. 	$records = $_POST['records'];
  83. 	$counter = 1;
  84. 	foreach ($records as $record) {
  85. 		$sql = "UPDATE lists_video SET video_order='$counter' WHERE id='$record'";
  86. 		$query = $mysqli->query($sql);
  87. 		$counter = $counter + 1;	
  88. 	}
  89. }
  90. if ($action == "youtube_channel_import") {
  91.  
  92. 	$id = intval($_POST['id']);
  93. 	if (empty($id)) {
  94. 	header("location:login.php");
  95. 	}
  96. 	$sql = "SELECT * FROM channels WHERE id='$id' LIMIT 1";
  97. 	$query = $mysqli->query($sql);
  98. 	$row = $query->fetch_assoc();
  99. 	$category_id = $row['category_id'];
  100. 	$channel_id = $row['id'];
  101. 	$channel_link = $row['link'];
  102. 	$videos_number = $row['videos_number'];
  103. 	$day = date('j');
  104. 	$month = date('n');
  105. 	$year = date('Y');
  106. 	$u = parse_url($channel_link);
  107. 	if (strpos($channel_link,'/user/') != false) {
  108. 	$youtube_username = str_replace('/user/','',$u['path']);
  109. 	$baseUrl = 'https://w...content-available-to-author-only...s.com/youtube/v3/';
  110. 	$apiKey = $options['api_youtube_apikey'];
  111. 	$link = json_decode(file_get_contents('https://w...content-available-to-author-only...s.com/youtube/v3/channels?key='.$apiKey.'&forUsername='.$youtube_username.'&part=id'), true);
  112. 	$channelId = $link['items'][0]['id'];
  113. 	} else {
  114. 	$baseUrl = 'https://w...content-available-to-author-only...s.com/youtube/v3/';
  115. 	$apiKey = $options['api_youtube_apikey'];
  116. 	$youtube_username = str_replace('/channel/','',$u['path']);	
  117. 	$channelId = $youtube_username;
  118. 	}
  119. 	$url = $baseUrl .'channels?' .
  120.     'id=' . $channelId .
  121.     '&part=contentDetails' . 
  122.     '&key=' . $apiKey;
  123. 	$json = json_decode(file_get_contents($url), true);
  124.  
  125. 	$playlist = $json['items'][0]['contentDetails']['relatedPlaylists']['uploads'];
  126.  
  127. 	$url = $baseUrl .'playlistItems?' .
  128. 	 'part=snippet' .
  129. 	 '&maxResults=' .$videos_number.
  130. 	 '&playlistId=' . $playlist .
  131. 	 '&key=' . $apiKey;
  132. 	$json = json_decode(file_get_contents($url), true);
  133. 	foreach(array_reverse($json['items']) as $video) {
  134. 		$video_id = $video['snippet']['resourceId']['videoId'];
  135. 		$video_title = htmlspecialchars($video['snippet']['title'],ENT_QUOTES);
  136. 		$video_details = htmlspecialchars($video['snippet']['description'],ENT_QUOTES);
  137. 		if (!empty($video['snippet']['thumbnails']['standard']['url'])) {
  138. 		$video_thumbnail = $video['snippet']['thumbnails']['standard']['url'];
  139. 		} else {
  140. 		$video_thumbnail = $video['snippet']['thumbnails']['high']['url'];	
  141. 		}
  142. 		$video_youtube_url = 'http://w...content-available-to-author-only...e.com/watch?v='.$video_id;
  143. 		if (check_youtube_id($video_id) == 0) {
  144. 		$videt = json_decode(file_get_contents('https://w...content-available-to-author-only...s.com/youtube/v3/videos?id='.$video_id.'&part=contentDetails&key='.$apiKey), true);
  145. 		$video_duration = $videt['items'][0]['contentDetails']['duration'];
  146. 		$duration = youtube_duration($video_duration);
  147. 		$datetime = time();
  148. 		if (!empty($video_thumbnail)) {
  149. 		$thumb = $video_id.'.jpg';
  150. 		$up = file_put_contents('../upload/videos/'.$thumb,file_get_contents($video_thumbnail));	
  151. 		} else {
  152. 		$thumb = '';	
  153. 		}
  154. 		if (count($video['snippet']['tags']) > 0) {
  155. 			$tags = implode(',',$video['snippet']['tags']);
  156. 		} else {
  157. 			$tags = title_to_keywords($video['snippet']['title']);
  158. 		}
  159. 		$publish_time = youtube_date_to_unix($video['snippet']['publishedAt']);
  160. 		$datetime = time();
  161. 		$day = date('j');
  162. 		$month = date('n');
  163. 		$year = date('Y');
  164. 		$insert = $mysqli->query("INSERT INTO videos (user_id,youtube_id,channel_id,category_id,title,details,permalink,datetime,thumbnail,duration,tags,day,month,year,published,publish_time,tag_id,hits,deleted,votes_up,votes_down) VALUES ('$_SESSION[youtube_pro_user]','$video_id','$channel_id','$category_id','$video_title','$video_details','$video_youtube_url','$datetime','$thumb','$duration','$tags','$day','$month','$year','1','$publish_time','0','0','0','0','0')");
  165. 		} 
  166. 	}	
  167.  
  168.  
  169. 	$now = time();
  170. 	$mysqli->query("UPDATE channels SET latest_activity='$now' WHERE id='$id'");
  171. }
  172.  
  173.  
  174. // import single video
  175. if ($action == "import_single_youtube_video") {
  176. 	$id = make_safe($_POST['id']);
  177. 	$category = make_safe($_POST['category']);
  178. 	if (empty($id)) {
  179. 	header("location:login.php");
  180. 	}
  181. 		$baseUrl = 'https://w...content-available-to-author-only...s.com/youtube/v3/';
  182. 		$apiKey = $options['api_youtube_apikey'];
  183. 		$url = $baseUrl .'videos?' .
  184. 				'id=' .$id.
  185. 				'&part=snippet' . 
  186. 				'&key=' . $apiKey;
  187. 		$json = json_decode(file_get_contents($url), true);
  188. 		if (count($json['items']) == 0) {
  189. 		echo 'failure';	
  190. 		} else {			
  191. 		$video_title = htmlspecialchars($json['items'][0]['snippet']['title'],ENT_QUOTES);
  192. 		$video_details = htmlspecialchars($json['items'][0]['snippet']['description'],ENT_QUOTES);
  193. 		if (!empty($json['items'][0]['snippet']['thumbnails']['standard']['url'])) {
  194. 		$video_thumbnail = $json['items'][0]['snippet']['thumbnails']['standard']['url'];
  195. 		} else {
  196. 		$video_thumbnail = $json['items'][0]['snippet']['thumbnails']['high']['url'];	
  197. 		}
  198. 		$video_youtube_url = 'http://w...content-available-to-author-only...e.com/watch?v='.$id;
  199. 		$videt = json_decode(file_get_contents('https://w...content-available-to-author-only...s.com/youtube/v3/videos?id='.$id.'&part=contentDetails&key='.$apiKey), true);
  200. 		$video_duration = $videt['items'][0]['contentDetails']['duration'];
  201. 		$duration = youtube_duration($video_duration);
  202. 		if (check_youtube_id($id) == 0) {
  203. 		$datetime = time();
  204. 		$day = date('j');
  205. 		$month = date('n');
  206. 		$year = date('Y');
  207. 		if (!empty($video_thumbnail)) {
  208. 		$thumb = 'youtube_'.$id.'.jpg';
  209. 		$up = file_put_contents('../upload/videos/'.$thumb,file_get_contents($video_thumbnail));	
  210. 		} else {
  211. 		$thumb = '';	
  212. 		}
  213. 		if (count($json['items'][0]['snippet']['tags']) > 0) {
  214. 			$tags = implode(',',$json['items'][0]['snippet']['tags']);
  215. 		} else {
  216. 			$tags = title_to_keywords($json['items'][0]['snippet']['title']);
  217. 		}
  218. 		$publish_time = youtube_date_to_unix($json['items'][0]['snippet']['publishedAt']);
  219. 		$datetime = time();
  220. 		$day = date('j');
  221. 		$month = date('n');
  222. 		$year = date('Y');
  223. 		$insert = $mysqli->query("INSERT INTO videos 
  224. 		(youtube_id,user_id,category_id,title,details,permalink,datetime,thumbnail,duration,day,month,year,published,tags,publish_time,tag_id,channel_id,hits,deleted,votes_up,votes_down) VALUES 
  225. 		('$id','$_SESSION[youtube_pro_user]','$category','$video_title','$video_details','$video_youtube_url','$datetime','$thumb','$duration','$day','$month','$year','1','$tags','$publish_time','0','0','0','0','0','0')");
  226. 		if ($insert) {
  227. 		echo 'success';	
  228. 		} else {
  229. 		echo 'failure';	
  230. 		}
  231. 		} else {
  232. 		echo 'failure';	
  233. 		}
  234. 		}
  235. }
  236.  
  237.  
  238.  
  239. if ($action == "import_channel_single_video") {
  240. if (isset($_POST)) {
  241. 		$category = make_safe(xss_clean(intval($_POST['category'])));
  242. 		$channel = make_safe(xss_clean(intval($_POST['channel'])));			
  243. 		$id = make_safe(xss_clean($_POST['id']));
  244. 		$datetime = time();
  245. 		$day = date('j');
  246. 		$month = date('n');
  247. 		$year = date('Y');
  248. 		if (empty($id)) {
  249. 		echo 'failure';	
  250. 		} elseif (check_youtube_id($id) > 0) {
  251. 		echo 'failure';	
  252. 		} else {				
  253. 				$baseUrl = 'https://w...content-available-to-author-only...s.com/youtube/v3/';
  254. 				$apiKey = $options['api_youtube_apikey'];
  255. 				$url = $baseUrl.'videos?'.
  256. 						'id='.$id.
  257. 						'&part=snippet'. 
  258. 						'&key='.$apiKey;
  259. 				$json = json_decode(file_get_contents($url), true);
  260. 				if (count($json['items']) == 0) {
  261. 				echo 'failure';	
  262. 				} else {
  263. 				$video_title = htmlspecialchars($json['items'][0]['snippet']['title'],ENT_QUOTES);
  264. 				$video_details = htmlspecialchars($json['items'][0]['snippet']['description'],ENT_QUOTES);
  265. 				if (!empty($json['items'][0]['snippet']['thumbnails']['standard']['url'])) {
  266. 				$video_thumbnail = $json['items'][0]['snippet']['thumbnails']['standard']['url'];
  267. 				} else {
  268. 				$video_thumbnail = $json['items'][0]['snippet']['thumbnails']['high']['url'];	
  269. 				}
  270. 				$video_youtube_url = 'http://w...content-available-to-author-only...e.com/watch?v='.$id;
  271. 				$videt = json_decode(file_get_contents('https://w...content-available-to-author-only...s.com/youtube/v3/videos?id='.$id.'&part=contentDetails&key='.$apiKey), true);
  272. 				$video_duration = $videt['items'][0]['contentDetails']['duration'];
  273. 				preg_match_all('!\d+!', $video_duration, $matches);
  274. 				$m = $matches[0][0];
  275. 				$s = $matches[0][1];
  276. 				$duration = ($m*60)+$s;
  277. 				if (!empty($video_thumbnail)) {
  278. 				$thumb = 'youtube_'.$id.'.jpg';
  279. 				$up = file_put_contents('../upload/videos/'.$thumb,file_get_contents($video_thumbnail));	
  280. 				} else {
  281. 				$thumb = '';	
  282. 				}
  283. 				if (count($json['items'][0]['snippet']['tags']) > 0) {
  284. 					$tags = implode(',',$json['items'][0]['snippet']['tags']);
  285. 				} else {
  286. 					$tags = title_to_keywords($json['items'][0]['snippet']['title']);
  287. 				}
  288. 				$publish_time = youtube_date_to_unix($json['items'][0]['snippet']['publishedAt']);
  289. 				$datetime = time();
  290. 				$day = date('j');
  291. 				$month = date('n');
  292. 				$year = date('Y');
  293. 				$insert = $mysqli->query("INSERT INTO videos (youtube_id,user_id,category_id,channel_id,title,details,permalink,datetime,thumbnail,duration,day,month,year,published,tags,publish_time,tag_id,hits,deleted,votes_up,votes_down) VALUES ('$id','$_SESSION[youtube_pro_user]','$category','$channel','$video_title','$video_details','$video_youtube_url','$datetime','$thumb','$duration','$day','$month','$year','1','$tags','$publish_time','0','0','0','0','0')");
  294. 				if ($insert) {
  295. 					echo 1;	
  296. 				} else {
  297. 					echo 'failure';	
  298. 				}
  299. 				} 
  300. 		}
  301. 	}
  302. }
  303.  
  304. if ($case == 'channel_details') {
  305. $id = make_safe($_GET['id']);	
  306. if (!empty($id)) {
  307. $baseUrl = 'https://w...content-available-to-author-only...s.com/youtube/v3/';
  308. $apiKey = $options['api_youtube_apikey'];
  309. $url = $baseUrl .'channels?' .
  310.     'id=' . $_GET['id'] .
  311.     '&part=snippet' . 
  312.     '&key=' . $apiKey;
  313. $json = json_decode(file_get_contents($url), true);
  314. $urla = $baseUrl .'channels?' .
  315.     'id=' . $_GET['id'] .
  316.     '&part=statistics' . 
  317.     '&key=' . $apiKey;
  318. $jsona = json_decode(file_get_contents($urla), true);
  319. ?>
  320. <div class="modal-dialog" id="channel-details">
  321. 		<div class="modal-content">
  322. 		<div class="modal-header">
  323. 			<button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
  324. 			<h4 class="modal-title">Channel Details</h4>
  325. 		</div>
  326. 		<div class="modal-body">
  327. 			<table class="table">
  328. 				<thead>
  329. 					<tr>
  330. 						<th>Field</th>
  331. 						<th>Value</th>
  332. 					</tr>
  333. 				</thead>
  334. 				<tbody>
  335. 					<tr>
  336. 						<td>Channel Name</td>
  337. 						<td><?php echo $json['items'][0]['snippet']['title']; ?></td>
  338. 					</tr>
  339. 					<tr>
  340. 						<td>Channel Description</td>
  341. 						<td><?php echo $json['items'][0]['snippet']['description']; ?></td>
  342. 					</tr>
  343. 					<tr>
  344. 						<td>Videos Number</td>
  345. 						<td><?php echo $jsona['items'][0]['statistics']['videoCount']; ?></td>
  346. 					</tr>
  347. 					<tr>
  348. 						<td>Subscribers Number</td>
  349. 						<td><?php echo $jsona['items'][0]['statistics']['subscriberCount']; ?></td>
  350. 					</tr>
  351. 					<tr>
  352. 						<td>Views Number</td>
  353. 						<td><?php echo $jsona['items'][0]['statistics']['viewCount']; ?></td>
  354. 					</tr>
  355. 				</tbody>
  356. 			</table>
  357. 		</div>
  358. 		<div class="modal-footer">
  359. 			<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
  360. 		</div>
  361. 		</div>
  362. </div>
  363. <?php
  364. }
  365. }
  366.  
  367.  
  368. if ($action == 'import_single_channel') {
  369. $id = make_safe($_POST['id']);	
  370. $category = make_safe($_POST['category']);	
  371. if (!empty($id)) {
  372. $baseUrl = 'https://w...content-available-to-author-only...s.com/youtube/v3/';
  373. $apiKey = $options['api_youtube_apikey'];
  374. $url = $baseUrl .'channels?' .
  375.     'id=' . $id.
  376.     '&part=snippet' . 
  377.     '&key=' . $apiKey;
  378. $json = json_decode(file_get_contents($url), true);
  379. if (count($json['items']) != 0) {
  380. if (check_youtube_channel_id($json['items'][0]['id']) == 0) {
  381. $datetime = time();
  382. $title = $json['items'][0]['snippet']['title'];
  383. $link = 'http://y...content-available-to-author-only...e.com/channel/'.$json['items'][0]['id'];
  384. $sql = "INSERT INTO channels (title,link,category_id,videos_number,add_time,latest_activity,auto_update,auto_update_period,youtube_channel_id) VALUES ('$title','$link','$category','30','$datetime','0','0','0','$id')";
  385. $query = $mysqli->query($sql);
  386. if ($query) {
  387. 	echo 'success';
  388. } else {
  389. 	echo 'failure';
  390. }
  391. } else {
  392. 	echo 'failure';
  393. }
  394. } else {
  395. 	echo 'failure';
  396. }
  397. } else {
  398. 	echo 'failure';
  399. }
  400. }
  401.  
  402.  
  403. if ($action == "import_multiple_videos") {
  404.  
  405. 	$category = intval($_POST['category']);
  406. 	$ids = explode(',',$_POST['myCheckboxes']);
  407. 	for ( $i=0; $i < count($ids); $i++)
  408.     {
  409. 				$baseUrl = 'https://w...content-available-to-author-only...s.com/youtube/v3/';
  410. 				$apiKey = $options['api_youtube_apikey'];
  411. 				$url = $baseUrl.'videos?'.
  412. 						'id='.$ids[$i].
  413. 						'&part=snippet'. 
  414. 						'&key='.$apiKey;
  415. 				$json = json_decode(file_get_contents($url), true);
  416. 				if (count($json['items']) != 0) {
  417. 				$video_title = htmlspecialchars($json['items'][0]['snippet']['title'],ENT_QUOTES);
  418. 				$video_details = htmlspecialchars($json['items'][0]['snippet']['description'],ENT_QUOTES);
  419. 				if (!empty($json['items'][0]['snippet']['thumbnails']['standard']['url'])) {
  420. 				$video_thumbnail = $json['items'][0]['snippet']['thumbnails']['standard']['url'];
  421. 				} else {
  422. 				$video_thumbnail = $json['items'][0]['snippet']['thumbnails']['high']['url'];	
  423. 				}
  424. 				$video_youtube_url = 'http://w...content-available-to-author-only...e.com/watch?v='.$ids[$i];
  425. 				$videt = json_decode(file_get_contents('https://w...content-available-to-author-only...s.com/youtube/v3/videos?id='.$ids[$i].'&part=contentDetails&key='.$apiKey), true);
  426. 				$video_duration = $videt['items'][0]['contentDetails']['duration'];
  427. 				preg_match_all('!\d+!', $video_duration, $matches);
  428. 				$m = $matches[0][0];
  429. 				$s = $matches[0][1];
  430. 				$duration = ($m*60)+$s;
  431. 				if (!empty($video_thumbnail)) {
  432. 				$thumb = 'youtube_'.$ids[$i].'.jpg';
  433. 				$up = file_put_contents('../upload/videos/'.$thumb,file_get_contents($video_thumbnail));	
  434. 				} else {
  435. 				$thumb = '';	
  436. 				}
  437. 				if (count($json['items'][0]['snippet']['tags']) > 0) {
  438. 					$tags = implode(',',$json['items'][0]['snippet']['tags']);
  439. 				} else {
  440. 					$tags = title_to_keywords($json['items'][0]['snippet']['title']);
  441. 				}
  442. 				$publish_time = youtube_date_to_unix($json['items'][0]['snippet']['publishedAt']);
  443. 				$datetime = time();
  444. 				$day = date('j');
  445. 				$month = date('n');
  446. 				$year = date('Y');
  447. 				$insert = $mysqli->query("INSERT INTO videos (youtube_id,user_id,category_id,title,details,permalink,datetime,thumbnail,duration,day,month,year,published,tags,publish_time,channel_id,tag_id,hits,deleted,votes_up,votes_down) VALUES ('$ids[$i]','$_SESSION[youtube_pro_user]','$category','$video_title','$video_details','$video_youtube_url','$datetime','$thumb','$duration','$day','$month','$year','1','$tags','$publish_time','0','0','0','0','0','0')");
  448. 				}   
  449.     }
  450.  
  451.  
  452. }
  453.  
  454.  
  455. if ($action == "import_multiple_videos_from_channel") {
  456.  
  457. 	$category = intval($_POST['category']);
  458. 	$channel_id = intval($_POST['channel_id']);
  459. 	$ids = explode(',',$_POST['myCheckboxes']);
  460. 	for ( $i=0; $i < count($ids); $i++)
  461.     {
  462. 				$baseUrl = 'https://w...content-available-to-author-only...s.com/youtube/v3/';
  463. 				$apiKey = $options['api_youtube_apikey'];
  464. 				$url = $baseUrl.'videos?'.
  465. 						'id='.$ids[$i].
  466. 						'&part=snippet'. 
  467. 						'&key='.$apiKey;
  468. 				$json = json_decode(file_get_contents($url), true);
  469. 				if (count($json['items']) != 0) {
  470. 				$video_title = htmlspecialchars($json['items'][0]['snippet']['title'],ENT_QUOTES);
  471. 				$video_details = htmlspecialchars($json['items'][0]['snippet']['description'],ENT_QUOTES);
  472. 				if (!empty($json['items'][0]['snippet']['thumbnails']['standard']['url'])) {
  473. 				$video_thumbnail = $json['items'][0]['snippet']['thumbnails']['standard']['url'];
  474. 				} else {
  475. 				$video_thumbnail = $json['items'][0]['snippet']['thumbnails']['high']['url'];	
  476. 				}
  477. 				$video_youtube_url = 'http://w...content-available-to-author-only...e.com/watch?v='.$ids[$i];
  478. 				$videt = json_decode(file_get_contents('https://w...content-available-to-author-only...s.com/youtube/v3/videos?id='.$ids[$i].'&part=contentDetails&key='.$apiKey), true);
  479. 				$video_duration = $videt['items'][0]['contentDetails']['duration'];
  480. 				preg_match_all('!\d+!', $video_duration, $matches);
  481. 				$m = $matches[0][0];
  482. 				$s = $matches[0][1];
  483. 				$duration = ($m*60)+$s;
  484. 				if (!empty($video_thumbnail)) {
  485. 				$thumb = 'youtube_'.$ids[$i].'.jpg';
  486. 				$up = file_put_contents('../upload/videos/'.$thumb,file_get_contents($video_thumbnail));	
  487. 				} else {
  488. 				$thumb = '';	
  489. 				}
  490. 				if (count($json['items'][0]['snippet']['tags']) > 0) {
  491. 					$tags = implode(',',$json['items'][0]['snippet']['tags']);
  492. 				} else {
  493. 					$tags = title_to_keywords($json['items'][0]['snippet']['title']);
  494. 				}
  495. 				$publish_time = youtube_date_to_unix($json['items'][0]['snippet']['publishedAt']);
  496. 				$datetime = time();
  497. 				$day = date('j');
  498. 				$month = date('n');
  499. 				$year = date('Y');
  500. 				$insert = $mysqli->query("INSERT INTO videos (youtube_id,user_id,category_id,channel_id,title,details,permalink,datetime,thumbnail,duration,day,month,year,published,tags,publish_time,tag_id,hits,deleted,votes_up,votes_down) VALUES ('$ids[$i]','$_SESSION[youtube_pro_user]','$category','$channel_id','$video_title','$video_details','$video_youtube_url','$datetime','$thumb','$duration','$day','$month','$year','1','$tags','$publish_time','0','0','0','0','0')");
  501. 				}   
  502.     }
  503.  
  504.  
  505. }
  506.  
  507. if ($action == "youtube_tag_import") {
  508.  
  509. 	$id = intval($_POST['id']);
  510. 	$tag = $general->tag($id);
  511. 	if ($tag != 0) {
  512. 	$tag_title = str_replace(' ','+',$tag['title']);
  513. 	$tag_id = $tag['id'];
  514. 	$category_id = $tag['category_id'];
  515. 	$max_results = $tag['videos_number'];
  516. 	$youtube_category = $tag['youtube_category'];
  517. 	$baseUrl = 'https://w...content-available-to-author-only...s.com/youtube/v3/';
  518. 	$apiKey = $options['api_youtube_apikey'];
  519. 	$url = $baseUrl ."search?q=$tag_title&maxResults=$max_results&order=date&part=snippet&type=video";
  520. 	if ($youtube_category != 0) {
  521. 	$url .= "&videoCategoryId=$youtube_category";	
  522. 	}
  523. 	$url .= "&key=$apiKey";
  524. 	$json = json_decode(file_get_contents($url), true);	
  525. 	foreach(array_reverse($json['items']) as $video) {
  526. 		$video_id = $video['id']['videoId'];
  527. 		$video_title = htmlspecialchars($video['snippet']['title'],ENT_QUOTES);
  528. 		$video_details = htmlspecialchars($video['snippet']['description'],ENT_QUOTES);
  529. 		if (!empty($video['snippet']['thumbnails']['standard']['url'])) {
  530. 		$video_thumbnail = $video['snippet']['thumbnails']['standard']['url'];
  531. 		} else {
  532. 		$video_thumbnail = $video['snippet']['thumbnails']['high']['url'];	
  533. 		}
  534. 		$video_youtube_url = 'http://w...content-available-to-author-only...e.com/watch?v='.$video_id;
  535. 		if (check_youtube_id($video_id) == 0) {
  536. 		$videt = json_decode(file_get_contents('https://w...content-available-to-author-only...s.com/youtube/v3/videos?id='.$video_id.'&part=contentDetails&key='.$apiKey), true);
  537. 		$video_duration = $videt['items'][0]['contentDetails']['duration'];
  538. 		$duration = youtube_duration($video_duration);
  539. 		$datetime = time();
  540. 		if (!empty($video_thumbnail)) {
  541. 		$thumb = $video_id.'.jpg';
  542. 		$up = file_put_contents('../upload/videos/'.$thumb,file_get_contents($video_thumbnail));	
  543. 		} else {
  544. 		$thumb = '';	
  545. 		}
  546. 		if (count($video['snippet']['tags']) > 0) {
  547. 			$tags = implode(',',$video['snippet']['tags']);
  548. 		} else {
  549. 			$tags = title_to_keywords($video['snippet']['title']);
  550. 		}
  551. 		$publish_time = youtube_date_to_unix($video['snippet']['publishedAt']);
  552. 		$datetime = time();
  553. 		$day = date('j');
  554. 		$month = date('n');
  555. 		$year = date('Y');
  556. 		$insert = $mysqli->query("INSERT INTO videos (user_id,youtube_id,tag_id,category_id,title,details,permalink,datetime,thumbnail,duration,tags,day,month,year,published,publish_time,channel_id,hits,deleted,votes_up,votes_down) VALUES ('$_SESSION[youtube_pro_user]','$video_id','$tag_id','$category_id','$video_title','$video_details','$video_youtube_url','$datetime','$thumb','$duration','$tags','$day','$month','$year','1','$publish_time','0','0','0','0','0')");
  557. 		} 
  558. 	}
  559. 	$now = time();
  560. 	$mysqli->query("UPDATE tags SET latest_activity='$now' WHERE id='$id'");
  561. 	}
  562.  
  563. }
Success #stdin #stdout 0.01s 82560KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/cNSR45
language:
PHP (php 7.3.5)
created:
5 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!