[Share]Ep6S2 Database( Clean )

[dheluxe]

I just wanna share this ep6s2 database that i was
cleaned.
RanEP6S2_database_cleaned.zip

[MentaL]

[asohasohas]

Thanks For Posting This...

its a Big Help To Others

[jyap1021]

goodd job :D

[dheluxe]

hehe thank you for appreciation... :D

[AEther14]

WhAO!! ThISZ IS A gUd sHare dheLuxe thAnks yOu abOut thIsz!

[lourence8]

what do u mean by clean sir? its this DB include Extreme class already?

[vincent47]

same question above..

[jayr0428]

For the problem in first time player creating extreme class character don't show up try to use this... this sql script work's 100% i all ready tested is many times..

USE [RanGame1]
GO
/****** Object:  StoredProcedure [dbo].[sp_Extreme]    Script Date: 12/17/2010 05:33:37 ******/
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>=0 ) )
    ) As t
) As tt 

[ragnavalk]

sir i use your files and i tried it many and i only get "Username or passwords did not match! Please Confirm" i use Ran Evilz Ep6 Season 2 Client files. can u help me with my problem?

[AEther14]

[ USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_Extreme] Script Date: 12/17/2010 05:33:37 ******/
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>=0 ) )
) As t
) As tt ]



How To Execute This.. in SQL how to Put This!

[ragnavalk]

@aether14 sir is the item.isf compatible to ep6 s1? if it is compatible then i would the item.isf of this and transfer it to ep6 s1.

[siklab06]

send me link of database s2

[siklab06]

any one have ep5s2 game.exe send me link guys

[albert]

I just wanna share this ep6s2 database that i was
cleaned.
RanEP6S2_database_cleaned.zip

Sir Your Link Is Unavailable,, can i have your database?? thank you in advance