Removing uGrade 255 and 253 from Rankings.

[Phoenix]

Hey, do any of you have the SQL Query for removing uGrade 255 and 253 from the rankings? I really need it and help would be appreciated.
Also, if you could give me the query needed for making the Quest Item duration to 7 days, I'd be really obliged.
Note : I already tried the one included in the DBFix by wesman; Doesn't work.

[MentaL]

[wutyes]

Gone.

[Phoenix]

SELECT * FROM Accounttable WHERE ugrade != 255 AND ugrade != 253

Simple fucking code l2codephp/mysql/mssql...

I don't think it's a complete query for the purpose. Anyways thanks.

"Simple fucking" code to you. Not me. I wouldn't have asked otherwise.

[alfredao]

For ranking page :)

SELECT TOP 50 * FROM Account a, Character b WHERE a.AID=b.AID AND a.UgradeID != 253 AND a.UgradeID != 255 AND b.CharNum != '-1'

Quest Item duration i don't know :(

[Linear88]

/** **/
// Credits to Linear88.
/** **/

SELECT TOP 50 * FROM Character c INNER JOIN Account a ON c.AID = a.AID WHERE c.DeleteFlag = 0 AND a.UGradeID != 253 AND a.UGradeID != 255

Give thanks, it would be appreciated. :)

Also, do you mean quest items in the form of cash items in the Central Bank / Storage?

[Phoenix]

No I mean when we get Items like a Shirt or Goblin Hat after defeating a Boss, it should be set to 7 days duration.

---------- Post added at 11:46 AM ---------- Previous post was at 11:42 AM ----------

/** **/
// Credits to Linear88.
/** **/

SELECT TOP 50 * FROM Character c INNER JOIN Account a ON c.AID = a.AID WHERE c.DeleteFlag = 0 AND a.UGradeID != 253 AND a.UGradeID != 255

Give thanks, it would be appreciated. :)

Also, do you mean quest items in the form of cash items in the Central Bank / Storage?

I'm sorry it still doesn't remove those character Grades from the rankings. It shows me a table of characters. What am I supposed to do then? Sorry I don't know much of MSSQL.

[diosz]

/** **/
// Credits to Linear88.
/** **/

SELECT TOP 50 * FROM Character c INNER JOIN Account a ON c.AID = a.AID WHERE c.DeleteFlag = 0 AND a.UGradeID != 253 AND a.UGradeID != 255

Give thanks, it would be appreciated. :)

Also, do you mean quest items in the form of cash items in the Central Bank / Storage?

why dont put

UGradeID != '253|255'

No I mean when we get Items like a Shirt or Goblin Hat after defeating a Boss, it should be set to 7 days duration.

---------- Post added at 11:46 AM ---------- Previous post was at 11:42 AM ----------



I'm sorry it still doesn't remove those character Grades from the rankings. It shows me a table of characters. What am I supposed to do then? Sorry I don't know much of MSSQL.

you can show your ranking?

[Mambo]

SELECT TOP 25 FROM Character WHERE UgradeID != '253|355' ORDER BY LEVEL DESCRIPTION

[alfredao]

SELECT TOP 25 FROM Character WHERE UgradeID != '253|355' ORDER BY LEVEL DESCRIPTION

LOL, whats this?

[Nolife_x]

Quest duration :

Database related :

USE [GunZDB]
GO
/****** Object:  StoredProcedure [dbo].[spInsertCharItem]    Script Date: 10/20/2009 14:10:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/* 캐릭터 아이템 추가 - 땜빵 */
ALTER PROC [dbo].[spInsertCharItem]
	@CID		int,
	@ItemID		int,
	@RentHourPeriod	smallint
AS
SET NOCOUNT ON 

DECLARE @OrderCIID	int
DECLARE @varBP 		int
-- 땜빵
SELECT @varBP = BP FROM Character where CID=@CID
IF @varBP < 0
BEGIN
	UPDATE Character SET BP=0 WHERE CID=@CID
	RETURN (-1)
END


BEGIN TRAN
INSERT INTO CharacterItem (CID, ItemID, RegDate, RentDate, RentHourPeriod) Values (@CID, @ItemID, GETDATE(), GETDATE(), @RentHourPeriod)
IF 0 <> @@ERROR BEGIN
	ROLLBACK TRAN
	RETURN (-1)
END
COMMIT TRAN

SET @OrderCIID = @@IDENTITY
SELECT @OrderCIID as ORDERCIID

Inside droptable.xml
<ITEM id="400526" rate="0.15" rent_period="168" /> <!-- 향상된 남성용 고블린 위자드 팔보호대 : 황금색 -->
<ITEM id="400527" rate="0.15" rent_period="168" /> <!-- 향상된 여성용 고블린 위자드 팔보호대 : 황금색 -->
<ITEM id="400525" rate="0.30" rent_period="168" /> <!-- 향상된 고블린 대장 몽둥이 : 황금색 -->


Make it same as this and it will work.

[Mambo]

LOL, whats this?

Thats called a query?

Though, i haven't done computers a long time so might be fucked up