[Problem] Bloody Files Items..

[.Zephion]

Hallo Epvp,

Unzwar habe ich ein kleines Problem , ich benutze die Bloody Flyff Files und habe einen komischen Error vor kurzem bekommen. (Items sind unsichtbar : o)

Damit meine ich z.B Goku Harre kann man nicht mehr Sehen b.z.w sie existieren nicht mehr, ich dachte mir schon 2 sachen entweder liegt es an der PropItem.txt,Defineitem... Oder an der Datenbank. Jeddoch will ich natürlich nicht Wipen oder so, (Muss ja nicht sein). Und ich habe schon alles ausgetestet was mir eingefallen ist. Ich hoffe dazu gibt es eine andere Lösung.

Hier mal die Errors:

 Spoiler

PHP Code:

query:uspLoggingTrade @pFlag=2, @pTradeID=1320169169, @pserverindex='01', @pidPlayer='0000105', @pItemIndex='21044', @pItemSerialNum=-273944115, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=54065941885785600
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2011/11/01    18:39:15
query:uspLoggingTrade @pFlag=2, @pTradeID=1320169169, @pserverindex='01', @pidPlayer='0000105', @pItemIndex='21044', @pItemSerialNum=-273944115, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=54065941885785600
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2011/11/01    18:39:16
query:LOG_ITEM_STR @im_szName='Fire',@iserverindex='01',@im_GetszName='UPGRADEITEM_SMELTSAFETY',@idwWorldID=1,@im_dwGold=503827647,@im_nRemainGold=503827647,@iItem_UniqueNo=-1096924320,@iItem_Name='2036',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count=102,@iState='N',@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 Server Native Client 10.0]Ungültiger Cursorstatus
2011/11/01    19:32:34
query:uspLoggingTrade @pFlag=2, @pTradeID=1320172381, @pserverindex='01', @pidPlayer='0000070', @pItemIndex='21042', @pItemSerialNum=452372003, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1351167986669192448
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2011/11/01    19:32:34
query:uspLoggingTrade @pFlag=2, @pTradeID=1320172381, @pserverindex='01', @pidPlayer='0000070', @pItemIndex='21042', @pItemSerialNum=452372003, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1351167986669192448
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2011/11/01    19:32:34
query:LOG_ITEM_STR @im_szName='GROUND',@iserverindex='01',@im_GetszName='Escobar1',@idwWorldID=2,@im_dwGold=1982905909,@im_nRemainGold=1982905909,@iItem_UniqueNo=1155464856,@iItem_Name='2036',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count=1,@iState='R',@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 Server Native Client 10.0]Ungültiger Cursorstatus
2011/11/01    20:45:29
query:uspLoggingTrade @pFlag=2, @pTradeID=1320176710, @pserverindex='01', @pidPlayer='0000070', @pItemIndex='22288', @pItemSerialNum=525690806, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1351137818873704960
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2011/11/01    20:45:29
query:uspLoggingTrade @pFlag=2, @pTradeID=1320176710, @pserverindex='01', @pidPlayer='0000070', @pItemIndex='22288', @pItemSerialNum=525690806, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=1351137818873704960
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2011/11/01    20:45:29
query:LOG_ITEM_STR @im_szName='Bonus',@iserverindex='01',@im_GetszName='Behe',@idwWorldID=1,@im_dwGold=509934283,@im_nRemainGold=509934283,@iItem_UniqueNo=994978313,@iItem_Name='22289',@iItem_durability=3600000,@im_nAbilityOption=10,@Im_GetdwGold=431525000,@iItem_count=1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId=2477259491328,@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 Server Native Client 10.0]Ungültiger Cursorstatus
2011/11/01    20:45:29
query:uspLoggingTrade @pFlag=2, @pTradeID=1320176710, @pserverindex='01', @pidPlayer='0000070', @pItemIndex='22289', @pItemSerialNum=994978313, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=2477259491328
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2011/11/01    20:45:29
query:uspLoggingTrade @pFlag=2, @pTradeID=1320176710, @pserverindex='01', @pidPlayer='0000070', @pItemIndex='22289', @pItemSerialNum=994978313, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=2477259491328
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2011/11/01    20:45:29
query:LOG_ITEM_STR @im_szName='Bonus',@iserverindex='01',@im_GetszName='Behe',@idwWorldID=1,@im_dwGold=509934283,@im_nRemainGold=509934283,@iItem_UniqueNo=-1398797738,@iItem_Name='22286',@iItem_durability=2880000,@im_nAbilityOption=10,@Im_GetdwGold=431525000,@iItem_count=1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResist=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId=796672,@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 Server Native Client 10.0]Ungültiger Cursorstatus 


 Spoiler

