HELP FOR AUTO JOB CHANGE

I play rohan for localhost, me and my cousins only are playing Rohan(H3) and I configuring where can I edit or modify in the database to have a Automatic Job change at Level 50, I use binEditor and look for Job Change Certificate/Certification but we cannot find the item, and I also look in database in dbo.ROHAN.EndGame but it’s the same like what I searched earlier. Thankyou In advance!

Quote:

Originally Posted by ivan7227 I play rohan for localhost, me and my cousins only are playing Rohan(H3) and I configuring where can I edit or modify in the database to have a Automatic Job change at Level 50, I use binEditor and look for Job Change Certificate/Certification but we cannot find the item, and I also look in database in dbo.ROHAN.EndGame but it’s the same like what I searched earlier. Thankyou In advance!

If you Google or use the search Button you can find a Jobchange Script :)

Quote:

Originally Posted by AllAboutRohan If you Google or use the search Button you can find a Jobchange Script :)

I already search it bro, it’s the same result and i also compared this code to my database and it is also the same.

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]
@[Only registered and activated users can see links. Click Here To Register...]_id int
AS
set nocount on

declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...]pe int
declare @[Only registered and activated users can see links. Click Here To Register...]sec int
declare @[Only registered and activated users can see links. Click Here To Register...] int

--아이템 가상 처리
update titem set type = @[Only registered and activated users can see links. Click Here To Register...]_id where id = 0
update tcharacterlogin set
last_date = getdate()
,login = 0
where char_id = @[Only registered and activated users can see links. Click Here To Register...]_id

select @[Only registered and activated users can see links. Click Here To Register...] = [level]
from tcharacterability
where char_id = @[Only registered and activated users can see links. Click Here To Register...]_id

select @[Only registered and activated users can see links. Click Here To Register...]pe = [ctype_id]
from tcharacter
where id = @[Only registered and activated users can see links. Click Here To Register...]_id


if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 196993)
begin
update tcharacter set ctype_id = 196994 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 196869)
begin
update tcharacter set ctype_id = 196870 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 197133)
begin
update tcharacter set ctype_id = 197134 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 197257)
begin
update tcharacter set ctype_id = 197258 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 197653)
begin
update tcharacter set ctype_id = 197654 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 197777)
begin
update tcharacter set ctype_id = 197778 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 198685)
begin
update tcharacter set ctype_id = 198686 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end


if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 198809)
begin
update tcharacter set ctype_id = 198810 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 200741)
begin
update tcharacter set ctype_id = 200742 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 200865)
begin
update tcharacter set ctype_id = 200866 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 204845)
begin
update tcharacter set ctype_id = 204846 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 204969)
begin
update tcharacter set ctype_id = 204970 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 229437)
begin
update tcharacter set ctype_id = 229438 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 229561)
begin
update tcharacter set ctype_id = 229562 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

select @[Only registered and activated users can see links. Click Here To Register...]sec = play_sec
from TCharacterLogin
where char_id = @[Only registered and activated users can see links. Click Here To Register...]_id

exec @[Only registered and activated users can see links. Click Here To Register...] = LOCAL_InsTCharacterLogin @[Only registered and activated users can see links. Click Here To Register...]_id

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

--return 0


commit

--------------------------------------
return @[Only registered and activated users can see links. Click Here To Register...]
----------------------------------------------------
-- Error Process
----------------------------------------------------
ERR:
rollback
return @[Only registered and activated users can see links. Click Here To Register...]


And i try to relogin in the game but still no luck, not changing.

On character create set ctype = ctype + 1. This creates the character as it's first page job (i.e. Mage lvl 1 -> created as Warlock lvl 1). Include a job change stone (no npc needed) or job change certification (to use npc) as a part of starting items.

No muss no fuss.