/**
* @param Database $db
*
* @return Database
*/
public function fillDatabase($db)
{
if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
$db->reportWarnings = false;
$db->query('CREATE TABLE ducks (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
name VARCHAR(10) NOT NULL
)');
$db->reportWarnings = true;
} else {
$db->query('CREATE TABLE ducks (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
name TEXT(10) NOT NULL
)');
}
$query = $db->prepare('INSERT INTO ducks (name) VALUES (?)');
$query->execute(array('Kwik'));
$query->execute(array('Kwek'));
$query->execute(array('Kwak'));
}
/**
* removes a user from the dbms and revokes all privileges
*
* @param string $username
* @param string $host
*/
public function deleteUser($username = null, $host = null)
{
if (Database::getAttribute(PDO::ATTR_SERVER_VERSION) < '5.0.2') {
// Revoke privileges (only required for MySQL 4.1.2 - 5.0.1)
$stmt = Database::prepare("REVOKE ALL PRIVILEGES ON * . * FROM `" . $username . "`@`" . $host . "`");
Database::pexecute($stmt);
}
// as of MySQL 5.0.2 this also revokes privileges. (requires MySQL 4.1.2+)
$stmt = Database::prepare("DROP USER :username@:host");
Database::pexecute($stmt, array("username" => $username, "host" => $host));
}
/**
* Get column and relation information from the database.
*
* @private
*
* @param Database $db
* @param string $prefix Table prefix
*
* @return array
*/
public function getSchema($db, $prefix = '')
{
$driver = $db->getAttribute(PDO::ATTR_DRIVER_NAME);
if ($driver == 'mysql') {
return $this->getSchemaMySql($db, $prefix);
} elseif ($driver == 'sqlite') {
return $this->getSchemaSqlite($db, $prefix);
} else {
warning('PDO driver: "' . $driver . '" not supported');
return false;
}
}
$id = intval($_POST['id']);
} elseif (isset($_GET['id'])) {
$id = intval($_GET['id']);
}
if ($page == 'overview') {
$log->logAction(ADM_ACTION, LOG_NOTICE, "viewed admin_index");
$overview_stmt = Database::prepare("SELECT COUNT(*) AS `number_customers`,\n\t\t\t\tSUM(`diskspace_used`) AS `diskspace_used`,\n\t\t\t\tSUM(`mysqls_used`) AS `mysqls_used`,\n\t\t\t\tSUM(`emails_used`) AS `emails_used`,\n\t\t\t\tSUM(`email_accounts_used`) AS `email_accounts_used`,\n\t\t\t\tSUM(`email_forwarders_used`) AS `email_forwarders_used`,\n\t\t\t\tSUM(`email_quota_used`) AS `email_quota_used`,\n\t\t\t\tSUM(`ftps_used`) AS `ftps_used`,\n\t\t\t\tSUM(`tickets_used`) AS `tickets_used`,\n\t\t\t\tSUM(`subdomains_used`) AS `subdomains_used`,\n\t\t\t\tSUM(`traffic_used`) AS `traffic_used`\n\t\t\t\tFROM `" . TABLE_PANEL_CUSTOMERS . "`" . ($userinfo['customers_see_all'] ? '' : " WHERE `adminid` = :adminid "));
$overview = Database::pexecute_first($overview_stmt, array('adminid' => $userinfo['adminid']));
$dec_places = Settings::Get('panel.decimal_places');
$overview['traffic_used'] = round($overview['traffic_used'] / (1024 * 1024), $dec_places);
$overview['diskspace_used'] = round($overview['diskspace_used'] / 1024, $dec_places);
$number_domains_stmt = Database::prepare("\n\t\tSELECT COUNT(*) AS `number_domains` FROM `" . TABLE_PANEL_DOMAINS . "`\n\t\tWHERE `parentdomainid`='0'" . ($userinfo['customers_see_all'] ? '' : " AND `adminid` = :adminid"));
$number_domains = Database::pexecute_first($number_domains_stmt, array('adminid' => $userinfo['adminid']));
$overview['number_domains'] = $number_domains['number_domains'];
$phpversion = phpversion();
$mysqlserverversion = Database::getAttribute(PDO::ATTR_SERVER_VERSION);
$webserverinterface = strtoupper(@php_sapi_name());
if (isset($_GET['lookfornewversion']) && $_GET['lookfornewversion'] == 'yes' || isset($lookfornewversion) && $lookfornewversion == 'yes') {
$update_check_uri = 'http://version.froxlor.org/Froxlor/legacy/' . $version;
if (ini_get('allow_url_fopen')) {
$latestversion = @file($update_check_uri);
if (isset($latestversion[0])) {
$latestversion = explode('|', $latestversion[0]);
if (is_array($latestversion) && count($latestversion) >= 1) {
$_version = $latestversion[0];
$_message = isset($latestversion[1]) ? $latestversion[1] : '';
$_link = isset($latestversion[2]) ? $latestversion[2] : htmlspecialchars($filename . '?s=' . urlencode($s) . '&page=' . urlencode($page) . '&lookfornewversion=yes');
// add the branding so debian guys are not gettings confused
// about their version-number
$lookfornewversion_lable = $_version . $branding;
$lookfornewversion_link = $_link;
