Help Daily Gift

04/18/2018 14:40 Rapid0#1
can anyone help me i successfully add it but when i try to login and i cant connect to select character and this is what i got

CQuery-LogFile_20180418
Code:
2018/04/18	20:36:16
query:CHARACTER_STR 'S2',@im_idPlayer='0000000'      [MENTION=3453071]iServe[/MENTION]rindex='01',@iaccount='rapido',@im_szName='1f6488b99d48ea5wd1wdk2j93ca699ed'      [MENTION=2476276]iPlayer[/MENTION]slot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=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_nFatiguePoint=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_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_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,@im_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_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0      [MENTION=3173290]itot[/MENTION]alPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0      [MENTION=714211]Im_BanK[/MENTION]='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)'      [MENTION=706561]iskill[/MENTION]Influence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)'      [MENTION=714211]Im_BanK[/MENTION]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,@iszInventoryPet='(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_nDailyGift=0,@im_nLastGift=0
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]@im_nDailyGift is not a parameter for procedure CHARACTER_STR.
error_20180418
Code:
2018/ 4/18 20:36:16
\server\Source\Program\_Database\DbManager.cpp, 556	CHARACTER_STR 'S2',@im_idPlayer='0000000'      [MENTION=3453071]iServe[/MENTION]rindex='01',@iaccount='rapido',@im_szName='1f6488b99d48ea5wd1wdk2j93ca699edd'      [MENTION=2476276]iPlayer[/MENTION]slot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=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_nFatiguePoint=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_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_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,@im_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_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0      [MENTION=3173290]itot[/MENTION]alPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0      [MENTION=714211]Im_BanK[/MENTION]='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)'      [MENTION=706561]iskill[/MENTION]Influence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)'      [MENTION=714211]Im_BanK[/MENTION]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,@iszInventoryPet='(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_nDailyGift=0,@im_nLastGift=0

	rapido, 1f6488b99d48ea5wd1wdk2j93ca699ed
please help me
04/18/2018 15:00 Dr. Peacock#2
You miss some parts at the Database. (Check: CHARACTER_STR...)
04/18/2018 15:12 Rapid0#3
Quote:
Originally Posted by Dr. Peacock View Post
You miss some parts at the Database. (Check: CHARACTER_STR...)
do i need to put this on character_str sir?
Code:
	sprintf( strCharacter, ",@im_nDailyGift=%d", m_nDailyGift );
	strncat(qryCharacter, strCharacter, sizeof(strCharacter));
	sprintf( strCharacter, ",@im_nLastGift=%d", m_nLastGift );
	strncat(qryCharacter, strCharacter, sizeof(strCharacter));
04/18/2018 16:30 alfredico#4
Ofc is not, can't you see the red underlining?