1 # Setup Table for ATutor Social Networking Feature
\r
3 CREATE TABLE `social_activities` (
\r
4 `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
5 `member_id` INTEGER UNSIGNED NOT NULL,
\r
6 `application_id` INTEGER UNSIGNED NOT NULL,
\r
8 `created_date` TIMESTAMP NOT NULL,
\r
13 # Applications/ Gagdets table
\r
14 CREATE TABLE `social_applications` (
\r
15 `id` INTEGER UNSIGNED,
\r
16 `url` VARCHAR(255) NOT NULL DEFAULT '',
\r
17 `title` VARCHAR(255) NOT NULL,
\r
18 `height` INTEGER UNSIGNED,
\r
19 `scrolling` INTEGER UNSIGNED,
\r
20 `screenshot` VARCHAR(255) NOT NULL,
\r
21 `thumbnail` VARCHAR(255) NOT NULL,
\r
22 `author` VARCHAR(255) NOT NULL,
\r
23 `author_email` VARCHAR(128) NOT NULL,
\r
24 `description` TEXT NOT NULL,
\r
25 `settings` TEXT NOT NULL,
\r
26 `views` TEXT NOT NULL,
\r
27 `last_updated` TIMESTAMP NOT NULL,
\r
32 # Application Settings, like storing the perference string.
\r
33 CREATE TABLE `social_application_settings` (
\r
34 `application_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
35 `member_id` INTEGER UNSIGNED NOT NULL,
\r
36 `name` VARCHAR(255) NOT NULL,
\r
37 `value` TEXT NOT NULL,
\r
38 PRIMARY KEY (`application_id`, `member_id`, `name`)
\r
42 # Application members mapping
\r
43 CREATE TABLE `social_members_applications` (
\r
44 `member_id` INTEGER UNSIGNED NOT NULL,
\r
45 `application_id` INTEGER UNSIGNED NOT NULL,
\r
46 PRIMARY KEY (`member_id`, `application_id`)
\r
51 CREATE TABLE `social_friends` (
\r
52 `member_id` INTEGER UNSIGNED NOT NULL,
\r
53 `friend_id` INTEGER UNSIGNED NOT NULL,
\r
54 `relationship` INTEGER UNSIGNED NOT NULL,
\r
55 PRIMARY KEY (`member_id`, `friend_id`)
\r
59 # Friend requests table
\r
60 CREATE TABLE `social_friend_requests` (
\r
61 `member_id` INTEGER UNSIGNED NOT NULL,
\r
62 `friend_id` INTEGER UNSIGNED NOT NULL,
\r
63 `relationship` INTEGER UNSIGNED NOT NULL,
\r
64 PRIMARY KEY (`member_id`, `friend_id`)
\r
68 # Person Positions (jobs)
\r
69 CREATE TABLE `social_member_position` (
\r
70 `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
71 `member_id` INTEGER UNSIGNED NOT NULL,
\r
72 `title` VARCHAR(255) NOT NULL,
\r
73 `company` VARCHAR(255) NOT NULL,
\r
74 `from` VARCHAR(10) NOT NULL DEFAULT 0,
\r
75 `to` VARCHAR(10) NOT NULL DEFAULT 0,
\r
82 CREATE TABLE `social_member_education` (
\r
83 `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
84 `member_id` INTEGER UNSIGNED NOT NULL,
\r
85 `university` VARCHAR(255) NOT NULL,
\r
86 `country` VARCHAR(128),
\r
87 `province` VARCHAR(128),
\r
88 `degree` VARCHAR(64),
\r
89 `field` VARCHAR(64),
\r
90 `from` VARCHAR(10) NOT NULL DEFAULT 0,
\r
91 `to` VARCHAR(10) NOT NULL DEFAULT 0,
\r
92 `description` TEXT NOT NULL,
\r
97 # Person related web sites
\r
98 CREATE TABLE `social_member_websites` (
\r
99 `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
100 `member_id` INTEGER UNSIGNED NOT NULL,
\r
101 `url` VARCHAR(255) NOT NULL,
\r
102 `site_name` VARCHAR(255),
\r
107 # Tracks visitor counts
\r
108 CREATE TABLE `social_member_track` (
\r
109 `member_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
110 `visitor_id` INTEGER UNSIGNED NOT NULL,
\r
111 `timestamp` TIMESTAMP NOT NULL,
\r
112 PRIMARY KEY (`member_id`, `visitor_id`, `timestamp`)
\r
116 # Person additional information cojoint with the members table
\r
117 CREATE TABLE `social_member_additional_information` (
\r
118 `member_id` INTEGER UNSIGNED NOT NULL,
\r
119 `expertise` VARCHAR(255) NOT NULL,
\r
121 `associations` TEXT,
\r
124 PRIMARY KEY (`member_id`)
\r
128 # Privacy Control Preferences
\r
129 CREATE TABLE `social_privacy_preferences` (
\r
130 `member_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
131 `preferences` TEXT NOT NULL,
\r
132 PRIMARY KEY (`member_id`)
\r
136 # Social Group tables
\r
137 CREATE TABLE `social_groups` (
\r
138 `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
139 `member_id` INTEGER UNSIGNED NOT NULL,
\r
140 `type_id` INTEGER UNSIGNED NOT NULL,
\r
141 `privacy` INTEGER UNSIGNED NOT NULL,
\r
142 `name` VARCHAR(255) NOT NULL,
\r
143 `logo` VARCHAR(255) NOT NULL,
\r
144 `description` TEXT NOT NULL,
\r
145 `created_date` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
\r
146 `last_updated` TIMESTAMP NOT NULL,
\r
151 CREATE TABLE `social_groups_activities` (
\r
152 `activity_id` INTEGER UNSIGNED NOT NULL,
\r
153 `group_id` INTEGER UNSIGNED NOT NULL,
\r
154 PRIMARY KEY (`activity_id`, `group_id`)
\r
158 CREATE TABLE `social_groups_members` (
\r
159 `group_id` INTEGER UNSIGNED NOT NULL,
\r
160 `member_id` INTEGER UNSIGNED NOT NULL,
\r
161 PRIMARY KEY (`group_id`, `member_id`)
\r
165 CREATE TABLE `social_groups_invitations` (
\r
166 `sender_id` INTEGER UNSIGNED NOT NULL,
\r
167 `member_id` INTEGER UNSIGNED NOT NULL,
\r
168 `group_id` INTEGER UNSIGNED NOT NULL,
\r
169 PRIMARY KEY (`sender_id`, `member_id`, `group_id`)
\r
173 CREATE TABLE `social_groups_requests` (
\r
174 `sender_id` INTEGER UNSIGNED NOT NULL,
\r
175 `member_id` INTEGER UNSIGNED NOT NULL,
\r
176 `group_id` INTEGER UNSIGNED NOT NULL,
\r
177 PRIMARY KEY (`sender_id`, `member_id`, `group_id`)
\r
181 CREATE TABLE `social_groups_types` (
\r
182 `type_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
183 `title` VARCHAR(127) NOT NULL,
\r
184 PRIMARY KEY (`type_id`)
\r
188 # CREATE TABLE `social_groups_forums` (
\r
189 # `group_id` INTEGER UNSIGNED NOT NULL,
\r
190 # `forum_id` INTEGER UNSIGNED NOT NULL,
\r
191 # PRIMARY KEY (`group_id`, `forum_id`)
\r
195 # Groups message board
\r
196 CREATE TABLE `social_groups_board` (
\r
197 `id` int(10) unsigned NOT NULL auto_increment,
\r
198 `member_id` int(10) unsigned NOT NULL,
\r
199 `group_id` int(10) unsigned NOT NULL,
\r
200 `body` text NOT NULL,
\r
201 `created_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
\r
206 CREATE TABLE `social_user_settings` (
\r
207 `member_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
\r
208 `app_settings` TEXT NOT NULL,
\r
209 PRIMARY KEY (`member_id`)
\r
214 #====== Initial Data ========
\r
215 INSERT INTO social_groups_types SET title='business', type_id=1;
\r
216 INSERT INTO social_groups_types SET title='common_interest', type_id=2;
\r
217 INSERT INTO social_groups_types SET title='entertainment_arts', type_id=3;
\r
218 INSERT INTO social_groups_types SET title='geography', type_id=4;
\r
219 INSERT INTO social_groups_types SET title='internet_technology', type_id=5;
\r
220 INSERT INTO social_groups_types SET title='organization', type_id=6;
\r
221 INSERT INTO social_groups_types SET title='music', type_id=7;
\r
222 INSERT INTO social_groups_types SET title='sports_recreation', type_id=8;
\r
225 INSERT INTO `language_text` VALUES ('en', '_module','network_home','My Network',NOW(),'');
\r
226 INSERT INTO `language_text` VALUES ('en', '_module','settings','Settings',NOW(),'');
\r
227 INSERT INTO `language_text` VALUES ('en', '_module','social','Networking',NOW(),'');
\r
228 INSERT INTO `language_text` VALUES ('en', '_module','applications','Gadgets',NOW(),'');
\r
229 INSERT INTO `language_text` VALUES ('en', '_module','manage_applications','Manage Gadgets',NOW(),'');
\r
230 INSERT INTO `language_text` VALUES ('en', '_module','add_application','Add Gadget',NOW(),'');
\r
231 INSERT INTO `language_text` VALUES ('en', '_module','add_to_mygadgets','Add to My Gadgets',NOW(),'');
\r
232 INSERT INTO `language_text` VALUES ('en', '_module','show_available_applications','Show Available Gadgets',NOW(),'');
\r
233 INSERT INTO `language_text` VALUES ('en', '_module','network_updates','Network Activity',NOW(),'');
\r
234 INSERT INTO `language_text` VALUES ('en', '_module','connections','My Contacts',NOW(),'');
\r
235 INSERT INTO `language_text` VALUES ('en', '_module','no_activities','No network activity.',NOW(),'');
\r
236 INSERT INTO `language_text` VALUES ('en', '_module','no_friends','You have no contacts yet.',NOW(),'');
\r
237 INSERT INTO `language_text` VALUES ('en', '_module','pending_friend_requests','Pending Friend Requests',NOW(),'');
\r
238 INSERT INTO `language_text` VALUES ('en', '_module','profile_picture','Profile Picture',NOW(),'');
\r
239 INSERT INTO `language_text` VALUES ('en', '_module','approve_request','Approve Request',NOW(),'');
\r
240 INSERT INTO `language_text` VALUES ('en', '_module','accept_request','Accept Request',NOW(),'');
\r
241 INSERT INTO `language_text` VALUES ('en', '_module','search_for_friends','Search People',NOW(),'');
\r
242 INSERT INTO `language_text` VALUES ('en', '_module','my_connections','Settings',NOW(),'');
\r
243 INSERT INTO `language_text` VALUES ('en', '_module','there_are_entries','There are %s entries.',NOW(),'');
\r
244 INSERT INTO `language_text` VALUES ('en', '_module','remove_friend','Remove Contact',NOW(),'');
\r
245 INSERT INTO `language_text` VALUES ('en', '_module','add_to_friends','Add to contacts',NOW(),'');
\r
246 INSERT INTO `language_text` VALUES ('en', '_module','my_friends_only','Only my contacts',NOW(),'');
\r
247 INSERT INTO `language_text` VALUES ('en', '_module','expertise','Expertise',NOW(),'');
\r
248 INSERT INTO `language_text` VALUES ('en', '_module','dob','Date of Birth',NOW(),'');
\r
249 INSERT INTO `language_text` VALUES ('en', '_module','interests','Interests',NOW(),'');
\r
250 INSERT INTO `language_text` VALUES ('en', '_module','associations','Associations',NOW(),'');
\r
251 INSERT INTO `language_text` VALUES ('en', '_module','awards','Awards',NOW(),'');
\r
252 INSERT INTO `language_text` VALUES ('en', '_module','others','Others',NOW(),'');
\r
253 INSERT INTO `language_text` VALUES ('en', '_module','training_and_education','Training and Education',NOW(),'');
\r
254 INSERT INTO `language_text` VALUES ('en', '_module','credits_and_work_experience','Credits and Work Experience',NOW(),'');
\r
255 INSERT INTO `language_text` VALUES ('en', '_module','institution','School/Institution',NOW(),'');
\r
256 INSERT INTO `language_text` VALUES ('en', '_module','degree','Degree/Program/Courses',NOW(),'');
\r
257 INSERT INTO `language_text` VALUES ('en', '_module','year','Year',NOW(),'');
\r
258 INSERT INTO `language_text` VALUES ('en', '_module','company','Company',NOW(),'');
\r
259 INSERT INTO `language_text` VALUES ('en', '_module','title','Title',NOW(),'');
\r
260 INSERT INTO `language_text` VALUES ('en', '_module','activities','Activities',NOW(),'');
\r
261 INSERT INTO `language_text` VALUES ('en', '_module','edit_profile','Edit Profile',NOW(),'');
\r
262 INSERT INTO `language_text` VALUES ('en', '_module','has_added_app','has added the <a href="%s">%s</a> gadget',NOW(),'');
\r
263 INSERT INTO `language_text` VALUES ('en', '_module','gadgets','Gadgets',NOW(),'');
\r
264 INSERT INTO `language_text` VALUES ('en', '_module','add_application_url','Add gadget by URL',NOW(),'');
\r
265 INSERT INTO `language_text` VALUES ('en', '_module','your_applications','My Gadgets',NOW(),'');
\r
266 INSERT INTO `language_text` VALUES ('en', '_module','social_profile','Network Profile',NOW(),'');
\r
267 INSERT INTO `language_text` VALUES ('en', '_module','social_groups','Network Groups',NOW(),'');
\r
268 INSERT INTO `language_text` VALUES ('en', '_module','search_for_groups','Search for Groups',NOW(),'');
\r
269 INSERT INTO `language_text` VALUES ('en', '_module','recently_joined','Recently Joined',NOW(),'');
\r
270 INSERT INTO `language_text` VALUES ('en', '_module','my_groups','My Network Groups',NOW(),'');
\r
271 INSERT INTO `language_text` VALUES ('en', '_module','group_name','Group Name',NOW(),'');
\r
272 INSERT INTO `language_text` VALUES ('en', '_module','group_type','Group Type',NOW(),'');
\r
273 INSERT INTO `language_text` VALUES ('en', '_module','group_logo','Group Logo',NOW(),'');
\r
274 INSERT INTO `language_text` VALUES ('en', '_module','business','Business',NOW(),'');
\r
275 INSERT INTO `language_text` VALUES ('en', '_module','common_interest','Common Interest',NOW(),'');
\r
276 INSERT INTO `language_text` VALUES ('en', '_module','entertainment_arts','Arts and Entertainment',NOW(),'');
\r
277 INSERT INTO `language_text` VALUES ('en', '_module','geography','Geographic',NOW(),'');
\r
278 INSERT INTO `language_text` VALUES ('en', '_module','internet_technology','Internet Technology',NOW(),'');
\r
279 INSERT INTO `language_text` VALUES ('en', '_module','music','Music',NOW(),'');
\r
280 INSERT INTO `language_text` VALUES ('en', '_module','sports_recreation','Sports and Recreation',NOW(),'');
\r
281 INSERT INTO `language_text` VALUES ('en', '_module','group_info','Group Details',NOW(),'');
\r
282 INSERT INTO `language_text` VALUES ('en', '_module','created_by','Created By',NOW(),'');
\r
283 INSERT INTO `language_text` VALUES ('en', '_module','group_last_update','Last Update',NOW(),'');
\r
284 INSERT INTO `language_text` VALUES ('en', '_module','number_of_members','Number of Members',NOW(),'');
\r
285 INSERT INTO `language_text` VALUES ('en', '_module','message_board','Message Board',NOW(),'');
\r
286 INSERT INTO `language_text` VALUES ('en', '_module','invite','Invite',NOW(),'');
\r
287 INSERT INTO `language_text` VALUES ('en', '_module','invite_groups','Invite New Group Members',NOW(),'');
\r
288 INSERT INTO `language_text` VALUES ('en', '_module','leave_group','Leave Group',NOW(),'');
\r
289 INSERT INTO `language_text` VALUES ('en', '_module','edit_group','Edit Group',NOW(),'');
\r
290 INSERT INTO `language_text` VALUES ('en', '_module','disband_group','Disband Group',NOW(),'');
\r
291 INSERT INTO `language_text` VALUES ('en', '_module','added_member','Added Members',NOW(),'');
\r
292 INSERT INTO `language_text` VALUES ('en', '_module','not_added_member','Add Members',NOW(),'');
\r
293 INSERT INTO `language_text` VALUES ('en', '_module','invite_group','Invite New Group Members',NOW(),'');
\r
294 INSERT INTO `language_text` VALUES ('en', '_module','position','Position',NOW(),'');
\r
295 INSERT INTO `language_text` VALUES ('en', '_module','add_new_position','Add new position',NOW(),'');
\r
296 INSERT INTO `language_text` VALUES ('en', '_module','education','Education',NOW(),'');
\r
297 INSERT INTO `language_text` VALUES ('en', '_module','add_new_education','Add new education',NOW(),'');
\r
298 INSERT INTO `language_text` VALUES ('en', '_module','websites','Websites',NOW(),'');
\r
299 INSERT INTO `language_text` VALUES ('en', '_module','add_new_website','Add new website',NOW(),'');
\r
300 INSERT INTO `language_text` VALUES ('en', '_module','add_new_interest','Add new interest',NOW(),'');
\r
301 INSERT INTO `language_text` VALUES ('en', '_module','add_new_association','Add new association',NOW(),'');
\r
302 INSERT INTO `language_text` VALUES ('en', '_module','add_new_award','Add new award',NOW(),'');
\r
303 INSERT INTO `language_text` VALUES ('en', '_module','reject_request','Reject Request',NOW(),'');
\r
304 INSERT INTO `language_text` VALUES ('en', '_module','show_your_applications','Show Your Gadgets',NOW(),'');
\r
305 INSERT INTO `language_text` VALUES ('en', '_module','available_applications','Available Gadgets',NOW(),'');
\r
306 INSERT INTO `language_text` VALUES ('en', '_module','view_groups','View Group',NOW(),'');
\r
307 INSERT INTO `language_text` VALUES ('en', '_module','now_friends1','and %s are now contacts.',NOW(),'');
\r
308 INSERT INTO `language_text` VALUES ('en', '_module','now_friends2','and %s are now contacts',NOW(),'');
\r
309 INSERT INTO `language_text` VALUES ('en', '_module','friends','My Contacts',NOW(),'');
\r
310 INSERT INTO `language_text` VALUES ('en', '_module','friends_of_friends','Contacts of Your Contacts',NOW(),'');
\r
311 INSERT INTO `language_text` VALUES ('en', '_module','local_network','Local Network',NOW(),'');
\r
312 INSERT INTO `language_text` VALUES ('en', '_module','world_network','World Network',NOW(),'');
\r
313 INSERT INTO `language_text` VALUES ('en', '_module','basic_profile','Basic Profile',NOW(),'');
\r
314 INSERT INTO `language_text` VALUES ('en', '_module','detailed_profile','Detailed Profile',NOW(),'');
\r
315 INSERT INTO `language_text` VALUES ('en', '_module','show_all','show all',NOW(),'');
\r
316 INSERT INTO `language_text` VALUES ('en', '_module','profile_control','Profile Visability',NOW(),'');
\r
317 INSERT INTO `language_text` VALUES ('en', '_module','no_gadgets_installed','You have not installed any gadgets yet.',NOW(),'');
\r
318 INSERT INTO `language_text` VALUES ('en', '_module','privacy_control_blurb','Controls who can see your profile and related information.',NOW(),'');
\r
319 INSERT INTO `language_text` VALUES ('en', '_module','search_visibility','Search Visibility',NOW(),'');
\r
320 INSERT INTO `language_text` VALUES ('en', '_module','search_profile','Search Profile',NOW(),'');
\r
321 INSERT INTO `language_text` VALUES ('en', '_module','search_connections','Search Connections',NOW(),'');
\r
322 INSERT INTO `language_text` VALUES ('en', '_module','search_education','Search Education',NOW(),'');
\r
323 INSERT INTO `language_text` VALUES ('en', '_module','search_position','Search Position',NOW(),'');
\r
324 INSERT INTO `language_text` VALUES ('en', '_module','privacy_settings','Privacy Settings',NOW(),'');
\r
325 INSERT INTO `language_text` VALUES ('en', '_module','new_group_invitations','New Group Invitations',NOW(),'');
\r
326 INSERT INTO `language_text` VALUES ('en', '_module','group_joined','You are a member of this group.',NOW(),'');
\r
327 INSERT INTO `language_text` VALUES ('en', '_module','has_requested_to','%s has requested to join the group %s.',NOW(),'');
\r
328 INSERT INTO `language_text` VALUES ('en', '_module','placelogo','Place holder logo',NOW(),'');
\r
329 INSERT INTO `language_text` VALUES ('en', '_module','has_invited_join','%s has invited you to join <a href="mods/social/groups/view.php?id=%s">%s</a>.',NOW(),'');
\r
330 INSERT INTO `language_text` VALUES ('en', '_module','suggestions','Suggestions',NOW(),'');
\r
331 INSERT INTO `language_text` VALUES ('en', '_module','university','School/Institution',NOW(),'');
\r
332 INSERT INTO `language_text` VALUES ('en', '_module','field','Area of Study',NOW(),'');
\r
333 INSERT INTO `language_text` VALUES ('en', '_module','create_group','Create New Group',NOW(),'');
\r
334 INSERT INTO `language_text` VALUES ('en', '_module','create_group_blurb','Create a new group on a particular topic, then invite people to post news items or discuss the topic. ',NOW(),'');
\r
335 INSERT INTO `language_text` VALUES ('en', '_module','group_admin','Group Moderator',NOW(),'');
\r
336 INSERT INTO `language_text` VALUES ('en', '_module','added_members','Current Group Members',NOW(),'');
\r
337 INSERT INTO `language_text` VALUES ('en', '_module','not_added_members','Invite Group Members',NOW(),'');
\r
338 INSERT INTO `language_text` VALUES ('en', '_module','edit_education','Edit Education',NOW(),'');
\r
339 INSERT INTO `language_text` VALUES ('en', '_module','admin_social','Social Network Settings',NOW(),'');
\r
341 INSERT INTO `language_text` VALUES ('en', '_module','application_settings','Gadget Settings',NOW(),'');
\r
342 INSERT INTO `language_text` VALUES ('en', '_module','application_control_blurb','Choose which gadgets to display on your networking home page.',NOW(),'');
\r
343 INSERT INTO `language_text` VALUES ('en', '_module','show_on_home_page','Show on Home Page',NOW(),'');
\r
344 INSERT INTO `language_text` VALUES ('en', '_module','group_last_updated','Last Updated ',NOW(),'');
\r
345 INSERT INTO `language_text` VALUES ('en', '_module','people_you_may_know','People you may know',NOW(),'');
\r
346 INSERT INTO `language_text` VALUES ('en', '_module','account_settings','Account settings',NOW(),'');
\r
347 INSERT INTO `language_text` VALUES ('en', '_module','application_settings','Application settings',NOW(),'');
\r
348 INSERT INTO `language_text` VALUES ('en', '_module','show_on_home_page','Show this gadget?',NOW(),'');
\r
349 INSERT INTO `language_text` VALUES ('en', '_module','notification_new_contact','%s wants to add you to as a ATutor Social contact. Follow the link below to login and accept or reject the request.
\r
352 Sent from ATutor Social at:
\r
355 INSERT INTO `language_text` VALUES ('en', '_module','contact_request','ATutor Social Contact Request',NOW(),'');
\r
356 INSERT INTO `language_text` VALUES ('en', '_module','contact_accepted','ATutor Social Contact Accepted',NOW(),'');
\r
357 INSERT INTO `language_text` VALUES ('en', '_module','notification_accept_contact','%s has been added to your ATutor Social contacts. Follow the link below to review your new contact.
\r
360 Sent from ATutor Social at:
\r
363 INSERT INTO `language_text` VALUES ('en', '_module','notification_group_invite','%s has invited you to join the %s group. Follow the link below to login and accept or reject the invitation.
\r
366 Sent from ATutor Social at:
\r
369 INSERT INTO `language_text` VALUES ('en', '_module','group_invitation','ATutor Social Group Invitation',NOW(),'');
\r
370 INSERT INTO `language_text` VALUES ('en', '_module','shindig_url','URL of Optional ShinDig server.',NOW(),'');
\r
371 INSERT INTO `language_text` VALUES ('en', '_module','notification_group_invite_accepted','%s has accepted your invitation to join the %s group. Follow the link below to login to the group.
\r
374 Login to ATutor Social at:
\r
377 INSERT INTO `language_text` VALUES ('en', '_module','group_invitation_accepted','ATutor Social Group Invitation Accepted',NOW(),'');
\r
378 INSERT INTO `language_text` VALUES ('en', '_module','notification_group_request_accepted','Your request to join the %s group has been accepted. Follow the link below to login to the group.
\r
381 Login to ATutor Social at:
\r
384 INSERT INTO `language_text` VALUES ('en', '_module','group_request_accepted','ATutor Social Group Request Accepted',NOW(),'');
\r
385 INSERT INTO `language_text` VALUES ('en', '_module','notification_group_request','A request has been made to join the %s group Follow the link below to login and accept or reject the request.
\r
388 Login to ATutor Social at:
\r
391 INSERT INTO `language_text` VALUES ('en', '_module','group_request','ATutor Social Join Group Request',NOW(),'');
\r
392 INSERT INTO `language_text` VALUES ('en', '_module','no_groups_yet','You have not joined any groups yet.',NOW(),'');
\r
393 INSERT INTO `language_text` VALUES ('en', '_module','shindig_blurb','If you have your own Shindig server setup, your can enter the URL to the server here. If you do not have your own Shindig server, you can either leave the URL empty, or you can use "http://social.atutor.ca/shindig/php" to connect to the ATutor social network. Shindig allows users to link gadgets from other sites into their social networking environment, as well as communicate with those in other social networks. If you choose not to use a Shindig server, your social network will function as a self-contained network, without access to external networks.',NOW(),'');
\r
394 INSERT INTO `language_text` VALUES ('en', '_module','visitor_counts','Visitor counts',NOW(),'');
\r
395 INSERT INTO `language_text` VALUES ('en', '_module','group_about_public','The group is opened to all users. No approval is needed.',NOW(),'');
\r
396 INSERT INTO `language_text` VALUES ('en', '_module','group_about_private','Users will have to be approved by the moderator to join this group.',NOW(),'');
\r
397 INSERT INTO `language_text` VALUES ('en', '_module','degrees','Degrees',NOW(),'');
\r
398 INSERT INTO `language_text` VALUES ('en', '_module','delete_applications','Delete applications',NOW(),'');
\r
400 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_ERROR_CANNOT_BE_EMPTY','Search field cannot be empty.',NOW(),'');
\r
401 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_GADGET_ADDED_SUCCESSFULLY','Gadget was successsfully added.',NOW(),'');
\r
402 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_GADGET_REMOVED_SUCCESSFULLY','Gadget was successsfully removed.',NOW(),'');
\r
403 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_GROUP_CREATED','Group was successfully created.',NOW(),'');
\r
404 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_ERROR_GROUP_CREATION_FAILED','Group creation failed.',NOW(),'');
\r
405 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_GROUP_JOINED','Group successfully joined.',NOW(),'');
\r
406 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_INVITATION_SENT','Invitation successfully sent. Person will be added when the invitation has been accepted.',NOW(),'');
\r
407 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_ERROR_CANT_DELETE_GROUP','You cannot delete this group.',NOW(),'');
\r
408 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_ERROR_GROUP_HAS_BEEN_REMOVED','Group has been removed.',NOW(),'');
\r
409 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_SOCIAL_GROUP_UPDATED','Group successfully updated.',NOW(),'');
\r
410 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_ERROR_GROUP_EDIT_FAILED','Group edit failed.',NOW(),'');
\r
411 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_SOCIAL_SETTINGS_SAVED','Social networking settings have been saved.',NOW(),'');
\r
412 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_ERROR_SOCIAL_SETTINGS_NOT_SAVED','Social networking settings were not saved.',NOW(),'');
\r
413 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_REQUEST_FRIEND_ADDED','Your request has been sent. Your new contact will be added when the person has accepted your request.',NOW(),'');
\r
414 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_JOIN_REQUEST_SENT','Request to join group has been sent. You will be added to the group when your request has been approved.',NOW(),'');
\r
415 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_ERROR_JOIN_REQUEST_FAILED','Request to join group failed. Perhaps you have already requested to join this group.',NOW(),'');
\r
416 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_ERROR_GADGET_DELETED_CANNOT_BE_EMPTY','You need to select at least one application to delete.',NOW(),'');
\r
417 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_ACCEPT_GROUP_INVITATION','Invitation to join group was accepted.',NOW(),'');
\r
418 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_REJECT_GROUP_INVITATION','Invitation to join group was rejected.',NOW(),'');
\r
419 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_ACCEPT_GROUP_REQUEST','Request to join group was accepted.',NOW(),'');
\r
420 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_REJECT_GROUP_REQUEST','Request to join group was rejected.',NOW(),'');
\r
421 INSERT INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_LEFT_GROUP_SUCCESSFULLY','Successfully removed from group.',NOW(),'');
\r
projects / atutor.git / blob