Videos: Difference between revisions
From Dune Awakening DB
Created page with "{{VideoGallery}}" |
mNo edit summary Tag: Reverted |
||
| Line 1: | Line 1: | ||
{{ | {{Videos}} | ||
Revision as of 04:08, 2 June 2025
Video Gallery
The query SELECT video_id,youtube_id,video_title,channel_name,duration,video_type,primary_tag,description FROM `data_videos` WHERE visibility='public' ORDER BY publish_date DESC LIMIT 20 is invalid (Error 1054: Unknown column 'video_title' in 'SELECT'
Function: EDConnectorRdbms::fetch Query: SELECT video_id,youtube_id,video_title,channel_name,duration,video_type,primary_tag,description FROM `data_videos` WHERE visibility='public' ORDER BY publish_date DESC LIMIT 20 ).
<style> .video-gallery-simple { padding: 20px; } .video-grid-simple {
display: grid; grid-template-columns: repeat(auto-fill, minmax(280px, 1fr)); gap: 20px;
} .video-card-simple {
background: #f5f5f5; border-radius: 8px; overflow: hidden;
} .video-card-simple a {
position: relative; display: block;
} .video-card-simple img {
width: 100%; height: auto;
} .video-duration {
position: absolute; bottom: 8px; right: 8px; background: rgba(0,0,0,0.8); color: white; padding: 2px 6px; border-radius: 3px; font-size: 12px;
} .video-card-simple h3 {
padding: 10px; margin: 0; font-size: 16px;
} .video-meta {
padding: 0 10px 10px; margin: 0; color: #666; font-size: 14px;
} </style>