[SOLVED] dont want extreme job, how to remove

[hyomi]

Hi all, how to change job selection picture?
i dont want extreme job.....just want 4 type job only

please help, where to edit

Thanks

[MentaL]

[lordskie03]

Host an Ep3 server.

[lourence8]

Host an Ep3 server.

What a Suggestion

use a fresh Data base shared here.. try to get in stickies..

ie lordskie03 can i suggest? if u cant help better not to post, God!!!

[SeiferXIII]

execute this script

USE [RanGame1]
GO
/****** Object:  StoredProcedure [dbo].[sp_Extreme]    Script Date: 04/24/2011 12:44:59 ******/
/****** PDF PIONEERS: EIFELZOCKER - THETSUYA - AUTHISTIKATED - SEIFER13 - CORREY - CRYPTICWORLD ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER   PROCEDURE [dbo].[sp_Extreme] 
    @nUserNum    int 

AS     
    DECLARE 
        @error_var int,  
        @rowcount_var int     

    SET NOCOUNT ON 

Select 9 As M, 9 As F 
From 
( 
    Select isnull(Sum(M),1) As MSum, isnull(Sum(F),1) As FSum, isnull(Sum(MS),0) As MS, isnull(Sum(FS),0) As FS 
    From 
    ( 
    Select ChaClass 
    , 
    Case ChaClass 
    When 1 Then 1 
    When 2 Then 1 
    When 256 Then 1 
    When 512 Then 1 
    Else 0 
    End As M 
    , 
    Case ChaClass 
    When 4 Then 1 
    When 8 Then 1 
    When 64 Then 1 
    When 128 Then 1 
    Else 0 
    End As F 
    , 
    Case ChaClass 
    When 16 Then  
        Case ChaDeleted 
        When 1 Then 0 
        Else 1 
        End 
    Else 0 
    End As MS 
    , 
    Case ChaClass 
    When 32 Then  
        Case ChaDeleted 
        When 1 Then 0 
        Else 1 
        End 
    Else 0 
    End As FS 
    From ChaInfo Where UserNum=@nUserNum And ( 
    ( ChaClass=16 OR ChaClass=32 ) OR  
    ( ( ChaClass=1 OR ChaClass=2 OR ChaClass=4 OR ChaClass=8 OR  
         ChaClass=64 OR ChaClass=128 OR ChaClass=256 OR ChaClass=512 ) AND ChaLevel>=5000 ) ) 
    ) As t 
) As tt

[hyomi]

@Seifer
script is not working.. in job selection screen, extreme is still appear.

another suggestion?

[ryan313]

im using ep6 s2 ranevilz.. my problem is opposite from his ...in my job sleection there is no extreme class.. i want to have a extreme class in my choicees can somebody help me.. ??




and also why is it that in my ranevilz ep6 s2 the PUM, madness and other boxes when i loot it .. its not working..no effect.. please help me..

[lourence8]

@ryan313@
use this script

use [RanGame1]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- 必碍何 巢/咯 积己 肮荐甫 馆券茄促.
/****** lourence8 ******/
ALTER   PROCEDURE [dbo].[sp_Extreme]
    @nUserNum    int

AS    
    DECLARE
        @error_var int, 
        @rowcount_var int    

    SET NOCOUNT ON
Select (MSum-MS) As M, (FSum-FS) As F
From
(
    Select isnull(Sum(M),0) As MSum, isnull(Sum(F),0) As FSum, isnull(Sum(MS),0) As MS, isnull(Sum(FS),0) As FS
    From
    (
    Select ChaClass
    ,
    Case ChaClass
    When 1 Then 1
    When 2 Then 1
    When 256 Then 1
    When 512 Then 1
    Else 0
    End As M
    ,
    Case ChaClass
    When 4 Then 1
    When 8 Then 1
    When 64 Then 1
    When 128 Then 1
    Else 0
    End As F
    ,
    Case ChaClass
    When 16 Then 
        Case ChaDeleted
        When 4 Then 0
        Else 1
        End
    Else 0
    End As MS
    ,
    Case ChaClass
    When 32 Then 
        Case ChaDeleted
        When 4 Then 0
        Else 1
        End
    Else 0
    End As FS
    From ChaInfo
    ) As t
) As tt

