Krystie
092a8bc7ce
- Removed all backup/duplicate files - Removed test files from root - Consolidated documentation to /docs/ - Moved scripts to /scripts/ - Renamed f_* directories (removed prefix) - Organized icons and assets - Removed unused vendor directories - Cleaned up redundant config files
29 lines
956 B
PHP
29 lines
956 B
PHP
<?php
|
|
defined('_ISVALID') or exit;
|
|
|
|
class VBrowseEnhanced extends VBrowse {
|
|
public static function getVideos($limit = 20, $offset = 0) {
|
|
global $class_database;
|
|
|
|
$sql = "SELECT * FROM db_videofiles
|
|
WHERE file_type = 'video' AND privacy = 'public'
|
|
ORDER BY upload_date DESC
|
|
LIMIT $limit OFFSET $offset";
|
|
|
|
return $class_database->execute($sql);
|
|
}
|
|
|
|
public static function searchVideos($query, $limit = 20) {
|
|
global $class_database;
|
|
|
|
$query = $class_database->escape($query);
|
|
$sql = "SELECT * FROM db_videofiles
|
|
WHERE (file_title LIKE '%$query%' OR file_description LIKE '%$query%')
|
|
AND file_type = 'video' AND privacy = 'public'
|
|
ORDER BY upload_date DESC
|
|
LIMIT $limit";
|
|
|
|
return $class_database->execute($sql);
|
|
}
|
|
}
|
|
?>
|