PDA

View Full Version : Select closed threads

COBRAws
11-07-2007, 05:15 AM
Hello guys, I have a piece of code to get all deleted threads, but I need the number so I can get the closed threads, here is the piece of code so its self explanatory.

$vbulletin->db->query_read("SELECT threadid,forumid FROM " . TABLE_PREFIX . "thread WHERE visible=2");


Which number do I have to put into Visible= to select closed threads instead of value 2 = deleted?

Thanks!
Opserty
11-07-2007, 11:19 AM
change visible = 2 to open = 0
COBRAws
11-07-2007, 02:16 PM
change visible = 2 to open = 0
Sorry I didnt explain very good, I need to know the value for closed threads
Opserty
11-07-2007, 02:31 PM
...and that is it...the fieldname is "open" and the value is "0" ... just follow what I said and it will work.
COBRAws
11-07-2007, 06:07 PM
...and that is it...the fieldname is "open" and the value is "0" ... just follow what I said and it will work.
Oh sorry, thanks mate