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($table)
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($table,$columnName)
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.EditAction()
Action:
EditAction()
ShowNewEntry($table)
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($table)
Action:
AddPrimaryKey($table,$col)
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:
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: