[10870][patch] Removing character and friend list

[Unik2psc]

What bug does the patch fix? What features does the patch add?

Delete characters from friend list when friend are online.

For which repository revision was the patch created?

MaNGOS/master

Is there a thread in the bug report section or at lighthouse? If yes, please add a link to the thread.

If We deleted character and our friends are online. Our friends will have "non existing" in friends list.

Who has been writing this patch? Please include either forum user names or email addresses.

Emtec on github.

Link to patch

https://gist.github.com/738573

Need test. I'll update my server tommorow (sorry)

[VladimirMangos]

Hmm, i only not see why need any JOIN in select.

I think "SELECT DISTINCT guid FROM character_social WHERE friend = '%u'" will do what need.

sObjectAccessor.FindPlayer req. real guid. Special buld catchers will generate compile error at attempt send uint32 to it. And this good.

Must called in way: sObjectAccessor.FindPlayer(ObjectGuid(HIGHGUID_PLAYER, fieldsFriend[0].GetUInt32()))

[VladimirMangos]

In [10870] with described fixes. Thank you