[Help] Getting My Clan Grade 3+

[Aceworm]

How do I make my clan Grade 3 or above?

 

[OMEGAbuffer]

MANUAL CLAN GRADE : You bring your server down, execute the code below in a query, and bring it up.

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.

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.

 

[Aceworm]

Thanks

 

[kirill113]

Cold you please Explaind it a bit better pelase ?

i am using an 1299 version and sql 2005

 

[gorani]

MANUAL CLAN GRADE : You bring your server down, execute the code below in a query, and bring it up.

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.

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?

 

[OMEGAbuffer]

That means you're missing those stored procedures. Either they were renamed in your database, or you never had them.

 

[Maltuz]

MANUAL CLAN GRADE : You bring your server down, execute the code below in a query, and bring it up.

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.

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?

 

[lollipop07]

MANUAL CLAN GRADE : You bring your server down, execute the code below in a query, and bring it up.

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.

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.

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.

 

[Maltuz]

Thx lollipop.