/**
* Notification View for liking annotation
*
* @return voud;
* @access private
*/
function ossn_like_annotation($hook, $type, $return, $params)
{
$notif = $params;
$baseurl = ossn_site_url();
$user = ossn_user_by_guid($notif->poster_guid);
$user->fullname = "<strong>{$user->fullname}</strong>";
$img = "<div class='notification-image'><img src='{$baseurl}/avatar/{$user->username}/small' /></div>";
if (preg_match('/like/i', $notif->type)) {
$type = 'like';
$database = new OssnDatabase();
$database->statement("SELECT * FROM kullaniciveriler WHERE(guid='{$notif->subject_guid}')");
$database->execute();
$result = $database->fetch();
$url = ossn_site_url("post/view/{$notif->subject_guid}#comments-item-{$notif->item_guid}");
if ($result->subtype == 'file:ossn:aphoto') {
$url = ossn_site_url("photos/view/{$notif->subject_guid}#comments-item-{$notif->item_guid}");
}
}
$type = "<div class='ossn-notification-icon-{$type}'></div>";
if ($notif->viewed !== NULL) {
$viewed = '';
} elseif ($notif->viewed == NULL) {
$viewed = 'class="ossn-notification-unviewed"';
}
$notification_read = "{$baseurl}notification/read/{$notif->guid}?notification=" . urlencode($url);
return "<a href='{$notification_read}'>\n\t <li {$viewed}> {$img} \n\t\t <div class='notfi-meta'> {$type}\n\t\t <div class='data'>" . ossn_print("ossn:notifications:{$notif->type}", array($user->fullname)) . '</div>
</div></li>';
}
/**
* Get user group posts guids
*
* @param integer $userguid Guid of user
*
* @return array;
*/
public static function getUserGroupPostsGuids($userguid)
{
if (empty($userguid)) {
return false;
}
$statement = "SELECT * FROM ossn_entities, ossn_entities_metadata WHERE(\n\t\t\t\t ossn_entities_metadata.guid = ossn_entities.guid \n\t\t\t\t AND ossn_entities.subtype='poster_guid'\n\t\t\t\t AND type = 'object'\n\t\t\t\t AND value = '{$userguid}'\n\t\t\t\t );";
$database = new OssnDatabase();
$database->statement($statement);
$database->execute();
$objects = $database->fetch(true);
if ($objects) {
foreach ($objects as $object) {
$guids[] = $object->owner_guid;
}
asort($guids);
return $guids;
}
return false;
}
* @link http://www.opensource-socialnetwork.org/licence
*/
//This upgrade might timeout, so set no time limit
set_time_limit(0);
//Please see: Things , should be provided in 3.x #421
$database = new OssnDatabase();
//delete a notification that have incorrect owner_guid
//1.) Remove old like:post:group:wall notification type
//2.) Remove old comments:post:group:wall type
$vars['from'] = 'ossn_notifications';
$vars['wheres'] = array("type = 'like:post:group:wall' OR type='comments:post:group:wall'");
$database->delete($vars);
//add new column to users table
//3.) Add time_created to ossn_users table
$database->statement("ALTER TABLE `ossn_users` ADD `time_created` INT(11) NOT NULL AFTER `activation`;");
$database->execute();
//ossn_object description text to longtext and title to text #459
//5.) ossn_object description text to longtext and title to text #459
$database->statement("ALTER TABLE `ossn_object` CHANGE `title` `title` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, \n\t\t\t\t\t CHANGE `description` `description` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;");
$database->execute();
//add last_cache and site_version in settings
$database->statement("INSERT INTO `ossn_site_settings` (`name`) VALUES ('last_cache')");
$database->execute();
$database->statement("INSERT INTO `ossn_site_settings` (`name`) VALUES ('site_version')");
$database->execute();
//update user time_created cloumn from user entites
$users = ossn_get_entities(array('type' => 'user', 'subtype' => 'gender', 'page_limit' => false));
if ($users) {
unset($vars);
foreach ($users as $user) {
if (isset($user->owner_guid) && empty($user->owner_guid)) {
/**
* Get user group posts guids
*
* @param (int) $userguid Guid of user
*
* @return array;
*/
public static function getUserGroupPostsGuids($userguid)
{
if (empty($userguid)) {
return false;
}
$statement = "SELECT * FROM kullaniciveriler, kullanicivericerik WHERE(\n\t\t\t\t kullanicivericerik.guid = kullaniciveriler.guid\n\t\t\t\t AND kullaniciveriler.subtype='poster_guid'\n\t\t\t\t AND type = 'object'\n\t\t\t\t AND value = '{$userguid}'\n\t\t\t\t );";
$database = new OssnDatabase();
$database->statement($statement);
$database->execute();
$objects = $database->fetch(true);
if ($objects) {
foreach ($objects as $object) {
$guids[] = $object->owner_guid;
}
asort($guids);
return $guids;
}
return false;
}
