they help here

[Gemeos]

they help here

 

[fsadario]

1- Search in old topics (press page 1, 2, 3 to find it).
2- See the great Q&A.

 

[jer0m3]

or search it much better

 

[mts]

first problem.. hex editor

 

[dylanNIRVANA]

they help here

i can help on the second one..

Go into ur DB
Expand Programability
Expand Stored Procedures
Right Click dbo.spInsertChar and click "Modify"
Delete the ENTIRE proc and insert this one:

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,100000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL)
END

Execute.

If you get an error.. Press "Parse"