|
You last visited: Today at 03:13
Advertisement
LOG_ITEM_STR
Discussion on LOG_ITEM_STR within the Flyff Private Server forum part of the Flyff category.
10/29/2014, 18:00
|
#1
|
elite*gold: 0 
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
LOG_ITEM_STR
hi epvpers how to fix this error
PHP Code:
query:LOG_ITEM_STR @im_szName='iPwnY',@iserverindex='01',@im_GetszName='N0VAS',@idwWorldID=1,@im_dwGold=135000,@im_nRemainGold=135000,@iItem_UniqueNo=-2023805421,@iItem_Name='26460',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count=5120,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId=0,@inPiercedSize=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
thanks in advance
|
|
|
|
10/29/2014, 19:16
|
#2
|
elite*gold: 19
Join Date: Apr 2011
Posts: 3,483
Received Thanks: 272
|
I think:
You need to Change the log01 DataSourceName to LOGGING_01_DBF, not LOG_01_DBF.
|
|
|
|
|
10/29/2014, 20:01
|
#3
|
elite*gold: 0
Join Date: Jan 2009
Posts: 1,741
Received Thanks: 1,674
|
Quote:
Originally Posted by Ecrypter
hi epvpers how to fix this error
PHP Code:
query:LOG_ITEM_STR @im_szName='iPwnY',@iserverindex='01',@im_GetszName='N0VAS',@idwWorldID=1,@im_dwGold=135000,@im_nRemainGold=135000,@iItem_UniqueNo=-2023805421,@iItem_Name='26460',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count=5120,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId=0,@inPiercedSize=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
thanks in advance |
Could you post more CQuery-LogFile errors? I think the real problem should be found before that.
I think that it should be something with uspLoggingTrade @iFlag=2. 
Quote:
Originally Posted by 12gamer34
I think:
You need to Change the log01 DataSourceName to LOGGING_01_DBF, not LOG_01_DBF.
|
Und wenn die LOG_01_DBF genau das selbe enthält die die LOGGING_01_DBF? Nein.
|
|
|
|
|
10/30/2014, 11:36
|
#4
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
here
PHP Code:
014/10/30 00:11:28
query:uspLoggingTrade @pFlag=2, @pTradeID=1414653119, @pserverindex='01', @pidPlayer='0000034', @pItemIndex='26645', @pItemSerialNum=1870887728, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1215954410219110144
SQLSTATE:23000 error:[Microsoft][SQL Native Client][SQL Server]Violation of PRIMARY KEY constraint 'PK_tblTradeItemLog'. Cannot insert duplicate key in object 'dbo.tblTradeItemLog'.
2014/10/30 00:11:28
query:uspLoggingTrade @pFlag=2, @pTradeID=1414653119, @pserverindex='01', @pidPlayer='0000034', @pItemIndex='26645', @pItemSerialNum=1870887728, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1215954410219110144
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/10/30 00:11:28
query:LOG_ITEM_STR @im_szName='vllMaroonllv',@iserverindex='01',@im_GetszName='WeAreYoung',@idwWorldID=1,@im_dwGold=799999993,@im_nRemainGold=799999993,@iItem_UniqueNo=1304304066,@iItem_Name='23574',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count=9999,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId=0,@inPiercedSize=0,@iadwItemId0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
|
|
|
|
All times are GMT +1. The time now is 03:13.
|
|
