Set Advanced Class in SQL?

[snodd11]

Hey guys, I'm trying to find how to set an advanced class on other players in the SQL so they dont need to do the class change job. Do anyone know wher ein the SQL this would be? I being looking around but cant seem to find anything.

[PenguinJoe]

Dude, what exactly do you call a "real search"? What keywords should he use that will actually return something of value? if you don't know the answer either keep your ignorance to yourself or simply say "I don't know". Flaming someone on a bulletin board system for simply asking a question only highlights the fact that you don't know the answer.

@snodd11:

There are a few ways of doing this. The safest is to simply auto-set to the 1st page of the secondary job when the character is created at level 1. The first page of the secondary job is always the class value in the database + 1 (secondary job page 2 is that value + 2). My suggestion is to do tis automatically in your

RohanGame/Programability/Stored Procedures/dbo.ROHAN_CreateCharacter

Stored procedure. The highlighted part of the stored procedure snippet will do this for you and give the player a job-change stone to switch to the second page when they need to.

 Spoiler

exec @ret = LOCAL_InsTCharacter @char_id output, @name, @ctype_id, @cface_id, @chair_id, @user_id, @mode, @world_id
if @ret <> 0 goto ERR

-- automatically change job to a 2nd class
UPDATE TCharacter set ctype_id = ctype_id + 1 where id = @char_id;
-- add a job change stone to inventory
INSERT INTO [RohanGame].[dbo].[TEventItem]([type],[attr],[stack],[rank],[equip_level],[equip_strength],[equip_dexterity],[equip_intelligence],[char_id],[date])VALUES(2884582,0x00,1,0,0,0,0,0,@char_id,GETDATE( ));

[PenguinJoe]

Originally Posted by kelvz002

better this way.. lols

(relogin for change job)
RohanGame>Programmability>System Stored Procedures>ROHAN_EndGame

 Spoiler

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

lol, if you say so.

Make them wait until lvl 50 and then just to set 1st page with no means to change their job to the second page.

Yeah, that's way better