<%@ page isThreadSafe="false" %><%@ include file="globalPaths.jsp" %><%@ include file="globalDefinitions.jsp" %><%@ include file="cacheBegin.jsp" %><%
// 	This code prevents caching for malicious cnt parameter specified by user
	
	int artworksPerPage = 42;
	int count = -1;
	try
	{
		if (request.getParameter("cnt") != null)
		{
			count = Integer.parseInt(request.getParameter("cnt"));
		}
	}
	catch (Exception e)
	{
		count = -1;
	}
	int cnt = count - count % artworksPerPage;
	if (cnt < 0) cnt = 0;
	String newurl = "category.jsp";
	String queryString = "?";
	if (request.getParameter("type") != null)
	{
		queryString = queryString + "type=" + request.getParameter("type") + "&";
	}
	if (request.getParameter("cat") != null)
	{
		queryString = queryString + "cat=" + request.getParameter("cat") + "&";
	}
	newurl = newurl + queryString;
	if (cnt != count)
	{
		sendRedirect(newurl + "cnt=" + cnt);
		return;
	}
%><%
	Cookie[] cookies;
	cookies = request.getCookies();
	String cookieArtist = "";
	for (int icook = 0; cookies != null && icook < cookies.length; icook++)
	{
		Cookie cookie = cookies[icook];
		if ((cookie.getName()).equals("galleryArtistID"))
		{
			cookieArtist = cookie.getValue(); 
		}
	}
	String remoteIP = "UndefinedIP";
	if (request.getRemoteAddr() != null)
	{
		remoteIP = request.getRemoteAddr();
	}
%><%
	boolean isPAI = false;
	boolean isGRA = false;
	boolean isPRI = false;
	boolean isPHO = false;
	boolean isSCU = false;
	boolean isMIX = false;
	boolean isNEW = false;
	boolean isCER = false;
	boolean isGLA = false;
	boolean isJEW = false;
	boolean isTEX = false;
	boolean isFUR = false;
	boolean isBOO = false;
	boolean isCAL = false;
	boolean isILL = false;
	boolean isDES = false;
	boolean isTYP = false;
	boolean isWEB = false;
	
	String category = request.getParameter("cat");
	
	if ("painting".equals(category))
		isPAI = true;
	if ("graphics".equals(category))
		isGRA = true;
	if ("printmaking".equals(category))
		isPRI = true;
	if ("photography".equals(category))
		isPHO = true;
	if ("sculpture".equals(category))
		isSCU = true;
	if ("mixedmedia".equals(category))
		isMIX = true;
	if ("newmedia".equals(category))
		isNEW = true;
	if ("ceramics".equals(category))
		isCER = true;
	if ("glass".equals(category))
		isGLA = true;
	if ("jewelry".equals(category))
		isJEW = true;
	if ("furniture".equals(category))
		isFUR = true;
	if ("textile".equals(category))
		isTEX = true;
	if ("booksart".equals(category))
		isBOO = true;
	if ("calligraphy".equals(category))
		isCAL = true;
	if ("illustration".equals(category))
		isILL = true;
	if ("printdesign".equals(category))
		isDES = true;
	if ("typography".equals(category))
		isTYP = true;
	if ("webdesign".equals(category))
		isWEB = true;
	
	
	if ("books".equals(category)) category="artbooks";
	String artType = request.getParameter("type");

	String artTypeCondition = "";
	String categoryCondition = "";
	String artTypeString = "";
	String categoryString = "";
	
	if  (artType != null && category != null
		&& !((artType.equals("fineart") || artType.equals("craft")
		|| artType.equals("commercialart")) && (category.equals("painting")
		|| category.equals("graphics") || category.equals("printmaking")
		|| category.equals("photography") || category.equals("sculpture")
		|| category.equals("mixedmedia") || category.equals("newmedia")
		|| category.equals("booksart") || category.equals("ceramics")
		|| category.equals("glass") || category.equals("jewelry")
		|| category.equals("furniture") || category.equals("metalart")
		|| category.equals("wood") || category.equals("textile")
		|| category.equals("calligraphy") || category.equals("illustration")
		|| category.equals("printdesign") || category.equals("typography")
		|| category.equals("artbooks") || category.equals("webdesign"))))
	{
		if ("fineart".equals(artType) || "craft".equals(artType) 
			|| "commercialart".equals(artType))
		{
			sendRedirect("category.jsp?type=" + artType);
			return;
		}
		else
		{
			sendRedirect("category.jsp");
			return;
		}
	}
	else
	{
		if (artType != null)
		{
			artTypeCondition = " AND W.type = " + quoteString(artType);
			if (artType.equals("fineart")) artTypeString = "FINE ART";
			if (artType.equals("craft")) artTypeString = "CRAFT";
			if (artType.equals("commercialart")) artTypeString = "GRAPHIC DESIGN";
		}
		else
		{
			artTypeString = "FINE&nbsp;ART,&nbsp;CRAFT,&nbsp;GRAPHIC DESIGN";
		}
		if (category != null)
		{
			categoryCondition = " AND W.category = " + quoteString(category);
			if (category.equals("booksart"))
			{
				categoryString = "Book Art";
			}
			else if (category.equals("printdesign"))
			{
				categoryString = "Print Design";
			}
			else if (category.equals("newmedia"))
			{
				categoryString = "New Media";
			}
			else if (category.equals("webdesign"))
			{
				categoryString = "Web Design";
			}
			else if (category.equals("artbooks"))
			{
				categoryString = "Books";
			}
			else if (category.equals("textile"))
			{
				categoryString = "Fiber Art";
			}
			else if (category.equals("mixedmedia"))
			{
				categoryString = "Mixed Media";
			}
			else
			{
				categoryString = toUpperCaseFirstLetter(category);
			}
		}
	}
