Logs for cashshop_db

[kyeme 71]

Please add the logs for Cash Shop. Thankssss!

 

http://trac.rathena.org/changeset/17242/rathena

CREATE TABLE `cashlog` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',  `char_id` int(11) NOT NULL DEFAULT '0',  `type` enum('T','V','P','M','S','N','D','C','A','E','I','B','$') NOT NULL DEFAULT 'S',  `cash_type` enum('O','K','C') NOT NULL DEFAULT 'O',  `amount` int(11) NOT NULL DEFAULT '0',  `map` varchar(11) NOT NULL DEFAULT '',  PRIMARY KEY (`id`),  INDEX `type` (`type`)) ENGINE=MyISAM AUTO_INCREMENT=1; 

 

Edited July 22, 2013 by kyeme

[ossi0110 200]

+1

[Beret 50]

I'm think should follow aegis log.

CREATE TABLE [dbo].[CashItemShopLog](	[Index] [int] IDENTITY(1,1) NOT NULL,	[Date] [datetime] NOT NULL,	[Action] [int] NULL,	[ServerID] [int] NULL,	[MapName] [varchar](24) NULL,	[AccountID] [int] NULL,	[AccountName] [varchar](24) NULL,	[CharacterID] [int] NULL,	[CharacterName] [varchar](24) NULL,	[CharacterIPaddr] [varchar](20) NULL,	[PosX] [int] NULL,	[PosY] [int] NULL,	[NpcName] [varchar](51) NULL,	[ItemID] [int] NULL,	[ItemName] [varchar](24) NULL,	[ItemCount] [int] NULL,	[ItemSerial] [bigint] NULL,	[ItemSlot1] [int] NULL,	[ItemSlot2] [int] NULL,	[ItemSlot3] [int] NULL,	[ItemSlot4] [int] NULL,	[ItemRefiningLevel] [int] NULL,	[Cash_Price] [int] NULL,	[Cash_View] [int] NULL,	[Cash_Before] [int] NULL,	[Cash_After] [int] NULL,

 

CREATE TABLE [dbo].[Cash_Reload_Log](	[AutoID] [int] IDENTITY(1,1) NOT NULL,	[game_id] [varchar](20) NOT NULL,	[aid] [int] NOT NULL,	[card_id] [varchar](20) NOT NULL,	[card_point] [int] NOT NULL,	[cash_after] [int] NOT NULL,	[log_date] [datetime] NOT NULL,

Edited July 22, 2013 by Beret

[Samuel 83]

+1 to Cashshop Log

[Ind 945]

does it really need a new table? can't we share picklog? (with a new type)

[Beret 50]

I think better to keep separate logs ind, is much more organized and easier to work with specific logs.

[Gerz 7]

yes, +1 for this

[evilpuncker 503]

I agree the use with picklog