/**
* Ossn Add Relations
*
* @params $from => relation from guid
* $to => relation to guid
* $type => relation type
* @param string $type
*
* @return bool
*/
function ossn_add_relation($from, $to, $type)
{
if ($from > 0 && $to > 0 && !empty($type) && $type !== 0) {
$add = new OssnDatabase();
$params['into'] = 'ossn_relationships';
$params['names'] = array('relation_from', 'relation_to', 'type', 'time');
$params['values'] = array($from, $to, $type, time());
if ($add->insert($params)) {
return true;
}
}
return false;
}
*
* @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);
}
/**
* Fixed the relationship table type from int to varchat
*
* @access private
*/
$database->statement("ALTER TABLE `ossn_relationships`\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
*
* @access private
*/
$database->statement("ALTER TABLE `ossn_site_settings` \n DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;");
$database->execute();
