Example #1
0
 public static function GetEquippedByUser($user)
 {
     global $MySQL;
     $query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "Items, " . System::$Configuration["Database.TablePrefix"] . "UserEquippedItems WHERE " . System::$Configuration["Database.TablePrefix"] . "UserEquippedItems.equippeditem_UserID = " . $user->ID . " AND " . System::$Configuration["Database.TablePrefix"] . "UserEquippedItems.equippeditem_ItemID = " . System::$Configuration["Database.TablePrefix"] . "Items.item_ID";
     $result = $MySQL->query($query);
     $count = $result->num_rows;
     $retval = array();
     for ($i = 0; $i < $count; $i++) {
         $values = $result->fetch_assoc();
         $retval[] = Item::GetByAssoc($values);
     }
     return $retval;
 }