
<!--#include file="common/dbprovider.inc"-->
<!--#include file="common/sprachauswahl.inc"-->
<html>
<head>

<%

response.buffer = "true"

id = int(request.querystring("id"))


' database connection
conn = db_bodas
category=request.querystring("category")
strSqlStmt = "select * FROM " & category & " WHERE  id = " & id
'response.write strSqlStmt
Set rs=Server.CreateObject("ADODB.Recordset")
rs.open strSqlStmt, conn	

if rs.eof then
response.write "Sorry, No photo avialable."
response.End
end if
%>


	<title><% =title_text %>Image </title>
	<link rel="stylesheet" href="common/admin.css" type="text/css"> 

<meta name="keywords" content="marbella, spanien, andalusien, immobilien, villen, wohnungen, penthouse, ferienwohnungen, costa del sol, marbella invest,  investitionen, geldanlage, golf, golfplätze, malaga, estepona, baugrundstücke, gewerbeobjekte, ladenlokale, puerto banus, marbella hotels, mediterranean weather, Investieren in Immobilien in Marbella, gute Renditen, solider Markt, wo die Sonne das ganze Jahr scheint, gesundes Klima,Traumlandschaft, Villen und Wohnungen an der Costa del Sol, 366 Tage Sonne,  Immobilienmarkt, Immobilienpreise, Immobilienschnäppchen, Wohnungskauf, Hauskauf, Häuserkauf, Grundstückskauf, Wohnungsverkauf, Hausverkauf, Häuserverkauf, Grundstücksverkauf, Immobilienkauf, Immobilienverkauf, Immobilienmakler, Makler, Immobiliengeschäft, Immobilienfinanzierung, Immobilienberatung, Immobilienberater, Immobilienspezialist, Immobilienprofi, Fertighaus, Ausbauhäuser, Ausbauhaus, Reihenhäuser, Reihenhaus, chalet, reststaurant, bar, parzelle, baugrundstück, marbella, Spain, Andalusia, real estates, villas, apartments, penthouse, vacation-apartments, Costa Del sol, marbella invest, investments, investment, golf, golf courses, malaga, estepona, building lots, trade-objects, load-local, Puerto banus, marbella hotels, mediterranean weather, investing in real estates in Marbella, good yields, strong market, where the sun seems the whole year, healthy Klima,Traumlandschaft, villas and apartments at her/it Costa Del Sol, 366 days sun, real estate-market, real estate-prices,  apartment-purchase, house-purchase, property-purchase, apartment-sale, house-sale, property-sale, real estate-purchase, real estate-sale, real estate-brokers, brokers, real estate-business, real estate-funding, real estate-advice, real estate-advisors, real estate-specialist, real estate-pro, ready-house, extension-houses, extension-house, townhouse, town-house, andalusien, immobilien, villen, wohnungen, penthouse, ferienwohnungen, costa del sol, marbella invest,  investitionen, geldanlage, golf, golfplätze, malaga, estepona, baugrundstücke, gewerbeobjekte, ladenlokale, puerto banus, marbella hotels, mediterranean weather, Investieren in Immobilien in Marbella, gute Renditen, solider Markt, wo die Sonne das ganze Jahr scheint, gesundes Klima,Traumlandschaft, Villen und Wohnungen an der Costa del Sol, 366 Tage Sonne,  Immobilienmarkt, Immobilienpreise, Immobilienschnäppchen, Wohnungskauf, Hauskauf, Häuserkauf, Grundstückskauf, Wohnungsverkauf, Hausverkauf, Häuserverkauf, Grundstücksverkauf, Immobilienkauf, Immobilienverkauf, Immobilienmakler, Makler, Immobiliengeschäft, Immobilienfinanzierung, Immobilienberatung, Immobilienberater, Immobilienspezialist, Immobilienprofi, Fertighaus, Ausbauhäuser, Ausbauhaus, Reihenhäuser, Reihenhaus, Espagne, andalusie, biens immeubles, villas, appartements, penthouse, apartements pour vacances, costa del sol, marbella invest,  investissements, placement, club de golf, terrains pour construire, objets commerciales, magasin, puerto banus, marbella hôtels, mediterranean temp, investir à biens immeubles à Marbella, bonnes profits, solide marché, marché immobilier, prix immobiliers, Immobilienschnäppchen, achât de propriété, achât de maison, vente de maison, achât de terrain, Wohnungsverkauf, Hausverkauf, Häuserverkauf, Grundstücksverkauf, Immobilienkauf, Immobilienverkauf, agent immobilier, courtier, maison préfabriqué, maisons serrée, apartement">	
<meta name="description" content="<%=Beschreibung %>">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="pragma" content="cache">
<meta name="robots" content="INDEX,FOLLOW">
<meta http-equiv="content-language" content="<% =session("lang") %>">
<META name="author" content="Manfred Leister">