%><%
	Vector names = new Vector();
	Vector shortBios = new Vector();
	Vector artworkSmallshots = new Vector();
	Vector packages = new Vector();
	Vector categories = new Vector();
	Vector websites = new Vector();
	Vector portfolios = new Vector();
	Vector artistIDs = new Vector();
	Vector artworkIDs = new Vector();
	Vector imageHeights = new Vector();
	Vector imageWidths = new Vector();
	Vector artworkDates = new Vector();
	String artworkID = null;
	String name = null;
	String shortBio = null;
	String artworkSmallshot = null;
	String pack = null;
	String website = null;
	String artistID = null;
	String width = null;
	String height = null;
	String portfolio = null;
	boolean needCaching = true;
%><%
	String query = "";
	ResultSet resultSet = null;
	Connection connection = null;
	Statement statement = null;
	try
	{
		connection = openConnection();
		statement = connection.createStatement();
		query = "SELECT A.id, A.speciality, A.firstname, A.lastname, A.shortbiography,"
			+ " A.portfolio, A.package, A.showStudio, A.activeflag, W.id,"
			+ " W.smallshot, W.modifiedDate, W.type, W.category, W.widthImage, W.heightImage,"
			+ " W.modifiedDate, S.id FROM galleryArtist A, galleryArtwork W, "
			+ " gallerySeries S WHERE W.artist = A.id AND S.artist = A.id"
			+ " AND W.series = S.id " + artTypeCondition + categoryCondition 
			+ " AND A.package != '6' AND A.package!='0' AND A.speciality!='' AND A.unwelcome<=1"
			+ " AND (W.activeflag='Y' OR W.activeflag='L') AND (A.activeflag='Y' OR A.ipLastLoggedFrom=" + quoteString(remoteIP) + " OR A.id=" 
			+ quoteString(cookieArtist) + " OR 'admin'="
			+ quoteString((String)session.getValue("logged")) 
			+ ") ORDER BY A.lastName, W.activeflag, S.id, W.id";
		resultSet = statement.executeQuery(query);
		String fullName;
		String firstName;
		String lastName;
		String id = "";
		while (resultSet.next()) 
		{
			if (!id.equals(resultSet.getString("A.id")))
			{
				if (!"Y".equals(resultSet.getString("A.activeflag")))
				{
					needCaching = false;
				}
				id = resultSet.getString("A.id");
				firstName = resultSet.getString("A.firstName");
				lastName = resultSet.getString("A.lastName");
				if (firstName.equals(""))
					fullName = lastName;
				else
					fullName = lastName + ", " + firstName;
				artistIDs.addElement(id);
				names.addElement(fullName);
				shortBio = resultSet.getString("A.shortBiography");
				shortBio = convertHTMLSymbolsToPlainNew(shortBio);
				// Remove malicious code (youtube) from description
				shortBio = prepareForListing(shortBio);				
				shortBios.addElement(shortBio);
				artworkSmallshots.addElement(resultSet.getString("W.smallshot"));
				imageHeights.addElement(resultSet.getString("W.heightImage"));
				imageWidths.addElement(resultSet.getString("W.widthImage"));
				categories.addElement(resultSet.getString("W.category"));
				packages.addElement(resultSet.getString("A.package"));
				websites.addElement(resultSet.getString("A.showStudio"));
				artworkIDs.addElement(resultSet.getString("W.id"));
				portfolios.addElement(resultSet.getString("A.portfolio"));
				artworkDates.addElement(getTimestampDigits(resultSet, "W.modifiedDate"));
			}
		}
		resultSet.close();
		connection.close();
	}
	catch (Exception e)
	{
		errorLog(e, query);
		sendRedirect(globalErrorPage + "?errorDescription="
			+ URLEncoder.encode(e.getMessage() + "."));
		return;
	}
	finally
	{
		if (resultSet != null) resultSet.close();
		if (connection != null && !connection.isClosed()) connection.close();
	}
