There this common problem =.=;

Printable View

Show 100 post(s) from this thread on one page

29-12-10
Kimsangchul

Re: There this common problem =.=;

Quote:

Originally Posted by mrNickname

Thanks Kim that is for creating the databases and i got that installed. But from now the channel won't show up no matter how i edit the Server.ini, there no showing any error on the consoles where could the problem be...

USE [Pangya_S4_TH]
GO

CREATE PROC [dbo].[USP_CHAR_EQUIP_LOAD_S4] (
@UID INT
)
AS

BEGIN

SET NOCOUNT ON

IF ( @UID > 0 ) BEGIN

SELECT X.ITEM_ID
, TYPEID
/* new */
, ITEMID_PARTS_1
, ITEMID_PARTS_2
, ITEMID_PARTS_3
, ITEMID_PARTS_4
, ITEMID_PARTS_5
, ITEMID_PARTS_6
, ITEMID_PARTS_7
, ITEMID_PARTS_8
, ITEMID_PARTS_9
, ITEMID_PARTS_10
, ITEMID_PARTS_11
, ITEMID_PARTS_12
, ITEMID_PARTS_13
, ITEMID_PARTS_14
, ITEMID_PARTS_15
, ITEMID_PARTS_16
, ITEMID_PARTS_17
, ITEMID_PARTS_18
, ITEMID_PARTS_19
, ITEMID_PARTS_20
, ITEMID_PARTS_21
, ITEMID_PARTS_22
, ITEMID_PARTS_23
, ITEMID_PARTS_24
/* new */
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
, AUXPARTS_1
, AUXPARTS_2
, AUXPARTS_3
, AUXPARTS_4
, AUXPARTS_5
, DEFAULT_HAIR
, DEFAULT_SHIRTS
, GIFT_FLAG
, PCL0
, PCL1
, PCL2
, PCL3
, PCL4
, PURCHASE
FROM (
SELECT
ITEM_ID
, TYPEID
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
, AUXPARTS_1
, AUXPARTS_2
, AUXPARTS_3
, AUXPARTS_4
, AUXPARTS_5
, DEFAULT_HAIR
, DEFAULT_SHIRTS
, GIFT_FLAG
, PCL0
, PCL1
, PCL2
, PCL3
, PCL4
, PURCHASE
FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK)
WHERE UID = @UID
) X
INNER JOIN
(
SELECT
ITEM_ID
, ITEMID_PARTS_1 = MAX(CASE WHEN EQUIP_NUM = 1 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_2 = MAX(CASE WHEN EQUIP_NUM = 2 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_3 = MAX(CASE WHEN EQUIP_NUM = 3 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_4 = MAX(CASE WHEN EQUIP_NUM = 4 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_5 = MAX(CASE WHEN EQUIP_NUM = 5 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_6 = MAX(CASE WHEN EQUIP_NUM = 6 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_7 = MAX(CASE WHEN EQUIP_NUM = 7 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_8 = MAX(CASE WHEN EQUIP_NUM = 8 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_9 = MAX(CASE WHEN EQUIP_NUM = 9 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_10 = MAX(CASE WHEN EQUIP_NUM = 10 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_11 = MAX(CASE WHEN EQUIP_NUM = 11 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_12 = MAX(CASE WHEN EQUIP_NUM = 12 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_13 = MAX(CASE WHEN EQUIP_NUM = 13 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_14 = MAX(CASE WHEN EQUIP_NUM = 14 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_15 = MAX(CASE WHEN EQUIP_NUM = 15 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_16 = MAX(CASE WHEN EQUIP_NUM = 16 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_17 = MAX(CASE WHEN EQUIP_NUM = 17 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_18 = MAX(CASE WHEN EQUIP_NUM = 18 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_19 = MAX(CASE WHEN EQUIP_NUM = 19 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_20 = MAX(CASE WHEN EQUIP_NUM = 20 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_21 = MAX(CASE WHEN EQUIP_NUM = 21 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_22 = MAX(CASE WHEN EQUIP_NUM = 22 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_23 = MAX(CASE WHEN EQUIP_NUM = 23 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_24 = MAX(CASE WHEN EQUIP_NUM = 24 THEN ITEMID ELSE 0 END)

FROM (
SELECT
ITEM_ID
, TYPEID
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK)
WHERE UID = @UID
) A
LEFT OUTER JOIN
(
SELECT CHAR_ITEMID, ITEMID, TYPEID, EQUIP_NUM
FROM TD_CHAR_EQUIP_S4 WITH (NOLOCK)
WHERE UID = @UID
--AND ITEMID > 0
AND USE_YN = 'Y'
) B
ON A.ITEM_ID = B.CHAR_ITEMID
GROUP BY ITEM_ID
) Y
ON X.ITEM_ID = Y.ITEM_ID

END

END
29-12-10
mrNickname

Re: There this common problem =.=;

Kim i have that package installed as well, and has nothing to do with the channel lol..
29-12-10
Kimsangchul

Re: There this common problem =.=;

this creates does not change
29-12-10
mrNickname

Re: There this common problem =.=;

Could you just paste your working Server.ini file? I want to run a diagnostic see where the problem lay.
29-12-10
Kimsangchul

Re: There this common problem =.=;

[SERVERINFO]
VERSION="582.00"
LOCALIP="127.0.0.1"
PORT=20201
MAXUSER=1200
SERVERGUID=20201
SERVERNAME="PangyaKr"
PROPERTY=32
ICONINDEX=9

[CONFIG]
REFRESHTIME=10
MSNSERVER="127.0.0.1"
MSNPORT=10103
MSNSERVER="127.0.0.1"
MSNPORT=10103
MSNSERVER="127.0.0.1"
MSNPORT=10103
MSNLOCALPORT="127.0.0.1"
MSNLOCALIP=10102

[SERVER_AUTH]
SERVER_IP=127.0.0.1
IP="127.0.0.1"
PORT=7911

[RANK]
;RANKIP=127.0.0.1
RANKIP=127.0.0.1
RANKPORT=10105

[DATABASE]
DBIP="Pangya_S4_TH"
DBUSER="sa"
DBPASSWORD="masterkr"

[DATABASE_CASH]
DBIP="INI3BILL_DB"
DBUSER="sa"
DBPASSWORD="masterkr"

[OPTION]
TTL=-1
30S_HOLES = 10
ONEMANPLAY=2
GAMEGUARD_CHECK=0
CONNECTIONTIMELIVE=2
USER_STATE_TRACK_INTERVAL=3600000
LOGROOTDIR=C:\PANGYA_TEST\PY_LOGDIR

[CHANNELINFO]
NUM_CHANNEL=5

TYPE
ÀÏ¹Ý Ã¤³Î : TYPE_NORMAL = 1
30ÀÎ´ëÈ¸ Àü¿ë Ã¤³Î : TYPE_30_CHANNEL = 1

[CHANNEL1]
NAME="Iniciante "
TYPE=1
MAXUSER=1000

[CHANNEL2]
NAME="Novato"
TYPE=70
MAXUSER=1000

[CHANNEL3]
NAME="Junior"
TYPE=1
MAXUSER=1000

[CHANNEL4]
NAME="Amador"
TYPE=1
MAXUSER=1000

[CHANNEL5]
NAME="Profissional"
TYPE=1
MAXUSER=1000
29-12-10
shinez

Re: There this common problem =.=;

HELP

nr.2 INI3_BILLDB

Code:

current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S1_FREECOOKIELOG_DEPLOY'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S2_FREECOOKIELOG_DEPLOY'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S1_ITEMBUYLOG_DEPLOY'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S2_ITEMBUYLOG_DEPLOY'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S1_OTHERLOG_DEPLOY'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S2_OTHERLOG_DEPLOY'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GCCASHSELL_CANCEL'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'UP_NT_MB_ACCOUNT_INFO4GAME'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_BYUL_CALC'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'UP_NT_MB_ACCOUNT_INFO'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GCACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GCACCOUNT_INFO'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GCACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GIVE_FREE_COOKIE'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_BYUL_CALC'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'UP_NT_MB_ACCOUNT_INFO4GAME'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'UP_NT_MB_ACCOUNT_INFO4GAME'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GCACCOUNT_INFO'. The object will still be created.

nr.4 Pangya_S4_TH

Code:

Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_EVENT_POST'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_EVENT_POST'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_ROOM_DEFAULT_ITEM'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.PROCEVENTROOKIEF'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.PROCCHECKBIRTHDAYEVENT'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'USP_PANG_BONGDARI'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'USP_CARD_POP_S4'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.PROCPLAYTIMEPOINT_ADD_COMBO_INC'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created. Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created.

[ThaiLand]
29-12-10
Tsukasa

Re: There this common problem =.=;

Quote:

Originally Posted by shinez

HELP

nr.2 INI3_BILLDB

[ThaiLand]

Please abide by the rules and do not post the same post several times over multiple topics. If you're asking for help, please do so in the form of a somewhat complete English sentense.

Also, please check the common beginner questions thread that explains the messages. Alternatively you can also read the release thread, which will do the same.

In a nutshell: Just ignore these messages. They indicate that the database isn't complete - a fact you should all know by now.
29-12-10
mrNickname

1 Attachment(s)

Re: There this common problem =.=;

Thanks i tried but the same problem. I guess i'm running out of luck.
29-12-10
Tsukasa

Re: There this common problem =.=;

Quote:

Originally Posted by mrNickname

Thanks i tried but the same problem. I guess i'm running out of luck.

Study the gameserver logs for details. You should see an error message that'll help you to identify the problem (i.e. stored procedure missing or whatnot). As you probably have noticed there are several log-files created, so be sure to check them all.
29-12-10
shinez

Re: There this common problem =.=;

Code:

USE [ini3_py_account] GO DECLARE @return_value int EXEC @return_value = [dbo].[SP_PANGYA_REGIST] @idcard = N'1', @sex = 0, @birthday = N'19900424', @zipcode = N'33000', @id = N'lifeme', @pswd = N'lifeme' SELECT 'Return Value' = @return_value GO

Error

Code:

Msg 515, Level 16, State 2, Procedure SP_PANGYA_REGIST, Line 14 Cannot insert the value NULL into column 'Visa_Ref', table 'ini3_py_account.dbo.Ini3_UserLogin'; column does not allow nulls. INSERT fails. The statement has been terminated. (1 row(s) affected)

HELP
29-12-10
Kimsangchul

Re: There this common problem =.=;

USE [INI3Bill_DB]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[hb_py_gp_apply_userinfo_in]
@iUser_No = 1, idx
@iUser_ID = N'admin', login
@iUser_ip = N'127.0.0.1',
@iDB_id = NULL,
@iItem_no = NULL,
@iOrder_no = NULL,
@iPersonal_no = NULL,
@iApply_type = N'K0',
@iAmount = 1000000 cookies

SELECT 'Return Value' = @return_value

GO
30-12-10
mrNickname

Re: There this common problem =.=;

@Shinez drop your existing ini3_py_account database and create new one and fix the 'INI3_PY_ACCOUNT.sql' :

In 'ini3_py_account.sql' search and find [Visa_Ref] and [VisaIDCard] set both 'NOT NULL' to 'NULL' make sure you edit all of it, save and execute again to fix it.

@Kim, nice script for adding cookies :D

And for me.. i haven't work out a solution for the Channel not being displayed on my list. I don't know if client incompatible or what i started to suspect the server files and configs are somehow wrong. It seems like server DID send the list but client did not display it.. Ignore the first error on top because i forgot to do 'alluseropen'.

LOGIN SERVER LOG:

Code:

2010-12-30 17:49:08 1 loginserver#1 13 Server OnConnected 2010-12-30 17:49:08 1 loginserver#1 13 ID:10101 TYPE:LOGIN CONN STATE:CONNECT DATA STATE:PINGPONG Block 2010-12-30 17:49:08 1 loginserver#1 13 Ping Free 2010-12-30 17:49:08 1 loginserver#1 13 ID:10101 TYPE:LOGIN CONN STATE:CONNECT DATA STATE:PONG Block 2010-12-30 17:49:08 1 loginserver#1 13 Pong Free : Interval(0) 2010-12-30 17:49:08 1 loginserver#1 13 ID:10101 TYPE:LOGIN CONN STATE:CONNECT DATA STATE:NONE 2010-12-30 17:52:08 1 loginserver#1 2 MacAddrs Size() 1 - 00-1e-10-1f-aa-49 2010-12-30 17:52:09 1 loginserver#1 0 [S_LOGIN] Call Fuction CheckLogin 2010-12-30 17:52:09 1 loginserver#1 0 [S_LOGIN] LoginCheck Query : exec dbo.USP_LOGINCHECK_TH 'konakona', 10101, 0 2010-12-30 17:52:09 1 loginserver#1 2 [DI_LOGIN] konakona Call InsertNewUser 2010-12-30 17:52:09 1 loginserver#1 2 [DI_LOGIN] konakona Call InsertNewUser 2 2010-12-30 17:52:09 1 loginserver#1 2 [DI_LOGIN] konakona Function InsertNewUser 1 2010-12-30 17:52:09 1 loginserver#1 2 [F_LOGIN] konakona CheckLogin Failed 2010-12-30 17:52:09 1 loginserver#1 2 [F_LOGIN] konakona CMD_REQUEST_LOGIN : ErrorCode 15 2010-12-30 17:52:31 1 loginserver#1 2 MacAddrs Size() 1 - 00-1e-10-1f-aa-49 2010-12-30 17:52:31 1 loginserver#1 0 [S_LOGIN] Call Fuction CheckLogin 2010-12-30 17:52:31 1 loginserver#1 0 [S_LOGIN] LoginCheck Query : exec dbo.USP_LOGINCHECK_TH 'konakona', 10101, 0 2010-12-30 17:52:31 1 loginserver#1 2 [DI_LOGIN] konakona Call InsertNewUser 2010-12-30 17:52:31 1 loginserver#1 2 [DI_LOGIN] konakona Call InsertNewUser 2 2010-12-30 17:52:31 1 loginserver#1 2 [DI_LOGIN] konakona Function InsertNewUser 1 2010-12-30 17:52:31 1 loginserver#1 2 [DI_LOGIN] konakona Function InsertNewUser 2 2010-12-30 17:52:31 1 loginserver#1 2 [DI_LOGIN] konakona Function InsertNewUser DB :Query exec dbo.USP_INSERT_NEWUSER_TH 0, 'konakona', 0, '', '800101', '00000', '800101-1000000', 0, 0, 'konakona' 2010-12-30 17:52:31 1 loginserver#1 2 [S_LOGIN] konakona CMD_REQUEST_LOGIN : 2010-12-30 17:52:47 1 loginserver#1 1 [S_NICKNAME] Change Nick : -> (note)Anemone 2010-12-30 17:52:50 1 loginserver#1 2 [S_LOGIN] ID(konakona) : CreateSecurityKey : AuthKey(35801D13) 2010-12-30 17:52:50 1 loginserver#1 1 [N_LOGIN] Uid(1), SendServerList

Show 100 post(s) from this thread on one page