DBI::Library::Database - Database interface for MySQL::Admin::GUI
use DBI::Library::Database;
my %message = ( thread => $thread, title => $headline, body => $body, thread => $thread, cat => $cat, attach => $sra, format => $format, id => $id, user => $m_sUser, attach => $m_sFilename, ip => remote_addr(), ); my $id = addMessage(\%message);
my %message = ( thread => $thread, title => $headline, body => $body, thread => $thread, cat => $cat, attach => $sra, format => $format, id => $id, user => $m_sUser, attach => $m_sFilename, ip => remote_addr(), ); editMessage(\%message);
my %reply =( title => $headline, body => $body, id => $reply, user => $m_sUser, attach => $sra, format => $html, ip => remote_addr(), ); reply(\%reply);
$bool = $self->deleteMessage($table,$id);
@menu = $m_oDatabase->readMenu($sThread,$nRight,$nStart,$nEnd,$bRewrite);
$rss = $m_oDatabase->rss($thread,int start);
$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);
enable or disable rewrite.
set serverName.
set floodtime.
searchDB($query,$column,$table,$rigt,$start,$end);
regexp search in tabelle ...
@messages = fulltext(query,table);
fulltextsuche in tabelle ...
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 = GetAttrs($tbl, $field, $m_hUniqueAttrs );
$sel = GetColumns($tbl ,$name,$selected);
see HTML::Menu::TreeView::getSelf
MySQL::Admin::GUI DBI DBI::Library
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.