الموقع العربي الاول للعبة Silkroad Online - بخصوص Scroll Change Name سؤال ؟

- قسم المواضيع المكررة و المخالفة (https://silkroad4arab.com/vb/forumdisplay.php?f=58)

- - بخصوص Scroll Change Name سؤال ؟ (https://silkroad4arab.com/vb/showthread.php?t=536913)

بخصوص Scroll Change Name سؤال ؟

انا دلوقتى مش عارف اعدل على فى الملف ده _AddTimedJob

كود:

USE [SRO_VT_SHARD]

GO

/****** Object:  StoredProcedure [dbo].[_AddTimedJob]    Script Date: 11/13/2013 16:22:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO



ALTER   procedure [dbo].[_AddTimedJob]

@CharID            int,

@Category        tinyint,

@JobID            int,

@TimeToKeep    int,

@Data1            int,

@Data2            int,

--##begin due to develop composite item

@Data3            int,

@Data4            int,

@Data5            int,

@Data6            int,

@Data7            int,

@Data8            int,

@Serial64        bigint,

@JID            int

--##end due to develop composite item

as

    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))

                return -1

            if (@TimeToKeep <= 0)

                return -2

            declare @NewJobID int

            set @NewJobID = 0



            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader

            --##If you want to only have one not both, then just modify the line below!

            if (@JobID = 1 or @JobID = 2)

            BEGIN

                insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)

                values(@CharID, @Category, @JobID, 1, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)

            END

            ELSE

            BEGIN

                --##begin due to develop composite item

                insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)

                values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)

            END

                --##end due to develop composite item

            set @NewJobID = @@identity

            if (@@error <> 0 or @@rowcount = 0)

                

                return -3

     return @NewJobID

ده اللى موجود فى الداتابيز بتاعتى عايز بقى احط دول
احطهم ازاى
ADDTimedJob_

كود:

    if(@JobID = '45000') - 

        BEGIN 

declare @CharName16 varchar(64) 

         Select @CharName16=CharName16 from _Char where CharID = @CharID 

         Update _Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID 

            return -3 

        END

Bilgi

كود:

--##begin due to develop composite item

@Data3            int,

@Data4            int,

@Data5            int,

@Data6            int,

@Data7            int,

@Data8            int,

@Serial64        bigint,

@JID            int

--##end due to develop composite item

as



as'dan sonraki bِlüme ekleyiniz. 



قِyle devam etsin. Yapamazsan‎z forumdan yaz‎n :)



    if(@JobID = '34006') -- Mudar nome do char 

        BEGIN 

declare @CharName16 varchar(64) 

         Select @CharName16=CharName16 from _Char where CharID = @CharID 

         Update _Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID 

            return -3 

        END  

    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))

                return -1

            if (@TimeToKeep <= 0)

                return -2

            declare @NewJobID int

            set @NewJobID = 0

يارب حد يرد علينا السنه دى

علـى فكــرة الـ Scroll Change Name مـش شغـالـة أصـلآ , أنـا جـربتهـا عنـدى ومـش شغـالـة..

تمام شكرا طب حضرتك ان كنت عايز اعرف بس استفسار عن حاجه عايز اجابته واقفل الموضوع بعديها ال Survival Area لو Srirya Clash
ليهم Event Or Arena
وشكرا

اتفضل يا برو بس ادعيلي بئا ^^

كود PHP:

USE [PS_GameData] GO ALTER TABLE Chars ALTER COLUMN [UserID] [varchar](12) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL ALTER TABLE Chars ALTER COLUMN [OldCharName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NULL GO DROP INDEX IX_Chars_CharName ON PS_GameData.dbo.Chars GO ALTER TABLE Chars ALTER COLUMN [CharName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL GO USE [PS_GameData] GO /****** Object: Index [IX_Chars_CharName] Script Date: 03/28/2010 10:17:12 ******/ CREATE NONCLUSTERED INDEX [IX_Chars_CharName] ON [dbo].[Chars] ( [CharName] ASC )WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY] GO set ANSI_NULLS ON set QUOTED_IDENTIFIER OFF GO

و لو قبلتك اي مشكلة استخدم ده ..

كود PHP:

ALTER Proc [dbo].[usp_Save_Char_Name_E] @ServerID tinyint, @CharID int, @OldCharName nvarchar(30), @NewCharName nvarchar(30) AS SET NOCOUNT ON --SET XACT_ABORT ON --DECLARE @NameCnt int --DECLARE @Ret int SET @OldCharName = LTRIM(RTRIM(@OldCharName)) SET @NewCharName = LTRIM(RTRIM(@NewCharName)) --SET @Ret = 0 IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@NewCharName AND Del=0) BEGIN RETURN -2 END --BEGIN TRANSACTION UPDATE Chars SET CharName=@NewCharName,RenameCnt=RenameCnt-1,OldCharName=@OldCharName WHERE CharID=@CharID AND Del=0 IF @@ERROR <> 0 BEGIN GOTO ERROR_ROLLBACK END UPDATE Guilds SET MasterName=@NewCharName WHERE MasterCharID=@CharID --IF @@ERROR <> 0 --BEGIN -- GOTO ERROR_ROLLBACK --END UPDATE FriendChars SET FriendName=@NewCharName WHERE FriendID=@CharID --IF @@ERROR <> 0 --BEGIN -- GOTO ERROR_ROLLBACK --END UPDATE BanChars SET BanName=@NewCharName WHERE BanID=@CharID --IF @@ERROR <> 0 --BEGIN -- GOTO ERROR_ROLLBACK --END INSERT INTO CharRenameLog( ServerID, CharID, CharName) VALUES(@ServerID, @CharID, @NewCharName ) --UPDATE PS_USERDB01.PS_UserData.dbo.CreatedChars SET CharName=@NewCharName WHERE ServerID=@ServerID AND CharID=@CharID --IF @@ERROR <> 0 --BEGIN -- GOTO ERROR_ROLLBACK --END --COMMIT TRANSACTION RETURN 1 ERROR_ROLLBACK: --ROLLBACK TRANSACTION RETURN -2 SET NOCOUNT OFF

.. و هاعمل موضوع بيها انشاء الله :)