[Dev] Server 4.2 Release support

Re: Server 4.2 Release support

Some know why I receive this error
"03-30 17:02:07| [Notify] OnReceived T_FL_LOG_START_FIELD_SERVER !
03-30 17:02:07|[DB Error] DBWorkerThreadID( 5500) hstmt(0xC03818): @PB_INIT Failed!" in log server and after this field server close and don't load the maps.

Last log in field server
03-30 17:02:07| [Notify] connected to PreServer !
03-30 17:02:07| [Notify] connected to IMServer !
03-30 17:02:07| [Notify] CFieldGlobal::InitServerSocket# Starting...

Re: Server 4.2 Release support

Fix procedure PB_Init

Re: Server 4.2 Release support

If you would use Profiler You wouldn't ask why you got errors.

Re: Server 4.2 Release support

yeah yeah I fix that but field don't start

Re: Server 4.2 Release support

Check What You added in the table. It might be wrong. It happen to me.

Re: Server 4.2 Release support

Code:

03-31 05:52:28| UDP Opened for NPC_Server_0(MapIndex[1001] IP[ 192.168.1.2], Port[6043]) 03-31 05:52:28| UDP Opened for NPC_Server_1(MapIndex[1002] IP[ 192.168.1.2], Port[6045]) 03-31 05:52:28| UDP Opened for NPC_Server_2(MapIndex[2001] IP[ 192.168.1.2], Port[6051]) 03-31 05:52:28| UDP Opened for NPC_Server_3(MapIndex[2002] IP[ 192.168.1.2], Port[6053]) 03-31 05:52:28| UDP Opened for NPC_Server_4(MapIndex[2003] IP[ 192.168.1.2], Port[6831]) 03-31 05:52:28| UDP Opened for NPC_Server_5(MapIndex[8001] IP[ 192.168.1.2], Port[6211]) 03-31 05:52:28| UDP Opened for NPC_Server_6(MapIndex[9000] IP[ 192.168.1.2], Port[6541]) 03-31 05:52:28| UDP Opened for NPC_Server_7(MapIndex[9001] IP[ 192.168.1.2], Port[6551]) 03-31 05:52:28| UDP Opened for NPC_Server_8(MapIndex[9002] IP[ 192.168.1.2], Port[6561]) 03-31 05:52:28| UDP Opened for NPC_Server_9(MapIndex[3002] IP[ 192.168.1.2], Port[6061]) 03-31 05:52:28| UDP Opened for NPC_Server_10(MapIndex[3301] IP[ 192.168.1.2], Port[6063]) 03-31 05:52:28| UDP Opened for NPC_Server_11(MapIndex[3302] IP[ 192.168.1.2], Port[6065]) 03-31 05:52:28| UDP Opened for NPC_Server_12(MapIndex[3303] IP[ 192.168.1.2], Port[6067]) 03-31 05:52:28| UDP Opened for NPC_Server_13(MapIndex[3003] IP[ 192.168.1.2], Port[6071]) 03-31 05:52:28| UDP Opened for NPC_Server_14(MapIndex[3306] IP[ 192.168.1.2], Port[6073]) 03-31 05:52:28| UDP Opened for NPC_Server_15(MapIndex[3307] IP[ 192.168.1.2], Port[6075]) 03-31 05:52:28| UDP Opened for NPC_Server_16(MapIndex[3308] IP[ 192.168.1.2], Port[6077]) 03-31 05:52:28| UDP Opened for NPC_Server_17(MapIndex[3309] IP[ 192.168.1.2], Port[6079]) 03-31 05:52:28| UDP Opened for NPC_Server_18(MapIndex[3004] IP[ 192.168.1.2], Port[6081]) 03-31 05:52:28| UDP Opened for NPC_Server_19(MapIndex[3311] IP[ 192.168.1.2], Port[6085]) 03-31 05:52:28| UDP Opened for NPC_Server_20(MapIndex[3312] IP[ 192.168.1.2], Port[6087]) 03-31 05:52:28| UDP Opened for NPC_Server_21(MapIndex[3313] IP[ 192.168.1.2], Port[6089]) 03-31 05:52:28| UDP Opened for NPC_Server_22(MapIndex[3314] IP[ 192.168.1.2], Port[6091]) 03-31 05:52:28| UDP Opened for NPC_Server_23(MapIndex[3005] IP[ 192.168.1.2], Port[6093]) 03-31 05:52:28| UDP Opened for NPC_Server_24(MapIndex[3381] IP[ 192.168.1.2], Port[6095]) 03-31 05:52:28| UDP Opened for NPC_Server_25(MapIndex[3006] IP[ 192.168.1.2], Port[6101]) 03-31 05:52:28| UDP Opened for NPC_Server_26(MapIndex[3321] IP[ 192.168.1.2], Port[6103]) 03-31 05:52:28| UDP Opened for NPC_Server_27(MapIndex[3322] IP[ 192.168.1.2], Port[6105]) 03-31 05:52:28| UDP Opened for NPC_Server_28(MapIndex[3323] IP[ 192.168.1.2], Port[6107]) 03-31 05:52:28| UDP Opened for NPC_Server_29(MapIndex[3007] IP[ 192.168.1.2], Port[6111]) 03-31 05:52:28| UDP Opened for NPC_Server_30(MapIndex[3326] IP[ 192.168.1.2], Port[6113]) 03-31 05:52:28| UDP Opened for NPC_Server_31(MapIndex[3008] IP[ 192.168.1.2], Port[6121]) 03-31 05:52:28| UDP Opened for NPC_Server_32(MapIndex[3331] IP[ 192.168.1.2], Port[6123]) 03-31 05:52:28| UDP Opened for NPC_Server_33(MapIndex[3332] IP[ 192.168.1.2], Port[6125]) 03-31 05:52:28| UDP Opened for NPC_Server_34(MapIndex[3333] IP[ 192.168.1.2], Port[6127]) 03-31 05:52:28| UDP Opened for NPC_Server_35(MapIndex[3009] IP[ 192.168.1.2], Port[6131]) 03-31 05:52:28| UDP Opened for NPC_Server_36(MapIndex[3336] IP[ 192.168.1.2], Port[6133]) 03-31 05:52:28| UDP Opened for NPC_Server_37(MapIndex[3337] IP[ 192.168.1.2], Port[6135]) 03-31 05:52:28| UDP Opened for NPC_Server_38(MapIndex[3013] IP[ 192.168.1.2], Port[6141]) 03-31 05:52:28| UDP Opened for NPC_Server_39(MapIndex[3341] IP[ 192.168.1.2], Port[6143]) 03-31 05:52:28| UDP Opened for NPC_Server_40(MapIndex[3342] IP[ 192.168.1.2], Port[6145]) 03-31 05:52:28| UDP Opened for NPC_Server_41(MapIndex[3343] IP[ 192.168.1.2], Port[6147]) 03-31 05:52:28| UDP Opened for NPC_Server_42(MapIndex[3014] IP[ 192.168.1.2], Port[6151]) 03-31 05:52:28| UDP Opened for NPC_Server_43(MapIndex[3346] IP[ 192.168.1.2], Port[6153]) 03-31 05:52:28| UDP Opened for NPC_Server_44(MapIndex[3347] IP[ 192.168.1.2], Port[6155]) 03-31 05:52:28| UDP Opened for NPC_Server_45(MapIndex[3018] IP[ 192.168.1.2], Port[6161]) 03-31 05:52:28| UDP Opened for NPC_Server_46(MapIndex[3316] IP[ 192.168.1.2], Port[6163]) 03-31 05:52:28| UDP Opened for NPC_Server_47(MapIndex[3317] IP[ 192.168.1.2], Port[6165]) 03-31 05:52:28| UDP Opened for NPC_Server_48(MapIndex[3067] IP[ 192.168.1.2], Port[6171]) 03-31 05:52:28| UDP Opened for NPC_Server_49(MapIndex[3361] IP[ 192.168.1.2], Port[6173]) 03-31 05:52:28| UDP Opened for NPC_Server_50(MapIndex[3362] IP[ 192.168.1.2], Port[6175]) 03-31 05:52:28| UDP Opened for NPC_Server_51(MapIndex[3034] IP[ 192.168.1.2], Port[6181]) 03-31 05:52:28| UDP Opened for NPC_Server_52(MapIndex[3035] IP[ 192.168.1.2], Port[6183]) 03-31 05:52:28| UDP Opened for NPC_Server_53(MapIndex[3036] IP[ 192.168.1.2], Port[6185]) 03-31 05:52:28| UDP Opened for NPC_Server_54(MapIndex[3386] IP[ 192.168.1.2], Port[6191]) 03-31 05:52:28| UDP Opened for NPC_Server_55(MapIndex[3388] IP[ 192.168.1.2], Port[6193]) 03-31 05:52:28| UDP Opened for NPC_Server_56(MapIndex[3389] IP[ 192.168.1.2], Port[6195]) 03-31 05:52:28| UDP Opened for NPC_Server_57(MapIndex[4001] IP[ 192.168.1.2], Port[6201]) 03-31 05:52:28| UDP Opened for NPC_Server_58(MapIndex[3351] IP[ 192.168.1.2], Port[6203]) 03-31 05:52:28| UDP Opened for NPC_Server_59(MapIndex[3352] IP[ 192.168.1.2], Port[6205]) 03-31 05:52:28| UDP Opened for NPC_Server_60(MapIndex[4002] IP[ 192.168.1.2], Port[6221]) 03-31 05:52:28| UDP Opened for NPC_Server_61(MapIndex[6001] IP[ 192.168.1.2], Port[6241]) 03-31 05:52:28| UDP Opened for NPC_Server_62(MapIndex[6010] IP[ 192.168.1.2], Port[6243]) 03-31 05:52:28| UDP Opened for NPC_Server_63(MapIndex[6011] IP[ 192.168.1.2], Port[6245]) 03-31 05:52:28| UDP Opened for NPC_Server_64(MapIndex[3366] IP[ 192.168.1.2], Port[6247]) 03-31 05:52:28| UDP Opened for NPC_Server_65(MapIndex[3367] IP[ 192.168.1.2], Port[6249]) 03-31 05:52:28| UDP Opened for NPC_Server_66(MapIndex[4006] IP[ 192.168.1.2], Port[6251]) 03-31 05:52:28| UDP Opened for NPC_Server_67(MapIndex[3063] IP[ 192.168.1.2], Port[6261]) 03-31 05:52:28| UDP Opened for NPC_Server_68(MapIndex[3371] IP[ 192.168.1.2], Port[6263]) 03-31 05:52:28| UDP Opened for NPC_Server_69(MapIndex[3372] IP[ 192.168.1.2], Port[6265]) 03-31 05:52:28| UDP Opened for NPC_Server_70(MapIndex[3068] IP[ 192.168.1.2], Port[6271]) 03-31 05:52:28| UDP Opened for NPC_Server_71(MapIndex[3069] IP[ 192.168.1.2], Port[6281]) 03-31 05:52:28| UDP Opened for NPC_Server_72(MapIndex[3060] IP[ 192.168.1.2], Port[6291]) 03-31 05:52:28| UDP Opened for NPC_Server_73(MapIndex[3376] IP[ 192.168.1.2], Port[6293]) 03-31 05:52:28| UDP Opened for NPC_Server_74(MapIndex[3377] IP[ 192.168.1.2], Port[6295]) 03-31 05:52:28| UDP Opened for NPC_Server_75(MapIndex[3378] IP[ 192.168.1.2], Port[6297]) 03-31 05:52:28| UDP Opened for NPC_Server_76(MapIndex[3016] IP[ 192.168.1.2], Port[6301]) 03-31 05:52:28| UDP Opened for NPC_Server_77(MapIndex[7001] IP[ 192.168.1.2], Port[6401]) 03-31 05:52:28| UDP Opened for NPC_Server_78(MapIndex[7002] IP[ 192.168.1.2], Port[6411]) 03-31 05:52:28| UDP Opened for NPC_Server_79(MapIndex[7003] IP[ 192.168.1.2], Port[6421]) 03-31 05:52:28| UDP Opened for NPC_Server_80(MapIndex[7004] IP[ 192.168.1.2], Port[6431]) 03-31 05:52:28| UDP Opened for NPC_Server_81(MapIndex[7005] IP[ 192.168.1.2], Port[6441]) 03-31 05:52:28| UDP Opened for NPC_Server_82(MapIndex[7006] IP[ 192.168.1.2], Port[6451]) 03-31 05:52:28| UDP Opened for NPC_Server_83(MapIndex[7007] IP[ 192.168.1.2], Port[6461]) 03-31 05:52:28| UDP Opened for NPC_Server_84(MapIndex[6002] IP[ 192.168.1.2], Port[6501]) 03-31 05:52:28| UDP Opened for NPC_Server_85(MapIndex[6003] IP[ 192.168.1.2], Port[6511]) 03-31 05:52:28| UDP Opened for NPC_Server_86(MapIndex[4007] IP[ 192.168.1.2], Port[6521]) 03-31 05:52:28| UDP Opened for NPC_Server_87(MapIndex[3017] IP[ 192.168.1.2], Port[6531]) 03-31 05:52:28| UDP Opened for NPC_Server_88(MapIndex[6004] IP[ 192.168.1.2], Port[6571]) 03-31 05:52:28| UDP Opened for NPC_Server_89(MapIndex[3401] IP[ 192.168.1.2], Port[6581]) 03-31 05:52:28| UDP Opened for NPC_Server_90(MapIndex[3402] IP[ 192.168.1.2], Port[6591]) 03-31 05:52:28| UDP Opened for NPC_Server_91(MapIndex[3406] IP[ 192.168.1.2], Port[6601]) 03-31 05:52:28| UDP Opened for NPC_Server_92(MapIndex[3407] IP[ 192.168.1.2], Port[6611]) 03-31 05:52:28| UDP Opened for NPC_Server_93(MapIndex[3408] IP[ 192.168.1.2], Port[6621]) 03-31 05:52:28| UDP Opened for NPC_Server_94(MapIndex[3064] IP[ 192.168.1.2], Port[6631]) 03-31 05:52:28| UDP Opened for NPC_Server_95(MapIndex[3421] IP[ 192.168.1.2], Port[6641]) 03-31 05:52:28| UDP Opened for NPC_Server_96(MapIndex[3019] IP[ 192.168.1.2], Port[6651]) 03-31 05:52:28| UDP Opened for NPC_Server_97(MapIndex[3020] IP[ 192.168.1.2], Port[6661]) 03-31 05:52:28| UDP Opened for NPC_Server_98(MapIndex[6005] IP[ 192.168.1.2], Port[6671]) 03-31 05:52:28| UDP Opened for NPC_Server_99(MapIndex[6006] IP[ 192.168.1.2], Port[6681]) 03-31 05:52:28| UDP Opened for NPC_Server_100(MapIndex[6007] IP[ 192.168.1.2], Port[6691]) 03-31 05:52:28| UDP Opened for NPC_Server_101(MapIndex[3426] IP[ 192.168.1.2], Port[6693]) 03-31 05:52:28| UDP Opened for NPC_Server_102(MapIndex[6008] IP[ 192.168.1.2], Port[6701]) 03-31 05:52:28| UDP Opened for NPC_Server_103(MapIndex[3431] IP[ 192.168.1.2], Port[6703]) 03-31 05:52:28| UDP Opened for NPC_Server_104(MapIndex[6009] IP[ 192.168.1.2], Port[6711]) 03-31 05:52:28| UDP Opened for NPC_Server_105(MapIndex[3436] IP[ 192.168.1.2], Port[6721]) 03-31 05:52:28| UDP Opened for NPC_Server_106(MapIndex[3437] IP[ 192.168.1.2], Port[6731]) 03-31 05:52:28| UDP Opened for NPC_Server_107(MapIndex[3368] IP[ 192.168.1.2], Port[6741]) 03-31 05:52:28| UDP Opened for NPC_Server_108(MapIndex[6012] IP[ 192.168.1.2], Port[6761]) 03-31 05:52:28| UDP Opened for NPC_Server_109(MapIndex[6014] IP[ 192.168.1.2], Port[6771]) 03-31 05:52:28| UDP Opened for NPC_Server_110(MapIndex[4008] IP[ 192.168.1.2], Port[6781]) 03-31 05:52:28| UDP Opened for NPC_Server_111(MapIndex[4009] IP[ 192.168.1.2], Port[6791]) 03-31 05:52:28| UDP Opened for NPC_Server_112(MapIndex[6013] IP[ 192.168.1.2], Port[6801]) 03-31 05:52:28| UDP Opened for NPC_Server_113(MapIndex[6015] IP[ 192.168.1.2], Port[6811]) 03-31 05:52:28| UDP Opened for NPC_Server_114(MapIndex[3441] IP[ 192.168.1.2], Port[6821]) 03-31 05:52:28| UDP Opened for NPC_Server_115(MapIndex[3334] IP[ 192.168.1.2], Port[6841]) 03-31 05:52:28| UDP Opened for NPC_Server_116(MapIndex[3335] IP[ 192.168.1.2], Port[6851]) 03-31 05:52:28| UDP Opened for NPC_Server_117(MapIndex[3338] IP[ 192.168.1.2], Port[6861]) 03-31 05:52:28| UDP Opened for NPC_Server_118(MapIndex[3379] IP[ 192.168.1.2], Port[6871]) 03-31 05:52:28| UDP Opened for NPC_Server_119(MapIndex[4003] IP[ 192.168.1.2], Port[6881]) 03-31 05:52:28| UDP Opened for NPC_Server_120(MapIndex[2004] IP[ 192.168.1.2], Port[6891]) 03-31 05:52:28| UDP Opened for NPC_Server_121(MapIndex[6016] IP[ 192.168.1.2], Port[6901]) 03-31 05:52:28| UDP Opened for NPC_Server_122(MapIndex[3029] IP[ 192.168.1.2], Port[7001]) 03-31 05:52:28| UDP Opened for NPC_Server_123(MapIndex[4010] IP[ 192.168.1.2], Port[7011]) 03-31 05:52:28| UDP Opened for NPC_Server_124(MapIndex[3015] IP[ 192.168.1.2], Port[7021]) 03-31 05:52:28| UDP Opened for NPC_Server_125(MapIndex[3028] IP[ 192.168.1.2], Port[7031]) 03-31 05:52:28| UDP Opened for NPC_Server_126(MapIndex[6017] IP[ 192.168.1.2], Port[7041]) 03-31 05:52:28| UDP Opened for NPC_Server_127(MapIndex[2005] IP[ 192.168.1.2], Port[7051]) 03-31 05:52:28| UDP Opened for NPC_Server_128(MapIndex[3025] IP[ 192.168.1.2], Port[7061]) 03-31 05:52:28| UDP Opened for NPC_Server_129(MapIndex[3031] IP[ 192.168.1.2], Port[7071]) 03-31 05:52:28| UDP Opened for NPC_Server_130(MapIndex[3021] IP[ 192.168.1.2], Port[7081]) 03-31 05:52:28| UDP Opened for NPC_Server_131(MapIndex[3024] IP[ 192.168.1.2], Port[7091]) 03-31 05:52:28| UDP Opened for NPC_Server_132(MapIndex[3022] IP[ 192.168.1.2], Port[7101]) 03-31 05:52:28| UDP Opened for NPC_Server_133(MapIndex[3023] IP[ 192.168.1.2], Port[7111]) 03-31 05:52:28| UDP Opened for NPC_Server_134(MapIndex[3045] IP[ 192.168.1.2], Port[7121]) 03-31 05:52:28| UDP Opened for NPC_Server_135(MapIndex[3390] IP[ 192.168.1.2], Port[7131]) 03-31 05:52:28| UDP Opened for NPC_Server_136(MapIndex[3391] IP[ 192.168.1.2], Port[7141]) 03-31 05:52:28| UDP Opened for NPC_Server_137(MapIndex[3392] IP[ 192.168.1.2], Port[7151]) 03-31 05:52:28| UDP Opened for NPC_Server_138(MapIndex[3395] IP[ 192.168.1.2], Port[7161]) 03-31 05:52:28| UDP Opened for NPC_Server_139(MapIndex[3416] IP[ 192.168.1.2], Port[7171]) 03-31 05:52:28| UDP Opened for NPC_Server_140(MapIndex[3413] IP[ 192.168.1.2], Port[7181]) 03-31 05:52:28| UDP Opened for NPC_Server_141(MapIndex[3412] IP[ 192.168.1.2], Port[7191]) 03-31 05:52:28| UDP Opened for NPC_Server_142(MapIndex[3411] IP[ 192.168.1.2], Port[7201]) 03-31 05:52:28| UDP Opened for NPC_Server_143(MapIndex[3394] IP[ 192.168.1.2], Port[7211]) 03-31 05:52:28| UDP Opened for NPC_Server_144(MapIndex[3393] IP[ 192.168.1.2], Port[7221]) 03-31 05:52:28| UDP Opened for NPC_Server_145(MapIndex[3396] IP[ 192.168.1.2], Port[7231]) 03-31 05:52:28| UDP Opened for NPC_Server_146(MapIndex[3397] IP[ 192.168.1.2], Port[7241]) 03-31 05:52:28| UDP Opened for NPC_Server_147(MapIndex[3418] IP[ 192.168.1.2], Port[7251]) 03-31 05:52:28| UDP Opened for NPC_Server_148(MapIndex[3417] IP[ 192.168.1.2], Port[7261]) 03-31 05:52:28| UDP Opened for NPC_Server_149(MapIndex[3414] IP[ 192.168.1.2], Port[7271]) 03-31 05:52:28| UDP Opened for NPC_Server_150(MapIndex[3415] IP[ 192.168.1.2], Port[7281]) 03-31 05:52:28| UDP Opened for NPC_Server_151(MapIndex[3451] IP[ 192.168.1.2], Port[7291]) 03-31 05:52:28| UDP Opened for NPC_Server_152(MapIndex[3452] IP[ 192.168.1.2], Port[7301]) 03-31 05:52:28| UDP Opened for NPC_Server_153(MapIndex[3453] IP[ 192.168.1.2], Port[7311]) 03-31 05:52:28| UDP Opened for NPC_Server_154(MapIndex[3454] IP[ 192.168.1.2], Port[7321]) 03-31 05:52:28| UDP Opened for NPC_Server_155(MapIndex[3455] IP[ 192.168.1.2], Port[7331]) 03-31 05:52:28| UDP Opened for NPC_Server_156(MapIndex[6018] IP[ 192.168.1.2], Port[7351]) 03-31 05:52:28| UDP Opened for NPC_Server_157(MapIndex[2006] IP[ 192.168.1.2], Port[7361]) 03-31 05:52:28| UDP Opened for NPC_Server_158(MapIndex[3042] IP[ 192.168.1.2], Port[7363]) 03-31 05:52:28| UDP Opened for NPC_Server_159(MapIndex[3041] IP[ 192.168.1.2], Port[7365]) 03-31 05:52:28| UDP Opened for NPC_Server_160(MapIndex[3043] IP[ 192.168.1.2], Port[7371]) 03-31 05:52:28| UDP Opened for NPC_Server_161(MapIndex[3044] IP[ 192.168.1.2], Port[7373]) 03-31 05:52:28| UDP Opened for NPC_Server_162(MapIndex[3080] IP[ 192.168.1.2], Port[7375]) 03-31 05:52:28| UDP Opened for NPC_Server_163(MapIndex[3081] IP[ 192.168.1.2], Port[7377]) 03-31 05:52:28| UDP Opened for NPC_Server_164(MapIndex[3084] IP[ 192.168.1.2], Port[7383]) 03-31 05:52:28| UDP Opened for NPC_Server_165(MapIndex[3085] IP[ 192.168.1.2], Port[7385]) 03-31 05:52:28| UDP Opened for NPC_Server_166(MapIndex[3086] IP[ 192.168.1.2], Port[7391]) 03-31 05:52:28| UDP Opened for NPC_Server_167(MapIndex[3087] IP[ 192.168.1.2], Port[7393]) 03-31 05:52:28| UDP Opened for NPC_Server_168(MapIndex[4100] IP[ 192.168.1.2], Port[7397]) 03-31 05:52:28| UDP Opened for NPC_Server_169(MapIndex[4101] IP[ 192.168.1.2], Port[7399]) 03-31 05:52:28| UDP Opened for NPC_Server_170(MapIndex[4400] IP[ 192.168.1.2], Port[7401]) 03-31 05:52:28| UDP Opened for NPC_Server_171(MapIndex[4401] IP[ 192.168.1.2], Port[7403]) 03-31 05:52:28| UDP Opened for NPC_Server_172(MapIndex[3088] IP[ 192.168.1.2], Port[7405]) 03-31 05:52:28| UDP Opened for NPC_Server_173(MapIndex[3089] IP[ 192.168.1.2], Port[7407]) 03-31 05:52:28| UDP Opened for NPC_Server_174(MapIndex[4300] IP[ 192.168.1.2], Port[7409]) 03-31 05:52:28| UDP Opened for NPC_Server_175(MapIndex[4301] IP[ 192.168.1.2], Port[7411]) 03-31 05:52:28| UDP Opened for NPC_Server_176(MapIndex[9011] IP[ 192.168.1.2], Port[7419]) 03-31 05:52:28| UDP Opened for NPC_Server_177(MapIndex[4302] IP[ 192.168.1.2], Port[7427]) 03-31 05:52:28| UDP Opened for NPC_Server_178(MapIndex[4303] IP[ 192.168.1.2], Port[7429])

