[MySQL Query] Itemshop bought view from SQL table

[kukubeni]

This command lists all purchased items for a 30-day period.

SELECT is_log.account_id,item_proto.locale_name, is_log.preis FROM `account`.`is_log` INNER JOIN `player`.`item_proto` ON `is_log`.`vnum` = `item_proto`.`vnum` WHERE TIMESTAMPDIFF(DAY, `zeitpunkt`,NOW()) <= 30;


Example result:

+------------+--------------+-------+
| account_id | locale_name | preis |
+------------+--------------+-------+
| 2408 | Knuud | 2000 |
+------------+--------------+-------+

 

[4peppe]

thanks, have you already tried it? it works?