/** * 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>'; }
/** * Delete group relations if user is deleted * * @param (object) $group Group Entity * * @return bool */ function ossn_delete_group_relations($group) { if ($group) { $delete = new OssnDatabase(); $params['from'] = 'ossn_relationships'; //delete group member requests if group deleted $params['wheres'] = array("relation_from='{$group->guid}' AND type='group:join:approve' OR", "relation_to='{$group->guid}' AND type='group:join'"); if ($delete->delete($params)) { return true; } } return false; }
function ossn_disable_cache() { $database = new OssnDatabase(); $params['table'] = 'siteayarlari'; $params['names'] = array('value'); $params['values'] = array(0); $params['wheres'] = array("setting_id='4'"); if ($database->update($params)) { OssnFile::DeleteDir(ossn_route()->cache); return true; } return false; }
/** * Delete component * * @return boolean */ public function delete($com) { if (in_array($com, $this->requiredComponents())) { return false; } $component = $this->getbyName($com); if (!$component) { return false; } $params = array(); $params['from'] = "ossn_components"; $params['wheres'] = array("com_id='{$com}'"); if (parent::delete($params)) { //Delete component settings upon its deletion #538 $entities = new OssnEntities(); $entities->deleteByOwnerGuid($component->id, 'component'); //delete component directory OssnFile::DeleteDir(ossn_route()->com . "{$com}/"); return true; } return false; }
/** * Delete component * * @return boolean */ public function delete($com) { if (in_array($com, $this->requiredComponents())) { return false; } $params = array(); $params['from'] = "ossn_components"; $params['wheres'] = array("com_id='{$com}'"); if (parent::delete($params)) { OssnFile::DeleteDir(ossn_route()->com . "{$com}/"); return true; } return false; }
/** * Update processed upgrades * * @param integer $upgrade New release * * @return boolean */ function ossn_update_upgraded_files($upgrade) { if (empty($upgrade)) { return false; } $database = new OssnDatabase(); $upgrade_json = array_merge(ossn_get_upgraded_files(), array($upgrade)); $upgrade_json = json_encode($upgrade_json); $update = array(); $update['table'] = 'ossn_site_settings'; $update['names'] = array('value'); $update['values'] = array($upgrade_json); $update['wheres'] = array("name='upgrades'"); if ($database->update($update)) { return true; } else { return false; } }
<?php /** * Open Source Social Network * * @package (Informatikon.com).ossn * @author OSSN Core Team <*****@*****.**> * @copyright 2014 iNFORMATIKON TECHNOLOGIES * @license General Public Licence http://www.opensource-socialnetwork.org/licence * @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')");
<?php $database = new OssnDatabase(); /** * Check if the upgrades settings exist or not * * @access private */ $fetch['from'] = 'siteayarlari'; $fetch['wheres'] = array("name='upgrades'"); $upgrade_settings = $database->select($fetch); /** * If settings didn't exist then create settings * * @access private */ if (empty($upgrade_settings->setting_id)) { $insert['into'] = 'siteayarlari'; $insert['names'] = array('name', 'value'); $insert['values'] = array('upgrades', ''); $database->insert($insert); } /** * Fixed the relationship table type from int to varchat * * @access private */ $database->statement("ALTER TABLE `arkadasliklar`\n CHANGE `type` `type` VARCHAR( 20 ) \n\t\t\t\t\t CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;"); $database->execute(); /** * Fix character settings for settings table
<?php /** * Open Source Social Network * * @package (Informatikon.com).ossn * @author OSSN Core Team <*****@*****.**> * @copyright 2014 iNFORMATIKON TECHNOLOGIES * @license General Public Licence http://www.opensource-socialnetwork.org/licence * @link http://www.opensource-socialnetwork.org/licence */ $settings = new OssnDatabase(); $sitename = input('sitename'); $owneremail = input('owneremail'); $sitelang = input('sitelang'); $notification_email = input('notification_email'); $errors = input('errors'); if (empty($sitename) || empty($owneremail) || empty($sitelang) || empty($errors)) { redirect(REF); } ossn_site_setting_update('site_name', $sitename, 2); ossn_site_setting_update('lang', $sitelang, 3); ossn_site_setting_update('owner_email', $owneremail, 5); ossn_site_setting_update('notification_email', $notification_email, 6); //update errors settings $update['table'] = 'ossn_site_settings'; $update['names'] = array('value'); $update['values'] = array($errors); $update['wheres'] = array("name='display_errors'"); $settings->update($update); ossn_trigger_message(ossn_print('settings:saved'), 'success');
<?php /** * OpenSource-SocialNetwork * * @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;
<?php /** * Open Source Social Network * * @package (Informatikon.com).ossn * @author OSSN Core Team <*****@*****.**> * @copyright 2014 iNFORMATIKON TECHNOLOGIES * @license General Public Licence http://www.opensource-socialnetwork.org/licence * @link http://www.opensource-socialnetwork.org/licence */ $component = new OssnComponents(); $database = new OssnDatabase(); /** * Add OssnPoke Component * * @access private */ $component->newCom('OssnPoke'); /** * Delete invalid notification from system (group like) * * @access private */ $delete['from'] = 'ossn_notifications'; $delete['wheres'] = array("type='like:post:group:wall'"); $database->delete($delete); /** * Update processed updates in database so user cannot upgrade again and again. * * @access private
<?php /** * Open Source Social Network * * @package (Informatikon.com).ossn * @author OSSN Core Team <*****@*****.**> * @copyright 2014 iNFORMATIKON TECHNOLOGIES * @license General Public Licence http://www.opensource-socialnetwork.org/licence * @link http://www.opensource-socialnetwork.org/licence */ $database = new OssnDatabase(); //regenerate .htaccess file ossn_generate_server_config('apache'); /** * Update processed updates in database so user cannot upgrade again and again. * * can we make this script short? */ $upgrade_json = array_merge(ossn_get_upgraded_files(), array($upgrade)); $upgrade_json = json_encode($upgrade_json); $update = array(); $update['table'] = 'ossn_site_settings'; $update['names'] = array('value'); $update['values'] = array($upgrade_json); $update['wheres'] = array("name='upgrades'"); $upgrade = str_replace('.php', '', $upgrade); if ($database->update($update) && ossn_update_db_version('3.2')) { ossn_trigger_message(ossn_print('upgrade:success', array($upgrade)), 'success'); } else { ossn_trigger_message(ossn_print('upgrade:failed', array($upgrade)), 'error');
<?php /** * OpenSource-SocialNetwork * * @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(); $Component = new OssnComponents(); /** * Fix typo in database table */ $database->statement("ALTER TABLE `ossn_entities` \n\t\t\t\t\t CHANGE `premission` `permission` INT( 1 ) NOT NULL ;"); $database->execute(); /** * Change component name size */ $database->statement("ALTER TABLE `ossn_components` \n\t\t\t\t\t CHANGE `com_id` `com_id` TEXT CHARACTER SET utf8 \n\t\t\t\t\t COLLATE utf8_general_ci NOT NULL ;"); $database->execute(); /** * Add OssnEmbed and OssnInvite Component */ $Component->ENABLE('OssnEmbed'); $Component->ENABLE('OssnInvite'); /** * Update processed updates in database so user cannot upgrade again and again. *
<?php /** * Open Source Social Network * * @package (Informatikon.com).ossn * @author OSSN Core Team <*****@*****.**> * @copyright 2014 iNFORMATIKON TECHNOLOGIES * @license General Public Licence http://www.opensource-socialnetwork.org/licence * @link http://www.opensource-socialnetwork.org/licence */ $component = new OssnComponents(); $database = new OssnDatabase(); /** * Add OssnChat Component * * @access private */ $component->ENABLE('OssnChat'); /** * Update processed updates in database so user cannot upgrade again and again. * * @access private */ $upgrade_json = array_merge(ossn_get_upgraded_files(), array($upgrade)); $upgrade_json = json_encode($upgrade_json); $update['table'] = 'ossn_site_settings'; $update['names'] = array('value'); $update['values'] = array($upgrade_json); $update['wheres'] = array("name='upgrades'"); $upgrade = str_replace('.php', '', $upgrade);
<?php /** * Open Source Social Network * * @package (Informatikon.com).ossn * @author OSSN Core Team <*****@*****.**> * @copyright 2014 iNFORMATIKON TECHNOLOGIES * @license General Public Licence http://www.opensource-socialnetwork.org/licence * @link http://www.opensource-socialnetwork.org/licence */ $database = new OssnDatabase(); /** * Check if the site errors settings exists or not * * @access private */ $fetch['from'] = 'ossn_site_settings'; $fetch['wheres'] = array("name='display_errors'"); $siterror_settings = $database->select($fetch); /** * If settings didn't exist then create settings * * @access private */ if (empty($siterror_settings->setting_id)) { $insert['into'] = 'ossn_site_settings'; $insert['names'] = array('name', 'value'); $insert['values'] = array('display_errors', 'off'); $database->insert($insert); }
/** * 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; }
<?php /** * Open Source Social Network * * @package (Informatikon.com).ossn * @author OSSN Core Team <*****@*****.**> * @copyright 2014 iNFORMATIKON TECHNOLOGIES * @license General Public Licence http://www.opensource-socialnetwork.org/licence * @link http://www.opensource-socialnetwork.org/licence */ $database = new OssnDatabase(); /** * Check if the upgrades settings exist or not * * @access private */ $fetch['from'] = 'ossn_site_settings'; $fetch['wheres'] = array("name='upgrades'"); $upgrade_settings = $database->select($fetch); /** * If settings didn't exist then create settings * * @access private */ if (empty($upgrade_settings->setting_id)) { $insert['into'] = 'ossn_site_settings'; $insert['names'] = array('name', 'value'); $insert['values'] = array('upgrades', ''); $database->insert($insert); }
ossn_trigger_message(ossn_print('fields:require'), 'error'); redirect(REF); } } } $password = input('password'); $types = array('normal', 'admin'); if (!in_array($user['type'], $types)) { ossn_trigger_message(ossn_print('account:create:error:admin'), 'error'); redirect(REF); } $user['birthdate'] = "{$user['bdd']}/{$user['bdm']}/{$user['bdy']}"; $OssnUser = new OssnUser(); $OssnUser->password = $password; $OssnUser->email = $user['email']; $OssnDatabase = new OssnDatabase(); $params['table'] = 'ossn_users'; $params['wheres'] = array("guid='{$entity->guid}'"); $params['names'] = array('first_name', 'last_name', 'email', 'type'); $params['values'] = array($user['firstname'], $user['lastname'], $user['email'], $user['type']); //check if email is not in user if ($entity->email !== input('email')) { if ($OssnUser->isOssnEmail()) { ossn_trigger_message(ossn_print('email:inuse'), 'error'); redirect(REF); } } //check if email is valid email if (!$OssnUser->isEmail()) { ossn_trigger_message(ossn_print('email:invalid'), 'error'); redirect(REF);
/** * 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; }