%><%
	int numpages = (int)Math.ceil((double)artworkIDs.size() / (double)artworksPerPage);
	int[] pageindex = new int[numpages];
	for (int i = 0; i < numpages; i ++)
	{
		pageindex[i] = i * artworksPerPage;
	}
	if (cnt > artworkIDs.size() - 1) 
	{
		if (numpages>0)
		{
			cnt = pageindex[numpages - 1];
		}
		else
		{
			cnt = 0;
		}
	}
	if (cnt != count) {
		sendRedirect(newurl + "cnt=" + cnt);
		return;
	}
	int fromindex = cnt;
	int toindex = cnt + artworksPerPage - 1;
	if (toindex > artworkIDs.size() - 1) toindex = artworkIDs.size() - 1;
	int previndex = fromindex - artworksPerPage;
	if (previndex < 0) previndex = 0;
	String title = "Categories&nbsp;-&nbsp;" + artTypeString + "&nbsp;" 
		+ (categoryString.length() > 0 ? "&nbsp;-&nbsp;" + categoryString : "");
%><%
	if (needCaching)
	{
%><%@ include file="cacheLaunch.jsp" %><%
	}
%>
<head>
<title><%=title%></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="classification" content="<%=title%>">
<meta name="keywords" http-equiv="keywords" content="<%=title%>">
<%@ include file="inc/head.txt" %>
<body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0" bgcolor="#F8FDEF">
<%@ include file="inc/top.txt" %>
<script language="JavaScript">onloadHandler();</script>
<table cellpadding="0" cellspacing="0" border="0" width="775" bgcolor="#FFFFFF">
	<tr>
		<td valign=top>
			<table cellpadding="0" cellspacing="0" border="0">
				<tr>
					<td align=center colspan=7><img src="ima/e1.gif" width="1" height="15"></td>
				</tr>
				<tr>
					<td align=center colspan=7><%
	if (isPAI || 
		isGRA || 
		isPRI || 
		isSCU || 
		isPHO || 
		isMIX || 
		isNEW || 
		"fineart".equals(artType))
	{
%><br><a href="category.jsp?type=fineart&cat=painting"><%
		if (isPAI)
		{
%><font id="dkSmall8g"><b>Painting</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Painting</font><%
		}
%></a> | <a href="category.jsp?type=fineart&cat=graphics"><%
		if (isGRA)
		{
%><font id="dkSmall8g"><b>Graphics</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Graphics</font><%
		}
%></a> | <a href="category.jsp?type=fineart&cat=printmaking"><%
		if (isPRI)
		{
%><font id="dkSmall8g"><b>Printmaking</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Printmaking</font><%
		}
%> | <a href="category.jsp?type=fineart&cat=photography"><%
		if (isPHO)
		{
%><font id="dkSmall8g"><b>Photography</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Photography</font><%
		}
%> | <a href="category.jsp?type=fineart&cat=sculpture"><%
		if (isSCU)
		{
%><font id="dkSmall8g"><b>Sculpture</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Sculpture</font><%
		}
%> | <a href="category.jsp?type=fineart&cat=mixedmedia"><%
		if (isMIX)
		{
%><font id="dkSmall8g"><b>Mixed Media</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Mixed Media</font><%
		}
%> | <a href="category.jsp?type=fineart&cat=newmedia"><%
		if (isNEW)
		{
%><font id="dkSmall8g"><b>New Media</b></font><%
		}
		else
		{
%><font id="dkSmall8b">New Media</font><%
		}
%></a><%
	}
	if (isCER || 
		isJEW || 
		isGLA || 
		isTEX || 
		isFUR || 
		"craft".equals(artType))
	{
%><br><a href="category.jsp?type=craft&cat=ceramics"><%
		if (isCER)
		{
%><font id="dkSmall8g"><b>Ceramics</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Ceramics</font><%
		}
%></a> | <a href="category.jsp?type=craft&cat=glass"><%
		if (isGLA)
		{
%><font id="dkSmall8g"><b>Glass</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Glass</font><%
		}
%></a> | <a href="category.jsp?type=craft&cat=jewelry"><%
		if (isJEW)
		{
%><font id="dkSmall8g"><b>Jewelry</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Jewelry</font><%
		}
%></a> | <a href="category.jsp?type=craft&cat=furniture"><%
		if (isFUR)
		{
%><font id="dkSmall8g"><b>Furniture</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Furniture</font><%
		}
%></a> | <a href="category.jsp?type=craft&cat=textile"><%
		if (isTEX)
		{
%><font id="dkSmall8g"><b>Fiber Art</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Fiber Art</font><%
		}
%></a><%
	}
	if (isBOO || 
		isCAL || 
		isILL || 
		isDES || 
		isTYP || 
		isWEB || 
		"commercialart".equals(artType))
	{
%><br><a href="category.jsp?type=commercialart&cat=booksart"><%
		if (isBOO)
		{
%><font id="dkSmall8g"><b>Book Art</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Book Art</font><%
		}
%></a> | <a href="category.jsp?type=commercialart&cat=calligraphy"><%
		if (isCAL)
		{
%><font id="dkSmall8g"><b>Calligraphy</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Calligraphy</font><%
		}
%></a> | <a href="category.jsp?type=commercialart&cat=illustration"><%
		if (isILL)
		{
%><font id="dkSmall8g"><b>Illustration</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Illustration</font><%
		}
%></a> | <a href="category.jsp?type=commercialart&cat=printdesign"><%
		if (isDES)
		{
%><font id="dkSmall8g"><b>Print Design</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Print Design</font><%
		}
%></a> | <a href="category.jsp?type=commercialart&cat=typography"><%
		if (isTYP)
		{
%><font id="dkSmall8g"><b>Typography</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Typography</font><%
		}
%></a> | <a href="category.jsp?type=commercialart&cat=webdesign"><%
		if (isWEB)
		{
%><font id="dkSmall8g"><b>Web Design</b></font><%
		}
		else
		{
%><font id="dkSmall8b">Web Design</font><%
		}
%></a><%
	}
