HELP Changejob REcon!

[lunarrohan]

anyone who can provide where to editing changejob status. what i mean is they only need to reconnect to the game to changejob! TIA

[servro]

USE [RohanGame]
GO
/****** Object: StoredProcedure [dbo].[ROHAN_EndGame] Script Date: 04/28/2014 10:02:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO







ALTER PROCEDURE [dbo].[ROHAN_EndGame]
@char_id int
AS
set nocount on

declare @level int
declare @ctype int
declare @play_sec int
declare @ret int

--아이템 가상 처리
update titem set type = @char_id where id = 0
update tcharacterlogin set
last_date = getdate()
,login = 0
where char_id = @char_id

select @level = [level]
from tcharacterability
where char_id = @char_id

select @ctype = [ctype_id]
from tcharacter
where id = @char_id


if(@level >= 50) and (@ctype= 196993)
begin
update tcharacter set ctype_id = 196994 where id = @char_id
end

if(@level >= 50) and (@ctype= 196869)
begin
update tcharacter set ctype_id = 196870 where id = @char_id
end

if(@level >= 50) and (@ctype= 197133)
begin
update tcharacter set ctype_id = 197134 where id = @char_id
end

if(@level >= 50) and (@ctype= 197257)
begin
update tcharacter set ctype_id = 197258 where id = @char_id
end

if(@level >= 50) and (@ctype= 197653)
begin
update tcharacter set ctype_id = 197654 where id = @char_id
end

if(@level >= 50) and (@ctype= 197777)
begin
update tcharacter set ctype_id = 197778 where id = @char_id
end

if(@level >= 50) and (@ctype= 198685)
begin
update tcharacter set ctype_id = 198686 where id = @char_id
end


if(@level >= 50) and (@ctype= 198809)
begin
update tcharacter set ctype_id = 198810 where id = @char_id
end

if(@level >= 50) and (@ctype= 200741)
begin
update tcharacter set ctype_id = 200742 where id = @char_id
end

if(@level >= 50) and (@ctype= 200865)
begin
update tcharacter set ctype_id = 200866 where id = @char_id
end

if(@level >= 50) and (@ctype= 204845)
begin
update tcharacter set ctype_id = 204846 where id = @char_id
end

if(@level >= 50) and (@ctype= 204969)
begin
update tcharacter set ctype_id = 204970 where id = @char_id
end

if(@level >= 50) and (@ctype= 229437)
begin
update tcharacter set ctype_id = 229438 where id = @char_id
end

if(@level >= 50) and (@ctype= 229561)
begin
update tcharacter set ctype_id = 229562 where id = @char_id
end

select @play_sec = play_sec
from TCharacterLogin
where char_id = @char_id

exec @ret = LOCAL_InsTCharacterLogin @char_id

if @@error <> 0 or @@rowcount <> 1 return -1

--return 0


commit

--------------------------------------
return @ret
----------------------------------------------------
-- Error Process
----------------------------------------------------
ERR:
rollback
return @ret

edit in :

RohanGame>>Programability>>Stored Procedures>>dbo.ROHAN_EndGame

[wyeth331]

wow thanks this will help me alot!