2 /****************************************************************/
4 /****************************************************************/
5 /* Copyright (c) 2002-2009 */
6 /* Inclusive Design Institute */
9 /* This program is free software. You can redistribute it and/or*/
10 /* modify it under the terms of the GNU General Public License */
11 /* as published by the Free Software Foundation. */
12 /****************************************************************/
14 $_user_location = 'public';
16 define('AT_INCLUDE_PATH', '../../../include/');
17 require(AT_INCLUDE_PATH.'vitals.inc.php');
18 require(AT_SOCIAL_INCLUDE.'friends.inc.php');
19 $_custom_css = $_base_path . AT_SOCIAL_BASENAME . 'module.css'; // use a custom stylesheet
21 if (!$_SESSION['valid_user']) {
22 require(AT_INCLUDE_PATH.'header.inc.php');
23 $info = array('INVALID_USER', $_SESSION['course_id']);
24 $msg->printInfos($info);
25 require(AT_INCLUDE_PATH.'footer.inc.php');
30 $member = new Member($_SESSION['member_id']);
32 // Handles social profile
33 if ($_POST['social_profile']){
34 //update database from here
35 header('Location: sprofile.php');
40 if (isset($_POST['submit'])){
41 //where was this request sent from
42 if (isset($_POST['edit'])){
43 $id = intval($_POST['id']);
44 if ($_POST['edit']=='position'){
45 $company = $_POST['company'];
46 $title = $_POST['title'];
47 $from = $_POST['from'];
49 $description = $_POST['description'];
50 $member->updatePosition($id, $company, $title, $from, $to, $description);
51 } elseif ($_POST['edit']=='education'){
52 $university = $_POST['university'];
53 $country = $_POST['country'];
54 $province = $_POST['province'];
55 $degree = $_POST['degree'];
56 $field = $_POST['field'];
57 $from = $_POST['from'];
59 $description = $_POST['description'];
60 $member->updateEducation($id, $university, $from, $to, $country, $province, $degree, $field, $description);
61 } elseif ($_POST['edit']=='websites'){
63 $site_name = $_POST['site_name'];
64 $member->updateWebsite($id, $url, $site_name);
65 } elseif ($_POST['edit']=='interests' || $_POST['edit']=='associations' || $_POST['edit']=='awards' || $_POST['edit']=='expertise'
66 || $_POST['edit']=='others'){
67 $interests = isset($_POST['interests'])&&$_POST['interests']==''? _AT('na'): $_POST['interests'];
68 $associations = isset($_POST['associations'])&&$_POST['associations']==''? _AT('na'): $_POST['associations'];
69 $awards = isset($_POST['awards'])&&$_POST['awards']==''? _AT('na'): $addslashes($_POST['awards']);
70 $expertise = isset($_POST['expertise'])&&$_POST['expertise']==''? _AT('na'): $_POST['expertise'];
71 $others = isset($_POST['others'])&&$_POST['others']==''? _AT('na'): $_POST['others'];
72 $member->updateAdditionalInformation($interests, $associations, $awards, $expertise, $others);
73 } elseif ($_POST['edit']=='representation'){
74 $rep_name = $_POST['rep_name'];
75 $rep_title = $_POST['rep_title'];
76 $rep_phone = $_POST['rep_phone'];
77 $rep_email = $_POST['rep_email'];
78 $rep_address = $_POST['rep_address'];
79 $member->updateRepresentation($id, $rep_name, $rep_title, $rep_phone, $rep_email, $rep_address);
80 } elseif ($_POST['edit']=='contact'){
81 $rep_name = $_POST['con_name'];
82 $rep_phone = $_POST['con_phone'];
83 $rep_email = $_POST['con_email'];
84 $rep_address = $_POST['con_address'];
85 $member->updateContact($id, $con_name, $con_phone, $con_email, $con_address);
86 } elseif ($_POST['edit']=='personal'){
87 $per_weight = $_POST['per_weight'];
88 $per_height = $_POST['per_height'];
89 $per_hair = $_POST['per_hair'];
90 $per_eyes = $_POST['per_eyes'];
91 $per_ethnicity = $_POST['per_ethnicity'];
92 $per_languages = $_POST['per_languages'];
93 $per_disabilities = $_POST['per_disabilities'];
94 $member->updatePersonal($per_weight, $per_height, $per_hair, $per_eyes, $per_ethnicity, $per_languages, $per_disabilities);
97 elseif (isset($_POST['add'])) {
98 if ($_POST['add']=='position'){
99 $company = $_POST['company'];
100 $title = $_POST['title'];
101 $from = $_POST['from'];
103 $description = $_POST['description'];
104 $member->addPosition($company, $title, $from, $to, $description);
105 } elseif ($_POST['add']=='education'){
106 $university = $_POST['university'];
107 $country = $_POST['country'];
108 $province = $_POST['province'];
109 $degree = $_POST['degree'];
110 $field = $_POST['field'];
111 $from = $_POST['from'];
113 $description = $_POST['description'];
114 $member->addEducation($university, $from, $to, $country, $province, $degree, $field, $description);
115 } elseif ($_POST['add']=='websites'){
116 $url = $_POST['url'];
117 $site_name = $_POST['site_name'];
118 $member->addWebsite($url, $site_name);
119 } elseif ($_POST['add']=='interests'){
120 $interests = $_POST['interests'];
121 $member->addInterests($interests);
122 } elseif ($_POST['add']=='associations'){
123 $associations = $_POST['associations'];
124 $member->addAssociations($associations);
125 } elseif ($_POST['add']=='awards'){
126 $awards = $_POST['awards'];
127 $member->addAwards($awards);
128 } elseif ($_POST['add']=='representation'){
129 $rep_name = $_POST['rep_name'];
130 $rep_title = $_POST['rep_title'];
131 $rep_phone = $_POST['rep_phone'];
132 $rep_email = $_POST['rep_email'];
133 $rep_address = $_POST['rep_address'];
134 $member->addRepresentation( $rep_name, $rep_title, $rep_phone, $rep_email, $rep_address);
135 } elseif ($_POST['add']=='contact'){
136 $con_name = $_POST['con_name'];
137 $con_phone = $_POST['con_phone'];
138 $con_email = $_POST['con_email'];
139 $con_address = $_POST['con_address'];
140 $member->addContact($con_name, $con_phone, $con_email, $con_address);
141 } elseif ($_POST['add']=='personal'){
142 $per_weight = $_POST['per_weight'];
143 $per_height = $_POST['per_height'];
144 $per_hair = $_POST['per_hair'];
145 $per_eyes = $_POST['per_eyes'];
146 $per_ethnicity = $_POST['per_ethnicity'];
147 $per_languages = $_POST['per_languages'];
148 $per_disabilities = $_POST['per_disabilities'];
149 $member->addPersonal($per_weight, $per_height, $per_hair, $per_eyes, $per_ethnicity, $per_languages, $per_disabilities);
156 if (isset($_GET['add'])){
157 //header starts here.
158 include(AT_INCLUDE_PATH.'header.inc.php');
159 if ($_GET['add']=='position'){
160 $savant->display('social/edit_profile/edit_position.tmpl.php');
161 } elseif ($_GET['add']=='education'){
162 $savant->display('social/edit_profile/edit_education.tmpl.php');
163 } elseif ($_GET['add']=='websites'){
164 $savant->display('social/edit_profile/edit_websites.tmpl.php');
165 } elseif ($_GET['add']=='interests' || $_GET['add']=='associations' || $_GET['add']=='awards'){
166 $savant->assign('title', $_GET['add']);
167 $savant->display('social/edit_profile/edit_additional.tmpl.php');
168 } elseif ($_GET['add']=='representation'){
169 $savant->display('social/edit_profile/edit_representation.tmpl.php');
170 } elseif ($_GET['add']=='contact'){
171 $savant->display('social/edit_profile/edit_contact.tmpl.php');
172 } elseif ($_GET['add']=='personal'){
173 $savant->display('social/edit_profile/edit_personal.tmpl.php');
176 include(AT_INCLUDE_PATH.'footer.inc.php');
181 if (isset($_GET['edit']) && isset($_GET['id']) && (intval($_GET['id']) > 0)){
182 $id = intval($_GET['id']);
184 //header starts here.
185 include(AT_INCLUDE_PATH.'header.inc.php');
186 $savant->assign('id', $id);
187 if ($_GET['edit']=='position'){
188 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_position WHERE id='.$id;
189 $rs = mysql_query($sql, $db);
190 $row = mysql_fetch_assoc($rs);
193 $savant->assign('company', $row['company']);
194 $savant->assign('profile_title', $row['title']);
195 $savant->assign('from', $row['from']);
196 $savant->assign('to', $row['to']);
197 $savant->assign('description', $row['description']);
198 $savant->display('social/edit_profile/edit_position.tmpl.php');
199 } elseif ($_GET['edit']=='education'){
200 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_education WHERE id='.$id;
201 $rs = mysql_query($sql, $db);
202 $row = mysql_fetch_assoc($rs);
205 $savant->assign('university', $row['university']);
206 $savant->assign('country', $row['country']);
207 $savant->assign('province', $row['province']);
208 $savant->assign('degree', $row['degree']);
209 $savant->assign('field', $row['field']);
210 $savant->assign('from', $row['from']);
211 $savant->assign('to', $row['to']);
212 $savant->assign('description', $row['description']);
213 $savant->display('social/edit_profile/edit_education.tmpl.php');
214 } elseif ($_GET['edit']=='websites'){
215 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_websites WHERE id='.$id;
216 $rs = mysql_query($sql, $db);
217 $row = mysql_fetch_assoc($rs);
220 $savant->assign('url', $row['url']);
221 $savant->assign('site_name', $row['site_name']);
222 $savant->display('social/edit_profile/edit_websites.tmpl.php');
224 } elseif ($_GET['edit']=='interests'){
225 $sql = 'SELECT interests FROM '.TABLE_PREFIX.'social_member_additional_information WHERE member_id='.$_SESSION['member_id'];
226 $rs = mysql_query($sql, $db);
227 $row = mysql_fetch_assoc($rs);
230 $savant->assign('interests', $row['interests']);
231 $savant->assign('title', 'interests');
232 $savant->display('social/edit_profile/edit_additional.tmpl.php');
233 } elseif ($_GET['edit']=='associations'){
234 $sql = 'SELECT associations FROM '.TABLE_PREFIX.'social_member_additional_information WHERE member_id='.$_SESSION['member_id'];
235 $rs = mysql_query($sql, $db);
236 $row = mysql_fetch_assoc($rs);
239 $savant->assign('associations', $row['associations']);
240 $savant->assign('title', 'associations');
241 $savant->display('social/edit_profile/edit_additional.tmpl.php');
242 } elseif ($_GET['edit']=='awards'){
243 $sql = 'SELECT awards FROM '.TABLE_PREFIX.'social_member_additional_information WHERE member_id='.$_SESSION['member_id'];
244 $rs = mysql_query($sql, $db);
245 $row = mysql_fetch_assoc($rs);
248 $savant->assign('awards', $row['awards']);
249 $savant->assign('title', 'awards');
250 $savant->display('social/edit_profile/edit_additional.tmpl.php');
251 } elseif ($_GET['edit']=='representation'){
252 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_representation WHERE member_id='.$_SESSION['member_id'];
253 $rs = mysql_query($sql, $db);
254 $row = mysql_fetch_assoc($rs);
257 $savant->assign('rep_name', $row['rep_name']);
258 $savant->assign('rep_title', $row['rep_title']);
259 $savant->assign('rep_phone', $row['rep_phone']);
260 $savant->assign('rep_email', $row['rep_email']);
261 $savant->assign('rep_address', $row['rep_address']);
262 $savant->display('social/edit_profile/edit_representation.tmpl.php');
264 }elseif ($_GET['edit']=='contact'){
265 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_contact WHERE member_id='.$_SESSION['member_id'];
266 $rs = mysql_query($sql, $db);
267 $row = mysql_fetch_assoc($rs);
270 $savant->assign('con_name', $row['con_name']);
271 $savant->assign('con_title', $row['con_title']);
272 $savant->assign('con_phone', $row['con_phone']);
273 $savant->assign('con_email', $row['con_email']);
274 $savant->assign('con_address', $row['con_address']);
275 $savant->display('social/edit_profile/edit_contact.tmpl.php');
277 }elseif ($_GET['edit']=='personal'){
278 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_personal WHERE member_id='.$_SESSION['member_id'];
279 $rs = mysql_query($sql, $db);
280 $row = mysql_fetch_assoc($rs);
283 $savant->assign('per_weight', $row['per_weight']);
284 $savant->assign('per_height', $row['per_height']);
285 $savant->assign('per_hair', $row['per_hair']);
286 $savant->assign('per_eyes', $row['per_eyes']);
287 $savant->assign('per_ethnicity', $row['per_ethnicity']);
288 $savant->assign('per_languages', $row['per_languages']);
289 $savant->assign('per_disabilities', $row['per_disabilities']);
290 $savant->display('social/edit_profile/edit_personal.tmpl.php');
294 include(AT_INCLUDE_PATH.'footer.inc.php');
300 if (isset($_GET['delete'])){
301 $id = intval($_GET['id']);
302 if ($_GET['delete']=='position'){
303 $member->deletePosition($id);
304 } elseif ($_GET['delete']=='education'){
305 $member->deleteEducation($id);
306 } elseif ($_GET['delete']=='websites'){
307 $member->deleteWebsite($id);
308 } elseif ($_GET['delete']=='interests'){
309 $member->deleteInterests($id);
310 } elseif ($_GET['delete']=='associations'){
311 $member->deleteAssociations($id);
312 } elseif ($_GET['delete']=='awards'){
313 $member->deleteAwards($id);
314 } elseif ($_GET['delete']=='representation'){
315 $member->deleteRepresentation($id);
316 } elseif ($_GET['delete']=='contact'){
317 $member->deleteContact($id);
318 } elseif ($_GET['delete']=='personal'){
319 $member->deletePersonal($id);
325 include(AT_INCLUDE_PATH.'header.inc.php');
326 $savant->display('social/pubmenu.tmpl.php');
327 $savant->assign('profile', $member->getDetails());
328 $savant->assign('position', $member->getPosition());
329 $savant->assign('education', $member->getEducation());
330 $savant->assign('websites', $member->getWebsites());
331 $savant->assign('representation', $member->getRepresentation());
332 $savant->assign('contact', $member->getContact());
333 $savant->assign('personal', $member->getPersonal());
334 $savant->display('social/edit_profile.tmpl.php');
335 include(AT_INCLUDE_PATH.'footer.inc.php');