it`s some eror
but worck nice and smooth
evifing its ok

ah lol i have complete DB ep 4 not sryy

i wil not make any server for now i just test some and yea i have all complete ep 4.2 server
but i wil not ghive to any one

Re: Server 4.2 Release support

This in in reply for @gaby001:

Quote:

it`s some eror
but worck nice and smooth
evifing its ok

ah lol i have complete DB ep 4 not sryy

i wil not make any server for now i just test some and yea i have all complete ep 4.2 server
but i wil not ghive to any one

Quote:

Re: [RELEASE] Episode 4.2
Release for SS. I think people post pictures with what they've got, only to show people something like "I am cool and proud" and not for releasing. Stop acting like kids.
3days ago

Quote:

Re: [RELEASE] Episode 4.2
Tempts me to post what I have for shits and giggles.
3 Days ago posted by @DragonLord.

Re: Server 4.2 Release support

Quote:

Originally Posted by pegasus82

Some know why I receive this error
"03-30 17:02:07| [Notify] OnReceived T_FL_LOG_START_FIELD_SERVER !
03-30 17:02:07|[DB Error] DBWorkerThreadID( 5500) hstmt(0xC03818): @PB_INIT Failed!" in log server and after this field server close and don't load the maps.

Last log in field server
03-30 17:02:07| [Notify] connected to PreServer !
03-30 17:02:07| [Notify] connected to IMServer !
03-30 17:02:07| [Notify] CFieldGlobal::InitServerSocket# Starting...

