How to remove Extreme Class from Create Character? EP6 S2
How to remove Extreme Class from Create Character? EP6 S2
Try this>>>
Go to RanGame1 then expand, go to Programmability then Stored Procedures, then below search for the dbo.sp_Extreme
Change with this
==========================================================================
USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_Extreme] Script Date: 08/23/2010 20:21:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_Extreme]
@nReturn int
AS
SET NOCOUNT ON
SELECT * FROM ChaInfo
WHERE ChaOnline = @nReturn
SET NOCOUNT OFF
==========================================================================
Just Set The 1 to 0
When 1 Then 1 <----
When 2 Then 1 <----
When 256 Then 1 <----
When 512 Then 1 <----
help me about
How to create Extreme Class
normal Class to Extreme this is an quest Extreme lv 190
Need to modify the Database
Who knows help me answer
ex
วิธีการรับเควส “บัตรสร้้างตัวละคร Extreme” - เกมส์ Ran Online - สูตรเกมส์ Game online บอร์ดเกมส์ออนไลน์
in where ??Originally Posted by dmc0105
can get thats code?
thx before sir dmc
here do this...
open ur microsoft sql server management studio express>>>log-in, expand database>>> go to ranuser>>>programability>>>expand stored procedure>>>right click db.sp_extreme then modify>>> you will see this
USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_Extreme] Script Date: 08/24/2010 15:08:45 ******/
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<<<---0 change to zero
When 2 Then 1<<<---0 change to zero
When 256 Then 1<<<---0 change to zero
When 512 Then 1<<<---0 change to zero
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
change the value from what bro dmc said ad then saved.....
press tanx if help...
Last edited by rob_angel23; 24-08-10 at 09:06 AM.
are this script really work ?
i've done this within my server, using RIP EXTREME Server, but it's not working, i can still see gunner class option when create character.
How to enable extreme in EP7 Jolin88???
modify the login page in source code.
thankyou sird
Thanks mate!
Reply With Quote