[FIX]spGetCharList

[Nekroido]

A little fix.
Lists characters in ascending order of creation.

NOTE: ALL MY FIXES ARE FOR LGKEIZ's DATABASE!

Use that db instead of saying that my code is bugged. I've tested my sql, and it works perfectly.

USE [Gunz]
GO
/****** Объект:  StoredProcedure [dbo].[spGetCharList]    Дата сценария: 04/01/2007 14:14:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[spGetCharList]
	-- Add the parameters for the stored procedure here
	@nAID INT
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT Level,CharNum,Name
	FROM Character
	WHERE AID = @nAID
	ORDER BY CharIndex
END

 

[Keith]

lets see If it works!

 

[MackInTosh]

Doesn't work but i appreciate the effort, change charIndex to charNum. Seems that works for me, using charIndex will mess with your characters really bad @_@

 

[Raven-Trigun]

Well It Will Work For Small Or Backed Up Servers
I Have A Beggining Server So It Worked Fine

 

[MackInTosh]

You'll see the problem once your server starts growing =3