i just modefied the CreateCharacter procedure to make newly created character with seal of wealth for 7 days.
here is the code
Code:SELECT @userGuid = memb_guid FROM Me_MuOnline.dbo.MEMB_INFO WHERE memb___id = @accountID INSERT INTO dbo.IGC_PeriodItemInfo(UserGUID,CharacterName,ItemType,ItemCode,EffectCategory,EffectType1,EffectType2,Serial,Duration,BuyDate,ExpireDate,UsedInfo,BuyDateString,ExpireDateString) VALUES @userGUID, @name,1,6700,24,6,7,RAND()*(3000+1),604800,convert(bigint, getdate(),113),convert(bigint, getdate(),113)+7,1,convert(bigint, getdate(),113)-1,convert(bigint, getdate(), 113)+6)
i cant enter the game, but there is no seal of wealth.
i checked IGC_PeriodItemInfo it insert successfully.
and i tried to buy Sealof wealth from xshop ang check IGC_PeriodItemInfo again. and it looks different.
see highlighted. it looks different from what i inserted using the code.
thank you in advance for helping.





Reply With Quote


