CreateCharacter Auto Seal of Wealth

[rustyhead]

i just modefied the CreateCharacter procedure to make newly created character with seal of wealth for 7 days.

here is the code

SELECT [USER=1335]user[/USER]Guid = memb_guid FROM Me_MuOnline.dbo.MEMB_INFO WHERE memb___id =  [USER=162874]account[/USER]ID
INSERT INTO dbo.IGC_PeriodItemInfo(UserGUID,CharacterName,ItemType,ItemCode,EffectCategory,EffectType1,EffectType2,Serial,Duration,BuyDate,ExpireDate,UsedInfo,BuyDateString,ExpireDateString)
VALUES [USER=1335]user[/USER]GUID,  [USER=1333344765]name[/USER],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.

 

[KarLi]

Since doing it this way is abit complicated, can't you add a special box/gift in inventory (untradeable) so which when they use/drop = they get seal of wealth for 7 days instead ?

 

[rustyhead]

Since doing it this way is abit complicated, can't you add a special box/gift in inventory (untradeable) so which when they use/drop = they get seal of wealth for 7 days instead ?

how can i make it that happened? essential tool cant make special gift..

 

[KarLi]

then find way and put the gift in inventory

and check the inventory code in dbo.inventory of that character and copy it, then update it as default in defaultclasstype for the specific class character to start with that inventory code (with the item u want)

as explained;

https://forum.ragezone.com/f193/new-characters-with-startup-items-1207037/