-INSERT INTO ImportScripts VALUES (DEFAULT, 'Links from CSV file [In-Link]', '', 'l', 'In-Link', '', 'CSV', '1');
-
-UPDATE CustomField
-SET ValueList = '=+||<SQL>SELECT DestAbbr AS OptionValue, DestName AS OptionName FROM <PREFIX>StdDestinations WHERE DestType = 2 AND (DestParentId = 225 OR DestParentId = 38) ORDER BY DestParentId DESC, DestAbbr ASC</SQL>'
-WHERE FieldName = 'LinkState';
-
-UPDATE CustomField
-SET ValueList = '=+||<SQL>SELECT DestAbbr AS OptionValue, DestName AS OptionName FROM <PREFIX>StdDestinations WHERE DestType = 1 ORDER BY DestAbbr ASC</SQL>'
-WHERE FieldName = 'LinkCountry';
-
-# ===== v 5.0.0 =====
-INSERT INTO Counters VALUES (DEFAULT, 'linkhits_count', 'SELECT ROUND(SUM(Hits)) FROM <%PREFIX%>Link', NULL, NULL, '300', '0', '|Link|');
-UPDATE Category SET Template = '/in-link/designs/section' WHERE Template = 'inlink/index';
-UPDATE Category SET CachedTemplate = '/in-link/designs/section' WHERE CachedTemplate = 'inlink/index';
-
-UPDATE ConfigurationValues SET VariableValue = '/in-link/designs/section' WHERE VariableName = 'l_CategoryTemplate';
-UPDATE ConfigurationValues SET VariableValue = 'in-link/designs/detail' WHERE VariableName = 'l_ItemTemplate';
-
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:links.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:setting_folder.view', 11, 1, 1, 0);
-DELETE FROM Permissions WHERE Permission LIKE 'in-link:inlink_general.%';
-
-UPDATE Events SET Description = 'la_event_link.owner.modify' WHERE Description = 'la_event_link.modify.modify';
-UPDATE Events SET Description = 'la_event_link.owner.modify.pending' WHERE Description = 'la_event_link.modify.modify.pending';
-
-UPDATE Phrase SET Module = 'In-Link' WHERE ((Phrase LIKE '%Links%' OR Phrase LIKE '%Listing%') AND (Module = 'Core') AND Phrase NOT IN ('la_section_QuickLinks'));
-
-UPDATE Phrase SET Module = 'In-Link', PhraseType = 1 WHERE ( (Phrase LIKE '%Validation%' OR Phrase LIKE 'la_title_In-Link') AND (Module = 'Core') AND Phrase NOT IN ('la_ValidationEmail', 'la_prompt_validation'));
Property changes on: branches/RC/in-link/install/upgrades.sql
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_opt_CreatedOn,Hits=la_Link_Hits,CachedRating=la_opt_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.01, 1, 1);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField2', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.02, 1, 1);
-INSERT INTO CustomField VALUES (DEFAULT, 4, 'LinkState', 'lu_fld_LinkState', 0, 'la_section_BusinessLocation', 'la_fld_LinkState', 'select', '=+||<SQL>SELECT DestAbbr AS OptionValue, DestName AS OptionName FROM <PREFIX>StdDestinations WHERE DestType = 2 AND (DestParentId = 225 OR DestParentId = 38) ORDER BY DestParentId DESC, DestAbbr ASC</SQL>', '', 3, 1, 0, 0);
-INSERT INTO CustomField VALUES (DEFAULT, 4, 'LinkCountry', 'lu_fld_LinkCountry', 0, 'la_section_BusinessLocation', 'la_fld_LinkCountry', 'select', '=+||<SQL>SELECT DestAbbr AS OptionValue, DestName AS OptionName FROM <PREFIX>StdDestinations WHERE DestType = 1 ORDER BY DestAbbr ASC</SQL>', '', 5, 1, 0, 0);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1', NULL, 'la_prompt_ActiveLinks', 0, 1);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link', NULL, 'la_prompt_TotalLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1', NULL, 'la_prompt_ActiveLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2', NULL, 'la_prompt_PendingLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0', NULL, 'la_prompt_DisabledLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS NewLinks FROM <%prefix%>Link WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Link_NewDays"%>*86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS HotLinks FROM <%prefix%>Link WHERE (HotItem = 1) OR (Hits >= <%m:config name="Link_MaxHotNumber"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS PopularLinks FROM <%prefix%>Link WHERE (PopItem = 1) OR ( (CachedRating >= <%link:hit_count type="top"%>) AND <%link:hit_count type="top"%> AND (PopItem = 2) )', NULL, 'la_prompt_PopularLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Link WHERE CachedRating > 0', NULL, 'la_prompt_LinksAverageRating', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksHits', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksVotes', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_NewestLinkDate', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_LastLinkUpdate', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);
-
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 14, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 14, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'FAVORITES', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD.PENDING', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'FAVORITES', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.DELETE', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.ADD', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.DELETE', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.MODIFY', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'FAVORITES', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.MODIFY', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.DELETE', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD.PENDING', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.MODIFY', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.DELETE', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW.PENDING', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.MODIFY.PENDING', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.DELETE', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:links.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:setting_folder.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_output.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_output.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_search.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_search.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_email.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_email.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.add', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.delete', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.add', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.delete', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:validation_list.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:validation_list.add', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:validation_list.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.add', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.delete', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.advanced:approve', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.advanced:decline', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.add', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.delete', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:link_validation.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:link_validation.advanced:continue', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:link_validation.advanced:restart', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:link_validation.advanced:validate', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:link_validation.advanced:reset', 11, 1, 1, 0);
-
-INSERT INTO ImportScripts VALUES (DEFAULT, 'Links from CSV file [In-Link]', '', 'l', 'In-Link', '', 'CSV', '1');
- Grids['<inp2:m_param name="prefix"/>'].SetDependantToolbarButtons( new Array('edit','delete','approve','decline','sep3','cut','copy','move_up','move_down','sep6'));
- 'ListingTypeId' => Array('type' => 'int','formatter'=>'kOptionsFormatter', 'options_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'ListingTypes ORDER BY Name', 'option_key_field'=>'ListingTypeId', 'option_title_field'=>'Name'),
- 'ItemResourceId' => Array('type' => 'int','formatter'=>'kLEFTFormatter','left_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'Link WHERE `%s` = \'%s\'','left_key_field'=>'ResourceId','left_title_field'=>'CONCAT(Name," (",Url,")")','required'=>1,'unique'=>Array('ItemResourceId')),
- 'ListingTypeId' => Array('type' => 'int','formatter'=>'kOptionsFormatter', 'options_sql'=>'SELECT %s FROM '.TABLE_PREFIX.'ListingTypes ORDER BY Name', 'option_key_field'=>'ListingTypeId', 'option_title_field'=>'Name'),
- Grids['<inp2:m_param name="prefix"/>'].SetDependantToolbarButtons( new Array('edit','delete','approve','decline','sep3','cut','copy','move_up','move_down','sep6'));
- Grids['<inp2:m_param name="prefix"/>'].SetDependantToolbarButtons( new Array('edit','delete','approve','decline','sep3','cut','copy','move_up','move_down','sep6'));
- Grids['<inp2:m_param name="prefix"/>'].SetDependantToolbarButtons( new Array('edit','delete','approve','decline','sep3','cut','copy','move_up','move_down','sep6'));
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 0,1)
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField2', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 3,1)
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1', NULL, 'la_prompt_ActiveLinks', 0, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link', NULL, 'la_prompt_TotalLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1', NULL, 'la_prompt_ActiveLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2', NULL, 'la_prompt_PendingLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0', NULL, 'la_prompt_DisabledLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS NewLinks FROM <%prefix%>Link WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Link_NewDays"%>*86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS HotLinks FROM <%prefix%>Link WHERE (HotItem = 1) OR (Hits >= <%m:config name="Link_VotesToHot"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PopularLinks FROM <%prefix%>Link WHERE (PopItem = 1) OR ( (CachedRating >= <%link:hit_count type="top"%>) AND <%link:hit_count type="top"%> AND (PopItem = 2) )', NULL, 'la_prompt_PopularLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Link WHERE CachedRating > 0', NULL, 'la_prompt_LinksAverageRating', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksHits', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksVotes', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_NewestLinkDate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_LastLinkUpdate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT FieldLabel as OptionName, FieldName as OptionValue FROM <PREFIX>CustomField WHERE Type=4</SQL>', 0,1)
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField2', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT FieldLabel as OptionName, FieldName as OptionValue FROM <PREFIX>CustomField WHERE Type=4</SQL>', 3,1)
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1', NULL, 'la_prompt_ActiveLinks', 0, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link', NULL, 'la_prompt_TotalLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1', NULL, 'la_prompt_ActiveLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2', NULL, 'la_prompt_PendingLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0', NULL, 'la_prompt_DisabledLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS NewLinks FROM <%prefix%>Link WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Link_NewDays"%>*86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS HotLinks FROM <%prefix%>Link WHERE (HotItem = 1) OR (Hits >= <%m:config name="Link_VotesToHot"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PopularLinks FROM <%prefix%>Link WHERE (PopItem = 1) OR ( (CachedRating >= <%link:hit_count type="top"%>) AND <%link:hit_count type="top"%> AND (PopItem = 2) )', NULL, 'la_prompt_PopularLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Link WHERE CachedRating > 0', NULL, 'la_prompt_LinksAverageRating', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksHits', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksVotes', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_NewestLinkDate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_LastLinkUpdate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);
- $o = $objLinkList->QueryItemCount; // only use when no highlighting issued
- }
- else
- {
- $o = $objLinkList->PerformItemCount($attribs);
- }
-
- if ($o == '') {
- $o = 0;
- }
- return $o;
-}
-
-
-/*
- @description: Used in conjuction with l_list_links. This function generates the page navigation
- for the list. If this tag is called before the list tag, this function will load
- the links. For that reason, the _ListType attribute is required if the pagnav
- tag preceeds the l_list_links tag in the template. Generally, it is good practice to
- duplicate all attributes set for l_list_links.
- @attrib: _PagesToList:int: Number of pages to list (default is 10)
- @attrib: _ShortList:bool: If set, uses the shortlist configuration value for links
- @attrib: _label:lang: language tag to include in the output if there are pages to list. If there are no pages listed, this text will not be included (resulting in an empty output)
- @attrib: _ListType::Determines the type of list to generate<br>
- Possible values:<UL>
- <LI>Category: List links from the current category (default)
- <LI>Hot: Hot Links (Most Popular & highest rated links)
- <LI>Pop: Most Popular links
- <LI>New: List new links
- <LI>Hot: List links with the most click-throughs
- <LI>Pick: List editor's picks
- <LI>myitems: List topics created by the current user
- <LI>favorites: List topics marked as favorites by the current user
- <LI>search: List search results
- </UL>
-
-*/
-function l_link_pagenav($attribs = array())
-{
- global $objLinkList, $objCatList, $objSession, $objConfig;
- $rs=$db->Execute('SELECT '.$objCatList->TitleField.', CategoryId FROM '.$objCatList->SourceTable.' WHERE ParentId = '.$suggest_cat_id.' AND Status = 1');
- $o = $objLinkList->QueryItemCount; // only use when no highlighting issued
- }
- else
- {
- $o = $objLinkList->PerformItemCount($attribs);
- }
-
- if ($o == '') {
- $o = 0;
- }
- return $o;
-}
-
-
-/*
- @description: Used in conjuction with l_list_links. This function generates the page navigation
- for the list. If this tag is called before the list tag, this function will load
- the links. For that reason, the _ListType attribute is required if the pagnav
- tag preceeds the l_list_links tag in the template. Generally, it is good practice to
- duplicate all attributes set for l_list_links.
- @attrib: _PagesToList:int: Number of pages to list (default is 10)
- @attrib: _ShortList:bool: If set, uses the shortlist configuration value for links
- @attrib: _label:lang: language tag to include in the output if there are pages to list. If there are no pages listed, this text will not be included (resulting in an empty output)
- @attrib: _ListType::Determines the type of list to generate<br>
- Possible values:<UL>
- <LI>Category: List links from the current category (default)
- <LI>Hot: Hot Links (Most Popular & highest rated links)
- <LI>Pop: Most Popular links
- <LI>New: List new links
- <LI>Hot: List links with the most click-throughs
- <LI>Pick: List editor's picks
- <LI>myitems: List topics created by the current user
- <LI>favorites: List topics marked as favorites by the current user
- <LI>search: List search results
- </UL>
-
-*/
-function l_link_pagenav($attribs = array())
-{
- global $objLinkList, $objCatList, $objSession, $objConfig;
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.01, 1, 1);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField2', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.02, 1, 1);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1', NULL, 'la_prompt_ActiveLinks', 0, 1);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link', NULL, 'la_prompt_TotalLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1', NULL, 'la_prompt_ActiveLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2', NULL, 'la_prompt_PendingLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0', NULL, 'la_prompt_DisabledLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS NewLinks FROM <%prefix%>Link WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Link_NewDays"%>*86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS HotLinks FROM <%prefix%>Link WHERE (HotItem = 1) OR (Hits >= <%m:config name="Link_MaxHotNumber"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) AS PopularLinks FROM <%prefix%>Link WHERE (PopItem = 1) OR ( (CachedRating >= <%link:hit_count type="top"%>) AND <%link:hit_count type="top"%> AND (PopItem = 2) )', NULL, 'la_prompt_PopularLinks', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Link WHERE CachedRating > 0', NULL, 'la_prompt_LinksAverageRating', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksHits', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksVotes', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_NewestLinkDate', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_LastLinkUpdate', 0, 2);
-INSERT INTO StatItem VALUES (DEFAULT, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);
-
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 14, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 14, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'FAVORITES', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD.PENDING', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 12, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'FAVORITES', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.DELETE', 13, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.VIEW', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.ADD', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.DELETE', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'CATEGORY.MODIFY', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'FAVORITES', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.MODIFY', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.DELETE', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 11, 1, 0, {LinkCatId});
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.VIEW', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.ADD.PENDING', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.MODIFY', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.DELETE', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.RATE', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.REVIEW.PENDING', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.MODIFY.PENDING', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.MODIFY.PENDING', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'LINK.OWNER.DELETE', 15, 0, 0, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:inlink_general.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:inlink_general.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_output.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_output.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_search.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_search.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_email.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_email.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.add', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:configuration_custom.delete', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.add', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:duplicate_checker.delete', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:validation_list.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:validation_list.add', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:validation_list.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.add', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.delete', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.advanced:approve', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:paid_listings.advanced:decline', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.view', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.add', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.edit', 11, 1, 1, 0);
-INSERT INTO Permissions VALUES (DEFAULT, 'in-link:listing_types.delete', 11, 1, 1, 0);
- $o = $objLinkList->QueryItemCount; // only use when no highlighting issued
- }
- else
- {
- $o = $objLinkList->PerformItemCount($attribs);
- }
-
- if ($o == '') {
- $o = 0;
- }
- return $o;
-}
-
-
-/*
- @description: Used in conjuction with l_list_links. This function generates the page navigation
- for the list. If this tag is called before the list tag, this function will load
- the links. For that reason, the _ListType attribute is required if the pagnav
- tag preceeds the l_list_links tag in the template. Generally, it is good practice to
- duplicate all attributes set for l_list_links.
- @attrib: _PagesToList:int: Number of pages to list (default is 10)
- @attrib: _ShortList:bool: If set, uses the shortlist configuration value for links
- @attrib: _label:lang: language tag to include in the output if there are pages to list. If there are no pages listed, this text will not be included (resulting in an empty output)
- @attrib: _ListType::Determines the type of list to generate<br>
- Possible values:<UL>
- <LI>Category: List links from the current category (default)
- <LI>Hot: Hot Links (Most Popular & highest rated links)
- <LI>Pop: Most Popular links
- <LI>New: List new links
- <LI>Hot: List links with the most click-throughs
- <LI>Pick: List editor's picks
- <LI>myitems: List topics created by the current user
- <LI>favorites: List topics marked as favorites by the current user
- <LI>search: List search results
- </UL>
-
-*/
-function l_link_pagenav($attribs = array())
-{
- global $objLinkList, $objCatList, $objSession, $objConfig;
- @description:Returns number of votes for item rating
-*/
-/*
- @field:link.cat_link
- @description:Returns a URL setting the link to the current link and the link's category to the current category
- @attrib:_template:tpl:Template URL should point to
-*/
-/*
- @field:link.link
- @description:Returns a URL setting the link to the current link
- @attrib:_template:tpl:Template URL should point to
-*/
-/*
- @field:link.rating
- @description:Displays the links rating
- @attrib:_displaymode:: How the rating should be displayed<br>
- <UL>
- <LI>"Numerical": Show the decimal value
- <LI>"Text": Show the text version
- <LI>"Graphical":Show images representing the rating
- </UL>
- @attrib:_onimage::on image tick shown in graphical display mode
- @attrib:_offimage::off image tick shown in graphical display mode
- @attrib:_separator::In graphical display mode, this html is placed between each tick image
-*/
-/*
- @field:link.reviews
- @description:Return the number of reviews for think link
- @attrib:_today:bool:Count reviews added today only
-*/
-/*
- @field:link.new
- @description:returns text if link's status is "new"
- @attrib:_label:lang: Text to return if status is new
-*/
-/*
- @field:link.pop
- @description:returns text if link's status is "popular"
- @attrib:_label:lang: Text to return if status is popular
-*/
-/*
- @field:link.hot
- @description:returns text if link's status is "hot"
- @attrib:_label:lang: Text to return if status is "hot"
-*/
-/*
- @field:link.pick
- @description:returns text if link's status is "hot"
- @attrib:_label:lang: Text to return if status is "hot"
-*/
-/*
- @field:link.custom
- @description:Returns a custom field
- @attrib:_customfield::field name to return
- @attrib:_default::default value
- @attrib:_listvalue::default value
-*/
-/*
- @field:link.category
- @description:Return a category field from the link's category
- @attrib:_cattag::Category field to parse
-*/
-/*
- @field:link.fullpath
- @description:The full category path of the item
-*/
-/*
- @field:link.relevance
- @description:Displays the link relevance in search results
- @attrib:_displaymode:: How the relevance should be displayed<br>
- <UL>
- <LI>"Numerical": Show the decimal value
- <LI>"Bar": Show the HTML representing the relevance. Returns two HTML cells ≶td< with specified background colors
- <LI>"Graphical":Show image representing the relevance
- </UL>
- @attrib:_onimage::Zero relevance image shown in graphical display mode. Also used as prefix to build other images (i.e. prefix+"_"+percentage+".file_extension"
- @attrib:_OffBackGroundColor::Off background color of HTML cell in bar display mode
- @attrib:_OnBackGroundColor::On background color of HTML cell in bar display mode
-
-*/
- break;
-
- default:
- unset($ret);
- break;
- }
-
- if(!isset($ret) || !strlen($ret) )
- {
- $ret = parent::ParseObject($element);
- }
- }
- else
- $ret= "Undefined";
- return $ret;
- }
-
- function parsetag($tag)
- {
- global $objConfig,$mytempdata, $rootURL, $var_list, $var_list_update, $l_var_list_update;
- WHERE (CreatedById = '.$objSession->Get('PortalUserId').') AND (OrgId > 0)';
-
- $pending_modified = Array();
- $original_links = Array();
- $db =& GetADODBConnection();
- $rs = $db->Execute($sql);
- while (!$rs->EOF) {
- $pending_modified[] = $rs->fields['LinkId'];
- $original_links[] = $rs->fields['OrgId'];
- $rs->MoveNext();
- }
-
- $TableName = $this->SourceTable;
- if ($pending_modified && $original_links) {
- $where = " (".$TableName.".Status > -1 OR LinkId IN (".implode(',', $pending_modified).") ) AND (LinkId NOT IN (".implode(',', $original_links).")) AND ".$TableName.".CreatedById=".$objSession->Get("PortalUserId");
- }
- else {
- $where = " (".$TableName.".Status > -1) AND ".$TableName.".CreatedById=".$objSession->Get("PortalUserId");
- function Query_Link($whereClause,$orderByClause=NULL,$JoinCats=TRUE)
- {
- global $objSession, $Errors;
-
- if($JoinCats)
- {
- $cattable = GetTablePrefix()."CategoryItems";
- $t = $this->SourceTable;
- $CategoryTable = GetTablePrefix()."Category";
- $sql = "SELECT ".$this->SourceTable.".*,$CategoryTable.CategoryId as CategoryId,CachedNavBar FROM $t INNER JOIN $cattable ON $cattable.ItemResourceId=$t.ResourceId ";
- $sql .= "INNER JOIN $CategoryTable ON ($CategoryTable.CategoryId=$cattable.CategoryId)";
- }
- else
- $sql = "SELECT * FROM ". $this->SourceTable;
- if(trim($whereClause)!="")
- {
- if(isset($whereClause))
- $sql = sprintf('%s WHERE %s',$sql,$whereClause);
- }
- if (trim($orderByClause)!="")
- {
- if(isset($orderByClause))
- $sql = sprintf('%s ORDER BY %s',$sql,$orderByClause);
- $sql = "SELECT CreatedOn FROM ".GetTablePrefix()."Link INNER JOIN ".GetTablePrefix()."CategoryItems AS cat ON (".GetTablePrefix()."Link.ResourceId = cat.ItemResourceId) WHERE cat.CategoryId=$CategoryId AND CreatedOn>=$cutoffdate ORDER BY CreatedOn DESC ";
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.01, 1, 1);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField2', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.02, 1, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1', NULL, 'la_prompt_ActiveLinks', 0, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link', NULL, 'la_prompt_TotalLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1', NULL, 'la_prompt_ActiveLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2', NULL, 'la_prompt_PendingLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0', NULL, 'la_prompt_DisabledLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS NewLinks FROM <%prefix%>Link WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Link_NewDays"%>*86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS HotLinks FROM <%prefix%>Link WHERE (HotItem = 1) OR (Hits >= <%m:config name="Link_MaxHotNumber"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PopularLinks FROM <%prefix%>Link WHERE (PopItem = 1) OR ( (CachedRating >= <%link:hit_count type="top"%>) AND <%link:hit_count type="top"%> AND (PopItem = 2) )', NULL, 'la_prompt_PopularLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Link WHERE CachedRating > 0', NULL, 'la_prompt_LinksAverageRating', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksHits', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksVotes', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_NewestLinkDate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_LastLinkUpdate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.01, 1, 1);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField2', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.02, 1, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1', NULL, 'la_prompt_ActiveLinks', 0, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link', NULL, 'la_prompt_TotalLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1', NULL, 'la_prompt_ActiveLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2', NULL, 'la_prompt_PendingLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0', NULL, 'la_prompt_DisabledLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS NewLinks FROM <%prefix%>Link WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Link_NewDays"%>*86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS HotLinks FROM <%prefix%>Link WHERE (HotItem = 1) OR (Hits >= <%m:config name="Link_MaxHotNumber"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PopularLinks FROM <%prefix%>Link WHERE (PopItem = 1) OR ( (CachedRating >= <%link:hit_count type="top"%>) AND <%link:hit_count type="top"%> AND (PopItem = 2) )', NULL, 'la_prompt_PopularLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Link WHERE CachedRating > 0', NULL, 'la_prompt_LinksAverageRating', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksHits', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksVotes', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_NewestLinkDate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_LastLinkUpdate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.01, 1, 1);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField2', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.02, 1, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1', NULL, 'la_prompt_ActiveLinks', 0, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link', NULL, 'la_prompt_TotalLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1', NULL, 'la_prompt_ActiveLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2', NULL, 'la_prompt_PendingLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0', NULL, 'la_prompt_DisabledLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS NewLinks FROM <%prefix%>Link WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Link_NewDays"%>*86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS HotLinks FROM <%prefix%>Link WHERE (HotItem = 1) OR (Hits >= <%m:config name="Link_MaxHotNumber"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PopularLinks FROM <%prefix%>Link WHERE (PopItem = 1) OR ( (CachedRating >= <%link:hit_count type="top"%>) AND <%link:hit_count type="top"%> AND (PopItem = 2) )', NULL, 'la_prompt_PopularLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Link WHERE CachedRating > 0', NULL, 'la_prompt_LinksAverageRating', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksHits', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksVotes', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_NewestLinkDate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_LastLinkUpdate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.01, 1, 1);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField2', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.02, 1, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1', NULL, 'la_prompt_ActiveLinks', 0, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link', NULL, 'la_prompt_TotalLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1', NULL, 'la_prompt_ActiveLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2', NULL, 'la_prompt_PendingLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0', NULL, 'la_prompt_DisabledLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS NewLinks FROM <%prefix%>Link WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Link_NewDays"%>*86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS HotLinks FROM <%prefix%>Link WHERE (HotItem = 1) OR (Hits >= <%m:config name="Link_VotesToHot"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PopularLinks FROM <%prefix%>Link WHERE (PopItem = 1) OR ( (CachedRating >= <%link:hit_count type="top"%>) AND <%link:hit_count type="top"%> AND (PopItem = 2) )', NULL, 'la_prompt_PopularLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Link WHERE CachedRating > 0', NULL, 'la_prompt_LinksAverageRating', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksHits', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksVotes', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_NewestLinkDate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_LastLinkUpdate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField', 'la_Text_Links', 'la_link_sortfield_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.01, 1, 1);
-INSERT INTO ConfigurationAdmin VALUES ('Link_SortField2', 'la_Text_Links', 'la_link_sortfield2_prompt', 'select', '', 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>', 10.02, 1, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1', NULL, 'la_prompt_ActiveLinks', 0, 1);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link', NULL, 'la_prompt_TotalLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1', NULL, 'la_prompt_ActiveLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2', NULL, 'la_prompt_PendingLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0', NULL, 'la_prompt_DisabledLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS NewLinks FROM <%prefix%>Link WHERE (NewItem = 1) OR ( (UNIX_TIMESTAMP() - CreatedOn) <= <%m:config name="Link_NewDays"%>*86400 AND (NewItem = 2) )', NULL, 'la_prompt_NewLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1', NULL, 'la_prompt_EditorsPickLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS HotLinks FROM <%prefix%>Link WHERE (HotItem = 1) OR (Hits >= <%m:config name="Link_VotesToHot"%> AND (HotItem = 2) )', NULL, 'la_prompt_HotLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) AS PopularLinks FROM <%prefix%>Link WHERE (PopItem = 1) OR ( (CachedRating >= <%link:hit_count type="top"%>) AND <%link:hit_count type="top"%> AND (PopItem = 2) )', NULL, 'la_prompt_PopularLinks', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="AVG(CachedRating)" type="currency" precision="2"%> FROM <%prefix%>Link WHERE CachedRating > 0', NULL, 'la_prompt_LinksAverageRating', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksHits', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link', NULL, 'la_prompt_MaxLinksVotes', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_NewestLinkDate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link', NULL, 'la_prompt_LastLinkUpdate', 0, 2);
-INSERT INTO StatItem VALUES (0, 'In-Link', 'SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'', NULL, 'la_prompt_LinkReviews', 0, 2);
-This section allows the administrator to specify the default values for various link settings in In-link.
-<ul>
-<li> Order links by this setting specifies the default primary sort order for the link listings. It applies both on the front-end, and in the Administrative Console in the catalog. The first dropdown allows to select the field (an attribute of the link), and the second dropdown the direction of the sort.
-<li> And then by this setting specifies the default secondary sort order. It is set in the same way as the primary, and used when the primary order values are ambiguous. For example, when the primary sort value is Link Name', the secondary order will be used to sort among links with the same name.
-<li> Number of links per page specifies the default number of links shown per page. This value applies both to the front-end and to the Administrative Console. In the latter, this value can be changed for each session through the View menu.
-<li> Number of links per page on a short listing this setting is similar to the Number of links per page', but it applies to the front-end short link lists only. It can be overridden by setting the tag attributes in the appropriate templates.
-<li> Number of days for a link to be NEW this setting specifies the number of days, from the date of creation, during which the link will be automatically marked New' by the system. This setting will only apply to the links with the New' flag set to Automatic'.
-<li> Minimum rating for a link to be POP this setting specifies the minimum rating of the link for it to be automatically marked Popular by the system. This setting will only apply to the links with the Popularity flag set to Automatic. Note, that for a link to be popular it will need to meet the minimum votes requirement set below.
-<li> Maximum number of HOT links this setting specifies the maximum number hot links in the database. A hot link is the one that has more hits than the other links. For example, if this option is set to 2, the In-portal system will pick the two links with the most hits and mark them as hot. (Of course, this will change real-time as links hits are updated, or as this setting changes). Please note, if more than one link has the maximum number of hits, the system will still enforce the maximum number requirement; therefore, there may be situations when a link with the most hits is not marked as hot.
-<li> Minimum number of votes to enable link rating this setting specifies the minimum number of votes required for the link rating to be effective. Usually, when only a small number of users have voted on a link, its rating will not be statistically accurate - it is likely, that only biased users have voted. When a larger number of users vote, the rating becomes more accurate. This setting affects the popularity property of a link links with less than required number of votes will not be considered popular, even if their rating is high enough.
-<li> Enhanced Listings this setting will enable the Enhanced listings functionality on the front end. Specifically, the Enhance option will appear on link listings under My Links section on the front end. To use the enhanced listing functionally, the site administrator needs to create at least one Listing Type under In-Link->Paid Listings section.
-<li>Allow Free Listings controls if free (regular) listings should be allowed; effective only when the enhanced (paid) listings are on. </li>
-<li> Display editor PICKs above regular links this setting will force all links, marked as Editor's pick' to be displayed above the other links, regardless of their priority or sort order. Among themselves, Editor's pick' links will be sorted according to the regular rules.
-<li> Display link URL in status bar this setting toggles the display of the URL in the browsers status bar (usually at the bottom of the window). It is impossible to view the URL of the link by examining the link itself, because In-link uses an intermediate script to redirect visitors to the link destinations. If it is desirable that the visitors can see the destination of the link, enable this setting.
-<li> Allow Duplicate Reviews this setting specifies the period during which the same user cannot submit another review on the same link. The time can be entered in seconds, minutes, hours, days, months or years. If it is set to zero, the users can submit reviews without this limitation. Please note, that regardless of this setting, the same user will be able to submit a review on another link immediately after the first review.
-<li> Allow Duplicate Rating Votes - this setting specifies the period during which the same user cannot rate the same link again. The time can be entered in seconds, minutes, hours, days, months or years. If it is set to zero, the users can rate links without this limitation. Please note, that regardless of this setting, the same user will be able to rate another link immediately after the first rating.
-<li> Reviews Per Page - specifies the default number of reviews shown per page. This value applies both to the front-end and to the Administrative Console.
-<li> Sort reviews by - this setting specifies the default primary sort order for the review listings. It applies both on the front-end, and in the Administrative Console in the link management section, Reviews tab. The first dropdown allows to select the field (an attribute of the review), and the second dropdown the direction of the sort.
-<li> and then by - this setting specifies the default secondary sort order. It is set in the same way as the primary, and used when the primary order values are ambiguous. For example, when the primary sort value is Review Text', the secondary order will be used to sort among reviews with the same body.
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.3.36/in-link/admin/include/help/configuration_output.txt
- $o = $objLinkList->QueryItemCount; // only use when no highlighting issued
- }
- else
- {
- $o = $objLinkList->PerformItemCount($attribs);
- }
-
- if ($o == '') {
- $o = 0;
- }
- return $o;
-}
-
-
-/*
- @description: Used in conjuction with l_list_links. This function generates the page navigation
- for the list. If this tag is called before the list tag, this function will load
- the links. For that reason, the _ListType attribute is required if the pagnav
- tag preceeds the l_list_links tag in the template. Generally, it is good practice to
- duplicate all attributes set for l_list_links.
- @attrib: _PagesToList:int: Number of pages to list (default is 10)
- @attrib: _ShortList:bool: If set, uses the shortlist configuration value for links
- @attrib: _label:lang: language tag to include in the output if there are pages to list. If there are no pages listed, this text will not be included (resulting in an empty output)
- @attrib: _ListType::Determines the type of list to generate<br>
- Possible values:<UL>
- <LI>Category: List links from the current category (default)
- <LI>Hot: Hot Links (Most Popular & highest rated links)
- <LI>Pop: Most Popular links
- <LI>New: List new links
- <LI>Hot: List links with the most click-throughs
- <LI>Pick: List editor's picks
- <LI>myitems: List topics created by the current user
- <LI>favorites: List topics marked as favorites by the current user
- <LI>search: List search results
- </UL>
-
-*/
-function l_link_pagenav($attribs = array())
-{
- global $objLinkList, $objCatList, $objSession, $objConfig;
- $rs=$db->Execute('SELECT '.$objCatList->TitleField.', CategoryId FROM '.$objCatList->SourceTable.' WHERE ParentId = '.$suggest_cat_id.' AND Status = 1');
- @description:Returns number of votes for item rating
-*/
-/*
- @field:link.cat_link
- @description:Returns a URL setting the link to the current link and the link's category to the current category
- @attrib:_template:tpl:Template URL should point to
-*/
-/*
- @field:link.link
- @description:Returns a URL setting the link to the current link
- @attrib:_template:tpl:Template URL should point to
-*/
-/*
- @field:link.rating
- @description:Displays the links rating
- @attrib:_displaymode:: How the rating should be displayed<br>
- <UL>
- <LI>"Numerical": Show the decimal value
- <LI>"Text": Show the text version
- <LI>"Graphical":Show images representing the rating
- </UL>
- @attrib:_onimage::on image tick shown in graphical display mode
- @attrib:_offimage::off image tick shown in graphical display mode
- @attrib:_separator::In graphical display mode, this html is placed between each tick image
-*/
-/*
- @field:link.reviews
- @description:Return the number of reviews for think link
- @attrib:_today:bool:Count reviews added today only
-*/
-/*
- @field:link.new
- @description:returns text if link's status is "new"
- @attrib:_label:lang: Text to return if status is new
-*/
-/*
- @field:link.pop
- @description:returns text if link's status is "popular"
- @attrib:_label:lang: Text to return if status is popular
-*/
-/*
- @field:link.hot
- @description:returns text if link's status is "hot"
- @attrib:_label:lang: Text to return if status is "hot"
-*/
-/*
- @field:link.pick
- @description:returns text if link's status is "hot"
- @attrib:_label:lang: Text to return if status is "hot"
-*/
-/*
- @field:link.custom
- @description:Returns a custom field
- @attrib:_customfield::field name to return
- @attrib:_default::default value
- @attrib:_listvalue::default value
-*/
-/*
- @field:link.category
- @description:Return a category field from the link's category
- @attrib:_cattag::Category field to parse
-*/
-/*
- @field:link.fullpath
- @description:The full category path of the item
-*/
-/*
- @field:link.relevance
- @description:Displays the link relevance in search results
- @attrib:_displaymode:: How the relevance should be displayed<br>
- <UL>
- <LI>"Numerical": Show the decimal value
- <LI>"Bar": Show the HTML representing the relevance. Returns two HTML cells ≶td< with specified background colors
- <LI>"Graphical":Show image representing the relevance
- </UL>
- @attrib:_onimage::Zero relevance image shown in graphical display mode. Also used as prefix to build other images (i.e. prefix+"_"+percentage+".file_extension"
- @attrib:_OffBackGroundColor::Off background color of HTML cell in bar display mode
- @attrib:_OnBackGroundColor::On background color of HTML cell in bar display mode
-
-*/
- break;
-
- default:
- unset($ret);
- break;
- }
-
- if(!isset($ret) || !strlen($ret) )
- {
- $ret = parent::ParseObject($element);
- }
- }
- else
- $ret= "Undefined";
- return $ret;
- }
-
- function parsetag($tag)
- {
- global $objConfig,$mytempdata, $rootURL, $var_list, $var_list_update, $l_var_list_update;
- WHERE (CreatedById = '.$objSession->Get('PortalUserId').') AND (OrgId > 0)';
-
- $pending_modified = Array();
- $original_links = Array();
- $db =& GetADODBConnection();
- $rs = $db->Execute($sql);
- while (!$rs->EOF) {
- $pending_modified[] = $rs->fields['LinkId'];
- $original_links[] = $rs->fields['OrgId'];
- $rs->MoveNext();
- }
-
- $TableName = $this->SourceTable;
- if ($pending_modified && $original_links) {
- $where = " (".$TableName.".Status > -1 OR LinkId IN (".implode(',', $pending_modified).") ) AND (LinkId NOT IN (".implode(',', $original_links).")) AND ".$TableName.".CreatedById=".$objSession->Get("PortalUserId");
- }
- else {
- $where = " (".$TableName.".Status > -1) AND ".$TableName.".CreatedById=".$objSession->Get("PortalUserId");
- $sql = "SELECT $TableName.*,$CategoryTable.CategoryId,$CategoryTable.".$ml_formatter->LangFieldName('CachedNavbar')." AS CachedNavBar FROM $TableName ";
- $p = $this->BasePermission.".VIEW";
- $sql .= $this->GetJoinedSQL($p,null,$where); // maybe null should be replaced by some CategoryId
- $sql = "SELECT ".$this->SourceTable.".*,$CategoryTable.CategoryId as CategoryId, ".$ml_formatter->LangFieldName('CachedNavbar')." AS CachedNavBar FROM $t INNER JOIN $cattable ON $cattable.ItemResourceId=$t.ResourceId ";
- $sql .= "INNER JOIN $CategoryTable ON ($CategoryTable.CategoryId=$cattable.CategoryId)";
- }
- else
- $sql = "SELECT * FROM ". $this->SourceTable;
- if(trim($whereClause)!="")
- {
- if(isset($whereClause))
- $sql = sprintf('%s WHERE %s',$sql,$whereClause);
- }
- if (trim($orderByClause)!="")
- {
- if(isset($orderByClause))
- $sql = sprintf('%s ORDER BY %s',$sql,$orderByClause);
- $sql = "SELECT CreatedOn FROM ".GetTablePrefix()."Link INNER JOIN ".GetTablePrefix()."CategoryItems AS cat ON (".GetTablePrefix()."Link.ResourceId = cat.ItemResourceId) WHERE cat.CategoryId=$CategoryId AND CreatedOn>=$cutoffdate ORDER BY CreatedOn DESC ";
- $Filters[] = "(val.ValidationStatus=0 OR val.ValidationStatus IS NULL)";
-
- if(count($Filters))
- {
- $imgFilter = implode(" OR ",$Filters);
- }
- else
- $imgFilter = "LinkValidationId = -1";
-}
-
-
-
-/* ------------------------------------ Build the SQL statement to populate the list ---------------------------*/
-
-
-$sql = "SELECT (CASE WHEN (val.ValidationStatus IS NULL) THEN '".admin_language("la_Text_Not_Validated")."' ELSE ( ELT(val.ValidationStatus+1,'".admin_language("la_Text_Not_Validated")." ','".admin_language("la_Text_Valid")."', '".admin_language("la_Text_Invalid")." ')) END) as ValStatus, ";
-$sql .="FROM_UNIXTIME(val.ValidationTime,'%m-%d-%Y') as ValidationTime, val.ValidationStatus as intValStatus, ";
-$sql .="val.LinkValidationId as LinkValidationId, val.ValidationCode as ValidationCode, SUBSTRING(link.Name, 1, 30) as LinkName, ";
-$sql .="CONCAT('<A href=\"', IF (link.Url LIKE 'http://%', link.Url, CONCAT('http://', link.Url)), '\" target=\"_blank\">', SUBSTRING(link.Url, 1, 30), '</A>') as LinkUrl, ";
-$sql .="FROM_UNIXTIME(link.CreatedOn,'%m-%d-%Y') as LinkCreatedOn, link.LinkId, link.Status ";
-
-$sql .="FROM ".$objLinkList->SourceTable." as link LEFT JOIN ".GetTablePrefix()."LinkValidation as val ON (link.LinkId=val.LinkId)";
-This release is necessary to support the new features introduced in In-portal Platform 1.2.1 (such as Section Permissions in the Administrative Console).
-Please refer to the release notes for In-portal Platform 1.2.1 for more information.
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/admin/install/upgrades/readme_3_2_1.txt
-This release is necessary to support the new features introduced in In-portal Platform 1.2.0 (such as Section Permissions in the Administrative Console).
-Please refer to the release notes for In-portal Platform 1.2.0 for more information.
-
-New In-link features:
- - Duplicate Links checker - allows locating duplicate links by their Name and/or URL field and editing, deleting and merging duplicates
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/admin/install/upgrades/readme_3_2_0.txt
- This is a maintenance release to support new features introduced in In-portal Platform 1.1.8 such as Category and Item Templates and custom field mechanism refactoring.
- Please refer to the release notes for In-portal Platform 1.1.8
-
-Bug fixes
- - In-link2 import utility may have created categories and links with automatic filename disabled, resulting an incorrect behavior when imported data was used in conjunction with mod_rewrite
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/admin/install/upgrades/readme_3_1_7.txt
-This tab contains the main attributes of the link.
-<ul>
-<li> Enable HTML? - this check box enables or disables HTML code in the link name and description. When checked, it will render the HTML (for example, a <B> tag will actually make the text bold). When unchecked, it will display the HTML as regular text (the <B> tag will appear exactly as <B>'). This is a very important setting, since some HTML tags can break the page layout, and in some instances can be a security concern (the Java Script, for example).
-<li> Link Id this read-only field displays the unique internal system ID of the link.
-<li> Name * - this field contains the link name.
-<li> Description this field contains the link description. The shortcut to the HTML editor next to this field will open a pop-up with an online HTML editor
-<li> URL * - this field contains the link URL. The URL can contain the protocol prefix (http://), but it does not have to.
-<li> Link Owner * - this field contains the name of the user who is owns this link. A link owner, given proper permissions, may modify the link on the front-end. By default, the link owner is the link creator. The administrator may change the link owner, by entering a different user name in this field, or by selecting it through a user pop up (shortcut to a user icon).
-<li>Automatic Filename specifies whether the Filename used for mod_rewrite should be generated automatically from the link name, or entered manually. If checked, the Filename will be generated from the link name, replacing all special characters ( !@#$%^&*()+|\=-~`{}][:;,./?>< ) by the underscore character (_), and all multiple underscores with a single underscore. If the resulting name ends with an underscore followed by number, an additional letter will be appended, since the names ending with a number are reserved for system use. The resulting name will also be checked for uniqueness, and if its not unique, additional letters will be appended to the end of the name
-<li>Custom Filename the filename used for the URL generation when using mod_rewrite. The field is disabled if Automatic Filename is On. If Automatic Filename is Off, the administrator may enter the filename manually, however it will still be checked for uniqueness, special characters and whether it ends with a number. In such cases the Filename will be automatically corrected before saving.
-<li> Status this field contains the link status.
-<li> New this field controls how the link new' status is calculated by In-link.
-<li> Hot this field controls how the link hot status is calculated by In-link. In automatic mode, In-link will consider as hot the X number of links with the most hits. X is defined under the In-link Output options.
-<li> Popularity this field controls how the link pop status is calculated by In-link. In automatic mode, In-link will consider those links as popular, which have at least X number of votes and have a rating above the predefined threshold. The number of votes and rating threshold are defined in the Output options section.
-<li> Editor's Pick this flags sets the Editor's Pick attribute of the link.
-<li> Priority - this field contains the numeric link priority.
-<li> Created on * - this field contains the creation date of the link. It is automatically set by the system when the link is created, however it can be changed by the administrator. The date can be entered directly into the field, or by using the visual calendar tool.
-<li> Expiration Date - this field contains the expiration date of the link. It is automatically set by the system when a link is created, using the creation date plus the predefined number of days, set in the In-link configuration. It can be changed by the administrator, by being entered directly into the field, or by using the visual calendar tool.
-<li> Rating this field contains the numeric rating of the link. The rating is calculated as the average value of all ratings selected by users for this link. The range of the value is predefined, and displayed to the right as a hint. The administrator can manually change the rating if necessary.
-<li> Votes this field contains the number of votes for the link. Each time a user votes (selects rating) for the link on the front-end, this value is incremented by one. This value is important for the rating calculating, it is used in the formula to calculate the average. The administrator can manually change the number of votes if necessary.
-<li> Hits this field contains the number of link's hits. This value is incremented each time a user clicks on the link to go to the link's URL. The administrator can manually change the hits if necessary.
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/links_edit.txt
-This tab contains a list of all relations of this link. To create a new relation, click the New' button (two opposite green arrows with a little sun). This will pop up an item picker, where you can choose one category or item of any module that supports relations.
-<ul>
-<li> Relation ID this is a read-only field, the internal system ID of the relation, guaranteed to be unique throughout the system. It is blank when a new relation is created.
-<li> Item this is a read-only field, displaying the name of the item that you are creating a relation to, and its type. In the current version, links can be related to categories, articles (if In-newz is installed) and topics (if In-bulletin is installed).
-<li> Type this field designated the type of the relation. A reciprocal' type denotes a two-way relation, and one way' a one directional relation, from the link to the item.
-<li> Enabled this field is the status flag of the relation.
-<li> Priority this field is the numerical priority of the relation.
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/relations_edit.txt
-This section allows the administrator to specify the default values for various link settings in In-link.
-<ul>
-<li> Order links by this setting specifies the default primary sort order for the link listings. It applies both on the front-end, and in the Administrative Console in the catalog. The first dropdown allows to select the field (an attribute of the link), and the second dropdown the direction of the sort.
-<li> And then by this setting specifies the default secondary sort order. It is set in the same way as the primary, and used when the primary order values are ambiguous. For example, when the primary sort value is Link Name', the secondary order will be used to sort among links with the same name.
-<li> Number of links per page specifies the default number of links shown per page. This value applies both to the front-end and to the Administrative Console. In the latter, this value can be changed for each session through the View menu.
-<li> Number of links per page on a short listing this setting is similar to the Number of links per page', but it applies to the front-end short link lists only. It can be overridden by setting the tag attributes in the appropriate templates.
-<li> Number of days for a link to be NEW this setting specifies the number of days, from the date of creation, during which the link will be automatically marked New' by the system. This setting will only apply to the links with the New' flag set to Automatic'.
-<li> Minimum rating for a link to be POP this setting specifies the minimum rating of the link for it to be automatically marked Popular by the system. This setting will only apply to the links with the Popularity flag set to Automatic. Note, that for a link to be popular it will need to meet the minimum votes requirement set below.
-<li> Maximum number of HOT links this setting specifies the maximum number hot links in the database. A hot link is the one that has more hits than the other links. For example, if this option is set to 2, the In-portal system will pick the two links with the most hits and mark them as hot. (Of course, this will change real-time as links hits are updated, or as this setting changes). Please note, if more than one link has the maximum number of hits, the system will still enforce the maximum number requirement; therefore, there may be situations when a link with the most hits is not marked as hot.
-<li> Minimum number of votes to enable link rating this setting specifies the minimum number of votes required for the link rating to be effective. Usually, when only a small number of users have voted on a link, its rating will not be statistically accurate - it is likely, that only biased users have voted. When a larger number of users vote, the rating becomes more accurate. This setting affects the popularity property of a link links with less than required number of votes will not be considered popular, even if their rating is high enough.
-<li> Enhanced Listings this setting will enable the Enhanced listings functionality on the front end. Specifically, the Enhance option will appear on link listings under My Links section on the front end. To use the enhanced listing functionally, the site administrator needs to create at least one Listing Type under In-Link->Paid Listings section.
-<li>Allow Free Listings controls if free (regular) listings should be allowed; effective only when the enhanced (paid) listings are on. </li>
-<li> Display editor PICKs above regular links this setting will force all links, marked as Editor's pick' to be displayed above the other links, regardless of their priority or sort order. Among themselves, Editor's pick' links will be sorted according to the regular rules.
-<li> Display link URL in status bar this setting toggles the display of the URL in the browsers status bar (usually at the bottom of the window). It is impossible to view the URL of the link by examining the link itself, because In-link uses an intermediate script to redirect visitors to the link destinations. If it is desirable that the visitors can see the destination of the link, enable this setting.
-<li> Allow Duplicate Reviews this setting specifies the period during which the same user cannot submit another review on the same link. The time can be entered in seconds, minutes, hours, days, months or years. If it is set to zero, the users can submit reviews without this limitation. Please note, that regardless of this setting, the same user will be able to submit a review on another link immediately after the first review.
-<li> Allow Duplicate Rating Votes - this setting specifies the period during which the same user cannot rate the same link again. The time can be entered in seconds, minutes, hours, days, months or years. If it is set to zero, the users can rate links without this limitation. Please note, that regardless of this setting, the same user will be able to rate another link immediately after the first rating.
-<li> Reviews Per Page - specifies the default number of reviews shown per page. This value applies both to the front-end and to the Administrative Console.
-<li> Sort reviews by - this setting specifies the default primary sort order for the review listings. It applies both on the front-end, and in the Administrative Console in the link management section, Reviews tab. The first dropdown allows to select the field (an attribute of the review), and the second dropdown the direction of the sort.
-<li> and then by - this setting specifies the default secondary sort order. It is set in the same way as the primary, and used when the primary order values are ambiguous. For example, when the primary sort value is Review Text', the secondary order will be used to sort among reviews with the same body.
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/config_list_output.txt
-This section allows the administrator to identify and manage duplicate links in the directory. By default, the section lists all duplicate links found in the system, identifying the duplicates by matching the URL field of the links. <br/>
-The field or fields used to locate the duplicates are controlled through View menu of the section, Group By sub-menu. Currently it provides the options to search for duplicates by link Name, URL or Name and URL pair.<br/>
-If duplicate links are found, they are displayed in the grid below the toolbar grouped by the selected field(s). The duplicate grid has the following fields:<br/>
-<ul>
- <li>Link – displays the link Name field</li>
- <li>Link URL – displays the link URL field</li>
- <li>Description – displays the description associated with the link</li>
- <li>Modified – displays link’s last modification date and time</li>
-</ul>
-The section toolbar has the following buttons:<br/>
-<ul>
- <li>Edit – opens link editing form for all of the selected links. </li>
- <li>Delete – deletes selected links from the database</li>
- <li>Merge – merges the group of duplicates. Only one target link in duplicates group should be selected for merging. All non-selected links will be merged into selected one. The merge functions adds the target link to the categories of all non-selected links in the group and deletes non-selected links, resulting a single link in all of the categories instead of the duplicates. Please note that you will not see the link in the duplicates listing after merging, since it will not have duplicates any more.</li>
- <li>View – opens the view menu for the grid. Please see section 5.1.6 for more information on using the view menu.</li>
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/duplicate_links.txt
-This tab contains all images associated with the link. To create a new image, click on the New' button (the icon like the Windows GIF icon with a little sun). This will open a new page where you specify the image details.
-<ul>
-<li> Image ID a read-only field, the internal system ID of the image, guaranteed to be unique throughout the system. It is blank when a new image is created.
-<li> Name this field contains the image name, used on the front-end, in side the In-tags to refer to this image.
-<li> Alt Value this field contains the text value, which will be displayed in the alt' tag of the image on the front end, in side the page HTML code, and when a mouse pointer hovers over the image (in Internet Explorer).
-<li> Status this field contains the status of the image, enabled or disabled.
-<li> Primary this flag designates the primary image. There can be only one primary image per list (for one link). When you check this box on an image, the previous primary image is unset (if there is more than one image in the list).
-<li> Priority this field contains the numerical priority of the image.
-<li> Thumbnail location (upload from PC) Using this control, you can upload an image from the workstation you are at to the In-portal server. The image will be stored in the in-portal/kernel/images' directory.
-<li> Thumbnail location (remote URL) Here you can enter a remote URL address of an image. It will be linked from the remote server.
-<li> Same As Thumbnail This check box sets the full-size image to be the same as the thumbnail image. When this option is checked, you cannot upload a full-size image.
-<li> Thumbnail location (upload from PC) - Using this control, you can upload an image from the workstation you are at to the In-portal server. The image will be stored in the in-portal/kernel/images' directory.
-<li> Thumbnail location (remote URL) - Here you can enter a remote URL address of an image. It will be linked to from the remote server.
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/links_images.txt
-This section allows the administrator to manage the link custom fields. The link custom fields are useful when you need to store additional information about the links. For example, the links may have such custom fields, as the language of the destination site, the safe audience rating, the load times, etc. All custom fields will be automatically used in the Administrative Console, in the Link Management section. You will need to edit the theme templates for them to appear on the front-end.
-<ul>
-<li> Field Id this is a read-only field displaying the unique system ID of the custom field.
-<li> Field Name sets the internal name of the custom field. This is the name you would use to refer to the custom field in the In-tags when designing templates.
-<li> Field Label this is a read-only field, which displays the language variable name associated with the label of that field, and the value of the variable in the current language (after the colon). The label is used on the front end, and in the Administrative Console, to describe the field to the user who is entering information into it.
-<li> Show on the general tab this setting controls whether the custom field will be also displayed on the General tab in the Administrative Console, when editing the links. It is a short cut for frequently used custom fields. All settings below apply only when this is checked.
-<li> Heading this field contains the language variable of the section heading, under which the field appear on the general tab.
-<li> Field Prompt this field contains the language variable, which text will appear as the hint bind the field.
-<li> Input Type this drop down allows the administrator to designate the type of the information stored in the custom field, by specifying the HTML control to be used on the General form.
-<li> List of Values this field contains all choices for the above HTML controls of type radio button' or drop down'. The choices must be in the format: value1 = language variabe1, value2=language variable2. For example, to create a drop down with three choices (One, Two, Three) and their respective numerical values, this field would contain the following: 1=la_one,2=la_two,3=la_three).
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/custom_fields_list.txt
-This tab lists all reviews of the link, and allows the administrator to manage them. Reviews are little text articles that are attached to the link. They can be used to collect feedback from the front-end users, to provide details of the ratings, and for many other purposes.
-Reviews have their own status, independent from the link. They can be active, pending or disabled. The idea is very similar to the link status only active reviews are displayed on the link detail page, or wherever specified in the theme design. The category permissions specify the status of a new review created on the front-end.
-<ul>
-<li> Enable HTML? this check box enables or disables HTML code in the review body. When checked, it will render the HTML (for example, a <B> tag will actually make the text bold). When unchecked, it will display the HTML as regular text (the <B> tag will appear exactly as <B>'). This is a very important setting, since some HTML tags can break the page layout, and in some instances can be a security concern (the Java Script, for example).
-<li> Review ID - this field is a read-only unique system ID of the review.
-<li> Created by* - this field contains the name of the user who submitted the review. This information will be displayed, along with the text of the review and the date, on the front-end, unless specified otherwise in the active theme. The administrator may change the review author by entering a different user name in this field, or by selecting it through a user picker (shortcut to a user icon will pop up the picker in a new window).
-<li> Review Text* - this field contains the main body of the review. To use the online HTML editor, click on the Editor' button next to this field.
-<li> Status - this is the status field of the review.
-<li> Priority this field contains the numerical priority of the review.
-<li> Created on this field contains the creation date of the review. It is automatically set by the system when the review is submitted, however it can be changed by the administrator. The date can be entered directly into the field, or by using the visual calendar tool.
-<li> Created at - this field contains the creation time of the review. It is automatically set by the system when the review is submitted, however it can be changed by the administrator. The date can be entered directly into the field, or by using the visual calendar tool.
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/links_reviews.txt
-This section contains general In-link settings, which are not related to links. In the current version, it has only one setting. Select Module Root Category' allows the administrator to specify the module root category of In-link. Clicking on the folder shortcut button will pop up a category picker.
-The module root category is used in several ways. On the front-end, in the Default theme, the top menu links each module to its module root category. Therefore, the Directory' menu item will open this category and its contents. In the Administrative Console, this setting provides a faster way to navigate in the module, as it presets the category for module-specific actions.
-Logically, the module root category defines the portion of the catalog tree that is designated only for the In-link categories. If you are using the categories to store items from multiple modules, this setting is not applicable to your situation.
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/config_list_general.txt
-This section lists all possible In-link events. Each event has a description, a type User' or Admin', a status Enabled', Front-end Only', and a From/To User'. The description hints about when the event occurs. The type indicates whether the email notification will be sent to the front-end user, or the administrator. The status Enabled' signifies that the email notifications for this event are enabled for both the front-end and the Administrative Console. The Front-end Only' status means that the notifications will be sent only when the event occurs on the front end. The Disabled' status means no notifications will be sent when this event occurs. The From/To User' field specifies the From' email for front-end user notifications, and the To' email for the administrative notifications. The other, matching pair of addresses (To' for the front, and From' for the admin) is automatically determined by the system based on who initiated the event. The event notification status can be changed by clicking on the toolbar buttons Enable' to enable the notification, Disable' to disable it, and Front Only' (icon with a monitor) to set to Front-end Only' status.
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/email_settings_list.txt
-This tab contains all images associated with the link. To create a new image, click on the New' button (the icon like the Windows GIF icon with a little sun). This will open a new page where you specify the image details.
-<ul>
-<li> Image ID a read-only field, the internal system ID of the image, guaranteed to be unique throughout the system. It is blank when a new image is created.
-<li> Name this field contains the image name, used on the front-end, in side the In-tags to refer to this image.
-<li> Alt Value this field contains the text value, which will be displayed in the alt' tag of the image on the front end, in side the page HTML code, and when a mouse pointer hovers over the image (in Internet Explorer).
-<li> Status this field contains the status of the image, enabled or disabled.
-<li> Primary this flag designates the primary image. There can be only one primary image per list (for one link). When you check this box on an image, the previous primary image is unset (if there is more than one image in the list).
-<li> Priority this field contains the numerical priority of the image.
-<li> Thumbnail location (upload from PC) Using this control, you can upload an image from the workstation you are at to the In-portal server. The image will be stored in the in-portal/kernel/images' directory.
-<li> Thumbnail location (remote URL) Here you can enter a remote URL address of an image. It will be linked from the remote server.
-<li> Same As Thumbnail This check box sets the full-size image to be the same as the thumbnail image. When this option is checked, you cannot upload a full-size image.
-<li> Thumbnail location (upload from PC) - Using this control, you can upload an image from the workstation you are at to the In-portal server. The image will be stored in the in-portal/kernel/images' directory.
-<li> Thumbnail location (remote URL) - Here you can enter a remote URL address of an image. It will be linked to from the remote server.
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/images_edit.txt
-This tab manages the categories of the link. The list shows all categories to which this link belongs. The administrator can add and remove additional categories on this list. At least one category must be there, and exactly one category must be designated as the primary. The primary category determines the permissions for the link. To designate the primary category of the link, select the category and click on the Primary Category icon in the toolbar. The primary' marker will move from the previous Primary Category to the one you have selected. </p>
-<p>The link will appear in all of the categories it belongs to, in the Administrative Console as well as on the front-end.
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/links_categories.txt
-This tab contains a list of all relations of this link. To create a new relation, click the New' button (two opposite green arrows with a little sun). This will pop up an item picker, where you can choose one category or item of any module that supports relations.
-<ul>
-<li> Relation ID this is a read-only field, the internal system ID of the relation, guaranteed to be unique throughout the system. It is blank when a new relation is created.
-<li> Item this is a read-only field, displaying the name of the item that you are creating a relation to, and its type. In the current version, links can be related to categories, articles (if In-newz is installed) and topics (if In-bulletin is installed).
-<li> Type this field designated the type of the relation. A reciprocal' type denotes a two-way relation, and one way' a one directional relation, from the link to the item.
-<li> Enabled this field is the status flag of the relation.
-<li> Priority this field is the numerical priority of the relation.
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/links_relations.txt
-This tab lists all reviews of the link, and allows the administrator to manage them. Reviews are little text articles that are attached to the link. They can be used to collect feedback from the front-end users, to provide details of the ratings, and for many other purposes.
-Reviews have their own status, independent from the link. They can be active, pending or disabled. The idea is very similar to the link status only active reviews are displayed on the link detail page, or wherever specified in the theme design. The category permissions specify the status of a new review created on the front-end.
-<ul>
-<li> Enable HTML? this check box enables or disables HTML code in the review body. When checked, it will render the HTML (for example, a <B> tag will actually make the text bold). When unchecked, it will display the HTML as regular text (the <B> tag will appear exactly as <B>'). This is a very important setting, since some HTML tags can break the page layout, and in some instances can be a security concern (the Java Script, for example).
-<li> Review ID - this field is a read-only unique system ID of the review.
-<li> Created by* - this field contains the name of the user who submitted the review. This information will be displayed, along with the text of the review and the date, on the front-end, unless specified otherwise in the active theme. The administrator may change the review author by entering a different user name in this field, or by selecting it through a user picker (shortcut to a user icon will pop up the picker in a new window).
-<li> Review Text* - this field contains the main body of the review. To use the online HTML editor, click on the Editor' button next to this field.
-<li> Status - this is the status field of the review.
-<li> Priority this field contains the numerical priority of the review.
-<li> Created on this field contains the creation date of the review. It is automatically set by the system when the review is submitted, however it can be changed by the administrator. The date can be entered directly into the field, or by using the visual calendar tool.
-<li> Created at - this field contains the creation time of the review. It is automatically set by the system when the review is submitted, however it can be changed by the administrator. The date can be entered directly into the field, or by using the visual calendar tool.
-</ul>
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.1.2/in-link/module_help/reviews_edit.txt
-UPDATE ConfigurationAdmin SET ValueList = 'Name=la_Link_Name,Description=la_Link_Description,Url=la_Link_URL,CreatedOn=la_Link_Date,Hits=la_Link_Hits,CachedRating=la_Link_Rating,<SQL>SELECT Prompt AS OptionName, CONCAT("cust_", FieldName) AS OptionValue FROM <PREFIX>CustomField WHERE (Type = 4) AND (IsSystem = 0)</SQL>' WHERE VariableName IN ('Link_SortField', 'Link_SortField2');
-
-UPDATE Modules SET Version = '3.2.0' WHERE Name = 'In-Link';
\ No newline at end of file
Property changes on: branches/unlabeled/unlabeled-1.2.2/in-link/admin/install/upgrades/inportal_upgrade_v3.2.0.sql
-UPDATE ConfigurationValues SET ModuleOwner = 'In-Link', Section = 'in-link:configuration_search' WHERE VariableName LIKE 'SearchRel_%_links' OR VariableName = 'Search_ShowMultiple_link';
-UPDATE ConfigurationValues SET VariableName = 'Search_ShowMultiple_links' WHERE VariableName = 'Search_ShowMultiple_link';