<% response.setContentType("text/xml; charset=UTF-8"); %> <%@ page import = "java.util.*, java.io.*, java.sql.*, java.text.*,java.math.*,com.epagecity.site.html.*,com.epagecity.site.*, com.epagecity.*" errorPage="/error.jsp" %><% String lookup_host = request.getHeader("Host"); if(lookup_host.startsWith("www.")) { lookup_host = lookup_host.substring(4,lookup_host.length()); } String info[] = CompanyDB.getCompanyByPrimaryDomain(lookup_host); int co_id = Integer.parseInt(info[0]); if(co_id == 0) return; if(co_id == 622){ pageContext.forward("/site/template/assets/home_template_pokerfanaddicts_622/includes/sitemap.jsp"); return; } if(co_id == 880){ pageContext.forward("/site/template/assets/home_template_shschi_880/includes/sitemap.jsp"); return; } Vector used_item_ids = new Vector(); CompanyBean co = CompanyDB.getCompanyById(co_id); if(!co.getBoolean("show_sitemap_xml") || info[1].equals("NO_DOMAIN")){ response.setStatus(404,"Not Found"); pageContext.forward("/404.jsp"); return; } ResultSet rs = SiteDB.execQuery(0,"select * from item where company_id = " + co_id + " and under_construction = 0 and requires_access = 0 and https = 0 and show_on_site_map_xml = 1 order by parent_id, item_id"); //skip the homepage if(rs.next()){ Timestamp ts = rs.getTimestamp("last_update"); ResultSet rs2 = SiteDB.execQuery(0,"select top 1 last_update from item_components where item_id = " + rs.getInt("item_id") + " order by last_update desc"); if(rs2.next()){ Timestamp ts2 = rs2.getTimestamp("last_update"); if(ts2.after(ts)) ts = ts2; } int homepage_id = rs.getInt("item_id"); used_item_ids.add("" + homepage_id); SimpleDateFormat df = (SimpleDateFormat)DateFormat.getDateInstance(); df.applyPattern("yyyy-MM-dd"); String s = df.format(new java.util.Date(ts.getTime())); df.applyPattern("HH:mm:ss"); String s1 = df.format(new java.util.Date(ts.getTime())); %> http://www.<%= info[1] %>/ <%= s %> daily 1.0 <% while(rs.next()){ if(ItemDB.checkUnderConstructionOrNotSitemapXML(co_id, rs.getInt("item_id"))) continue; ts = rs.getTimestamp("last_update"); rs2 = SiteDB.execQuery(0,"select top 1 last_update from item_components where item_id = " + rs.getInt("item_id") + " order by last_update desc"); if(rs2.next()){ Timestamp ts2 = rs2.getTimestamp("last_update"); if(ts2.after(ts)) ts = ts2; } if(co_id == 533){ Timestamp ts3 = com.epagecity.site.psychobaby.PsychoBabyDB.getProductAssignmentLastUpdate(co_id, rs.getInt("item_id")); if(ts3 != null){ if(ts3.after(ts)) ts = ts3; } } df = (SimpleDateFormat)DateFormat.getDateInstance(); df.applyPattern("yyyy-MM-dd"); s = df.format(new java.util.Date(ts.getTime())); df.applyPattern("HH:mm:ss"); s1 = df.format(new java.util.Date(ts.getTime())); String priority = "0.8"; String freq = "weekly"; if(rs.getInt("parent_id") == homepage_id){ priority = "0.9"; freq = "daily"; } String link = "http://www." + info[1] + "/site/epage/" + rs.getInt("item_id") + "_" +co_id + ".htm"; if(rs.getString("alt_link") != null && !rs.getString("alt_link").equals("")){ link = rs.getString("alt_link"); if(link.startsWith("/site")) link = "http://www." + info[1] + link; else continue; } if(rs.getString("friendly_uri") != null && !rs.getString("friendly_uri").equals("")){ link = "http://www." + info[1] + "/" + rs.getString("friendly_uri") + "/"; } if( used_item_ids.contains("" + rs.getInt("item_id")) ) continue; else used_item_ids.add("" + rs.getInt("item_id")); //first convert & to & and then back again... link = P.replaceString(link,"&","&"); link = P.replaceString(link,"&","&"); link = P.replaceString(link,"'","'"); link = P.replaceString(link,"\"","""); %> <%= link %> <%= s %> <%= freq %> <%= priority %> <% } %><% } %>