[ryan313]

@ryan313@
use this script

use [RanGame1]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- 必碍何 巢/咯 积己 肮荐甫 馆券茄促.
/****** lourence8 ******/
ALTER   PROCEDURE [dbo].[sp_Extreme]
    @nUserNum    int

AS    
    DECLARE
        @error_var int, 
        @rowcount_var int    

    SET NOCOUNT ON
Select (MSum-MS) As M, (FSum-FS) As F
From
(
    Select isnull(Sum(M),0) As MSum, isnull(Sum(F),0) As FSum, isnull(Sum(MS),0) As MS, isnull(Sum(FS),0) As FS
    From
    (
    Select ChaClass
    ,
    Case ChaClass
    When 1 Then 1
    When 2 Then 1
    When 256 Then 1
    When 512 Then 1
    Else 0
    End As M
    ,
    Case ChaClass
    When 4 Then 1
    When 8 Then 1
    When 64 Then 1
    When 128 Then 1
    Else 0
    End As F
    ,
    Case ChaClass
    When 16 Then 
        Case ChaDeleted
        When 4 Then 0
        Else 1
        End
    Else 0
    End As MS
    ,
    Case ChaClass
    When 32 Then 
        Case ChaDeleted
        When 4 Then 0
        Else 1
        End
    Else 0
    End As FS
    From ChaInfo
    ) As t
) As tt

how?? where am i going to use this script??

[SeiferXIII]

E x ecute it

[hyomi]

@ryan313 : i also use ranevilz .could u please give me your rangame1.bak ?

[ryan313]

E x ecute it

how ?? step by step please..

[earltop123]

HERE CLICK FIRST THE NEW QUERY AND PASTE THE SCRIPT after it excute!!

[ryan313]

HERE CLICK FIRST THE NEW QUERY AND PASTE THE SCRIPT after it excute!!

inside the cha info?
dude not working..please elaborate.. please..

[hyomi]

@lourence8 : i tried your suggestion to use fresh cleandb of ep6s2
well it works at first time create character ....no extreme class shows

but when i create the second character...problem come..extreme class appear...

i dont want extreme class...do you have another suggestion?

[ryan313]

@hyomi.. may i have your RanGame1.bak?? are you sure that the root for that problem is the RanGame1.bak?? can i use yours too? i will upload wait..vbecause i want to have extreme..

[hyomi]

@ryan sry i am not sure the root of this problem is the rangame1

but you can try my rangame1.bak ,so tell me if it works

[ryan313]

@ryan sry i am not sure the root of this problem is the rangame1

but you can try my rangame1.bak ,so tell me if it works

ook wait..
this is my rangame1.bak.. try this also ..and reply if this work...

i will try yours...

[hyomi]

@ryan313 : i tried your rangame1.bak. At first character no extreme class .Restart client and then create second character...extreme class appear ....

help plz , how to remove extreme class????

[ryan313]

i dont know.. i think nobody helps us here.. even PRO is not helping..

[denvee]

@ryan313 : i tried your rangame1.bak. At first character no extreme class .Restart client and then create second character...extreme class appear ....

help plz , how to remove extreme class????

if thats the case then what you can do is to just have 1 character per account so no one can create a second character... on the RanUser set ChaRemain default binding to 1 so every new account can only create 1 character.... this is best if you are starting from zero...

oh and remove any character card you have in the game

[ryansmith]

How about removing extreme sp? Suggestion only :)
Posted via Mobile Device

[dmc0105]

    Case ChaClass 
    When 1 Then 1 
    When 2 Then 1 
    When 256 Then 1 
    When 512 Then 1 
    Else 0 
    End As M 
    , 
    Case ChaClass 
    When 4 Then 1 
    When 8 Then 1
    When 64 Then 1 
    When 128 Then 1

Red = change to 0...

[druidz]

hong@lucky can on9 msn? i need ask something[help]

[hyomi]

@dmc0105
Thank youuuuu....it solve my problem, now its only 4 class...

SOLVED