styleguide

Action: means the sub is called from GUI.pm via do('tables.pl'); eval('sub()');

Sometimes it is possible that parameters will be used instead of param('table') values.

For example SaveNewTable() calls ShowNewTable( 'table', 'column count' ).

again if CREATE TABLE failed.

ShowNewTable(table, count)

Action:

Shows a form to create a new table.

SaveNewTable()

Action: Dont call direct.

ShowDumpTable

Action:

DumpTable

Action: table will be print

in void context param( 'table' ) will be used.

ShowDumpDatabase

Action

Export the Database.

DumpDatabase( $database )

In void context $m_sCurrentDb db will be used.

HighlightSQl()

$formated_string = HighlightSQl();

todo: HighlightSQl as html and link to mysql documentation.

getLink()

searchHelpTopic

HelpTopics

action

action=HelpTopics

AddFulltext($table,$columnName)

Action:

In void context param('table') and param('column') will be used.

DropFulltext

Action: In void context param('table') and param('column') will be used.

AddIndex($table,$indexName)

Action: In void context param('table') and param('column') will be used.

DropIndex($table,$indexName)

Action:

In void context param('table') and param('column') will be used.

AddUnique( $table, $indexName )

Action: In void context param('table') and param('column') will be used.

DropUnique($table,$indexName)

Action: In void context param('table') and param('column') will be used.

ExecSql($sql,$boolShowSQL)

this is the 'main' sub to excute sql within this system.

If you write your own sub write something like this:

sub foo {

  print qq(

  #requestURI( url,id,txt )

  <a href="javascript:requestURI('$m_hrSettings->{cgi}{serverName}$ENV{SCRIPT_NAME}?action=bar&foo=true','bar','bar');">bar</a>);

}

sub bar{

  ExecSql('select * from bar') if param('foo');
  

}

SQL()

Action: Excute SQL with the "SQL Editor".

ShowTable($table)

Action:

Call this to show the table overview.

MultipleAction

Action:Multiple Table Actions.

MultipleDbAction

Action: Multiple Database Actions

EditEntry()

Action:

     EditEntry( $table, $id )
     
     In void context param('table') and param('edit') will be used.

SaveUpload

Action: SaveUpload

downLoadFile

action: downLoadFile ( col, table, param)

ShowNewEntry

Action: In void context param ( 'table' ) will be used.

SaveEntry

Action:

NewEntry

Action:

DeleteEntry

Action: In void context param('table') will ne used.

round

private

ShowTables

Action:

DropTable

Action:

ShowTableDetails

Action:

AddPrimaryKey

action:

DropCol($table,$column)

Action:

TruncateTable($table)

Action:

EditTable($table)

Action:

ShowEditIndex()

Action:

SaveNewIndex()

Action:

SaveEditTable()

Action:

SaveNewColumn()

Action:

RenameTable($table,$newtable)

Action:

ChangeEngine($table,$engine)

Action:

ChangeAutoInCrementValue($table,$autoInCrement)

Action:

ShowDbHeader()

create the Table Menu and CreateDatabase CreateUser CreateTable ChangeCurrentDb SqlEditor SqlSearch forms.

_insertTables()

Action:

AnalyzeTable( $table )

Action:

RepairTable($table)

Action:

OptimizeTable( $table )

Action:

ShowUsers()

Action:

ShowRights()

Action:

initRights($user,$host)

the rights for $m_hUserRights will be initialized

HasRight()

private

GetTables()

  return a <select><option>...</option></select> with the Tables from the current DB. 

GetDatabases()

  returns a <select><option>...</option></select>  with the Databases
  
  GetDatabases(name, selected Databases)

GetUsers()

  (select) GetUsers(name, selected)

SaveRights()

Action:

CreateUser()

Action;

DeleteUser()

Action:

ShowDatabases()

Action:

DropDatabase( databaseName )

Action:

CreateDatabase( databaseName )

Action:

ShowProcesslist()

Action:

killProzess()

Action:

ShowVariables()

Action:

ChangeCharset()

Action:

searchForm()

Action:

searchDatabase()

Action:

showProfile()

Action:

saveProfile

Action:

GetTypes

  return the data types

  GetTypes( selected type, select_name, table, field , \$hrSet );

renameDatabase()

Action:

cpanm MySQL::Admin

perl -MCPAN -e shell
install MySQL::Admin