2011/11/ 4 00:18:00
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320362294, @pserverindex='01', @pidPlayer='0000070', @pItemIndex='22416', @pItemSerialNum=1454748211, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=5, @pResistAbilityOpt=20,@pRandomOpt=5154297101312
2011/11/ 4 04:15:09
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320376510, @pserverindex='01', @pidPlayer='0000050', @pItemIndex='21043', @pItemSerialNum=-484837806, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=43621612133049984 0
2011/11/ 4 06:15:51
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320383754, @pserverindex='01', @pidPlayer='0000440', @pItemIndex='22060', @pItemSerialNum=-277899153, @pItemCnt=1, @pAbilityOpt=9, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=5291601826816
2011/11/ 4 06:15:51
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320383754, @pserverindex='01', @pidPlayer='0000440', @pItemIndex='22246', @pItemSerialNum=2020038988, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=64939809376311552 0
2011/11/ 4 06:15:51
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320383754, @pserverindex='01', @pidPlayer='0000440', @pItemIndex='22247', @pItemSerialNum=946723605, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=46858795482218572 8
2011/11/ 4 06:15:51
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320383754, @pserverindex='01', @pidPlayer='0000440', @pItemIndex='22249', @pItemSerialNum=1608184150, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=13871287714701642 24
2011/11/ 4 06:19:42
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320383982, @pserverindex='01', @pidPlayer='0000440', @pItemIndex='21044', @pItemSerialNum=-1628939197, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=13510999610097666 56
2011/11/ 4 06:37:04
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320385044, @pserverindex='01', @pidPlayer='0000440', @pItemIndex='18027', @pItemSerialNum=1421487536, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=2487329754112
2011/11/ 4 06:37:04
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320385044, @pserverindex='01', @pidPlayer='0000440', @pItemIndex='18026', @pItemSerialNum=291672266, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=64939857446390835 2
2011/11/ 4 06:37:04
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320385044, @pserverindex='01', @pidPlayer='0000440', @pItemIndex='18024', @pItemSerialNum=-1095354615, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=64939802638581606 4
2011/11/ 4 06:53:06
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320386005, @pserverindex='01', @pidPlayer='0000373', @pItemIndex='22256', @pItemSerialNum=-218019307, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=5154047525632
2011/11/ 4 06:53:06
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320386005, @pserverindex='01', @pidPlayer='0000373', @pItemIndex='22255', @pItemSerialNum=-790914842, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=36385795038511360
2011/11/ 4 06:53:06
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320386005, @pserverindex='01', @pidPlayer='0000373', @pItemIndex='22061', @pItemSerialNum=1256081137, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=46922394034162995 2
2011/11/ 4 06:54:51
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320386103, @pserverindex='01', @pidPlayer='0000373', @pItemIndex='2009', @pItemSerialNum=2064574431, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=208843316736
2011/11/ 4 06:55:35
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320386136, @pserverindex='01', @pidPlayer='0000444', @pItemIndex='2009', @pItemSerialNum=2064574431, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=208843316736
2011/11/ 4 06:57:34
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320386266, @pserverindex='01', @pidPlayer='0000444', @pItemIndex='22255', @pItemSerialNum=-790914842, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=36385795038511360
2011/11/ 4 07:06:00
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320386781, @pserverindex='01', @pidPlayer='0000373', @pItemIndex='22255', @pItemSerialNum=-790914842, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=36385795038511360
2011/11/ 4 07:06:00
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320386781, @pserverindex='01', @pidPlayer='0000373', @pItemIndex='2009', @pItemSerialNum=2064574431, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=208843316736
2011/11/ 4 09:56:22
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320396983, @pserverindex='01', @pidPlayer='0000335', @pItemIndex='10297', @pItemSerialNum=1399544083, @pItemCnt=1, @pAbilityOpt=1, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=73289185171616256
2011/11/ 4 09:58:01
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320397081, @pserverindex='01', @pidPlayer='0000335', @pItemIndex='21040', @pItemSerialNum=635138736, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=63402404909180569 6
2011/11/ 4 10:06:09
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320397594, @pserverindex='01', @pidPlayer='0000070', @pItemIndex='21040', @pItemSerialNum=635138736, @pItemCnt=1, @pAbilityOpt=0, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=63402404909180569 6
2011/11/ 4 10:51:07
\BF Source\Source\_Database\DbManager.cpp, 8071 RANKING.RANKING_DBF.dbo.usp_guildbank_log_view 'S1','000014','01'
2011/11/ 4 10:51:50
\BF Source\Source\_Database\DbManager.cpp, 8071 RANKING.RANKING_DBF.dbo.usp_guildbank_log_view 'S2','000014','01'
2011/11/ 4 10:52:33
\BF Source\Source\_Database\DbManager.cpp, 8071 RANKING.RANKING_DBF.dbo.usp_guildbank_log_view 'S3','000014','01'
2011/11/ 4 10:53:16
\BF Source\Source\_Database\DbManager.cpp, 8071 RANKING.RANKING_DBF.dbo.usp_guildbank_log_view 'S4','000014','01'
2011/11/ 4 11:50:51
SavePlayer(Bonus) - Exec RETURN FALSE, ThreadID : 61632
2011/11/ 4 12:08:59
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320404943, @pserverindex='01', @pidPlayer='0000297', @pItemIndex='22298', @pItemSerialNum=1435173765, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=2545976359936
2011/11/ 4 12:08:59
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320404943, @pserverindex='01', @pidPlayer='0000297', @pItemIndex='22301', @pItemSerialNum=1565175098, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=13871632549572779 52
2011/11/ 4 12:43:20
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320406995, @pserverindex='01', @pidPlayer='0000455', @pItemIndex='22331', @pItemSerialNum=-926368684, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=43269919628564915 2
2011/11/ 4 13:04:52
\BF Source\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @pTradeID=1320408290, @pserverindex='01', @pidPlayer='0000443', @pItemIndex='22331', @pItemSerialNum=-926368684, @pItemCnt=1, @pAbilityOpt=10, @pItemResist=0, @pResistAbilityOpt=0,@pRandomOpt=43269919628564915 2

PS: Beim Createn eines Goku Haares kommt natürlich auch kein Item mehr.
Ich bitte um schnelle hilfe Davor ging es.

[Professor Linebeck]

Hast du die Einträge so gelassen wie sie sind?
Bzw hast du die Definierung verändert von den Item's wärend ein Spieler das Item used?

[.Zephion]

Nein, habe ich nicht...