/**
* show flagged media
*/
function showflagged(&$rowsfv, &$rowsfg)
{
global $limitstart, $smartyvs, $Itemid;
/** define template variables **/
$hidden_inputs = '<input type="hidden" name="boxchecked" value="0" />
<input type="hidden" name="limitstart" value="'.$limitstart.'" />
<input type="hidden" name="option" value="com_hwdvideoshare" />
<input type="hidden" name="task" value="flagged" />
<input type="hidden" name="hidemainmenu" value="0">';
jimport('joomla.html.pane');
$pane =& JPane::getInstance('tabs');
$startpane = $pane->startPane( 'reported-pane' );
$endtab = $pane->endPanel();
$endpane = $pane->endPane();
$starttab1 = $pane->startPanel( _HWDVIDS_TAB_VIDEO, 'panel-v' );
$starttab2 = $pane->startPanel( _HWDVIDS_TAB_GROUPS, 'panel-g' );
/** assign template variables **/
$smartyvs->assign( "hidden_inputs", $hidden_inputs );
$smartyvs->assign( "header_title", _HWDVIDS_SECTIONHEAD_FLAGGED );
$smartyvs->assign( "totalvideos", count($rowsfv) );
$smartyvs->assign( "totalgroups", count($rowsfg) );
$smartyvs->assign( "startpane", $startpane );
$smartyvs->assign( "endtab", $endtab );
$smartyvs->assign( "endpane", $endpane );
$smartyvs->assign( "starttab1", $starttab1 );
$smartyvs->assign( "starttab2", $starttab2 );
$list_videos = array();
$k = 0;
for ($i=0, $n=count($rowsfv); $i < $n; $i++) {
$row = $rowsfv[$i];
$list_videos[$i]->id = $row->id;
$list_videos[$i]->checked = JHTML::_('grid.checkedout', $row, $i);
if ( $row->checked_out && ( $row->checked_out != $my->id ) ) {
$list_videos[$i]->title = stripslashes($row->title);
} else {
$link = 'index.php?option=com_hwdvideoshare&task=editvidsA&hidemainmenu=1&cid='. $row->id;
$list_videos[$i]->title = '<a href="'.$link.'" title="Edit Category">'.stripslashes($row->title).'</a>';
}
$list_videos[$i]->user = hwd_vs_tools::generateBEUserFromID($row->userid);
$list_videos[$i]->status = $row->status;
$list_videos[$i]->date = $row->date;
$list_videos[$i]->k = $k;
$list_videos[$i]->i = $i;
$k = 1 - $k;
}
$smartyvs->assign( "list_videos", $list_videos );
$cbtotal = count($rowsfv)+1;
$list_groups = array();
$k = 0;
for ($i=0, $n=count($rowsfg); $i < $n; $i++) {
$row = $rowsfg[$i];
$list_groups[$i]->id = $row->id;
$list_groups[$i]->checked = JHTML::_('grid.checkedout', $row, $cbtotal);
if ( $row->checked_out && ( $row->checked_out != $my->id ) ) {
$list_groups[$i]->title = stripslashes($row->title);
} else {
$link = 'index.php?option=com_hwdvideoshare&task=editgrpA&hidemainmenu=1&cid='. $row->id;
$list_groups[$i]->title = '<a href="'.$link.'" title="Edit Category">'.stripslashes($row->group_name).'</a>';
}
$list_groups[$i]->user = hwd_vs_tools::generateBEUserFromID($row->userid);
$list_groups[$i]->status = $row->status;
$list_groups[$i]->date = $row->date;
$list_groups[$i]->k = $k;
$list_groups[$i]->i = $cbtotal;
$cbtotal++;
$k = 1 - $k;
}
$smartyvs->assign( "list_groups", $list_groups );
/** display template **/
$smartyvs->display('admin_reported.tpl');
return;
}
function frontpage()
{
global $mainframe, $limitstart, $Itemid;
$db =& JFactory::getDBO();
$stats = array();
$db->setQuery( "SELECT count(*) FROM #__hwdvidsvideos WHERE approved = \"pending\"" );
$stats['approvals'] = $db->loadResult();
$db->SetQuery( "SELECT count(*) FROM #__hwdvidsvideos WHERE approved = \"queuedforconversion\" AND approved = \"queuedforthumbnail\"" );
$stats['conversion'] = $db->loadResult();
$db->SetQuery( "SELECT count(*) FROM #__hwdvidsflagged_videos WHERE status = \"UNREAD\"" );
$stats['reportedvideos'] = $db->loadResult();
$db->SetQuery( "SELECT count(*) FROM #__hwdvidsflagged_groups WHERE status = \"UNREAD\"" );
$stats['reportedgroups'] = $db->loadResult();
$db->SetQuery( "SELECT count(*) FROM #__hwdvidsvideos" );
$stats['totalvideos'] = $db->loadResult();
$db->SetQuery( "SELECT count(*) FROM #__hwdvidscategories" );
$stats['totalcategories'] = $db->loadResult();
$db->SetQuery( "SELECT count(*) FROM #__users" );
$stats['totalusers'] = $db->loadResult();
$db->SetQuery( "SELECT id FROM #__users ORDER BY registerDate DESC" );
$stats['latestuser'] = hwd_vs_tools::generateBEUserFromID($db->loadResult());
$db->SetQuery( "SELECT count(*) FROM #__hwdvidsgroups" );
$stats['totalgroups'] = $db->loadResult();
$db->SetQuery( "SELECT id, group_name FROM #__hwdvidsgroups ORDER BY date DESC" );
$latestgroup = $db->loadObject();
if (!empty($latestgroup->id)) { $stats['latestgroup'] = "<a href=\"index.php?option=com_hwdvideoshare&task=editgrpA&hidemainmenu=1&cid=".$latestgroup->id."\">$latestgroup->group_name</a>"; } else { $stats['latestgroup']=null; }
$db->SetQuery( "SELECT count(*) FROM #__hwdvidsvideos WHERE date_uploaded >= DATE_SUB(NOW(),INTERVAL 1 DAY)" );
$stats['totalvideostoday'] = $db->loadResult();
$db->SetQuery( "SELECT count(*) FROM #__hwdvidsvideos WHERE date_uploaded >= DATE_SUB(NOW(),INTERVAL 7 DAY)" );
$stats['totalvideosweek'] = $db->loadResult();
$db->SetQuery( "SELECT count(*) FROM #__hwdvidslogs_views" );
$views_30 = $db->loadResult();
$db->SetQuery( "SELECT SUM(views) FROM #__hwdvidslogs_archive" );
$views_all = $db->loadResult();
$stats['totalviews'] = $views_30 + $views_all;
$db->SetQuery( "SELECT count(*) FROM #__hwdvidslogs_favours" );
$favours_30 = $db->loadResult();
$db->SetQuery( "SELECT SUM(favours) FROM #__hwdvidslogs_archive" );
$favours_all = $db->loadResult();
$stats['totalfavours'] = $favours_30 + $favours_all;
$db->SetQuery( "SELECT * FROM #__hwdvidsvideos ORDER BY updated_rating DESC, rating_number_votes DESC LIMIT 0, 10" );
$mostpopular = $db->loadObjectList();
$db->SetQuery( "SELECT * FROM #__hwdvidsvideos ORDER BY number_of_views DESC LIMIT 0, 10" );
$mostviewed = $db->loadObjectList();
$db->SetQuery( "SELECT * FROM #__hwdvidsvideos ORDER BY date_uploaded DESC LIMIT 0, 10" );
$mostrecent = $db->loadObjectList();
$db->SetQuery( "SELECT * FROM #__hwdvidsgroups ORDER BY date DESC LIMIT 0, 10" );
$recentgroups = $db->loadObjectList();
hwdvids_HTML::frontpage($stats, $mostpopular, $mostviewed, $mostrecent, $recentgroups);
}
