Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 13:10

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

Advertisement



Stored proc doesnt work after reinstalling PC

Discussion on Stored proc doesnt work after reinstalling PC within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2011
Posts: 144
Received Thanks: 23
Stored proc doesnt work after reinstalling PC

Hey guys!

I my problem is that I edited a vSRO database included a "Skill reset scroll" 2 months ago and it worked well. Since I reinstalled my PC and also the MSSQL 08 R2, that certain scroll (Skill reset) hasn't been working... I've checked the procedures in the database SRO_VT_LOG but everything is OK. So, my question is that: could reinstalling a PC causes that prevoius stored procedures not working ? Or am I dumb and the problem is not this, another - and what's that ?

Help me, guys !
Thx
-NS
NagySandor96 is offline  
Old 10/09/2016, 19:38   #2
 
elite*gold: 0
Join Date: Apr 2015
Posts: 1,444
Received Thanks: 1,371
Show us the Producer?
​Goofie​ is offline  
Old 10/09/2016, 20:07   #3
 
elite*gold: 0
Join Date: Oct 2011
Posts: 144
Received Thanks: 23
Here you are:

<start>

if(@Operation = 41 and @To = 255 and (@ItemRefID = 150001)) --Skill Reset--
begin
declare @SP int
declare @SPMastery int
SELECT @SP = SUM(SRO_VT_SHARD.._RefSkill.ReqLearn_SP) FROM SRO_VT_SHARD.._RefSkill, SRO_VT_SHARD.._CharSkill WHERE SRO_VT_SHARD.._RefSkill.ID=SRO_VT_SHARD.._CharSkil l.SkillID AND SRO_VT_SHARD.._CharSkill.CharID=@CharID AND SRO_VT_SHARD.._RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @SPMastery = SUM(SRO_VT_SHARD.._RefLevel.Exp_M) FROM SRO_VT_SHARD.._CharSkillMastery, SRO_VT_SHARD.._RefLevel WHERE SRO_VT_SHARD.._RefLevel.Lvl=SRO_VT_SHARD.._CharSki llMastery.Level AND SRO_VT_SHARD.._CharSkillMastery.CharID=@CharID AND SRO_VT_SHARD.._CharSkillMastery.Level <= '120'
UPDATE SRO_VT_SHARD.._Char SET RemainSkillPoint=RemainSkillPoint @SP @SPMastery+2000000 WHERE CharID=@CharID
DELETE SRO_VT_SHARD.._CharSkill FROM SRO_VT_SHARD.._RefSkill, SRO_VT_SHARD.._CharSkill WHERE SRO_VT_SHARD.._RefSkill.ID=SRO_VT_SHARD.._CharSkil l.SkillID AND SRO_VT_SHARD.._CharSkill.CharID=@CharID AND SRO_VT_SHARD.._RefSkill.ReqCommon_MasteryLevel1 <= '120' AND SRO_VT_SHARD.._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE SRO_VT_SHARD.._CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'
end
NagySandor96 is offline  
Old 10/09/2016, 20:47   #4
 
elite*gold: 0
Join Date: Jul 2011
Posts: 69
Received Thanks: 38
Why did you use @To .. Remove this
Kai· is offline  
Old 10/09/2016, 21:15   #5
 
elite*gold: 0
Join Date: Oct 2011
Posts: 144
Received Thanks: 23
Nothing has changed... the problem still exist... :/
NagySandor96 is offline  
Reply


Similar Threads Similar Threads
about [STORED PROC]
05/11/2014 - SRO Private Server - 0 Replies
hello epvp i want to know what is the STORED PROC and what his job need some tips



All times are GMT +1. The time now is 13:10.


Powered by vBulletin®
Copyright ©2000 - 2024, 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 ©2024 elitepvpers All Rights Reserved.