/** * 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); }