From d8ddf38453cb988645244d0f10da10f1d1665c93 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 21 Sep 2010 21:55:16 +0200 Subject: Core/Items: Implemented trading soulbound loot items Core/DBLayer: Converted more more player-related queries into prepared statements Core/Items: Fixed loading of enchantments Closes issue #4130. --HG-- branch : trunk --- sql/base/characters_database.sql | 23 ++++++++++++++++++++++ .../10030_characters_item_soulbound_trade_data.sql | 6 ++++++ 2 files changed, 29 insertions(+) create mode 100644 sql/updates/10030_characters_item_soulbound_trade_data.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index ede2e59e225..acccb19513a 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1791,6 +1791,29 @@ LOCK TABLES `item_refund_instance` WRITE; /*!40000 ALTER TABLE `item_refund_instance` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `item_soulbound_trade_data` +-- + +DROP TABLE IF EXISTS `item_soulbound_trade_data`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `item_soulbound_trade_data` ( + `itemGuid` int(11) unsigned NOT NULL COMMENT 'Item GUID', + `allowedPlayers` text NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', + PRIMARY KEY (`itemGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item Refund System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `item_soulbound_trade_data` +-- + +LOCK TABLES `item_soulbound_trade_data` WRITE; +/*!40000 ALTER TABLE `item_soulbound_trade_data` DISABLE KEYS */; +/*!40000 ALTER TABLE `item_soulbound_trade_data` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `lag_reports` -- diff --git a/sql/updates/10030_characters_item_soulbound_trade_data.sql b/sql/updates/10030_characters_item_soulbound_trade_data.sql new file mode 100644 index 00000000000..e6f43debb9b --- /dev/null +++ b/sql/updates/10030_characters_item_soulbound_trade_data.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `item_soulbound_trade_data`; +CREATE TABLE `item_soulbound_trade_data` ( + `itemGuid` int(11) unsigned NOT NULL COMMENT 'Item GUID', + `allowedPlayers` text NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', + PRIMARY KEY (`itemGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item Refund System'; -- cgit v1.2.3