4 //create the config file for webcalendar
6 install_password: 764b9c698569b4e77fd69db363fef414
9 db_database: $sys_gfdbname
10 db_login: $sys_gfdbuser
11 db_password: $sys_gfdbpasswd
20 $handle = fopen(forge_get_config('plugins_path') . '/' . $pluginname . "/www/includes/settings.php", "w");
21 fwrite($handle,$fichier_conf);
25 $res = db_query_params ('SELECT user_name,user_pw,email,user_id FROM users WHERE NOT user_name=$1 ',
28 while ($row = db_fetch_array($res)) {
30 $res_flags = db_query_params ('SELECT COUNT(*) FROM user_group WHERE user_id = $1 AND admin_flags = $2 AND group_id = 1',
31 array ($row['user_id'],
33 $row_flags = db_fetch_array($res_flags) ;
34 $cal_res = db_query_params ('INSERT INTO webcal_user (cal_login, cal_passwd, cal_email,cal_firstname, cal_is_admin) VALUES ($1,$2,$3,$4,$5)',
35 array ($row['user_name'] ,
39 $row_flags[0] == 1 ? 'Y' : 'N'));
44 $res2 = db_query_params ('SELECT unix_group_name,groups.group_id,group_name,email FROM groups,users,user_group WHERE groups.group_id >5 AND groups.group_id = user_group.group_id AND user_group.user_id = users.user_id AND user_group.admin_flags = $1 ',
46 while ($row2 = db_fetch_array($res2)) {
48 //get for admin of project
49 $res_user_group = db_query_params ('SELECT user_group.user_id,user_name,email from user_group,users WHERE user_group.user_id = users.user_id AND group_id = $1 AND admin_flags = $2',
50 array ($row2['group_id'],
53 //get the email of the admin
54 $res_mail = db_query_params ('SELECT cal_email FROM webcal_user WHERE cal_login = $1',
55 array ($row2['unix_group_name']));
56 $row_mail = db_fetch_array($res_mail);
57 $mail = $row_mail['cal_email'];
60 while($row_user_group = db_fetch_array($res_user_group)) {
61 $cal_res = db_query_params ('INSERT INTO webcal_asst (cal_boss, cal_assistant) VALUES ($1,$2)',
62 array ($row2['unix_group_name'],
63 $row_user_group['user_name']));
66 $mail = str_replace($row_user_group['email'],"",$mail);
67 $mail = str_replace(",".$row_user_group['email'],"",$mail);
75 $mail = $mail.$virgule.$row_user_group['email'] ;
78 db_query_params ('UPDATE webcal_user SET cal_email = $1 WHERE cal_login = $2',
79 array (trim($mail,','),
80 $row2['unix_group_name'])) ;
82 $cal_res = db_query_params ('INSERT INTO webcal_user (cal_login, cal_passwd, cal_firstname,cal_email) VALUES ($1,$2,$3,$4)',
83 array ($row2['unix_group_name'] ,
85 addslashes($row2['group_name']) ,
93 $res_hierarchy = db_query_params ('select p1.group_id as father_id,p1.unix_group_name as father_unix_name,p1.group_name as father_name,p2.group_id as son_id,p2.unix_group_name as son_unix_name,p2.group_name as son_name from groups as p1,groups as p2,plugin_projects_hierarchy where p1.group_id=plugin_projects_hierarchy.project_id and p2.group_id=plugin_projects_hierarchy.sub_project_id and plugin_projects_hierarchy.activated=$1 AND plugin_projects_hierarchy.link_type=$2',
97 while($row_hierarchy = db_fetch_array($res_hierarchy)) {
98 $res_entry = db_query_params ('SELECT cal_id FROM webcal_entry_user WHERE cal_login = $1 AND cal_status = $2',
99 array ($row_hierarchy['son_unix_name'],
102 while($row_entry = db_fetch_array($res_entry)) {
103 $res_insert_entry = db_query_params ('INSERT INTO webcal_entry_user (cal_id,cal_login,cal_status) VALUES ($1,$2,$3)',
104 array ($row_entry['cal_id'],
105 $row_hierarchy['father_unix_name'],
115 $res = db_query_params ('SELECT value, user_id, group_id FROM user_group,role_setting WHERE role_setting.role_id = user_group.role_id AND role_setting.section_name = $1',
118 while( $row_flags = db_fetch_array($res)){
123 $res_nom_boss = db_query_params ('SELECT unix_group_name FROM groups WHERE group_id = $1 ',
124 array ($row_flags['group_id']));
125 $row_nom_boss = db_fetch_array($res_nom_boss);
128 $res_nom_user = db_query_params ('SELECT user_name FROM users WHERE user_id = $1 ',
129 array ($row_flags['user_id']));
130 $row_nom_user = db_fetch_array($res_nom_user);
133 $res_count = db_query_params ('SELECT COUNT(*) FROM webcal_asst WHERE cal_boss = $1 AND cal_assistant = $2',
134 array ($row_nom_boss['unix_group_name'],
135 $row_nom_user['user_name']));
136 $row_num = db_fetch_array($res_count);
139 $res_mail = db_query_params ('SELECT cal_email FROM webcal_user WHERE cal_login = $1',
140 array ($row_nom_boss['unix_group_name']));
141 $row_mail = db_fetch_array($res_mail);
143 if(($row_num[0] != 1 ) && ($row_flags['value'] == 1)){
144 //recuperer le nom du user et du group
145 $res_insert = db_query_params ('INSERT INTO webcal_asst (cal_boss, cal_assistant) VALUES ($1,$2)',
146 array ($row_nom_boss['unix_group_name'],
147 $row_nom_user['user_name']));
149 //we add email of the new admin
150 $mail = $row_mail['cal_email'].",".$row_nom_user['email'] ;
151 db_query_params ('UPDATE webcal_user SET cal_email = $1 WHERE cal_login = $2',
153 $row_nom_boss['unix_group_name']));
155 elseif($row_num[0] == 1 && ($row_flags['value'] != 1)){
156 $res_del = db_query_params ('DELETE FROM webcal_asst WHERE cal_boss = $1 AND cal_assistant = $2',
157 array ($row_nom_boss['unix_group_name'],
158 $row_nom_user['user_name']));
160 //we del email of the old admin
161 $mail = str_replace(",".$row_nom_user['email'],"",$row_mail['cal_email']) ;
162 db_query_params ('UPDATE webcal_user SET cal_email = $1 WHERE cal_login = $2',
164 $row_nom_boss['unix_group_name']));