Chriss 1927 Posted July 8, 2020 Share Posted July 8, 2020 Spoiler ClientManagerBoot.cpp //search static const char * s_szQuery = "SELECT " "shop.vnum, " "shop.npc_vnum, " "shop_item.item_vnum, " "shop_item.count " "FROM shop LEFT JOIN shop_item " "ON shop.vnum = shop_item.shop_vnum ORDER BY shop.vnum, shop_item.item_vnum"; //replace or adapt: static const char * s_szQuery = "SELECT " "shop.vnum, " "shop.npc_vnum, " "shop_item.item_vnum, " "shop_item.count " "FROM shop LEFT JOIN shop_item " "ON shop.vnum = shop_item.shop_vnum ORDER BY shop.vnum, shop_item.id"; // shop_item.item_vnum - shop_item.id shop_item.sql SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for shop_item -- ---------------------------- DROP TABLE IF EXISTS `shop_item`; CREATE TABLE `shop_item` ( `id` int(10) UNSIGNED NOT NULL DEFAULT 1, `shop_vnum` int(11) NOT NULL DEFAULT 0, `item_vnum` int(11) NOT NULL DEFAULT 0, `count` tinyint(4) unsigned NOT NULL DEFAULT 1 ) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed; -- ---------------------------- -- Records of shop_item -- ---------------------------- INSERT INTO `shop_item` VALUES (1, 1, 1009, 1); INSERT INTO `shop_item` VALUES (2, 1, 297, 1); INSERT INTO `shop_item` VALUES (3, 1, 4049, 1); SET FOREIGN_KEY_CHECKS=1; 6 Link to comment Share on other sites More sharing options...
BaalaaN 1 Posted December 13, 2020 Share Posted December 13, 2020 Thank's Link to comment Share on other sites More sharing options...
Kafa 153 Posted December 13, 2020 Share Posted December 13, 2020 (edited) Edited August 25, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Etzhel 115 Posted December 14, 2020 Share Posted December 14, 2020 So? Link to comment Share on other sites More sharing options...
Recommended Posts