This error doesn't matter because that procedure only update servergroup in td_account from MGameSrvID to just 0 - it means logged out. And even if your procedure its okay, when all players have '0' in this column that error will appear and you should start srv normally with that error, so its smth else.

Re: Server 4.2 Release support

Use SQL Profiler to get a more detailed information about the errors. It's very simple with SQL Profiler. Here it is: LINK

Re: Server 4.2 Release support

When I put in MapTrigger some values, Field Server crash without write a log and it makes a .dmp files. Anyone can help me? I try some values but is not working.. Thanks

Re: Server 4.2 Release support

for example
MapTriggerId , MapIndex, MapChannel,FunctionID

1 4100 0 1

Re: Server 4.2 Release support

ok thanks, thanks to SQL Profiler I understand when it crash and is a TriggerFunctionCrystal problem and not maptrigger error, anyway thank you :)

Re: Server 4.2 Release support

anyone else having problems with atum_load_ti_itemmixingelement ? anyway I tried to get rid of this error but it just seems to get even more annoying.

Anyways, here is some info on the problem I'm having. Maybe I am just missing something here.

Errors

Spoiler:

04-03 01:56:25|ERROR: CAtumDBHelper::LoadItemMixingInfo() Failed!!!
04-03 01:56:25|[Error] FieldServer IOCPInit Error

