Just a little help with something

[Logikos]

Hey, i'm in the middle of finishing a hack of mine. In the hack it uses the /admincp/forums.php file. To turn this hack on/off of a per forum baisis. Look here so you get a better understanding.


print_yes_no_row($vbphrase['turn_marlboro_on_off'], 'forum[marlboro]', $forum['marlboro']);


Now in some files im using this:

if ($foruminfo['marlboro']=='1')
{
Code here
}
else
{
Code Here
}


Basicly If custom hack is turned on for that forum show this, if not show this instead.

Now my problem is, i have to call the forum IDs that the custom hack is turned on. Heres the query im using now.


$mar = $DB_site->query("
SELECT
thread.threadid as threadid,thread.title as title,thread.forumid as forumid,thread.postusername as postusername,thread.dateline as dateline
FROM thread AS thread
WHERE postuserid= $userinfo[userid] AND forumid IN(X,Y,Z)
ORDER BY dateline DESC
");


Notice the X,Y,Z. I would have to put the forum IDs there, i know i could make this a vbulletin setting and use $vboptions['forum_ids'] in place of the forumid IN(X,Y,Z), but i would rather not have the user turn it on in the forum, and then add the forumid in a box in the vbulletin options area.

Does anyone know what i could use for that query to grab the turned on forums id?

Something like this?

$mar = $DB_site->query("
SELECT
thread.threadid as threadid,thread.title as title,thread.forumid as forumid,thread.postusername as postusername,thread.dateline as dateline
FROM thread AS thread
WHERE postuserid= $userinfo[userid] AND forumid IN(($foruminfo['marlboro'])
ORDER BY dateline DESC
");


Doubt i'm even close. Thanks in advance!

[Logikos]

Bump? :(

[Dean C]

I'm not completely following - can you explain it again :)?

[Dark_Wizard]

Are you just looking for forumid's? And if so why are you making it so complicated?

[Logikos]

Here why, i'm not making it more complacated, im making it much eaiser on the user that will be using this hack:

1.) If the user makes a new forum he has the option to turn this hack on or off per forum. See Screenshot:

http://www.initialz.com/gear/forum1.gif

Now in this query below i need to add the forum IDs where they were turned on. from the screenshot above:

See this query below? Where you see X,Y,Z, i want to code it so it calls the forum ids from where they are turned on from.


$mar = $DB_site->query("
SELECT
thread.threadid as threadid,thread.title as title,thread.forumid as forumid,thread.postusername as postusername,thread.dateline as dateline
FROM thread AS thread
WHERE postuserid= $userinfo[userid] AND forumid IN(X,Y,Z)
ORDER BY dateline DESC
");


Make ant sense now?

[CarCdr]

You'll have to use a JOIN to select only those rows for which the forum table entry has 'marlboro' on.

[Logikos]

I don't understand, isn't LEFT JOIN used to join 2 or more tables together in one query? In this case its not, unless i miss understood you. Maybe an example?

[Dark_Wizard]

Your making this way too complex...contact me via IM today....