styleguide
Action: means the sub is called from GUI.pm via do('tables.pl'); eval('sub()');
sometimes it is possible that there also parameters used instead of param('table') values.
For example SaveNewTable() call ShowNewTable( 'table', 'column count' )
again if CREATE TABLE failed.
ShowNewTable($tbl,$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()
Auswahliste (select) wird zurueck gegeben
GetTables(name)
todo nach Database.pm verschiebenGetDatabases()
Auswahliste (select) wird zurueck gegeben
GetDatabases(name)
todo nach Database.pm verschiebenGetUsers()
Auswahliste (select) wird zurueck gegeben
GetUsers(name)
todo nach Database.pm verschiebenSaveRights()
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, slect_name);renameDatabase()
Action: