Moderators (requests and notices)

I'm not so special I see.

I am suprised you are allowed to send some many messages in shuch a short amount of time

i'm emailing them. you are all invited to the wedding if it works out by the way. just leave the field clear for me to take a decent run at it. i'll tag out if things go sour, who wants 2nd dibs

You do realise we all only got the messages after rejection from Ed and Sumo. We’re not first choice soulmates.

Also had the same PM. I thought I was special. :(

Edit: My comment isn't even special.

It's either @hippy or @Dammit using an alias.

It would've never worked out for us, them in London, me in Cheshire, and also the fact they appear to be a bit of a slag.
I'll just delete it, and try not to think about the path not taken.

Obviously it's @rpm

My one said it wanted to be in a relationship with me if I could sell them an arrospok for fifty dollars.

Now I realise that it's spam I'm all like...

Feeling very baby blue.

I've had the same message, from that user twice..

https://www.lfgss.com/profiles/200642/

Hands off my lady you cunts.

TWICE

i'll defer to my more handsome colleague
story of my life

.

1 Attachment

You’re all so cynical. I emailed them and now I’m in a loving relationship (once I’ve handed over my bank details)

I've asked them to give me their bank details

I pulled too.

Thanks, nuked and blocked.

I feel left out... ;)

I feel cockblocked. Damn, she could've been the one. And now I'll never know.

@Velocio I have the "new message" icon but no new message. I assume I was also one of the lucky ones to receive an invite to form a new relationship and as you have deleted all of the messages I have no way of resetting my unread count. Not really a major issue for me as I don't tend to get a lot of PMs but might impact others too.

did it just fix for you?

I've just tried to do it manually, to see if it's a repeatable thing.

One day I will need to remember I just added this:

CREATE OR REPLACE FUNCTION UpdateHuddleCountsForSite(in_site_id integer)
RETURNS VOID AS $$
DECLARE profile RECORD;
BEGIN 
FOR profile IN SELECT profile_id, profile_name FROM profiles WHERE site_id = in_site_id ORDER BY profile_id
LOOP

WITH u AS (
    SELECT COALESCE(COUNT(*) OVER(), 0) AS total
      FROM flags ff
      JOIN (
               SELECT hp.huddle_id
                     ,f.last_modified
                 FROM huddle_profiles hp
                      JOIN flags f ON f.item_type_id = 5
                                  AND f.item_id = hp.huddle_id
                 LEFT JOIN read r ON r.profile_id = profile.profile_id
                                 AND r.item_type_id = 5
                                 AND r.item_id = f.item_id
                 LEFT JOIN read r2 ON r2.profile_id = profile.profile_id
                                  AND r2.item_type_id = 5
                                  AND r2.item_id = 0
                WHERE hp.profile_id = profile.profile_id
                  AND f.last_modified > COALESCE(
                                            COALESCE(
                                                r.read,
                                                r2.read
                                            ),
                                            TIMESTAMP WITH TIME ZONE '1970-01-01 12:00:00'
                                        )
           ) AS h ON ff.parent_item_id = h.huddle_id
                 AND ff.parent_item_type_id = 5
                 AND ff.last_modified >= h.last_modified
      LEFT JOIN ignores i ON i.profile_id = profile.profile_id
                         AND i.item_type_id = 3
                         AND i.item_id = ff.created_by
     WHERE i.profile_id IS NULL
     GROUP BY h.huddle_id
     LIMIT 1
)
UPDATE profiles
   SET unread_huddles = COALESCE((SELECT total FROM u), 0)
 WHERE profile_id = profile.profile_id;

RAISE NOTICE '% %', profile.profile_id, profile.profile_name;
END LOOP;
END;
$$language plpgsql;

Well, I ran it.

My count doesn't look wrong... I've flushed caches... so I'm just assuming that SQL did what it was supposed to do.

Yep, fixed. Thanks!

I've never had an alias on here.

I would hit on you in the old fashioned way.
(No, less old fashioned than just dragging you back to my cave)

dragging you back to my cave

And then what big boy?