Where to put this extreme class>?

[ryan313]

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

where can i locate this??

[MentaL]

[Ace312]

Sa imong mama

[ryan313]

Sa imong mama

binuang bay?? ayaw ug comment ug y hinundan..!

[lordskie03]

Step by Step Instructions

*Open SQL Management Studio Express.
*Connect To Your Account
*Expand Database
*Expand RanGame1
*Expand Programmability
*Expand Stored Fuctions
*Find dbo.sp_Extreme
*Replace 0 to 1 to get exptreme class

From:

Case ChaClass
When 1 Then 0
When 2 Then 0
When 256 Then 0
When 512 Then 0
Else 0
End As M

To

Case ChaClass
When 1 Then 1
When 2 Then 1
When 256 Then 1
When 512 Then 1
Else 0
End As M

Hope I helped!

[ryan313]

Step by Step Instructions

*Open SQL Management Studio Express.
*Connect To Your Account
*Expand Database
*Expand RanGame1
*Expand Programmability
*Expand Stored Fuctions
*Find dbo.sp_Extreme
*Replace 0 to 1 to get exptreme class

From:

Case ChaClass
When 1 Then 0
When 2 Then 0
When 256 Then 0
When 512 Then 0
Else 0
End As M

To

Case ChaClass
When 1 Then 1
When 2 Then 1
When 256 Then 1
When 512 Then 1
Else 0
End As M

Hope I helped!

not effective.. i want that there is extreme class in creation .. can u help me??

[ryan313]

mine is already

Case ChaClass
When 1 Then 1
When 2 Then 1
When 256 Then 1
When 512 Then 1
Else 0
End As M

still no extreme class in char creation..

[lordskie03]

did you save it? if yes, then maybe your client is the problem.

[ryan313]

yes i saved it.../

USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_Extreme] Script Date: 04/30/2011 17:53:27 ******/
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 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




what will i do next??

[lordskie03]

Why not try to change your client? are you using Ep6 s2?

[ryan313]

Why not try to change your client? are you using Ep6 s2?

yup ranevilz ep6 s2..