Suche

[gg]

Hallo, liebe Entwickler und User,

es geht um das Immobilien-Modul auf warp-speed von 2002 für Nuke 5.5 als deutsche Überarbeitung von Michael Post mit lang-files. Habe dieses Modul soweit allein eingebaut bekommen, scheitere aber am Aufruf unter "Immobilienliste" "Alle Immobilien anzeigen" 
in der Datei "modules.php?op=modload&name=immobilien&file=browse"
wo an der Stelle der aus der DB auszulesenden Daten 2 mysql-Fehlermeldungen ausgegeben werden.

Ich habe dann noch das Original-Immomodul installiert, was auf die gleichen DB-Tabellen zugreift, aus dem heraus die Anpassung von diesem Michael gemacht wurde (Keinerlei Hinweis in den Dateien, wie und wo man Ihn kontaktieren könnte, auch nicht bei  warp-speed).

Dort steht der code eigentlich gleich, erstaunlicher Weise läuft das ohne Fehlermeldung, ist aber leider komplett im Quellcode mit englishem Text.

Wie ich euch bisher kennenlernen durfte, ist das wieder nur ein klitzekleiner Fehler und für Euch Profis schon beim Blßen "Drüberschauen" ersichtlich!

Wäre echt toll, wenn Ihr mir helfen könntet, dafür danke....

Quellcode der Überarbeitung

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\xampp\htdocs\mx1\modules\immobilien\propview.php on line 32
Es sind Objekte in den Kategorien

[ Sortieren nach:   Preis  Meistbesucht  Betten  Bäder  Stadt  Größe ]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\xampp\htdocs\mx1\modules\immobilien\propview.php on line 86

Zeile 26 bis Zeile 88

