File: 20041211-syncmail.php

package info (click to toggle)
gforge 4.5.14-22etch13
  • links: PTS
  • area: main
  • in suites: etch
  • size: 13,004 kB
  • ctags: 11,918
  • sloc: php: 36,047; sql: 29,050; sh: 10,538; perl: 6,496; xml: 3,810; makefile: 341; python: 263; ansic: 256
file content (90 lines) | stat: -rw-r--r-- 2,343 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
#! /usr/bin/php4 -f
<?php
require_once('www/include/squal_pre.php');
require_once('common/mail/MailingList.class');
require_once('common/include/Group.class');

//
//	Set up this script to run as the site admin
//

$res = db_query("SELECT user_id FROM user_group WHERE admin_flags='A' AND group_id='1'");

if (!$res) {
	echo db_error();
	exit();
}

if (db_numrows($res) == 0) {
	// There are no Admins yet, aborting without failing
	echo "SUCCESS\n";
	exit();
}

$id=db_result($res,0,0);
session_set_new($id);

$res = db_query("SELECT group_id, unix_group_name 
	FROM groups 
	WHERE STATUS='A' ORDER BY group_id");

if (!$res) {
	echo "FAIL\n";
	exit();
} else {

	for ($i=0; $i<db_numrows($res); $i++) {
		$group_id   = db_result($res,$i,'group_id');
		$group_name = db_result($res,$i,'unix_group_name');
	
		$res2 = db_query("SELECT * FROM mail_group_list 
			WHERE group_id = '".$group_id."' 
			AND list_name = '".$group_name."-commits'");
	
		if (db_numrows($res2) < 1) {
			$group = new Group($group_id);
			if (!$group || !is_object($group)) {
				$was_error=true;
				echo "Could Not Get Group Object for $group_name";
			} elseif ($group->isError()) {
				$was_error=true;
				echo "Could Not Get Group Object for $group_name: ".$group->getErrorMessage();
			} else {
	
				$res_aux2 = db_query("SELECT user_id FROM user_group 
					WHERE admin_flags = 'A' 
					AND group_id = '".$group_id."'");
	
				$group_admin = db_result($res_aux2,0,'user_id');
	
				echo "Will create mailing list for <b>".$group_name."-commits</b><br>\n";
				$mailing_list = new MailingList($group);
				if (!$mailing_list || !is_object($mailing_list)) {
					$was_error=true;
					echo "Could Not Get MailingList Object for $group_name";
				} elseif ($mailing_list->isError()) {
					$was_error=true;
					echo "Could Not Get MailingList Object for $group_name: ".$mailing_list->getErrorMessage();
				} else {
					if (!$mailing_list->create('commits', 'cvs commits', 1,$group_admin)) {
						$was_error=true;
						echo "Could Not Create New Mailing List for $group_name: ".$mailing_list->getErrorMessage();
					} else {
						if ($mailing_list->isError()) {
							$was_error=true;
							echo $mailing_list->getErrorMessage();
						} else {

						}
					}
				}
			}
		}
	}
	if ($was_error) {
		echo "FAIL\n";
	} else {
		echo "SUCCESS\n";
	}
}
?>