Bugün asp sıkıntı sorunu yaşıyorum ve ikinci sıkıntı çektiğim konu Sayfalama yaparken içerikler hep yan yana gidiyor. Aşağı doğru dosyaları indiremiyorum. Mesela sağa doğru 5 aşağı doğru 6 olacak şekilde bir kategori sayfası var onu yapamıyorum..
Yardımcı olursanız sevinirim.. kat.asp aşağıdadır. (seo uyumlu)
<% @Language = "VBScript" Codepage="1254" %>
<!--#include file="inc_ayarlar.asp"-->
<!--#include file="inc_fonksiyonlar.asp"-->
<%
Response.Buffer = True
Response.Expires = -1
Response.ExpiresAbsolute = Now() - 2
Response.AddHeader "pragma","no-cache"
Response.AddHeader "cache-control","private"
Response.CacheControl = "No-Store"
%>
<!--#include file="baglan.asp"-->
<%
id= Request.QueryString("id")
Set oyun = Server.CreateObject("ADODB.Recordset")
sor = "Select * from kat where kat_id like '" & id & "'"
oyun.Open sor,Baglanti,1,3
%>
<html>
<head>
<title><%=oyun("kat_adi") %></title>
<meta name="keywords" content="<%=oyun("kat_adi") %>, <%=oyun("kat_adi") %> videosu, <%=oyun("kat_adi") %> videolar, <%=oyun("kat_adi") %> video izle, <%=oyun("kat_adi") %> video seyret">
<META NAME="description" CONTENT="<%=oyun("kat_adi") %> videoları en iyi görüntü ve <%=oyun("kat_adi") %> videoları sadece videolar1.org'da"/>
<META NAME="DC.Subject" CONTENT="videolar">
<META NAME="DC.Creator" CONTENT="videolar">
<meta name="googlebot" content="All">
<meta name="robots" content="All">
<META NAME="distribution" CONTENT="global">
<META NAME="rating" CONTENT="general">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1254">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
<meta http-equiv="Content-Language" content="tr">
<meta http-equiv="Copyright" CONTENT="Copyright © 2008 sizeders">
<meta http-equiv="Reply-to" CONTENT="noertz@gmail.com">
<meta name="Author" CONTENT="oyunlar - noertz@gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=">
<link rel="stylesheet" href="mrkz.css" type="text/css" media="screen" />
</head>
<BODY leftMargin=0 rightMargin=0 topMargin=0 marginheight="0" link="#0099CC" vlink="#0099CC" alink="#24ADFF">
<!--webbot bot="HTMLMarkup" startspan --><script language="javaScript">
<!--
function openWindow(URL){
newWindow = window.open(URL,"xxx", "height=500,width=520,scrollbars=yes,status=no,too lbar=no,hotkeys=no,locationbar=no,fullscreen=0,res izable=0");
newWindow.moveTo(screen.availWidth/2-400,screen.availHeight/2-250);
newWindow.focus();
}
function MM_checkBrowser(NSvers,NSpass,NSnoPass,IEvers,IEpass,IEnoPass,OBpass,URL,altURL) { //v4.0
var newURL='', verStr=navigator.appVersion, app=navigator.appName, version = parseFloat(verStr);
if (app.indexOf('Netscape') != -1) {
if (version >= NSvers) {if (NSpass>0) newURL=(NSpass==1)?URL:altURL;}
else {if (NSnoPass>0) newURL=(NSnoPass==1)?URL:altURL;}
} else if (app.indexOf('Microsoft') != -1) {
if (version >= IEvers || verStr.indexOf(IEvers) != -1)
{if (IEpass>0) newURL=(IEpass==1)?URL:altURL;}
else {if (IEnoPass>0) newURL=(IEnoPass==1)?URL:altURL;}
} else if (OBpass>0) newURL=(OBpass==1)?URL:altURL;
if (newURL) { openWindow(unescape(newURL)); document.MM_returnValue=false; }
}
//-->
</script><!--webbot bot="HTMLMarkup" endspan -->
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="999" height="55">
<tr>
<td width="100%" background="images/header-bg.png" height="134">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" height="100%">
<tr>
<td width="39%">
<img border="0" src="images/logo.gif"></td>
<td width="61%" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%">
<p align="right"><A href="javascript:history.go(0)" onClick="javascript:this.style.behavior='url(#default#homepage)';this.setHomePage('http://www.3doyunoyna.net');" TARGET="_self"><img border="0" src="images/20.gif"></a>
</SCRIPT>
<a href="javascript:window.external.AddFavorite('http://www.3doyunoyna.net','3doyunoyna.net - 3d oyunlar');">
<img border="0" src="images/14.gif"></a> <a href="rss.asp">
<img border="0" src="images/31.gif"></a> <a href="rss2.asp">
<img border="0" src="images/32.gif"></a> <a href="rss3.asp">
<img border="0" src="images/33.gif"></a>
</td>
</tr>
<tr>
<td width="100%" align="center">
<p align="center"><br>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="999">
<tr>
<td width="100%" background="images/mbg.gif" height="55">
<p align="center"><!--#include file="menu.asp"--></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="999" height="51">
<tr>
<td width="100%" height="51">
<div align="center">
<center>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FFCC00" width="980" height="30" bgcolor="#FFFFCC">
<tr>
<td width="100%"> <font face="Verdana" style="font-size: 9pt"><b><img border="0" src="images/bar.gif">
<font color="#666666">Videolar1.org Duyuru :</font> Türkiye'nin En
Geniş içerikli <font color="#FF0066">Video</font> Sitesine<font color="#0099CC">
</font><font color="#0066CC">Kayıt Olun</font>.</b></font></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="999">
<tr>
<td width="100%" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="66%" valign="top">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="99%">
<tr>
<td width="100%"><img border="0" src="images/v5.gif"></td>
</tr>
<tr>
<td width="100%" valign="top" align="center">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<%
id = Temizle(Trim(request.querystring("id")))
If id = "" OR isNumeric(id) = False Then
response.redirect "default.asp"
End If
Set Rec = Server.CreateObject("ADODB.Recordset")
sql = "Select * from oyunlar where oyun_kati=" & id & " order by oyun_id DESC"
Rec.Open sql,Conn,1,3
adet = Rec.recordcount
if Rec.eof or Rec.bof then
Response.Write " <center><br><br>Bu Kategoride Şu Anda oyun Bulunmuyor, Daha Sonra Tekrar Deneyiniz,<br> Teşekkürler....</center>"
Else
shf = Request.QueryString("shf")
if shf="" then
shf=1
else
shf = CINT(Request.QueryString("shf"))
end if
Rec.pagesize = 10
Rec.absolutepage = shf
sayfa = Rec.pagecount
for i=1 to Rec.pagesize
if Rec.EOF then exit for
%>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="5%" style="border-bottom: 1px solid #0099CC"> <img border="0" src="<%=Rec("oyun_resmi") %>" width="47" height="52"></td>
<td width="89%" style="border-bottom: 1px solid #0099CC"><b><i>
<font face="Trebuchet MS" color="#0099cc" size="3"> <a href="videoizle.asp?id=<%=Rec("oyun_id") %>" style="text-decoration: none"><%=Rec("oyun_adi") %></a></font></i></b><br>
<font face="Arial" size="2"> <a title="<%=Rec("oyun_kat_adi") %>" href="http://www.videolar1.org/kategori.asp?id=<%=Rec("oyun_kati") %>" style="text-decoration: none">
<%=Rec("oyun_kat_adi") %></a> Kategorisi</font></td>
<td width="6%" style="border-bottom: 1px solid #0099CC"><a href="videoizle.asp?id=<%=Rec("oyun_id") %>"><img border="0" src="images/small-sq-play.png"></a></td>
</tr>
</table>
<%
Rec.movenext
next
%>
</table><br><b><font face="Verdana" size="2">
<%
for y=1 to sayfa
if shf = y then
response.write " [ "&y&" ] "
else
response.write "<a style=""text-decoration: none"" href=""kategori.asp?id="&id&"&shf="&y&"""> [ "&y&" ] </a>"
end if
Next
response.write "</p>"
Rec.Close
Set Rec = Nothing
Conn.Close
Set Conn = Nothing
End If
%> </font></b>
</td>
</tr>
</table>
</center>
</div>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%"><img border="0" src="images/sponsor.gif"></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%">
<p align="center"><!--#include file="hitlist.asp"--></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="34%" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%">
<p align="center">
</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%" valign="top">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%"><!--#include file="site_ekle.asp"--></td>
</tr>
</table>
</center>
</div>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="325" height="260" background="images/ybg.gif">
<tr>
<td width="100%">
<p align="center"><!--#include file="adsense.asp"--></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
<div align="center" style="width: 340; height: 322">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="98%">
<tr>
<td width="100%" valign="top"><img border="0" src="images/uye.gif"></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="325" height="260">
<tr><form action="http://groups.google.com/group/oyunlar1/boxsubscribe" target="_blank">
<td width="100%" background="images/ybg.gif" valign="top">
<p align="center"><br>
<img border="0" src="images/45.gif"> <font size="1" face="Verdana">
Sadece Mail Adresinizle Kayıt Olun.<br>
<br>
Yeni oyunları İLK siz izleyin öne geçin.<br>
<br>
Kayıtlar <b>Ücretsizdir<br>
</b></font><div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="289" height="58" background="images/mailbar.gif">
<tr>
<td width="100%">
<p align="center"><font size="4">
<input border="0" name="email" size="28" style="border:1px solid #FFFFFF; font-size: 14pt"></font></td>
</tr>
</table>
</center>
</div>
<p align="center">
<input type="image" hspace="5" src="images/kayit.gif" border="0" name="submit">
</td>
</tr>
</table>
</center>
</div>
</FORM>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%" valign="top">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="98%">
<tr>
<td width="100%" valign="top"><img border="0" src="images/arananlar.gif"></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="325" height="260" background="images/ybg.gif">
<tr>
<td width="100%" valign="top">
<p align="center"><br>
<!--#include file="tags.asp"--><br>
</td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="100%"><!--#include file="altkisim.asp"--></td>
</tr>
</table>
</center>
</div>
</body>
</html>