Diskusné fórum

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

 ");

/*-------------------------------------------------------+

| PHP-Fusion Content Management System

| Copyright (C) PHP-Fusion Inc

| https://www.php-f...

+--------------------------------------------------------+

| Filename: videos/videos.php

| Author: RobiNN

 $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

 WHERE v.video_cat = 2

 ORDER BY v.video_datestamp DESC

 LIMIT 6

 ");