Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Coding Corner
You last visited: Today at 22:20

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

Advertisement



(HELP) WRONG PROCEDURE STAT/SKILL RESET SCROLLS?

Discussion on (HELP) WRONG PROCEDURE STAT/SKILL RESET SCROLLS? within the SRO Coding Corner forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2011
Posts: 228
Received Thanks: 18
Thumbs up (HELP) WRONG PROCEDURE STAT/SKILL RESET SCROLLS?

Hello mates, when i use stat reset scroll and skill reset scroll, game says my lvl is too low, and i used it with gm lv 110 char full far farm and full stats points used, whats wrong with my procedure? : (SHARDLOG - ADDLOGITEM):

Quote:
-- Stat Point / Skill Recall Scrolls
IF ( @ = '41') AND @RefID BETWEEN '41799' AND '41800'
BEGIN
DECLARE @Type int
SELECT @Type = CASE WHEN @RefID = '41799' THEN '1' -- Skill Reset
WHEN @RefID = '41800' THEN '2' -- Stats Reset
ELSE 0 END
IF @Type = '1'
BEGIN
DECLARE @SP int = (SELECT SUM(RS.ReqLearn_SP) -- CLUE THE SKILL POINTS BY SKILLS
FROM SRO_VT_SHARD.dbo._RefSkill RS

INNER JOIN SRO_VT_SHARD.dbo._CharSkill CS
ON RS.ID = CS.SkillID

WHERE CS.CharID = @D
AND RS.ReqCommon_MasteryLevel1 <= '110')

DECLARE @MASTERY int = (SELECT SUM(RF.Exp_M) -- CLUE THE LEVEL MASTERY
FROM SRO_VT_SHARD.dbo._CharSkillMastery CSM

INNER JOIN SRO_VT_SHARD.dbo._RefLevel RF
ON RF.[Lvl] = CSM.[Level]

WHERE CSM.[CharID] = @D
AND CSM.[Level] <= '110')

--- START UPDATING
UPDATE SRO_VT_SHARD.dbo._Char
SET RemainSkillPoint = RemainSkillPoint + @SP @MASTERY+'3000000'
WHERE CharID = @D

-- START DELETING
DELETE SRO_VT_SHARD.dbo._CharSkill
FROM SRO_VT_SHARD.dbo._RefSkill RFS , SRO_VT_SHARD.dbo._CharSkill CSL
WHERE RFS.ID = CSL.SkillID
AND CSL.CharID = @D
AND RFS.ReqCommon_MasteryLevel1 <= '110'
AND RFS.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)

-- UPDATING LINE
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery
SET [LEVEL] = '0'
WHERE CharID = @D
AND Level <= '110'

END

-- Stats Recall
IF @Type = '2'
BEGIN
DECLARE @ INT , @ INT , @ INT , @ INT

SELECT @ = CurLevel FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @D

SET @ = @*3)-3
SET @ = @+ 19

-- UPDATING LINE
UPDATE SRO_VT_SHARD.dbo._Char
SET Strength = @ , Intellect = @ , RemainStatPoint = @
WHERE CharID = @D

-- Begin DELETE SnowShield if ACTIVE
DELETE FROM SRO_VT_SHARD.dbo._CharSkill WHERE SkillID BETWEEN '8092' AND '8122'
AND CharID = @D
END
END

I FOUNDED THE SOLUTION!!

Both IDs was lv 120 on rejobjcommon (just slide the bar on the table and u will find REQLV1u will see levels below), my server is 110 so changed from 120 to 110, no needs media modify.
ThievesUTD is offline  
Reply


Similar Threads Similar Threads
(HELP) WRONG PROCEDURE STAT/SKILL RESET SCROLLS?
09/01/2018 - SRO Private Server - 3 Replies
Hello mates, when i use stat reset scroll and skill reset scroll, game says my lvl is too low, and i used it with gm lv 110 char full far farm and full stats points used, whats wrong with my procedure? : (SHARDLOG - ADDLOGITEM):
Any way to reset STAT points? (not using a stat reset scroll)
02/12/2016 - SRO Coding Corner - 5 Replies
Hey folks i tryed with item scroll reset stat, it works allmost perfect but those dc is rly sux... I saw at some private server that they have some like coded procedure starting to be active when you write something in your for example private chat(and it give nice reset stat without DC) chat: $Reset Reset_stats thats only example.
[Selling] 101lvl Rogue/Bard [Pavo] + skill and stat reset scrolls
05/26/2013 - Silkroad Online Trading - 0 Replies
im selling CLEAN char in server pavo 101lvl FF rogue/bard with 2x skill and 1x stat reset scrolls 3inv pages dead pick pet and 25 reverses i accept gold in centaurus or 10euro paypal/psc PM ME
WTS 2x 114 Bard/Cleric on Orion (Skill reset,Stat reset, Prem+,1000% 10x)
12/11/2012 - Silkroad Online Trading - 5 Replies
- 2x 114 Bard/Cleric on Orion All have: - 1 Skill reset - 1 Stat reset - Prem+ - 1000% 10x more then 1b Gold on 2 Accounts. Cheap!!
WTS 95 heuskal nuker PERSIA [with STAT/SKILL RESET SCROLLS] SEE PROOF INSIDE!!
02/20/2012 - Silkroad Online Trading - 2 Replies
95 heuskal nuker FF in server PERSIA heuk/fire/cold some light +3+4+5 prot set +5 spear FB sun/som accs +3 3 avatars email verified STILL HAS STAT/SKILL RESET SCROLLS...NOT DELETED!!!!!! SEE PROOF



All times are GMT +1. The time now is 22:21.


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.