Cant DELETE Character HELP!

Results 1 to 2 of 2
  1. #1
    Valued Member Lenstaber is offline
    MemberRank
    Sep 2012 Join Date
    127Posts

    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


  2. #2
    Member diemorko is offline
    MemberRank
    Nov 2015 Join Date
    70Posts

    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.



Advertisement