Register for your free account! | Forgot your password?

Go Back   elitepvpers > Silkroad Online > SRO PServer - Discussions / Questions > SRO PServer Ask the Experts
You last visited: Today at 03:17

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


(HELP) WRONG PROCEDURE STAT/SKILL RESET SCROLLS?

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2011
Posts: 21
Received Thanks: 0
(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 ( @Operation = '41') AND @ItemRefID BETWEEN '41799' AND '41800'
BEGIN
DECLARE @ScrollType int
SELECT @ScrollType = CASE WHEN @ItemRefID = '41799' THEN '1' -- Skill Reset
WHEN @ItemRefID = '41800' THEN '2' -- Stats Reset
ELSE 0 END
IF @ScrollType = '1'
BEGIN
DECLARE @TotalSP 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 = @CharID
AND RS.ReqCommon_MasteryLevel1 <= '110')

DECLARE @TSPMASTERY 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] = @CharID
AND CSM.[Level] <= '110')

--- START UPDATING
UPDATE SRO_VT_SHARD.dbo._Char
SET RemainSkillPoint = RemainSkillPoint + @[email protected]+'3000000'
WHERE CharID = @CharID

-- 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 = @CharID
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 = @CharID
AND Level <= '110'

END

-- Stats Recall
IF @ScrollType = '2'
BEGIN
DECLARE @STR INT , @INT INT , @MAXL INT , @RSP INT

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

SET @RSP = (@MaxL*3)-3
SET @MaxL = @MaxL+ 19

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

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



ThievesUTD is offline  
Old 08/20/2018, 00:21   #2
 
elite*gold: 85
Join Date: Feb 2014
Posts: 1,033
Received Thanks: 1,583
There might be a itemlevel restriction in refobjitem maybe that is over 110 for @RefID BETWEEN '41799' AND '41800'.

Sometimes its quite simple. If not... just google for another reset procedure that is on elitepvpers. There are quite a few.


Royalblade* is offline  
Thanks
1 User
Old 08/20/2018, 20:10   #3
 
elite*gold: 85
Join Date: Feb 2014
Posts: 1,033
Received Thanks: 1,583
First of all...

All procedures in Shardlog use the shardlog database.
All procedures in Shard use the Shard database.

There is no general "better" or "worse".

A LOG is made/written because it's there to save information for SMC log checking later.
Shard procedures are made because they are very importantly needed. If they fail, then something ingame will **** up. You can get disconnected, or the whole server can start to lag etc. Shard procedures are more PRONE to errors.

If you wanna know more, you should first learn SQL from tutorials, cause the issues you got are very simple so far.
Royalblade* is offline  
Old 09/01/2018, 00:26   #4
 
elite*gold: 0
Join Date: Nov 2011
Posts: 21
Received Thanks: 0
Quote:
Originally Posted by Royalblade* View Post
First of all...

All procedures in Shardlog use the shardlog database.
All procedures in Shard use the Shard database.

There is no general "better" or "worse".

A LOG is made/written because it's there to save information for SMC log checking later.
Shard procedures are made because they are very importantly needed. If they fail, then something ingame will **** up. You can get disconnected, or the whole server can start to lag etc. Shard procedures are more PRONE to errors.

If you wanna know more, you should first learn SQL from tutorials, cause the issues you got are very simple so far.
Ty bro i fixed
ThievesUTD is offline  
Reply



« How to add a teleport choise ? | Problem with map shortcut "M" »

Similar Threads
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.
100Lvl Stat/Skill reset scrolls.
08/08/2014 - SRO Ask the Experts - 1 Replies
Hello, strange thing has happened to me. I have reached 100 level and my chars have not received reset scrolls. But my other char, very old one, maybe 5 years old has reached 100 level and he got scrolls. Tell me, who is getting those scrolls and who's not?
[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 03:17.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.