[Release] Collection of Reset Scrolls

[Zidane*]

Hello Elitepvpers people

*New Collection of scrolls has arrived right now most problems have been fixed

*New Icons-Effects For Scrolls Added.

*Collection Contain [ Reset Change Name Scroll - Reset Stat Scroll - Reset Skill Scroll - Reset Job Penalty - Reset Holly Water Temple Time - Remove Pk Scroll]

*All Procedures Bugs/Crashes Has been fixed successful

*Any Problem while adding it to your server leave a comment with your problem and i will fix it soon possible.

if you have been notified click thanks

[abdoelking77]

thanks mate.

[XxGhostSpiriTxX]

thanks

[EdwardTeach+-]

First one it will bug your character.

 --# Reset Scrolls. Created by Zidane

	      if(@JobID = '33808') -- change charname
          begin 
declare @CharName16 varchar(64) 
         Select @CharName16=CharName16 from _Char where CharID = @CharID 
         Update _Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID 
            return -3 
        end

[Zidane*]

Originally Posted by EdwardTeach+-

First one it will bug your character.

 --# Reset Scrolls. Created by Zidane

	      if(@JobID = '33808') -- change charname
          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 my vps online right now i will record video for you but wait for tommorow or in night iwill show u then before speaking test it

[EdwardTeach+-]

Originally Posted by Zidane*

If my vps online right now i will record video for you but wait for tommorow or in night iwill show u then before speaking test it

when you're in guild it will bug ur char simple

[cristianxi]

Originally Posted by EdwardTeach+-

when you're in guild it will bug ur char simple

+1

[blapanda]

Originally Posted by Zidane*

If my vps online right now i will record video for you but wait for tommorow or in night iwill show u then before speaking test it

Originally Posted by EdwardTeach+-

First one it will bug your character.

 --# Reset Scrolls. Created by Zidane

	      if(@JobID = '33808') -- change charname
          begin 
declare @CharName16 varchar(64) 
         Select @CharName16=CharName16 from _Char where CharID = @CharID 
         Update _Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID 
            return -3 
        end

He is totally right.
There are several tables which needs to be adjusted, if being at least involved to a system like the guild stuff.
_Char, _CharNameList, _SR_ShardCharNames, _Friend, _GuildMember, _GPHistory, and many more.
Not to forget about custom tables with linked name entries.

[cristianxi]

Originally Posted by EdwardTeach+-

when you're in guild it will bug ur char simple

Originally Posted by blapanda

He is totally right.

Guys and What about Scroll Senior may be same bug ¿?

PHP Code:

IF (@Operation = '41') and (@ItemRefID = 'XXXX') 
    Begin
       declare @CharName16 varchar(64) 
    set @CharName16 = (select CharName16 from [SRO_VT_SHARD].dbo._Char where CharID = @CharID )
       UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set CharName16 = '[Senior]' + @CharName16 where CharID = @CharID
        END 


[EdwardTeach+-]

Originally Posted by cristianxi

Guys and What about Scroll Senior may be same bug ¿?

PHP Code:

IF (@Operation = '41') and (@ItemRefID = 'XXXX') 
    Begin
       declare @CharName16 varchar(64) 
    set @CharName16 = (select CharName16 from [SRO_VT_SHARD].dbo._Char where CharID = @CharID )
       UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set CharName16 = '[Senior]' + @CharName16 where CharID = @CharID
        END 


totally same.

[Spitze..]

Originally Posted by EdwardTeach+-

totally same.

+1

[blapanda]

Originally Posted by cristianxi

Guys and What about Scroll Senior may be same bug ¿?

PHP Code:

IF (@Operation = '41') and (@ItemRefID = 'XXXX') 
    Begin
       declare @CharName16 varchar(64) 
    set @CharName16 = (select CharName16 from [SRO_VT_SHARD].dbo._Char where CharID = @CharID )
       UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set CharName16 = '[Senior]' + @CharName16 where CharID = @CharID
        END 


Everything what changes names, be it even the most unimportant thing you can imagine about, needs to include every single "name referring"-table.
Counts also for adding characters manually via query.

[Syloxx]

just use the procedure "_RenameByCharID" and you won't run into any problems lol

[EdwardTeach+-]

Originally Posted by Syloxx

just use the procedure "_RenameByCharID" and you won't run into any problems lol

_RenameCharNameByID*

[thelag2]

Dont works for me. When i use scroll. Still have 7 days Penalty in job Help