________
Profiler Report
DatabaseName="atum2_db_1" ObjectName="atum_load_ti_itemmixingelement"

Code in Files(reference)

Spoiler:

bRet = i_pODBCStmt->ExecuteQuery((char*)(PROCEDURE_120220_0003));
if (!bRet)
{
i_pODBCStmt->FreeStatement();
return 0;
}

SQLBindCol(i_pODBCStmt->m_hstmt, 1, SQL_C_LONG , &retMixingElementTool.UniqueID, 0, &cb1);
SQLBindCol(i_pODBCStmt->m_hstmt, 2, SQL_C_LONG , &retMixingElementTool.SourceItem.ItemNum, 0, &cb2);
SQLBindCol(i_pODBCStmt->m_hstmt, 3, SQL_C_LONG , &retMixingElementTool.SourceItem.Count, 0, &cb3);

memset(&retMixingElementTool, 0x00, sizeof(retMixingElementTool));
while ( (ret = SQLFetch(i_pODBCStmt->m_hstmt)) != SQL_NO_DATA)
{
vectorMixingElementTool.push_back(retMixingElementTool);

memset(&retMixingElementTool, 0x00, sizeof(retMixingElementTool));
}

i_pODBCStmt->FreeStatement();

Spoiler:

//Insert ti_ItemMixingInfo
int nObjects = 0;
vector<ITEM_MIXING_ELEMENT_TOOL>::iterator itr(o_pMapItemMixingElement->begin());
for(; itr != o_pMapItemMixingElement->end(); itr++)
{
ITEM_MIXING_ELEMENT_TOOL tmItemMixingInfo;
tmItemMixingInfo = *itr;

SQLBindParameter(i_pODBCStmt->m_hstmt, 1, SQL_PARAM_INPUT, SQL_C_LONG, SQL_INTEGER, 0, 0, &tmItemMixingInfo.UniqueID, 0, &arrCB[1]);
SQLBindParameter(i_pODBCStmt->m_hstmt, 2, SQL_PARAM_INPUT, SQL_C_LONG, SQL_INTEGER, 0, 0, &tmItemMixingInfo.SourceItem.ItemNum, 0, &arrCB[2]);
SQLBindParameter(i_pODBCStmt->m_hstmt, 3, SQL_PARAM_INPUT, SQL_C_LONG, SQL_INTEGER, 0, 0, &tmItemMixingInfo.SourceItem.Count, 0, &arrCB[3]);

BOOL bRet = i_pODBCStmt->ExecuteQuery((char*)(PROCEDURE_120220_0001));
i_pODBCStmt->FreeStatement();
if (!bRet)
{
// error
char err[1024];
sprintf(err, "ERROR line : UniqueID(%d) ItemNum(%d) Count(%d)!!", tmItemMixingInfo.UniqueID, tmItemMixingInfo.SourceItem.ItemNum, tmItemMixingInfo.SourceItem.Count);
MessageBox(NULL, err, "ti_ItemMixingElement", MB_OK);
return -3;
}
nObjects++;
// 2009. 10. 27 by jskim ÁøÇà·ü È®ÀÎ
SendMessage(hWnd, WM_PROGRESSBAR_POS, 0, nObjects);
ProcessLoopMessage(hWnd);
//end 2009. 10. 27 by jskim ÁøÇà·ü È®ÀÎ
}
return nObjects;

