Forum: Community Center


Subject: All the broken freestuff ---

_dodger opened this issue on Jan 19, 2003 ยท 8 posts


_dodger posted Mon, 20 January 2003 at 1:57 AM

An idea then: add a column to the FreeStuff database called active char(0). Run a script to check the statuses of every one nightly and if it doesn't return 200-OK, mark it NULL, and if it is okay leave it ''. (In MySQL there is no Boolean datatype, but a char(0) works just as well. The value is either NULL or '' (nothing but defined as nothing). This works as a boolean. Modify the output to only list ones WHERE active IS NOT NULL