INSERTINTOConfigurationAdminVALUES('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);
INSERTINTOConfigurationAdminVALUES('Link_SortField2','la_Text_Links','la_link_sortfield2_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.02,1,1);
INSERTINTOCustomFieldVALUES(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);
INSERTINTOCustomFieldVALUES(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);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT COUNT(*) as LinkCount FROM <%prefix%>Link WHERE Status=1',NULL,'la_prompt_ActiveLinks',0,1);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT COUNT(*) AS TotalLinks FROM <%prefix%>Link',NULL,'la_prompt_TotalLinks',0,2);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT COUNT(*) AS ActiveLinks FROM <%prefix%>Link WHERE Status = 1',NULL,'la_prompt_ActiveLinks',0,2);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT COUNT(*) AS PendingLinks FROM <%prefix%>Link WHERE Status = 2',NULL,'la_prompt_PendingLinks',0,2);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT COUNT(*) AS DisabledLinks FROM <%prefix%>Link WHERE Status = 0',NULL,'la_prompt_DisabledLinks',0,2);
INSERTINTOStatItemVALUES(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);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT COUNT(*) FROM <%prefix%>Link WHERE EditorsPick = 1',NULL,'la_prompt_EditorsPickLinks',0,2);
INSERTINTOStatItemVALUES(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);
INSERTINTOStatItemVALUES(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);
INSERTINTOStatItemVALUES(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);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT MAX(Hits) AS MaxLinksHits FROM <%prefix%>Link',NULL,'la_prompt_MaxLinksHits',0,2);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT MAX(CachedVotesQty) AS MaxLinksVotes FROM <%prefix%>Link',NULL,'la_prompt_MaxLinksVotes',0,2);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT <%m:post_format field="MAX(CreatedOn)" type="date"%> FROM <%prefix%>Link',NULL,'la_prompt_NewestLinkDate',0,2);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT <%m:post_format field="MAX(Modified)" type="date"%> FROM <%prefix%>Link',NULL,'la_prompt_LastLinkUpdate',0,2);
INSERTINTOStatItemVALUES(DEFAULT,'In-Link','SELECT COUNT(*) FROM <%prefix%>ItemReview WHERE Module = \'<%modules:get_current%>\'',NULL,'la_prompt_LinkReviews',0,2);