Add ability to create taxonomy-filtered daily nodes

I modified the random daily node function to give this functionality. I don't have the time or the skills to integrate this in with the rest of the module, but I present it here in case it's useful to anyone else.

 function _daily_node_by_tid_filter_random($tid1, $tid2) {
  // Check whether we have already one today which is still valid
  $db_record = db_fetch_object(db_query("SELECT dr.nid FROM {daily_random} dr, {node} n WHERE dr.nid = n.nid AND tid = %d AND n.status = 1 AND dr.date = '%s'", $tid1, _daily_pack_date(_daily_today())));

  if ($db_record) {
    $nid = $db_record->nid;
  } 
  else {
    // If we did not find one, generate a new one
    db_query("DELETE FROM {daily_random} WHERE tid = %d", $tid1);
    $nr_of_rows = db_result(db_query("SELECT COUNT(*) FROM {term_node} t1, {term_node} t2,{daily} d, {node} n WHERE t1.tid = %d AND t2.tid = %d AND t1.nid = n.nid AND t2.nid = n.nid AND n.vid = d.vid AND n.status = 1", $tid1, $tid2));
    if (!$nr_of_rows) {
      return;
    }
    $nid = db_result(db_query("SELECT n.nid FROM {term_node} t1, {term_node} t2, {daily} d, {node} n WHERE t1.tid = %d AND t2.tid = %d AND t1.nid = n.nid AND t2.nid = n.nid AND n.vid = d.vid AND n.status = 1 ORDER BY d.date LIMIT %d,1", $tid1, $tid2, rand(0, $nr_of_rows - 1)));
    db_query("INSERT INTO {daily_random} (tid,nid,date) VALUES (%d,%d,'%s')", $tid1, $nid, _daily_pack_date(_daily_today()));
  }

  $node = node_load($nid);
  return $node;
}

Actually, I've determined this code doesn't work the way I wanted it to. It only allows for one Quote of the Day at a time since the tid for "Quote" is the same regardless of author. I tried to modify it to make it possible to have multiple quotes, but it doesn't seem possible without changing the table schema. So far my modifications to the table schema have been without success.

I've gotten this functionality working to my satisfaction now. Below is the main function which implements it. The calling functions need to be changed slightly in order to pass in the right variables. I haven't integrated it in with the interface, however.

 function _daily_node_by_tid_random($tid, $nrid = 0, $tid2 = 0) {
  // Check whether we have already one today which is still valid
  $db_record = db_fetch_object(db_query("SELECT dr.nid FROM {daily_random} dr, {node} n WHERE dr.nid = n.nid AND tid = %d AND tid2 = %d AND n.status = 1 AND dr.date = '%s'", $tid, $tid2, _daily_pack_date(_daily_today())));
  
  if ($db_record) {
    $nid = $db_record->nid;
  } 
  else {
    // If we did not find one, generate a new one
	if($tid2 == 0) {
		db_query("DELETE FROM {daily_random} WHERE tid = %d AND tid2 = 0", $tid);
		$nr_of_rows = db_result(db_query("SELECT COUNT(*) FROM {term_node} t,{daily} d, {node} n WHERE t.tid = %d AND t.nid = n.nid AND n.vid = d.vid AND n.status = 1", $tid));
		if (!$nr_of_rows) {
		  return;
		}
		$nid = db_result(db_query("SELECT n.nid FROM {term_node} t,{daily} d, {node} n WHERE t.tid = %d AND t.nid = n.nid AND n.vid = d.vid AND n.status = 1 ORDER BY d.date LIMIT %d,1", $tid, rand(0, $nr_of_rows - 1)));
		db_query("INSERT INTO {daily_random} (nrid,tid,tid2,nid,date) VALUES (%d,%d,%d,%d,'%s')", $nrid, $tid, 'NULL', $nid, _daily_pack_date(_daily_today()));
		}
	else {
		db_query("DELETE FROM {daily_random} WHERE tid = %d AND tid2 = %d", $tid, $tid2);
		$nr_of_rows = db_result(db_query("SELECT COUNT(*) FROM {term_node} t1, {term_node} t2, {daily} d, {node} n WHERE t1.tid = %d AND t1.nid = n.nid AND t2.tid = %d AND t2.nid = n.nid AND n.vid = d.vid AND n.status = 1", $tid, $tid2));
		if (!$nr_of_rows) {
		  return;
		}
		$nid = db_result(db_query("SELECT n.nid FROM {term_node} t1, {term_node} t2, {daily} d, {node} n WHERE t1.tid = %d AND t1.nid = n.nid AND t2.tid = %d AND t2.nid = n.nid AND n.vid = d.vid AND n.status = 1 ORDER BY d.date LIMIT %d,1", $tid, $tid2, rand(0, $nr_of_rows - 1)));
		db_query("INSERT INTO {daily_random} (nrid,tid,tid2,nid,date) VALUES (%d,%d,%d,%d,'%s')", $nrid, $tid, $tid2, $nid, _daily_pack_date(_daily_today()));
  		}	
	}	
	
  $node = node_load($nid);
  return $node;
} 

In order to get this to work, the table schema must be as follows:

Field Type Null Key Default
nrid int(11) NO PRI 0
tid int(10) unsigned NO 0
tid2 int(11) YES NULL
nid int(10) unsigned NO 0
date char(8) NO NULL