/**
* 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;
}
*
* @package (Informatikon.com).ossn
* @author OSSN Core Team <*****@*****.**>
* @copyright 2014 iNFORMATIKON TECHNOLOGIES
* @license General Public Licence http://opensource-socialnetwork.com/licence
* @link http://www.opensource-socialnetwork.com/licence
*/
$database = new OssnDatabase();
/**
* Fix duplicate username in database
*
* @access private
*/
$database->statement("SELECT DISTINCT username, count(username) as \n\t\t\t\t times FROM `ossn_users` GROUP BY username HAVING \n\t\t\t\t count(username) > 1");
$database->execute();
$data = $database->fetch(true);
foreach ($data as $meta) {
$duplicates[] = $meta->username;
$database->statement("SELECT * FROM `ossn_users` \n\t\t\t\t\t\t\t WHERE(username='******');");
$database->execute();
$users = $database->fetch(true);
//no need to fix first username
unset($users->{0});
$increment = 0;
foreach ($users as $user) {
$databasen = $increment + 1;
$databaseusername = $user->username . '' . $databasen;
$database->statement("UPDATE `ossn_users` SET \n\t\t\t\t\t\t\t\t username='******' \n\t\t\t\t\t\t\t\t WHERE(guid='{$user->guid}');");
$database->execute();
}
unset($increment);
/**
* 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 ossn_entities 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}");
}
if ($result->subtype == 'file:profile:photo') {
$url = ossn_site_url("photos/user/view/{$notif->subject_guid}#comments-item-{$notif->item_guid}");
}
if ($result->subtype == 'file:profile:cover') {
$url = ossn_site_url("photos/cover/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 (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;
}
