DBI::Library::Database - Database interface for MySQL::Admin::GUI
use DBI::Library::Database;
constructor
$name = $m_oDatabase->getName($m_sSid);
$m_sSidid = $m_oDatabase->setSid(name,pass);
$bool = $m_oDatabase->checkSession($m_sUser,$m_sSid);
$hashref = $m_oDatabase->getAction($m_sAction);
$right = $m_oDatabase->getActionRight($m_sAction);
$nRight = right($m_sAction,$m_sUsername);
userright(user);
topicright(id);
catright('name|name2');
isMember($m_sUser);
checkt ob es den user bereits gibt.
hasAcount($email)
checkt ob es die email Adresse bereits gibt.
$m_oDatabase->addUser(user, pass);
set serverName.
set floodtime.
checked wann die letzte aktion der ip adresse war und erlaubt sie nur wenn midestens time zeit zur letzen aktion vergangen ist.
checkFlood(ip,optionaler abstand in sekunden )
checkFlood(remote_addr());
GetAutoIncrementValue(table)
liefert die primary_key(s) der tabelle zurueck @array = GetPrimaryKey(table)
liefert die auto_increment zeile zurueck GetAutoIncrement(table)
Gibt eine auswahl liste der Datenabanken zurueck
GetTables(name,selected )
Gibt die anzahl der tabellen fuer die angegebene Datenbank zurueck.
gibt das Charset zu coalation zurueck. GetCharacterSet(coalation);
gibt die verfuegbaren Engines zurueck. GetEngines(tabelle);
GetEngineForRow(tabelle, zeile);
gibt die NULL(NULL | not NULL) auswahlliste zurueck GetNull(selected extra, slect_name);
gibt die extra(auto_increment) auswahlliste zurueck GetExtra(selected extra, slect_name);
gibt die datentypen zurueck GetTypes(selected type, slect_name);
gibt eine auswahlliste (select) zurueck. GetColumnCollation( tabelle ,columne, name_select);
$sel = GetCollation(name);
$sel = GetCharset(name,table);
$sel = GetAttrs($tbl, $field, $m_hUniqueAttrs );
$sel = GetColumns($tbl ,$name,$selected);
see HTML::Menu::TreeView::getSelf
MySQL::Admin::GUI DBI DBI::Library " =head1 AUTHOR
Dirk Lindner <lze@cpan.org>
Copyright (C) 2005-2009 by Hr. Dirk Lindner
This program is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.
To install MySQL::Admin, copy and paste the appropriate command in to your terminal.
cpanm
cpanm MySQL::Admin
CPAN shell
perl -MCPAN -e shell install MySQL::Admin
For more information on module installation, please visit the detailed CPAN module installation guide.