'; // determine Stats if ( $adventurebook_combat_system ) { /* @var Combat_System $adventurebook_combat_system */ $stats = $adventurebook_combat_system->get_item_stats_to_show( $item->get_complete_stats() ); } else { $stats = $item->get_complete_stats(); } // Name + Toggle $content .= ''; // adventurebook_item_name // Stats- and Description-Container (hidden) $content .= ''; // adventurebook_item return $content; } public static function get_item_by_id( $id ): ?Item { global $wpdb; $result = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM " . $wpdb->prefix . "adventurebook_items WHERE id = %d", $id ), ARRAY_A );// phpcs:ignore WordPress.DB.DirectDatabaseQuery if ( $result === null ) { return null; } return new Item( $result['id'], $result['character_id'], $result['code'], $result['location_id'], $result['stats'], $result['spawn_id'] ); } public static function create_item( $character_id, $code, $location_id, ?array $stats = null, $spawn_id = 0 ): ?Item { // check if the item definition exists $item_definition = Item_Definition::get_item_definition_by_code( $code ); if ( $item_definition === null ) { return null; } // get the stats which are copied to the item instance from the combat system $combat_system = adventurebook_get_combat_system_for_character_id( $character_id ); $stats_to_be_copied = $combat_system->get_item_stats_to_be_instantiated(); // if no stats are given, copy the default stats from the item definition // but only those stats which are defined to be copied by the combat system // this way we avoid copying unnecessary stats like "Value" or "Description" // to the item instance in the database if ( $stats === null ) { $stats = array(); foreach ( $stats_to_be_copied as $stat_name ) { if ( isset( $item_definition->stats[ $stat_name ] ) ) { $stats[ $stat_name ] = $item_definition->stats[ $stat_name ]; } } } global $wpdb; $table_name = $wpdb->prefix . 'adventurebook_items'; $wpdb->insert( $table_name, array(// phpcs:ignore WordPress.DB.DirectDatabaseQuery 'character_id' => $character_id, 'code' => $code, 'location_id' => $location_id, 'stats' => json_encode( $stats ), 'spawn_id' => $spawn_id, ) ); $id = $wpdb->insert_id; return new Item( $id, $character_id, $code, $location_id, json_encode( $stats ), $spawn_id ); } public static function delete_item( $id ): void { global $wpdb; $table_name = $wpdb->prefix . 'adventurebook_items'; $wpdb->delete( $table_name, array( 'id' => $id ) );// phpcs:ignore WordPress.DB.DirectDatabaseQuery } public static function get_items_by_character_id( $character_id ): array { global $wpdb; $results = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM " . $wpdb->prefix . "adventurebook_items WHERE character_id = %d", $character_id ), ARRAY_A );// phpcs:ignore WordPress.DB.DirectDatabaseQuery $items = array(); foreach ( $results as $result ) { $items[] = new Item( $result['id'], $result['character_id'], $result['code'], $result['location_id'], $result['stats'] ); } return $items; } /** * Get all items associated with a specific spawn point. * * @param int $spawn_id The ID of the spawn point. * * @return Item[] An array of Item objects. */ public static function get_items_for_spawn_id( $spawn_id ): array { global $wpdb; $results = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM " . $wpdb->prefix . "adventurebook_items WHERE spawn_id = %d", $spawn_id ), ARRAY_A );// phpcs:ignore WordPress.DB.DirectDatabaseQuery $items = array(); foreach ( $results as $result ) { $items[] = new Item( $result['id'], $result['character_id'], $result['code'], $result['location_id'], $result['stats'], $result['spawn_id'] ); } return $items; } public static function delete_items_by_character_id( $character_id ): void { global $wpdb; $table_name = $wpdb->prefix . 'adventurebook_items'; $wpdb->delete( $table_name, array( 'character_id' => $character_id ) );// phpcs:ignore WordPress.DB.DirectDatabaseQuery } public function get_slot(): string { $stats = $this->get_complete_stats(); return $stats['Slot'] ?? ''; } public function set_location( int $location_id ): void { $this->location_id = $location_id; $this->save_to_db(); } public function set_spawn_id( int $spawn_id ): void { $this->spawn_id = $spawn_id; $this->save_to_db(); } public static function delete_items_for_spawn_id( $spawn_id ): void { global $wpdb; $table_name = $wpdb->prefix . 'adventurebook_items'; $wpdb->delete( $table_name, array( 'spawn_id' => $spawn_id ) );// phpcs:ignore WordPress.DB.DirectDatabaseQuery } /** * Deletes all items that are associated with a spawn_id that no longer exists in the item_spawns table. * * @return int The number of deleted items. */ public static function delete_orphaned_items(): int { global $wpdb; $table_name = $wpdb->prefix . 'adventurebook_items'; $spawn_table_name = $wpdb->prefix . 'adventurebook_item_spawns'; // $wpdb->query( "DELETE FROM $table_name WHERE spawn_id != 0 AND spawn_id NOT IN (SELECT id FROM $spawn_table_name)" );// phpcs:ignore WordPress.DB.DirectDatabaseQuery,WordPress.DB.PreparedSQL.InterpolatedNotPrepared // Escape the table names before interpolating into the SQL string. // Table names cannot be used as placeholders in $wpdb->prepare(), so esc_sql() is used here. $escaped_table = esc_sql( $table_name ); $escaped_spawn_table = esc_sql( $spawn_table_name ); $wpdb->query( "DELETE FROM " . $escaped_table . " WHERE spawn_id != 0 AND spawn_id NOT IN (SELECT id FROM " . $escaped_spawn_table . ")" ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery return $wpdb->rows_affected; } public function save_to_db(): void { global $wpdb; $table_name = $wpdb->prefix . 'adventurebook_items'; $wpdb->update( $table_name, array(// phpcs:ignore WordPress.DB.DirectDatabaseQuery 'character_id' => $this->character_id, 'code' => $this->code, 'location_id' => $this->location_id, 'stats' => json_encode( $this->stats ), 'spawn_id' => $this->spawn_id, ), array( 'id' => $this->id ) ); } public function is_usable(): bool { $item_definition = Item_Definition::get_item_definition_by_code( $this->code ); return $item_definition->is_usable(); } public function is_resource(): bool { $item_definition = Item_Definition::get_item_definition_by_code($this->code); return $item_definition->is_resource(); } public function get_charges(): int { $charges = $this->get_stat( 'Charges' ); if ( ! is_numeric( $charges ) || $charges < 0 ) { return 1; } return intval( $charges ); } public function decrease_charges( int $amount = 1 ): void { $current_charges = $this->get_charges(); $new_charges = max(0, $current_charges - $amount); $this->stats['Charges'] = $new_charges; $this->save_to_db(); } public function set_charges( int $charges ): void { $this->stats['Charges'] = $charges; $this->save_to_db(); } public function get_item_slot(): string { $item_definition = Item_Definition::get_item_definition_by_code( $this->code ); return $item_definition->get_item_slot(); } public function is_two_handed(): bool { $item_definition = Item_Definition::get_item_definition_by_code( $this->code ); return $item_definition->is_two_handed(); } /** * Compares this item with another item to determine if they are identical. * Two items are considered identical if they have the same item definition code * and the same stats (both keys and values). * * Money items are never considered identical. * * this is used for a grouped inventory display * * @param ?Item $other The other item to compare with. * * @return bool True if the items are identical, false otherwise. */ public function is_identical_to_item( ?Item $other ): bool { if ( $other == null || $this->code !== $other->code || $this->code == 'money' ) { return false; } // compare stats $stats1 = $this->get_complete_stats(); $stats2 = $other->get_complete_stats(); if ( count( $stats1 ) !== count( $stats2 ) ) { return false; } foreach ( $stats1 as $key => $value ) { if ( ! array_key_exists( $key, $stats2 ) || $stats2[ $key ] !== $value ) { return false; } } return true; } public function set_stat(string $string, mixed $value): void { $this->stats[$string] = $value; $this->save_to_db(); } }