Help please

09/10/2021 21:18 ilyaslord36#1
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' @[Only registered and activated users can see links. Click Here To Register...]rindex='01' @[Only registered and activated users can see links. Click Here To Register...]count='administrator',@im_szName=' e377351c7edcbc01b7ccf6232823fdbc' @[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 @[Only registered and activated users can see links. Click Here To Register...]_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 @[Only registered and activated users can see links. Click Here To Register...]_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='(nu ll)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=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)',@im_szVipEndTime='(null) ',@im_nAlchemyLevel=0,@im_nAlchemyExp=0 @[Only registered and activated users can see links. Click Here To Register...]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' @[Only registered and activated users can see links. Click Here To Register...]rindex='01' @[Only registered and activated users can see links. Click Here To Register...]count='administrator',@im_szName=' e377351c7edcbc01b7ccf6232823fdbc' @[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 @[Only registered and activated users can see links. Click Here To Register...]_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 @[Only registered and activated users can see links. Click Here To Register...]_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='(nu ll)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=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)',@im_szVipEndTime='(null) ',@im_nAlchemyLevel=0,@im_nAlchemyExp=0 @[Only registered and activated users can see links. Click Here To Register...]ruf='0'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '*='
09/10/2021 23:59 Nιgнтмαяε#2
You were already answered here: [Only registered and activated users can see links. Click Here To Register...]

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:
Code:
			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... :rollsafe:
09/11/2021 04:47 WaterIsSand#3
Quote:
Originally Posted by ilyaslord36 View Post
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.

Quote:
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 : [Only registered and activated users can see links. Click Here To Register...]

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.
09/11/2021 21:44 ilyaslord36#4
Quote:
Originally Posted by Nιgнтмαяε View Post
You were already answered here: [Only registered and activated users can see links. Click Here To Register...]

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:
Code:
			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... :rollsafe:

[Only registered and activated users can see links. Click Here To Register...]

and another problem when i use the bank code the character canot connected
[Only registered and activated users can see links. Click Here To Register...]
09/12/2021 00:18 Nιgнтмαяε#5
Quote:
Originally Posted by ilyaslord36 View Post
[Only registered and activated users can see links. Click Here To Register...]

and another problem when i use the bank code the character canot connected
[Only registered and activated users can see links. Click Here To Register...]
Here: [Only registered and activated users can see links. Click Here To Register...]

Since your to lazy to remove the MENTION tags within the codebox. :rolleyes:
09/12/2021 01:14 ilyaslord36#6
Quote:
Originally Posted by Nιgнтмαяε View Post
Here: [Only registered and activated users can see links. Click Here To Register...]

Since your to lazy to remove the MENTION tags within the codebox. :rolleyes:
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'.
09/12/2021 02:19 Nιgнтмαяε#7
Quote:
Originally Posted by ilyaslord36 View Post
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
Code:
inner join #temp_realPlayerslot as ttt on A.m_idPlayer = ttt.m_idPlayer AND A.playerslot= ttt.playerslot
Which is this -> [Only registered and activated users can see links. Click Here To Register...]

:rollsafe:
09/12/2021 12:54 ilyaslord36#8
Quote:
Originally Posted by Nιgнтмαяε View Post
Then remove
Code:
inner join #temp_realPlayerslot as ttt on A.m_idPlayer = ttt.m_idPlayer AND A.playerslot= ttt.playerslot
Which is this -> [Only registered and activated users can see links. Click Here To Register...]

:rollsafe:
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