- Joined
- Feb 11, 2013
- Messages
- 37
- Reaction score
- 0
i'm add Reset stats and worked with me.. but after some edit's
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!for no DC remove
return -3
use and teleport
Msg 2714, Level 16, State 6, Line 2
There is already an object named '_TimedJob' in the database.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@JobID".
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 8
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 9
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 10
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 11
Must declare the scalar variable "@CharID".
USE [SRO_VT_SHARD]
GO
/****** Object: Table [dbo].[_TimedJob] Script Date: 01/15/2014 11:02:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_TimedJob](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CharID] [int] NOT NULL,
[Category] [tinyint] NOT NULL,
[JobID] [int] NOT NULL,
[TimeToKeep] [int] NOT NULL,
[Data1] [int] NULL,
[Data2] [int] NULL,
[Data3] [int] NULL,
[Data4] [int] NULL,
[Data5] [int] NULL,
[Data6] [int] NULL,
[Data7] [int] NULL,
[Data8] [int] NULL,
[Serial64] [bigint] NOT NULL,
[JID] [int] NULL,
CONSTRAINT [PK__TimedJob] PRIMARY KEY NONCLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[_TimedJob] ADD DEFAULT (0) FOR [Data3]
GO
ALTER TABLE [dbo].[_TimedJob] ADD DEFAULT (0) FOR [Data4]
GO
ALTER TABLE [dbo].[_TimedJob] ADD DEFAULT (0) FOR [Data5]
GO
ALTER TABLE [dbo].[_TimedJob] ADD DEFAULT (0) FOR [Data6]
GO
ALTER TABLE [dbo].[_TimedJob] ADD DEFAULT (0) FOR [Data7]
GO
ALTER TABLE [dbo].[_TimedJob] ADD DEFAULT (0) FOR [Data8]
GO
ALTER TABLE [dbo].[_TimedJob] ADD DEFAULT (0) FOR [Serial64]
GO
ALTER TABLE [dbo].[_TimedJob] ADD DEFAULT (0) FOR [JID]
GO
if(@JobID= '33801')
begin
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '120'
UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalSPMastery+200000 WHERE CharID=@CharID
DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)
UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'
end