PHP Item::GetByID Examples

Example #1

File: MarketStarterPack.inc.php Project: alcexhim/PhoenixSNS

 public function GetItems()
 {
     global $MySQL;
     $query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "MarketStarterPackItems WHERE " . System::$Configuration["Database.TablePrefix"] . "MarketStarterPackItems.starterpackitem_StarterPackID = " . $this->ID;
     $result = $MySQL->query($query);
     $count = $result->num_rows;
     $retval = array();
     for ($i = 0; $i < $count; $i++) {
         $values = $result->fetch_assoc();
         $item = Item::GetByID($values["starterpackitem_ItemID"]);
         if ($item == null) {
             continue;
         }
         $retval[] = $item;
     }
     return $retval;
 }