/** * 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; }