Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Help] Getting My Clan Grade 3+

Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
MANUAL CLAN GRADE : You bring your server down, execute the code below in a query, and bring it up.

Code:
delete currentuser set
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights
exec krallistesi_olustur

AUTO CLAN GRADE : Bring down your server down, add the code below to your Account_Logout procedure, hit execute, and bring it up.

Code:
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights

REMEMBER! You need at least 134k or 144k(I forgot) NP to get grade 3 at least. So, make sure you set your NP column(Loyalty) in the USERDATA column to desired amount before you clan grade.
 
Initiate Mage
Joined
Aug 21, 2006
Messages
1
Reaction score
0
MANUAL CLAN GRADE : You bring your server down, execute the code below in a query, and bring it up.

Code:
delete currentuser set
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights
exec krallistesi_olustur
AUTO CLAN GRADE : Bring down your server down, add the code below to your Account_Logout procedure, hit execute, and bring it up.

Code:
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights
REMEMBER! You need at least 134k or 144k(I forgot) NP to get grade 3 at least. So, make sure you set your NP column(Loyalty) in the USERDATA column to desired amount before you clan grade.

Just 1 question omega... i'm getting this msge:
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'otonpsimgesi'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'np_icon'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.

Any help about this?
 
Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
That means you're missing those stored procedures. Either they were renamed in your database, or you never had them.
 
Junior Spellweaver
Joined
Jun 7, 2006
Messages
144
Reaction score
1
MANUAL CLAN GRADE : You bring your server down, execute the code below in a query, and bring it up.

Code:
delete currentuser set
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights
exec krallistesi_olustur

AUTO CLAN GRADE : Bring down your server down, add the code below to your Account_Logout procedure, hit execute, and bring it up.

Code:
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights

REMEMBER! You need at least 134k or 144k(I forgot) NP to get grade 3 at least. So, make sure you set your NP column(Loyalty) in the USERDATA column to desired amount before you clan grade.



I tried that my clan got 79k nps but we're still grade 5 :S can u pls tell me what it can be?
 
Experienced Elementalist
Joined
Aug 18, 2007
Messages
204
Reaction score
0
MANUAL CLAN GRADE : You bring your server down, execute the code below in a query, and bring it up.

Code:
delete currentuser set
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights
exec krallistesi_olustur

AUTO CLAN GRADE : Bring down your server down, add the code below to your Account_Logout procedure, hit execute, and bring it up.

Code:
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights

REMEMBER! You need at least 134k or 144k(I forgot) NP to get grade 3 at least. So, make sure you set your NP column(Loyalty) in the USERDATA column to desired amount before you clan grade.



Sorry but you dont need all those turk procedures..

Just execute 'Rank_knights' and 'knights_rating_update'

And for crying out load remove all those turk procedures.

Heres the correct way, add this account logout procedure.

Code:
USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[ACCOUNT_LOGOUT]    Script Date: 09/30/2008 23:23:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[ACCOUNT_LOGOUT]
@AccountID	varchar(21),
@nRet smallint	OUTPUT

AS

BEGIN TRAN

DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID

EXEC RANK_KNIGHTS
EXEC UPDATE_PERSONAL_RANK
EXEC USER_KNIGHTS_RATING_UPDATE
EXEC UPDATE_MANNERPOINT_RANK

COMMIT TRAN
SET @nRet = 1

Done your knight ranking, rating and all PK logos are now fully automated.
 
Back
Top