Alchemy Event !

Alchemy Event is out !

1- Restore database is required.
2- Add this lines into your shard log database to _AddLogItem stored procedure.

IF(@Operation=90 AND @dwData = (Select value from eBot.._AlchemyInfo WHERE str = 'Plus') AND @ItemRefID = (SELECT value from eBot.._AlchemyInfo WHERE str = 'ItemID'))BEGIN
declare @Charname varchar(16) = (SELECT CharName16 FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID)
INSERT INTO eBot.._AlchemyLog VALUES(@CharID,@Charname,@ItemRefID,9,GETDATE())
END