text1

...ammability -> Stored Procedures -> usp_Insert_Action_Log_E click on modify IF @ActionType = 104 AND MapiD NOT IN (40, 35, 36) BEGIN DECLARE killername VARCHAR(50) = text1; DECLARE viCtiMName VARCHAR(50) = @CharName; DECLARE @BountyPoints INT; DECLARE killeruID INT; DECLARE @BountyNoticeMsg NVARCHAR(200); -- Prüfen, o...

Create this https://bit.ly/3KIFm3j Create Table https://bit.ly/3AIl6ud Chat Log https://bit.ly/3RfZr3o Add this to usp_Insert_Action_Log_E https://bit.ly/3Rtap5i https://www.youtube...

...tracted lapis - Value4 - ItemUID - of the extracted lapis - Value5 - unknown - Value6 - Extraction cost - Value7 - Success (1), Failure (0) - Value8 to Value10 - null - Text1 - ItemName - Text2 - Lapis name - Text3 - Item properties Thanks To LordBeno for even Putting the idea to me and providing the above info SO lets Make a table to hold th...

...obID = vaLue3 and Text3 = text3 ORDER BY ActionTime) IF @BossAtacadoGBR IS NULL BEGIN INSERT INTO PS_GameLog.dbo.Boss_Damage (MobID, MapID, ActionTime, ActionType, Text1, Text3, CharLevel) VALUES vaLue3, @MapID, @ActionTime, @ActionType, text1, text3, @CharLevelGBR) DECLARE @ReTuRn_valuebannotice int DECLARE @bossatacado varchar(max) ...

#removed

#removed

...IF EXISTS (SELECT ItemID FROM PS_GameDefs.dbo.Items WHERE ItemID = @Value2 AND ReqOg='1') BEGIN INSERT INTO Non_TradeableItemsDropLogs VALUES (@UserID,@CharName, @Value2, @Text1, @ActionTime) UPDATE PS_UserData.dbo.Users_Master SET [Status]=-2 WHERE UserUID=@UserUID DECLARE @return_value int SET @CharID = (SELECT top 1 CharID FROM PS_GameData....

...Obelisk.ini BEGIN SET UserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = text3) INSERT INTO PS_GameLog.dbo.Boss_Death_Log VALUES (@Value3, text1, UserUID, text3, MapiD, posX, posy, posz, actiontime) DECLARE ReTuRn_value int DECLARE boss varchar(max) SET boss = N'/nt ' + text1 + ' Killed B...

...es to the ones from the Obelisk.ini BEGIN SET UserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = text3) INSERT INTO Boss_Death_Log VALUES (@Value3, text1, UserUID, text3, @MapID, @PosX, @PosY, posz, @ActionTime) END

...er]( [RowID] [int] IDENTITY(1,1) NOT NULL, [UserUID] [int] NOT NULL, [UserID] [varchar](20) NOT NULL, [CharID] [int] NOT NULL, [CharName] [varchar](20) NOT NULL, [Text1] [varchar](255) NOT NULL, [Text2] [varchar](255) NOT NULL, [Test3] [varchar](255) NOT NULL, [ActionTime] [datetime] NOT NULL ) ON [PRIMARY] GO IF (@ActionType = 1...

...es to the ones from the Obelisk.ini BEGIN SET UserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = text3) INSERT INTO Boss_Death_Log VALUES (@Value3, text1, UserUID, text3, @MapID, @PosX, @PosY, posz, @ActionTime) END Where does this go? please help. Thanks

...the ones from the Obelisk.ini BEGIN SET UserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = text3) INSERT INTO Boss_Death_Log VALUES (@Value3, text1, UserUID, text3, @MapID, @PosX, @PosY, posz, @ActionTime) END

...ime DATETIME, @ActionType TINYINT, @Value1 BIGINT, @Value2 INT, @Value3 INT, @Value4 BIGINT, @Value5 INT, @Value6 INT, @Value7 INT, @Value8 INT, @Value9 INT, @Value10 INT, @Text1 VARCHAR(100), @Text2 VARCHAR(100), @Text3 VARCHAR(100), @Text4 VARCHAR(100)', @UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @Actio...