Underbar help!

[RenePunik]

Same as title.. I want to start with Underbar clean any help?

[MentaL]

[lepitismak]

UPDATE _RefCharDefault_Quest SET Service = 1
delete from _CHARQUEST where QuestID = 1
INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2) SELECT CharID, 1,5,0, '2012-04-13 20:44:00','2012-04-13 20:44:00',31458135,0 FROM _CHAR where CharID > 0

backup before

[RenePunik]

It fucked my database xD

[lepitismak]

restore backup
with me work fine

[UraharaKisuke]

@lepitismak

This query is not for new Chars have a Clean underbar .... ( epic fail )

just edit : [dbo].[_AddNewClientConfig]

[RenePunik]

@lepitismak

This query is not for new Chars have a Clean underbar .... ( epic fail )

just edit : [dbo].[_AddNewClientConfig]

Yes , thanks for attention...
My _AddNewClientConfig producer Can edit it ?

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewClientConfig]    Script Date: 05/23/2014 00:22:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER PROC [dbo].[_AddNewClientConfig] @CharID    int
AS
    DECLARE @NinitialVersion    int
    DECLARE @nMaxSlotCount        tinyint
    DECLARE @nSlotSequence        tinyint

    SET @NinitialVersion = 0
    SET @nMaxSlotCount = 51
    SET @nSlotSequence = 0

    -- Version Data (0)
    insert _ClientConfig values  @CharID, 0, 0, 0, @NinitialVersion)

    -- Quick Slot Data (1)
    INSERT _ClientConfig 
        SELECT @CharID, 1, CNT, 0, 0 
        FROM _RefDummySlot WITH (NOLOCK) 
        WHERE CNT < @nMaxSlotCount

    -- HP Macro Data (11)
    insert _ClientConfig values  @CharID, 11, 0, 0, 0)

    -- MP Macro Data (12)
    insert _ClientConfig values  @CharID, 12, 0, 0, 0)

    -- Abnormal Macro Data (13)
    insert _ClientConfig values  @CharID, 13, 0, 0, 0)

    -- Potion Delay Data (14)
    insert _ClientConfig values  @CharID, 14, 0, 0, 0)