Procedure

Spoiler:

USE [atum2_db_1]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------

Create PROC [dbo].[atum_load_ti_ItemMixingElement]
AS
SELECT [UniqueID], [SourceItemNum], [SourceCount] FROM [atum2_db_account].[dbo].[ti_ItemMixingElement] WITH (NOLOCK)

Honestly its seems very simple, I guess I'm just overlooking something.

Re: Server 4.2 Release support

Use this:

Code:

USE [atum2_db_account] GO /****** Object: StoredProcedure [dbo].[atum_load_ti_ItemMixingElement] Script Date: 04/02/2014 03:26:34 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ------------------------------- -- Pre Server¿ë Log Total User ------------------------------- ALTER PROCEDURE [dbo].[atum_load_ti_ItemMixingElement] AS DECLARE @i_UniqueID int DECLARE @i_ItemNum INT DECLARE @i_Count INT INSERT INTO atum2_db_account.dbo.ti_ItemMixingElement VALUES (@i_UniqueID, @i_ItemNum, @i_Count)

And try to make the column names as ItemNum and Count from SourceItemNum and SourceCount.
And see if works.
When I will finish completely the ep4.2 databases I will share it on ragezone.

Re: Server 4.2 Release support

I fixed preety all just one what i have to do its complete CrystalSystem tables and it will be like original DB (NGC Infl War working corectly, pet socket, level, name working, arena maps ragnarok armagedon working, InfinityField 1,2,3 working) , About crystals i just started to work with them but i have a quite problem with sequencenumbers ( if its not a random when beat one crystal then rest of them dissapear but its under construction now), ahh i almost forget, all bins cleaned and deleted that shitty welcome message

about procedure/table:

Proc:

Code:

USE [atum2_db_1] GO /****** Object: StoredProcedure [dbo].[atum_load_ti_itemmixingelement] Script Date: 2014-04-03 14:51:10 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[atum_load_ti_itemmixingelement] AS SELECT UniqueID,ItemNum,Count FROM atum2_db_account.dbo.ti_itemmixingelement WITH (NOLOCK);

Table (Copied from table design):

Code:

UniqueID int Checked ItemNum int Checked Count int Checked Unchecked

Youre welcome