dl_search.asp dosyası güncellenmiş kodları.
<%
'<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
'<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
'<> Copyright (C) 2004-2005 Ken Smiley (PCAKen) All Rights Reserved
'<>
'<> By using this program, you are agreeing to the terms of the
'<> GNU General Public License.
'<>
'<> This program is free software; you can redistribute it and/or
'<> modify it under the terms of the GNU General Public License
'<> as published by the Free Software Foundation; either version 2
'<> of the License, or any later version.
'<>
'<> All copyright notices regarding MaxWebPortal must remain intact
'<> in the scripts and in the outputted HTML.
'<> The "powered by" text/logo with a link back to
'<> http://www.maxwebportal.info in the footer of the pages MUST
'<> remain visible when the pages are viewed on the internet or intranet.
'<>
'<> Support can be obtained from support forums at:
'<> http://www.maxwebportal.info
'<>
'<> Email: maxweb@maxwebportal.info
'<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
'<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
'***********************************************************************
'** Copyright (C) 2001 - 2004 Max Yuan All Rights Reserved
'**
'** By using this program, you are agreeing to the terms of the
'** GNU General Public License.
'**
'** This program is free software; you can redistribute it and/or
'** modify it under the terms of the GNU General Public License
'** as published by the Free Software Foundation; either version 2
'** of the License, or any later version.
'**
'** All copyright notices regarding MaxWebPortal must remain intact
'** in the scripts and in the outputted HTML.
'** The "powered by" text/logo with a link back to
'** http://www.maxwebportal.com in the footer of the pages MUST
'** remain visible when the pages are viewed on the internet or intranet.
'**
'** Support can be obtained from support forums at:
'** http://www.maxwebportal.com
'**
'** Email: maxwebportal@hotmail.com
'** ICQ: 148111300
'** Türkçeye Çeviren OgReTmEnLeRiM.NeT | Bülent KARAYAZI
'***********************************************************************
CurPageType = "Download-Dosyalar"
CurPageInfoChk = "1"
function CurPageInfo ()
strOnlineQueryString = ChkActUsrUrl(Request.QueryString)
PageName = "Arıyor"
PageAction = "Dosya<br>"
PageLocation = "dl_search.asp"
CurPageInfo = PageAction & " " & "<a href=" & PageLocation & ">" & PageName & "</a>"
end function
%>
<!-- #INCLUDE FILE="config.asp" -->
<!-- #INCLUDE FILE="inc_functions.asp" -->
<!-- #INCLUDE FILE="dl_functions.asp" -->
<!-- #INCLUDE FILE="inc_top.asp" -->
<!-- #INCLUDE FILE="inc_ADOVBS.asp" -->
<%
search = ChkString(Request("search"), "SQLString")
show = Request("num")
mwpThemeTableCustomCode = " border=""1"" cellpadding=""0"" cellspacing=""0"" style=""border-collapse: collapse"" align=""center"" width=""99%"""
mwpThemeSmallBlock_open()%>
<tr>
<td width="100%"><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<img src="Images/nav_icon.gif" align="absbottom" border="0"> <a href="default.asp">Ana Sayfa</a> >> <a href="dl.asp">Download</a> >> Arama Sonuçları: <%= search %>
</font></td>
</tr>
<%mwpThemeSmallBlock_close()%><br>
<table border="0" width="99%" align="center">
<tr>
<td width="180" valign="top"><!-- #include file="dl_menu.asp" --></td>
<td width="100%" valign="top">
<%
mwpThemeBlock_open()
response.write "<br><tr><td align=""left"">"
if show = "10" then
strSQL = "select * from DL where Keyword like'%" & search & "%' or DESCRIPTION like '%" & search & "%' and show=1 order by DL_ID DESC"
Dim iPageSize
Dim iPageCount
Dim iPageCurrent
Dim strOrderBy
Dim strSQL
Dim objPagingConn
Dim objPagingRS
Dim iRecordsShown
Dim I
iPageSize = 10
'set page size
If Request.QueryString("page") = "" Then
iPageCurrent = 1
Else
iPageCurrent = CInt(Request.QueryString("page"))
End If
If Request.QueryString("order") = "" Then
strOrderBy = "DL_id"
Else
strOrderBy = Request.QueryString("order")
End If
Set objPagingRS = Server.CreateObject("ADODB.Recordset")
objPagingRS.PageSize = iPageSize
objPagingRS.CacheSize = iPageSize
objPagingRS.Open strSQL, my_Conn, adOpenStatic, adLockReadOnly, adCmdText
reccount = objPagingRS.recordcount
iPageCount = objPagingRS.PageCount
If iPageCurrent > iPageCount Then iPageCurrent = iPageCount
If iPageCurrent < 1 Then iPageCurrent = 1
If iPageCount = 0 Then
Response.Write "<center><font color=red size=3>Kayıt bulunamadı!</font></center>"
Else
objPagingRS.AbsolutePage = iPageCurrent
%>
<center><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>+1"><b>Arama Sonuçları: </b></font><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>+1" color="#FF0000"><%=reccount%><% if reccount = 1 then %> dosyada<% else %> dosyada<% end if %><b> <%=search%></b></font><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>" color="#FF0000"> bulundu </center>
<%
iRecordsShown = 0
Do While iRecordsShown < iPageSize And Not objPagingRS.EOF
dagar=DateDiff("d", Date, strtodate(objPagingRS("post_Date")))+7
strDescription = objPagingRS("DESCRIPTION")
strDLName = objPagingRS("NAME")
intDLID = objPagingRS("DL_ID")
intHit = objPagingRS("HIT")
strPostDate = strtodate(objPagingRS("POST_DATE"))
dateSince=DateDiff("d", Date(), strPostDate)+7
call displayDL()
iRecordsShown = iRecordsShown + 1
objPagingRS.MoveNext
Loop
%>
<%
End If
objPagingRS.Close
Set objPagingRS = Nothing
If iPageCurrent <> 1 Then
%>
<a HREF="DL_search.asp?page=<%= iPageCurrent - 1 %>&order=<%= Server.URLEncode(strOrderBy) %>&search=<%=search%>&num=<%=show%>"><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>">Önceki</font></a>
<%
End If
If iPageCurrent < iPageCount Then
%>
<a HREF="DL_search.asp?page=<%= iPageCurrent + 1 %>&order=<%= Server.URLEncode(strOrderBy) %>&search=<%=search%>&num=<%=show%>"><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>">Sonraki</font></a>
</center>
<%
End If
%>
<center>
<font face="<%= strDefaultFontFace %>" size="<%= strFooterFontSize %>">Sayfa <b><%= iPageCurrent %></b> / <b><%= iPageCount %></b> </font>
</center>
<%
else
if show = "20" then
strSQL = "select * from DL where Keyword like'%" & search & "%' or DESCRIPTION like '%" & search & "%' and show=1 order by DL_ID DESC"
iPageSize = 20
'set page size
If Request.QueryString("page") = "" Then
iPageCurrent = 1
Else
iPageCurrent = CInt(Request.QueryString("page"))
End If
If Request.QueryString("order") = "" Then
strOrderBy = "DL_id"
Else
strOrderBy = Request.QueryString("order")
End If
Set objPagingRS = Server.CreateObject("ADODB.Recordset")
objPagingRS.PageSize = iPageSize
objPagingRS.CacheSize = iPageSize
objPagingRS.Open strSQL, my_Conn, adOpenStatic, adLockReadOnly, adCmdText
reccount = objPagingRS.recordcount
iPageCount = objPagingRS.PageCount
If iPageCurrent > iPageCount Then iPageCurrent = iPageCount
If iPageCurrent < 1 Then iPageCurrent = 1
If iPageCount = 0 Then
Response.Write "<center><font color=red size=3>Kayıt bulunamadı!</font></center>"
Else
objPagingRS.AbsolutePage = iPageCurrent
%>
<center><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>+1"><b>Arama Sonuçları: </b></font><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>+1" color="#FF0000"><%=reccount%><% if reccount = 1 then %> dosyada<% else %> dosyada<% end if %><b> <%=search%></b></font><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>" color="#FF0000"> bulundu</font></center>
<%
iRecordsShown = 0
Do While iRecordsShown < iPageSize And Not objPagingRS.EOF
dagar=DateDiff("d", Date, strtodate(objPagingRS("post_Date")))+7
strDescription = objPagingRS("DESCRIPTION")
strDLName = objPagingRS("NAME")
intDLID = objPagingRS("DL_ID")
intHit = objPagingRS("HIT")
strPostDate = strtodate(objPagingRS("POST_DATE"))
dateSince=DateDiff("d", Date(), strPostDate)+7
call displayDL()
iRecordsShown = iRecordsShown + 1
objPagingRS.MoveNext
Loop
%>
<%
End If
objPagingRS.Close
Set objPagingRS = Nothing
If iPageCurrent <> 1 Then
%>
<a HREF="dl_search.asp?page=<%= iPageCurrent - 1 %>&order=<%= Server.URLEncode(strOrderBy) %>&search=<%=search%>&num=<%=show%>"><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>">Önceki</font></a>
<%
End If
If iPageCurrent < iPageCount Then
%>
<a HREF="dl_search.asp?page=<%= iPageCurrent + 1 %>&order=<%= Server.URLEncode(strOrderBy) %>&search=<%=search%>&num=<%=show%>"><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>">Sonraki</font></a>
</center>
<%
End If
%>
<center>
<font face="<%= strDefaultFontFace %>" size="<%= strFooterFontSize %>">Sayfa <b><%= iPageCurrent %></b> / <b><%= iPageCount %></b> </font>
</center>
<%
else
if show = "30" then
strSQL = "select * from DL where Keyword like'%" & search & "%' or DESCRIPTION like '%" & search & "%' and show=1 order by DL_ID DESC"
iPageSize = 30
'set page size
If Request.QueryString("page") = "" Then
iPageCurrent = 1
Else
iPageCurrent = CInt(Request.QueryString("page"))
End If
If Request.QueryString("order") = "" Then
strOrderBy = "DL_ID"
Else
strOrderBy = Request.QueryString("order")
End If
Set objPagingRS = Server.CreateObject("ADODB.Recordset")
objPagingRS.PageSize = iPageSize
objPagingRS.CacheSize = iPageSize
objPagingRS.Open strSQL, my_Conn, adOpenStatic, adLockReadOnly, adCmdText
reccount = objPagingRS.recordcount
iPageCount = objPagingRS.PageCount
If iPageCurrent > iPageCount Then iPageCurrent = iPageCount
If iPageCurrent < 1 Then iPageCurrent = 1
If iPageCount = 0 Then
Response.Write "<center><font color=red size=3>Kayıt bulunamadı!</font></center>"
Else
objPagingRS.AbsolutePage = iPageCurrent
%>
<center><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>+1"><b>Arama Sonuçları:</b></font><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>+1" color="#FF0000"> <%=reccount%><% if reccount = 1 then %> dosyada<% else %> dosyada<% end if %><b> <%=search%></b></font><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>" color="#FF0000"> bulundu</center>
<%
iRecordsShown = 0
Do While iRecordsShown < iPageSize And Not objPagingRS.EOF
dagar=DateDiff("d", Date, strtodate(objPagingRS("post_Date")))+7
strDescription = objPagingRS("DESCRIPTION")
strDLName = objPagingRS("NAME")
intDLID = objPagingRS("DL_ID")
intHit = objPagingRS("HIT")
strPostDate = strtodate(objPagingRS("POST_DATE"))
dateSince=DateDiff("d", Date(), strPostDate)+7
call displayDL()
iRecordsShown = iRecordsShown + 1
objPagingRS.MoveNext
Loop
%>
<%
End If
objPagingRS.Close
Set objPagingRS = Nothing
If iPageCurrent <> 1 Then
%>
<a HREF="dl_search.asp?page=<%= iPageCurrent - 1 %>&order=<%= Server.URLEncode(strOrderBy) %>&search=<%=search%>&num=<%=show%>"><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>">Önceki</font></a>
<%
End If
If iPageCurrent < iPageCount Then
%>
<a HREF="dl_search.asp?page=<%= iPageCurrent + 1 %>&order=<%= Server.URLEncode(strOrderBy) %>&search=<%=search%>&num=<%=show%>"><font face="<%= strDefaultFontFace %>" size="<%= strDefaultFontSize %>">Sonraki</font></a>
</center>
<%
End If
%>
<center>
<font face="<%= strDefaultFontFace %>" size="<%= strFooterFontSize %>">Sayfa <b><%= iPageCurrent %></b> / <b><%= iPageCount %></b> </font>
</center>
<%
end if
end if
end if
response.write "</td></tr>"
mwpThemeBlock_close()
%>
</td>
</tr>
</table>
<!-- #INCLUDE FILE="dl_affiliates.asp" -->
<!-- #INCLUDE FILE="inc_footer.asp" -->