ActionTypeDefs

~~beetols~~ · 01/09/2025, 14:30

I'm sharing the values on ActionLog i found lately rewriting a new ActionLog panel

Code:

USE [PS_GameLog]
GO

/****** Check e Droppare la tabella se esiste ******/
IF OBJECT_ID('dbo.ActionTypeDefs', 'U') IS NOT NULL
BEGIN
    DROP TABLE [dbo].[ActionTypeDefs];
END
GO

/****** Object:  Table [dbo].[ActionTypeDefs]    Script Date: 1/9/2025 2:25:05 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ActionTypeDefs](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[ActionType] [tinyint] NOT NULL,
	[ActionName] [varchar](50) NOT NULL,
	[Value1] [varchar](50) NULL,
	[Value2] [varchar](50) NULL,
	[Value3] [varchar](50) NULL,
	[Value4] [varchar](50) NULL,
	[Value5] [varchar](50) NULL,
	[Value6] [varchar](50) NULL,
	[Value7] [varchar](50) NULL,
	[Value8] [varchar](50) NULL,
	[Value9] [varchar](50) NULL,
	[Value10] [varchar](50) NULL,
	[Text1] [varchar](50) NULL,
	[Text2] [varchar](50) NULL,
	[Text3] [varchar](50) NULL,
	[Text4] [varchar](50) NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[ActionTypeDefs] ON 
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (1, 102, N'Mob Action', N'MobID', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'MobName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (2, 103, N'Kill', N'DeathID', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'DeathName', N'NewStatus', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (3, 104, N'Death', N'KillerID', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'KillerName', N'NewStatus', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (4, 105, N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (5, 106, N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (6, 107, N'Login', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'UserIP', N'NewStatus', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (7, 108, N'Logout', NULL, N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'NewStatus', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (8, 111, N'Dropped Item', N'ItemUID', N'ItemID', N'Count', NULL, N'MobID', NULL, NULL, NULL, NULL, NULL, N'ItemName', N'Action', N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (9, 112, N'Bought Item', N'ItemUID', N'ItemID', N'Count', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'Action', N'ItemDetails', N'Inventory')
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (10, 113, N'Bought Item from NPC', N'ItemUID', N'ItemID', N'NPC ID', N'Count', N'Cost', N'Remaining Gold', NULL, NULL, NULL, NULL, N'ItemName', NULL, N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (11, 114, N'Sold Item', N'ItemUID', N'ItemID', N'unknown', N'Count', N'Gold1', N'Gold2', NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails', NULL, N'Inventory')
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (12, 115, N'Bought from player', N'ItemUID', N'ItemID', N'CharID', N'Count', N'Gold', NULL, NULL, NULL, NULL, NULL, N'ItemName', N'CharName', N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (13, 116, N'Sold to player', N'ItemUID', N'ItemID', N'CharID', N'Count', N'Gold', NULL, NULL, NULL, NULL, NULL, N'ItemName', N'CharName', N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (14, 117, N'Trade ?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (15, 118, N'unknown', N'ItemUID', N'ItemID', N'Count', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'CharName', N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (16, 119, N'Lapis Link', N'ItemUID', N'ItemID', N'LapisID', N'LapisUID', N'unknown', N'Cost', N'Success', NULL, NULL, NULL, N'ItemName', N'LapisName', N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (17, 120, N'Lapis Extraction', N'ItemUID', N'ItemID', N'LapisID', N'LapisUID', N'unknown', N'Cost', N'Success', NULL, NULL, NULL, N'ItemName', N'LapisName', N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (18, 121, N'unknown', N'ItemUID', N'ItemID', N'unknown', N'unknown', N'unknown', NULL, N'unknown', NULL, NULL, NULL, N'ItemName', NULL, N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (19, 122, N'unknown', N'ItemUID', N'ItemID', N'unknown', N'unknown', NULL, N'unknown', N'unknown', N'unknown', NULL, NULL, N'ItemName', NULL, N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (20, 123, N'unknown', N'CharID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'CharName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (21, 124, N'unknown', N'CharID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'CharName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (22, 125, N'unknown', N'CharID', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'CharName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (23, 131, N'Quest Start', N'QuestID', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'QuestName', N'NPC', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (24, 133, N'Quest Complete', N'QuestID', N'unknown', N'unknown', N'ItemID', N'Count', NULL, NULL, NULL, NULL, NULL, N'QuestName', N'ItemName', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (25, 141, N'? Skill Related', N'SkillID', N'SkillLevel', N'SkillPoint?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'SkillName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (26, 146, N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (27, 151, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (28, 152, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (29, 153, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (30, 154, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (31, 155, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (32, 156, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (33, 161, N'Gold from floor', N'gold', N'totalgold', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (34, 163, N'unknown', N'unknown', N'totalgold', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'CharName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (35, 164, N'NPC portal', N'cost', N'totalgold', N'option', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'NPC Name', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (36, 170, N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (37, 171, N'Relics Action 1', N'Country?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'RelicName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (38, 172, N'Relics Action 2', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'RelicName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (39, 173, N'Boss Fight', N'HP', N'Damage', N'MobID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'BossName', N'Action', N'CharName', N'SkillName')
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (40, 174, N'Rename', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Old CharName', N'New CharName', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (41, 175, N'Guild1?', N'GuildID?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (42, 176, N'Guild2?', N'GuildID?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (43, 177, N'Guild3?', N'GuildID?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (44, 178, N'Guild4?', N'GuildID?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (45, 179, N'Guild5?', N'GuildID?', N'GuildID?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', N'GuildName', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (46, 180, N'GM Comands', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Command Name', N'Text2', N'Text3', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (47, 190, N'unknown', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (48, 191, N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (49, 192, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (50, 193, N'unknown', N'unknown', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (51, 194, N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (52, 195, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (53, 196, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (54, 198, N'unknown', N'ItemUID', N'ItemID', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'MobName', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (55, 200, N'GuildWH?', N'ItemUID', N'ItemID', N'Count', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, N'GuildName', N'ItemName', N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (56, 201, N'GuildWH?', N'ItemUID', N'ItemID', N'Count', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, N'GuildName', N'ItemName', N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (57, 202, N'Guild?', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (58, 203, N'Guild?', N'GuildID', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', N'Option', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (59, 204, N'Guild?', N'GuildID', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (60, 205, N'Guild?', N'GuildID', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (61, 210, N'Join Party', N'PartyID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (62, 211, N'Leave Party', N'PartyID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (63, 212, N'Enchant', N'ItemUID', N'ItemID', N'EnchantID', N'EnchantUID', N'unknown', N'Cost', N'Success', NULL, NULL, NULL, N'ItemName', N'LapisiaName', N'ItemDetails', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (64, 213, N'Recreation', N'ItemUID', N'ItemID', N'RecreationID', N'RecreationUID', NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'OldRecreation', N'NewRecreation', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (65, 214, N'Item Creation', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (66, 215, N'unknown', N'ItemUID', N'ItemID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'ItemUID', N'NewStats', NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (67, 216, N'Asta Added', N'ItemUID', N'ItemID', N'AstaID', N'unk', N'unk', N'unk', N'unk', N'gold1', N'gold2', N'gold3', N'gold4', N'ItemName', N'ItemDetails', N'AstaDetails')
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (68, 217, N'Asta Fail', N'ItemUID', N'ItemID', N'AstaID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (69, 218, N'Asta Bought', N'ItemUID', N'ItemID', N'AstaID', N'Gold', N'Gold', N'CharID', NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails', NULL, N'CharName')
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (70, 219, N'Asta Offert', N'ItemUID', N'ItemID', N'AstaID', N'Gold', N'Gold', N'CharID', N'unk', NULL, NULL, NULL, N'ItemName', N'ItemDetails', NULL, N'CharName')
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (71, 220, N'Asta withdraw', N'ItemUID', N'ItemID', N'AstaID', N'unk', N'unk', N'unk', NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails', NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (72, 221, N'Asta money withdraw', N'unk', N'unk', N'Gold1', N'Gold2', N'Gold3', N'Gold4', N'Gold5', N'Gold6', NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (73, 222, N'Asta Unk', N'ItemUID', N'ItemID', N'AstaID', N'unk', N'Gold1', N'Gold2', N'Gold3', N'unk', NULL, NULL, N'ItemName', N'ItemDetails', NULL, N'CharName')
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (74, 223, N'Asta Unk 1', N'ItemUID', N'ItemID', N'AstaID', N'unk', NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails', NULL, N'CharName')
GO
INSERT [dbo].[ActionTypeDefs] ([RowID], [ActionType], [ActionName], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [Text1], [Text2], [Text3], [Text4]) VALUES (75, 224, N'Asta Unk 2', N'ItemUID', N'ItemID', N'AstaID', N'unk', NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails', NULL, N'CharName')
GO
SET IDENTITY_INSERT [dbo].[ActionTypeDefs] OFF
GO

If you have extra info about some ActionType share here and I'll update the query!

n1mr0mvp · 01/19/2025, 10:50

Thanks!

[DEV]_Yûko · 05/31/2025, 19:43

USE [PS_GameLog];
GO

-- Supprime la table existante si nécessaire
IF OBJECT_ID('dbo.ActionTypeDefs','U') IS NOT NULL
DROP TABLE dbo.ActionTypeDefs;
GO

-- Crée la table
CREATE TABLE dbo.ActionTypeDefs (
RowID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
ActionType TINYINT NOT NULL,
ActionName VARCHAR(50) NOT NULL,
Value1 VARCHAR(50) NULL,
Value2 VARCHAR(50) NULL,
Value3 VARCHAR(50) NULL,
Value4 VARCHAR(50) NULL,
Value5 VARCHAR(50) NULL,
Value6 VARCHAR(50) NULL,
Value7 VARCHAR(50) NULL,
Value8 VARCHAR(50) NULL,
Value9 VARCHAR(50) NULL,
Value10 VARCHAR(50) NULL,
Text1 VARCHAR(50) NULL,
Text2 VARCHAR(50) NULL,
Text3 VARCHAR(50) NULL,
Text4 VARCHAR(50) NULL
);
GO

-- Insère toutes les lignes en un seul bloc
INSERT INTO dbo.ActionTypeDefs
(ActionType, ActionName, Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4)
VALUES
(102, N'Mob Action', N'MobID', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'MobName', NULL, NULL, NULL),
(103, N'Kill', N'DeathID', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'DeathName', N'NewStatus', NULL),
(104, N'Death', N'KillerID', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'KillerName',N'NewStatus', NULL),
(105, N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(106, N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(107, N'Login', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'UserIP', N'NewStatus', NULL),
(108, N'Logout', NULL, N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'NewStatus', NULL),
(111, N'Dropped Item', N'ItemUID', N'ItemID', N'Count', NULL, N'MobID', NULL, NULL, NULL, NULL, NULL, N'ItemName', N'Action', N'ItemDetails',NULL),
(112, N'Bought Item', N'ItemUID', N'ItemID', N'Count', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'Action', N'ItemDetails',N'Inventory'),
(113, N'Bought Item from NPC', N'ItemUID', N'ItemID', N'NPC ID', N'Count', N'Cost', N'Remaining Gold', NULL, NULL, NULL, NULL, N'ItemName', NULL, N'ItemDetails',NULL),
(114, N'Sold Item', N'ItemUID', N'ItemID', N'unknown', N'Count', N'Gold1', N'Gold2', NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails',NULL, N'Inventory'),
(115, N'Bought from player', N'ItemUID', N'ItemID', N'CharID', N'Count', N'Gold', NULL, NULL, NULL, NULL, NULL, N'ItemName', N'CharName', N'ItemDetails',NULL),
(116, N'Sold to player', N'ItemUID', N'ItemID', N'CharID', N'Count', N'Gold', NULL, NULL, NULL, NULL, NULL, N'ItemName', N'CharName', N'ItemDetails',NULL),
(117, N'Trade ?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(118, N'unknown', N'ItemUID', N'ItemID', N'Count', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'CharName', N'ItemDetails',NULL),
(119, N'Lapis Link', N'ItemUID', N'ItemID', N'LapisID', N'LapisUID',N'unknown', N'Cost', N'Success', NULL, NULL, NULL, N'ItemName', N'LapisName', N'ItemDetails',NULL),
(120, N'Lapis Extraction', N'ItemUID', N'ItemID', N'LapisID', N'LapisUID',N'unknown', N'Cost', N'Success', NULL, NULL, NULL, N'ItemName', N'LapisName', N'ItemDetails',NULL),
(121, N'unknown', N'ItemUID', N'ItemID', N'unknown', N'unknown', N'unknown', NULL, N'unknown', NULL, NULL, NULL, N'ItemName', NULL, N'ItemDetails',NULL),
(122, N'unknown', N'ItemUID', N'ItemID', N'unknown', N'unknown', NULL, N'unknown', N'unknown', N'unknown', NULL, NULL, N'ItemName', NULL, N'ItemDetails',NULL),
(123, N'unknown', N'CharID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'CharName', NULL, NULL, NULL),
(124, N'unknown', N'CharID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'CharName', NULL, NULL, NULL),
(125, N'unknown', N'CharID', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'CharName', NULL, NULL, NULL),
(131, N'Quest Start', N'QuestID', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'QuestName', N'NPC', NULL, NULL),
(133, N'Quest Complete', N'QuestID', N'unknown', N'unknown',N'ItemID', N'Count', NULL, NULL, NULL, NULL, NULL, N'QuestName',N'ItemName', NULL, NULL),
(141, N'? Skill Related', N'SkillID', N'SkillLevel',N'SkillPoint?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'SkillName', NULL, NULL, NULL),
(146, N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(151, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(152, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(153, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(154, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(155, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(156, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(161, N'Gold from floor', N'gold', N'totalgold',NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(163, N'unknown', N'unknown', N'totalgold',N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'CharName', NULL, NULL, NULL),
(164, N'NPC portal', N'cost', N'totalgold',N'option', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'NPC Name', NULL, NULL, NULL),
(170, N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(171, N'Relics Action 1', N'Country?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'RelicName', NULL, NULL, NULL),
(172, N'Relics Action 2', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'RelicName', NULL, NULL, NULL),
(173, N'Boss Fight', N'HP', N'Damage', N'MobID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'BossName', N'Action', N'CharName', N'SkillName'),
(174, N'Rename', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Old CharName',N'New CharName',NULL, NULL),
(175, N'Guild1?', N'GuildID?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL),
(176, N'Guild2?', N'GuildID?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL),
(177, N'Guild3?', N'GuildID?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL),
(178, N'Guild4?', N'GuildID?', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL),
(179, N'Guild5?', N'GuildID?', N'GuildID?',NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', N'GuildName',NULL, NULL),
(180, N'GM Commands', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Command Name',N'Text2', N'Text3', NULL),
(190, N'unknown', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(191, N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(192, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(193, N'unknown', N'unknown', N'unknown', N'unknown',N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(194, N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(195, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(196, N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(198, N'unknown', N'ItemUID', N'ItemID', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'MobName', NULL, NULL),
(200, N'GuildWH?', N'ItemUID', N'ItemID', N'Count', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, N'GuildName', N'ItemName', N'ItemDetails',NULL),
(201, N'GuildWH?', N'ItemUID', N'ItemID', N'Count', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, N'GuildName', N'ItemName', N'ItemDetails',NULL),
(202, N'Guild?', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, N'ItemDetails',NULL),
(203, N'Guild?', N'GuildID', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', N'Option', NULL, NULL),
(204, N'Guild?', N'GuildID', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL),
(205, N'Guild?', N'GuildID', N'unknown', N'unknown', N'unknown', NULL, NULL, NULL, NULL, NULL, NULL, N'GuildName', NULL, NULL, NULL),
(210, N'Join Party', N'PartyID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(211, N'Leave Party', N'PartyID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(212, N'Enchant', N'ItemUID', N'ItemID', N'EnchantID',N'EnchantUID',N'unknown',N'Cost', N'Success', NULL, NULL, NULL, N'ItemName', N'LapisiaName',N'ItemDetails',NULL),
(213, N'Recreation', N'ItemUID', N'ItemID', N'RecreationID',N'RecreationUID',NULL,NULL,NULL,NU LL,NULL,NULL,N'ItemName',N'OldRecreation',N'NewRec reation',NULL),
(214, N'Item Creation', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(215, N'unknown', N'ItemUID', N'ItemID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'ItemUID', N'NewStats', NULL),
(216, N'Asta Added', N'ItemUID', N'ItemID', N'AstaID', N'unk', N'unk', N'unk', N'unk', N'gold1', N'gold2', N'gold3', N'gold4', N'ItemName', N'ItemDetails',N'AstaDetails'),
(217, N'Asta Fail', N'ItemUID', N'ItemID', N'AstaID', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails',NULL, NULL),
(218, N'Asta Bought', N'ItemUID', N'ItemID', N'AstaID', N'Gold', N'Gold', N'CharID', NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails',NULL, N'CharName'),
(219, N'Asta Offert', N'ItemUID', N'ItemID', N'AstaID', N'Gold', N'Gold', N'CharID', N'unk', NULL, NULL, NULL, N'ItemName', N'ItemDetails',NULL, N'CharName'),
(220, N'Asta withdraw', N'ItemUID', N'ItemID', N'AstaID', N'unk', N'unk', N'unk', NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails',NULL, NULL),
(221, N'Asta money withdraw', N'unk', N'unk', N'Gold1', N'Gold2', N'Gold3', N'Gold4', N'Gold5', N'Gold6', NULL, NULL, NULL, NULL, NULL, NULL),
(222, N'Asta Unk', N'ItemUID', N'ItemID', N'AstaID', N'unk', N'Gold1', N'Gold2', N'Gold3', N'unk', NULL, NULL, N'ItemName', N'ItemDetails',NULL, N'CharName'),
(223, N'Asta Unk 1', N'ItemUID', N'ItemID', N'AstaID', N'unk', NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails',NULL, N'CharName'),
(224, N'Asta Unk 2', N'ItemUID', N'ItemID', N'AstaID', N'unk', NULL, NULL, NULL, NULL, NULL, NULL, N'ItemName', N'ItemDetails',NULL, N'CharName');
GO