All pastes #99425 Raw Edit

Gopneg

public text v1 · immutable
#99425 ·published 2006-07-25 09:01 UTC
rendered paste body
    select count(grcm.acgrcmid) -- +BDUEQQQ7BDg- >= 1 +BEIEPg- +BEAEMAQ3BEAENQRIBDUEPQQ+-, +BEUEPgRCBE8- +BD8EPg- +BDgENAQ1BDU- +BDEEPgQ7BEwESAQ1- 1 +BDEESwRCBEw- 
                                -- +BD0ENQ- +BDQEPgQ7BDYEPQQ+- - +BEEEQgRABEMEOgRCBEMEQAQw- +BDEEMAQ3BEs- +BEIEMAQ6BD4EMgQw-, +BE8- +BD0EMAQ0BDUETgRBBEw- :)
    into Result
    from accgrcomm grcm, accgracc acgr 
    where 
      grcm.accgr = acgr.accgr
      and grcm.allowed >= 1 -- +BDIESwQxBDgEQAQwBDUEPA- +BDMEQARDBD8EPwRL- +BDQEOwRP- +BDoEPgRCBD4EQARLBEU- +BEAEMAQ3BEAENQRIBDUEPQQ+-
      and grcm.allowed is not null -- +BDIESwQxBDgEQAQwBDUEPA- +BDMEQARDBD8EPwRL- +BDQEOwRP- +BDoEPgRCBD4EQARLBEU- +BEAEMAQ3BEAENQRIBDUEPQQ+-
      and grcm.comm = ncid
        select c.cid -- +BDIESwQxBDgEQAQwBDUEPA- +BDoEPgQ8BDAEPQQ0BEM-
        from commands c
        where c.name = vcommand)   
        
      and grcm.chnl in (
        select ch.chid -- +BDIESwQxBDgEQAQwBDUEPA- +BDoEMAQ9BDAEOw-
          from channels ch
          where ch.channel = vchannel
            and ch.ntwrk = nnetwork
            or ch.chid = 1
            or ch.chid = 2) 
    
      and acgr.acc = naccid( -- +BDIESwQxBDgEQAQwBDUEPA- +BDMEQARDBD8EPwRD- +BDAEOgQwBEMEPQRCBD4EMg-
        select ac.accid -- +BDIESwQxBDgEQAQwBDUEPA- +BDAEOgQ6BDAEQwQ9BEI-
        from accounts ac 
        where ( ac.locked = 0 -- +BDAEOgQ6BDAEQwQ9BEI- +BD0ENQ- +BDcENQQxBDsEPgQ6BDgEQAQ+BDIEMAQ9-
                or ac.locked is null)
              and ac.logined >= 1 -- +BE4ENwQ1BEA- +BDcEMAQ7BD4EMwQ4BD0ENQQ9-   
              and ac.logined is not null
              and ac.logusr = (
                    select u.usid from users u -- +BDIESwQxBDgEQAQwBDUEPA- +BE4ENwQ1BEAEMA-
                    where u.nick = (
                            select n.nckid
                            from nicks n
                            where n.nick = vnick)                    
                          and u.usr = vusr
                          and u.host = vhost
                          and u.ntwork = nnetwork));