Example #1
0
 /**
  * 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');
 }
Example #2
0
 /**
  * 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);
 }
Example #3
0
 public static function getAuthLogin()
 {
     $params = array();
     return ViewController::show('auth.login', 'MySQLDumper Login', $params, '', false);
 }
Example #4
0
 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');
 }
Example #5
0
|
*/
Route::get('/auth/login', function () {
    return ViewController::getAuthLogin();
});
// Authentication routes...
Route::post('auth/login', 'Auth\\AuthController@postLogin');
Route::get('auth/logout', 'Auth\\AuthController@getLogout');
Route::group(['middleware' => 'auth'], function () {
    // root
    Route::get('/', function () {
        return ViewController::getHomepage();
    });
    // query server
    Route::get('/query', function () {
        return ViewController::getQueryPage();
    });
    // conduit
    Route::get('/conduit', function () {
        return APIController::index();
    });
    Route::group(['prefix' => 'conduit'], function () {
        // conduit index
        Route::get('generate', function () {
            return APIController::generateAPIFile();
        });
        // conduit generator
        Route::post('conjure', function () {
            return APIController::conjureConduit();
        });
        // conduit connection