Clean Up Congress

Tue, 05 Sep 2006 20:24:53 +0000

nid); $bings4[] = t('

'); $bings4[] = l(t($bing4->title), "node/$bing4->nid"); $bings4[] = t('

'); $bings4[] = t('

'); $bings4[] = t($bing4->teaser); $bings4[] = t('

'); //$bings4[] = t(''); //$bings4[] = l(t('read more'), "node/$bing4->nid"); //$bings4[] = t(''); $bings4[] = t(''); echo (theme_news_list($bings4)); //print the number of people on the site $time_period = variable_get('user_block_seconds_online', 2700); // Perform database queries to gather online user lists. $guests = db_fetch_object(db_query('SELECT COUNT(sid) AS count FROM {sessions} WHERE timestamp >= %d AND uid = 0', time() - $time_period)); $users = db_query('SELECT DISTINCT(uid), MAX(timestamp) AS max_timestamp FROM {sessions} WHERE timestamp >= %d AND uid != 0 GROUP BY uid ORDER BY max_timestamp DESC', time() - $time_period ); $total_users = db_num_rows($users); // Format the output with proper grammar. if ($total_users == 1 && $guests->count == 1) { $output = t('

There is currently %visitors online. Join now!

', array('%members' => format_plural($total_users, '1 user', '%count users'), '%visitors' => format_plural($guests->count, '1 person', '%count people'))); } else { $output = t('

There are currently %visitors online. Join now!

', array('%members' => format_plural($total_users, '1 user', '%count users'), '%visitors' => format_plural($guests->count, '1 person', '%count people'))); } echo $output; // end of code to print # of people on the site. echo ('

Current Campaigns

'); $resultado2 = db_query("SELECT nid from node where type = 'flexinode-8' AND sticky = 1 ORDER BY created LIMIT 0,2"); //$max = 400; while ($campaign_node = db_fetch_object($resultado2)) { $bing3 = node_load($campaign_node->nid); $linktitle = str_replace(' ', '-', $bing3->title); $ltitle = strtolower($linktitle); $bings3[] = t('

'); $bings3[] = t(''); $bings3[] = l(t($bing3->title), "campaigns/main/$ltitle"); $bings3[] = t(''); //$bings3[] = t('
'); $bings3[] = t('

'); $bings3[] = t($bing3->teaser); //$bings3[] = substr(t($bing3->teaser),0,strpos($bing3->teaser," ",$max)); $bings3[] = t('

'); $bings3[] = t(''); $bings3[] = l(t('...act now!'), "campaigns/main/$ltitle"); $bings3[] = t(''); $bings3[] = t('

'); } echo (theme_news_list($bings3)); echo ('

'); echo ('

'); echo l(t('See all our campaigns '), 'campaigns'); echo(''); echo ('

'); echo('

Latest News From the Wire

'); $result = db_query("SELECT n.nid, a.*, af.nid AS feednid FROM {node} n INNER JOIN {aggregator2_item} a ON n.nid = a.nid INNER JOIN {aggregator2_feed} af ON a.fid = af.nid WHERE n.type = 'aggregator2_item' AND n.status = 1 ORDER BY n.created DESC LIMIT 0, 5"); while ($news_node = db_fetch_object($result)) { $bing2 = node_load($news_node->nid); $feed = node_load($news_node->feednid); $bings2[] = t('

'); $bings2[] = l(t($bing2->title),'node/'.$bing2->nid); $bings2[] = t('
'); $bings2[] = t(''); $bings2[] = t($feed->title.' - '); $bings2[] = t(format_date($bing2->created, 'custom', 'M d, g:i A')); $bings2[] = t('
'); $bings2[] = t('

'); $bings2[] = l(t('read more'), "node/$bing2->nid"); $bings2[] = t('

'); } echo ('

'); echo (theme_news_list($bings2)); echo ('

'); echo ('

'); echo l(t('Read more news clips '), 'pcnewswire', array('title' => 'read more news')); echo(''); echo ('

'); ?>

Public Campaign Action Fund - Clean Up Congress - Comments

Clean Up Congress

'); $bings4[] = l(t($bing4->title), "node/$bing4->nid"); $bings4[] = t('

Current Campaigns

Latest News From the Wire