<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
var xy = navigator.appVersion;
xz = xy.substring(0,4);
document.cookie = "ScreenWidth=" + screen.width
document.cookie = "ScreenHeight=" + screen.height
// End -->
</script>

</head>

<body bgcolor="#FFFFFF">
<p align="center"><strong><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">Idioma 
  / Sprache / Langue / Language =</font></strong> <a href="view.asp?lang=es&id=<% =id %>&category=<% =category %>"><img src="<% =url %>/images/flag_es.gif" width="30" height="21" border="0" align="absmiddle"></a> 
  &nbsp; <a href="view.asp?lang=de&id=<% =id %>&category=<% =category %>"> <img src="<% =url %>/images/flag_de.gif" width="30" height="21" border="0" align="absmiddle"></a> 
  &nbsp; <a href="view.asp?lang=fr&id=<% =id %>&category=<% =category %>"> <img src="<% =url %>/images/flag_fr.gif" width="30" height="21" border="0" align="absmiddle"></a> 
  &nbsp; <a href="view.asp?lang=en&id=<% =id %>&category=<% =category %>"> <img src="<% =url %>/images/flag_en.gif" width="30" height="21" border="0" align="absmiddle"></a> 
  &nbsp; <a href="view.asp?lang=sv&id=<% =id %>&category=<% =category %>"> <img src="<% =url %>/images/flag_ru.gif" width="30" height="21" border="0" align="absmiddle"></a>

<table width="200" border="0" cellpadding="0" align="center">
  <tr>
    <td><img src="<% =url %>/images/imagegallery_<% =session("lang") %>.gif"></td>
    <td><a href="javascript:history.back(-1)"><img src="<% =url %>/images/goback_<% =session("lang") %>.gif"  border="0"></a></td>
  </tr>
</table>
<br>

<table width="200" border="0" align="center">
  <tr>
    <td><%
strSqlStmt2 = "select * FROM " & category & " WHERE  id = " & id-1
'response.write strSqlStmt
Set rs2=Server.CreateObject("ADODB.Recordset")
rs2.open strSqlStmt2, conn
if rs2.eof then
else
ziel=rs2("id")
response.write "<a href=view.asp?id="&ziel&"&category="&category&" ><img src=""http://cielomijas.com/images/arrow_left.jpg"" width=""37"" height=""44""></a>"
end if
%></td>
    <td><table  border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="16"><img src="images/top_lef.gif" alt="picture" width="16" height="16"></td>
        <td height="16" background="images/top_mid.gif"><img src="images/top_mid.gif" alt="picture" width="16" height="16"></td>
        <td width="24"><img src="images/top_rig.gif" alt="picture" width="24" height="16"></td>
      </tr>
      <tr>
        <td width="16" rowspan="2" background="images/cen_lef.gif"><img src="images/cen_lef.gif" alt="picture" width="16" height="11"></td>
        <td align="center" valign="middle" bgcolor="#EFEFEF"></td>
        <td width="24" rowspan="2" background="images/cen_rig.gif"><img src="images/cen_rig.gif" alt="picture" width="24" height="11"></td>
      </tr>
      <tr>
        <%
' get screen size
'Declare variables
Dim strScreenWidth
Dim strScreenHeight

'Read the cookies with the width and height
strScreenWidth = Request.Cookies("ScreenWidth")
strScreenHeight = Request.Cookies("ScreenHeight")

'If not cookie was made then say the screen size is 800x600
If strScreenWidth = "" Then strScreenWidth = 800
'If strScreenHeight = "" Then strScreenHeight = 600