//spit out listings for multiple properties
   function makelisting($querystring, $link, $guidestring, $cur_page, $properties_per_page, $sort)
      {
      if ($sort == "") {$sort = "price DESC";}
      $querystring = "SELECT * FROM ".$prefix."_homes ORDER BY $sort";
      $result = mysql_query('$querystring;',$link);
      $num_rows = mysql_num_rows($result);
      $page_num = $cur_page + 1;
      $total_num_page = ceil($num_rows/$properties_per_page);
      $module_name = basename(dirname(__FILE__));
      print "<Center>";
      if ($num_rows == "1") {Print "" . _ONELIST . "<BR>";}
      else {Print "" . _OBJEKTE . " $num_rows " . _OBJEKTE3 . "<BR>";}
      if ($total_num_page != 0)
         {
         Print "" . _SEITEN . " $page_num " . _SEITEN2 . " $total_num_page.<BR>";
         $prevpage = $cur_page-1;
         $nextpage = $cur_page+1;
         if ($page_num != 1){print "<a href=\"modules.php?op=modload&name=$module_name&file=propview&$guidestring&cur_page=$prevpage&sort=$sort\">" . _VSEITE . "</a>     ";}
         if ($page_num != $total_num_page){print "  <a href=\"modules.php?op=modload&name=$module_name&file=propview&$guidestring&cur_page=$nextpage&sort=$sort\">" . _NSEITE . "</a>     ";}
         }
      if ($total_num_page > 1)
              {
              print "<FORM name=pagejump_top>";
            Print "<SELECT NAME=\"selectpage\" onChange=\"window.location.href=document.pagejump_top.selectpage.options[document.pagejump_top.selectpage.selectedIndex].value\">  ";
               Print "<OPTION VALUE=\"modules.php?op=modload&name=$module_name&file=propview&$guidestring&cur_page\" SELECTED>" . _JSEITE . " ";
               for ($counter=0; $counter<=$total_num_page-1; $counter++)
                  {
                  $page_jump = $counter +1;
                  print "<OPTION VALUE=\"modules.php?op=modload&name=$module_name&file=propview&$guidestring&cur_page=$counter&sort=$sort\">" . _SITE . " $page_jump ";
                  }
               print "</SELECT>";
            Print "</FORM>";
            }
      print "<P>";
//handle sort functions
      print "[ " . _SORT . " ";
      print "&#160;&#160;<a href=\"modules.php?op=modload&name=$module_name&file=propview&$guidestring&sort=price%20DESC\">";
      if ($sort == "price DESC") {print "<B>" . _PREIS . "</b>";}
      else {print "Preis";}
      print "</a>&#160;&#160;<a href=\"modules.php?op=modload&name=$module_name&file=propview&$guidestring&sort=id%20DESC\">";
      if ($sort == "id DESC") {print "<B>" . _MEISTBESUCHT . "</b>";}
      else {print "Meistbesucht";}
      print "</a>&#160;&#160;<a href=\"modules.php?op=modload&name=$module_name&file=propview&$guidestring&sort=beds%20DESC\">";
      if ($sort == "beds DESC") {print "<B>" . _BETT . "</b>";}
      else {print "Betten";}
      print "</a>&#160;&#160;<a href=\"modules.php?op=modload&name=$module_name&file=propview&$guidestring&sort=baths%20DESC\">";
      if ($sort == "baths DESC") {print "<B>" . _BATH . "</b>";}
      else {print "B&auml;der";}
      print "</a>&#160;&#160;<a href=\"modules.php?op=modload&name=$module_name&file=propview&$guidestring&sort=city\">";
      if ($sort == "city") {print "<B>" . _CITY . "</b>";}
      else {print "Stadt";}
      print "</a>&#160;&#160;<a href=\"modules.php?op=modload&name=$module_name&file=propview&$guidestring&sort=sqfeet%20DESC\">";
      if ($sort == "sqfeet DESC") {print "<B>" . _GROS . "</b>";}
      else {print "Gr&ouml;&szlig;e";}
      print "</a> ]<P>";
      //end sort functions
      $limit_str = "LIMIT ". $cur_page * $properties_per_page .",$properties_per_page";
      $query = "$querystring $limit_str";
      $result = mysql_query("$query",$link);
         while ($a_row =mysql_fetch_array ($result) )
            {
//strip slashes so input appears correctly

Quellcode aus der englishen Version:

//spit out listings for multiple properties
        function makelisting($querystring, $link, $guidestring, $cur_page, $properties_per_page, $sort, $modname, $basepath, $adminpath, $basemodurl, $adminmodurl,$prefix)
                {
                if ($sort == "") {$sort = "price DESC";}
                $querystring = $querystring." ORDER BY $sort";
                $result = mysql_query("$querystring;",$link);
                $num_rows = mysql_num_rows($result);
                $page_num = $cur_page + 1;
                $total_num_page = ceil($num_rows/$properties_per_page);
                print "<Center>";
                if ($num_rows == "1") {Print "<font class=\"pn-title\">There is currently one listing in this category.<BR></font>";}
                else {Print "There are currently $num_rows listings in this category.<BR>";}
                if ($total_num_page != 0)
                        {
                        Print "<font class=\"pn-title\">This is page $page_num of $total_num_page. Displaying $properties_per_page listings per page.</font><BR>";
                        $prevpage = $cur_page-1;
                        $nextpage = $cur_page+1;
                        if ($page_num != 1){print "<font class=\"pn-title\"><a href=\"$basemodurl=propview&$guidestring&cur_page=$prevpage&sort=$sort\">Previous Page</a>     </font>";}
                        if ($page_num != $total_num_page){print "<font class=\"pn-title\"><a href=\"$basemodurl=propview&$guidestring&cur_page=$nextpage&sort=$sort\">Next Page</a>     </font>";}
                        }
                if ($total_num_page > 1)
                                  {
                                  print "<FORM name=pagejump_top method=post>";
                                Print "<SELECT NAME=\"selectpage\" onChange=\"window.location.href=document.pagejump_top.selectpage.options[document.pagejump_top.selectpage.selectedIndex].value\">";
                                        Print "<OPTION VALUE=\"$basemodurl=propview&$guidestring&cur_page\" SELECTED>Jump To Another Page ";
                                        for ($counter=0; $counter<=$total_num_page-1; $counter++)
                                                {
                                                $page_jump = $counter +1;
                                                print "<OPTION VALUE=\"$basemodurl=propview&$guidestring&cur_page=$counter&sort=$sort\">Page $page_jump ";
                                                }
                                        print "</SELECT>";
                                Print "</FORM>";
                                }
                print "<P>";
                //handle sort functions
                print "[ Sort by: ";
                print "&#160;&#160;<a href=\"$basemodurl=propview&$guidestring&sort=price%20DESC\">";
                if ($sort == "price DESC") {print "<B>Price</b>";}
                else {print "Price";}
                print "</a>&#160;&#160;<a href=\"$basemodurl=propview&$guidestring&sort=id%20DESC\">";
                if ($sort == "id DESC") {print "<B>Most Recent</b>";}
                else {print "Most Recent";}
                print "</a>&#160;&#160;<a href=\"$basemodurl=propview&$guidestring&sort=beds%20DESC\">";
                if ($sort == "beds DESC") {print "<B>Beds</b>";}
                else {print "Beds";}
                print "</a>&#160;&#160;<a href=\"$basemodurl=propview&$guidestring&sort=baths%20DESC\">";
                if ($sort == "baths DESC") {print "<B>Baths</b>";}
                else {print "Baths";}
                print "</a>&#160;&#160;<a href=\"$basemodurl=propview&$guidestring&sort=city\">";
                if ($sort == "city") {print "<B>City</b>";}
                else {print "City";}
                print "</a>&#160;&#160;<a href=\"$basemodurl=propview&$guidestring&sort=sqfeet%20DESC\">";
                if ($sort == "sqfeet DESC") {print "<B>Square Footage</b>";}
                else {print "Square Footage";}
                print "</a> ]<P>";
//end sort functions
                $limit_str = "LIMIT ". $cur_page * $properties_per_page .",$properties_per_page";
                $query = "$querystring $limit_str";
                $result = mysql_query("$query;",$link);
                        while ($a_row = mysql_fetch_array ($result) )
                                {

.

[gg]

Hab hier leider keine Hilfe bekommen, und, wie das bei NICHT-Programmierern wie mir am besten klappt, es mit 1000 mal probieren versucht.

Hier die Lösung:

in der Datei  propview.php

   function makelisting($querystring, $link, $guidestring, $cur_page, $properties_per_page, $sort)
      {
global $sort, $querystring, $prefix, $result, $link, $num_rows,$page_num, $cur_page, $total_num_page, $num_rows, $properties_per_page, $module_name, $prevpage,$counter, $page_jump, $a_row, $limit_str, $query, $sort, $view, $db, $key , $value;

Die Zeile global dazugesetzt.

Ausserdem ein paar Zeilen tiefer:

$result = mysql_query('$querystring;',$link); 

geändert in

$result = mysql_query($querystring,$link); 

jetzt funktioniert es.