/**
* This function adds a friend to the database, remove the equivalent friend request.
*
* @param int the member being approved, not "MYSELF"
*/
function approveFriendRequest($friend_id){
global $db;
$friend_id = intval($friend_id);
if ($friend_id < 1){
return;
}
//TODO: hardcoded relationship = 1
$sql = "INSERT INTO ".TABLE_PREFIX."social_friends SET member_id=$_SESSION[member_id], friend_id=$friend_id, relationship=1";
$is_succeeded = mysql_query($sql, $db);
//remove the equivalent friend request
if ($is_succeeded){
$is_succeeded = removeFriendRequest($friend_id, $_SESSION['member_id']);
}
//add to activities log
if ($is_succeeded){
$act = new Activity();
$str1 = _AT('now_friends1', printSocialName($friend_id));
$act->addActivity($_SESSION['member_id'], $str1);
$str2 = _AT('now_friends2', printSocialName($_SESSION['member_id']));
$act->addActivity($friend_id, $str2);
unset($act);
}
}
/**
* Add this application to the member's application list
* @param int member_id
* @param int application_id
*/
function addMemberApplication($member_id, $app_id)
{
$member_id = intval($member_id);
$app_id = intval($app_id);
$sql = "REPLACE INTO %ssocial_members_applications (member_id, application_id) VALUES (%d,%d)";
$result = queryDB($sql, array(TABLE_PREFIX, $member_id, $app_id));
if ($result > 0) {
//Add this to the home page
$home_settings = $this->getHomeDisplaySettings();
$home_settings[$app_id] = 1;
//manually set this application
$this->setHomeDisplaySettings($home_settings);
$act = new Activity();
$act->addActivity($_SESSION['member_id'], '', $app_id);
unset($act);
}
}
/**
* Update a group
* @param int group id
* @param int member_id, to update the owner of this group
* @param int the group type specified in the table, social_groups_type
* @param string name of the group
* @param string description of the group
* @param string the filename of the logo
* @param string group privacy, private for 1, public for 0
*/
function updateGroup($group_id, $member_id, $type_id, $name, $description, $logo, $privacy)
{
global $addslashes;
$group_id = intval($group_id);
$member_id = intval($member_id);
$type_id = intval($type_id);
$name = $addslashes($name);
$description = $addslashes($description);
$logo = $addslashes($logo);
$privacy = $privacy == 'private' ? 1 : 0;
//only include logo sql iff it is not empty, otherwise the old entry will be erased.
if ($logo != '') {
$logo_sql = "`logo`='{$logo}', ";
} else {
$logo_sql = '';
}
$sql = "UPDATE %ssocial_groups SET `member_id`=%d, `type_id`=%d, " . $logo_sql . "`name`='%s', `privacy`=%d, `description`='%s', `last_updated`=NOW() WHERE id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $member_id, $type_id, $name, $privacy, $description, $group_id));
if ($result > 0) {
$act = new Activity();
$str1 = _AT('has_updated_group', '<a href="' . url_rewrite(AT_SOCIAL_BASENAME . 'groups/view.php?id=' . $group_id) . '">' . htmlentities_utf8($name)) . '</a>';
$act->addActivity($member_id, $str1);
unset($act);
return true;
}
return false;
}
/**
* 发布活动
*/
public function addActivityAction()
{
$json_data = $this->request->getJsonRawBody(true);
$new_activity_id = Activity::addActivity($json_data);
if ($new_activity_id === false) {
$return_data = array('success' => false, 'err_msg' => '活动发布失败');
} else {
$return_data = array('success' => true, 'err_msg' => '活动发布成功', 'activity_id' => $new_activity_id);
}
$this->view->setVars($return_data);
}
/**
* Add this application to the member's application list
* @param int member_id
* @param int application_id
*/
function addMemberApplication($member_id, $app_id)
{
global $db;
$member_id = intval($member_id);
$app_id = intval($app_id);
$sql = 'INSERT INTO ' . TABLE_PREFIX . "social_members_applications (member_id, application_id) VALUES ({$member_id}, {$app_id})";
$result = mysql_query($sql, $db);
if ($result) {
//Add this to the home page
$home_settings = $this->getHomeDisplaySettings();
$home_settings[$app_id] = 1;
//manually set this application
$this->setHomeDisplaySettings($home_settings);
$act = new Activity();
$act->addActivity($_SESSION['member_id'], '', $app_id);
unset($act);
}
}
<?php
require "../php/init.php";
$mainUser = new User();
if (!$mainUser->inRole(1)) {
die('nope. not allowed!');
}
$actId = Input::get('id');
$act = new Activity();
$oldRoles = $act->showRoles($actId);
if ($userData = Input::get('info')) {
$newRoles = $userData['roles'];
unset($userData['roles']);
if (Input::get('add')) {
Activity::addActivity($userData, $newRoles);
} else {
try {
Activity::updateActivity($actId, $userData);
} catch (Exception $e) {
echo $e;
$error = true;
}
if (!$error) {
foreach ($oldRoles as $key => $oldRole) {
if (!in_array($key, $newRoles)) {
Activity::removeRole($actId, $key);
}
}
foreach ($newRoles as $key => $newRole) {
if (!array_key_exists($newRole, $oldRoles)) {
Activity::addRole($actId, $newRole);
/**
* Add a member to the group
* @param int member id
* @return boolean true if succeded, false otherwise.
*/
function addMember($member_id)
{
global $db;
$member_id = intval($member_id);
$sql = 'INSERT INTO ' . TABLE_PREFIX . 'social_groups_members (group_id, member_id) VALUES (' . $this->group_id . ", {$member_id})";
$result = mysql_query($sql, $db);
if ($result) {
//add a record to the activities
$act = new Activity();
$str1 = _AT('has_joined_group', '<a href="' . url_rewrite(AT_SOCIAL_BASENAME . 'groups/view.php?id=' . $this->getID(), AT_PRETTY_URL_IS_HEADER) . '">' . htmlentities_utf8($this->getName()) . '</a>');
$act->addActivity($member_id, $str1);
unset($act);
return true;
}
return false;
}
