Hall of Fame

[fourdeltaOne]

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!

[PHPVibe A.]

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

[fourdeltaOne]

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.

[PHPVibe A.]

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

Code Select Expand

$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 Select Expand

type='4'

which means 'shared a video'.