Mercurial > defr > drupal > ad

comparison adcache.inc @ 7:6aeff3329e01 ad

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
maj module ad 2.1rc1
author piotre
date Mon, 20 Jul 2009 13:54:40 +0000
parents e5584a19768b
children
comparison
equal deleted inserted replaced
6:b7653861e0b4 7:6aeff3329e01
213 * Default function for retrieving list of ids. 213 * Default function for retrieving list of ids.
214 */ 214 */
215 function adserve_cache_id($type, $id) { 215 function adserve_cache_id($type, $id) {
216 switch ($type) { 216 switch ($type) {
217 case 'nids': 217 case 'nids':
218 $result = db_query("SELECT aid FROM {ads} WHERE adstatus = 'active' AND aid IN(%d)", $id); 218 $result = db_query("SELECT aid FROM {ads} WHERE adstatus = 'active' AND aid IN(%s)", $id);
219 break; 219 break;
220 case 'tids': 220 case 'tids':
221 $result = db_query("SELECT a.aid FROM {ads} a INNER JOIN {term_node} n ON a.aid = n.nid WHERE a.adstatus = 'active' AND n.tid IN(%d)", $id); 221 $result = db_query("SELECT a.aid FROM {ads} a INNER JOIN {term_node} n ON a.aid = n.nid WHERE a.adstatus = 'active' AND n.tid IN(%s)", $id);
222 break; 222 break;
223 case 'default': 223 case 'default':
224 $result = db_query("SELECT a.aid FROM {ads} a LEFT JOIN {term_node} n ON a.aid = n.nid WHERE a.adstatus = 'active' AND n.tid IS NULL"); 224 $result = db_query("SELECT a.aid FROM {ads} a LEFT JOIN {term_node} n ON a.aid = n.nid WHERE a.adstatus = 'active' AND n.tid IS NULL");
225 break; 225 break;
226 default: 226 default: