/**
* Make changes to the database.
*
* @return void
*/
public function up()
{
Schema::create('keys', function ($table) {
$table->increments('id');
$table->string('name');
$table->string('api_key');
$table->timestamps();
});
$key = new Key();
$key->name = "default";
$key->api_key = Config::get('solder.platform_key');
$key->save();
}
public function action_do_create()
{
$rules = array('name' => 'required|unique:keys', 'api_key' => 'required|unique:keys');
$validation = Validator::make(Input::all(), $rules);
if ($validation->fails()) {
return Redirect::back()->with_errors($validation->errors);
}
$key = new Key();
$key->name = Input::get('name');
$key->api_key = Input::get('api_key');
$key->save();
return Redirect::to('key/list')->with('success', 'API key added!');
}
public function upload()
{
$s3 = \Aws\S3\S3Client::factory(array('key' => 'AKIAIUCV4E2L4HDCDOUA', 'secret' => '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', 'region' => 'us-east-1'));
$key = new Key();
if (Input::file('key') != null) {
exec('openssl rsa -noout -in ' . Input::file('key')->getRealPath(), $cli_output, $cli_exec_result_success);
// lmao why is this logic reversed? and it works?
if (!$cli_exec_result_success) {
$s3->putObject(array('Bucket' => App::isLocal() ? 'devkeys.nosprawl.software' : 'keys.nosprawl.software', 'Key' => Input::file('key')->getClientOriginalName(), 'SourceFile' => Input::file('key')->getRealPath()));
$key->remote_url = Input::file('key')->getClientOriginalName();
} else {
return Redirect::to('integrations')->withMessage("Key not added. Please upload a valid PEM file.");
}
}
$key->integration_id = Input::get('integration_id');
$key->username = Input::get('username');
$key->password = Input::get('password');
if ($key->save()) {
return Redirect::to('integrations')->withMessage("Credentials added.");
} else {
return Redirect::to('integrations')->withMessage("Key not added.");
}
}
public function apiKeysAction()
{
$user = $this->_helper->db->findById();
$keyTable = $this->_helper->db->getTable('Key');
$this->view->user = $user;
$this->view->currentUser = $this->getCurrentUser();
$this->view->keys = $keyTable->findBy(array('user_id' => $user->id));
if ($this->getRequest()->isPost()) {
// Create a new API key.
if ($this->getParam('api_key_label')) {
$key = new Key();
$key->user_id = $user->id;
$key->label = $this->getParam('api_key_label');
$key->key = sha1($user->username . microtime() . rand());
$key->save();
$this->_helper->flashMessenger(__('A new API key was successfully created.'), 'success');
}
// Rescend API keys.
if ($this->getParam('api_key_rescind')) {
foreach ($this->getParam('api_key_rescind') as $keyId) {
$keyTable->find($keyId)->delete();
}
$this->_helper->flashMessenger(__('An existing API key was successfully rescinded.'), 'success');
}
$this->_helper->redirector->gotoRoute();
}
}
/**
* Saves a key for the form
* @author Matthew McNaney <mcnaney at gmail dot com>
*/
function saveKey()
{
if (empty($this->_key_id)) {
$key = new Key();
$key->setModule('phatform');
$key->setItemName('form');
$key->setItemId($this->_id);
$key->setEditPermission('edit_forms');
$key->setUrl('index.php?module=phatform&PHAT_MAN_OP=view&PHPWS_MAN_ITEMS[]=' . $this->_id);
} else {
$key = new Key($this->_key_id);
}
if ($this->_anonymous) {
$key->restricted = 0;
} else {
$key->restricted = 1;
}
$key->setTitle($this->_label);
$key->setSummary($this->_blurb0);
$key->save();
$this->_key_id = $key->id;
return $key;
}
public function saveKey()
{
if (empty($this->key_id)) {
$key = new Key();
$key->module = $key->item_name = 'block';
$key->item_id = $this->id;
} else {
$key = new Key($this->key_id);
}
$key->edit_permission = 'edit_block';
$key->title = $this->title;
$result = $key->save();
if (PHPWS_Error::isError($result)) {
return $result;
}
if (empty($this->key_id)) {
$this->key_id = $key->id;
$this->save(FALSE);
}
}
public function saveKey()
{
if (empty($this->key_id)) {
$key = new Key();
} else {
$key = new Key($this->key_id);
if (PHPWS_Error::isError($key->_error)) {
$key = new Key();
}
}
$key->setModule('signup');
$key->setItemName('sheet');
$key->setItemId($this->id);
$key->setEditPermission('edit_sheet');
if (MOD_REWRITE_ENABLED) {
$key->setUrl('signup/sheet_id/' . $this->id);
} else {
$key->setUrl('index.php?module=signup&sheet_id=' . $this->id);
}
$key->setTitle($this->title);
$result = $key->save();
if (PHPWS_Error::logIfError($result)) {
return false;
}
if (!$this->key_id) {
$this->key_id = $key->id;
$db = new PHPWS_DB('signup_sheet');
$db->addWhere('id', $this->id);
$db->addValue('key_id', $this->key_id);
PHPWS_Error::logIfError($db->update());
}
return true;
}
public function delete($permanent = false)
{
$db = new PHPWS_DB('ps_page');
$db->addWhere('id', $this->id);
if ($permanent) {
$result = $db->delete();
if (PHPWS_Error::logIfError($result)) {
return false;
}
Key::drop($this->key_id);
$db = new PHPWS_DB('ps_text');
$db->addWhere('pid', $this->id);
$result = $db->delete();
$db = new PHPWS_DB('ps_block');
$db->addWhere('pid', $this->id);
$db->delete();
} else {
$db->addValue('deleted', 1);
$db->addValue('last_updated', time());
$result = $db->update();
if (PHPWS_Error::logIfError($result)) {
return false;
}
$key = new \Key($this->key_id);
$key->active = 0;
$key->save();
$key->unregister();
}
$this->removeShortcuts();
if ($this->parent_page) {
$db = new PHPWS_DB('ps_page');
$db->addWhere('parent_page', $this->parent_page);
$db->addWhere('page_order', $this->page_order, '>');
PHPWS_Error::logIfError($db->reduceColumn('page_order'));
}
return true;
}
public function saveKey($new_folder = true)
{
if (empty($this->key_id)) {
$key = new Key();
} else {
$key = new Key($this->key_id);
if (PHPWS_Error::isError($key->getError())) {
$key = new Key();
}
}
$key->setModule('filecabinet');
$key->setItemName('folder');
$key->setItemId($this->id);
$key->setEditPermission('edit_folders');
$key->setUrl($this->viewLink(false));
$key->setTitle($this->title);
$key->setSummary($this->description);
$result = $key->save();
if (PHPWS_Error::isError($result)) {
return $result;
}
$this->key_id = $key->id;
if ($new_folder) {
$db = new PHPWS_DB('folders');
$db->addWhere('id', $this->id);
$db->addValue('key_id', $this->key_id);
$result = $db->update();
if (PHPWS_Error::isError($result)) {
return $result;
}
}
return true;
}
function saveKey()
{
if (empty($this->key_id)) {
$key = new Key();
$key->module = 'wiki';
$key->item_name = 'page';
$key->item_id = $this->getId();
$key->edit_permission = 'edit_page';
} else {
$key = new Key($this->key_id);
}
$key->title = $this->getTitle();
$key->url = (MOD_REWRITE_ENABLED ? 'wiki/' : 'index.php?module=wiki&page=') . $this->getTitle(FALSE);
$result = $key->save();
if (PEAR::isError($result)) {
return $result;
}
if (empty($this->key_id)) {
$this->key_id = $key->id;
$this->save(FALSE);
}
}
public function saveKey()
{
if (empty($this->key_id)) {
$key = new Key();
} else {
$key = new Key($this->key_id);
if (PHPWS_Error::isError($key->_error)) {
$key = new Key();
}
}
$key->setModule('pagesmith');
$key->setItemId($this->id);
$key->setEditPermission('edit_page');
$key->setUrl($this->url());
foreach ($this->_sections as $sec) {
if ($sec->sectype == 'text') {
$key->setSummary($sec->getContent());
break;
}
}
$key->setTitle($this->title);
$result = $key->save();
if (PHPWS_Error::logIfError($result)) {
return false;
}
if (!$this->key_id) {
$this->key_id = $key->id;
$db = new PHPWS_DB('ps_page');
$db->addWhere('id', $this->id);
$db->addValue('key_id', $this->key_id);
PHPWS_Error::logIfError($db->update());
} elseif ($this->_title_change) {
PHPWS_Core::initModClass('menu', 'Menu.php');
Menu::updateKeyLink($this->key_id);
}
$this->_key = $key;
return true;
}
public function saveKey()
{
if (empty($this->key_id)) {
$key = new Key();
$key->module = $key->item_name = 'menu';
$key->item_id = $this->id;
} else {
$key = new Key($this->key_id);
}
$key->title = $this->title;
$result = $key->save();
if (PHPWS_Error::isError($result)) {
return $result;
}
if (empty($this->key_id)) {
$this->key_id = $key->id;
$this->save(false);
}
}
public function saveKey()
{
if (empty($this->key_id)) {
$key = new Key();
} else {
$key = new Key($this->key_id);
if (PHPWS_Error::isError($key->getError())) {
$key = new Key();
}
}
$key->setModule('calendar');
$key->setItemName('schedule');
$key->setItemId($this->id);
if ($this->public) {
$key->restricted = 0;
$key->setEditPermission('edit_public');
} else {
$key->restricted = 2;
$key->setEditPermission('edit_private');
}
$key->setUrl($this->getViewLink(false));
$key->setTitle($this->title);
$key->setSummary($this->summary);
$result = $key->save();
$this->key_id = $key->id;
return $result;
}
public function saveKey()
{
if (empty($this->key_id)) {
$key = new Key();
} else {
$key = new Key($this->key_id);
if (PHPWS_Error::isError($key->getError())) {
$key = new Key();
}
}
$key->setModule('calendar');
$key->setItemName('event' . $this->_schedule->id);
$key->setItemId($this->id);
$key->setUrl($this->getViewLink());
$key->setTitle($this->summary);
if (!empty($this->description)) {
$key->setSummary($this->description);
}
$result = $key->save();
if (PHPWS_Error::isError($result)) {
return $result;
}
$this->key_id = $key->id;
return $key;
}
public function saveKey()
{
if (empty($this->key_id)) {
$key = new Key();
} else {
$key = new Key($this->key_id);
if (PHPWS_Error::isError($key->getError())) {
$key = new Key();
}
}
$key->setModule('blog');
$key->setItemName('entry');
$key->setItemId($this->id);
$key->setEditPermission('edit_blog');
$key->setUrl($this->getViewLink(true));
$key->setTitle($this->title);
$key->setShowAfter($this->publish_date);
$key->setHideAfter($this->expire_date);
if (!empty($this->summary)) {
$key->setSummary($this->summary);
} else {
$key->setSummary($this->entry);
}
$key->save();
$this->key_id = $key->id;
return $key;
}