- md5
- 51a9fb89ab5a4a7c869ca2aa8e28fed0
- sha1
- b5907b1ef0f75d99eef9616040185fe5097265ce
- sha256
- 56a5375932fae54d564db9d666b72f954fc4da89a8227494fa31e15d44cb5ef4
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896
<?php
/**
* @version $Id: content.php 1825 2006-01-14 21:48:43Z stingrey $
* @package Joomla
* @subpackage Content
* @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* Joomla! is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*/
// no direct access
defined( '_VALID_MOS' ) or die( 'Restricted access' );
require_once( $mainframe->getPath( 'front_html', 'com_content' ) );
$id = intval( mosGetParam( $_REQUEST, 'id', 0 ) );
$sectionid = intval( mosGetParam( $_REQUEST, 'sectionid', 0 ) );
$pop = intval( mosGetParam( $_REQUEST, 'pop', 0 ) );
$limit = intval( mosGetParam( $_REQUEST, 'limit', '' ) );
$order = mosGetParam( $_REQUEST, 'order', '' );
$limitstart = intval( mosGetParam( $_REQUEST, 'limitstart', 0 ) );
$now = date( 'Y-m-d H:i', time() + $mosConfig_offset * 60 * 60 );
// Editor usertype check
$access = new stdClass();
$access->canEdit = $acl->acl_check( 'action', 'edit', 'users', $my->usertype, 'content', 'all' );
$access->canEditOwn = $acl->acl_check( 'action', 'edit', 'users', $my->usertype, 'content', 'own' );
$access->canPublish = $acl->acl_check( 'action', 'publish', 'users', $my->usertype, 'content', 'all' );
// cache activation
$cache =& mosCache::getCache( 'com_content' );
// loads function for frontpage component
if ( $option == 'com_frontpage' ) {
$cache->call( 'frontpage', $gid, $access, $pop, $now, $limit, $limitstart );
return;
}
switch ( strtolower( $task ) ) {
case 'findkey':
findKeyItem( $gid, $access, $pop, $option, $now );
break;
case 'view':
showItem( $id, $gid, $access, $pop, $option, $now );
break;
case 'section':
$cache->call( 'showSection', $id, $gid, $access, $now );
break;
case 'category':
$cache->call( 'showCategory', $id, $gid, $access, $sectionid, $limit, $order, $limitstart, $now );
break;
case 'blogsection':
$cache->call('showBlogSection', $id, $gid, $access, $pop, $now, $limit, $limitstart );
break;
case 'blogcategorymulti':
case 'blogcategory':
$cache->call( 'showBlogCategory', $id, $gid, $access, $pop, $now, $limit, $limitstart );
break;
case 'archivesection':
showArchiveSection( $id, $gid, $access, $pop, $option );
break;
case 'archivecategory':
showArchiveCategory( $id, $gid, $access, $pop, $option, $now );
break;
case 'edit':
editItem( $id, $gid, $access, 0, $task, $Itemid );
break;
case 'new':
editItem( 0, $gid, $access, $sectionid, $task, $Itemid );
break;
case 'save':
case 'apply':
case 'apply_new':
mosCache::cleanCache( 'com_content' );
saveContent( $access, $task );
break;
case 'cancel':
cancelContent( $access );
break;
case 'emailform':
emailContentForm( $id );
break;
case 'emailsend':
emailContentSend( $id );
break;
case 'vote':
recordVote ();
break;
default:
//$cache->call('showBlogSection', 0, $gid, $access, $pop, $now );
header("HTTP/1.0 404 Not Found");
echo _NOT_EXIST;
break;
}
/**
* Searches for an item by a key parameter
* @param int The user access level
* @param object Actions this user can perform
* @param int
* @param string The url option
* @param string A timestamp
*/
function findKeyItem( $gid, $access, $pop, $option, $now ) {
global $database;
$keyref = mosGetParam( $_REQUEST, 'keyref', '' );
$keyref = $database->getEscaped( $keyref );
$query = "SELECT id"
. "\n FROM #__content"
. "\n WHERE attribs LIKE '%keyref=$keyref%'"
;
$database->setQuery( $query );
$id = $database->loadResult();
if ($id > 0) {
showItem( $id, $gid, $access, $pop, $option, $now );
} else {
echo 'Key not found';
}
}
function frontpage( $gid, &$access, $pop, $now ) {
global $database, $mainframe, $my, $Itemid;
$nullDate = $database->getNullDate();
$noauth = !$mainframe->getCfg( 'shownoauth' );
// Parameters
$menu = new mosMenu( $database );
$menu->load( $Itemid );
$params = new mosParameters( $menu->params );
$orderby_sec = $params->def( 'orderby_sec', '' );
$orderby_pri = $params->def( 'orderby_pri', '' );
// Ordering control
$order_sec = _orderby_sec( $orderby_sec );
$order_pri = _orderby_pri( $orderby_pri );
// query records
// $query = "SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups"
$query = "SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,"
. "\n a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,"
. "\n CHAR_LENGTH( a.fulltext ) AS readmore,"
. "\n ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups"
. "\n FROM #__content AS a"
. "\n INNER JOIN #__content_frontpage AS f ON f.content_id = a.id"
. "\n INNER JOIN #__categories AS cc ON cc.id = a.catid"
. "\n INNER JOIN #__sections AS s ON s.id = a.sectionid"
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
. "\n LEFT JOIN #__content_rating AS v ON a.id = v.content_id"
. "\n LEFT JOIN #__groups AS g ON a.access = g.id"
. "\n WHERE a.state = 1"
. ( $noauth ? "\n AND a.access <= $my->gid" : '' )
. "\n AND ( publish_up = '$nullDate' OR publish_up <= '$now' )"
. "\n AND ( publish_down = '$nullDate' OR publish_down >= '$now' )"
. "\n AND s.published = 1"
. "\n AND cc.published = 1"
. "\n ORDER BY $order_pri $order_sec"
;
$database->setQuery( $query );
$rows = $database->loadObjectList();
// Dynamic Page Title
$mainframe->SetPageTitle( $menu->name );
BlogOutput( $rows, $params, $gid, $access, $pop, $menu );
}
function showSection( $id, $gid, &$access, $now ) {
global $database, $mainframe, $Itemid;
$nullDate = $database->getNullDate();
$noauth = !$mainframe->getCfg( 'shownoauth' );
// Paramters
$params = new stdClass();
if ( $Itemid ) {
$menu = new mosMenu( $database );
$menu->load( $Itemid );
$params = new mosParameters( $menu->params );
} else {
$menu = '';
$params = new mosEmpty();
}
$orderby = $params->get( 'orderby', '' );
$params->set( 'type', 'section' );
$params->def( 'page_title', 1 );
$params->def( 'pageclass_sfx', '' );
$params->def( 'other_cat_section', 1 );
$params->def( 'empty_cat_section', 0 );
$params->def( 'other_cat', 1 );
$params->def( 'empty_cat', 0 );
$params->def( 'cat_items', 1 );
$params->def( 'cat_description', 1 );
$params->def( 'back_button', $mainframe->getCfg( 'back_button' ) );
$params->def( 'pageclass_sfx', '' );
// Ordering control
$orderby = _orderby_sec( $orderby );
$section = new mosSection( $database );
$section->load( $id );
if ( $access->canEdit ) {
$xwhere = '';
$xwhere2 = "\n AND b.state >= 0";
} else {
$xwhere = "\n AND a.published = 1";
$xwhere2 = "\n AND b.state = 1"
. "\n AND ( b.publish_up = '$nullDate' OR b.publish_up <= '$now' )"
. "\n AND ( b.publish_down = '$nullDate' OR b.publish_down >= '$now' )"
;
}
$empty = '';
$empty_sec = '';
if ( $params->get( 'type' ) == 'category' ) {
// show/hide empty categories
if ( !$params->get( 'empty_cat' ) ) {
$empty = "\n HAVING numitems > 0";
}
}
if ( $params->get( 'type' ) == 'section' ) {
// show/hide empty categories in section
if ( !$params->get( 'empty_cat_section' ) ) {
$empty_sec = "\n HAVING numitems > 0";
}
}
$access = '';
if ($noauth) {
$access = "\n AND a.access <= $gid";
}
// Main Query
$query = "SELECT a.*, COUNT( b.id ) AS numitems"
. "\n FROM #__categories AS a"
. "\n LEFT JOIN #__content AS b ON b.catid = a.id"
. $xwhere2
. "\n WHERE a.section = '$section->id'"
. $xwhere
. $access
. "\n GROUP BY a.id"
. $empty
. $empty_sec
. "\n ORDER BY $orderby"
;
$database->setQuery( $query );
$categories = $database->loadObjectList();
// Dynamic Page Title
$mainframe->SetPageTitle( $menu->name );
$null = null;
HTML_content::showContentList( $section, $null, $access, $id, $null, $gid, $params, $null, $categories, $null, $null );
}
/**
* @param int The category id
* @param int The group id of the user
* @param int The access level of the user
* @param int The section id
* @param int The number of items to dislpay
* @param int The offset for pagination
*/
function showCategory( $id, $gid, &$access, $sectionid, $limit, $selected, $limitstart, $now ) {
global $database, $mainframe, $Itemid, $mosConfig_list_limit;
$nullDate = $database->getNullDate();
$noauth = !$mainframe->getCfg( 'shownoauth' );
// Paramters
$params = new stdClass();
if ( $Itemid ) {
$menu = new mosMenu( $database );
$menu->load( $Itemid );
$params = new mosParameters( $menu->params );
} else {
$menu = '';
$params = new mosParameters( '' );
}
if ( $selected ) {
$orderby = $selected;
} else {
$orderby = $params->get( 'orderby', 'rdate' );
$selected = $orderby;
}
$params->set( 'type', 'category' );
$params->def( 'page_title', 1 );
$params->def( 'title', 1 );
$params->def( 'hits', $mainframe->getCfg( 'hits' ) );
$params->def( 'author', !$mainframe->getCfg( 'hideAuthor' ) );
$params->def( 'date', !$mainframe->getCfg( 'hideCreateDate' ) );
$params->def( 'date_format', _DATE_FORMAT_LC );
$params->def( 'navigation', 2 );
$params->def( 'display', 1 );
$params->def( 'display_num', $mosConfig_list_limit );
$params->def( 'other_cat', 1 );
$params->def( 'empty_cat', 0 );
$params->def( 'cat_items', 1 );
$params->def( 'cat_description', 0 );
$params->def( 'back_button', $mainframe->getCfg( 'back_button' ) );
$params->def( 'pageclass_sfx', '' );
$params->def( 'headings', 1 );
$params->def( 'order_select', 1 );
$params->def( 'filter', 1 );
$params->def( 'filter_type', 'title' );
// Ordering control
$orderby = _orderby_sec( $orderby );
$category = new mosCategory( $database );
$category->load( $id );
if ( $sectionid == 0 ) {
$sectionid = $category->section;
}
if ( $access->canEdit ) {
$xwhere = '';
$xwhere2 = "\n AND b.state >= 0";
} else {
$xwhere = "\n AND c.published = 1";
$xwhere2 = "\n AND b.state = 1"
. "\n AND ( publish_up = '$nullDate' OR publish_up <= '$now' )"
. "\n AND ( publish_down = '$nullDate' OR publish_down >= '$now' )"
;
}
$pagetitle = '';
if ( $Itemid ) {
$menu = new mosMenu( $database );
$menu->load( $Itemid );
$pagetitle = $menu->name;
} // if
// show/hide empty categories
$empty = '';
if ( !$params->get( 'empty_cat' ) )
$empty = "\n HAVING COUNT( b.id ) > 0";
// get the list of other categories
$query = "SELECT c.*, COUNT( b.id ) AS numitems"
. "\n FROM #__categories AS c"
. "\n LEFT JOIN #__content AS b ON b.catid = c.id "
. $xwhere2
. ( $noauth ? "\n AND b.access <= $gid" : '' )
. "\n WHERE c.section = '$category->section'"
. $xwhere
. ( $noauth ? "\n AND c.access <= $gid" : '' )
. "\n GROUP BY c.id"
. $empty
. "\n ORDER BY c.ordering"
;
$database->setQuery( $query );
$other_categories = $database->loadObjectList();
// get the total number of published items in the category
// filter functionality
$filter = mosGetParam( $_POST, 'filter', '' );
$filter = strtolower( $filter );
$and = '';
if ( $filter ) {
if ( $params->get( 'filter' ) ) {
switch ( $params->get( 'filter_type' ) ) {
case 'title':
$and = "\n AND LOWER( a.title ) LIKE '%$filter%'";
break;
case 'author':
$and = "\n AND ( ( LOWER( u.name ) LIKE '%$filter%' ) OR ( LOWER( a.created_by_alias ) LIKE '%$filter%' ) )";
break;
case 'hits':
$and = "\n AND a.hits LIKE '%$filter%'";
break;
}
}
}
if ( $access->canEdit ) {
$xwhere = "\n AND a.state >= 0";
} else {
$xwhere = "\n AND a.state = 1"
. "\n AND ( publish_up = '$nullDate' OR publish_up <= '$now' )"
. "\n AND ( publish_down = '$nullDate' OR publish_down >= '$now' )"
;
}
$query = "SELECT COUNT(a.id) as numitems"
. "\n FROM #__content AS a"
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
. "\n LEFT JOIN #__groups AS g ON a.access = g.id"
. "\n WHERE a.catid = $category->id"
. $xwhere
. ( $noauth ? "\n AND a.access <= $gid" : '' )
. "\n AND $category->access <= $gid"
. $and
. "\n ORDER BY $orderby"
;
$database->setQuery( $query );
$counter = $database->loadObjectList();
$total = $counter[0]->numitems;
$limit = $limit ? $limit : $params->get( 'display_num' ) ;
if ( $total <= $limit ) $limitstart = 0;
require_once( $GLOBALS['mosConfig_absolute_path'] . '/includes/pageNavigation.php' );
$pageNav = new mosPageNav( $total, $limitstart, $limit );
// get the list of items for this category
$query = "SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups"
. "\n FROM #__content AS a"
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
. "\n LEFT JOIN #__groups AS g ON a.access = g.id"
. "\n WHERE a.catid = $category->id"
. $xwhere
. ( $noauth ? "\n AND a.access <= $gid" : '' )
. "\n AND $category->access <= $gid"
. $and
. "\n ORDER BY $orderby"
. "\n LIMIT $limitstart, $limit"
;
$database->setQuery( $query );
$items = $database->loadObjectList();
$check = 0;
if ( $params->get( 'date' ) ) {
$order[] = mosHTML::makeOption( 'date', _ORDER_DROPDOWN_DA );
$order[] = mosHTML::makeOption( 'rdate', _ORDER_DROPDOWN_DD );
$check .= 1;
}
if ( $params->get( 'title' ) ) {
$order[] = mosHTML::makeOption( 'alpha', _ORDER_DROPDOWN_TA );
$order[] = mosHTML::makeOption( 'ralpha', _ORDER_DROPDOWN_TD );
$check .= 1;
}
if ( $params->get( 'hits' ) ) {
$order[] = mosHTML::makeOption( 'hits', _ORDER_DROPDOWN_HA );
$order[] = mosHTML::makeOption( 'rhits', _ORDER_DROPDOWN_HD );
$check .= 1;
}
if ( $params->get( 'author' ) ) {
$order[] = mosHTML::makeOption( 'author', _ORDER_DROPDOWN_AUA );
$order[] = mosHTML::makeOption( 'rauthor', _ORDER_DROPDOWN_AUD );
$check .= 1;
}
$order[] = mosHTML::makeOption( 'order', _ORDER_DROPDOWN_O );
$lists['order'] = mosHTML::selectList( $order, 'order', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'value', 'text', $selected );
if ( $check < 1 ) {
$lists['order'] = '';
$params->set( 'order_select', 0 );
}
$lists['task'] = 'category';
$lists['filter'] = $filter;
// Dynamic Page Title
$mainframe->SetPageTitle( $pagetitle );
HTML_content::showContentList( $category, $items, $access, $id, $sectionid, $gid, $params, $pageNav, $other_categories, $lists, $selected );
} // showCategory
function showBlogSection( $id=0, $gid, &$access, $pop, $now=NULL ) {
global $database, $mainframe, $Itemid;
$noauth = !$mainframe->getCfg( 'shownoauth' );
// Parameters
$params = new stdClass();
if ( $Itemid ) {
$menu = new mosMenu( $database );
$menu->load( $Itemid );
$params = new mosParameters( $menu->params );
} else {
$menu = "";
$params = new mosParameters( '' );
}
// new blog multiple section handling
if ( !$id ) {
$id = $params->def( 'sectionid', 0 );
}
$where = _where( 1, $access, $noauth, $gid, $id, $now );
// Ordering control
$orderby_sec = $params->def( 'orderby_sec', 'rdate' );
$orderby_pri = $params->def( 'orderby_pri', '' );
$order_sec = _orderby_sec( $orderby_sec );
$order_pri = _orderby_pri( $orderby_pri );
// Main data query
//$query = "SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, g.name AS groups"
$query = "SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,"
. "\n a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,"
. "\n CHAR_LENGTH( a.fulltext ) AS readmore,"
. "\n ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups"
. "\n FROM #__content AS a"
. "\n INNER JOIN #__categories AS cc ON cc.id = a.catid"
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
. "\n LEFT JOIN #__content_rating AS v ON a.id = v.content_id"
. "\n LEFT JOIN #__sections AS s ON a.sectionid = s.id"
. "\n LEFT JOIN #__groups AS g ON a.access = g.id"
. ( count( $where ) ? "\n WHERE ".implode( "\n AND ", $where ) : '' )
. "\n AND s.access <= $gid"
. "\n AND s.published = 1"
. "\n AND cc.published = 1"
. "\n ORDER BY $order_pri $order_sec"
;
$database->setQuery( $query );
$rows = $database->loadObjectList();
// Dynamic Page Title
if ($menu) {
$mainframe->setPageTitle( $menu->name );
}
BlogOutput( $rows, $params, $gid, $access, $pop, $menu );
}
function showBlogCategory( $id=0, $gid, &$access, $pop, $now ) {
global $database, $mainframe, $Itemid;
$noauth = !$mainframe->getCfg( 'shownoauth' );
// Paramters
$params = new stdClass();
if ( $Itemid ) {
$menu = new mosMenu( $database );
$menu->load( $Itemid );
$params = new mosParameters( $menu->params );
} else {
$menu = '';
$params = new mosParameters( '' );
}
// new blog multiple section handling
if ( !$id ) {
$id = $params->def( 'categoryid', 0 );
}
$where = _where( 2, $access, $noauth, $gid, $id, $now );
// Ordering control
$orderby_sec = $params->def( 'orderby_sec', 'rdate' );
$orderby_pri = $params->def( 'orderby_pri', '' );
$order_sec = _orderby_sec( $orderby_sec );
$order_pri = _orderby_pri( $orderby_pri );
// Main data query
//$query = "SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, g.name AS groups, cc.name AS category"
$query = "SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,"
. "\n a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,"
. "\n CHAR_LENGTH( a.fulltext ) AS readmore,"
. "\n ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups"
. "\n FROM #__content AS a"
. "\n LEFT JOIN #__categories AS cc ON cc.id = a.catid"
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
. "\n LEFT JOIN #__content_rating AS v ON a.id = v.content_id"
. "\n LEFT JOIN #__sections AS s ON a.sectionid = s.id"
. "\n LEFT JOIN #__groups AS g ON a.access = g.id"
. ( count( $where ) ? "\n WHERE ".implode( "\n AND ", $where ) : '' )
. "\n AND s.access <= $gid"
. "\n AND s.published = 1"
. "\n AND cc.published = 1"
. "\n ORDER BY $order_pri $order_sec"
;
$database->setQuery( $query );
$rows = $database->loadObjectList();
// Dynamic Page Title
$mainframe->SetPageTitle( $menu->name );
BlogOutput( $rows, $params, $gid, $access, $pop, $menu );
}
function showArchiveSection( $id=NULL, $gid, &$access, $pop, $option ) {
global $database, $mainframe;
global $Itemid;
$noauth = !$mainframe->getCfg( 'shownoauth' );
// Paramters
$year = mosGetParam( $_REQUEST, 'year', date( 'Y' ) );
$month = mosGetParam( $_REQUEST, 'month', date( 'm' ) );
$params = new stdClass();
if ( $Itemid ) {
$menu = new mosMenu( $database );
$menu->load( $Itemid );
$params = new mosParameters( $menu->params );
} else {
$menu = "";
$params = new mosParameters( '' );
}
$params->set( 'intro_only', 1 );
$params->set( 'year', $year );
$params->set( 'month', $month );
// Ordering control
$orderby_sec = $params->def( 'orderby_sec', 'rdate' );
$orderby_pri = $params->def( 'orderby_pri', '' );
$order_sec = _orderby_sec( $orderby_sec );
$order_pri = _orderby_pri( $orderby_pri );
// used in query
$where = _where( -1, $access, $noauth, $gid, $id, NULL, $year, $month );
// checks to see if 'All Sections' options used
if ( $id == 0 ) {
$check = '';
} else {
$check = "\n AND a.sectionid = $id";
}
// query to determine if there are any archived entries for the section
$query = "SELECT a.id"
. "\n FROM #__content as a"
. "\n WHERE a.state = -1"
. $check
;
$database->setQuery( $query );
$items = $database->loadObjectList();
$archives = count( $items );
// Main Query
//$query = "SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, g.name AS groups"
$query = "SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,"
. "\n a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,"
. "\n CHAR_LENGTH( a.fulltext ) AS readmore,"
. "\n ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups"
. "\n FROM #__content AS a"
. "\n INNER JOIN #__categories AS cc ON cc.id = a.catid"
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
. "\n LEFT JOIN #__content_rating AS v ON a.id = v.content_id"
. "\n LEFT JOIN #__sections AS s ON a.sectionid = s.id"
. "\n LEFT JOIN #__groups AS g ON a.access = g.id"
. ( count( $where ) ? "\n WHERE ". implode( "\n AND ", $where ) : '')
. "\n AND s.access <= $gid"
. "\n AND s.published = 1"
. "\n AND cc.published = 1"
. "\n ORDER BY $order_pri $order_sec"
;
$database->setQuery( $query );
$rows = $database->loadObjectList();
// initiate form
$link = 'index.php?option=com_content&task=archivesection&id='. $id .'&Itemid='. $Itemid;
echo '<form action="'.sefRelToAbs( $link ).'" method="post">';
// Dynamic Page Title
$mainframe->SetPageTitle( $menu->name );
if ( !$archives ) {
// if no archives for category, hides search and outputs empty message
echo '<br /><div align="center">'. _CATEGORY_ARCHIVE_EMPTY .'</div>';
} else {
BlogOutput( $rows, $params, $gid, $access, $pop, $menu, 1 );
}
echo '<input type="hidden" name="id" value="'. $id .'" />';
echo '<input type="hidden" name="Itemid" value="'. $Itemid .'" />';
echo '<input type="hidden" name="task" value="archivesection" />';
echo '<input type="hidden" name="option" value="com_content" />';
echo '</form>';
}
function showArchiveCategory( $id=0, $gid, &$access, $pop, $option, $now ) {
global $database, $mainframe;
global $Itemid;
// Parameters
$noauth = !$mainframe->getCfg( 'shownoauth' );
$year = mosGetParam( $_REQUEST, 'year', date( 'Y' ) );
$month = mosGetParam( $_REQUEST, 'month', date( 'm' ) );
$module = mosGetParam( $_REQUEST, 'module', '' );
// used by archive module
if ( $module ) {
$check = '';
} else {
$check = "\n AND a.catid = $id";
}
if ( $Itemid ) {
$menu = new mosMenu( $database );
$menu->load( $Itemid );
$params = new mosParameters( $menu->params );
} else {
$menu = '';
$params = new mosParameters( '' );
}
$params->set( 'year', $year );
$params->set( 'month', $month );
// Ordering control
$orderby_sec = $params->def( 'orderby', 'rdate' );
$order_sec = _orderby_sec( $orderby_sec );
// used in query
$where = _where( -2, $access, $noauth, $gid, $id, NULL, $year, $month );
// query to determine if there are any archived entries for the category
$query = "SELECT a.id"
. "\n FROM #__content as a"
. "\n WHERE a.state = -1"
. $check
;
$database->setQuery( $query );
$items = $database->loadObjectList();
$archives = count( $items );
//$query = "SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, g.name AS groups"
$query = "SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,"
. "\n a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,"
. "\n CHAR_LENGTH( a.fulltext ) AS readmore,"
. "\n ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups"
. "\n FROM #__content AS a"
. "\n INNER JOIN #__categories AS cc ON cc.id = a.catid"
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
. "\n LEFT JOIN #__content_rating AS v ON a.id = v.content_id"
. "\n LEFT JOIN #__sections AS s ON a.sectionid = s.id"
. "\n LEFT JOIN #__groups AS g ON a.access = g.id"
. ( count( $where ) ? "\n WHERE ". implode( "\n AND ", $where ) : '' )
. "\n AND s.access <= $gid"
. "\n AND s.published = 1"
. "\n AND cc.published = 1"
. "\n ORDER BY $order_sec"
;
$database->setQuery( $query );
$rows = $database->loadObjectList();
// initiate form
$link = 'index.php?option=com_content&task=archivecategory&id='. $id .'&Itemid='. $Itemid;
echo '<form action="'.sefRelToAbs( $link ).'" method="post">';
// Page Title
$mainframe->SetPageTitle( $menu->name );
if ( !$archives ) {
// if no archives for category, hides search and outputs empty message
echo '<br /><div align="center">'. _CATEGORY_ARCHIVE_EMPTY .'</div>';
} else {
// if coming from the Archive Module, the Archive Dropdown selector is not shown
if ( $id ) {
BlogOutput( $rows, $params, $gid, $access, $pop, $menu, 1 );
} else {
BlogOutput( $rows, $params, $gid, $access, $pop, $menu, 0 );
}
}
echo '<input type="hidden" name="id" value="'. $id .'" />';
echo '<input type="hidden" name="Itemid" value="'. $Itemid .'" />';
echo '<input type="hidden" name="task" value="archivecategory" />';
echo '<input type="hidden" name="option" value="com_content" />';
echo '</form>';
}
function BlogOutput ( &$rows, &$params, $gid, &$access, $pop, &$menu, $archive=NULL ) {
global $mainframe, $Itemid, $task, $id, $option, $database, $mosConfig_live_site;
// parameters
if ( $params->get( 'page_title', 1 ) && $menu) {
$header = $params->def( 'header', $menu->name );
} else {
$header = '';
}
$columns = $params->def( 'columns', 2 );
if ( $columns == 0 ) {
$columns = 1;
}
$intro = $params->def( 'intro', 4 );
$leading = $params->def( 'leading', 1 );
$links = $params->def( 'link', 4 );
$pagination = $params->def( 'pagination', 2 );
$pagination_results = $params->def( 'pagination_results', 1 );
$pagination_results = $params->def( 'pagination_results', 1 );
$descrip = $params->def( 'description', 1 );
$descrip_image = $params->def( 'description_image', 1 );
// needed for back button for page
$back = $params->get( 'back_button', $mainframe->getCfg( 'back_button' ) );
// needed to disable back button for item
$params->set( 'back_button', 0 );
$params->def( 'pageclass_sfx', '' );
$params->set( 'intro_only', 1 );
$total = count( $rows );
// pagination support
$limitstart = intval( mosGetParam( $_REQUEST, 'limitstart', 0 ) );
$limit = $intro + $leading + $links;
if ( $total <= $limit ) {
$limitstart = 0;
}
$i = $limitstart;
// needed to reduce queries used by getItemid
$ItemidCount['bs'] = $mainframe->getBlogSectionCount();
$ItemidCount['bc'] = $mainframe->getBlogCategoryCount();
$ItemidCount['gbs'] = $mainframe->getGlobalBlogSectionCount();
// used to display section/catagory description text and images
// currently not supported in Archives
if ( $menu && $menu->componentid && ( $descrip || $descrip_image ) ) {
switch ( $menu->type ) {
case 'content_blog_section':
$description = new mosSection( $database );
$description->load( $menu->componentid );
break;
case 'content_blog_category':
$description = new mosCategory( $database );
$description->load( $menu->componentid );
break;
default:
$menu->componentid = 0;
break;
}
}
// Page Output
// page header
if ( $header ) {
echo '<div class="componentheading'. $params->get( 'pageclass_sfx' ) .'">'. $header .'</div>';
}
if ( $archive ) {
echo '<br />';
echo mosHTML::monthSelectList( 'month', 'size="1" class="inputbox"', $params->get( 'month' ) );
echo mosHTML::integerSelectList( 2000, 2010, 1, 'year', 'size="1" class="inputbox"', $params->get( 'year' ), "%04d" );
echo '<input type="submit" class="button" />';
}
// checks to see if there are there any items to display
if ( $total ) {
$col_with = 100 / $columns; // width of each column
$width = 'width="'. intval( $col_with ) .'%"';
if ( $archive ) {
// Search Success message
$msg = sprintf( _ARCHIVE_SEARCH_SUCCESS, $params->get( 'month' ), $params->get( 'year' ) );
echo "<br /><br /><div align='center'>". $msg ."</div><br /><br />";
}
echo '<table class="blog' . $params->get( 'pageclass_sfx' ) . '" cellpadding="0" cellspacing="0">';
// Secrion/Category Description & Image
if ( $menu && $menu->componentid && ( $descrip || $descrip_image ) ) {
$link = $mosConfig_live_site .'/images/stories/'. $description->image;
echo '<tr>';
echo '<td valign="top">';
if ( $descrip_image && $description->image ) {
echo '<img src="'. $link .'" align="'. $description->image_position .'" hspace="6" alt="" />';
}
if ( $descrip && $description->description ) {
echo $description->description;
}
echo '<br/><br/>';
echo '</td>';
echo '</tr>';
}
// Leading story output
if ( $leading ) {
echo '<tr>';
echo '<td valign="top">';
for ( $z = 0; $z < $leading; $z++ ) {
if ( $i >= $total ) {
// stops loop if total number of items is less than the number set to display as leading
break;
}
echo '<div>';
show( $rows[$i], $params, $gid, $access, $pop, $option, $ItemidCount );
echo '</div>';
$i++;
}
echo '</td>';
echo '</tr>';
}
if ( $intro && ( $i < $total ) ) {
echo '<tr>';
echo '<td valign="top">';
echo '<table width="100%" cellpadding="0" cellspacing="0">';
// intro story output
for ( $z = 0; $z < $intro; $z++ ) {
if ( $i >= $total ) {
// stops loop if total number of items is less than the number set to display as intro + leading
break;
}
if ( !( $z % $columns ) || $columns == 1 ) {
echo '<tr>';
}
echo '<td valign="top" '. $width .'>';
// outputs either intro or only a link
if ( $z < $intro ) {
show( $rows[$i], $params, $gid, $access, $pop, $option, $ItemidCount );
} else {
echo '</td>';
echo '</tr>';
break;
}
echo '</td>';
// if ( !( ( $z + 1 ) % $columns ) || $columns == 1 ) {
// echo '</tr>';
// }
//
// $i++;
// }
//
// // this is required to output a final closing </tr> tag when the number of items does not fully
// // fill the last row of output - a blank column is left
// if ( $intro % $columns ) {
// echo '</tr>';
// }
$i++;
// this is required to output a closing </tr> tag if one of the 3 conditions are met
// 1. No of intro story output = number of columns
// 2. Total number of items is reached before the number set to display
// 3. Reached the last item but it does not fully fill the last row of output - a blank column is left
if ( !( ( $z + 1 ) % $columns ) || $columns == 1 ) {
echo '</tr>';
} else if ($i >= $total) {
echo '</tr>';
} else if ( ( ( $z + 1 )==$intro ) && ( $intro % $columns ) ) {
echo '</tr>';
}
}
echo '</table>';
echo '</td>';
echo '</tr>';
}
// Links output
if ( $links && ( $i < $total ) ) {
echo '<tr>';
echo '<td valign="top">';
echo '<div class="blog_more'. $params->get( 'pageclass_sfx' ) .'">';
HTML_content::showLinks( $rows, $links, $total, $i, 1, $ItemidCount );
echo '</div>';
echo '</td>';
echo '</tr>';
}
// Pagination output
if ( $pagination ) {
if ( ( $pagination == 2 ) && ( $total <= $limit ) ) {
// not visible when they is no 'other' pages to display
} else {
// get the total number of records
$limitstart = $limitstart ? $limitstart : 0;
require_once( $GLOBALS['mosConfig_absolute_path'] . '/includes/pageNavigation.php' );
$pageNav = new mosPageNav( $total, $limitstart, $limit );
if ( $option == 'com_frontpage' ) {
$link = 'index.php?option=com_frontpage&Itemid='. $Itemid;
} else if ( $archive ) {
$year = $params->get( 'year' );
$month = $params->get( 'month' );
$link = 'index.php?option=com_content&task='. $task .'&id='. $id .'&Itemid='. $Itemid.'&year='. $year .'&month='. $month;
} else {
$link = 'index.php?option=com_content&task='. $task .'&id='. $id .'&Itemid='. $Itemid;
}
echo '<tr>';
echo '<td valign="top" align="center">';
echo $pageNav->writePagesLinks( $link );
echo '<br /><br />';
echo '</td>';
echo '</tr>';
if ( $pagination_results ) {
echo '<tr>';
echo '<td valign="top" align="center">';
echo $pageNav->writePagesCounter();
echo '</td>';
echo '</tr>';
}
}
}
echo '</table>';
} else if ( $archive && !$total ) {
// Search Failure message for Archives
$msg = sprintf( _ARCHIVE_SEARCH_FAILURE, $params->get( 'month' ), $params->get( 'year' ) );
echo '<br /><br /><div align="center">'. $msg .'</div><br />';
} else {
// Generic blog empty display
echo _EMPTY_BLOG;
}
// Back Button
$params->set( 'back_button', $back );
mosHTML::BackButton ( $params );
}
function showItem( $uid, $gid, &$access, $pop, $option, $now ) {
global $database, $mainframe, $Itemid;
global $mosConfig_MetaTitle, $mosConfig_MetaAuthor;
$nullDate = $database->getNullDate();
if ( $access->canEdit ) {
$xwhere = '';
} else {
$xwhere = " AND ( a.state = 1 OR a.state = -1 )"
. "\n AND ( publish_up = '$nullDate' OR publish_up <= '$now' )"
. "\n AND ( publish_down = '$nullDate' OR publish_down >= '$now' )"
;
}
$query = "SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub"
. "\n FROM #__content AS a"
. "\n LEFT JOIN #__categories AS cc ON cc.id = a.catid"
. "\n LEFT JOIN #__sections AS s ON s.id = cc.section AND s.scope = 'content'"
. "\n LEFT JOIN #__users AS u ON u.id = a.created_by"
. "\n LEFT JOIN #__content_rating AS v ON a.id = v.content_id"
. "\n LEFT JOIN #__groups AS g ON a.access = g.id"
. "\n WHERE a.id = $uid"
. $xwhere
. "\n AND a.access <= $gid"
;
$database->setQuery( $query );
$row = NULL;
if ( $database->loadObject( $row ) ) {
if ( !$row->cat_pub && $row->catid ) {
// check whether category is published
mosNotAuth();
return;
}
if ( !$row->sec_pub && $row->sectionid ) {
// check whether section is published
mosNotAuth();
return;
}
$params = new mosParameters( $row->attribs );
$params->set( 'intro_only', 0 );
$params->def( 'back_button', $mainframe->getCfg( 'back_button' ) );
if ( $row->sectionid == 0) {
$params->set( 'item_navigation', 0 );
} else {
$params->set( 'item_navigation', $mainframe->getCfg( 'item_navigation' ) );
}
// loads the links for Next & Previous Button
if ( $params->get( 'item_navigation' ) ) {
// Paramters for menu item as determined by controlling Itemid
$menu = new mosMenu( $database );
$menu->load( $Itemid );
$mparams = new mosParameters( $menu->params );
// the following is needed as different menu items types utilise a different param to control ordering
// for Blogs the `orderby_sec` param is the order controlling param
// for Table and List views it is the `orderby` param
$mparams_list = $mparams->toArray();
if ( array_key_exists( 'orderby_sec', $mparams_list ) ) {
$order_method = $mparams->get( 'orderby_sec', '' );
} else {
$order_method = $mparams->get( 'orderby', '' );
}
// additional check for invalid sort ordering
if ( $order_method == 'front' ) {
$order_method = '';
}
$orderby = _orderby_sec( $order_method );
// array of content items in same category correctly ordered
$query = "SELECT a.id"
. "\n FROM #__content AS a"
. "\n WHERE a.catid = $row->catid"
. "\n AND a.state = $row->state"
. ($access->canEdit ? '' : "\n AND a.access <= $gid" )
. $xwhere
. "\n ORDER BY $orderby"
;
$database->setQuery( $query );
$list = $database->loadResultArray();
// this check needed if incorrect Itemid is given resulting in an incorrect result
if ( !is_array($list) ) {
$list = array();
}
// location of current content item in array list
$location = array_search( $uid, $list );
$row->prev = '';
$row->next = '';
if ( $location - 1 >= 0 ) {
// the previous content item cannot be in the array position -1
$row->prev = $list[$location - 1];
}
if ( ( $location + 1 ) < count( $list ) ) {
// the next content item cannot be in an array position greater than the number of array postions
$row->next = $list[$location + 1];
}
}
// page title
$mainframe->setPageTitle( $row->title );
if ($mosConfig_MetaTitle=='1') {
$mainframe->addMetaTag( 'title' , $row->title );
}
if ($mosConfig_MetaAuthor=='1') {
$mainframe->addMetaTag( 'author' , $row->author );
}
show( $row, $params, $gid, $access, $pop, $option );
} else {
mosNotAuth();
return;
}
}
function show( $row, $params, $gid, &$access, $pop, $option, $ItemidCount=NULL ) {
global $database, $mainframe, $Itemid;
global $cache;
$noauth = !$mainframe->getCfg( 'shownoauth' );
if ( $access->canEdit ) {
if ( $row->id === null || $row->access > $gid ) {
mosNotAuth();
return;
}
} else {
if ( $row->id === null || $row->state == 0 ) {
mosNotAuth();
return;
}
if ( $row->access > $gid ) {
if ( $noauth ) {
mosNotAuth();
return;
} else {
if ( !( $params->get( 'intro_only' ) ) ) {
mosNotAuth();
return;
}
}
}
}
// GC Parameters
$params->def( 'link_titles', $mainframe->getCfg( 'link_titles' ) );
$params->def( 'author', !$mainframe->getCfg( 'hideAuthor' ) );
$params->def( 'createdate', !$mainframe->getCfg( 'hideCreateDate' ) );
$params->def( 'modifydate', !$mainframe->getCfg( 'hideModifyDate' ) );
$params->def( 'print', !$mainframe->getCfg( 'hidePrint' ) );
$params->def( 'pdf', !$mainframe->getCfg( 'hidePdf' ) );
$params->def( 'email', !$mainframe->getCfg( 'hideEmail' ) );
$params->def( 'rating', $mainframe->getCfg( 'vote' ) );
$params->def( 'icons', $mainframe->getCfg( 'icons' ) );
$params->def( 'readmore', $mainframe->getCfg( 'readmore' ) );
// Other Params
$params->def( 'image', 1 );
$params->def( 'section', 0 );
$params->def( 'section_link', 0 );
$params->def( 'category', 0 );
$params->def( 'category_link', 0 );
$params->def( 'introtext', 1 );
$params->def( 'pageclass_sfx', '' );
$params->def( 'item_title', 1 );
$params->def( 'url', 1 );
// loads the link for Section name
if ( $params->get( 'section_link' ) ) {
$query = "SELECT a.id"
. "\n FROM #__menu AS a"
. "\n WHERE a.componentid = ". $row->sectionid.""
;
$database->setQuery( $query );
$_Itemid = $database->loadResult();
if ( $_Itemid ) {
$_Itemid = '&Itemid='. $_Itemid;
}
$link = sefRelToAbs( 'index.php?option=com_content&task=section&id='. $row->sectionid . $_Itemid );
$row->section = '<a href="'. $link .'">'. $row->section .'</a>';
}
// loads the link for Category name
if ( $params->get( 'category_link' ) ) {
$query = "SELECT a.id"
. "\n FROM #__menu AS a"
. "\n WHERE a.componentid = $row->catid"
;
$database->setQuery( $query );
$_Itemid = $database->loadResult();
if ( $_Itemid ) {
$_Itemid = '&Itemid='. $_Itemid;
}
$link = sefRelToAbs( 'index.php?option=com_content&task=category&sectionid='. $row->sectionid .'&id='. $row->catid . $_Itemid );
$row->category = '<a href="'. $link .'">'. $row->category .'</a>';
}
// loads current template for the pop-up window
$template = '';
if ( $pop ) {
$params->set( 'popup', 1 );
$query = "SELECT template"
. "\n FROM #__templates_menu"
. "\n WHERE client_id = 0"
. "\n AND menuid = 0"
;
$database->setQuery( $query );
$template = $database->loadResult();
}
// show/hides the intro text
if ( $params->get( 'introtext' ) ) {
$row->text = $row->introtext. ( $params->get( 'intro_only' ) ? '' : chr(13) . chr(13) . $row->fulltext);
} else {
$row->text = $row->fulltext;
}
// deal with the {mospagebreak} mambots
// only permitted in the full text area
$page = intval( mosGetParam( $_REQUEST, 'limitstart', 0 ) );
// record the hit
if ( !$params->get( 'intro_only' ) && ($page == 0)) {
$obj = new mosContent( $database );
$obj->hit( $row->id );
}
$cache->call( 'HTML_content::show', $row, $params, $access, $page, $option, $ItemidCount );
}
function editItem( $uid, $gid, &$access, $sectionid=0, $task, $Itemid ){
global $database, $my;
global $mosConfig_absolute_path, $mosConfig_live_site;
$nullDate = $database->getNullDate();
$row = new mosContent( $database );
// load the row from the db table
$row->load( $uid );
// fail if checked out not by 'me'
if ($row->isCheckedOut( $my->id )) {
mosErrorAlert( "The module [ ".$row->title." ] is currently being edited by another person.");
}
if ( $uid ) {
// existing record
if ( !( $access->canEdit || ( $access->canEditOwn && $row->created_by == $my->id ) ) ) {
mosNotAuth();
return;
}
} else {
// new record
if (!($access->canEdit || $access->canEditOwn)) {
mosNotAuth();
return;
}
}
if ( $uid ) {
$sectionid = $row->sectionid;
}
$lists = array();
// get the type name - which is a special category
$query = "SELECT name FROM #__sections"
. "\n WHERE id = $sectionid"
;
$database->setQuery( $query );
$section = $database->loadResult();
if ( $uid == 0 ) {
$row->catid = 0;
}
if ( $uid ) {
$row->checkout( $my->id );
if (trim( $row->publish_down ) == '0000-00-00 00:00:00') {
$row->publish_down = 'Never';
}
if (trim( $row->images )) {
$row->images = explode( "\n", $row->images );
} else {
$row->images = array();
}
$query = "SELECT name from #__users"
. "\n WHERE id = $row->created_by"
;
$database->setQuery( $query );
$row->creator = $database->loadResult();
$query = "SELECT name from #__users"
. "\n WHERE id = $row->modified_by"
;
$database->setQuery( $query );
$row->modifier = $database->loadResult();
$query = "SELECT content_id from #__content_frontpage"
."\n WHERE content_id = $row->id"
;
$database->setQuery( $query );
$row->frontpage = $database->loadResult();
} else {
$row->sectionid = $sectionid;
$row->version = 0;
$row->state = 0;
$row->ordering = 0;
$row->images = array();
$row->publish_up = date( 'Y-m-d', time() );
$row->publish_down = 'Never';
$row->creator = 0;
$row->modifier = 0;
$row->frontpage = 0;
}
// calls function to read image from directory
$pathA = $mosConfig_absolute_path .'/images/stories';
$pathL = $mosConfig_live_site .'/images/stories';
$images = array();
$folders = array();
$folders[] = mosHTML::makeOption( '/' );
mosAdminMenus::ReadImages( $pathA, '/', $folders, $images );
// list of folders in images/stories/
$lists['folders'] = mosAdminMenus::GetImageFolders( $folders, $pathL );
// list of images in specfic folder in images/stories/
$lists['imagefiles'] = mosAdminMenus::GetImages( $images, $pathL );
// list of saved images
$lists['imagelist'] = mosAdminMenus::GetSavedImages( $row, $pathL );
// make the select list for the states
$states[] = mosHTML::makeOption( 0, _CMN_UNPUBLISHED );
$states[] = mosHTML::makeOption( 1, _CMN_PUBLISHED );
$lists['state'] = mosHTML::selectList( $states, 'state', 'class="inputbox" size="1"', 'value', 'text', intval( $row->state ) );
// build the html select list for ordering
$query = "SELECT ordering AS value, title AS text"
. "\n FROM #__content"
. "\n WHERE catid = $row->catid"
. "\n ORDER BY ordering"
;
$lists['ordering'] = mosAdminMenus::SpecificOrdering( $row, $uid, $query, 1 );
// build list of categories
$lists['catid'] = mosAdminMenus::ComponentCategory( 'catid', $sectionid, intval( $row->catid ) );
// build the select list for the image positions
$lists['_align'] = mosAdminMenus::Positions( '_align' );
// build the html select list for the group access
$lists['access'] = mosAdminMenus::Access( $row );
// build the select list for the image caption alignment
$lists['_caption_align'] = mosAdminMenus::Positions( '_caption_align' );
// build the html select list for the group access
// build the select list for the image caption position
$pos[] = mosHTML::makeOption( 'bottom', _CMN_BOTTOM );
$pos[] = mosHTML::makeOption( 'top', _CMN_TOP );
$lists['_caption_position'] = mosHTML::selectList( $pos, '_caption_position', 'class="inputbox" size="1"', 'value', 'text' );
HTML_content::editContent( $row, $section, $lists, $images, $access, $my->id, $sectionid, $task, $Itemid );
}
/**
* Saves the content item an edit form submit
*/
function saveContent( &$access, $task ) {
global $database, $mainframe, $my;
global $mosConfig_absolute_path, $Itemid;
$nullDate = $database->getNullDate();
$row = new mosContent( $database );
if ( !$row->bind( $_POST ) ) {
echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
exit();
}
$isNew = $row->id < 1;
if ( $isNew ) {
// new record
if ( !( $access->canEdit || $access->canEditOwn ) ) {
mosNotAuth();
return;
}
$row->created = date( 'Y-m-d H:i:s' );
$row->created_by = $my->id;
} else {
// existing record
if ( !( $access->canEdit || ( $access->canEditOwn && $row->created_by == $my->id ) ) ) {
mosNotAuth();
return;
}
$row->modified = date( 'Y-m-d H:i:s' );
$row->modified_by = $my->id;
}
if ( trim( $row->publish_down ) == 'Never' ) {
$row->publish_down = $nullDate;
}
// code cleaner for xhtml transitional compliance
$row->introtext = str_replace( '<br>', '<br />', $row->introtext );
$row->fulltext = str_replace( '<br>', '<br />', $row->fulltext );
// remove <br /> take being automatically added to empty fulltext
$length = strlen( $row->fulltext ) < 9;
$search = strstr( $row->fulltext, '<br />');
if ( $length && $search ) {
$row->fulltext = NULL;
}
$row->title = ampReplace( $row->title );
// Publishing state hardening for Authors
if ( !$access->canPublish ) {
if ( $isNew ) {
// For new items - author is not allowed to publish - prevent them from doing so
$row->state = 0;
} else {
// For existing items keep existing state - author is not allowed to change status
$query = "SELECT state"
. "\n FROM #__content"
. "\n WHERE id = $row->id"
;
$database->setQuery( $query);
$state = $database->loadResult();
if ( $state ) {
$row->state = 1;
} else {
$row->state = 0;
}
}
}
if (!$row->check()) {
echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
exit();
}
$row->version++;
if (!$row->store()) {
echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
exit();
}
// manage frontpage items
require_once( $mainframe->getPath( 'class', 'com_frontpage' ) );
$fp = new mosFrontPage( $database );
if ( mosGetParam( $_REQUEST, 'frontpage', 0 ) ) {
// toggles go to first place
if (!$fp->load( $row->id )) {
// new entry
$query = "INSERT INTO #__content_frontpage"
. "\n VALUES ( $row->id, 1 )"
;
$database->setQuery( $query );
if (!$database->query()) {
echo "<script> alert('".$database->stderr()."');</script>\n";
exit();
}
$fp->ordering = 1;
}
} else {
// no frontpage mask
if ( !$fp->delete( $row->id ) ) {
$msg .= $fp->stderr();
}
$fp->ordering = 0;
}
$fp->updateOrder();
$row->checkin();
$row->updateOrder( "catid = $row->catid" );
// gets section name of item
$query = "SELECT s.title"
. "\n FROM #__sections AS s"
. "\n WHERE s.scope = 'content'"
. "\n AND s.id = $row->sectionid"
;
$database->setQuery( $query );
// gets category name of item
$section = $database->loadResult();
$query = "SELECT c.title"
. "\n FROM #__categories AS c"
. "\n WHERE c.id = $row->catid"
;
$database->setQuery( $query );
$category = $database->loadResult();
if ( $isNew ) {
// messaging for new items
require_once( $mosConfig_absolute_path .'/components/com_messages/messages.class.php' );
$query = "SELECT id"
. "\n FROM #__users"
. "\n WHERE sendEmail = 1"
;
$database->setQuery( $query );
$users = $database->loadResultArray();
foreach ($users as $user_id) {
$msg = new mosMessage( $database );
$msg->send( $my->id, $user_id, "New Item", sprintf( _ON_NEW_CONTENT, $my->username, $row->title, $section, $category ) );
}
}
$msg = $isNew ? _THANK_SUB : _E_ITEM_SAVED;
switch ( $task ) {
case 'apply':
$link = $_SERVER['HTTP_REFERER'];
break;
case 'apply_new':
$Itemid = mosGetParam( $_POST, 'Returnid', $Itemid );
$link = 'index.php?option=com_content&task=edit&id='. $row->id.'&Itemid='. $Itemid;
break;
case 'save':
default:
$Itemid = mosGetParam( $_POST, 'Returnid', '' );
if ( $Itemid ) {
$link = 'index.php?option=com_content&task=view&id='. $row->id.'&Itemid='. $Itemid;
} else {
$link = mosGetParam( $_POST, 'referer', '' );
}
break;
}
mosRedirect( $link, $msg );
}
/**
* Cancels an edit operation
* @param database A database connector object
*/
function cancelContent( &$access ) {
global $database, $my, $task;
$row = new mosContent( $database );
$row->bind( $_POST );
if ( $access->canEdit || ( $access->canEditOwn && $row->created_by == $my->id ) ) {
$row->checkin();
}
$Itemid = mosGetParam( $_POST, 'Returnid', '0' );
$referer = mosGetParam( $_POST, 'referer', '' );
$parts = parse_url( $referer );
parse_str( $parts['query'], $query );
if ( $task == 'edit' || $task == 'cancel' ) {
$Itemid = mosGetParam( $_POST, 'Returnid', '' );
$referer = 'index.php?option=com_content&task=view&id='. $row->id.'&Itemid='. $Itemid;
}
if ( $referer && !( $task == 'new' ) ) {
mosRedirect( $referer );
} else {
mosRedirect( 'index.php' );
}
}
/**
* Shows the email form for a given content item.
* @param int The content item id
*/
function emailContentForm( $uid ) {
global $database, $my;
$row = new mosContent( $database );
$row->load( $uid );
if ( $row->id === null || $row->access > $my->gid ) {
mosNotAuth();
return;
} else {
$query = "SELECT template"
. "\n FROM #__templates_menu"
. "\n WHERE client_id = 0"
. "\n AND menuid = 0"
;
$database->setQuery( $query );
$template = $database->loadResult();
HTML_content::emailForm( $row->id, $row->title, $template );
}
}
/**
* Shows the email form for a given content item.
* @param int The content item id
*/
function emailContentSend( $uid ) {
global $database, $mainframe;
global $mosConfig_live_site, $mosConfig_sitename;
$validate = mosGetParam( $_POST, mosHash( 'validate' ), 0 );
if (!$validate) {
// probably a spoofing attack
echo _NOT_AUTH;
return;
}
// First, make sure the form was posted from a browser.
// For basic web-forms, we don't care about anything
// other than requests from a browser:
if (!isset( $_SERVER['HTTP_USER_AGENT'] )) {
header( "HTTP/1.0 403 Forbidden" );
die( _NOT_AUTH );
exit;
}
// Make sure the form was indeed POST'ed:
// (requires your html form to use: action="post")
if (!$_SERVER['REQUEST_METHOD'] == 'POST' ) {
header("HTTP/1.0 403 Forbidden");
die( _NOT_AUTH );
exit;
}
// Attempt to defend against header injections:
$badStrings = array(
'Content-Type:',
'MIME-Version:',
'Content-Transfer-Encoding:',
'bcc:',
'cc:'
);
// Loop through each POST'ed value and test if it contains
// one of the $badStrings:
foreach ($_POST as $k => $v){
foreach ($badStrings as $v2) {
if (strpos( $v, $v2 ) !== false) {
header( "HTTP/1.0 403 Forbidden" );
die( _NOT_AUTH );
}
}
}
// Made it past spammer test, free up some memory
// and continue rest of script:
unset($k, $v, $v2, $badStrings);
$_Itemid = $mainframe->getItemid( $uid, 0, 0 );
$email = mosGetParam( $_POST, 'email', '' );
$yourname = mosGetParam( $_POST, 'yourname', '' );
$youremail = mosGetParam( $_POST, 'youremail', '' );
$subject_default = _EMAIL_INFO .' ' . $yourname;
$subject = mosGetParam( $_POST, 'subject', $subject_default );
if ($uid < 1 || !$email || !$youremail || ( is_email( $email ) == false ) || (is_email( $youremail ) == false)) {
mosErrorAlert( _EMAIL_ERR_NOINFO );
}
$query = "SELECT template"
. "\n FROM #__templates_menu"
. "\n WHERE client_id = 0"
. "\n AND menuid = 0"
;
$database->setQuery( $query );
$template = $database->loadResult();
// link sent in email
$link = sefRelToAbs( $mosConfig_live_site .'/index.php?option=com_content&task=view&id='. $uid .'&Itemid='. $_Itemid );
// message text
$msg = sprintf( _EMAIL_MSG, $mosConfig_sitename, $yourname, $youremail, $link );
// mail function
mosMail( $youremail, $yourname, $email, $subject, $msg );
HTML_content::emailSent( $email, $template );
}
function is_email( $email ){
$rBool = false;
if (preg_match( "/[\w\.\-]+@\w+[\w\.\-]*?\.\w{1,4}/", $email )) {
$rBool = true;
}
return $rBool;
}
function recordVote() {
global $database;
$user_rating = mosGetParam( $_REQUEST, 'user_rating', 0 );
$url = mosGetParam( $_REQUEST, 'url', '' );
$cid = mosGetParam( $_REQUEST, 'cid', 0 );
$cid = intval( $cid );
$user_rating = intval( $user_rating );
if (($user_rating >= 1) and ($user_rating <= 5)) {
$currip = getenv( 'REMOTE_ADDR' );
$query = "SELECT *"
. "\n FROM #__content_rating"
. "\n WHERE content_id = $cid"
;
$database->setQuery( $query );
$votesdb = NULL;
if ( !( $database->loadObject( $votesdb ) ) ) {
$query = "INSERT INTO #__content_rating ( content_id, lastip, rating_sum, rating_count )"
. "\n VALUES ( $cid, '$currip', $user_rating, 1 )";
$database->setQuery( $query );
$database->query() or die( $database->stderr() );;
} else {
if ($currip != ($votesdb->lastip)) {
$query = "UPDATE #__content_rating"
. "\n SET rating_count = rating_count + 1, rating_sum = rating_sum + $user_rating, lastip = '$currip'"
. "\n WHERE content_id = $cid"
;
$database->setQuery( $query );
$database->query() or die( $database->stderr() );
} else {
mosRedirect ( $url, _ALREADY_VOTE );
}
}
mosRedirect ( $url, _THANKS );
}
}
function _orderby_pri( $orderby ) {
switch ( $orderby ) {
case 'alpha':
$orderby = 'cc.title, ';
break;
case 'ralpha':
$orderby = 'cc.title DESC, ';
break;
case 'order':
$orderby = 'cc.ordering, ';
break;
default:
$orderby = '';
break;
}
return $orderby;
}
function _orderby_sec( $orderby ) {
switch ( $orderby ) {
case 'date':
$orderby = 'a.created';
break;
case 'rdate':
$orderby = 'a.created DESC';
break;
case 'alpha':
$orderby = 'a.title';
break;
case 'ralpha':
$orderby = 'a.title DESC';
break;
case 'hits':
$orderby = 'a.hits';
break;
case 'rhits':
$orderby = 'a.hits DESC';
break;
case 'order':
$orderby = 'a.ordering';
break;
case 'author':
$orderby = 'a.created_by_alias, u.name';
break;
case 'rauthor':
$orderby = 'a.created_by_alias DESC, u.name DESC';
break;
case 'front':
$orderby = 'f.ordering';
break;
default:
$orderby = 'a.ordering';
break;
}
return $orderby;
}
/*
* @param int 0 = Archives, 1 = Section, 2 = Category
*/
function _where( $type=1, &$access, &$noauth, $gid, $id, $now=NULL, $year=NULL, $month=NULL ) {
global $database;
$nullDate = $database->getNullDate();
$where = array();
// normal
if ( $type > 0) {
$where[] = "a.state = '1'";
if ( !$access->canEdit ) {
$where[] = "( a.publish_up = '$nullDate' OR a.publish_up <= '$now' )";
$where[] = "( a.publish_down = '$nullDate' OR a.publish_down >= '$now' )";
}
if ( $noauth ) {
$where[] = "a.access <= $gid";
}
if ( $id > 0 ) {
if ( $type == 1 ) {
$where[] = "a.sectionid IN ( $id ) ";
} else if ( $type == 2 ) {
$where[] = "a.catid IN ( $id ) ";
}
}
}
// archive
if ( $type < 0 ) {
$where[] = "a.state='-1'";
if ( $year ) {
$where[] = "YEAR( a.created ) = '$year'";
}
if ( $month ) {
$where[] = "MONTH( a.created ) = '$month'";
}
if ( $noauth ) {
$where[] = "a.access <= $gid";
}
if ( $id > 0 ) {
if ( $type == -1 ) {
$where[] = "a.sectionid = $id";
} else if ( $type == -2) {
$where[] = "a.catid = $id";
}
}
}
return $where;
}
?>
The same content is in 2 releases, Joomla 1.0.6 to 1.0.7. See them all, or every version of this file.