[Help] Getting My Clan Grade 3+

How do I make my clan Grade 3 or above?

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.

Thanks

Cold you please Explaind it a bit better pelase ?

i am using an 1299 version and sql 2005

Quote:

---

Originally Posted by OMEGAbuffer

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?

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

Quote:

---

Originally Posted by OMEGAbuffer

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?

Quote:

---

Originally Posted by OMEGAbuffer

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.

Thx lollipop.