/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public static function displaySettingsIndex() { $settingGroup = Request::input('settingGroup'); if ($settingGroup == null) { $settingGroup = 'general_msd'; } $settingGroups = SettingController::getSettingGroups(); $fetchSettings = SettingController::fetchSettings($settingGroup); $params = array('settingGroups' => $settingGroups, 'chosenGroup' => $settingGroup, 'settings' => $fetchSettings); return ViewController::show('settings.index', 'MySQLDumper Settings', $params, 'settings'); }
/** * Display the specified resource. * * @param string $dbName * @param string $tableName * @return \Illuminate\Http\Response */ public static function viewTable($dbName, $tableName, $page = 1, $perPage = 30) { $tableInfo = DB::select("SELECT TABLE_ROWS, DATA_LENGTH, INDEX_LENGTH FROM information_schema.TABLES WHERE TABLE_SCHEMA = :dbName AND TABLE_NAME = :tableName", ['dbName' => $dbName, 'tableName' => $tableName]); $tableRows = $tableInfo[0]->TABLE_ROWS; $tableSize = DBController::byteConversion($tableInfo[0]->DATA_LENGTH + $tableInfo[0]->INDEX_LENGTH); $tableData = DB::select("SELECT * FROM `" . $dbName . "`.`" . $tableName . "` LIMIT 0,30"); $tableView = ''; for ($i = 0; $i < count($tableData); $i++) { if ($i % 2) { $alt = ''; } else { $alt = '_alt'; } $params = array(); $tableView .= ViewController::build('columns.row', $params); } $tableColumns = DBController::getColumnsForTable($dbName, $tableName); $params = array('dbName' => $dbName, 'tableName' => $tableName, 'tableColumns' => $tableColumns, 'tableRows' => $tableRows, 'tableSize' => $tableSize, 'tableData' => $tableData); return ViewController::show('columns.index', 'Columns in `' . $dbName . '`.`' . $tableName . '`', $params, $dbName); }
public static function getAuthLogin() { $params = array(); return ViewController::show('auth.login', 'MySQLDumper Login', $params, '', false); }
public static function conduitUpdate($id) { $getConduit = DB::table('conduit_api')->where('id', '=', $id)->first(); $curlParams = array('apiPublic' => $getConduit->api_public_key, 'apiPrivate' => $getConduit->api_private_key); $curlParamString = ''; foreach ($curlParams as $key => $value) { $curlParamString .= $key . '=' . $value . '&'; } $conduit = APIController::conduitSend($getConduit->url_to_api_file, count($curlParams), $curlParamString); if ($conduit->output !== 'CONDUIT_CONNECTED') { if ($conduit->output === 'INVALID_PUB_OR_PRI') { echo 'Incorrect API keys provided for Conduit'; } else { echo 'Unknown error occurred, Conduit may be inaccessible'; } exit; } $performUpdate = $curlParamString . 'do=conduitUpdate'; $conduit = APIController::conduitSend($getConduit->url_to_api_file, 4, $performUpdate); $params = array('id' => $getConduit->id, 'conduitUri' => $getConduit->url_to_api_file); if ($conduit->output === 'CONDUIT_UPDATE_NOT_REQUIRED') { $params['updateOutput'] = 'Conduit is already up to date.'; } else { if ($conduit->output === 'CONDUIT_UPDATE_ERROR') { $params['updateOutput'] = 'Conduit failed to update - may not be able to write files.'; } else { if ($conduit->output === 'CONDUIT_UPDATE_SUCCESS') { $params['updateOutput'] = 'Conduit update successful.'; } else { $params['updateOutput'] = 'Unknown error occurred: ' . $conduit->output; } } } return ViewController::show('conduit.update', 'Conduit@' . $getConduit->url_to_api_file, $params, 'conduit'); }