1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Impromtou Meet.....tonight

Discussion in 'NorthEast' started by Airjockie, Jan 10, 2004.

Thread Status:
Not open for further replies.
  1. Airjockie

    Airjockie Watanabe Whore!!!

    Messages:
    11,238
    Likes Received:
    166
    Joined:
    Jan 21, 2003
    Location:
    Meriden, CT, USA
  2. ScrapinSi

    ScrapinSi Senior Member

    Messages:
    3,292
    Likes Received:
    4
    Joined:
    Feb 27, 2003
    damn... should have read this last night... i would have met up with ya... its not like its far away... I can see the hotel from my house... LOL
     
  3. Celerity

    Celerity Well-Known Member

    Messages:
    21,969
    Likes Received:
    146
    Joined:
    Sep 11, 2003
    a Casino night seems like a good idea, but we need some warning or something before trekking out across the state in the freezing fuck cold.

    -> Steve
     
  4. pissedoffsol

    pissedoffsol RETIRED

    Messages:
    49,693
    Likes Received:
    53
    Joined:
    Sep 28, 2002
    Location:
    Retirement Home
    if ( count($this->bad_forum) > 0 )
    {
    $qe = " AND p.forum_id NOT IN(".implode(',', $this->bad_forum ).") ";
    }
     
  5. Airjockie

    Airjockie Watanabe Whore!!!

    Messages:
    11,238
    Likes Received:
    166
    Joined:
    Jan 21, 2003
    Location:
    Meriden, CT, USA
  6. TurboMirage

    TurboMirage YEEAAAHHH VIP

    Messages:
    24,577
    Likes Received:
    696
    Joined:
    May 20, 2003
    Location:
    Central, MA

    haha!
     
  7. Airjockie

    Airjockie Watanabe Whore!!!

    Messages:
    11,238
    Likes Received:
    166
    Joined:
    Jan 21, 2003
    Location:
    Meriden, CT, USA
    Well...I can't say for certain if I'll have next Sat night off or not...but If I do...I would be up for a trip to swing up there.....

    I will need a DD.....
     
  8. pissedoffsol

    pissedoffsol RETIRED

    Messages:
    49,693
    Likes Received:
    53
    Joined:
    Sep 28, 2002
    Location:
    Retirement Home
    //--------------------------------------------
    // Grab articles new/recent in 1 bad ass query
    //--------------------------------------------

    $limit = $ibforums->vars['csite_article_max'];

    if ( $ibforums->vars['csite_article_recent_on'] AND $ibforums->vars['csite_article_recent_max'] )
    {
    $limit += $ibforums->vars['csite_article_recent_max'];
    }

    if ( count($this->bad_forum) > 0 )
    {
    $qe = " AND p.forum_id NOT IN(".implode(',', $this->bad_forum ).") ";
    }

    if ( $ibforums->vars['csite_article_forum'] )
    {
    $ibforums->vars['csite_article_forum'] = ','.$ibforums->vars['csite_article_forum'];
    }

    // have we converted from another board?

    if ( $ibforums->vars['vb_configured'] )
    {
    $DB->query("SELECT t.*, f.read_perms, f.use_html, p.*, m.avatar, m.view_avs, m.avatar_size, m.id as member_id, m.name as member_name, m.mgroup, g.g_id, g.g_dohtml
    FROM invision_posts p
    LEFT JOIN invision_topics t on (t.tid=p.topic_id and t.approved=1 and t.moved_to IS NULL)
    LEFT JOIN invision_forums f on (f.id=p.forum_id)
    LEFT JOIN invision_members m on (p.author_id=m.id)
    LEFT JOIN invision_groups g on (g.g_id=m.mgroup)
    WHERE p.forum_id IN (-1{$ibforums->vars['csite_article_forum']}) $qe
    GROUP BY p.topic_id
    ORDER BY t.pinned DESC, p.post_date DESC
    LIMIT 0,$limit");
    }
    else
    {
    $DB->query("SELECT t.*, f.read_perms, f.use_html, p.*, m.avatar, m.view_avs, m.avatar_size,
    m.id as member_id, m.name as member_name, m.mgroup, g.g_id, g.g_dohtml
    FROM invision_topics t
    LEFT JOIN invision_members m ON (t.starter_id=m.id)
    LEFT JOIN invision_groups g ON (g.g_id=m.mgroup)
    LEFT JOIN invision_posts p ON (p.topic_id=t.tid AND p.new_topic=1)
    LEFT JOIN invision_forums f on (f.id=p.forum_id)
    WHERE t.forum_id IN (-1{$ibforums->vars['csite_article_forum']}) $qe
    AND t.approved=1 AND (t.moved_to IS NULL or t.moved_to='')
    ORDER BY t.pinned DESC, t.start_date DESC
    LIMIT 0,$limit");
    }

    $i = 0;

    while ( $r = $DB->fetch_row() )
    {

    if ( $i >= $ibforums->vars['csite_article_max'] )
    {
    //------------------------------------
    // Store recent
    //------------------------------------

    $this->recent[ $r['pid'] ] = $r;
    }
    else
    {
    //------------------------------------
    // Store new
    //------------------------------------

    $this->articles[ $r['pid'] ] = $r;
    }

    $i++;
    }
     
  9. Airjockie

    Airjockie Watanabe Whore!!!

    Messages:
    11,238
    Likes Received:
    166
    Joined:
    Jan 21, 2003
    Location:
    Meriden, CT, USA
    :roll: :roll: :roll:

    And WTF is that suppose to do..... :ph34r:
     
  10. Bob Vila

    Bob Vila ɐןıʌ qoq Admin VIP

    Messages:
    4,669
    Likes Received:
    57
    Joined:
    Jul 4, 2003
    Location:
    Bristol, Ct.

    god you are a nerd.

    :)
     
  11. ScrapinSi

    ScrapinSi Senior Member

    Messages:
    3,292
    Likes Received:
    4
    Joined:
    Feb 27, 2003
  12. Jeef

    Jeef NO MA'AM Moderator VIP

    Messages:
    7,150
    Likes Received:
    294
    Joined:
    Sep 29, 2002
    Location:
    CT
  13. pissedoffsol

    pissedoffsol RETIRED

    Messages:
    49,693
    Likes Received:
    53
    Joined:
    Sep 28, 2002
    Location:
    Retirement Home
    bah, thats just a function from the board that i was hacking for v4 useage :D
     
  14. Airjockie

    Airjockie Watanabe Whore!!!

    Messages:
    11,238
    Likes Received:
    166
    Joined:
    Jan 21, 2003
    Location:
    Meriden, CT, USA
    soooo....anyone up for a trip to the Mo/sun this fri or sat?
     
  15. jamesA

    jamesA Well known pissed off telephone guy VIP

    Messages:
    16,123
    Likes Received:
    1,020
    Joined:
    Aug 10, 2003

    :bo: :owned:
     
Thread Status:
Not open for further replies.

Share This Page