%>
<br><br>
</td>
				</tr>
				<tr>
					<td width="14" height="1"><img src="ima/e1.gif" width="14" height="1"></td>
					<td width="137" height="1"><img src="ima/e1.gif" width="137" height="1"></td>
					<td width="220" height="1"><img src="ima/e1.gif" width="220" height="1"></td>
					<td width="30" height="1"><img src="ima/e1.gif" width="30" height="1"></td>
					<td width="137" height="1"><img src="ima/e1.gif" width="137" height="1"></td>
					<td width="220" height="1"><img src="ima/e1.gif" width="220" height="1"></td>
					<td width="14" height="1"><img src="ima/e1.gif" width="14" height="1"></td>
				</tr>
				<tr>
					<td align=center colspan=7><img src="ima/e1.gif" width="1" height="35"></td>
				</tr>
				<tr>
					<td width="14" height="1"><img src="ima/e1.gif" width="14" height="1"></td>
					<td width="137" height="1"><img src="ima/e1.gif" width="137" height="1"></td>
					<td width="220" height="1"><img src="ima/e1.gif" width="220" height="1"></td>
					<td width="30" height="1"><img src="ima/e1.gif" width="30" height="1"></td>
					<td width="137" height="1"><img src="ima/e1.gif" width="137" height="1"></td>
					<td width="220" height="1"><img src="ima/e1.gif" width="220" height="1"></td>
					<td width="14" height="1"><img src="ima/e1.gif" width="14" height="1"></td>
				</tr>
							
