Related Topics


[Video CMS v4]how to make the most recently added videos from subscribed users  (Read 1894 times) Print

1 B


fourdeltaOne  June 19, 2014, 09:58:10 AM

how to make the most recently added videos from subscribed users. (youtube)
I do not need see channel activity namely recently added video.

can give sql query? i will do the rest.

thanks in advance! :)

Logged
Skype: epic.mediauz


Alexander  June 19, 2014, 02:08:01 PM

In the buzz page?
The code it's already there in the sort :)

Logged

fourdeltaOne  June 21, 2014, 08:02:39 PM

Well, I'd like to put the thing together with the home page.
I need only recently added video of subscribed users.

using code sql  buzz page, did not work, as there are a subscriber counts and activity.

Logged
Skype: epic.mediauz


Alexander  June 21, 2014, 09:38:10 PM

  :o You don't just copy the code ....but it's your coding sample...


Code
$vq = "Select ".DB_PREFIX."activity.*, ".DB_PREFIX."users.avatar,".DB_PREFIX."users.id as pid, ".DB_PREFIX."users.name from ".DB_PREFIX."activity left join ".DB_PREFIX."users on ".DB_PREFIX."activity.user=".DB_PREFIX."users.id where ".DB_PREFIX."activity.user in (select uid from ".DB_PREFIX."users_friends where fid ='".user_id()."') and  ".DB_PREFIX."activity.type = '4' ORDER BY ".DB_PREFIX."activity.id DESC ".this_limit();

Notice the
Code
type='4'
which means 'shared a video'.

Logged