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!

[FIX]spGetCharList

Junior Spellweaver
Joined
Mar 16, 2007
Messages
177
Reaction score
0
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.

Code:
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
 
Last edited:
Junior Spellweaver
Joined
Nov 23, 2004
Messages
125
Reaction score
2
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 @_@
 
Junior Spellweaver
Joined
Mar 24, 2007
Messages
134
Reaction score
0
Well It Will Work For Small Or Backed Up Servers
I Have A Beggining Server So It Worked Fine
 
Junior Spellweaver
Joined
Nov 23, 2004
Messages
125
Reaction score
2
You'll see the problem once your server starts growing =3
 
Back
Top