<!--  beg  -->	
<%
	for (int i = fromindex; i < toindex + 1 && numpages > 0; i += 2)
	{
%>						
				<tr>
<%
		String link = "href=\"index.shtml\"";
		for (int j = i; j < i + 2; j ++)
		{
			if (j < artworkIDs.size())
			{
				artworkID = (String)artworkIDs.elementAt(j);
				name = (String)names.elementAt(j);
				shortBio = substituteTokens((String)shortBios.elementAt(j), "<br>", " ");
				artworkSmallshot = (String)artworkSmallshots.elementAt(j) + "?" 
					+ artworkDates.elementAt(j);
				category = (String)categories.elementAt(j);
				pack = (String)packages.elementAt(j);
				website = (String)websites.elementAt(j);
				portfolio = (String)portfolios.elementAt(j);
				artistID = (String)artistIDs.elementAt(j);
				width = (String)imageWidths.elementAt(j);
				height = (String)imageHeights.elementAt(j);
				if (category.equals("booksart"))
				{
					category = "Book Art";
				}
				else if (category.equals("printdesign"))
				{
					category = "Print Design";
				}
				else if (category.equals("newmedia"))
				{
					category = "New Media";
				}
				else if (category.equals("webdesign"))
				{
					category = "Web Design";
				}
				else if (category.equals("artbooks"))
				{
					category = "Books";
				}
				else if (category.equals("textile"))
				{
					category = "Fiber Art";
				}
				else if (category.equals("mixedmedia"))
				{
					category = "Mixed Media";
				}
				else
				{
					category = toUpperCaseFirstLetter(category);
				}
%>
					<td><font id="dkSmall6b">&nbsp;</font></td>							
					<td align="center" valign="top"><br>
<%
				if (pack.equals("0"))
				{
					link = "href=\"artwork.jsp?artwork=" + artworkID + "\"";
				}
				else if (pack.equals("1") || pack.equals("5"))
				{
					link = "href=\"artworks.jsp?artist=" + artistID + "\"";
				}
				else if (pack.equals("3"))
				{
					link = "href=\"" + portfolio + "\" target=\"_blank\"";
				}
				else if (pack.equals("2"))
				{
					link = "href=\"" + website + "\" target=\"_blank\"";
				}
%><a <%=link%>><img src="<%=artworkSmallshot%>" border="0" alt="<%=name%>" <% 
				if (Integer.parseInt(artworkID) > 262)
				{
					if ((float)(Integer.valueOf(height).intValue()) /
						(Integer.valueOf(width).intValue()) > 1.15) 
					{  
			%> height=90 <% 
					} 
					else 
					{
						if ((float)(Integer.valueOf(height).intValue()) /
							(Integer.valueOf(width).intValue()) < 1/1.15) 
						{ 
				%> width=90 <% 
						} 
						else 
						{ 
				%> width=82 <% 
						} 
					}
				}
	%>></a></td>
					<td valign=top><br><a <%=link%>><font id=dkSmall7b><b><%=name%></b></font></a><br><font id=dkSmall8b20><font id="dkSmall6buy"><b><%=category%></b></font></font><br><font id="dkSmall7miracle"><%=shortBio%></font></td>
<%
			}
			else
			{
%>
					<td colspan="3"></td>
<%
			}
		}
%>
					<td>&nbsp;</td>
				</tr>
				<tr>
					<td colspan="7"><br>&nbsp;</td>
				</tr>
				
<%
	}
%>
<!--  end  -->
			</table>
		</td>
	</tr>
</table>
<table cellspacing="0" cellpadding="0" border="0" width="775">
	<tr>
<% 
	if (numpages > 1)
	{
%>							
		<td align=center colspan=4>
			<br><font id="dkSmall8d">&nbsp;Results <%= fromindex + 1 %>-<%= toindex + 1 %> of <%=artworkIDs.size() %>&nbsp;&nbsp;&nbsp;</font>
<%
		if (fromindex > 0) 
		{ 
%>
			<a href="<%=newurl%>cnt=<%=previndex%>"><font id="dkSmall8d">&nbsp;Previous &nbsp;&nbsp;</font></a>  
<% 
		}  
		for (int j = 0; j < numpages; j ++)
		{ 
%>
			<font id=dkSmall8d>&nbsp;<a href="<%=newurl%>cnt=<%=pageindex[j]%>" class="types"><%= pageindex[j] == fromindex ? "<b>" + (j + 1) + "</b>" : String.valueOf(j + 1) %></a>&nbsp;
			</font>
<%
		}
		if (toindex<artworkIDs.size()-1)
		{
%>
			<a href="<%=newurl%>cnt=<%=toindex + 1%>"><font id="dkSmall8d">&nbsp;Next&nbsp;</font></a>
<%
		}
%></td><%
	}
	else
	{
%>
		<td align=center ><br><font id="dkSmall8d">&nbsp;</font></td>
<%
	}
%>
	</tr>
	
</table>
<%@ include file="inc/bottom.txt" %><%
	names.removeAllElements();
	shortBios.removeAllElements();
	artworkSmallshots.removeAllElements();
	artworkDates.removeAllElements();
	packages.removeAllElements();
	categories.removeAllElements();
	websites.removeAllElements();
	portfolios.removeAllElements();
	artistIDs.removeAllElements();
	artworkIDs.removeAllElements();
	imageHeights.removeAllElements();
	imageWidths.removeAllElements();
%><%
	if (needCaching)
	{
%><%@ include file="cacheEnd.jsp" %><%
	}
%><%@ include file="globalFinally.jsp" %>