Intellect
|
Last Activity: 10/18/2013 16:45
Mentions
| 03/26/2023 |
| 23:45 - leiwis mentioned Intellect in post Reset Stat point Bug ...if(@Operation = 41 and slot_To = 255 and (@ItemRefID = 465562)) --Stat Reset Scroll--
begin
WAITFOR DELAY '00:00:03';
declare strength smallint
declare Intellect smallint
declare maxlevel tinyint
declare remainstatPoint smallint
select maxlevel = MaxLevel from SRO_VT_SHARD.._Char where CharID = @CharID
s... |
| 02/22/2020 |
| 13:29 - NorseGodTyr mentioned Intellect in post need fix bug scroll reset stat ...get to add operation = 41 this was if you are using the scroll
IF ( operation = 41 and itemRefID = 51624)
begin
declare strength int
declare Intellect int
declare maxlevel int
declare remainstatPoint int
select maxlevel = MaxLevel from _Char where CharID = ChariD
set remainstatPo... |
| 03:59 - ZαKuRα mentioned Intellect in post need fix bug scroll reset stat ...this could work for you :rollsafe:
SRO_VT_LOG.dbo._AddLogItem
if(@ItemRefID = '51624') --- remove stats
begin
declare strength int
declare Intellect int
declare maxlevel int
declare remainstatPoint int
select maxlevel = MaxLevel from SRO_VT_SHARD.dbo._Char where CharID = ChariD
... |
| 02/21/2020 |
| 16:54 - ...name16'.
IF(@EventID = 6)
BEGIN
if exists ( select CharID from SRO_VT_SHARDLOG..RESET_STAT where Charid = ChariD and TT = 0)
begin
declare strength smallint
declare Intellect smallint
declare maxlevel tinyint
declare remainstatPoint smallint
select maxlevel = MaxLevel from SRO_VT_SHARD.._Char where CharID = ChariD
set remainstatPoint = maxlevel... |
| 02/20/2020 |
| 18:35 - sonzenbi mentioned Intellect in post need fix bug scroll reset stat ... end
IF(@EventID = 6)
BEGIN
if exists ( select CharID from LOG_DB..RESET_STAT where Charid = ChariD and TT = 0)
begin
declare strength smallint
declare Intellect smallint
declare maxlevel tinyint
declare remainstatPoint smallint
select maxlevel = MaxLevel from SRO_VT_SHARD.._Char where CharID = ChariD
... |
| 13:23 - ...eed fix this bug or make this scroll work in town only
this my Procedure
if(@JobID = '34137')
begin
declare strength int
declare Intellect int
declare maxlevel int
declare remainstatPoint int
select maxlevel = MaxLevel from _Char where CharID = ChariD
set r... |
| 02/26/2018 |
| 03:32 - athena1410 mentioned Intellect in post Reset Stats scroll Problem ...1 xxx -1 xxx 0 0 0
_AddLogItem-Sro.Vt.Log
IF (@Operation = 16) AND itemRefID = 46357 -- Stat Reset Scroll
BEGIN
declare strength int
declare Intellect int
declare maxlevel int
declare remainstatPoint int
select maxlevel = MaxLevel from _Char where CharID = ChariD
set r... |
| 03/08/2017 |
| 00:17 - Deleted Posts |
| 00:16 - White Ros3 mentioned Intellect in post Stat Scroll Dosent work help! USE This
IF (@Operation = 41) -- remove stats
BEGIN
IF (@ItemRefID = 93002) --- RefObjCommon ID-----
BEGIN
declare strength int
declare Intellect int
declare maxlevel int
declare remainstatPoint int
select maxlevel = MaxLevel from SRO_VT_SHARD.DBO._Char where CharID = ChariD
... |
| 02/26/2017 |
| 16:35 - DevilArrow mentioned Intellect in post Stat Scroll Dosent work help! ...'Stat scroll Item ID Here' )
BEGIN
IF ( operation = '41')
BEGIN
declare strength int
declare Intellect int
declare maxlevel int
declare remainstatPoint int
select maxlevel = MaxLevel from SRO_VT_SHARD.DBO._Char where CharID = @CharI... |
| 06/04/2016 |
| 10:36 - Deleted Posts |






