DISABLE Extreme Class Character

[dronza68]

1. How do i DISABLE EXTREME CLASS in the Character Choices.

like this one

i want it to be disabled.
::::

---------- Post added at 10:19 AM ---------- Previous post was at 09:26 AM ----------

added update..

> This one's not working

> http://forum.ragezone.com/f444/solved-dont-want-extreme-job-745935/index2.html

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

im using EP5 Database

 

[dronza68]

update on this.

 

[dronza68]

update

 

[IamDJDRB]

@dronza68

i think the code are already can use no extreme class....
correct me if wrong..

 

[dronza68]

@dronza68

i think the code are already can use no extreme class....
correct me if wrong..

Hey what i mean is. i want the script that disables the EXTREME CLASS.

so far i found those script around saying that it CAN DISABLE EXTREME CLASS in Gender selection.
and again it doesn't work. or shall i say how do i make it work. . -__- :closedeyes::closedeyes::closedeyes:

 

[geger009]

execute this..
hope this help your prob..

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 0 
    When 2 Then 0 
    When 256 Then 0 
    When 512 Then 0 
    Else 0 
    End As M 
    , 
    Case ChaClass 
    When 4 Then 0 
    When 8 Then 0 
    When 64 Then 0 
    When 128 Then 0 
    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

 

[dronza68]

Bump!

---------- Post added at 09:53 AM ---------- Previous post was at 09:51 AM ----------

execute this..
hope this help your prob..

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 0 
    When 2 Then 0 
    When 256 Then 0 
    When 512 Then 0 
    Else 0 
    End As M 
    , 
    Case ChaClass 
    When 4 Then 0 
    When 8 Then 0 
    When 64 Then 0 
    When 128 Then 0 
    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

not working. . Extreme class Gender still exist
:closedeyes::closedeyes::closedeyes:

 

[hyomi]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO



-- 斛鬼睡 陴/罹 儅撩 偎熱蒂 奩棻.
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
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 0
When 2 Then 0
When 256 Then 0
When 512 Then 0
Else 0
End As M
,
Case ChaClass
When 4 Then 0
When 8 Then 0
When 64 Then 0
When 128 Then 0
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>=0 ) )
) As t
) As tt