Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rohan
You last visited: Today at 18:40

  • Please register to post and access all features, it's quick, easy and FREE!

 

HELP Changejob REcon!

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Dec 2013
Posts: 17
Received Thanks: 0
HELP Changejob REcon!

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



lunarrohan is offline  
Old   #2
 
elite*gold: 0
Join Date: Nov 2010
Posts: 16
Received Thanks: 0
Quote:
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 :

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


servro is offline  
Old   #3
 
elite*gold: 0
Join Date: Feb 2014
Posts: 3
Received Thanks: 0
wow thanks this will help me alot!
wyeth331 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Auto changejob REquest
anyone who can share how to autochangejob just reconnectiong i saw one here it says "this i set for auto job change lv 50 (relogin for change job)...
1 Replies - Rohan
changejob WAAT-Files
Hello, I would like to know how I do to add a NPC to change class ^ ^ Thank you for answering me :) Thank you much for its files to Elektrochemie...
8 Replies - Nostale
About fast-changejob
My fast-changejob popup window, I accidentally closed off, how can trigger it pop up again?
1 Replies - Flyff PServer - Discussions / Questions
[Source Frage] Changejob
Hallo Epvpers ich hab mal ne frage zur Source, ich hab das hier gefunden // ˬ: hacked /* int nJob; BOOL bGamma = TRUE; ar >> nJob; ar >>...
11 Replies - Flyff PServer - Discussions / Questions
[RELEASE]FlyFF Web ChangePass,ChangeJob,Reset Posi,Buffs Script
Put this to your web server. Simple Panel This script have changepass,changejob, buffs,reset position. Edit config.php by yours Download Here...
10 Replies - Flyff PServer Guides & Releases



All times are GMT +2. The time now is 18:40.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.