rollback

[PercyGloryKal]

i have hexed DB server with the release from madnight
i change the sql create player

plz can some one help for fixing the rolback

thx for ur time

[MentaL]

[David Emad]

use this db. http://www15.zippyshare.com/v/52767382/file.html
and at player_db0 add CurHT as int and also add CurMT as int

and stored procedure add this:

CREATE PROCEDURE [dbo].[CreatePlayer]


@uid int, @name varchar(14), @class tinyint, @Strength tinyint, @Health tinyint, @Intelligence tinyint, @Wisdom tinyint, @dexterity tinyint, @curht int, @curmt int, @Map tinyint,
@x int,
@y int,
@z int, @face tinyint, @Hair tinyint
AS


INSERT INTO Player ( [UID], [Name], [Class], [Strength], Health, Intelligence, Wisdom, Dexterity, [CurHT], [CurMT], [Map], [X], [Y], [Z], [Face], [Hair])
VALUES ( @uid @name @class @Strength, @Health @Intelligence @Wisdom, @dexterity @curht @curmt, 0, 256171, 256020, 16410, @face, @Hair)

[SmithieBoy]

use this db. http://www15.zippyshare.com/v/52767382/file.html
and at player_db0 add CurHT as int and also add CurMT as int

and stored procedure add this:

CREATE PROCEDURE [dbo].[CreatePlayer]


@uid int, @name varchar(14), @class tinyint, @Strength tinyint, @Health tinyint, @Intelligence tinyint, @Wisdom tinyint, @dexterity tinyint, @curht int, @curmt int, @Map tinyint,
@x int,
@y int,
@z int, @face tinyint, @Hair tinyint
AS


INSERT INTO Player ( [UID], [Name], [Class], [Strength], Health, Intelligence, Wisdom, Dexterity, [CurHT], [CurMT], [Map], [X], [Y], [Z], [Face], [Hair])
VALUES ( @uid @name @class @Strength, @Health @Intelligence @Wisdom, @dexterity @curht @curmt, 0, 256171, 256020, 16410, @face, @Hair)

Your stored missing somethings.

CREATE PROCEDURE [dbo].[CreatePlayer]


@uid int, @name varchar(14), @class tinyint, @Strength tinyint, @Health tinyint, @Intelligence tinyint, @Wisdom tinyint, @dexterity tinyint, @curht int, @curmt int, @Map tinyint,
@x int,
@y int,
@z int, @face tinyint, @Hair tinyint
AS


INSERT INTO Player ( [UID], [Name], [Class], [Strength], Health, Intelligence, Wisdom, Dexterity, [CurHT], [CurMT], [Map], [X], [Y], [Z], [Face], [Hair])
VALUES ( @uid, @name, @class, @Strength, @Health, @Intelligence, @Wisdom, @dexterity, @curht, @curmt, 0, 256171, 256020, 16410, @face, @Hair)