Pangya season 4 create new character it alway female

[KoMO_CRuX]

Hi!! I'm setup pangya season 4 with http://forum.ragezone.com/f514/v1-2-complete-pangya-setup-719617/ tutorials guide and find some question with
http://forum.ragezone.com/f200/common-beginner-questions-715711/ Common Beginner Questions guide thank you terrorofdeath and Tsukasa your both are rock!!. Ok my pangya server and client run fine but i have some problem when i create new account with Stored Procedure i set sex = 0 (i want male character) when i login game my character is female. So i try to make new account and set sex = 1 when i login game it still to be female anybody please advice me how to create new character to male (the new character i can choose only Hana) thank for any advice and sorry my English very poor :laugh:

 

[a22345875]

the sex in you account tbl

 

[KoMO_CRuX]

a22345875 thank you for you'r response but where i can find account tbl? because i find in ini3_py_account, INI3Bill_DB,and Pangya_S4_TH they not have account tbl... Thank

 

[chreadie]

a22345875 thank you for you'r response but where i can find account tbl? because i find in ini3_py_account, INI3Bill_DB,and Pangya_S4_TH they not have account tbl... Thank

Try to think a little bit more creative, when he says "account tbl" he means the table that holds the accountinformation.

Try this:

UPDATE [ini3_py_account].[dbo].[Ini3_UserLogin] SET Sex = 0 WHERE UserID = 'NameOfAccountHere'

 

[KoMO_CRuX]

Hi chreadie the code is not work i create new account it alway still to be female character BTW Thank you for your help

 

[Twilight]

change and execute this code

USE ini3_py_account;
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON

SET DATEFORMAT ymd;

declare @ndex nvarchar(20);
declare @user varchar(32);
declare @passwd varchar(32);
declare @bhday int;
declare @sex int;

SET @ndex= 1+ (SELECT MAX(idx)
FROM dbo.Ini3_UserLogin)

--change block----------------------------------------
SET @sex = 0
SET @user = 'nameuserlogin'
SET @passwd = 'passwdlogin'
SET @bhday = 19690916
------------------------------------------------------

exec SP_PANGYA_REGIST @ndex,@sex,@bhday,0000,@user,@passwd;
exec SP_PANGYA_ACTIVATE @user;

 

[KoMO_CRuX]

Twilight thank you for your help I will try ... Thank