if strScreenWidth>1000 then strScreenWidth = 1000
%>
        <%
bild=rs("imagefile")
if bild<>"" then
else
bild="image_replacer.jpg"
end if

%>
        <td width="56" align="center" valign="top" bgcolor="#E7E3E7"><div align="center"><a href="bodas/<% =category %>/<% =bild %>" alt="picture" align="top" border="2" >"<img src="bodas/<% =category %>/<% =bild %>" alt="picture" width="<% =strScreenWidth-100 %>" align="top" border="2" ></a><br>
          <% =rs("caption")%>
        </div></td>
      </tr>
      <tr>
        <td width="16" height="16"><img src="images/bot_lef.gif" alt="picture" width="16" height="16"></td>
        <td height="16" background="images/bot_mid.gif"><img src="images/bot_mid.gif" alt="picture" width="16" height="16"></td>
        <td width="24" height="16"><img src="images/bot_rig.gif" alt="picture" width="24" height="16"></td>
      </tr>
    </table></td>
    <td><%
strSqlStmt3 = "select * FROM " & category & " WHERE  id = " & id+1
'response.write strSqlStmt
Set rs3=Server.CreateObject("ADODB.Recordset")
rs3.open strSqlStmt3, conn, 3,3
if rs3.eof then
else
ziel=rs3("id")
response.write "<a href=view.asp?id="&ziel&"&category="&category&" ><img src=""http://cielomijas.com/images/arrow_right.jpg"" width=""37"" height=""44""></a>"
end if
%></td>
  </tr>
</table>
<div align="center"><br>
<%
response.write "<table width=""200"" border=""1"" align=""center"" bgcolor=""#CCCCCC"">"
response.write "<tr>"
response.write "<td colspan=2><p>"
response.write "<font face=""Verdana, Arial, Helvetica, sans-serif"" size=""1"">" & ca_descripcion & "</font>"
response.write ":<br>"
response.write "<font face=""Verdana, Arial, Helvetica, sans-serif"" size=""1"">" 
response.write rs("bild_description_" & session("lang") & "")
response.write "</font></p></td>"


Set rs2=Server.CreateObject("ADODB.Recordset")
sqlstmt="select * from add_comment WHERE publish='yes' AND bild_id=" & id
'response.write sqlstmt
rs2.open sqlstmt, conn

if rs2.eof then
else
do until rs2.eof
response.write "<tr><td colspan=2>"
response.write "<font face=""Verdana, Arial, Helvetica, sans-serif"" size=""1""><u>" & l_comment3 &"</u>: " & rs2("firstname") & " " & rs2("lastname") & " (" & rs2("datemod") & ")" & "<br></font>"
response.write "<font face=""Verdana, Arial, Helvetica, sans-serif"" size=""1"">" & rs2("bild_description_"&session("lang")&"") & "</font>"
response.write "</td></tr>"
rs2.movenext
loop
end if
	  
response.write "</td>"
response.write  "</tr>"
response.write "</table>"
%>
  <SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function popjack1()
 {
  window.open('admin/add_new_comment.asp?id=<% =id %>&category=<% =category %>','popjack1','toolbar=no,location=no,directories=no,status=no,menubar=no,resizable=yes,copyhistory=no,scrollbars=yes,width=200,height=700');
 }
//-->
</script>
  <img src="<% =url %>/bodas/images/flower.gif" align="middle">&nbsp;&nbsp;<A href="JavaScript: popjack1()" onMouseOver="window.status='Status Bar Message'; return true" onMouseOut="window.status=''; return true"><font color="#000000"> 
  <% =l_comment %>
  </font></a><br>
	  <form name="myform" action="index2.asp?lang=<% =session("lang") %>" method=POST>
  <table width="272" border="1">
    <tr>
      <td width="230">
		<font color="blue" size="0" face="Verdana, Arial, Helvetica, sans-serif"><strong><% =stichwortsuche2 %>
        : </strong></font> <input type="Text" name="wortsuche" size="20" value=""> 
        <input name="submit" type="submit" style="font-name: Arial; font-size: 11px; width:12em" class="searchbarb" value="<% =l_buscar2 %>"> 
	  </td>
    </tr>
  </table>
  </form>  
</div>
</body>
</html>