Execute This Script On Database To Remove Extreme Class
Code:
USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_Extreme] Script Date: 11/21/2014 03:23:05 ******/
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 (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 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 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
You Can Use This Guide For Setting Up The Server
Note: Dont Update the Classic Game Launcher And dont 4get to edit the param.ini to your ip btw u can use this direct play launcher
Litte Info About The Server:
*Cap Lvl 170
*Last Map Root Hole
*Skills Up To 157
*BTG
And i think its RanPH EP7 V1 V822 Client Based
Credits:
*Emolista
*Owner Of ClassicRan
*To All Ragezone Members
*For Me Searching And Making The Files Compatible
