Register for your free account! | Forgot your password?

You last visited: Today at 05:59

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Release] Collection of Reset Scrolls

Discussion on [Release] Collection of Reset Scrolls within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old   #1
 
Zidane*'s Avatar
 
elite*gold: 0
Join Date: Jul 2017
Posts: 4
Received Thanks: 14
Arrow [Release] Collection of Reset Scrolls

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

Attached Files
File Type: rar Reset Scrolls.rar (17.1 KB, 1286 views)
Zidane* is offline  
Thanks
5 Users
Old 08/03/2017, 14:56   #2
 
elite*gold: 0
Join Date: Mar 2010
Posts: 114
Received Thanks: 24
thanks mate.
abdoelking77 is offline  
Old 08/03/2017, 15:05   #3

 
XxGhostSpiriTxX's Avatar
 
elite*gold: 53
Join Date: Jul 2012
Posts: 542
Received Thanks: 191
thanks
XxGhostSpiriTxX is offline  
Old 08/03/2017, 15:09   #4
 
elite*gold: 0
Join Date: Feb 2016
Posts: 652
Received Thanks: 342
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
EdwardTeach+- is offline  
Old 08/03/2017, 15:16   #5
 
Zidane*'s Avatar
 
elite*gold: 0
Join Date: Jul 2017
Posts: 4
Received Thanks: 14
Cool Test It Before speaking :)

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
Zidane* is offline  
Old 08/03/2017, 15:17   #6
 
elite*gold: 0
Join Date: Feb 2016
Posts: 652
Received Thanks: 342
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
EdwardTeach+- is offline  
Old 08/03/2017, 15:35   #7
 
cristianxi's Avatar
 
elite*gold: 0
Join Date: May 2010
Posts: 377
Received Thanks: 212
Quote:
Originally Posted by EdwardTeach+- View Post
when you're in guild it will bug ur char simple
+1
cristianxi is offline  
Old 08/03/2017, 17:15   #8
 
blapanda's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 760
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.
blapanda is offline  
Thanks
1 User
Old 08/03/2017, 19:35   #9
 
cristianxi's Avatar
 
elite*gold: 0
Join Date: May 2010
Posts: 377
Received Thanks: 212
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].[_CharSet CharName16 '[Senior]' + @CharName16 where CharID = @CharID
        END 
cristianxi is offline  
Old 08/03/2017, 21:11   #10
 
elite*gold: 0
Join Date: Feb 2016
Posts: 652
Received Thanks: 342
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].[_CharSet CharName16 '[Senior]' + @CharName16 where CharID = @CharID
        END 
totally same.
EdwardTeach+- is offline  
Old 08/04/2017, 01:46   #11

 
elite*gold: 16
Join Date: May 2012
Posts: 200
Received Thanks: 100
Quote:
Originally Posted by EdwardTeach+- View Post
totally same.
+1
Spitze.. is offline  
Old 08/04/2017, 04:38   #12
 
blapanda's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 760
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].[_CharSet 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.
blapanda is offline  
Old 08/04/2017, 05:07   #13
 
Syloxx's Avatar
 
elite*gold: 56
Join Date: Oct 2013
Posts: 1,165
Received Thanks: 774
just use the procedure "_RenameByCharID" and you won't run into any problems lol
Syloxx is offline  
Old 08/04/2017, 19:23   #14
 
elite*gold: 0
Join Date: Feb 2016
Posts: 652
Received Thanks: 342
Quote:
Originally Posted by Syloxx View Post
just use the procedure "_RenameByCharID" and you won't run into any problems lol
_RenameCharNameByID*
EdwardTeach+- is offline  
Thanks
1 User
Old 02/26/2019, 22:11   #15
 
elite*gold: 0
Join Date: Jul 2010
Posts: 247
Received Thanks: 23
Dont works for me. When i use scroll. Still have 7 days Penalty in job Help
thelag2 is offline  
Reply


Similar Threads Similar Threads
[ Reset Release ] Dragon City and Monster Legends Reset [ DZTool ]
07/29/2014 - Dragon City - 10 Replies
Hello We Proudly Release DZTools Website! All Hacks are there. This Thread focuses on Reset Hacks. Dragon City Reset : Dragon City Reset Monster Legends Reset : Monster Legends Reset Thanks for using.



All times are GMT +1. The time now is 06:01.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.