Impromtou Meet.....tonight

We may earn a small commission from affiliate links and paid advertisements. Terms

Status
Not open for further replies.
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
 
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
 
if ( count($this->bad_forum) > 0 )
{
$qe = " AND p.forum_id NOT IN(".implode(',', $this->bad_forum ).") ";
}
 
Originally posted by pissedoffsol@Jan 11 2004, 03:41 PM
if ( count($this->bad_forum) > 0 )
{
$qe = " AND p.forum_id NOT IN(".implode(',', $this->bad_forum ).") ";
}
Click to expand...

haha!
 
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.....
 
//--------------------------------------------
// 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++;
}
 
Originally posted by pissedoffsol@Jan 11 2004, 05:08 PM
//--------------------------------------------
// 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++;
}
Click to expand...

god you are a nerd.

:)
 
bah, thats just a function from the board that i was hacking for v4 useage :D
 
Originally posted by sisteve+Jan 11 2004, 08:41 PM-->
sisteve @ Jan 11 2004 said:
pissedoffsol
Click to expand...
sisteve @ Jan 11 2004 said:
@Jan 11 2004, 05:08 PM
//--------------------------------------------
// 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++;
}
Click to expand...

god you are a nerd.

:)
Click to expand...

:bo: :owned:
 
Status
Not open for further replies.
Back
Top