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 = 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
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.
