/**
* 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;
}
/**
* 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;
}
* @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')");
$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));
$database->execute();
/**
* Fix lenght of time_created
*
* @access private
*/
$database->statement("ALTER TABLE `ossn_notifications` \n CHANGE `time_created` `time_created` INT( 11 ) NOT NULL ;");
$database->execute();
/**
* Delete wrong relationships
*
* @access private
*/
$delete['from'] = 'ossn_relationships';
$delete['wheres'] = array("type='0'");
$database->delete($delete);
/**
* 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);
if ($database->update($update)) {
ossn_trigger_message(ossn_print('upgrade:success', array($upgrade)), 'success');
} else {
