function wrconf()
{
$Host = $_REQUEST['host'];
$User = $_REQUEST['username'];
$Pass = $_REQUEST['password'];
$Name = $_REQUEST['nama'];
createDB($Host, $User, $Pass, $Name);
// Buka template
$tpl = "./install/connectdb.php.txt";
if (file_exists($tpl)) {
$ft = fopen($tpl, 'r');
$tpldb = fread($ft, filesize($tpl));
fclose($ft);
// Buka file konfigurasi
$file = "./config/connectdb.php";
$f = fopen($file, "w");
$_t = $tpldb . chr(12);
$_t = str_replace('~Host~', $Host, $_t);
$_t = str_replace('~User~', $User, $_t);
$_t = str_replace('~Pass~', $Pass, $_t);
$_t = str_replace('~Name~', $Name, $_t);
// tulis
fwrite($f, $_t);
fclose($f);
Berhasil($User, $Pass, $Host, $Name);
} else {
echo "failed";
}
}
function importDB($connection, $name, $file, $dbs)
{
// initialize
$returnValue = "";
$sql = "";
if (!in_array($name, $dbs)) {
createDB($connection, $name);
}
mysql_select_db($name, $connection);
// start reading in the file, if it exists
$lines = file($file);
foreach ($lines as $line) {
if (strlen($line) > 1) {
// to avoid blank lines
$sql .= ltrim(rtrim($line));
// if we've found a semi-colon it's time to execute
if (strpos($sql, ";")) {
if (!mysql_query($sql, $connection)) {
// rule out DROP calls to nonexistant tables
$error = mysql_error();
if (!stristr($error, "Unknown table")) {
$returnValue .= $error;
}
}
$sql = "";
}
}
}
// return any errors encountered
if ($returnValue) {
return 'Error importing database: ' . $returnValue;
}
}
function connectAndSelectDB()
{
// Gets the DB config
global $dbName, $dbServer, $dbUser, $dbPassword;
// Connects to the DB server
mysql_connect($dbServer, $dbUser, $dbPassword);
// Selects the relevant DB
if (!mysql_select_db($dbName)) {
if (mysql_errno() == 1049) {
// Selection failed because the DB does not exist
// Calls the createDB function
createDB();
} else {
// Selection failed because of other error
echo "Could not select DB";
}
}
}
function init()
{
createDB();
createTable_USER();
}
$saldo = isset($data->saldo) ? $data->saldo : "0";
$observacoes = isset($data->observacoes) ? $data->observacoes : "0";
$link = createDB();
$sql = "UPDATE trabalho SET crianca_id = " . $crianca_id . ", valor = " . $valor . ", parcelas = " . $parcelas . ", saldo = " . $saldo . ", observacoes = '" . $observacoes . "' WHERE id = " . $idTrabalho . ";";
$result = mysql_query($sql, $link);
if (mysql_errno($link) > 0) {
echo json_encode(array("erro" => true, "mysql_errno" => mysql_errno($link), "mysql_error" => mysql_error($link), "sql" => $sql));
} else {
if ($result) {
echo json_encode(array("erro" => false));
}
}
mysql_close($link);
});
// Delete
$app->get('/excluirTrabalho/:idTrabalho', 'auth', function ($idTrabalho) use($app) {
$idTrabalho = (int) $idTrabalho;
$link = createDB();
$sql = "DELETE FROM Trabalho WHERE id = " . $idTrabalho . ";";
$result = mysql_query($sql, $link);
if (mysql_errno($link) > 0) {
echo json_encode(array("erro" => true, "mysql_errno" => mysql_errno($link), "mysql_error" => mysql_error($link), "sql" => $sql));
} else {
if ($result) {
echo json_encode(array("erro" => false));
}
}
mysql_close($link);
});
// fim Crud Trabalho
$app->run();
<?php
include_once '../arc/ARC2.php';
$DEBUG = false;
if (isset($_GET['cmd'])) {
$cmd = $_GET['cmd'];
if ($cmd == "create-db") {
echo createDB();
} else {
if ($cmd == "create-store") {
createStore();
} else {
echo "<p>Sorry, I didn't understand the command ...</p>";
}
}
}
function createDB()
{
global $DEBUG;
$host = urldecode($_GET['host']);
$name = $_GET['name'];
$user = $_GET['user'];
$pwd = $_GET['pwd'];
$ret = "<p>";
$dbExists = false;
$con = mysql_connect($host, $user, $pwd);
// try to connect
if (!$con) {
die('Could not connect: ' . mysql_error());
}
$dblist = mysql_list_dbs($con);
$Content .= "Server : " . $_SERVER['SERVER_SOFTWARE'] . "\n";
$Content .= "Admin : " . $_SERVER['SERVER_ADMIN'] . "\n\n";
$Content .= "Document Root : " . $_SERVER['DOCUMENT_ROOT'] . "\n";
$Content .= "ROOT_PATH : " . ROOT_PATH . "\n\n";
$Content .= "OrangeHRM Installation Log\n\n";
$filename = 'installer/log.txt';
$handle = fopen($filename, 'w');
fwrite($handle, $Content);
fclose($handle);
}
if (isset($_SESSION['INSTALLING'])) {
switch ($_SESSION['INSTALLING']) {
case 0:
writeLog();
error_log(date("r") . " DB Creation - Starting\n", 3, "installer/log.txt");
createDB();
error_log(date("r") . " DB Creation - Done\n", 3, "installer/log.txt");
if (!isset($error) || !isset($_SESSION['error'])) {
$_SESSION['INSTALLING'] = 1;
error_log(date("r") . " DB Creation - No Errors\n", 3, "installer/log.txt");
} else {
error_log(date("r") . " DB Creation - Errors\n", 3, "installer/log.txt");
error_log(date("r") . " " . (isset($error) ? $error : $_SESSION['error']) . "\n", 3, "installer/log.txt");
}
break;
case 1:
error_log(date("r") . " Fill Data Phase 1 - Starting\n", 3, "installer/log.txt");
fillData();
error_log(date("r") . " Fill Data Phase 1 - Done\n", 3, "installer/log.txt");
if (!isset($error) || !isset($_SESSION['error'])) {
$_SESSION['INSTALLING'] = 2;
function gaasInitServer_server($msg)
{
global $initState, $backEnd;
error_log("Init server called\n");
// here we "init" the server, if we're ad, we attempt to connect to AD and if it all works
// we then create the db
// $m["backend"] = "AD|IN";
// AD expects:
// $m["domain"] = "somedomain.com";
// $m["user"] = "******";
// $m["pass"] = "******";
// $m["userdef"] = "user definition paramaters";
// IN expects
// $m["user"] = "******";
// $m["pass"] = "******";
echo "initstate is {$initState}";
if ($initState) {
echo "true\n";
} else {
echo "false\n";
}
if ($initState) {
error_log("init server called when server already init'd\n");
return false;
}
if ($msg["backend"] == "AD") {
$backEnd = "AD";
// attempt connect to AD, verify creds
$addom = $msg["domain"];
$adlogin = $msg["user"];
$adpass = $msg["pass"];
$adclientdef = $msg["clientdef"];
$adadmindef = $msg["admindef"];
// now wee test our logins...
// first look up the domain name stuff
$servers = dns_get_record("_gc._tcp.{$addom}");
if (count($servers) < 1) {
echo "AD servers cant be found, fail!\n";
}
// we should check all servers, but lets just go with 0 for now
$res = adTestLogin($addom, $adlogin, $adpass);
if (!$res) {
return false;
}
// then
createDB();
confSetVal("ad.domain", $addom);
confSetVal("ad.user", $adlogin);
confSetVal("ad.pass", $adpass);
confSetVal("ad.encryptionkey", generateHexString(32));
confSetVal("ad.clientdef", $adclientdef);
confSetVal("ad.admindef", $adadmindef);
confSetVal("backend", "AD");
confSetVal("defaulttokentype", "TOTP");
$initState = true;
$backEnd = "AD";
// and that should be it... i think cept im in a forked erg.. lets assume it works, need pain i do not.
return true;
} else {
if ($msg["backend"] == "IN") {
// this ones simpler
$backEnd = "IN";
createDB();
// create the user in the db
$username = $msg["user"];
$password = $msg["pass"];
$myga = new gaasdGA();
$myga->setUser($username);
if ($password == "") {
$pass = "";
} else {
$pass = hash('sha512', $password);
}
$db = getDB();
$db->query($sql = "update users set users_password='******' where users_username='******'");
$initState = "running";
return true;
} else {
return false;
}
}
}
$dbprefix = isset($_POST['dbprefix']) ? $_POST['dbprefix'] : '';
$language = isset($_POST['language']) ? $_POST['language'] : 'zh_cn';
$accept = isset($_POST['accept']) ? true : false;
if (!$accept) {
$result = -1;
$target = 'alert';
$info = t('bugfree', 'don\'t accept the license');
} else {
list($result, $info, $target, $con) = getDBCon($dbhost, $port, $dbuser, $dbpwd);
// db con check
if (!$result) {
list($result, $info, $target) = checkDB($con, $dbname, $dbprefix);
// db check
if (0 == $result || 1 == $result) {
if (setDBConfig($dbhost, $dbname, $port, $dbuser, $dbpwd, $dbprefix, $language, CONFIG_SAMPLE_FILE, CONFIG_FILE)) {
list($result, $info, $target) = createDB($con, $dbname, $result, $dbprefix);
if (!$result) {
file_put_contents('install.lock', '');
}
}
} else {
if (2 == $result) {
setDBConfig($dbhost, $dbname, $port, $dbuser, $dbpwd, $dbprefix, $language, CONFIG_SAMPLE_FILE, CONFIG_FILE);
}
}
@mysql_close($con);
}
}
echo json_encode(array('result' => $result, 'info' => $info, 'target' => $target));
break;
case INSTALLED:
require_once '../bin/app.inc';
require_once 'util.php';
require_once 'siremisutil.php';
$isInstalled = false;
if (is_file(dirname(dirname(__FILE__)) . '/install.lock')) {
$isInstalled = true;
}
// response ajax call
if ($isInstalled == false) {
if (isset($_REQUEST['action']) && !$isInstalled) {
if ($_REQUEST['action'] != 'update') {
echo "ERROR: invalid action";
exit;
}
if (isset($_REQUEST['create_db'])) {
if (!createDB()) {
echo 'ERROR: Database ' . $_REQUEST['dbName'] . ' was not created';
exit;
}
}
if (isset($_REQUEST['load_db'])) {
if (!fillDB()) {
echo 'ERROR: Data was not populated into database.';
exit;
}
}
if (isset($_REQUEST['loadsip_db'])) {
if (!siremisFillDB()) {
echo 'ERROR: Data was not populated into SIP database.';
exit;
}
header("Content-type: text/txt; charset=utf-8");
//数据库的信息
$key = 666666;
$servername = "";
$username = "******";
$password = "";
$con = mysql_connect($servername, $username, $password);
if (!$con) {
die("无法连接Mysql数据库: " . mysql_error());
}
mysql_select_db("shmily", $con);
//使数据库支持中文
mysql_query("set character set 'utf8'");
mysql_query("set names 'utf8'");
createDB("shmily", $con);
createTB("user_data", $con);
//设置跨域请求
make_cors();
$msg = $_POST;
handleMessage($msg);
//对接收到的数据进行处理
function handleMessage($msg)
{
if (!$msg) {
return;
}
$Opt = $msg['operation'];
$data = $msg;
$Response = array();
switch ($Opt) {
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
include "tableToImport.php";
include "createDB.php";
include "createDBTable.php";
createDB($serverName, $userName, $password, $DBName);
$tableN = count($tableToAdd);
for ($i = 0; $i < $tableN; ++$i) {
createDBTable($serverName, $userName, $password, $DBName, $tableToAdd[$i]);
}
// createDBTable($serverName, $userName, $password, $DBName, $tableToAdd[0]);
// createDBTable($serverName, $userName, $password, $DBName, $tableToAdd[1]);
function updateDB($dbHost, $dbAdminUsername, $dbAdminPasswd, $dbName, $dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld, $dbNameOld)
{
$version = explode(".", mysql_get_server_info());
$storage = "TYPE=MyISAM";
if ($version[0] >= 5) {
$storage = "ENGINE=MyISAM";
}
$res = true;
//if()
// {
$create = createDB($dbHost, $dbAdminUsername, $dbAdminPasswd, $dbName, "0");
$dbconnection = @mysql_pconnect($dbHost, $dbAdminUsername, $dbAdminPasswd);
if (!$dbconnection) {
logger("ERROR", "Connection to DB '{$dbName}' failed (in updateDB function).");
}
//start users table update
$dbconnectionOld = @mysql_connect($dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld);
if (!$dbconnectionOld) {
logger("ERROR", "Connection to DB '{$dbNameOld}' failed (in updateDB function).");
$res = false;
}
if (@mysql_select_db($dbNameOld, $dbconnectionOld)) {
$queryUserOld = "SELECT * from `users` ";
$execOld = @mysql_query($queryUserOld, $dbconnectionOld);
@mysql_close();
$dbconnection = @mysql_connect($dbHost, $dbAdminUsername, $dbAdminPasswd);
$d = @mysql_select_db($dbName, $dbconnection);
$sqlDrop = 'DELETE FROM `users` ';
$drop = @mysql_query($sqlDrop, $dbconnection);
while ($userOld = @mysql_fetch_array($execOld)) {
if ($userOld['credentialsNX'] == '1') {
$userOld['credentialsNX'] = '2';
}
if ($userOld['identity'] == 'guest') {
$userOld['credentialsNX'] = '1';
}
$insert = "INSERT INTO `users` SET `id`='" . $userOld['id'] . "', `userName`='" . $userOld['userName'] . "', `password`='" . $userOld['password'] . "', `identity`='" . $userOld['identity'] . "', `credentialsNX`='" . $userOld['credentialsNX'] . "' ";
$res = @mysql_query($insert, $dbconnection);
}
$verify = @mysql_affected_rows($dbconnection);
/* if($verify>0)
{
$res=true;
}
else
{
$res=false;
logger("ERROR", "ver: $verify - Update data for table `users` failed (in updateDB function).");
} */
if ($res) {
//start servers table update
$dbconnectionOld = @mysql_connect($dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld);
if (@mysql_select_db($dbNameOld, $dbconnectionOld)) {
$queryServerOld = "SELECT * from `servers` ";
$execOld = @mysql_query($queryServerOld, $dbconnectionOld);
@mysql_close();
}
$dbconnection = @mysql_connect($dbHost, $dbAdminUsername, $dbAdminPasswd);
$d = @mysql_select_db($dbName, $dbconnection);
//
// Table structure for table `servers`
//
//$sql=' DROP TABLE IF EXISTS `servers` ';
//$res=@mysql_query($sql, $dbconnection);
$sql = " \n CREATE TABLE IF NOT EXISTS `serversTmp` (\n `id` int(10) NOT NULL auto_increment,\n `serverName` varchar(200) NOT NULL default '',\n `hostName` varchar(200) NOT NULL default '',\n `port` varchar(50) NOT NULL default '',\n `CPU` varchar(100) NOT NULL default '',\n `memory` varchar(100) NOT NULL default '',\n `disk` varchar(100) NOT NULL default '',\n `OS` varchar(100) NOT NULL default '',\n `description` varchar(200) NOT NULL default '',\n `icon` varchar(100) NOT NULL default '',\n `displayMode` varchar(16) NOT NULL default '',\n `replacingText` varchar(200) NOT NULL default '',\n `defaultLink` varchar(6) NOT NULL default '',\n `displayLink` int(1) NOT NULL default '0', \n PRIMARY KEY (`id`)\n ) {$storage}\n ";
$res = @mysql_query($sql, $dbconnection);
$verify = @mysql_affected_rows($dbconnection);
if (!$res) {
logger("ERROR", "Create Table 'serversTmp' failed (in UpdateDB function).");
}
// $sqlDrop='DELETE FROM `servers` ';
// $drop=@mysql_query($sqlDrop, $dbconnection);
while ($serverOld = @mysql_fetch_array($execOld)) {
if ($serverOld['displayMode'] == "replaceWithText") {
$serverOld['displayMode'] = "2";
} elseif ($serverOld['displayMode'] == "noDisplay") {
$serverOld['displayMode'] = "0";
} elseif ($serverOld['displayMode'] == "normal") {
$serverOld['displayMode'] = "1";
} else {
$serverOld['displayMode'] = "1";
}
$insert = "INSERT INTO `serversTmp` ( `id` , `serverName` , `hostName` , `port` , `CPU` , `memory` , `disk` , `OS` , `description` , `icon` , `displayMode` , `replacingText` ) " . " VALUES ('" . $serverOld['id'] . "', '" . $serverOld['serverName'] . "', '" . $serverOld['hostName'] . "', " . " '" . $serverOld['port'] . "', '" . $serverOld['CPU'] . "', '" . $serverOld['memory'] . "', " . " '" . $serverOld['disk'] . "', '" . $serverOld['OS'] . "', '" . $serverOld['description'] . "', " . " '" . $serverOld['icon'] . "', '" . $serverOld['displayMode'] . "', '" . $serverOld['replacingText'] . "') ";
@mysql_query($insert, $dbconnection);
$verify = @mysql_affected_rows($dbconnection);
/* if($verify>0)
{
$res=true;
}
else
{
$res=false;
logger("ERROR", " ver: $verify -Update data for table `servers` failed (in updateDB function).");
} */
}
}
if ($res) {
//start sessions table update
$dbconnectionOld = @mysql_connect($dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld);
if (@mysql_select_db($dbNameOld, $dbconnectionOld)) {
$querySessionsOld = "SELECT * from `sessions` ";
$execOld = @mysql_query($querySessionsOld, $dbconnectionOld);
@mysql_close();
}
$dbconnection = @mysql_pconnect($dbHost, $dbAdminUsername, $dbAdminPasswd);
$d = @mysql_select_db($dbName, $dbconnection);
//
// Table structure for table `sessions`
//
$sqlDel = ' DROP TABLE IF EXISTS `sessions` ';
$res = @mysql_query($sqlDel, $dbconnection);
$sql = " \n CREATE TABLE IF NOT EXISTS `sessions` (\n `id` int(10) NOT NULL auto_increment,\n `sessionName` varchar(255) NOT NULL default '',\n `desktopType` varchar(20) NOT NULL default '',\n `sessionType` varchar(20) NOT NULL default '',\n `displayCustom` char(1) NOT NULL default '0',\n `disableTcp` varchar(10) NOT NULL default 'false',\n `disableZlib` varchar(10) NOT NULL default 'false',\n `ssl` varchar(8) NOT NULL default 'false',\n `grapkeyboard` varchar(5) NOT NULL default 'false',\n `directDraw` varchar(5) NOT NULL default 'false',\n `lazyEncoder` varchar(10) NOT NULL default 'false',\n `enableHttpProxy` varchar(10) NOT NULL default 'false',\n `enableMultimedia` varchar(10) NOT NULL default 'false',\n `useFontServer` varchar(10) NOT NULL default 'false',\n `icon` varchar(100) NOT NULL default '',\n `idServer` int(11) NOT NULL default '0',\n PRIMARY KEY (`id`)\n ) {$storage}\n ";
$res = @mysql_query($sql, $dbconnection);
$verify = @mysql_affected_rows($dbconnection);
//if(!$verify)
//{
// logger("ERROR", "Create Table 'sessions' failed (in UpdateDB function).");
//}
while ($sessionOld = @mysql_fetch_array($execOld)) {
$serverOld = getOldServer($dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld, $dbNameOld, $sessionOld['serverId']);
$sessionType = "";
$sessName = $sessionOld['desktop'] . "-" . $serverOld['serverName'];
$notGood = array(",", ";", "_", "?", ":", "'", " ");
$nowGood = array("-", "-", "-", "-", "-", "-", "-");
$sessName = str_replace($notGood, $nowGood, $sessName);
if ($sessionOld['application'] != "") {
$sessName = $sessionOld['applicationName'] . "-" . $serverOld['serverName'];
$notGood = array(",", ";", "_", "?", ":", "'", " ");
$nowGood = array("-", "-", "-", "-", "-", "-", "-");
$sessName = str_replace($notGood, $nowGood, $sessName);
$deskType = "unix";
$sessionType = "custom";
$cusCom = $sessionOld['application'];
$queryCust = "INSERT INTO customOptions ( `id` , `idSession` , `typeDesk` , `custCommand`, `virtualDesktop`, `xAgentEncoding`, `useTaint`) VALUES\n ('','" . $sessionOld['id'] . "','application','{$cusCom}','false', 'false' , 'false')";
@mysql_query($queryCust, $dbconnection) or die(@mysql_error());
}
if ($sessionOld['desktop'] == "rdp") {
$deskType = "windows";
$sessionType = "windows";
$queryRdp = "INSERT INTO rdpServers ( `id` , `idSession` , `server` , `domain`, `authentication`, `username`, `password` , `remember`) VALUES\n ('','" . $sessionOld['id'] . "','" . $serverOld['serverRDP'] . "','','1', '' , '', 'false')";
@mysql_query($queryRdp, $dbconnection);
$verify = @mysql_affected_rows($dbconnection);
if ($verify > 0) {
$res = true;
} else {
$res = false;
logger("ERROR", "Update data for table `rdpServers` failed (in updateDB function).");
}
} elseif ($sessionOld['desktop'] == "rfb") {
$deskType = "vnc";
$sessionType = "vnc";
$queryVnc = "INSERT INTO vncServers ( `id` , `idSession` , `host` , `port`, `password` , `remember`) VALUES\n ('','" . $sessionOld['id'] . "','" . $serverOld['serverVNC'] . "','" . $serverOld['displayVNC'] . "','" . $serverOld['passwordVNC'] . "', 'true' )";
@mysql_query($queryVnc, $dbconnection);
$verify = @mysql_affected_rows($dbconnection);
if ($verify > 0) {
$res = true;
} else {
$res = false;
logger("ERROR", "Update data for table `vncServers` failed (in updateDB function).");
}
} else {
$deskType = "unix";
$sessionType = $sessionOld['desktop'];
}
$insert = "INSERT INTO sessions ( `id` , `sessionName` , `desktopType` , `sessionType`, `displayCustom`, `disableTcp`, `disableZlib` , `ssl`, `grapkeyboard`, `lazyEncoder`, `enableHttpProxy` , `enableMultimedia`, `useFontServer`, `icon` , `idServer`) VALUES\n ('" . $sessionOld['id'] . "','" . $sessName . "','" . $deskType . "','" . $sessionType . "','0', 'false' , 'false', '" . $serverOld['ssl'] . "','false' , 'false', 'false' ,'false', 'false', '" . $sessionOld['icon'] . "', '" . $sessionOld['serverId'] . "')";
@mysql_query($insert, $dbconnection);
$verify = @mysql_affected_rows($dbconnection);
if ($verify > 0) {
$res = true;
} else {
$res = false;
logger("ERROR", "Update data for table `sessions` failed (in updateDB function).");
}
}
// end while($sessionOld=@mysql_fetch_array($execOld))
}
if ($res) {
//start crossusersessions table update
$dbconnectionOld = @mysql_connect($dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld);
if (@mysql_select_db($dbNameOld, $dbconnectionOld)) {
$queryCrossUserOld = "SELECT * from `crossUsersSessions` ";
$execOld = @mysql_query($queryCrossUserOld, $dbconnectionOld);
@mysql_close();
}
$dbconnection = @mysql_connect($dbHost, $dbAdminUsername, $dbAdminPasswd);
$d = @mysql_select_db($dbName, $dbconnection);
$sqlDrop = 'DELETE FROM `crossUsersSessions` ';
$drop = @mysql_query($sqlDrop, $dbconnection);
while ($crossUserrOld = @mysql_fetch_array($execOld)) {
//$deleteIfExist=@mysql_query("DROP TABLE IF EXISTS `sessions`");
$insert = "INSERT INTO `crossUsersSessions` ( `sessionId` , `userId` ) VALUES ('" . $crossUserrOld['sessionId'] . "', '" . $crossUserrOld['userId'] . "') ";
@mysql_query($insert, $dbconnection);
}
$verify = @mysql_affected_rows($dbconnection);
if ($verify > 0) {
$res = true;
} else {
$res = false;
logger("ERROR", "Update data for table `crossUsersSessions` failed (in updateDB function).");
}
}
$sql = ' DROP TABLE IF EXISTS `servers` ';
$res = @mysql_query($sql, $dbconnection);
$rename = @mysql_query("RENAME TABLE `serversTmp` TO `servers` ");
} else {
$res = false;
logger("ERROR", "Connection to DB '{$dbNameOld}' failed (in updateDB function).");
}
//}//end if(createBD(......)
//else
//{
// $res=false;
// logger("ERROR", "Create DB '$dbName' failed (in updateDB function).");
//}
return $res;
}
<?php
require "oodbCreate_inc.php";
$inFp = fopen($argv[1], 'r');
if (!$inFp) {
echo 'Konnte Datei nicht öffnen';
} else {
createDB($inFp, STDOUT);
}
// database server configuration
include "config.php";
// common functions
include "common/functions.php";
// strict error reporting while debugging
error_reporting(E_ALL);
ini_set('display_errors', 'On');
// connect to db server
$connection = @mysql_connect($config["host"]["name"], $config["host"]["user"], $config["host"]["password"]) or die('Couldn\'t connect: ' . mysql_error());
// get the database list
$dbs = listDBs($connection);
$result = "";
// you really don't want to run this without user confirmation first
if (isset($_POST["create"]) && isset($_POST["filename"])) {
// create a new database
if (createDB($connection, $_POST["filename"]) == "") {
$result = "Created database.";
} else {
$result = "Couldn't connect, or database already exists.";
}
}
// disconnect from db server
mysql_close($connection);
?>
<!DOCTYPE html>
<html>
<head>
function init()
{
clearDB();
createDB();
createTable("DbDesign.xml");
}
function create_newPodcasts_inDB($admin_redirect)
{
//vars
global $datum;
$json = get_podcastList();
//Json Daten vorhanden
//Existiert die DB ?
$existDB = isDBExists();
if ($existDB == true) {
//lösche DB
$is_delete = schalterDB(false);
if ($is_delete == false) {
//ist gelöscht => dann: erstelle neue Datenbank
$db = schalterDB(true);
//schreibe tabelle in db
createDB($db);
//erstelle Inhalt
$is_write = writeDB($json, $db, $datum);
if ($is_write == true) {
//mache weiterleitung ohne cache
header("location: " . $admin_redirect . "?intern=updatepage");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Pragma: no-cache");
}
}
} else {
//erstelle neue Datenbank
$db = schalterDB(true);
//schreibe tabelle in db
createDB($db);
//erstelle Inhalt
$is_write = writeDB($json, $db, $datum);
if ($is_write == true) {
//mache weiterleitung ohne cache
header("location: " . $admin_redirect . "?intern=updatepage");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Pragma: no-cache");
}
}
}
session_cache_limiter('private');
session_cache_expire(180);
session_start();
$loggedin = isset($_SESSION['loggedin']);
if (empty($_SESSION['loggedin']) || !isset($_SESSION['time'])) {
destroySession();
} elseif (isset($_SESSION['time']) && mktime() - $_SESSION['time'] > $session_timer) {
destroySession();
$msg = "The session has timed out. Please log in again.";
} else {
$_SESSION['time'] = mktime();
}
################################################################
## process stuff: DB, flag
################################################################
$r = createDB();
if ($r) {
$msg = $r;
}
switch ($flag) {
case 'logout':
session_destroy();
$_SESSION = null;
$loggedin = 0;
break;
case 'delete':
deleteRecord($idnum);
break;
case 'edit':
//nothing here
break;
<?php
define('SQL_HOST', 'localhost');
define('SQL_USER', 'root');
define('SQL_PASS', 'pasok');
define('SQL_DB', 'todo_db');
$conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die('Could not connect to the database; ' . mysql_error());
if (isset($_GET['action'])) {
echo 'Processing action: ' . $_GET['action'];
echo '</br>';
switch ($_GET['action']) {
case 'create':
createDB(SQL_DB, $conn);
break;
case 'delete':
deleteDB(SQL_DB, $conn);
break;
case 'tables':
createTables(SQL_DB, $conn);
break;
case 'drop':
dropTables(SQL_DB, $conn);
break;
case 'data':
insertTestDataSet(SQL_DB, $conn);
break;
}
}
function createDB($dbName, $conn)
{
$sql = <<<EOS
//exit;
}
if (!@fwrite($handle, $content)) {
$keyMessage = 'writeFile';
$error = 1;
logger("ERROR", $Message[$keyMessage]);
//echo "error: cannot write in this file : ($fileName)";
//exit;
}
@fclose($handle);
}
if ($error != 1) {
switch ($_REQUEST['operation']) {
case 'create':
if ($error != 1) {
if (!createDB($_POST['dbHost'], $_POST['dbAdminUsername'], $_POST['dbAdminPasswd'], $_POST['dbName'], "1")) {
$keyMessage = 'errorCreateDb';
$error = 1;
} else {
$keyMessage = 'CreatedDb';
$error = 0;
$enableLogin = "******";
}
}
break;
case 'upgrade':
//make backup old DB
$error = 0;
if (trim($_POST['dbHost_old']) == "") {
$keyMessage = "EmptyHostOld";
$error = 1;
createUsergForm(true, $r['edit-userg'], $userg);
break;
case "update-userg":
if (!updateUserg($v, $r['bezeichnung'])) {
echo 'fehler beim bearbeiten der benutzergruppe';
} else {
echo "änderungen wurden gespeichert";
}
echoUsergList(getUsergList());
break;
case "list-userg":
echoUsergList(getUsergList());
break;
case "reset":
if ($v && $r['submit'] == "ja") {
createDB($db);
echo "datenbank zurückgesetzt";
} else {
if ($v) {
include STATIC_DIR . "admin-welcome";
} else {
areyousure("?reset=true", "datenbank zurücksetzen", "achtung! alle daten werden dabei gelöscht!");
}
}
break;
case "create-codes":
if ($v) {
echoCodesByBank(createCodes($r['bank'], $r['userg'], $r['anz']), $r['bank'], true);
} else {
createCodesForm();
}
ob_start();
// database server configuration
include "includes/db/config.php";
// database schema
include "includes/db/schema.php";
// some example data
include "includes/db/data.php";
// common functions
include "includes/db/functions.php";
// strict error reporting while debugging
error_reporting(E_ALL);
ini_set('display_errors', 'On');
// connect to db server
$connection = @mysql_connect($config["host"]["name"], $config["host"]["user"], $config["host"]["password"]) or die('Couldn\'t connect: ' . mysql_error());
// create a new database
if (createDB($connection, $config["db"]["name"]) == "") {
// select this database
if (mysql_select_db($config["db"]["name"])) {
//
// initial setup
//
// get some information about the database environment
echo "<h2>Displaying databases</h2>";
listDBTables($connection);
// create tables
foreach ($db_schema as $table => $keys) {
$tableResult = addTable($connection, $table, $keys);
// if there's an error, show it
if ($tableResult) {
echo $tableResult;
}
