Odoslané pred 3 rokmi
Someone tried to remake the panel: The last video, to show video only from one category.The original panel, without any changes:
if (!defined('IN_FUSION')) {
die('Access Denied');
}
$videos = function_exists('infusion_exists') ? infusion_exists('videos') : db_exists(DB_PREFIX.'videos');
if ($videos) {
$side_panel = FALSE;
require_once INFUSIONS.'videos/functions.php';
$result = dbquery("SELECT v.*, vc.video_cat_id, vc.video_cat_name, u.user_id, u.user_name, u.user_status, u.user_avatar, u.user_level, u.user_joined
FROM ".DB_VIDEOS." v
INNER JOIN ".DB_VIDEO_CATS." vc on v.video_cat = vc.video_cat_id
LEFT JOIN ".DB_USERS." u ON v.video_user=u.user_id
ORDER BY v.video_datestamp DESC
LIMIT 6
");
I think I need to add code, in INNER JOIN: AND vc.video_cat_id='2', but I can not get the panel to work. Can someone help, show sample code.