From dac1084f318dc1d0c5c0004448caf236ea673d51 Mon Sep 17 00:00:00 2001
From: Stephan Poehlsen <stephan@poehlsen.net>
Date: Tue, 14 Aug 2007 18:08:19 +0000
Subject: Keine Ahnung was das hier ist, ist sau alt

git-svn-id: file:///home/lennart/svn/public/sse/trunk@82 5fbabb74-0606-0410-a5e4-b5cc6a42724e
---
 www/index.php | 8 ++++----
 www/style.xsl | 2 +-
 2 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/www/index.php b/www/index.php
index b62c80e..0cc24b3 100644
--- a/www/index.php
+++ b/www/index.php
@@ -125,7 +125,7 @@ while ($q) {
   }
 
 
-  $sql = "SELECT SQL_CALC_FOUND_ROWS COUNT(*)/COUNT(DISTINCT pr.id) AS keywords_cnt, ".
+  $sql = "SELECT COUNT(*)/COUNT(DISTINCT pr.id) AS keywords_cnt, ".
     " SUM(w.cnt)/COUNT(DISTINCT pr.id) AS cnt, " .
     " f.path, f.language_id, pr.id AS prid, pr.name AS package_name ".
     " FROM word AS w, file AS f, package AS p, provider_record AS pr ".
@@ -155,7 +155,7 @@ while (isset($sql) and $sql) {
     break;
   }
 
-  $res2 = mysql_query("SELECT FOUND_ROWS() AS cnt");
+  $res2 = mysql_query("SELECT COUNT(*) AS cnt FROM word AS w WHERE ".$where);
   if ($r2 = mysql_fetch_array($res2)) {
     $total = $r2['cnt'];
   }
@@ -182,7 +182,7 @@ $max_start = ($max_page-1)*$num;
 
 if ($total) {
 
-  echo('<p>Results: <span id="results_total">'.$total."</span></p>\n".
+  echo('<p>Results: ca. <span id="results_total">'.$total."</span></p>\n".
        '<ul class="results" id="result_list">'."\n");
 
   while ($r = mysql_fetch_array($res)) {
@@ -219,7 +219,7 @@ if ($max_page > 1) {
   }
 
   echo(($start < $max_start ? '<li><a id="browse_next" href="'.$l.min($max_start, $start+$num).'">next</a>'."</li>\n" : '').
-       ($start < $max_start ? '<li><a id="browse_last" href="'.$l.$max_start.'">last</a>'."</li>\n" : '').
+       //($start < $max_start ? '<li><a id="browse_last" href="'.$l.$max_start.'">last</a>'."</li>\n" : '').
        "</ul>\n");
 
 }
diff --git a/www/style.xsl b/www/style.xsl
index dd23d0a..43bbd05 100644
--- a/www/style.xsl
+++ b/www/style.xsl
@@ -20,7 +20,7 @@
 
          <xsl:if test="number(id(&quot;results_total&quot;)) > 0">
 
-           <div class="n_hits"><xsl:value-of select="id(&quot;results_total&quot;)"/> hits.</div>
+           <div class="n_hits">ca. <xsl:value-of select="id(&quot;results_total&quot;)"/> hits.</div>
 
            <xsl:for-each select="id(&quot;result_list&quot;)/html:li">
              <div class="hit">
-- 
cgit