- Joined
- Oct 5, 2006
- Messages
- 215
- Reaction score
- 8
Hello everyoneI would need help for a player problemhow do you delete items from a player or remove a player's character (without deleting their account)season 4.9I thank you in advance
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
USE [Pangya_S4_TH]
GO
/****** Object: StoredProcedure [dbo].[DeleteCharacter] Script Date: 11/07/2017 01:47:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[DeleteCharacter]
@LOGIN VARCHAR(20),
@CHAR_TYPEID INT
AS
BEGIN
SET NOCOUNT ON
DECLARE @UID INT = 0
-- IF ACCOUNT IS EXISTED
IF EXISTS (SELECT 1 FROM DBO.Pangya_Member_Info WHERE userid = @LOGIN) BEGIN
-- GET UID
SELECT @UID = UID FROM DBO.Pangya_Member_Info WHERE userid = @LOGIN
-- DELETE CHARACTER
DELETE FROM DBO.Pangya_Character_Information WHERE UID = @UID AND typeid = @CHAR_TYPEID
-- IF CHARACTER DELETED
IF (@@ROWCOUNT > 0) BEGIN
UPDATE DBO.Pangya_Item_WareHouse SET Valid = 0 WHERE UID = @UID AND DBO.UDF_PART_GET_CHAR(typeid) = (0x4000000 ^ @CHAR_TYPEID)
END
END
END
GO