LOG_ITEM_STR

10/29/2014 18:00 Ecrypter#1
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 12gamer34#2
I think:
You need to Change the log01 DataSourceName to LOGGING_01_DBF, not LOG_01_DBF.
10/29/2014 20:01 xTwiLightx#3
Quote:
Originally Posted by Ecrypter View Post
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 View Post
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 Ecrypter#4
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