[FIX]Character creation

[weijian95]

I got this:

Msg 137, Level 15, State 2, Procedure spInsertChar, Line 23
Must declare the scalar variable "@cn".
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@szName".
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@nSex".
Msg 156, Level 15, State 1, Line 31
Incorrect syntax near the keyword 'ELSE'.
Msg 137, Level 15, State 2, Line 56
Must declare the scalar variable "@nCostume".
Msg 156, Level 15, State 1, Line 96
Incorrect syntax near the keyword 'ELSE'.
Msg 137, Level 15, State 2, Line 96
Must declare the scalar variable "@nCostume".
Msg 156, Level 15, State 1, Line 129
Incorrect syntax near the keyword 'ELSE'.
Msg 137, Level 15, State 2, Line 129
Must declare the scalar variable "@nCostume".
Msg 156, Level 15, State 1, Line 170
Incorrect syntax near the keyword 'ELSE'.
Msg 137, Level 15, State 2, Line 170
Must declare the scalar variable "@nCostume".
Msg 156, Level 15, State 1, Line 202
Incorrect syntax near the keyword 'ELSE'.
Msg 137, Level 15, State 2, Line 202
Must declare the scalar variable "@nCostume".
Msg 156, Level 15, State 1, Line 243
Incorrect syntax near the keyword 'ELSE'.
Msg 137, Level 15, State 2, Line 243
Must declare the scalar variable "@nCostume".
Msg 102, Level 15, State 1, Line 284
Incorrect syntax near 'END'.

Must I change to

CREATE PROCEDURE [dbo].[spInsertChar]

[weijian95]

Nice release, now i don't have to worry abt giving how much bounty to buy starting equips!

[UkRaiNeR]

Msg 8101, Level 16, State 1, Procedure spInsertChar, Line 22
An explicit value for the identity column in table 'Character' can only be specified when a column list is used and IDENTITY_INSERT is ON.

:/ error, i dont understand >_>

[lPurchy]

Thanks works perfectly!

[maxteam]

O_o
whr am i supposed to add this..??
i camt find ne dbo.spinsertchar in my
GUNZDB--->Tables---->
can u tell me whr it is

[UkRaiNeR]

good release for sum ppl :P

[maxteam]

plzzzz tell me whr do i put it
i need it badly...(T_T)