function shGetNEWSPCategories($catId, $option, $shLangName, &$cat, &$sec)
{
if (empty($catId)) {
return false;
}
static $catData = null;
$sefConfig =& Sh404sefFactory::getConfig();
if (!is_null($catData[$shLangName][$catId])) {
// get DB
$database =& JFactory::getDBO();
$query = "SELECT c.id, c.section, c.title, s.id as sectionid, s.title as stitle" . "\n FROM #__categories as c, #__sections as s" . "\n WHERE " . "\n s.id = c.section" . "\n AND c.id = '" . $catId . "'";
$database->setQuery($query);
if (shTranslateUrl($option, $shLangName)) {
$categories = $database->loadObjectList();
} else {
$categories = $database->loadObjectList(false);
}
if (!empty($categories)) {
$sec = ($sefConfig->shNewsPInsertSecId ? $sectionId . $sefConfig->replacement : '') . $categories[0]->stitle;
// section
$cat = ($sefConfig->shNewsPInsertCatId ? $sectionId . $sefConfig->replacement : '') . $categories[0]->title;
// category
$catData[$shLangName][$catId]['cat'] = $cat;
$catData[$shLangName][$catId]['sec'] = $sec;
}
} else {
$cat = $catData[$shLangName][$catId]['cat'];
$sec = $catData[$shLangName][$catId]['sec'];
}
return !empty($cat);
}
function dm_sef_get_category_array($category_id, $option, $shLangName)
{
global $shMosConfig_locale;
$sefConfig =& shRouter::shGetConfig();
// get DB
$database =& JFactory::getDBO();
static $DMtree = null;
if (empty($tree[$shMosConfig_locale])) {
$q = "SELECT id, title, parent_id FROM #__categories";
// load them all in memory
$database->setQuery($q);
if (!shTranslateUrl($option, $shLangName)) {
// V 1.2.4.m
$DMtree[$shMosConfig_locale] = $database->loadObjectList('id', false);
} else {
$DMtree[$shMosConfig_locale] = $database->loadObjectList('id');
}
}
$title = array();
if ($sefConfig->shDMInsertCategories == 1) {
// only one category
$title[] = ($sefConfig->shDMInsertCategoryId ? $DMtree[$shMosConfig_locale][$category_id]->id . $sefConfig->replacement : '') . $DMtree[$shMosConfig_locale][$category_id]->title;
} else {
do {
// all categories and subcategories. We don't really need id, as path
$title[] = ($sefConfig->shDMInsertCategoryId ? $DMtree[$shMosConfig_locale][$category_id]->id . $sefConfig->replacement : '') . $DMtree[$shMosConfig_locale][$category_id]->title;
// will always be unique
$category_id = $DMtree[$shMosConfig_locale][$category_id]->parent_id;
} while ($category_id != 0);
}
return array_reverse($title);
}
function vm_sef_get_category_title(&$db, &$catDesc, $category_id, $option, $shLangName)
{
global $shMosConfig_locale;
$sefConfig =& shRouter::shGetConfig();
if (empty($category_id)) {
return '';
}
$q = "SELECT c.category_name, c.category_id, c.category_description, x.category_parent_id FROM #__vm_category AS c";
$q .= "\n LEFT JOIN #__vm_category_xref AS x ON c.category_id = x.category_child_id;";
$db->setQuery($q);
if (!shTranslateUrl($option, $shLangName)) {
// V 1.2.4.m
$tree = $db->loadObjectList('category_id', false);
} else {
$tree = $db->loadObjectList('category_id');
}
$catDesc = $tree[$category_id]->category_description;
$title = '';
$securityCounter = 0;
do {
// all categories and subcategories
$securityCounter++;
$title .= ($sefConfig->shInsertCategoryId ? $tree[$category_id]->category_id . $sefConfig->replacement : '') . $tree[$category_id]->category_name . ' | ';
$category_id = $tree[$category_id]->category_parent_id;
} while ($category_id != 0 && $securityCounter < 10);
if ($securityCounter >= 10) {
JError::raiseError(500, 'Unable to create SEF url for Virtuemart: could not find category with id : ' . $category_id);
}
return JString::rtrim($title, ' | ');
}
function shFetchPostId($show, $option, $shLangName)
{
if (empty($show)) {
return null;
}
// get DB
$database =& JFactory::getDBO();
$sql = 'SELECT contentid from #__myblog_permalinks WHERE permalink = \'' . $show . '\'';
$database->setQuery($sql);
if (shTranslateUrl($option, $shLangName)) {
$postId = $database->loadResult();
} else {
$postId = $database->loadResult(false);
}
return isset($postId) ? $postId : '';
}
function shGetFileName($id, $option, $shLangName)
{
if (empty($id)) {
return null;
}
$sefConfig =& shRouter::shGetConfig();
// get DB
$database =& JFactory::getDBO();
$database->setQuery('SELECT id, filetitle, containerid FROM #__downloads_files WHERE id = ' . $database->Quote($id));
if (!shTranslateUrl($option, $shLangName)) {
$rows = $database->loadRow(false);
} else {
$rows = $database->loadRow();
}
$title = shGetContainerName($rows[2], $option, $shLangName);
if (count($title) > 1) {
array_pop($title);
}
// V w 27/08/2007 13:56:13 remove trailling slash
$title[] = ($sefConfig->shRemoInsertDocId ? $id . $sefConfig->replacement : '') . $rows[1];
return $title;
}
function dp_sef_get_category_array($category_id, $option, $shLangName)
{
global $shMosConfig_locale;
$sefConfig =& shRouter::shGetConfig();
// get DB
$db =& JFactory::getDBO();
static $tree = null;
// V 1.2.4.m $tree must an array based on current language
$title = array();
if (SH404SEF_DP_INSERT_ALL_CATEGORIES == 0) {
return $title;
}
if (empty($tree[$shMosConfig_lang])) {
// load up all cat details
$q = 'SELECT title, id, parent_id FROM #__dp_categories';
$q .= "\n WHERE published <> '0';";
// V x
$db->setQuery($q);
if (!shTranslateUrl($option, $shLangName)) {
// V 1.2.4.m
$tree[$shMosConfig_lang] = $db->loadObjectList('id', false);
} else {
$tree[$shMosConfig_lang] = $db->loadObjectList('id');
}
}
if (SH404SEF_DP_INSERT_ALL_CATEGORIES == 1) {
// only one category
$title[] = (SH404SEF_DP_INSERT_CAT_ID != 0 ? $tree[$shMosConfig_lang][$category_id]->id . $sefConfig->replacement : '') . $tree[$shMosConfig_lang][$category_id]->title;
} else {
do {
// all categories and subcategories.
$title[] = (SH404SEF_DP_INSERT_CAT_ID ? $tree[$shMosConfig_lang][$category_id]->id . $sefConfig->replacement : '') . $tree[$shMosConfig_lang][$category_id]->title;
// will always be unique
$category_id = $tree[$shMosConfig_lang][$category_id]->parent_id;
} while ($category_id != 0);
}
return array_reverse($title);
}
$title[] = $sh_LANG[$shLangIso]['_HP_SEF_SENDENQUIRY'];
$title[] = $row->company_name;
shRemoveFromGETVarsList('id');
// Sendenquiry does not use this ID to determine whether this is directed to company or agent, the form has a hidden field called 'sbj' to distinguish this.
break;
}
break;
# View Agent Email
# View Agent Email
case 'viewagentemail':
$agent_id = id;
$title[] = $sh_LANG[$shLangIso]['_HP_SEF_EMAIL'];
shRemoveFromGETVarsList('task');
if (is_numeric($agent_id)) {
$database->setQuery("SELECT a.id, a.name AS agent_name, c.id, c.name AS company_name FROM #__hp_agents AS a" . "\nLEFT JOIN #__hp_companies AS c ON a.company = c.id" . "\nWHERE a.id = " . $database->Quote($agent_id) . "\nLIMIT 1");
if (shTranslateUrl($option, $shLangName)) {
$row = $database->loadObject();
} else {
$row = $database->loadObject(false);
}
$title[] = $row->company_name;
$title[] = $row->agent_name;
$title[] = '/';
shRemoveFromGETVarsList('id');
} else {
$dosef = false;
}
break;
# Standard Search
# Standard Search
case 'search':
for ($ccnt = $first_url_cat; $ccnt <= $last_url_cat; $ccnt++) {
$title[] = $cat_titles[$ccnt];
}
/*print_r($title);
die($row->title);
exit;*/
}
// Add item title as URL segment
$row_title = $sefConfig->UseAlias ? $row->alias : $row->title;
$row_title .= $sefConfig->ContentTitleInsertArticleId ? "-" . $row->id : "";
$title[] = $row_title;
// V 1.2.4.j 2007/04/11 : numerical ID, on some categories only
if ($sefConfig->shInsertNumericalId && isset($sefConfig->shInsertNumericalIdCatList) && !empty($id) && $view == 'items' && !in_array($row->type_id, $globalnopath)) {
$q = 'SELECT id, catid, created FROM #__content WHERE id = ' . $database->Quote($id);
$database->setQuery($q);
if (shTranslateUrl($option, $shLangName) || !FLEXI_FISH) {
// V 1.2.4.m
$contentElement = $database->loadObject();
} else {
$contentElement = $database->loadObject(null, false);
}
if ($contentElement) {
$foundCat = array_search($contentElement->catid, $sefConfig->shInsertNumericalIdCatList);
if ($foundCat !== null && $foundCat !== false || $sefConfig->shInsertNumericalIdCatList[0] == '') {
// test both in case PHP < 4.2.0
$shTemp = explode(' ', $contentElement->created);
$title[] = str_replace('-', '', $shTemp[0]) . $contentElement->id;
}
}
}
shMustCreatePageId('set', true);
/**
* Returns a string with an article id, in accordance
* with various settings
* @param $id
* @param $view
* @param $option
* @param $shLangName
*/
function shGetArticleIdString($id, $view, $option, $shLangName)
{
$database =& JFactory::getDBO();
$sefConfig =& shRouter::shGetConfig();
// V 1.5.7 : article id, on some categories only
$articleId = '';
if ($sefConfig->ContentTitleInsertArticleId && isset($sefConfig->shInsertContentArticleIdCatList) && !empty($id) && $view == 'article') {
$q = 'SELECT id, catid FROM #__content WHERE id = ' . $id;
$database->setQuery($q);
if (shTranslateUrl($option, $shLangName)) {
// V 1.2.4.m
$contentElement = $database->loadObject();
} else {
$contentElement = $database->loadObject(false);
}
if ($contentElement) {
$foundCat = array_search($contentElement->catid, $sefConfig->shInsertContentArticleIdCatList);
if ($foundCat !== null && $foundCat !== false || $sefConfig->shInsertContentArticleIdCatList[0] == '') {
// test both in case PHP < 4.2.0
$articleId = $contentElement->id;
}
}
}
return $articleId;
}
function vmSefGetProductName($productId, $option, $shLangName, $shLangIso)
{
if (empty($productId)) {
return null;
}
global $sh_LANG;
$sefConfig =& shRouter::shGetConfig();
// get DB
$database =& JFactory::getDBO();
$q = "SELECT product_id, product_sku, product_name FROM #__vm_product";
// then try to add its name as well
$q .= "\n WHERE product_id = " . $database->Quote($productId);
$database->setQuery($q);
if (!shTranslateUrl($option, $shLangName)) {
$row = $database->loadObject(false);
} else {
$row = $database->loadObject();
}
if (empty($row)) {
// non name available
return $sh_LANG[$shLangIso]['_PHPSHOP_PRODUCT'] . $sefConfig->replacement . $product_id;
}
$shName = '';
if ($sefConfig->shInsertProductId) {
$shName .= $row->product_id;
}
if ($sefConfig->shVmUseProductSKU) {
$shName .= (empty($shName) ? '' : $sefConfig->replacement) . $row->product_sku;
}
if ($sefConfig->shVmInsertProductName) {
$shName .= (empty($shName) ? '' : $sefConfig->replacement) . $row->product_name;
}
if (empty($shName)) {
$shName = $row->product_name;
}
return $shName;
}
function shInitializePlugin($lang, &$shLangName, &$shLangIso, $option) {
$conf =& JFactory::getConfig();
$configDefaultLanguage = $conf->getValue('config.language');
$shLangName = empty($lang) ? Sh404sefFactory::getPageInfo()->shMosConfig_locale : shGetNameFromIsoCode( $lang);
$shLangIso = (shTranslateUrl($option, $shLangName)) ?
(isset($lang) ? $lang : shGetIsoCodeFromName( Sh404sefFactory::getPageInfo()->shMosConfig_locale))
: (isset($configDefaultLanguage) ? shGetIsoCodeFromName($configDefaultLanguage) : shGetIsoCodeFromName( Sh404sefFactory::getPageInfo()->shMosConfig_locale));
if (strpos($shLangIso, '_') !== false) {
//11/08/2007 14:30:16 mambo compat
$shTemp = explode( '_', $shLangIso);
$shLangIso = $shTemp[0];
}
// reset pageid creation : the plugin must turn it on by itself
shMustCreatePageId( 'set', false);
// added protection : do not SEF if component is not installed. Do not attempt to build SEF URL
// if component is not installed, or else plugin may try to read from comp DB tables. This will cause DB table names
// to be displayed
return !sh404SEF_CHECK_COMP_IS_INSTALLED
|| ( sh404SEF_CHECK_COMP_IS_INSTALLED &&
shFileExists(sh404SEF_ABS_PATH.'components/'.$option.'/'.str_replace('com_', '',$option).'.php'));
}
function shGetJSVideoTitle($id, $option, $shLangName)
{
$sefConfig =& Sh404sefFactory::getConfig();
$database =& JFactory::getDBO();
$query = 'SELECT id, title, category_id FROM #__community_videos WHERE id = ' . $database->Quote($id);
$database->setQuery($query);
if (!shTranslateUrl($option, $shLangName)) {
$result = $database->loadObject(false);
} else {
$result = $database->loadObject();
}
$videoName = ($sefConfig->shJSInsertVideoId ? $id . $sefConfig->replacement : '') . $result->title;
// optionnally insert video category
if ($sefConfig->shJSInsertVideoCat) {
$title = array(shGetJSVideoCategoryTitle($result->category_id, $option, $shLangName), $videoName);
} else {
$title = array($videoName);
}
return $title;
}
function shKUTopicName($topicid, $option, $shLangIso, $shLangName)
{
static $topics = array();
$sefConfig =& shRouter::shGetConfig();
if (empty($topicid) || !$sefConfig->shFbInsertMessageSubject) {
return '';
}
if (class_exists('KunenaForum')) {
// Kunena 2.0 support
$topic = KunenaForumTopic::getInstance($topicid);
$topicsubject = $topic->subject;
} elseif (class_exists('KunenaRouter')) {
// Kunena 1.6 support
if (empty(KunenaRouter::$msgidcache[$topicid])) {
$database =& JFactory::getDBO();
$query = 'SELECT subject, id FROM #__kunena_messages WHERE id=' . (int) $topicid;
$database->setQuery($query);
KunenaRouter::$msgidcache[$topicid] = $database->loadResult();
}
$topicsubject = KunenaRouter::$msgidcache[$topicid];
} else {
// Kunena 1.0 / 1.5 support
if (empty($topics[$topicid])) {
$database =& JFactory::getDBO();
$query = 'SELECT id, subject FROM #__fb_messages WHERE id = ' . (int) $topicid;
$database->setQuery($query);
if (!shTranslateUrl($option, $shLangName)) {
$topicDetails = $database->loadObject(false);
} else {
$topicDetails = $database->loadObject();
}
$topics[$topicid] = empty($topicDetails) ? '' : $topicDetails->subject;
}
$topicsubject = $topics[$topicid];
}
// we have a user name
$topicstring = empty($topicsubject) ? 't' . $sefConfig->replacement . $topicid : ($sefConfig->shFbInsertMessageId ? $topicid . $sefConfig->replacement : '');
// if name, put ID only if requested
$topicstring = $topicstring . (empty($topicsubject) ? '' : $topicsubject);
return $topicstring;
}
function shKUTopicName($topicid, $option, $shLangIso, $shLangName)
{
static $topics = array();
$sefConfig =& shRouter::shGetConfig();
if (empty($topicid) || !$sefConfig->shFbInsertMessageSubject) {
return '';
}
if (empty($topics[$topicid])) {
$database =& JFactory::getDBO();
$query = "SELECT id, subject FROM #__fb_messages where id = " . $database->Quote($topicid);
$database->setQuery($query);
if (!shTranslateUrl($option, $shLangName)) {
$topicDetails = $database->loadObject(false);
} else {
$topicDetails = $database->loadObject();
}
if (!empty($topicDetails)) {
$topics[$topicid] = $topicDetails->subject;
}
}
// we have a user name
$topicstring = empty($topics[$topicid]) ? 't' . $sefConfig->replacement . $topicid : ($sefConfig->shFbInsertMessageId ? $topicid . $sefConfig->replacement : '');
// if name, put ID only if requested
$topicstring = $topicstring . (empty($topics[$topicid]) ? '' : $topics[$topicid]);
return $topicstring;
}
$dosef = false;
}
break;
default:
if (sh404SEF_PDF_DIR && $view == 'article' && !empty($format) && $format == 'pdf') {
$title[] = sh404SEF_PDF_DIR; // insert pdf directory
shMustCreatePageId( 'set', true);
}
// V 1.2.4.j 2007/04/11 : numerical ID, on some categories only
if ($sefConfig->shInsertNumericalId && isset($sefConfig->shInsertNumericalIdCatList)
&& !empty($id) && ($view == 'article')) {
$q = 'SELECT id, catid, created FROM #__content WHERE id = '.$database->Quote( $id);
$database->setQuery($q);
if (shTranslateUrl($option, $shLangName)) // V 1.2.4.m
$contentElement = $database->loadObject( );
else $contentElement = $database->loadObject( false);
if ($contentElement) {
$foundCat = array_search($contentElement->catid, $sefConfig->shInsertNumericalIdCatList);
if (($foundCat !== null && $foundCat !== false)
|| ($sefConfig->shInsertNumericalIdCatList[0] == '')) { // test both in case PHP < 4.2.0
$shTemp = explode(' ', $contentElement->created);
$title[] = str_replace('-','', $shTemp[0]).$contentElement->id;
}
}
}
// use libray function to fetch Joomla content title
if ($task == 'article.edit') {
if (empty($a_id)) { // submit new article
