Get("Link_View"); $Links_AllValue = 127; if(!is_numeric($LinkView)) { $LinkView = 127; } $Link_SortField = $objConfig->Get('Link_SortField'); if( !strlen($Link_SortField) ) $Link_SortField = 'Priority'; $Link_SortOrder = $objConfig->Get('Link_SortOrder'); if( !strlen($Link_SortOrder) ) $Link_SortOrder = 'desc'; $Perpage_Links = (int)$objConfig->Get("Perpage_Links"); if(!$Perpage_Links) $Perpage_Links="'all'"; if($LinkView == $Links_AllValue) { $Link_ShowAll = 1; $Link_Filter = ""; } else { $Status = array(); $Mod = array(); if($LinkView & $Bit_Pending) $Status[] = STATUS_PENDING; if($LinkView & $Bit_Active) $Status[] = STATUS_ACTIVE; if($LinkView & $Bit_Disabled) $Status[] = STATUS_DISABLED; if(count($Status)) { $LinkFilter .= " AND (Status IN (".implode(",",$Status).") "; } else $LinkFilter .= " AND ((Status=-1) "; if($LinkView & $Bit_Ed) { $LinkFilter .= " OR (EditorsPick=1) "; } if($LinkView & $Bit_New) { $cutoff = adodb_date("U") - ($objConfig->Get("Link_NewDays") * 86400); $LinkFilter .= " OR (CreatedOn > ".$cutoff.") "; } if($LinkView & $Bit_Pop) { //$cutoff = GetLinkPopValue(); if($cutoff>0) $LinkFilter .= " OR (CachedRating >= ".$cutoff.") "; } if($LinkView & $Bit_Hot) { //$cutoff = GetLinkHotValue(); if($cutoff>0) $LinkFilter .= " OR (Hits >= ".$cutoff.") "; } $LinkFilter .= ")"; } $list = $objSession->GetVariable("SearchWord"); $LinkSearch = (strlen($list)>0 && $SearchType =="Links" || $SearchType="all") || (strlen($list)==0); $objLinkList->Clear(); $objLinkList->EnablePaging=TRUE; $LinkSearch = $LinkSearch && ($objSession->HasCatPermission("LINK.VIEW")); $lt = $objLinkList->SourceTable; $catjoin = GetTablePrefix()."CategoryItems"; $cattable = $objCatList->SourceTable; $order = trim($objConfig->Get("Link_SortField")." ".$objConfig->Get("Link_SortOrder")); if(strlen($order)) $order = "ORDER BY $order"; $sql = "SELECT * FROM $lt "; $sql .= "INNER JOIN $catjoin ON ($lt.ResourceId=$catjoin.ItemResourceId) "; if($LinkSearch) { if(strlen($list)==0) { $where = "WHERE CategoryId=".$objCatList->CurrentCategoryID().$LinkFilter; } else { $SearchQuery = $objLinkList->AdminSearchWhereClause($list); if(strlen($SearchQuery)) { $SearchQuery = " (".$SearchQuery.")"; if(strlen($CatScopeClause)) $SearchQuery .= " AND ".$CatScopeClause; $where = ' AND '.$SearchQuery.$LinkFilter; } else $where = "WHERE CategoryId=".$objCatList->CurrentCategoryID().$LinkFilter; } $sql .= $where." ".$order; $objLinkList->Query_Item($sql); $objLinkList->QueryItemCount = TableCount($objLinkList->SourceTable," CategoryId=".$objCatList->CurrentCategoryID().$LinkFilter,TRUE); $CatTotal = TableCount($objLinkList->SourceTable," CategoryId=".$objCatList->CurrentCategoryID(),TRUE); $caption = language("la_ItemTab_Links"); $ItemTabs->AddTab(language("la_ItemTab_Links"),"links",$objLinkList->QueryItemCount, $m_tab_Links_hide,$CatTotal); } $lang_URL = language("la_prompt_URL"); $lang_Links = language("la_Text_Links"); $lang_Reviews = language("la_Text_Reviews"); print << var Link_SortField = '$Link_SortField'; var Link_SortOrder = '$Link_SortOrder'; var Links_Perpage = $Perpage_Links; var LinkView = $LinkView; var LinkTitle = '$caption'; var lang_URL = "$lang_URL"; var lang_Links = "$lang_Links"; var lang_Reviews = "$lang_Reviews"; var Links_Paste = false; function Links_SortMenu() { sub_menu_sorting_sub = new Menu(LinkTitle); sub_menu_sorting_sub.addMenuItem(lang_Asc,"config_val('Link_SortOrder','asc');",RadioIsSelected(Link_SortOrder,'asc')); sub_menu_sorting_sub.addMenuItem(lang_Desc,"config_val('Link_SortOrder','desc');",RadioIsSelected(Link_SortOrder,'desc')); sub_menu_sorting_sub.addMenuSeparator(); sub_menu_sorting_sub.addMenuItem(lang_Default,"config_val('Link_SortField','Name');",""); sub_menu_sorting_sub.addMenuItem(lang_Name,"config_val('Link_SortField','Name');",RadioIsSelected(Link_SortField,'Name')); sub_menu_sorting_sub.addMenuItem(lang_URL,"config_val('Link_SortField','Url');",RadioIsSelected(Link_SortField,'Url')); sub_menu_sorting_sub.addMenuItem(lang_CreatedOn,"config_val('Link_SortField','CreatedOn');",RadioIsSelected(Link_SortField,'CreatedOn')); sub_menu_sorting_sub.addMenuItem(lang_Reviews,"config_val('Link_SortField','CachedReviewsQty');",RadioIsSelected(Link_SortField,'CachedReviewsQty')); sub_menu_sorting_sub.addMenuItem(lang_Rating,"config_val('Link_SortField','CachedRating');",RadioIsSelected(Link_SortField,'CachedRating')); sub_menu_sorting_sub.addMenuItem(lang_Votes,"config_val('Link_SortField','CachedVotesQty');",RadioIsSelected(Link_SortField,'CachedVotesQty')); sub_menu_sorting_sub.addMenuItem(lang_Hits,"config_val('Link_SortField','CachedHits');",RadioIsSelected(Link_SortField,'CachedHits')); return sub_menu_sorting_sub; } function Links_FilterMenu() { menu_filter = new Menu(LinkTitle); menu_filter.addMenuItem(lang_All,"config_val('Link_View', $Links_AllValue);",LinkView==$Links_AllValue); menu_filter.addMenuItem(lang_None,"config_val('Link_View', 0);",LinkView==0); menu_filter.addMenuSeparator(); menu_filter.addMenuItem(lang_Active,"FlipBit('Link_View',LinkView,6);",BitStatus(LinkView,6)); menu_filter.addMenuItem(lang_Pending,"FlipBit('Link_View',LinkView,5);", BitStatus(LinkView,5)); menu_filter.addMenuItem(lang_Disabled,"FlipBit('Link_View',LinkView,4);",BitStatus(LinkView,4)); menu_filter.addMenuSeparator(); menu_filter.addMenuItem(lang_New,"FlipBit('Link_View',LinkView,3);",BitStatus(LinkView,3)); menu_filter.addMenuItem(lang_Pop,"FlipBit('Link_View',LinkView,1);",BitStatus(LinkView,1)); menu_filter.addMenuItem(lang_Hot,"FlipBit('Link_View',LinkView,2);",BitStatus(LinkView,2)); menu_filter.addMenuItem(lang_EdPick,"FlipBit('Link_View',LinkView,0);",BitStatus(LinkView,0)); return menu_filter; } function Links_SelectMenu() { menu_select = new Menu(LinkTitle); menu_select.addMenuItem(lang_All,"javascript:selectAll('"+activeTab.id+"');",""); menu_select.addMenuItem(lang_Unselect,"javascript:unselectAll('"+activeTab.id+"');",""); menu_select.addMenuItem(lang_Invert,"javascript:invert('"+activeTab.id+"');",""); return menu_select; } function Links_PerPageMenu() { caption = lang_Links +" "+lang_PerPage; menu_results = new Menu(caption); menu_results.addMenuItem("10","config_val('Perpage_Links', '10');",RadioIsSelected(Links_Perpage,10)); menu_results.addMenuItem("20","config_val('Perpage_Links', '20');",RadioIsSelected(Links_Perpage,20)); menu_results.addMenuItem("50","config_val('Perpage_Links', '50');",RadioIsSelected(Links_Perpage,50)); menu_results.addMenuItem("100","config_val('Perpage_Links', '100');",RadioIsSelected(Links_Perpage,100)); menu_results.addMenuItem("500","config_val('Perpage_Links', '500');",RadioIsSelected(Links_Perpage,500)); return menu_results; } END; ?>