Changeset 1143

Timestamp:

06/11/2008 09:46:18 AM (21 months ago)

Author:

DarTar

Message:

Replace alias with actual column name in LoadWantedPages(), thanks ajmh for the patch, fixes #309

Files:

• branches/1.1.6.5/libs/Wakka.class.php (modified) (1 diff)

branches/1.1.6.5/libs/Wakka.class.php

@@ -709 +709 @@
                 }
         }
-        function LoadWantedPages() { return $this->LoadAll("select distinct ".$this->config["table_prefix"]."links.to_tag as tag,count(".$this->config["table_prefix"]."links.from_tag) as count from ".$this->config["table_prefix"]."links left join ".$this->config["table_prefix"]."pages on ".$this->config["table_prefix"]."links.to_tag = ".$this->config["table_prefix"]."pages.tag where ".$this->config["table_prefix"]."pages.tag is NULL group by tag order by count desc"); }
+        function LoadWantedPages() { return $this->LoadAll("select distinct ".$this->config["table_prefix"]."links.to_tag as tag,count(".$this->config["table_prefix"]."links.from_tag) as count from ".$this->config["table_prefix"]."links left join ".$this->config["table_prefix"]."pages on ".$this->config["table_prefix"]."links.to_tag = ".$this->config["table_prefix"]."pages.tag where ".$this->config["table_prefix"]."pages.tag is NULL group by ".$this->config["table_prefix"]."links.to_tag order by count desc"); }
         function IsWantedPage($tag)
         {