Nuke 7.6 kullanıyorum. Bu siteden sayfa numaralandırmayı indirdim. Çalışıyor fakat bir sorun var. Sayfa numaralandırmayı sadece misafirler görebiliyor. Üye girişi yapıldığında sayfa numaralandırma tablosu görünmüyor ve bütün haberler çıkıyor. Misafir olarak girildiğinde ise hiç bir sorun yok.
News/index.php
Kod:
<php>sql_query("SELECT topictext FROM ".$prefix."_topics WHERE topicid='$new_topic'");
$row_a = $db->sql_fetchrow($result_a);
$numrows_a = $db->sql_numrows($result_a);
$topic_title = stripslashes(check_html($row_a['topictext'], "nohtml"));
OpenTable();
if ($numrows_a == 0) {
echo "<center><font>$sitename</font><br><br>"._NOINFO4TOPIC."<br><br>[ <a href="modules.php?name=News\">"._GOTONEWSINDEX."</a> | <a href="modules.php?name=Topics\">"._SELECTNEWTOPIC."</a> ]</center>";
} else {
echo "<center><font>$sitename: $topic_title</font><br><br>"
."<form action=\"modules.php?name=Search\" method=\"post\">"
."<input>"
.""._SEARCHONTOPIC.": <input> "
."<input>"
."</form>"
."[ <a href="index.php\">"._GOTOHOME."</a> | <a href="modules.php?name=Topics\">"._SELECTNEWTOPIC."</a> ]</center>";
}
CloseTable();
echo "<br>";
}
if ($pagenum == "") { $pagenum = 1 ; }
$offset = ($pagenum-1) * $storynum ;
$result = $db->sql_query("SELECT sid, catid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes, acomm, score, ratings FROM ".$prefix."_stories $qdb $querylang ORDER BY sid DESC limit $offset, $storynum");
while ($row = $db->sql_fetchrow($result)) {
$s_sid = intval($row['sid']);
$catid = intval($row['catid']);
$aid = stripslashes($row['aid']);
$title = stripslashes(check_html($row['title'], "nohtml"));
$time = $row['time'];
$hometext = stripslashes($row['hometext']);
$bodytext = stripslashes($row['bodytext']);
$comments = stripslashes($row['comments']);
$counter = intval($row['counter']);
$topic = intval($row['topic']);
$informant = stripslashes($row['informant']);
$notes = stripslashes($row['notes']);
$acomm = intval($row['acomm']);
$score = intval($row['score']);
$ratings = intval($row['ratings']);
if ($catid > 0) {
$row2 = $db->sql_fetchrow($db->sql_query("SELECT title FROM ".$prefix."_stories_cat WHERE catid='$catid'"));
$cattitle = stripslashes(check_html($row2['title'], "nohtml"));
}
getTopics($s_sid);
formatTimestamp($time);
$subject = stripslashes(check_html($subject, "nohtml"));
$introcount = strlen($hometext);
$fullcount = strlen($bodytext);
$totalcount = $introcount + $fullcount;
$c_count = $comments;
$r_options = "";
if (isset($c o o k i e[4])) { $r_options .= "&mode=$c o o k i e[4]"; }
if (isset($c o o k i e[5])) { $r_options .= "&order=$c o o k i e[5]"; }
if (isset($c o o k i e[6])) { $r_options .= "&thold=$c o o k i e[6]"; }
$story_link = "<a href="modules.php?name=News&file=article&sid=$s_sid$r_options\">";
$morelink = "";
if ($fullcount > 0 OR $c_count > 0 OR $articlecomm == 0 OR $acomm == 1) {
$morelink .= "$story_link<b>"._READMORE."</b></a> - ";
} else {
$morelink .= "";
}
if ($fullcount > 0) { $morelinkkk .= "$totalcountt "; }
if ($articlecomm == 1 AND $acomm == 0) {
if ($c_count == 0) { $morelink .= "$story_link"._COMMENTSQ."</a>"; } elseif ($c_count == 1) { $morelink .= "$story_link$c_count "._COMMENT."</a>"; } elseif ($c_count > 1) { $morelink .= "$story_link$c_count Yorum Eklenmiş...</a>"; }
}
$sid = intval($s_sid);
if ($catid != 0) {
$row3 = $db->sql_fetchrow($db->sql_query("SELECT title FROM ".$prefix."_stories_cat WHERE catid='$catid'"));
$title1 = stripslashes(check_html($row3['title'], "nohtml"));
$title = "<a href="modules.php?name=News&file=categories&op=newindex&catid=$catid\"><font>$title1</font></a>: $title";
$morelink .= " | <a href="modules.php?name=News&file=categories&op=newindex&catid=$catid\">$title1</a>";
}
if ($score != 0) {
$rated = substr($score / $ratings, 0, 4);
} else {
$rated = 0;
}
$morelink .= " $ratedd";
$morelink .= "";
$morelink = str_replace(" | | ", " | ", $morelink);
themeindex($aid, $informant, $datetime, $title, $counter, $topic, $hometext, $notes, $morelink, $topicname, $topicimage, $topictext);
}
#eski.netopsiyon.com Sayfa Numaralandırma
#$limitpn = "limit 100"; # limit number of stories
if(isset($new_topic)) {
$sql_pn = "select * from ".$prefix."_stories where topic='$new_topic' $limitpn";
} else {
$sql_pn = "select * from ".$prefix."_stories where ihome=0 $limitpn";
}
$result_pn = $db->sql_query($sql_pn);
$numstories = $db->sql_numrows($result_pn);
$numpages = ceil($numstories / $storynum);
if ($numpages > 1) {
opentable();
echo "<center><img src=\"modules/News/images/kucukok.gif\" height=\"9\" width=\"10\">  Toplam Haber : <b>$numstories</b> <img src=\"modules/News/images/kucukok.gif\" height=\"9\" width=\"10\">  Toplam Sayfa : <b>$numpages</b> <img src=\"modules/News/images/kucukok.gif\" height=\"9\" width=\"10\">  Her Sayfada : <b>$storynum</b><br>" ;
if ($pagenum > 1) {
$prevpage = $pagenum - 1 ;
$leftarrow = "modules/News/images/sol.gif" ;
if(isset($new_topic)) {
echo "<a href="modules.php?name=News&new_topic=$new_topic&pagenum=$prevpage\">";
echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
} else {
echo "<a href="modules.php?name=News&pagenum=$prevpage\">";
echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
}
}
echo "[ " ;
for ($i=1; $i < $numpages+1; $i++) {
if ($i == $pagenum) {
echo "<b>$i</b>";
} else {
if(isset($new_topic)) {
echo "<a href="modules.php?name=News&new_topic=$new_topic&pagenum=$i\">$i</a>";
} else {
echo "<a href="modules.php?name=News&pagenum=$i\">$i</a>";
}
}
if ($i < $numpages) { echo " | "; } else { echo " ]"; }
}
if ($pagenum </a> 5) { $score = 5; }
if ($score < 1) { $score = 1; }
if ($score != 1 AND $score != 2 AND $score != 3 AND $score != 4 AND $score != 5) {
Header("Location: index.php");
die();
}
if (isset($ratec o o k i e)) {
$rc o o k i e = base64_decode($ratec o o k i e);
$rc o o k i e = addslashes($rc o o k i e);
$r_c o o k i e = explode(":", $rc o o k i e);
}
for ($i=0; $i <sizeof>sql_query("update ".$prefix."_stories set score=score+$score, ratings=ratings+1 where sid='$sid'");
$info = base64_encode("$rc o o k i e$sid:");
setc o o k i e("ratec o o k i e","$info",time()+3600);
update_points(7);
Header("Location: modules.php?name=News&op=rate_complete&sid=$sid$r_options");
}
} else {
include("header.php");
title("$sitename: "._ARTICLERATING."");
OpenTable();
echo "<center>"._DIDNTRATE."<br><br>"
.""._GOBACK."</center>";
CloseTable();
include("footer.php");
}
}
function rate_complete($sid, $rated=0) {
global $sitename, $user, $c o o k i e;
$r_options = "";
if (is_user($user)) {
if (isset($c o o k i e[4])) { $r_options .= "&mode=$c o o k i e[4]"; }
if (isset($c o o k i e[5])) { $r_options .= "&order=$c o o k i e[5]"; }
if (isset($c o o k i e[6])) { $r_options .= "&thold=$c o o k i e[6]"; }
}
include("header.php");
title("$sitename: "._ARTICLERATING."");
OpenTable();
if ($rated == 0) {
echo "<center>"._THANKSVOTEARTICLE."<br><br>"
."[ <a href="modules.php?name=News&file=article&sid=$sid$r_options\">"._BACKTOARTICLEPAGE."</a> ]</center>";
} elseif ($rated == 1) {
echo "<center>"._ALREADYVOTEDARTICLE."<br><br>"
."[ <a href="modules.php?name=News&file=article&sid=$sid$r_options\">"._BACKTOARTICLEPAGE."</a> ]</center>";
}
CloseTable();
include("footer.php");
}
switch ($op) {
default:
theindex($new_topic);
break;
case "rate_article":
rate_article($sid, $score);
break;
case "rate_complete":
rate_complete($sid, $rated);
break;
}
?>
News/categories.php
Kod:
<php>sql_query("update ".$prefix."_stories_cat set counter=counter+1 where catid='$catid'");
if ($pagenum == "") { $pagenum = 1 ; }
$offset = ($pagenum-1) * $storynum ;
$result = $db->sql_query("SELECT sid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes, acomm, score, ratings FROM ".$prefix."_stories where catid='$catid' $querylang ORDER BY sid DESC limit $offset, $storynum");
while ($row = $db->sql_fetchrow($result)) {
$s_sid = intval($row['sid']);
$aid = stripslashes($row['aid']);
$title = stripslashes(check_html($row['title'], "nohtml"));
$time = $row['time'];
$hometext = stripslashes($row['hometext']);
$bodytext = stripslashes($row['bodytext']);
$comments = intval($row['comments']);
$counter = intval($row['counter']);
$topic = intval($row['topic']);
$informant = stripslashes($row['informant']);
$notes = stripslashes($row['notes']);
$acomm = intval($row['acomm']);
$score = intval($row['score']);
$ratings = intval($row['ratings']);
getTopics($s_sid);
formatTimestamp($time);
$subject = stripslashes(check_html($subject, "nohtml"));
$introcount = strlen($hometext);
$fullcount = strlen($bodytext);
$totalcount = $introcount + $fullcount;
$c_count = $comments;
$r_options = "";
if (isset($c o o k i e[4])) { $r_options .= "&mode=$c o o k i e[4]"; }
if (isset($c o o k i e[5])) { $r_options .= "&order=$c o o k i e[5]"; }
if (isset($c o o k i e[6])) { $r_options .= "&thold=$c o o k i e[6]"; }
$story_link = "<a href="modules.php?name=News&file=article&sid=$s_sid$r_options\">";
$morelink = "(";
if ($fullcount > 0 OR $c_count > 0 OR $articlecomm == 0 OR $acomm == 1) {
$morelink .= "$story_link<b>"._READMORE."</b></a> | ";
} else {
$morelink .= "";
}
if ($fullcount > 0) { $morelink .= "$totalcount "._BYTESMORE." | "; }
if ($articlecomm == 1 AND $acomm == 0) {
if ($c_count == 0) { $morelink .= "$story_link"._COMMENTSQ."</a>"; } elseif ($c_count == 1) { $morelink .= "$story_link$c_count "._COMMENT."</a>"; } elseif ($c_count > 1) { $morelink .= "$story_link$c_count "._COMMENTS."</a>"; }
}
if ($score != 0) {
$rated = substr($score / $ratings, 0, 4);
} else {
$rated = 0;
}
$morelink .= " | "._SCORE." $rated";
$morelink .= ")";
$morelink = str_replace(" | | ", " | ", $morelink);
$sid = intval($s_sid);
$row2 = $db->sql_fetchrow($db->sql_query("select title from ".$prefix."_stories_cat where catid='$catid'"));
$title1 = stripslashes(check_html($row2['title'], "nohtml"));
$title = "$title1: $title";
themeindex($aid, $informant, $datetime, $title, $counter, $topic, $hometext, $notes, $morelink, $topicname, $topicimage, $topictext);
}
if ($httpref==1) {
$referer = $_SERVER["HTTP_REFERER"];
if ($referer=="" OR ereg("unknown", $referer) OR eregi($nukeurl,$referer)) {
} else {
$db->sql_query("insert into ".$prefix."_referer values (NULL, '$referer')");
}
$numrows = $db->sql_numrows($db->sql_query("select * from ".$prefix."_referer"));
if($numrows==$httprefmax) {
$db->sql_query("delete from ".$prefix."_referer");
}
}
#START Page Numbers
#$limitpn = "limit 100"; # limit number of stories in categories
$numstories = $db->sql_numrows($db->sql_query("select * from ".$prefix."_stories where catid='$catid' $limitpn"));
$numpages = ceil($numstories / $storynum);
if ($numpages > 1) {
opentable();
echo "<center>$numstories "._STORIES." ($numpages "._PAGES.", $storynum "._PERPAGE.")<br>" ;
if ($pagenum > 1) {
$prevpage = $pagenum - 1 ;
$leftarrow = "images/left.gif" ;
echo "<a href="modules.php?name=News&file=categories&op=newindex&catid=$catid&pagenum=$prevpage\">";
echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
}
echo "[ " ;
for ($i=1; $i < $numpages+1; $i++) {
if ($i == $pagenum) {
echo "<b>$i</b>";
} else {
echo "<a href="modules.php?name=News&file=categories&op=newindex&catid=$catid&pagenum=$i\">$i</a>";
}
if ($i < $numpages) { echo " | "; } else { echo " ]"; }
}
if ($pagenum </a>
#eski.netopsiyon.com Sayfa Numaralandırma
#$limitpn = "limit 100"; # limit number of stories
if(isset($new_topic)) {
$sql_pn = "select * from ".$prefix."_stories where topic='$new_topic' $limitpn";
} else {
$sql_pn = "select * from ".$prefix."_stories where ihome=0 $limitpn";
}
$result_pn = $db->sql_query($sql_pn);
$numstories = $db->sql_numrows($result_pn);
$numpages = ceil($numstories / $storynum);
if ($numpages > 1) {
opentable();
echo "<center><img src=\"modules/News/images/kucukok.gif\" height=\"9\" width=\"10\">  Toplam Haber : <b>$numstories</b> <img src=\"modules/News/images/kucukok.gif\" height=\"9\" width=\"10\">  Toplam Sayfa : <b>$numpages</b> <img src=\"modules/News/images/kucukok.gif\" height=\"9\" width=\"10\">  Her Sayfada : <b>$storynum</b><br>" ;
if ($pagenum > 1) {
$prevpage = $pagenum - 1 ;
$leftarrow = "modules/News/images/sol.gif" ;
if(isset($new_topic)) {
echo "<a href="modules.php?name=News&new_topic=$new_topic&pagenum=$prevpage\">";
echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
} else {
echo "<a href="modules.php?name=News&pagenum=$prevpage\">";
echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
}
}
echo "[ " ;
for ($i=1; $i < $numpages+1; $i++) {
if ($i == $pagenum) {
echo "<b>$i</b>";
} else {
if(isset($new_topic)) {
echo "<a href="modules.php?name=News&new_topic=$new_topic&pagenum=$i\">$i</a>";
} else {
echo "<a href="modules.php?name=News&pagenum=$i\">$i</a>";
}
}
if ($i < $numpages) { echo " | "; } else { echo " ]"; }
}
if ($pagenum </a> 5) { $score = 5; }
if ($score < 1) { $score = 1; }
if ($score != 1 AND $score != 2 AND $score != 3 AND $score != 4 AND $score != 5) {
Header("Location: index.php");
die();
}
if (isset($ratec o o k i e)) {
$rc o o k i e = base64_decode($ratec o o k i e);
$rc o o k i e = addslashes($rc o o k i e);
$r_c o o k i e = explode(":", $rc o o k i e);
}
for ($i=0; $i <sizeof>sql_query("update ".$prefix."_stories set score=score+$score, ratings=ratings+1 where sid='$sid'");
$info = base64_encode("$rc o o k i e$sid:");
setc o o k i e("ratec o o k i e","$info",time()+3600);
update_points(7);
Header("Location: modules.php?name=News&op=rate_complete&sid=$sid$r_options");
}
} else {
include("header.php");
title("$sitename: "._ARTICLERATING."");
OpenTable();
echo "<center>"._DIDNTRATE."<br><br>"
.""._GOBACK."</center>";
CloseTable();
#eski.netopsiyon.com Sayfa Numaralandırma
#$limitpn = "limit 100"; # limit number of stories
if(isset($new_topic)) {
$sql_pn = "select * from ".$prefix."_stories where topic='$new_topic' $limitpn";
} else {
$sql_pn = "select * from ".$prefix."_stories where ihome=0 $limitpn";
}
$result_pn = $db->sql_query($sql_pn);
$numstories = $db->sql_numrows($result_pn);
$numpages = ceil($numstories / $storynum);
if ($numpages > 1) {
opentable();
echo "<center><img src=\"modules/News/images/kucukok.gif\" height=\"9\" width=\"10\">  Toplam Haber : <b>$numstories</b> <img src=\"modules/News/images/kucukok.gif\" height=\"9\" width=\"10\">  Toplam Sayfa : <b>$numpages</b> <img src=\"modules/News/images/kucukok.gif\" height=\"9\" width=\"10\">  Her Sayfada : <b>$storynum</b><br>" ;
if ($pagenum > 1) {
$prevpage = $pagenum - 1 ;
$leftarrow = "modules/News/images/sol.gif" ;
if(isset($new_topic)) {
echo "<a href="modules.php?name=News&new_topic=$new_topic&pagenum=$prevpage\">";
echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
} else {
echo "<a href="modules.php?name=News&pagenum=$prevpage\">";
echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
}
}
echo "[ " ;
for ($i=1; $i < $numpages+1; $i++) {
if ($i == $pagenum) {
echo "<b>$i</b>";
} else {
if(isset($new_topic)) {
echo "<a href="modules.php?name=News&new_topic=$new_topic&pagenum=$i\">$i</a>";
} else {
echo "<a href="modules.php?name=News&pagenum=$i\">$i</a>";
}
}
if ($i < $numpages) { echo " | "; } else { echo " ]"; }
}
if ($pagenum </a> 5) { $score = 5; }
if ($score < 1) { $score = 1; }
if ($score != 1 AND $score != 2 AND $score != 3 AND $score != 4 AND $score != 5) {
Header("Location: index.php");
die();
}
if (isset($ratec o o k i e)) {
$rc o o k i e = base64_decode($ratec o o k i e);
$rc o o k i e = addslashes($rc o o k i e);
$r_c o o k i e = explode(":", $rc o o k i e);
}
for ($i=0; $i <sizeof>sql_query("update ".$prefix."_stories set score=score+$score, ratings=ratings+1 where sid='$sid'");
$info = base64_encode("$rc o o k i e$sid:");
setc o o k i e("ratec o o k i e","$info",time()+3600);
update_points(7);
Header("Location: modules.php?name=News&op=rate_complete&sid=$sid$r_options");
}
} else {
include("header.php");
title("$sitename: "._ARTICLERATING."");
OpenTable();
echo "<center>"._DIDNTRATE."<br><br>"
.""._GOBACK."</center>";
CloseTable();
Bu forumda yeni başlıklar açamazsınız Bu forumdaki başlıklara cevap veremezsiniz Bu forumdaki mesajlarınızı değiştiremezsiniz Bu forumdaki mesajlarınızı silemezsiniz Bu forumdaki anketlerde oy kullanamazsınız