Action

...tes the Craftname of items based on: The character's job (0–5) The item type (e.g. weapons, armor, accessories, cape) When does it run? When the character logs out ActionType = 108). How does the Craftname work? The Craftname is a 20-character string made of 10 values, each 2 digits long (e.g. 50505000000050404070): STR DEX REC INT WIS LUC...

...his table /* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/ BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON COMMIT ...

...> usp_Insert_Chat_Log_E DECLARE @Sentencee varchar(max) , @Pointss varchar(max) SET @Pointss = (SELECT point FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID) IF( @ActionType = '114') BEGIN IF (@Value2 = '100212') BEGIN UPDATE PS_UserData.dbo.Users_Master SET Point = Point + ( 10 * @Value4 ) WHERE UserUID = @UserUID END IF (@Value2 = '100213') ...

...LTER DATABASE [ACCOUNT_DBF] SET COMPATIBILITY_LEVEL = 130 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [ACCOUNT_DBF].[dbo].[sp_fulltext_database] Action = 'enable' end GO ALTER DATABASE [ACCOUNT_DBF] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [ACCOUNT_DBF] SET ANSI_NULLS OFF GO ALTER DATABASE [ACCOUNT_DBF] SET ANSI_P...

...e current IP This is the code I wrote in an attempt to do this functionality, but it is not working, someone with more experience in sql can help I will enjoy it :) IF ( ActionType = 107 ) BEGIN if exists (Select * from PS_GameLog.dbo.Char_Enter_Leave_Log where UserUID UserUID) begin update PS_UserData.dbo.Users_Master Set UserIP = (select UserIP f...

x

/*Sistemas reset pvp rank*/ DECLARE resetKill int IF ActionType = '108' BEGIN IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 1000000 ) BEGIN UPDATE PS_GameData.dbo.Chars SET K1 = 0 WHERE CharID = ChariD UPDATE PS_G...

#removed

...automatically stack the items in inventory. It works by relogging. You need to be implement this code in: PS_GameLog -> Programmability -> Store Procedures -> dbo.usp_Insert_Action_Log_E IF @ActionType = '108' BEGIN -- Merge Consumable items DECLARE @MyCursor CURSOR, @RowID INT, @RowID2 INT, @Count INT, @Count2 INT, @MaxCount INT, @ItemID INT SET @M...

You can try using a trigger! USE [PS_GameLog] GO /****** Object: Trigger [dbo].[Action] Script Date: 07/24/2011 18:54:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [dbo].[Action] on [PS_GameLog].[dbo].[ActionLog] for insert as DEC...

you can try to use something like this in your procedure -- ActionType: 114 = Get AP by Selling Item to NPC -- ActionType: 112 = Get AP by using it SET @AT = 112 IF ( ActionType = @AT ) BEGIN -- 50 AP Card IF (@ItemID = 100218) ...

...hor: <[Dev]Velocity> -- Create date: <12-11-18> -- Description: <Get DP> -- ============================================= CREATE trigger [dbo].[GetDP] on [PS_GameLog].[dbo].[ActionLog] after insert, update as begin declare UserUID int = (select UserUID from inserted) DECLARE ChariD int = (select CharID from inserted) DECLARE ActionType tinyint = (Select ...

Instead of a procedure use a trigger. USE [PS_GameLog] GO /****** Object: Trigger [dbo].[Action] Script Date: 12/09/2018 16:26:19 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [dbo].[Action] on [PS_GameLog].[dbo].[ActionLog] for insert as DEC...

...f you can make video I will be thanking you already excuse my English There's nothing complicated about this script. Insert the following code into PS_Gamelog.dbo.usp_Insert_Action_Log_E DECLARE Nome varchar(30),@K1 int SET Nome = (SELECT CharName FROM PS_GameData.dbo._CreatedChars WHERE CharID = ChariD) SET @K1 = (SELECT K1 FROM PS_GameData...