[Release] Collection of Reset Scrolls

Page 1 of 2 1 2
08/03/2017 14:49 Zidane*#1
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 :bandit:

[Only registered and activated users can see links. Click Here To Register...]
08/03/2017 14:56 abdoelking77#2
thanks mate.
08/03/2017 15:05 XxGhostSpiriTxX#3
thanks
08/03/2017 15:09 EdwardTeach+-#4
First one it will bug your character.

Code:
 --# 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
08/03/2017 15:16 Zidane*#5
Quote:
Originally Posted by EdwardTeach+- View Post
First one it will bug your character.

Code:
 --# 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 :)
08/03/2017 15:17 EdwardTeach+-#6
Quote:
Originally Posted by Zidane* View Post
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
08/03/2017 15:35 cristianxi#7
Quote:
Originally Posted by EdwardTeach+- View Post
when you're in guild it will bug ur char simple
+1
08/03/2017 17:15 blapanda#8
Quote:
Originally Posted by Zidane* View Post
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 :)
Quote:
Originally Posted by EdwardTeach+- View Post
First one it will bug your character.

Code:
 --# 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.
08/03/2017 19:35 cristianxi#9
Quote:
Originally Posted by EdwardTeach+- View Post
when you're in guild it will bug ur char simple
Quote:
Originally Posted by blapanda View Post
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 
08/03/2017 21:11 EdwardTeach+-#10
Quote:
Originally Posted by cristianxi View Post
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.
08/04/2017 01:46 Spitze..#11
Quote:
Originally Posted by EdwardTeach+- View Post
totally same.
+1
08/04/2017 04:38 blapanda#12
Quote:
Originally Posted by cristianxi View Post
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.
08/04/2017 05:07 Syloxx#13
just use the procedure "_RenameByCharID" and you won't run into any problems lol
08/04/2017 19:23 EdwardTeach+-#14
Quote:
Originally Posted by Syloxx View Post
just use the procedure "_RenameByCharID" and you won't run into any problems lol
_RenameCharNameByID*
02/26/2019 22:11 thelag2#15
Dont works for me. When i use scroll. Still have 7 days Penalty in job Help :(
Page 1 of 2 1 2