Help please

[ilyaslord36]

Plz i need databases Dragoncross Im using sql 2017

query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find server 'RANKING' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
2021/09/05 01:12:09
query:CHARACTER_STR 'S2',@im_idPlayer='0000000' @rindex='01' @count='administrator',@im_szName=' e377351c7edcbc01b7ccf6232823fdbc' @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 @_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 @_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 @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 @='(null)', @im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(nu ll)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0, @im_dwSMTime='(null)' @Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @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)',@im_szVipEndTime='(null) ',@im_nAlchemyLevel=0,@im_nAlchemyExp=0 @ruf='0'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '*='.
2021/09/05 01:12:09
query:CHARACTER_STR 'S2',@im_idPlayer='0000000' @rindex='01' @count='administrator',@im_szName=' e377351c7edcbc01b7ccf6232823fdbc' @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 @_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 @_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 @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 @='(null)', @im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(nu ll)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0, @im_dwSMTime='(null)' @Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @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)',@im_szVipEndTime='(null) ',@im_nAlchemyLevel=0,@im_nAlchemyExp=0 @ruf='0'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '*='

[Nιgнтмαяε]

You were already answered here:

Someone has already told you how to solve this problem, you also told them you fixed it clearly you didnt as your still getting the same error.

So again it's:

			FROM CHARACTER_TBL as A 
				inner join INVENTORY_TBL as B on A.m_idPlayer = B.m_idPlayer and A.serverindex = B.serverindex
				inner join INVENTORY_EXT_TBL as D on B.serverindex = D.serverindex and B.m_idPlayer = D.m_idPlayer
				inner join #temp_realPlayerslot as ttt on A.m_idPlayer = ttt.m_idPlayer AND A.playerslot= ttt.playerslot
				left outer join GUILD_MEMBER_TBL as C on D.m_idPlayer = C.m_idPlayer and D.serverindex = C.serverindex
			WHERE 	A.isblock = 'F'
				AND A.account =  [MENTION=8190413]iac[/MENTION]count  
				AND A.serverindex =  [MENTION=3453071]iServe[/MENTION]rindex
			ORDER BY A.playerslot

You have posted this 4 times now and have't made any effort...

[WaterIsSand]

Originally Posted by ilyaslord36

Plz i need databases Dragoncross Im using sql 2017

query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find server 'RANKING' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

Lookup the linkedserver commands or in the source remove the Ranking.ranking. for the sql queries.

SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '*='.

The " *= " syntax is deprecated and hasn't been used for years. The correct syntax is using "left inner join".

As said before, you've been told this. Thanks for Nightmare for pointing it out but here's another one :

Well guess what, it is the same error. Make sure to read your errors before posting them. Make sure to do it for the full character_str procedure and swap out all of the incorrect syntax.

[ilyaslord36]

Originally Posted by Nιgнтмαяε

You were already answered here:

Someone has already told you how to solve this problem, you also told them you fixed it clearly you didnt as your still getting the same error.

So again it's:

			FROM CHARACTER_TBL as A 
				inner join INVENTORY_TBL as B on A.m_idPlayer = B.m_idPlayer and A.serverindex = B.serverindex
				inner join INVENTORY_EXT_TBL as D on B.serverindex = D.serverindex and B.m_idPlayer = D.m_idPlayer
				inner join #temp_realPlayerslot as ttt on A.m_idPlayer = ttt.m_idPlayer AND A.playerslot= ttt.playerslot
				left outer join GUILD_MEMBER_TBL as C on D.m_idPlayer = C.m_idPlayer and D.serverindex = C.serverindex
			WHERE 	A.isblock = 'F'
				AND A.account =  [MENTION=8190413]iac[/MENTION]count  
				AND A.serverindex =  [MENTION=3453071]iServe[/MENTION]rindex
			ORDER BY A.playerslot

You have posted this 4 times now and have't made any effort...

and another problem when i use the bank code the character canot connected

[Nιgнтмαяε]

Originally Posted by ilyaslord36

and another problem when i use the bank code the character canot connected

Here:

Since your to lazy to remove the MENTION tags within the codebox.

[ilyaslord36]

Originally Posted by Nιgнтмαяε

Here:

Since your to lazy to remove the MENTION tags within the codebox.

The broblem is fixed
But when i input bank pw of character to login
He can't be login i take a screenshot of this error in Attachment 326363
SQLSTATE:42S02 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name '#temp_realPlayerslot'.

[Nιgнтмαяε]

Originally Posted by ilyaslord36

The broblem is fixed
But when i input bank pw of character to login
He can't be login i take a screenshot of this error in Attachment 326363
SQLSTATE:42S02 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name '#temp_realPlayerslot'.

Then remove

inner join #temp_realPlayerslot as ttt on A.m_idPlayer = ttt.m_idPlayer AND A.playerslot= ttt.playerslot

Which is this ->

[ilyaslord36]

Originally Posted by Nιgнтмαяε

Then remove

inner join #temp_realPlayerslot as ttt on A.m_idPlayer = ttt.m_idPlayer AND A.playerslot= ttt.playerslot

Which is this ->

I have remove it but nothing change the error stop log
But the character not success to connect with client he stop 't when i input bank pw