Remove Points from STR/INT and Reset Skills from Char

[sherio]

i'm add Reset stats and worked with me.. but after some edit's

 

[longway]

sherio can you share it with us ?

 

[Kuruma]

Don't use MaxLevel use current level lolol

 

[arracho]

Working for me but i get dc message when i use it (not crash).

any idea?

 

[MrSaxobeat]

for no DC remove
return -3

 

[Zenox]

How did u fix it ? it just crash for me and when i log back then nothing happend
Edit: nvm, fixed

 

[sherio]

for no DC remove
return -3

and if i want char make teleport after use scroll not DC what i do ?

 

[MrSaxobeat]

use and teleport

 

[sherio]

use and teleport

bro i want scroll make automatic teleport after used .. any help ?

 

[MrSaxobeat]

i dont have this.

 

[GusToma]

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

can u help me guys !! at _TimedJop

done solved