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; }