daniel
2008-06-08 61d290c124aa65c9ad2edd183617b92660f92289
interface/lib/classes/plugin_listview.inc.php
@@ -49,10 +49,14 @@
                $limit_sql = $app->listform->getPagingSQL($sql_where);
                $listTpl->setVar("paging",$app->listform->pagingHTML);
            
            $sql_order_by = '';
            if(isset($this->options["sql_order_by"])) {
               $sql_order_by = $this->options["sql_order_by"];
            }
            
                // Get the data
                $records = $app->db->queryAllRecords("SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $limit_sql");
                $records = $app->db->queryAllRecords("SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $sql_order_by $limit_sql");
                $bgcolor = "#FFFFFF";
                if(is_array($records)) {
@@ -71,6 +75,8 @@
                           if($field['formtype'] == "SELECT") {
                              $rec[$key] = $field['value'][$rec[$key]];
                           }
                           // Create a lowercase version of every item
                           $rec[$key.'_lowercase'] = strtolower($rec[$key]);
                        }
                                // The variable "id" contains always the index field
@@ -80,7 +86,7 @@
                        }
                }
                $listTpl->setLoop('records',$records_new);
                $listTpl->setLoop('records',@$records_new);
                // Loading language field
                $lng_file = "lib/lang/".$_SESSION["s"]["language"]."_".$app->listform->listDef['name']."_list.lng";