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 append to $m_sContent
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
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 {
$m_sContent .= qq(
#requestURI( url,id,txt )
<a href="javascript:requestURI('$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: