SQLSTATE:42000 error

08/06/2020 16:45 wlsska1764#1
2020/08/06 23:20:44
query:CHARACTER_STR 'S2',@im_idPlayer='0000000' @[Only registered and activated users can see links. Click Here To Register...]rindex='01',@iaccount='test01',@im_szName='89d1ed2 2aac58f5bbea53b2fde81a946' @[Only registered and activated users can see links. Click Here To Register...]slot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.00 0000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_s zCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairM esh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex =0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle =0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFa tiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_ nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta= 0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@ im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkil l='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@i m_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_ vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000, @im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@i m_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@ im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_ idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDea thLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0 @[Only registered and activated users can see links. Click Here To Register...]alPlayTime=0,@im_Card='(null)',@im_Index_Card='(nu ll)',@im_ObjIndex_Card='(null)',@im_Cube='(null)', @im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)' ,@im_Inventory='(null)',@im_apIndex='(null)',@im_a dwEquipment='(null)',@im_dwObjIndex='(null)',@im_a SlotApplet='(null)',@im_aSlotItem='(null)',@im_aSl otQueue='(null)',@im_SkillBar=0 @[Only registered and activated users can see links. Click Here To Register...]='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @[Only registered and activated users can see links. Click Here To Register...]Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @[Only registered and activated users can see links. Click Here To Register...]Piercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0 .000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z =0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_ dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszIn ventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@ im_aCheckedQuest='(null)'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]'*=' 근처의 구문이 잘못되었습니다.

2020/ 8/ 6 23:16:19 CDbManager::UpdateGuildRanking에서 (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') 실패

2020/ 8/ 6 23:16:23 OP: 1352559, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2020/ 8/ 6 23:16:30 잘못된 파일 : mvr_InfoPeng.o3d, mvr_InfoPeng.o3d, Mvr_Npcpaang.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 OP: 7477, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2020/ 8/ 6 23:16:36 OP: 5519, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2020/ 8/ 6 23:16:37 OP: 1107, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




Error
08/06/2020 17:10 netHoxInc#2
Yep thats an error.

And this post is no question or anything, its just a useless spam post.

Reported. Maybe clearify ur post better next time...
08/06/2020 17:26 cookie69#3
Quote:
Originally Posted by wlsska1764 View Post
2020/08/06 23:20:44
query:CHARACTER_STR 'S2',@im_idPlayer='0000000' @[Only registered and activated users can see links. Click Here To Register...]rindex='01',@iaccount='test01',@im_szName='89d1ed2 2aac58f5bbea53b2fde81a946' @[Only registered and activated users can see links. Click Here To Register...]slot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.00 0000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_s zCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairM esh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex =0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle =0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFa tiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_ nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta= 0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@ im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkil l='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@i m_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_ vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000, @im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@i m_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@ im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_ idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDea thLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0 @[Only registered and activated users can see links. Click Here To Register...]alPlayTime=0,@im_Card='(null)',@im_Index_Card='(nu ll)',@im_ObjIndex_Card='(null)',@im_Cube='(null)', @im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)' ,@im_Inventory='(null)',@im_apIndex='(null)',@im_a dwEquipment='(null)',@im_dwObjIndex='(null)',@im_a SlotApplet='(null)',@im_aSlotItem='(null)',@im_aSl otQueue='(null)',@im_SkillBar=0 @[Only registered and activated users can see links. Click Here To Register...]='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @[Only registered and activated users can see links. Click Here To Register...]Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @[Only registered and activated users can see links. Click Here To Register...]Piercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0 .000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z =0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_ dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszIn ventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@ im_aCheckedQuest='(null)'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]'*=' 근처의 구문이 잘못되었습니다.

2020/ 8/ 6 23:16:19 CDbManager::UpdateGuildRanking에서 (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') 실패

2020/ 8/ 6 23:16:23 OP: 1352559, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2020/ 8/ 6 23:16:30 잘못된 파일 : mvr_InfoPeng.o3d, mvr_InfoPeng.o3d, Mvr_Npcpaang.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 CModelObject::LoadElement에서 튕김 : 읽은 파일명 Model\mvr_InfoPeng.o3d

2020/ 8/ 6 23:16:30 OP: 7477, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2020/ 8/ 6 23:16:36 OP: 5519, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2020/ 8/ 6 23:16:37 OP: 1107, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




Error
This is a syntax error..
I see a missing "," just before the param @[Only registered and activated users can see links. Click Here To Register...]piercing so you need to fix it in cpp code I guess.
08/07/2020 19:18 jooodzszsz#4
Why you use password "test" :D
08/07/2020 19:28 netHoxInc#5
Quote:
Originally Posted by wlsska1764 View Post
@im_szName='89d1ed22aac58f5bbea53b2fde81a946'
Quote:
Originally Posted by jooodzszsz View Post
Why you use password "test" :D
Isn't the real question why his char is named like that? :D
08/07/2020 19:54 jooodzszsz#6
Quote:
Originally Posted by netHoxInc View Post
Isn't the real question why his char is named like that? :D
No because its his password and not the char name :D

Quote:
CHARACTER_STR 'S2',@im_idPlayer (iMode),@iserverindex,@iaccount,@im_szName (iPassword)
08/07/2020 19:56 netHoxInc#7
Quote:
Originally Posted by jooodzszsz View Post
No because its his password and not the char name :D
Not used to the db funcs, from his quote it looked just like that :P
08/07/2020 19:58 jooodzszsz#8
Quote:
Originally Posted by netHoxInc View Post
Not used to the db funcs, from his quote it looked just like that :P
The qoute comes from a comment of Aeonsoft, it was used as the password before but they decided to remove it.
And the Server send the password as the parameter m_szName
Quote:
/*

??? ?? ??????? ?????? ????
ex )
CHARACTER_STR 'S2',@im_idPlayer (iMode),@iserverindex,@iaccount,@im_szName (iPassword)
CHARACTER_STR 'S2','0','02','seghope','1234'


*/
08/09/2020 01:02 xTwiLightx#9
Quote:
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]'*=' 근처의 구문이 잘못되었습니다.
You're using an outdated SQL Server join syntax in the CHARACTER_STR procedure.
It needs to be changed to actual T-SQL syntax.

So something like this:
Code:
SELECT A.col1, B.col2
FROM Table1 A, Table2 B
WHERE A.serverindex *= B.serverindex
needs to be changed to something like this:
Code:
SELECT A.col1, B.col2
FROM Table1 A
LEFT OUTER JOIN Table2 B ON B.serverindex = A.serverindex
*= needs to be replaced with a left outer join
=* needs to be replaced with a right outer join
08/14/2020 10:09 Michi#10
@[Only registered and activated users can see links. Click Here To Register...]

We do not tolerate threads like yours, if you still need help then add a question or something else that could help. Next time we will delete your topic with no comment.

Take this as a warning!