Нашел статью на джумлабок по выборке базы из Joomla по страницам с таким вот кодом: Код (PHP): $db = & JFactory::getDBO(); $limit = $mainframe->getUserStateFromRequest("$option.limit", 'limit', 14, 'int'); //I guess getUserStateFromRequest is for session or different reasons $limit_start = JRequest::getVar('limitstart', 0, '', 'int'); $db->setQuery('SELECT SQL_CALC_FOUND_ROWS x, y, z FROM jos_content WHERE x', $limit_start, $limit); $items = &$db->loadAssocList(); if (empty($items)) { $jAp->enqueueMessage($db->getErrorMsg(), 'error'); return; } else { //Here the beauty starts $db->setQuery('SELECT FOUND_ROWS();'); //не перезагружем запрос! а просто вернем данные их предыдущего запроса jimport('joomla.html.pagination'); $pageNav = new JPagination( $db->loadResult(), $limit_start, $limit ); foreach($items as $item) { //вывод элементов } echo $pageNav->getListFooter(); // отображаем навигацию } Далее пытаюсь повторить ее, но не получается: Код (PHP): defined('_JEXEC') or die; $db = JFactory::getDBO(); $limit = $mainframe->getUserStateFromRequest("$option.limit", 'limit', 14, 'int'); //I guess getUserStateFromRequest is for session or different reasons $limit_start = JRequest::getVar('limitstart', 0, '', 'int'); $db->setQuery('SELECT SQL_CALC_FOUND_ROWS id,data_match,league,team,ourpick,results FROM derst_blood WHERE id', $limit_start, $limit); $items = $db->loadAssocList(); //Here the beauty starts $db->setQuery('SELECT FOUND_ROWS();'); //не перезагружем запрос! а просто вернем данные их предыдущего запроса jimport('joomla.html.pagination'); $pageNav = new JPagination( $db->loadResult(), $limit_start, $limit ); foreach($items as $key => $value) { //вывод элементов echo '<td class="time" style="height: 15px; width: 50px; text-align: center;">'.$value['data_match'].'</td>'; } echo $pageNav->getListFooter(); // отображаем навигацию } Долго пытался сам понять причину не работоспособности. Ошибок не выдается в принципе, просто белый лист. Даже сам сайт не подгружается. Попробовал так, дабы посмотреть что отдает loadAssocList(); : Код (PHP): defined('_JEXEC') or die; jimport('joomla.html.pagination'); /* $limit = $mainframe->getUserStateFromRequest("$option.limit", 'limit', 14, 'int'); //I guess getUserStateFromRequest is for session or different reasons $limit_start = JRequest::getVar('limitstart', 0, '', 'int'); */ $db = JFactory::getDBO(); $query = 'SELECT id,data_match,league,team,ourpick,results FROM derst_bloodybet_tips WHERE id ORDER BY `derst_bloodybet_tips`.`id` DESC'; $db->setQuery($query); $data = $db->loadAssocList(); print_r($data); Массив данных, все норм. А при таком запросе, ниже, как в статье ничего не возвращается. Я так понимаю SQL_CALC_FOUND_ROWS, просто считает количество строк,так? : Код (PHP): defined('_JEXEC') or die; $db = JFactory::getDBO(); $limit = $mainframe->getUserStateFromRequest("$option.limit", 'limit', 14, 'int'); //I guess getUserStateFromRequest is for session or different reasons $limit_start = JRequest::getVar('limitstart', 0, '', 'int'); $db->setQuery('SELECT SQL_CALC_FOUND_ROWS id,data_match,league,team,ourpick,results FROM derst_blood WHERE id', $limit_start, $limit); $items = $db->loadAssocList(); print_r($items); Больше чем уверен, что-то напутал я, ибо все делается методом тыка и подстановок. Буду благодарен за подсказки.
Код (PHP): defined('_JEXEC') or die; jimport('joomla.html.pagination'); $limit = $mainframe->getUserStateFromRequest("$option.limit", 'limit', 14, 'int'); //I guess getUserStateFromRequest is for session or different reasons $limit_start = JRequest::getVar('limitstart', 0, '', 'int'); $db = JFactory::getDBO(); $query = 'SELECT SQL_CALC_FOUND_ROWS id,data_match,league,team,ourpick,results FROM derst_bloodybet_tips WHERE id DESC'; $db->setQuery($query, $limit_start, $limit); $data = $db->loadAssocList(); print_r($data); Так же белый лист.
Судя по описанию функции SUM, она приведет сумму всех значений в колонке, а не посчитает количество строк в таблице. А задача: при запросе в базу, посчитать количество строк -> и передать их в loadAssocList(); -> а от туда вывести в таблицу, разбивая ее на страницы. И соответственно дальше выводить Nое количество строчек из базы, на страницу, с навигацией под таблицей < 1,2,3 > с помощью JPagination. Ну по крайней мере я так понял приведенный код в статье. Код (PHP): <?php defined('_JEXEC') or die; $db = & JFactory::getDBO(); $limit = $mainframe->getUserStateFromRequest("$option.limit", 'limit', 14, 'int'); //I guess getUserStateFromRequest is for session or different reasons $limit_start = JRequest::getVar('limitstart', 0, '', 'int'); $db->setQuery('SELECT SQL_CALC_FOUND_ROWS id,data_match,league,team,ourpick,results FROM derst_bloodybet_tips WHERE id DESC', $limit_start, $limit); $items = &$db->loadAssocList(); if (empty($items)) { $jAp->enqueueMessage($db->getErrorMsg(), 'error'); return; } else { //Here the beauty starts $db->setQuery('SELECT FOUND_ROWS();'); //не перезагружем запрос! а просто вернем данные их предыдущего запроса jimport('joomla.html.pagination'); $pageNav = new JPagination( $db->loadResult(), $limit_start, $limit ); foreach($items as $item) { //вывод элементов } echo $pageNav->getListFooter(); // отображаем навигацию } ?> И плюс не понимаю, даже если не правильный запрос или или ошибка в php. Почему Joomla не стартует на странице этой, просто белый лист без ошибок. Показ ошибок включен. UPD: Порылся по корню, увидел что изменен путь pagination.php. Судя по инфе с форумов, в версии 3. Новый путь к файлу: \libraries\cms\pagination\pagination.php. Старый: /libraries/joomla/ html /pagination.php Правильно ли я испраивл вызов? : jimport('cms.pagination.pagination'); --- добавлено: 20.04.2017, первое сообщение размещено: 19.04.2017 --- Код (PHP): <?php // No direct access defined('_JEXEC') or die; jimport('cms.pagination.pagination'); $db = & JFactory::getDBO(); $limit = 20; //I guess getUserStateFromRequest is for session or different reasons $limit_start = JRequest::getVar('limitstart', 0, '', 'int'); $db->setQuery('SELECT SQL_CALC_FOUND_ROWS id, data_match,league,team,ourpick,results FROM derst_bloodybet_tips ORDER BY id DESC', $limit_start, $limit); $items = &$db->loadAssocList(); if (empty($items)) { $jAp->enqueueMessage($db->getErrorMsg(), 'error'); return; } else { //Here the beauty starts $db->setQuery('SELECT FOUND_ROWS();'); //не перезагружем запрос! а просто вернем данные их предыдущего запроса $pageNav = new JPagination( $db->loadResult(), $limit_start, $limit ); echo '<table class="coefs" style="width: 877px; height: 19px;" border="0"> <tbody>' ; echo'<tr style="height: 10px;">'; echo'<td class="" style="height: 10px; width: 50pxpx; text-align: left;">'; echo'<h1 style="text-align: left;margin: 0 0 -70px 0"><strong>'; echo JText::_('COM_BLOODYBET_FORM_LBL_BLOODYTIPS_DATA_MATCH'); echo'</strong></h1>'; echo'</td>'; echo'<td class="" style="height: 10px; width: 150px; text-align: left;">'; echo'<h1 style="text-align: left;margin: 0 0 -70px 0"><strong>'; echo JText::_('COM_BLOODYBET_FORM_LBL_BLOODYTIPS_LEAGUE'); echo'</strong></h1>'; echo'</td>'; echo'<td class="" style="height: 10px; width: 150px; text-align: left;">'; echo'<h1 style="text-align: left;margin: 0 0 -70px 0"><strong>'; echo JText::_('COM_BLOODYBET_FORM_LBL_BLOODYTIPS_TEAM'); echo'</strong></h1>'; echo'</td>'; echo'<td style="height: 10px; width: 250px; text-align: left;">'; echo'<h1 style="text-align: left;margin: 0 0 -70px 0"><strong>'; echo JText::_('COM_BLOODYBET_FORM_LBL_BLOODYTIPS_OURPICK'); echo'</strong></h1>'; echo'</td>'; echo'<td style="height: 10px; width: 60px; text-align: center;">'; echo'<h1 style="text-align: left;margin: 0 0 -70px 0"><strong>'; echo JText::_('COM_BLOODYBET_FORM_LBL_BLOODYTIPS_RESULTS'); echo'</strong></h1>'; echo'</td>'; echo'</tr>'; foreach($items as $key => $value) { /* print_r($value);*/ //вывод элементов echo '<tr style="height: 15px;">'; echo '<td class="time" style="height: 15px; width: 50px; text-align: center;">'.$value['data_match'].'</td>'; echo '<td class="teams" style="height: 15px; width: 150px; text-align: left;">'.$value['league'].'</td>'; echo '<td class="" style="height: 15px; width: 190px; text-align: left;">'.$value['team'].'</td>'; echo '<td style="height: 15px; width: 210px; text-align: left;">'.$value['ourpick'].'</td>'; echo '<td style="height: 15px; width: 60px; text-align: center;">'.$value['results'].'</td>'; echo '</tr>'; } echo '</table>'; echo $pageNav->getPaginationLinks(); // отображаем навигацию } ?> Убрал Код (PHP): $mainframe->getUserStateFromRequest("$option.limit", 'limit', 14, 'int'); Изменил jimport('joomla.html.pagination'); на jimport('cms.pagination.pagination'); И все почти заработало! Выводится таблица, 20 результатов, как задано в Код (PHP): $limit = 20; Под таблицей появляется выбор страницы и выбор количества выводимых строк: Но выбор количества значений из выпадающего списка вообще не функционирует. так же ка ки выбор страницы, еси нажать на номер 2, то получается адрес вида "index.php?option=com_bloodybet&view=bloodytipss2&Itemid=23#", так же как и на 3, 4,5... Мне кажется что-то кроется в функции getPaginationLinks()пробывал как в изначальной статье getListFooter();, результат одинаковый), может быть что-то не совпадает с версией joomla и статья из которой я черпал информацию написана под ранние версии?
Вылезают такие ошибки в консоли браузера, при нажатии на цифру страницы которую выводит echo $pageNav->getPaginationLinks(); // отображаем навигацию Вот на что ругается браузер: Код (html): <ul class="pagination-list"> <li class="disabled"> <span><span class="icon-backward icon-first"></span></span> </li> <li class="disabled"> <span><span class="icon-step-backward icon-previous"></span></span> </li> <li class="active"> <span>1</span> </li> <li> <a class="" href="#" onclick="document.adminForm.limitstart.value=20; Joomla.submitform();return false;"> 2 </a> </li> <li> <a class="" href="#" onclick="document.adminForm.limitstart.value=40; Joomla.submitform();return false;"> 3 </a> </li> <li> <a class="" href="#" onclick="document.adminForm.limitstart.value=60; Joomla.submitform();return false;"> 4 </a> </li> <li> <a class="" href="#" onclick="document.adminForm.limitstart.value=80; Joomla.submitform();return false;"> 5 </a> </li> <li> <a class="" href="#" onclick="document.adminForm.limitstart.value=100; Joomla.submitform();return false;"> 6 </a> </li> <li> <a class="" href="#" onclick="document.adminForm.limitstart.value=120; Joomla.submitform();return false;"> 7 </a> </li> <li> <a class="" href="#" onclick="document.adminForm.limitstart.value=140; Joomla.submitform();return false;"> 8 </a> </li> <li> <a class="hasTooltip" title="Next" href="#" onclick="document.adminForm.limitstart.value=20; Joomla.submitform();return false;"> <span class="icon-step-forward icon-next"></span> </a> </li> <li> <a class="hasTooltip" title="End" href="#" onclick="document.adminForm.limitstart.value=140; Joomla.submitform();return false;"> <span class="icon-forward icon-last"></span> </a> </li> </ul> <input type="hidden" name="limitstart" value="0" /> </div> Во-первых, меня смущает почему подставляется что-то связанное с админкой :document.adminForm.limitstart.value=140; Joomla.submitform();return false А во вторых, не понимаю почему вместо ссылок #, почему то пагенация не работает. --- добавлено: 20.04.2017, первое сообщение размещено: 20.04.2017 --- Ну мне нужно что бы выводилось стандартно, без возможности выбрать пользователю, то количество которое я указываю. То бишь 20, строк из таблицы, на 1 страничку и далее переход по 1,2,3,4
Вынос мозга выдал print_r($pageNav);: Код (PHP): JPagination Object ( [limitstart] => 0 [limit] => 20 [total] => 152 [prefix] => [pagesStart] => 1 [pagesStop] => 8 [pagesCurrent] => 1 [pagesTotal] => 8 [viewall:protected] => [additionalUrlParams:protected] => Array ( ) [app:protected] => JApplicationSite Object ( [_language_filter:protected] => [_detect_browser:protected] => [docOptions:protected] => Array ( ) [scope] => com_bloodybet [_clientId:protected] => 0 [_messageQueue:protected] => Array ( ) [_name:protected] => site [profiler:protected] => [template:protected] => stdClass Object ( [id] => 9 [home] => 1 [template] => hot_betting [params] => Joomla\Registry\Registry Object ( [data:protected] => stdClass Object ( [templateWidth] => 916 [columnLeftWidth] => 209 [columnRightWidth] => 209 [textDirection] => ltr [copyright] => BloodyBet [templateStyle] => 2 [backgroundColor] => #1a3c5d [topLineColor] => #0e3154 [headerBg] => header_bg1.jpg [bodyText] => #659dd1 [linksColor] => #8ccd00 [componentHeadingText] => #ffffff [headingText] => #ffffff [headingHoverText] => #ffffff [menuEffect] => fadeIn(700) [topMenuText] => #89ce00 [topMenuHoverText] => #ffffff [topMenuSubBgHover] => #20609b [topMenuSubText] => #ffffff [topMenuSubTextHover] => #ffffff [columnFirstWord] => #283751 [columnHeading] => #283751 [columnText] => #659dd1 [columnLink] => #ffffff [footerWrapBg] => #0e3154 [footerText] => #cccccc [footerLink] => #cccccc [footerLinkHover] => #ffffff ) [initialized:protected] => 1 [separator] => . ) ) [charSet] => utf-8 [mimeType] => text/html [modifiedDate] => [client] => Joomla\Application\Web\WebClient Object ( [platform:protected] => [mobile:protected] => [engine:protected] => [browser:protected] => 19 [browserVersion:protected] => 57.0.2987.133 [languages:protected] => Array ( ) [encodings:protected] => Array ( ) [userAgent:protected] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36 [acceptEncoding:protected] => gzip, deflate, sdch [acceptLanguage:protected] => ru-RU,ru;q=0.8,en-US;q=0.6,en;q=0.4 [robot:protected] => [detection:protected] => Array ( [browser] => 1 ) [headers:protected] => ) [document:protected] => JDocumentHtml Object ( [_links] => Array ( ) [_custom] => Array ( ) [template] => [baseurl] => [params] => [_file] => [_template:protected] => [_template_tags:protected] => Array ( ) [_caching:protected] => [_html5:JDocumentHtml:private] => [title] => History [description] => dsa [link] => [base] => [language] => en-gb [direction] => ltr [_generator] => Joomla! - Open Source Content Management [_mdate] => [_tab] => [_lineEnd] => [_charset] => utf-8 [_mime] => text/html [_namespace] => [_profile] => [_scripts] => Array ( ) [_script] => Array ( ) [scriptOptions:protected] => Array ( ) [_styleSheets] => Array ( ) [_style] => Array ( ) [_metaTags] => Array ( [http-equiv] => Array ( [content-type] => text/html; charset=utf-8 ) [name] => Array ( [keywords] => [rights] => ) ) [_engine] => [_type] => html [mediaVersion:protected] => 5a52a366dda2dfc130b9c554635dce6b ) [language:protected] => JLanguage Object ( [debug:protected] => [default:protected] => en-GB [orphans:protected] => Array ( ) [metadata:protected] => Array ( [name] => English (en-GB) [tag] => en-GB [rtl] => 0 [locale] => en_GB.utf8, en_GB.UTF-8, en_GB, eng_GB, en, english, english-uk, uk, gbr, britain, england, great britain, uk, united kingdom, united-kingdom [firstDay] => 0 [weekEnd] => 0,6 ) [locale:protected] => [lang:protected] => en-GB [paths:protected] => Array ( [joomla] => Array ( [/home/u190734/bettingtips-bloodybetcom/tester/language/en-GB/en-GB.ini] => 1 ) [lib_joomla] => Array ( [/home/u190734/bettingtips-bloodybetcom/tester/language/en-GB/en-GB.lib_joomla.ini] => 1 ) [plg_system_updatenotification] => Array ( [/home/u190734/bettingtips-bloodybetcom/tester/administrator/language/en-GB/en-GB.plg_system_updatenotification.ini] => 1 ) [plg_system_logout] => Array ( [/home/u190734/bettingtips-bloodybetcom/tester/administrator/language/en-GB/en-GB.plg_system_logout.ini] => 1 ) [tpl_hot_betting] => Array ( [/home/u190734/bettingtips-bloodybetcom/tester/language/en-GB/en-GB.tpl_hot_betting.ini] => 1 ) [com_bloodybet] => Array ( [/home/u190734/bettingtips-bloodybetcom/tester/language/en-GB/en-GB.com_bloodybet.ini] => 1 ) ) [errorfiles:protected] => Array ( ) [strings:protected] => Array ( [JERROR_PARSING_LANGUAGE_FILE] => : error(s) in line(s) %s [ERROR] => Error [MESSAGE] => Message [NOTICE] => Notice [WARNING] => Warning [J1] => 1 [J2] => 2 [J3] => 3 [J4] => 4 [J5] => 5 [J6] => 6 [J7] => 7 [J8] => 8 [J9] => 9 [J10] => 10 [J15] => 15 [J20] => 20 [J25] => 25 [J30] => 30 [J50] => 50 [J100] => 100 [J200] => 200 [J500] => 500 [JACTION_ADMIN] => Configure [JACTION_ADMIN_GLOBAL] => Super User [JACTION_COMPONENT_SETTINGS] => Component Settings [JACTION_CREATE] => Create [JACTION_DELETE] => Delete [JACTION_EDIT] => Edit [JACTION_EDITOWN] => Edit Own [JACTION_EDITSTATE] => Edit State [JACTION_LOGIN_ADMIN] => Administrator Login [JACTION_LOGIN_SITE] => Site Login [JACTION_MANAGE] => Access Administration Interface [JADMINISTRATOR] => Administrator [JALL] => All [JALL_LANGUAGE] => All [JAPPLY] => Save [JARCHIVED] => Archived [JAUTHOR] => Author [JCANCEL] => Cancel [JCATEGORY] => Category [JDATE] => Date [JDEFAULT] => Default [JDETAILS] => Details [JDISABLED] => Disabled [JEDITOR] => Editor [JENABLED] => Enabled [JEXPIRED] => Expired [JFALSE] => False [JFEATURED] => Featured [JHIDE] => Hide [JINVALID_TOKEN] => The most recent request was denied because it contained an invalid security token. Please refresh the page and try again. [JLOGIN] => Log in [JLOGOUT] => Log out [JNEW] => New [JNEXT] => Next [JNO] => No [JNONE] => None [JNOTPUBLISHEDYET] => Not published yet [JNOTICE] => Notice [JOFF] => Off [JOFFLINE_MESSAGE] => This site is down for maintenance. Please check back again soon. [JON] => On [JOPTIONS] => Options [JPAGETITLE] => %1$s - %2$s [JPREV] => Prev [JPREVIOUS] => Previous [JPUBLISHED] => Published [JREGISTER] => Register [JREQUIRED] => Required [JSAVE] => Save [JSHOW] => Show [JSITE] => Site [JSTATUS] => Status [JSUBMIT] => Submit [JTAG] => Tags [JTAG_DESC] => Assign tags to content items. You may select a tag from the pre-defined list or enter a new tag by typing the name in the field and pressing enter. [JTOOLBAR_VERSIONS] => Versions [JTRASH] => Trash [JTRASHED] => Trashed [JTRUE] => True [JUNPUBLISHED] => Unpublished [JYEAR] => Year [JYES] => Yes [JBROWSERTARGET_MODAL] => Modal [JBROWSERTARGET_NEW] => Open in new window [JBROWSERTARGET_PARENT] => Open in parent window [JBROWSERTARGET_POPUP] => Open in popup [JERROR_ALERTNOAUTHOR] => You are not authorised to view this resource. [JERROR_ALERTNOTEMPLATE] => The template for this display is not available. Please contact a Site administrator. [JERROR_AN_ERROR_HAS_OCCURRED] => An error has occurred. [JERROR_COULD_NOT_FIND_TEMPLATE] => Could not find template "%s". [JERROR_ERROR] => Error [JERROR_LAYOUT_AN_OUT_OF_DATE_BOOKMARK_FAVOURITE] => an out-of-date bookmark/favourite [JERROR_LAYOUT_ERROR_HAS_OCCURRED_WHILE_PROCESSING_YOUR_REQUEST] => An error has occurred while processing your request. [JERROR_LAYOUT_GO_TO_THE_HOME_PAGE] => Go to the Home Page [JERROR_LAYOUT_HOME_PAGE] => Home Page [JERROR_LAYOUT_MIS_TYPED_ADDRESS] => a mistyped address [JERROR_LAYOUT_NOT_ABLE_TO_VISIT] => You may not be able to visit this page because of: [JERROR_LAYOUT_PAGE_NOT_FOUND] => The requested page can't be found. [JERROR_LAYOUT_PLEASE_CONTACT_THE_SYSTEM_ADMINISTRATOR] => If difficulties persist, please contact the System Administrator of this site and report the error below. [JERROR_LAYOUT_PLEASE_TRY_ONE_OF_THE_FOLLOWING_PAGES] => Please try one of the following pages: [JERROR_LAYOUT_PREVIOUS_ERROR] => Previous Error [JERROR_LAYOUT_REQUESTED_RESOURCE_WAS_NOT_FOUND] => The requested resource was not found. [JERROR_LAYOUT_SEARCH] => You may wish to search the site or visit the home page. [JERROR_LAYOUT_SEARCH_ENGINE_OUT_OF_DATE_LISTING] => a search engine that has an out-of-date listing for this site [JERROR_LAYOUT_SEARCH_PAGE] => Search this site [JERROR_LAYOUT_YOU_HAVE_NO_ACCESS_TO_THIS_PAGE] => you have no access to this page [JERROR_LOADING_MENUS] => Error loading Menus: %s [JERROR_LOGIN_DENIED] => You can't access the private section of this site. [JERROR_NOLOGIN_BLOCKED] => Login denied! Your account has either been blocked or you have not activated it yet. [JERROR_PAGE_NOT_FOUND] => Page not found [JERROR_SESSION_STARTUP] => Error initialising the session. [JERROR_TABLE_BIND_FAILED] => hmm %s ... [JERROR_USERS_PROFILE_NOT_FOUND] => User profile not found [JFIELD_ACCESS_DESC] => Access level for this content. [JFIELD_ACCESS_LABEL] => Access [JFIELD_ALIAS_DESC] => The Alias will be used in the SEF URL. Leave this blank and Joomla! will fill in a default value from the title. This value will depend on the SEO settings (Global Configuration->Site). Using Unicode will produce UTF-8 aliases. You may also enter manually any UTF-8 character. Spaces and some forbidden characters will be changed to hyphens. When using default transliteration it will produce an alias in lower case and with dashes instead of spaces. You may enter the Alias manually. Use lowercase letters and hyphens (-). No spaces or underscores are allowed. Default value will be a date and time if the title is typed in non-latin letters . [JFIELD_ALIAS_LABEL] => Alias [JFIELD_ALIAS_PLACEHOLDER] => Auto-generate from title [JFIELD_ALT_PAGE_TITLE_LABEL] => Alternative Page Title [JFIELD_CATEGORY_DESC] => Category [JFIELD_LANGUAGE_DESC] => Assign a language to this article. [JFIELD_LANGUAGE_LABEL] => Language [JFIELD_META_DESCRIPTION_DESC] => Metadata description. [JFIELD_META_DESCRIPTION_LABEL] => Meta Description [JFIELD_META_KEYWORDS_DESC] => Keywords describing the content. [JFIELD_META_KEYWORDS_LABEL] => Keywords [JFIELD_META_RIGHTS_DESC] => Describe what rights others have to use this content. [JFIELD_META_RIGHTS_LABEL] => Content Rights [JFIELD_ORDERING_DESC] => Ordering of the article within the category. [JFIELD_ORDERING_LABEL] => Ordering [JFIELD_PUBLISHED_DESC] => Set publication status. [JFIELD_TITLE_DESC] => Title for the article. [JGLOBAL_ADD_CUSTOM_CATEGORY] => Add new Category [JGLOBAL_ARTICLES] => Articles [JGLOBAL_AUTH_ACCESS_DENIED] => Access Denied [JGLOBAL_AUTH_ACCESS_GRANTED] => Access Granted [JGLOBAL_AUTH_BIND_FAILED] => Failed binding to LDAP server [JGLOBAL_AUTH_CANCEL] => Authentication cancelled [JGLOBAL_AUTH_CURL_NOT_INSTALLED] => Curl isn't installed. [JGLOBAL_AUTH_EMPTY_PASS_NOT_ALLOWED] => Empty password not allowed. [JGLOBAL_AUTH_FAIL] => Authentication failed [JGLOBAL_AUTH_FAILED] => Failed to authenticate: %s [JGLOBAL_AUTH_INCORRECT] => Incorrect username/password [JGLOBAL_AUTH_INVALID_PASS] => Username and password do not match or you do not have an account yet. [JGLOBAL_AUTH_INVALID_SECRETKEY] => The two factor authentication Secret Key is invalid. [JGLOBAL_AUTH_NO_BIND] => Unable to bind to LDAP [JGLOBAL_AUTH_NO_CONNECT] => Unable to connect to LDAP server [JGLOBAL_AUTH_NO_REDIRECT] => Could not redirect to server: %s [JGLOBAL_AUTH_NO_USER] => Username and password do not match or you do not have an account yet. [JGLOBAL_AUTH_NOT_CREATE_DIR] => Could not create the FileStore folder %s. Please check the effective permissions. [JGLOBAL_AUTH_PASS_BLANK] => LDAP can't have blank password [JGLOBAL_AUTH_UNKNOWN_ACCESS_DENIED] => Result Unknown. Access Denied [JGLOBAL_AUTH_USER_BLACKLISTED] => User is blacklisted. [JGLOBAL_AUTH_USER_NOT_FOUND] => Unable to find user [JGLOBAL_AUTO] => Auto [JGLOBAL_CATEGORY_NOT_FOUND] => Category not found [JGLOBAL_CENTER] => Center [JGLOBAL_CHECK_ALL] => Check All [JGLOBAL_CLICK_TO_SORT_THIS_COLUMN] => Select to sort by this column [JGLOBAL_CREATED_DATE_ON] => Created on %s [JGLOBAL_CUSTOM_CATEGORY] => New Categories [JGLOBAL_DESCRIPTION] => Description [JGLOBAL_DISPLAY_NUM] => Display # [JGLOBAL_EDIT] => Edit [JGLOBAL_EDIT_TITLE] => Edit article [JGLOBAL_EMAIL] => Email [JGLOBAL_EMAIL_TITLE] => Email this link to a friend [JGLOBAL_FIELD_CATEGORIES_CHOOSE_CATEGORY_DESC] => Categories that are within this category will be displayed. [JGLOBAL_FIELD_CATEGORIES_CHOOSE_CATEGORY_LABEL] => Select a Top Level Category [JGLOBAL_FIELD_CATEGORIES_DESC_DESC] => If you enter some text in this field, it will override the Top Level Category Description, if it has one. [JGLOBAL_FIELD_CATEGORIES_DESC_LABEL] => Top Level Category Description [JGLOBAL_FIELD_CREATED_BY_ALIAS_DESC] => Uses another name than the author's for display. [JGLOBAL_FIELD_CREATED_BY_ALIAS_LABEL] => Author's Alias [JGLOBAL_FIELD_CREATED_BY_DESC] => The user who created this. [JGLOBAL_FIELD_CREATED_BY_LABEL] => Created By [JGLOBAL_FIELD_CREATED_DESC] => Created Date. [JGLOBAL_FIELD_CREATED_LABEL] => Created Date [JGLOBAL_FIELD_FEATURED_DESC] => Assign the article to the featured blog layout. [JGLOBAL_FIELD_FEATURED_LABEL] => Featured [JGLOBAL_FIELD_FIELD_CACHETIME_DESC] => The number of minutes before the cache is refreshed. [JGLOBAL_FIELD_FIELD_ORDERING_LABEL] => Order [JGLOBAL_FIELD_FIELD_ORDERING_DESC] => Order items will be displayed in. [JGLOBAL_FIELD_ID_DESC] => Record number in the database. [JGLOBAL_FIELD_ID_LABEL] => ID [JGLOBAL_FIELD_LAYOUT_DESC] => Default layout to use for items. [JGLOBAL_FIELD_LAYOUT_LABEL] => Choose a Layout [JGLOBAL_FIELD_MODIFIED_LABEL] => Modified Date [JGLOBAL_FIELD_MODIFIED_BY_DESC] => The user who did the last modification. [JGLOBAL_FIELD_MODIFIED_BY_LABEL] => Modified By [JGLOBAL_FIELD_NUM_CATEGORY_ITEMS_DESC] => Number of categories to display for each level. [JGLOBAL_FIELD_NUM_CATEGORY_ITEMS_LABEL] => Number of Categories [JGLOBAL_FIELD_PUBLISH_DOWN_DESC] => An optional date to stop publishing. [JGLOBAL_FIELD_PUBLISH_DOWN_LABEL] => Finish Publishing [JGLOBAL_FIELD_PUBLISH_UP_DESC] => An optional date to start publishing. [JGLOBAL_FIELD_PUBLISH_UP_LABEL] => Start Publishing [JGLOBAL_FIELD_SHOW_BASE_DESCRIPTION_DESC] => Show description of the top level category or optionally override with the text from the description field found in menu item. If using Root as top level category, the description field has to be filled. [JGLOBAL_FIELD_SHOW_BASE_DESCRIPTION_LABEL] => Top Level Category Description [JGLOBAL_FIELD_VERSION_NOTE_DESC] => Enter an optional note for this version of the item. [JGLOBAL_FIELD_VERSION_NOTE_LABEL] => Version Note [JGLOBAL_FILTER_BUTTON] => Filter [JGLOBAL_FILTER_LABEL] => Filter [JGLOBAL_FULL_TEXT] => Full Text [JGLOBAL_GT] => > [JGLOBAL_HELPREFRESH_BUTTON] => Refresh [JGLOBAL_HITS] => Hits [JGLOBAL_HITS_COUNT] => Hits: %s [JGLOBAL_ICON_SEP] => | [JGLOBAL_INHERIT] => Inherit
