-
Valued Member
Cant DELETE Character HELP!
hello i am using season 4.1 of muemu.pl files and when i try to delete character it writes: you have entered an invalid personal id number
i tried to change id at sql in Tables/MEMB_INFO but unfortunately
also found wz_deletecharacter and there is written:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_DeleteCharacter] Script Date: 03/15/2016 23:28:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_DeleteCharacter]
@account varchar(10),
@name varchar(10)
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @result tinyint
SET @result = 0
If NOT EXISTS ( SELECT Name FROM Character WHERE Name = @name )
begin
SET @result = 0
end
else
begin
SET @result = 1
DELETE FROM Character WHERE AccountID = @account AND Name= @name
DELETE FROM OptionData WHERE Name = @name
DELETE FROM QuestKillCount WHERE Name = @name
DELETE FROM MasterSkillTree WHERE Name = @name
DELETE FROM EventLeoTheHelper WHERE Name = @name
DELETE FROM EventSantaClaus WHERE Name = @name
DELETE FROM RankingDuel WHERE Name = @name
DELETE FROM RankingBloodCastle WHERE Name = @name
DELETE FROM RankingChaosCastle WHERE Name = @name
DELETE FROM RankingDevilSquare WHERE Name = @name
DELETE FROM RankingIllusionTemple WHERE Name = @name
end
SELECT @result
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
so i dont know whats problem please help
-
-
Member
Re: Cant DELETE Character HELP!
sno__numb set to 111111111111111111 and it will work!
Last edited by diemorko; 19-03-16 at 11:21 AM.