| 1 |
<?php |
<?php |
| 2 |
// $Id: schedule.module,v 1.2 2005/09/25 12:12:15 MegaGrunt Exp $ |
// $Id: schedule.module,v 1.3 2005/09/25 22:08:28 MegaGrunt Exp $ |
| 3 |
|
|
| 4 |
|
$GLOBALS['installed_modules']['schedule'] = 1.4; |
| 5 |
|
|
| 6 |
|
|
| 7 |
function schedule_help($section = "admin/help#schedule") { |
function schedule_help($section = "admin/help#schedule") { |
| 258 |
} |
} |
| 259 |
|
|
| 260 |
|
|
| 261 |
// get count of qued |
// get count of queued |
| 262 |
function schedule_count_qued($type, $publication_id, $publication_timestamp) { |
function schedule_count_queued($type, $publication_id, $publication_timestamp) { |
| 263 |
|
|
| 264 |
// publication hasn't started sending |
// publication hasn't started sending |
| 265 |
if ($publication_timestamp > time() || $publication_timestamp == 0) return 0; |
if ($publication_timestamp > time() || $publication_timestamp == 0) return 0; |
| 266 |
|
|
| 267 |
$qued_count = db_fetch_array(db_query(" |
$queued_count = db_result(db_query(" |
| 268 |
SELECT s.*, m.pub_time, m.sent |
SELECT COUNT(*) |
| 269 |
FROM {subscribed} s |
FROM {subscribed} s |
| 270 |
LEFT JOIN {users} u ON s.uid = u.uid |
LEFT JOIN {users} u ON s.uid = u.uid |
| 271 |
LEFT JOIN {bounced_email_count} b ON u.mail = b.email |
LEFT JOIN {bounced_email_count} b ON u.mail = b.email |
| 277 |
ORDER BY u.name |
ORDER BY u.name |
| 278 |
", $publication_timestamp, $publication_id, $type, variable_get('bounce_limit', 1))); |
", $publication_timestamp, $publication_id, $type, variable_get('bounce_limit', 1))); |
| 279 |
|
|
| 280 |
return $qued_count; |
return $queued_count; |
| 281 |
|
|
| 282 |
} |
} |
| 283 |
|
|