setLink($conn); if (!$this->getLink()){ return false; } $res = mysqli_select_db($this->getLink(), DB); if (!$res){ // Data Base Not configured echo "You have to configure the DataBase"; return false; } return true; } function getLink(){ return $this->_conn; } function setLink($conn){ $this->_conn = $conn; } function import() { $db = (isset($_GET["database"]) ? $_GET["database"] : "information_schema"); $db = mysqli_real_escape_string($this->getLink(), $db); $xml = ""; $arr = array(); @ $datatypes = file("../../db/mysql/datatypes.xml"); $arr[] = $datatypes[0]; $arr[] = ''; for ($i=1;$igetLink(), "SELECT * FROM TABLES WHERE TABLE_SCHEMA = '".$db."'"); while ($row = mysqli_fetch_array($result)) { $table = $row["TABLE_NAME"]; $xml .= ''; $comment = (isset($row["TABLE_COMMENT"]) ? $row["TABLE_COMMENT"] : ""); if ($comment) { $xml .= ''.htmlspecialchars($comment).''; } $q = "SELECT * FROM COLUMNS WHERE TABLE_NAME = '".$table."' AND TABLE_SCHEMA = '".$db."'"; $result2 = mysqli_query($this->getLink(), $q); while ($row = mysqli_fetch_array($result2)) { $name = $row["COLUMN_NAME"]; $type = $row["COLUMN_TYPE"]; $comment = (isset($row["COLUMN_COMMENT"]) ? $row["COLUMN_COMMENT"] : ""); $null = ($row["IS_NULLABLE"] == "YES" ? "1" : "0"); if (preg_match("/binary/i",$row["COLUMN_TYPE"])) { $def = bin2hex($row["COLUMN_DEFAULT"]); } else { $def = $row["COLUMN_DEFAULT"]; } $ai = (preg_match("/auto_increment/i",$row["EXTRA"]) ? "1" : "0"); if ($def == "NULL") { $def = ""; } $xml .= ''; $xml .= ''.strtoupper($type).''; $xml .= ''.$def.''; if ($comment) { $xml .= ''.htmlspecialchars($comment).''; } /* fk constraints */ $q = "SELECT REFERENCED_TABLE_NAME AS 'table', REFERENCED_COLUMN_NAME AS 'column' FROM KEY_COLUMN_USAGE k LEFT JOIN TABLE_CONSTRAINTS c ON k.CONSTRAINT_NAME = c.CONSTRAINT_NAME WHERE CONSTRAINT_TYPE = 'FOREIGN KEY' AND c.TABLE_SCHEMA = '".$db."' AND c.TABLE_NAME = '".$table."' AND k.COLUMN_NAME = '".$name."'"; $result3 = mysqli_query($this->getLink(), $q); while ($row = mysqli_fetch_array($result3)) { $xml .= ''; } $xml .= ''; } /* keys */ $q = "SELECT * FROM STATISTICS WHERE TABLE_NAME = '".$table."' AND TABLE_SCHEMA = '".$db."' ORDER BY SEQ_IN_INDEX ASC"; $result2 =mysqli_query($this->getLink(),$q); $idx = array(); while ($row = mysqli_fetch_array($result2)) { $name = $row["INDEX_NAME"]; if (array_key_exists($name, $idx)) { $obj = $idx[$name]; } else { $type = $row["INDEX_TYPE"]; $t = "INDEX"; if ($type == "FULLTEXT") { $t = $type; } if ($row["NON_UNIQUE"] == "0") { $t = "UNIQUE"; } if ($name == "PRIMARY") { $t = "PRIMARY"; } $obj = array( "columns" => array(), "type" => $t ); } $obj["columns"][] = $row["COLUMN_NAME"]; $idx[$name] = $obj; } foreach ($idx as $name=>$obj) { $xml .= ''; for ($i=0;$i'; } $xml .= ''; } $xml .= ""; } $arr[] = $xml; $arr[] = ''; return implode("\n",$arr); } } $a = (isset($_GET["action"]) ? $_GET["action"] : false); switch ($a) { case "list": setup_saveloadlist(); $DBHandler = new mysqlDB(); if (!$DBHandler->connect()) { header("HTTP/1.0 503 Service Unavailable"); break; } $result = mysqli_query($DBHandler->getLink(), "SELECT keyword FROM ".TABLE." ORDER BY dt DESC"); while ($row = mysqli_fetch_assoc($result)) { echo $row["keyword"]."\n"; } break; case "save": setup_saveloadlist(); $DBHandler = new mysqlDB(); if (!$DBHandler->connect()) { header("HTTP/1.0 503 Service Unavailable"); break; } $keyword = (isset($_GET["keyword"]) ? $_GET["keyword"] : ""); $keyword = mysqli_real_escape_string($DBHandler->getLink(), $keyword); $data = file_get_contents("php://input"); if (get_magic_quotes_gpc() || get_magic_quotes_runtime()) { $data = stripslashes($data); } $data = mysqli_real_escape_string($DBHandler->getLink(), $data); $r = mysqli_query($DBHandler->getLink(), "SELECT * FROM ".TABLE." WHERE keyword = '".$keyword."'"); if (mysqli_num_rows($r) > 0) { $res = mysqli_query($DBHandler->getLink(), "UPDATE ".TABLE." SET data = '".$data."' WHERE keyword = '".$keyword."'"); } else { $res = mysqli_query($DBHandler->getLink(), "INSERT INTO ".TABLE." (keyword, data) VALUES ('".$keyword."', '".$data."')"); } if (!$res) { header("HTTP/1.0 500 Internal Server Error"); } else { header("HTTP/1.0 201 Created"); } break; case "load": setup_saveloadlist(); $DBHandler = new mysqlDB(); if (!$DBHandler->connect()) { header("HTTP/1.0 503 Service Unavailable"); break; } $keyword = (isset($_GET["keyword"]) ? $_GET["keyword"] : ""); $keyword = mysqli_real_escape_string($DBHandler->getLink(), $keyword); $result = mysqli_query($DBHandler->getLink(), "SELECT `data` FROM ".TABLE." WHERE keyword = '".$keyword."'"); $row = mysqli_fetch_assoc($result); if (!$row) { header("HTTP/1.0 404 Not Found"); } else { header("Content-type: text/xml"); echo $row["data"]; } break; case "import": setup_import(); $DBHandler = new mysqlDB(); if (!$DBHandler->connect()) { header("HTTP/1.0 503 Service Unavailable"); break; } header("Content-type: text/xml"); echo $DBHandler->import(); break; default: header("HTTP/1.0 501 Not Implemented"); } /* list: 501/200 load: 501/200/404 save: 501/201 import: 501/200 */ ?>