<?php
require_once '../libs/Storage.php';
$db = new Storage();
$key = '%';
$last_id = '';
if (isset($_POST['key']) && isset($_POST['last_id'])) {
$key = $_POST['key'];
$last_id = $_POST['last_id'];
}
$result = $db->select("SELECT * FROM yapi WHERE title IS NOT NULL AND title != '' AND LOWER(title) LIKE LOWER('%{$key}%') OR REPLACE(title, ' ', '') LIKE LOWER('%{$key}%') ORDER BY meta_id DESC LIMIT 20 OFFSET {$last_id}");
$i = $last_id;
foreach ($result as $keys => $value) {
echo '<div id="leftVideo' . $i . '" more_id="' . $i . '" key="' . $key . '" class="video" onclick="video_click(' . $i . ')" video_yid="' . $value["yid"] . '" video_title="' . $value["title"] . '">
<img class="video-image" src="' . $value['thumbnail'] . '">
';
if ($value['viewers'] == 0 || $value['viewers'] == 1) {
echo '<p class="video-title">' . $value['title'] . ' (<i class="material-icons" style="position:relative;bottom:-0.2em;font-size:1.2em;">visibility</i> ' . $value['viewers'] . ' View)</p>';
} else {
echo '<p class="video-title">' . $value['title'] . ' (<i class="material-icons" style="position:relative;bottom:-0.2em;font-size:1.2em;">visibility</i> ' . $value['viewers'] . ' Views)</p>';
}
echo '<p class="video-author">' . $value['author'] . '</p>
<p class="video-description">' . $value['description'] . '</p>
</div>
';
$i++;
}
?>
<script type="text/javascript">
$(document).ready(function(){
$('.tooltipped').tooltip({delay: 50});
<?php
require_once '../libs/Storage.php';
$db = new Storage();
$allowedExts = array("gif", "jpeg", "jpg", "png");
$temp = explode(".", $_FILES["file"]["name"]);
$extension = end($temp);
$index = $_GET['id'];
if (($_FILES["file"]["type"] == "image/gif" || $_FILES["file"]["type"] == "image/jpeg" || $_FILES["file"]["type"] == "image/jpg" || $_FILES["file"]["type"] == "image/pjpeg" || $_FILES["file"]["type"] == "image/x-png" || $_FILES["file"]["type"] == "image/png") && in_array($extension, $allowedExts)) {
if ($_FILES["file"]["error"] > 0) {
echo json_encode($allowedExts);
} else {
$ext = pathinfo($_FILES["file"]["name"], PATHINFO_EXTENSION);
$file_name = $_FILES["file"]["name"];
$tmp_url = 'img/thumbnail/' . $file_name . '_' . date('Y-m-d_H:m:s') . '.' . $ext;
$file_url = $_SERVER['DOCUMENT_ROOT'] . '/videotube/' . $tmp_url;
$edit['new_thumbnail'] = $tmp_url;
$data_video = $db->select("SELECT * FROM yapi WHERE id = '" . $index . "' LIMIT 1");
$old_picture = $data_video[0]['new_thumbnail'];
if ($old_picture != '') {
unlink($_SERVER['DOCUMENT_ROOT'] . '/videotube/' . $old_picture);
}
if (move_uploaded_file($_FILES["file"]["tmp_name"], $file_url)) {
$db->update('yapi', $edit, 'id="' . $index . '"');
$edit['status'] = 1;
$edit['tmp_url'] = $tmp_url;
echo json_encode($edit);
}
}
}
//end of if FILE
<?php
require_once '../libs/Storage.php';
$db = new Storage();
$q = '%';
if (isset($_GET['q']) && $_GET['q'] != '') {
$key = $_GET['q'];
$result = $db->select("SELECT * FROM yapi WHERE title IS NOT NULL AND title != '' AND BINARY LOWER(title) LIKE LOWER('%{$key}%') OR REPLACE(title, ' ', '') LIKE LOWER('%{$key}%') AND suggest != 1 ORDER BY meta_id DESC LIMIT 25");
} else {
$key = '%';
$result = $db->select("SELECT * FROM yapi WHERE title IS NOT NULL AND title != '' AND suggest != 1 ORDER BY meta_id DESC LIMIT 25");
}
$resultq = $db->select("SELECT * FROM yapi WHERE title IS NOT NULL AND title != '' AND suggest = 1 LIMIT 1");
$i = 1;
foreach ($resultq as $key => $value) {
# code...
echo '<div id="leftVideo' . $i . '" more_id="' . $i . '" key="' . $key . '" class="video" onclick="video_click(' . $i . ')" video_yid="' . $value["yid"] . '" video_title="' . $value["title"] . '">
<img class="video-image" src="' . $value['thumbnail'] . '">
<p class="video-title">' . $value['title'] . ' (<i class="material-icons" style="position:relative;bottom:-0.2em;font-size:1.2em;">visibility</i> ' . $value['viewers'] . ' Views) <span class="right" style="background-color:yellow;color:black">EMPFOHLENES VIDEO</span></p>
<p class="video-author">' . $value['author'] . '</p>
<p class="video-description">' . $value['description'] . '</p>
</div>
';
}
$i = 2;
foreach ($result as $keys => $value) {
echo '<div id="leftVideo' . $i . '" more_id="' . $i . '" key="' . $key . '" class="video" onclick="video_click(' . $i . ')" video_yid="' . $value["yid"] . '" video_title="' . $value["title"] . '">
<img class="video-image" src="' . $value['thumbnail'] . '">
<p class="video-title">' . $value['title'] . ' (<i class="material-icons" style="position:relative;bottom:-0.2em;font-size:1.2em;">visibility</i> ' . $value['viewers'] . ' Views)</p>
<p class="video-author">' . $value['author'] . '</p>
<p class="video-description">' . $value['description'] . '</p>
<?php
require_once '../libs/Storage.php';
$db = new Storage();
$result = $db->select("SELECT * FROM yapi WHERE title IS NOT NULL AND title != '' ORDER BY viewers DESC LIMIT 10");
foreach ($result as $keys => $value) {
echo '<div class="video" video_yid="' . $value["yid"] . '" video_title="' . $value["title"] . '">
<img class="video-image" src="' . $value['thumbnail'] . '">
';
if ($value['viewers'] == 0 || $value['viewers'] == 1) {
echo '<p class="video-title">' . $value['title'] . ' (<i class="material-icons" style="position:relative;bottom:-0.2em;font-size:1.2em;">visibility</i> ' . $value['viewers'] . ' View)</p>';
} else {
echo '<p class="video-title">' . $value['title'] . ' (<i class="material-icons" style="position:relative;bottom:-0.2em;font-size:1.2em;">visibility</i> ' . $value['viewers'] . ' Views)</p>';
}
echo '<p class="video-author">' . $value['author'] . '</p>
<p class="video-description">' . $value['description'] . '</p>
</div>
';
}
<?php
require_once '../libs/Storage.php';
$db = new Storage();
$key = strtolower($_GET['name']);
$result = $db->select("SELECT lists FROM playlist WHERE LOWER(name) LIKE LOWER('{$key}') ");
print_r($result[0]['lists']);
<?php
require_once '../libs/Storage.php';
$db = new Storage();
$result = $db->select("SELECT * FROM yapi WHERE title IS NOT NULL AND title != '' AND new = 1 ORDER BY meta_id DESC");
$i = 2;
?>
<div class="row">
<?php
foreach ($result as $keys => $value) {
?>
<div class="col l3 m4 s6 neue_videos" id="leftVideo<?php
echo $i;
?>
" onclick="video_click(<?php
echo $i;
?>
)" video_yid="<?php
echo $value["yid"];
?>
" video_title="<?php
echo $value["title"];
?>
">
<?php
if ($value['new_thumbnail'] == '') {
?>
<img width="100px" height="100px" src="<?php
echo $value['thumbnail'];
?>
">
<?php
require_once '../libs/Storage.php';
$db = new Storage();
$key = $_GET['yid'];
$result = $db->select("SELECT * FROM yapi WHERE yid = '{$key}'");
echo $json_response = json_encode($result);
$daten['password'] = $password->hash($_GET['password']);
$daten['created_at'] = date("Y-m-d H:i:s");
$db->insert('playlist', $daten);
} elseif ($_GET['action'] == 'delete') {
$id = $_GET['playlist_id'];
echo $id;
$db->delete('playlist', 'id=' . $id);
} elseif ($_GET['action'] == 'update') {
$_GET['daten'] = urldecode(stripslashes($_GET['daten']));
$daten['lists'] = $_GET['daten'];
$daten['name'] = $_GET['name'];
$daten['updated_at'] = date("Y-m-d H:i:s");
$db->update('playlist', $daten, 'name="' . $daten["name"] . '"');
} elseif ($_GET['action'] == 'check_name') {
$name = $_GET['name'];
$result = $db->select("SELECT EXISTS(SELECT 1 FROM playlist WHERE name ='{$name}' LIMIT 1) as checked");
/*
* if exists result is 1 else is 0
*/
print_r($result[0]['checked']);
} elseif ($_GET['action'] == 'check_password') {
$name = $_GET['name'];
$pass = $_GET['password'];
$result = $db->select("SELECT password FROM playlist WHERE name='{$name}' ");
if ($password->validate($pass, $result[0]['password'])) {
echo 1;
} else {
echo 0;
}
} elseif ($_GET['action'] == 'update_viewer') {
# code...
<?php
require_once '../libs/Storage.php';
$db = new Storage();
$data['getVideo'] = $db->select("SELECT meta_id,meta_value FROM wp_postmeta WHERE meta_key = '_tern_wp_youtube_video' ORDER BY meta_id DESC LIMIT 5");
if (!sizeof($data['getVideo'])) {
echo '<div class="alert alert-info">No Data.</div>';
} else {
foreach ($data['getVideo'] as $keys => $value) {
$yid = $value['meta_value'];
$check = $db->select("SELECT count(*) as count FROM yapi WHERE yid ='{$yid}'");
if ($check[0]['count'] == 0) {
$url = "https://www.youtube.com/watch?v=" . $yid;
$result = get_web_page($url);
//echo $url;
if ($result['errno'] != 0) {
echo "error: bad url | timeout | redirect loop ...";
} elseif ($result['http_code'] != 200) {
echo "error: no page | no permissions | no service ";
} else {
$page = $result['content'];
if ($result == TRUE) {
$str = $page;
$title = preg_match_all('/<meta itemprop="name" content="(.*)">/', $str, $parts2);
$thumbnail = preg_match_all('/<meta property="og:image" content="(.*)">/', $str, $parts3);
$description = preg_match_all('/<meta property="og:description" content="(.*)">/', $str, $parts4);
$author = preg_match_all('/<link itemprop="url" href="(.*)">/', $str, $parts5);
$daten['yid'] = $yid;
$daten['url'] = $url;
$daten['title'] = $parts2[1][0];
$daten['thumbnail'] = $parts3[1][0];
