· 7 years ago · Jan 12, 2019, 02:26 PM
1DROP TABLE IF EXISTS `itemshop_log`;
2CREATE TABLE `itemshop_log` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `item_vnum` int(11) NOT NULL,
5 `account_id` int(11) NOT NULL,
6 `datetime` datetime NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=latin1;
9
10
11#ifdef __ITEM_SHOP__
12void LogManager::ItemShopBuyLog(DWORD dwItemVnum, DWORD dwAccountID)
13{
14
15 Query("INSERT INTO itemshop_log%s (item_vnum, account_id, datetime) VALUES('%d', '%d' , NOW())", get_table_postfix(), dwItemVnum, dwAccountID);
16
17}
18#endif
19
20
21#ifdef __ITEM_SHOP__
22 void ItemShopBuyLog(DWORD dwItemVnum, DWORD dwAccountID);
23#endif
24
25
26 LogManager::instance().ItemShopBuyLog( item.vnum, ch->GetDesc()->GetAccountTable().id);