filen openpic.asp er her:
<%
dim ID
ID = REQUEST.QUERYSTRING("ID")
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
strDNS = "driver={MySQL};server=mysql5.123hotel.dk;uid=vibytomrer;pwd=cc6e026b;database=vibytomrer_dk_db"
set Rs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM VT_GALLERY_CONTENT WHERE GALLERY_CONTENT_ID = " & ID & " ORDER BY GALLERY_CONTENT_SORTBY ASC"
Rs.Open strSQL, strDNS
DESC = RS("GALLERY_CONTENT_DESC")
C_ID = RS("GALLERY_ID")
PIC = RS("GALLERY_CONTENT_PIC")
set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM VT_GALLERY WHERE GALLERY_ID = " & C_ID
Rs.Open strSQL, strDNS
Gal_Name = RS("GALLERY_NAME")
set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM VT_GALLERY_CONTENT WHERE GALLERY_ID = " & C_ID & " ORDER BY GALLERY_CONTENT_SORTBY ASC"
Rs.CursorLocation = 3
Rs.Open strSQL, strDNS, 1
rs.Find "GALLERY_CONTENT_ID=" & ID
pos = rs.AbsolutePosition
IF NOT RS.BOF THEN
RS.moveprevious
END IF
IF NOT RS.BOF THEN
L_ID = RS("GALLERY_CONTENT_ID")
ELSE
RS.MOVELAST
L_ID = RS("GALLERY_CONTENT_ID")
END IF
RS.CLOSE
SET RS = NOTHING
set rs2 = Server.CreateObject("ADODB.Recordset")
strSQL2 = "SELECT * FROM VT_GALLERY_CONTENT WHERE GALLERY_ID = " & C_ID & " ORDER BY GALLERY_CONTENT_SORTBY ASC"
Rs2.CursorLocation = 3
Rs2.Open strSQL2, strDNS, 1
rs2.Find "GALLERY_CONTENT_ID=" & ID
pos = rs2.AbsolutePosition
IF NOT RS2.EOF THEN
RS2.MOVENEXT
ELSE
RS2.MOVEFIRST
N_ID = RS2("GALLERY_CONTENT_ID")
END IF
IF NOT RS2.EOF THEN
N_ID = RS2("GALLERY_CONTENT_ID")
ELSE
RS2.MOVEFIRST
N_ID = RS2("GALLERY_CONTENT_ID")
END IF
RS2.CLOSE
SET RS2 = NOTHING
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Galleri - <%=Gal_Name%></title>
<script>
<%
IF REQUEST.QUERYSTRING("MODE") <> "" THEN
%>
setTimeout( "self.location.href='openpic.asp?ID=<%=N_ID%>&mode=dias';", 10*1000 );
<%
END IF
%>
var ns4 = (document.layers)?true:false;
var ns6 = (document.getElementById && !document.all)?true:false;
var bredde = 602
var hojde = 570
self.moveTo(0,0)
if (ns4) {
self.resizeTo(bredde,hojde);
} else if (ns6) {
self.resizeTo(bredde,hojde);
} else {
self.resizeTo(bredde,hojde);
};
var bredde2 = ((screen.width-bredde)/2)
var hojde2 = ((screen.height-hojde)/2)
self.moveTo(bredde2, hojde2)
var nytWin2 = null;
function bigPic( url ) {
if ( nytWin2 && !nytWin2.closed ) { // hvis vinduet allerede er der
nytWin2.location.href = url; // ny side til eksisterende vindue
if ( nytWin2.focus ) nytWin2.focus(); // hiver det existerende vindue op foran
} else {
nytWin2 = window.open( url, "Planlosning", "location=no,menubar=no,toolbar=no,resizable=no,scrollbars=no" + ",height=477,width=602");
}
};
</script>
<link rel="STYLESHEET" type="text/css" href="css/style.css">
</head>
<body bgcolor="#fafafa" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" marginheight="0" marginwidth="0">
<table class="text" width="100%" height="100%" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="f5f5f5" colspan="3" height="450px" valign="top" align="center"><img src="galleri/<%=PIC%>"></td>
</tr>
<tr>
<td colspan="3" width="100%" bgcolor="fafafa" height="5px"></td>
</tr>
<tr>
<td width="200" align="left" valign="top">
<table class='text' align="left" border="0">
<tr align="left">
<td style='width:20px'"> </td>
<%
IF REQUEST.QUERYSTRING("MODE") <> "" THEN
RESPONSE.WRITE "<td><a href='java script:window.close();'><img alt='Luk vinduet' src='pic/popupClose.gif') border='0'></a></td>"
RESPONSE.WRITE "<td><a href='openpic.asp?ID="&ID&"&mode=dias'><img alt='Start dias show' src='pic/dias.gif' border='0'></a></td>"
RESPONSE.WRITE "<td><a href='openpic.asp?ID="&ID&"'><img alt='Stop dias show' src='pic/diaspause.gif' border='0'></a></td>"
RESPONSE.WRITE "<td><a href='openpic.asp?ID="&L_ID&"&mode=dias'><img alt='Gå til forrige billede' src='pic/popupLeftArrow.gif' border='0'></a></td>"
RESPONSE.WRITE "<td><a href='openpic.asp?ID="&N_ID&"&mode=dias'><img alt='Gå til næste billede' src='pic/popupRightArrow.gif' border='0'></a></td>"
ELSE
RESPONSE.WRITE "<td><a href='java script:window.close();'><img alt='Luk vinduet' src='pic/popupClose.gif') border='0'></a></td>"
RESPONSE.WRITE "<td><a href='openpic.asp?ID="&ID&"&mode=dias'><img alt='Start dias show' src='pic/dias.gif' border='0'></a></td>"
RESPONSE.WRITE "<td><a href='openpic.asp?ID="&L_ID&"'><img alt='Gå til forrige billede' src='pic/popupLeftArrow.gif' border='0'></a></td>"
RESPONSE.WRITE "<td><a href='openpic.asp?ID="&N_ID&"'><img alt='Gå til næste billede' src='pic/popupRightArrow.gif' border='0'></a></td>"
END IF
%>
</tr>
</table>
</td>
<td> </td>
<td width="350" valign="top">
<%=DESC%>
</td>
</tr>
</table>
</body>
</html>
Slettet bruger
Ny bruger
Nybegynder
Opret
Preview
