- Joined
- Feb 22, 2007
- Messages
- 4
- Reaction score
- 0
why all char have 200HP? why
how can i do
i want 100hp
SORRY I'M BAD ENGLISH:bad:
how can i do
i want 100hp
SORRY I'M BAD ENGLISH:bad:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID
DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character
INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,99999999,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,getdate(),getdate(),0)
END