<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="System.IO" %> <%@ Import Namespace="System.Configuration" %> <%@ Page language="c#" Codebehind="site_map.aspx.cs" AutoEventWireup="True" Inherits="OpenSites.VolPage.site_map" %> <%@ Register TagPrefix="voloper" TagName="header" Src="header.ascx" %> <%@ Register TagPrefix="voloper" TagName="footer" Src="footer.ascx" %> <% String language; if (Request.Cookies["language"] != null) language = Request.Cookies["language"].Value; else language = ConfigurationSettings.AppSettings["default_language"]; StreamReader sr = new StreamReader (Server.MapPath("text/site_map_"+language+".txt")); string strText = sr.ReadToEnd (); sr.Close (); Response.Write (strText); %> <% String strSQL = "select * from pages where parent=0 and display_in_menu=1 order by sort_order,page_id"; DataView dView = m_Pagefile.m_DBLayer.RunSelectReturnDV (strSQL,null,false); Response.Write ("

"); for (int i=0; i"+dView[i]["page_name"].ToString()+"\n"); strSQL = "select * from pages where parent="+dView[i]["page_id"].ToString()+" and display_in_menu=1 order by sort_order,page_id"; DataView dView2 = m_Pagefile.m_DBLayer.RunSelectReturnDV (strSQL,null,false); if (dView2.Count > 0) { DisplaySubLink (Convert.ToInt32 (dView[i]["page_id"])); } Response.Write (""); } Response.Write ("

"); %>