[Planeshift-cvs] CVS: SC database.php,1.8,1.9

[Andrew C. <ac...@us...>]

Update of /cvsroot/planeshift/SC
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4102

Modified Files:
	database.php 
Log Message:
Can now search on item_stat name.  

Index: database.php
===================================================================
RCS file: /cvsroot/planeshift/SC/database.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** database.php	4 Apr 2005 01:44:31 -0000	1.8
--- database.php	17 Apr 2005 06:32:58 -0000	1.9
***************
*** 678,681 ****
--- 678,703 ----
  	}
   }
+  
+  
+  
+  class ItemStatsDB extends Database 
+  {
+     function ItemStatsDB() 
+     {
+         Database::Database();
+     }
+     
+     function getItemStatsFromSearch($sqlWhere, $order_by=null) 
+     {    
+         $this->getFieldsByXML("item_stats");
+         $sqlFields = $this->getXMLListFields();
+         if($order_by==null) {
+             $order_by[0] = "id";
+         }
+         return $this->getAllByIDLike($sqlFields, $sqlWhere, "item_stats", $order_by);
+     }
+ 
+  }
+  
   		
   // {{{ our class connectors
***************
*** 703,706 ****
--- 725,734 ----
   	return new LootDB();
   }
+  
+  function newItemStatsConn() 
+  {
+     return new ItemStatsDB();
+  }
+  
   // }}}