<%@ Language=VBScript %> <% Option Explicit %> <% Dim strPM, PM, Im1path, Im2path, LogoMain, FSYS, Logo, strMenu, Menu, strMC, MenuCat, strRI, RI, MCols, ID, foldGall, newFolderName, ImgFolder, ImgFiles, file, strMenus, Menus Response.Expires = 0 strPM = "SELECT * FROM PageMinder WHERE ID = 3" Set PM = CreateObject("ADODB.RecordSet") PM.Open strPM, objConn strRI = "SELECT * FROM Restaurants" Set RI = CreateObject("ADODB.RecordSet") RI.Open strRI, objConn If RI("MultipleMenus") = True Then strMenus = "SELECT * FROM Menus WHERE Catering = False Order By OrderNo" Set Menus = CreateObject("ADODB.RecordSet") Menus.Open strMenus, objConn, adOpenStatic If Request.QueryString("viewMenuID") > "" Then strMenu= "SELECT * FROM Menu WHERE Menu = "& Request.QueryString("viewMenuID") &" Order By OrderNo" strMC = "SELECT MenuCats.ID, MenuCats.MenuCat, First(MenuCats.OrderNo) As OrderNo, First(MenuCats.CatDescrip) AS CatDescrip FROM Menu LEFT JOIN MenuCats ON Menu.MenuCat = MenuCats.ID GROUP BY MenuCats.ID, MenuCats.MenuCat, Menu.Menu HAVING (((Menu.Menu)="& Request.QueryString("viewMenuID") &")) Order By First(MenuCats.OrderNo)" ElseIf Not Menus.EOF Then strMenu= "SELECT * FROM Menu WHERE Menu = "& Menus("ID") &" Order By OrderNo" strMC = "SELECT MenuCats.ID, MenuCats.MenuCat, First(MenuCats.OrderNo) As OrderNo, First(MenuCats.CatDescrip) AS CatDescrip FROM Menu LEFT JOIN MenuCats ON Menu.MenuCat = MenuCats.ID GROUP BY MenuCats.ID, MenuCats.MenuCat, Menu.Menu HAVING (((Menu.Menu)="& Menus("ID") &")) Order By First(MenuCats.OrderNo)" Else strMenu= "SELECT * FROM Menu Order By OrderNo" strMC = "SELECT * FROM MenuCats Order By OrderNo" End If Else strMenu= "SELECT * FROM Menu Order By OrderNo" strMC = "SELECT * FROM MenuCats Order By OrderNo" End If Set Menu = CreateObject("ADODB.RecordSet") Menu.Open strMenu, objConn Set MenuCat = CreateObject("ADODB.RecordSet") MenuCat.Open strMC, objConn MCols = 1 If Layout("MPhotos") = True AND Layout("MIAlign") <> "Center" Then MCols = MCols + 1 If Layout("MPrice") = "right" AND Layout("MIAlign") <> "Center" Then MCols = MCols + 1 Set FSYS = Server.CreateObject("Scripting.FileSystemObject") Im1path = Server.MapPath ("pageminder") & "\" & PM("Image1") Im2path = Server.MapPath ("pageminder") & "\" & PM("Image2") If Layout("LogoSub") > "" Then LogoMain = Server.MapPath ("logo") & "\" & Layout("LogoSub") If FSYS.FileExists(LogoMain) Then Logo = Layout("LogoSub") Else LogoMain = Server.MapPath ("logo") & "\" & Layout("LogoMain") If FSYS.FileExists(LogoMain) Then Logo = Layout("LogoMain") End If %> <%=PM("PageTitle")%> "> "> " marginwidth="<%=Layout("LeftMargin")%>" topmargin="<%=Layout("TopMargin")%>" marginheight="<%=Layout("TopMargin")%>"> <% If Layout("PageAlign") = "Center" Then %>
<% End If %> <% If BRC = "True" OR TRC = "True" Then %> "100%"<% Else %>"780"<% End If %>> <% If TRC = "True" Then %> <% End If %> <% If BRC = "True" Then %> <% End If %>
><% If Layout("TL") = "True" Then %><% End If %> ><% If Layout("TR") = "True" Then %><% End If %>
<% End If %><% If Layout("NavLoc") = "Horizontal" Then %> bgcolor="white"<% End If %> width=<% If Layout("PageAlign") = "Full" Then %>"100%"<% If Layout("PageHeight") = True Then %> height="100%"<% End If %><% Else %><% If TRC OR BRC = "True" Then %>"750"<% Else %>"780"<% If Layout("PageHeight") = True Then %> height="100%"<% End If %><% End If %><% End If %>> <% If Layout("LogoPos") = "Below" Then %> <% End If %><% If FSYS.FileExists(LogoMain) Then %> <% End If %><% If Layout("LogoPos") = "Above" Then %> <% End If %>
Layout("HdrImg") Then %>bgcolor="<%=Layout("HdrImg")%>"<% End If %> align="<%=Layout("NavAlign")%>">
">
<% If FSYS.FileExists(im1Path) Then %>
style="padding-right: 6px; padding-bottom: 6px; filter:shadow(color:gray, strength:4, direction:135);"<% End If %>> <% Response.Write CoName & " border='<% If PM("Img1Border") = True Then %>1<% Else %>0<% End If %>'>
<% End If %><% If PM("Headline").ActualSize > 0 Then %>
<%=PM("Headline")%>
<% End If %><% If PM("HeaderText").ActualSize > 0 Then %>
<%=PM("HeaderText")%>
<% End If %><% If PM("BodyText").ActualSize > 0 Then %>
<%=PM("BodyText")%>
<% End If %> <% 'If Not Menu.EOF Then %> <% If FSYS.FileExists(im2Path) Then %>
style="padding-right: 6px; padding-bottom: 6px; filter:shadow(color:gray, strength:4, direction:135);"<% End If %>> <% Response.Write CoName & " border='<% If PM("Img2Border") = True Then %>1<% Else %>0<% End If %>'>
<% End If %><% If PM("FooterText").ActualSize > 0 Then %>
<%=PM("FooterText")%>
<% End If %>
<% If Layout("OptIn") = True Then %><% End If %>
<% Else %> bgcolor="white"<% End If %> width=<% If Layout("PageAlign") = "Full" Then %>"100%"<% If Layout("PageHeight") = True Then %> height="100%"<% End If %><% Else %><% If TRC OR BRC = "True" Then %>"750"<% Else %>"780"<% If Layout("PageHeight") = True Then %> height="100%"<% End If %><% End If %><% End If %>> <% If FSYS.FileExists(LogoMain) Then %> <% End If %>
" width="125" valign="top">
<% If FSYS.FileExists(im1Path) Then %>
style="padding-right: 6px; padding-bottom: 6px; filter:shadow(color:gray, strength:4, direction:135);" <% End If %>> <% Response.Write CoName & " border='<% If PM("Img1Border") = True Then %>1<% Else %>0<% End If %>'>
<% End If %><% If PM("Headline").ActualSize > 0 Then %>
<%=PM("Headline")%>
<% End If %><% If PM("HeaderText").ActualSize > 0 Then %>
<%=PM("HeaderText")%>
<% End If %><% If PM("BodyText").ActualSize > 0 Then %>
<%=PM("BodyText")%>
<% End If %> <% If FSYS.FileExists(im2Path) Then %>
style="padding-right: 6px; padding-bottom: 6px; filter:shadow(color:gray, strength:4, direction:135);" <% End If %>> <% Response.Write CoName & " border='<% If PM("Img2Border") = True Then %>1<% Else %>0<% End If %>'>
<% End If %><% If PM("FooterText").ActualSize > 0 Then %>
<%=PM("FooterText")%>
<% End If %>
<% End If %><% If TRC = "True" OR BRC = "True"Then %>
><% If Layout("BL") = "True" Then %><% End If %> ><% If Layout("BR") = "True" Then %><% End If %>
<% End If %><% If Layout("PageAlign") = "Center" Then %>
<% End If %> <% PM.Close Set PM = Nothing Menu.Close Set Menu = Nothing MenuCat.Close Set MenuCat = Nothing If RI("MultipleMenus") = True Then Menus.Close Set Menus = Nothing End If RI.Close Set RI = Nothing Layout.Close Set Layout = Nothing siteNav.Close Set siteNav = Nothing Set FSYS = Nothing objConn.Close Set objConn = Nothing %>