function get_inff_dir($dirpath)
{
$rarr = null;
// массив , необходимые индексы для которого и выясеняет данная функция читая их из файла
$str = "";
// строка в которую будет помещаться имя каждого тэга считанного из текстового файла
if ($rarr = scandir($dirpath)) {
array_flip($rarr);
foreach ($rarr as $key => $value) {
$rarr[$key] = array("dfg" => "fds");
}
$isinfo = FALSE;
}
$fdata = open_file($path, "r");
while (!feof($fdata)) {
$simb = fgetc($fdata);
// читаем файл посимвольно.
if ($simb != "\r" && $simb != "\n") {
$str = $str . $simb;
} else {
if ($simb == "\r") {
$rarr[$str] = null;
$str = "";
}
}
}
return $rarr;
}
function add_txt($file, $name, $uid, $textassoc = null, $start = 0, $end = 0)
{
// open the file
$filestr = open_file($file);
// =========== GENERALIZE THIS PLZ =======================================
// arrayify the text into canonical array form
$acanon = str_to_array($filestr, "[^a-zA-Z0-9_\\s]");
// get the hash of the text
$hash = count_words($acanon);
// get counts of uniques, hapax, ...
$counts = get_counts($hash);
// get a unique text hash to be used as location data
$thash = file_id($uid, $name, $filestr);
// must build aarray to send to db add function
$data['name'] = $name;
$data['words'] = $hash;
$data['user'] = $uid;
$data['counts'] = $counts;
$data['start'] = $start;
$data['end'] = $end ? $end : $counts['total'] - 1;
$data['assoc'] = $textassoc;
$data['canon'] = $filestr;
$data['hash'] = $thash;
// call the add function in MODQUERY and retrive the text_id
$tid = add_text_to_db($data);
return $tid;
}
public function notify()
{
$data['post'] = $_POST;
$data['get'] = $_GET;
$data['env'] = $_ENV;
$data['requst'] = $_REQUEST;
open_file($data, 'wxpay');
}
function tfile_to_str($path)
{
$str = "";
$fdata = open_file($path, "r");
while (!feof($fdata)) {
$simb = fgetc($fdata);
// read file charecter by character
$str = $str . $simb;
}
// по окончании этого цикла в переменной $str мы размещаем всё содержимое файла метаинформации.
return $str;
}
public function getScanStation()
{
include "functions.php";
include "../../../config/config.php";
$data = open_file("/usr/share/fruitywifi/logs/dhcp.leases");
$out = explode("\n", $data);
$leases = [];
for ($i = 0; $i < count($out); $i++) {
$temp = explode(" ", $out[$i]);
$leases[$temp[1]] = array($temp[2], $temp[3]);
}
unset($out);
unset($data);
$exec = "iw dev {$io_in_iface} station dump | sed -e 's/^\\t/|/g' | tr '\\n' ' ' | sed -e 's/Sta/\\nSta/g' | tr '\\t' ' '";
$out = exec_fruitywifi($exec);
$output = [];
for ($i = 0; $i < count($out); $i++) {
$station = [];
$temp = explode("|", $out[$i]);
if ($temp[0] != "") {
foreach ($temp as &$value) {
unset($sub);
if (strpos($value, 'Station ') !== false) {
$value = str_replace("Station ", "", $value);
$value = explode(" ", $value);
$mac = $value[0];
$value = "station: " . $value[0];
$key_mac = $value[0];
}
$sub = explode(": ", $value);
//$station[] = $sub;
//$station[] = array($sub[0] => $sub[1]);
$station[$sub[0]] = $sub[1];
}
if (array_key_exists($mac, $leases)) {
//$station[] = array("ip" => $leases[$mac][0]);
//$station[] = array("hostname" => $leases[$mac][1]);
$station["ip"] = $leases[$mac][0];
$station["hostname"] = $leases[$mac][1];
} else {
//$station[] = array("ip" => "");
//$station[] = array("hostname" => "");
$station["ip"] = "";
$station["hostname"] = "";
}
//$output[] = $station;
$output[] = $station;
}
}
echo json_encode($output);
}
function index($datapath, $dbpath)
{
// Create or open the database we're going to be writing to.
$db = new XapianWritableDatabase($dbpath, Xapian::DB_CREATE_OR_OPEN);
// Set up a TermGenerator that we'll use in indexing
$termgenerator = new XapianTermGenerator();
$termgenerator->set_stemmer(new XapianStem('en'));
// open the file
$fH = open_file($datapath);
// Read the header row in
$headers = get_csv_headers($fH);
while (($row = parse_csv_row($fH, $headers)) !== false) {
// mapping from field name to value using first row headers
// We're just going to use id_NUMBER, TITLE and DESCRIPTION
$description = $row['DESCRIPTION'];
$title = $row['TITLE'];
$identifier = $row['id_NUMBER'];
$collection = $row['COLLECTION'];
$maker = $row['MAKER'];
// we make a document and tell the term generator to use this
$doc = new XapianDocument();
$termgenerator->set_document($doc);
// index each field with a suitable prefix
$termgenerator->index_text($title, 1, 'S');
$termgenerator->index_text($description, 1, 'XD');
// index fields without prefixes for general search
$termgenerator->index_text($title);
$termgenerator->increase_termpos();
$termgenerator->index_text($description);
### Start of new indexing code.
// index the MATERIALS field, splitting on semicolons
$materials = explode(";", $row['MATERIALS']);
foreach ($materials as $material) {
$material = strtolower(trim($material));
if ($material != '') {
$doc->add_boolean_term('XM' . $material);
}
}
### End of new indexing code.
// store all the fields for display purposes
$doc->set_data(json_encode($row));
// we use the identifier to ensure each object ends up
// in the database only once no matter how many times
// we run the indexer
$idterm = "Q" . $identifier;
$doc->add_term($idterm);
$db->replace_document($idterm, $doc);
}
}
public function scanRecon()
{
//include "functions.php";
$exec = "python scan-recon.py -i mon0 ";
//$out = exec_fruitywifi($exec);
$data = open_file("/usr/share/fruitywifi/logs/wifirecon.log");
$out = explode("\n", $data);
$output = [];
for ($i = 0; $i < count($out); $i++) {
$ap = [];
$temp = explode(",", $out[$i]);
//if ($temp[0] != "")
//{
foreach ($temp as &$value) {
$ap[] = $value;
}
$output[] = $ap;
//}
}
echo json_encode($output);
}
function index($datapath, $dbpath)
{
// Create or open the database we're going to be writing to.
$db = new XapianWritableDatabase($dbpath, Xapian::DB_CREATE_OR_OPEN);
// Set up a TermGenerator that we'll use in indexing.
$termgenerator = new XapianTermGenerator();
$termgenerator->set_stemmer(new XapianStem('english'));
// Open the file.
$fH = open_file($datapath);
// Read the header row in.
$headers = get_csv_headers($fH);
while (($row = parse_csv_row($fH, $headers)) !== false) {
// '$row' maps field name to value. The field names come from the
// first row of the CSV file.
//
// We're just going to use DESCRIPTION, TITLE and id_NUMBER.
$description = $row['DESCRIPTION'];
$title = $row['TITLE'];
$identifier = $row['id_NUMBER'];
// We make a document and tell the term generator to use this.
$doc = new XapianDocument();
$termgenerator->set_document($doc);
// Index each field with a suitable prefix.
$termgenerator->index_text($title, 1, 'S');
$termgenerator->index_text($description, 1, 'XD');
// Index fields without prefixes for general search.
$termgenerator->index_text($title);
$termgenerator->increase_termpos();
$termgenerator->index_text($description);
// Store all the fields for display purposes.
$doc->set_data(json_encode($row));
// We use the identifier to ensure each object ends up in the
// database only once no matter how many times we run the
// indexer.
$idterm = "Q" . $identifier;
$doc->add_boolean_term($idterm);
$db->replace_document($idterm, $doc);
}
}
$tab_directive = $dom->get_elements_by_tagname('directive');
foreach ($tab_directive as $lign) {
if ($lign->get_attribute('id') == $dir_id) {
$directive = $lign;
}
}
$parent = $directive->parent_node();
$parent->remove_child($directive);
$dom->dump_file($file);
release_file($file);
echo "<html><body onload=\"window.open('../index.php','main')\"></body></html>";
} elseif ($query == "add_directive") {
$cat_id = $_GET['id'];
$category = get_category_by_id($cat_id);
$XML_FILE = "/etc/ossim/server/" . $category->xml_file;
$dom = open_file($XML_FILE);
$id = new_directive_id($category->id);
$null = NULL;
$node = $dom->create_element('directive');
$node->set_attribute('id', $id);
$node->set_attribute('name', "New directive");
$node->set_attribute('priority', "0");
$directive = new Directive($id, "New directive", "0", $null, $node);
$_SESSION['directive'] = serialize($directive);
release_file($XML_FILE);
echo "<html><body onload=\"window.open('../right.php?directive=" . $id . "&level=1&action=edit_dir&id=" . $id . "','right')\"></body></html>";
} elseif ($query == "save_category") {
$file = '/etc/ossim/server/categories.xml';
if (!($dom = domxml_open_file($file, DOMXML_LOAD_SUBSTITUTE_ENTITIES))) {
echo _("Error while parsing the document") . "\n";
exit;
}
$continue = check_server();
if ($continue === true) {
print_log("Server OK");
$continue = record_count();
if ($continue === true) {
print_log("Record count {$total_count}");
$continue = open_file();
if ($continue === true) {
print_log("Output file {$current_outfile}");
while ($this_count <= $total_count && $continue === true) {
print_log('start:' . $this_count . ' get:' . $get_count . ' wait:' . $wait_time);
if ($record_count >= $file_split && $file_split > 0) {
$chunk_count++;
close_file();
open_file();
print_log("Output chunk file {$current_outfile}");
$record_count = 0;
}
$start_time = time();
$continue = get_records();
$this_count += $get_count;
$end_time = time();
$time_dif = $end_time - $start_time;
if ($time_dif >= $wait_min && $time_dif <= $wait_max) {
$wait_time = $time_dif;
$wait_time += $wait_add;
if ($get_count < $get_max) {
$get_count += $get_add;
}
}
}
// 4. checks if file was uploaded and uploads file
if (count($_FILES) > 0 && $_FILES['file1']['error'] == 0) {
//4a. checks if uploaded file is text
if ($_FILES['file1']['type'] == 'text/plain') {
//4b. if file is text type
// Set the destination directory for uploads
$upload_dir = '/vagrant/sites/todo.dev/public/uploads/';
// Grab the filename from the uploaded file by using basename
$filename_up = basename($_FILES['file1']['name']);
// Create the saved filename using the file's original name and our upload directory
$saved_filename = $upload_dir . $filename_up;
// Move the file from the temp location to our uploads directory
move_uploaded_file($_FILES['file1']['tmp_name'], $saved_filename);
//4c. merges uploaded file with existing file
$string_to_add = open_file($saved_filename);
$array_to_add = explode("\n", $string_to_add);
$list_array = array_merge($list_array, $array_to_add);
} else {
echo "File type must be TXT";
echo '<script type="text/javascript">alert("type must be txt"); </script>';
}
}
//6. converts array to string for saving to file
$contents = implode("\n", $list_array);
save_file($filename, $contents);
?>
<html>
<head>
<title>My HTML todo list</title>
<?php
require 'person_class.php';
require 'overwrite_file_function.php';
require 'open_file_function.php';
$people = array(new student("Mark", "Weiser", 21, 120.65), new student("Alice", "Karl", 20, 200.122), new employee("Jony", "White", 25, 12.522), new student("Ida", "Red", 22, 40.98), new employee("June", "Greed", 18, 70));
overwrite_file();
$arrlength = count($people);
for ($x = 0; $x < $arrlength; $x++) {
$text = $people[$x]->get_title() . ", " . $people[$x]->get_name() . ", " . $people[$x]->get_surname() . ", " . $people[$x]->get_age() . ", " . $people[$x]->get_balance() . "\n";
open_file($text);
}
echo "<pre>";
echo file_get_contents("data.txt");
echo "<pre>";
function extract_data($short)
{
$xml_str = open_file($short);
$reader = new XMLReader();
if (!$reader->open($xml_str)) {
die("Failed to open First Folio");
}
$mei = array();
$num_items = 0;
$pid = 1;
$act = 0;
$scene = 0;
$line = 0;
$play = '';
$person = array();
$id = $name = '';
$pers = '';
$sex = '';
$role = '';
while ($reader->read()) {
if ($reader->nodeType == XMLReader::ELEMENT && $reader->name == 'person') {
$id = $reader->getAttribute('xml:id');
$sex = $reader->getAttribute('sex');
$role = $reader->getAttribute('role');
$pid++;
}
if ($reader->nodeType == XMLReader::ELEMENT && $reader->name == 'persName') {
if ($reader->getAttribute('type') == "standard") {
$pers = $reader->readString();
}
}
if ($id) {
$person[$id] = array('xmlid' => $id, 'name' => $pers, 'snid' => $pid, 'sex' => $sex, 'role' => $role);
}
// parse the play sections
if ($reader->nodeType == XMLReader::ELEMENT && $reader->name == 'div') {
$divtype = $reader->getAttribute('type');
if ($divtype == 'act') {
$act = $reader->getAttribute('n');
array_push($mei, struct($act, $scene, $divtype, 10 + $act, '', '', ''));
}
if ($divtype == 'scene') {
$scene = $reader->getAttribute('n');
array_push($mei, struct($act, $scene, $divtype, 50 + $scene, '', '', ''));
}
}
if ($reader->nodeType == XMLReader::ELEMENT && $reader->name == 'sp') {
$speaker = substr($reader->getAttribute('who'), 1);
}
if ($reader->nodeType == XMLReader::ELEMENT && ($reader->name == 'l' || $reader->name == 'p')) {
$play = 60 + $person[$speaker]['snid'];
$rhyme = $reader->getAttribute('rhyme');
$ln = $reader->getAttribute('n');
if ($play > 60) {
array_push($mei, struct($act, $scene, $reader->name, $play, $speaker, $rhyme, $ln));
}
}
// get the types of stage direction
if ($reader->nodeType == XMLReader::ELEMENT && $reader->name == 'stage') {
$type = $reader->getAttribute('type');
if ($type == 'entrance') {
array_push($mei, struct($act, $scene, $reader->name, 101, '', '', ''));
} else {
if ($type == 'exit') {
array_push($mei, struct($act, $scene, $reader->name, 102, '', '', ''));
} else {
if ($type == 'setting') {
array_push($mei, struct($act, $scene, $reader->name, 103, '', '', ''));
} else {
if ($type == 'business') {
array_push($mei, struct($act, $scene, $reader->name, 104, '', '', ''));
} else {
array_push($mei, struct($act, $scene, $reader->name, 105, '', '', ''));
}
}
}
}
}
}
$reader->close();
return $person;
}
<!-- OUTPUT -->
<div id="result-1">
<div>
<form id="formLogs-Refresh" name="formLogs-Refresh" method="POST" autocomplete="off" action="index.php">
<input type="submit" value="refresh">
<br><br>
<?php
if ($logfile != "" and $action == "view") {
$filename = $mod_logs_history . $logfile . ".log";
} else {
$filename = $mod_logs;
}
$data = open_file($filename);
// REVERSE
$data_array = explode("\n", $data);
$data = implode("\n", array_reverse($data_array));
?>
<textarea id="output" class="module-content" style="font-family: courier;"><?php
echo htmlspecialchars($data);
?>
</textarea>
<input type="hidden" name="type" value="logs">
</form>
</div>
</div>
}
if ($r_act == "eval") {
echo "<td alling=\"center\"><input type=radio checked name=\"r_act\" value=\"eval\"><b>Eval</b></td>";
} else {
echo "<td alling=\"center\"><input type=radio name=\"r_act\" value=\"eval\"><b>Eval</b></td>";
}
echo "<td><input type=submit name=\"b_act\" value=\"Change\"></td></tr></table></form>";
################## ACTION ######################################################
if ($r_act == "nav" or $r_act == NULL) {
$box = $_POST['box'];
if ($_POST['b_save']) {
$res = save_file($_POST['text'], $_POST['fname'], $_POST['dname']);
} elseif ($_POST['b_new_file']) {
open_file($_POST['new'], "wb", $_POST['dname']);
} elseif ($_POST['b_open_file']) {
open_file($_POST['fname'], "r", $_POST['dname']);
} elseif ($_POST['b_mail']) {
$res = "Function under construction!!!!!!!!!";
} elseif ($_POST['b_run']) {
chdir($_POST['wdir']);
$dir = getcwd();
$res = ex($_POST['cmd']);
} elseif ($_POST['b_f_file']) {
chdir($_POST['wdir']);
$dir = getcwd();
$res = ex("whereis " . $_POST['ffile']);
} elseif ($_POST['b_upload']) {
$s = "Uploading file " . $_POST['lfilename'] . " use the " . $box;
$res = up_file($_POST['lfilename'], $_POST['tfilename'], $_POST['box']);
} elseif ($_POST['b_mydb']) {
//Выводим список БД
$cssPath = '../../../template/css/';
$css = base64_decode(getValue("css","str","GET","fdsfds.fsd"));
$action = getValue("action","str","POST","");
$content = getValue("content","str","POST","");
$filename = $cssPath . $css;
if(file_exists($filename)){
if($action == 'save'){
$filename = str_replace(".bak","",$filename);
if(!file_exists($filename . ".bak")){
@copy($filename,$filename . ".bak");
chmod($filename . ".bak",777);
}
write_file($filename,htmlspecialchars($content));
redirect("editcss.php");
}
$content = open_file($filename);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<?php
echo $load_header;
?>
</head>
<body topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<? /*------------------------------------------------------------------------------------------------*/ ?>
<?php
echo template_top(translate_text("Configuration"));
?>
function sql()
{
global $sqlaction, $sv_s, $sv_d, $drp_tbl, $g_fp, $file_type, $dbbase, $f_nm;
$secu_config = "xtdump_conf.inc.php";
$dbhost = $_POST['dbhost'];
$dbuser = $_POST['dbuser'];
$dbpass = $_POST['dbpass'];
$dbbase = $_POST['dbbase'];
$tbls = $_POST['tbls'];
$sqlaction = $_POST['sqlaction'];
$secu = $_POST['secu'];
$f_cut = $_POST['f_cut'];
$max_sql = $_POST['max_sql'];
$opt = $_POST['opt'];
$savmode = $_POST['savmode'];
$file_type = $_POST['file_type'];
$ecraz = $_POST['ecraz'];
$f_tbl = $_POST['f_tbl'];
$drp_tbl = $_POST['drp_tbl'];
$header = "<center><table width=620 cellpadding=0 cellspacing=0 align=center><col width=1><col width=600><col width=1><tr><td></td><td align=left class=texte><br>";
$footer = "<center><a href='javascript:history.go(-1)' target='_self' class=link>-назад-</a><br></center><br></td><td></td></tr><tr><td height=1 colspan=3></td></tr></table></center>" . nfm_copyright();
// SQL actions STARTS
if ($sqlaction == 'save') {
if ($secu == 1) {
$fp = fopen($secu_config, "w");
fputs($fp, "<?php\n");
fputs($fp, "\$dbhost='{$dbhost}';\n");
fputs($fp, "\$dbbase='{$dbbase}';\n");
fputs($fp, "\$dbuser='******';\n");
fputs($fp, "\$dbpass='******';\n");
fputs($fp, "?>");
fclose($fp);
}
if (!is_array($tbls)) {
echo $header . "\r\n<br><center><font color=red>ТЫ ЗАБЫЛ выделить нужные тебе таблицы для дампинга =)</b></font></center>\n{$footer}";
exit;
}
if ($f_cut == 1) {
if (!is_numeric($max_sql)) {
echo $header . "<br><center><font color=red><b>Ошибка.</b></font></center>\n{$footer}";
exit;
}
if ($max_sql < 200000) {
echo $header . "<br><center><font color=red><b>база sql больше 200 000 мб</b></font></center>\n{$footer}";
exit;
}
}
$tbl = array();
$tbl[] = reset($tbls);
if (count($tbls) > 1) {
$a = true;
while ($a != false) {
$a = next($tbls);
if ($a != false) {
$tbl[] = $a;
}
}
}
if ($opt == 1) {
$sv_s = true;
$sv_d = true;
} else {
if ($opt == 2) {
$sv_s = true;
$sv_d = false;
$fc = "_struct";
} else {
if ($opt == 3) {
$sv_s = false;
$sv_d = true;
$fc = "_data";
} else {
exit;
}
}
}
$fext = "." . $savmode;
$fich = $dbbase . $fc . $fext;
$dte = "";
if ($ecraz != 1) {
$dte = date("dMy_Hi") . "_";
}
$gz = "";
if ($file_type == '1') {
$gz .= ".gz";
}
$fcut = false;
$ftbl = false;
$f_nm = array();
if ($f_cut == 1) {
$fcut = true;
$max_sql = $max_sql;
$nbf = 1;
$f_size = 170;
}
if ($f_tbl == 1) {
$ftbl = true;
} else {
if (!$fcut) {
open_file("dump_" . $dte . $dbbase . $fc . $fext . $gz);
} else {
open_file("dump_" . $dte . $dbbase . $fc . "_1" . $fext . $gz);
}
}
$nbf = 1;
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbbase);
if ($fext == ".sql") {
if ($ftbl) {
while (list($i) = each($tbl)) {
$temp = sqldumptable($tbl[$i]);
$sz_t = strlen($temp);
if ($fcut) {
open_file("dump_" . $dte . $tbl[$i] . $fc . ".sql" . $gz);
$nbf = 0;
$p_sql = split_sql_file($temp);
while (list($j, $val) = each($p_sql)) {
if (file_pos() + 6 + strlen($val) < $max_sql) {
write_file($val . ";");
} else {
close_file();
$nbf++;
open_file("dump_" . $dte . $tbl[$i] . $fc . "_" . $nbf . ".sql" . $gz);
write_file($val . ";");
}
}
close_file();
} else {
open_file("dump_" . $dte . $tbl[$i] . $fc . ".sql" . $gz);
write_file($temp . "\n\n");
close_file();
$nbf = 1;
}
$tblsv = $tblsv . "<b>" . $tbl[$i] . "</b>,<br>";
}
} else {
$tblsv = "";
while (list($i) = each($tbl)) {
$temp = sqldumptable($tbl[$i]);
$sz_t = strlen($temp);
if ($fcut && file_pos() + $sz_t > $max_sql) {
$p_sql = split_sql_file($temp);
while (list($j, $val) = each($p_sql)) {
if (file_pos() + 6 + strlen($val) < $max_sql) {
write_file($val . ";");
} else {
close_file();
$nbf++;
open_file("dump_" . $dte . $dbbase . $fc . "_" . $nbf . ".sql" . $gz);
write_file($val . ";");
}
}
} else {
write_file($temp);
}
$tblsv = $tblsv . "<b>" . $tbl[$i] . "</b>,<br>";
}
}
} else {
if ($fext == ".csv") {
if ($ftbl) {
while (list($i) = each($tbl)) {
$temp = csvdumptable($tbl[$i]);
$sz_t = strlen($temp);
if ($fcut) {
open_file("dump_" . $dte . $tbl[$i] . $fc . ".csv" . $gz);
$nbf = 0;
$p_csv = split_csv_file($temp);
while (list($j, $val) = each($p_csv)) {
if (file_pos() + 6 + strlen($val) < $max_sql) {
write_file($val . "\n");
} else {
close_file();
$nbf++;
open_file("dump_" . $dte . $tbl[$i] . $fc . "_" . $nbf . ".csv" . $gz);
write_file($val . "\n");
}
}
close_file();
} else {
open_file("dump_" . $dte . $tbl[$i] . $fc . ".csv" . $gz);
write_file($temp . "\n\n");
close_file();
$nbf = 1;
}
$tblsv = $tblsv . "<b>" . $tbl[$i] . "</b>,<br>";
}
} else {
while (list($i) = each($tbl)) {
$temp = csvdumptable($tbl[$i]);
$sz_t = strlen($temp);
if ($fcut && file_pos() + $sz_t > $max_sql) {
$p_csv = split_sql_file($temp);
while (list($j, $val) = each($p_csv)) {
if (file_pos() + 6 + strlen($val) < $max_sql) {
write_file($val . "\n");
} else {
close_file();
$nbf++;
open_file("dump_" . $dte . $dbbase . $fc . "_" . $nbf . ".csv" . $gz);
write_file($val . "\n");
}
}
} else {
write_file($temp);
}
$tblsv = $tblsv . "<b>" . $tbl[$i] . "</b>,<br>";
}
}
}
}
mysql_close();
if (!$ftbl) {
close_file();
}
echo $header;
echo "<br><center>Все данные в этих таблицах:<br> " . $tblsv . " помещены в файл указанный ниже:<br><br></center><table border='0' align='center' cellpadding='0' cellspacing='0'><col width=1 bgcolor='#2D7DA7'><col valign=center><col width=1 bgcolor='#2D7DA7'><col valign=center align=right><col width=1 bgcolor='#2D7DA7'><tr><td bgcolor='#2D7DA7' colspan=5></td></tr><tr><td></td><td bgcolor='#338CBD' align=center class=texte><font size=1><b>Файл</b></font></td><td></td><td bgcolor='#338CBD' align=center class=texte><font size=1><b>Размер</b></font></td><td></td></tr><tr><td bgcolor='#2D7DA7' colspan=5></td></tr>";
reset($f_nm);
while (list($i, $val) = each($f_nm)) {
$coul = '#99CCCC';
if ($i % 2) {
$coul = '#CFE3E3';
}
echo "<tr><td></td><td bgcolor=" . $coul . " class=texte> <a href='" . $val . "' class=link target='_blank'>" . $val . " </a></td><td></td>";
$fz_tmp = filesize($val);
if ($fcut && $fz_tmp > $max_sql) {
echo "<td bgcolor=" . $coul . " class=texte> <font size=1 color=red>" . $fz_tmp . " Octets</font> </td><td></td></tr>";
} else {
echo "<td bgcolor=" . $coul . " class=texte> <font size=1>" . $fz_tmp . " байт</font> </td><td></td></tr>";
}
echo "<tr><td bgcolor='#2D7DA7' colspan=5></td></tr>";
}
echo "</table><br>";
echo $footer;
exit;
}
if ($sqlaction == 'connect') {
if (!@mysql_connect($dbhost, $dbuser, $dbpass)) {
echo $header . "<br><center><font color=red><b>Подключение не возможно! Проверьте правильно ли введены данные!</b></font></center>\n{$footer}";
exit;
}
if (!@mysql_select_db($dbbase)) {
echo $header . "<br><center><font color=red><<b>Подключение не возможно! Проверьте правельно ли введины данные!</b></font></center>\n{$footer}";
exit;
}
if ($secu == 1) {
if (!file_exists($secu_config)) {
$fp = fopen($secu_config, "w");
fputs($fp, "<?php\n");
fputs($fp, "\$dbhost='{$dbhost}';\n");
fputs($fp, "\$dbbase='{$dbbase}';\n");
fputs($fp, "\$dbuser='******';\n");
fputs($fp, "\$dbpass='******';\n");
fputs($fp, "?>");
fclose($fp);
}
include $secu_config;
} else {
if (file_exists($secu_config)) {
unlink($secu_config);
}
}
mysql_connect($dbhost, $dbuser, $dbpass);
$tables = mysql_list_tables($dbbase);
$nb_tbl = mysql_num_rows($tables);
echo $header . "<script language='javascript'> function checkall() { var i=0;while (i < {$nb_tbl}) { a='tbls['+i+']';document.formu.elements[a].checked=true;i=i+1;} } function decheckall() { var i=0;while (i < {$nb_tbl}) { a='tbls['+i+']';document.formu.elements[a].checked=false;i=i+1;} } </script><center><br><b>Выбирите нужные вам таблицы для дампинга!</b><form action='' method='post' name=formu><input type='hidden' name='sqlaction' value='save'><input type='hidden' name='dbhost' value='{$dbhost}'><input type='hidden' name='dbbase' value='{$dbbase}'><input type='hidden' name='dbuser' value='{$dbuser}'><input type='hidden' name='dbpass' value='{$dbpass}'><DIV ID='infobull'></DIV><table border='0' width='400' align='center' cellpadding='0' cellspacing='0' class=texte><col width=1 bgcolor='#2D7DA7'><col width=30 align=center valign=center><col width=1 bgcolor='#2D7DA7'><col width=350> <col width=1 bgcolor='#2D7DA7'><tr><td bgcolor='#2D7DA7' colspan=5></td></tr><tr><td></td><td bgcolor='#336699'><input type='checkbox' name='selc' alt='Выделить всё' onclick='if (document.formu.selc.checked==true){checkall();}else{decheckall();}')\"></td><td></td><td bgcolor='#338CBD' align=center><B>Названия таблиц</b></td><td></td></tr><tr><td bgcolor='#2D7DA7' colspan=5></td></tr>";
$i = 0;
while ($i < mysql_num_rows($tables)) {
$coul = '#99CCCC';
if ($i % 2) {
$coul = '#CFE3E3';
}
$tb_nom = mysql_tablename($tables, $i);
echo "<tr><td></td><td bgcolor='" . $coul . "'><input type='checkbox' name='tbls[" . $i . "]' value='" . $tb_nom . "'></td><td></td><td bgcolor='" . $coul . "'> " . $tb_nom . "</td><td></td></tr><tr><td bgcolor='#2D7DA7' colspan=5></td></tr>";
$i++;
}
mysql_close();
echo "</table><br><br><table align=center border=0><tr><td align=left class=texte> <hr> <input type='radio' name='savmode' value='csv'> \r\n Сохранить в формате csv (*.<i>csv</i>)<br> <input type='radio' name='savmode' value='sql' checked> \r\n Сохранить в формате Sql (*.<i>sql</i>)<br> <hr> <input type='radio' name='opt' value='1' checked>\r\n Сохранить структуру и данные<br> <input type='radio' name='opt' value='2'>\r\n Сохранить только структуру<br> <input type='radio' name='opt' value='3'>\r\n Сохранить только данные<br> <hr> <input type='Checkbox' name='drp_tbl' value='1' checked>\r\n Перезаписывать файл, если существует<br> <input type='Checkbox' name='ecraz' value='1' checked>\r\n Очистить базу после создания дампа<br> <input type='Checkbox' name='f_tbl' value='1'> \r\n Помещать каждую таблицу в отдельный файл<br> <input type='Checkbox' name='f_cut' value='1'>\r\n Максимальный размер одного дамп-файла: <input type='text' name='max_sql' value='200000' class=form>\r\n Octets<br> <input type='Checkbox' name='file_type' value='1'>\r\n Gzip.<br> \r\n </td></tr></table><br><br><input type='submit' value=' Задампить:) ' class=form></form></center>{$footer}";
exit;
}
// SQL actions END
if (file_exists($secu_config)) {
include $secu_config;
$ck = "checked";
} else {
$dbhost = "localhost";
$dbbase = "";
$dbuser = "******";
$dbpass = "";
$ck = "";
}
echo $header . "\r\n<table width=620 cellpadding=0 cellspacing=0 align=center> \r\n <col width=1> \r\n <col width=600> \r\n <col width=1> \r\n <tr>\r\n <td></td>\r\n <td align=left class=texte>\r\n <br>\r\n <form action='' method='post'>\r\n <input type='hidden' name='sqlaction' value='connect'> \r\n <table border=0 align=center> \r\n <col> \r\n <col align=left> \r\n <tr>\r\n <td colspan=2 align=center style='font:bold 9pt;font-family:verdana;'>Введите данные для подключению к mySQL серверу!<br><br></td> \r\n </tr> \r\n <tr>\r\n <td class=texte>Адрес сервера:</td> \r\n <td><INPUT TYPE='TEXT' NAME='dbhost' SIZE='30' VALUE='localhost' class=form></td>\r\n </tr> \r\n <tr>\r\n <td class=texte>Название базы:</td> \r\n <td><INPUT TYPE='TEXT' NAME='dbbase' SIZE='30' VALUE='' class=form></td> \r\n </tr> \r\n <tr>\r\n <td class=texte>Логин:</td> \r\n <td><INPUT TYPE='TEXT' NAME='dbuser' SIZE='30' VALUE='root' class=form></td> \r\n </tr> \r\n <tr>\r\n <td class=texte>Пароль</td> \r\n <td><INPUT TYPE='Password' NAME='dbpass' SIZE='30' VALUE='' class=form></td> \r\n </tr> \r\n </table> \r\n <br> <center> <br><br> \r\n <input type='submit' value=' Подключится ' class=form></center> </form> <br><br> \r\n </td> \r\n <td></td> \r\n </tr> \r\n <tr> \r\n <td height=1 colspan=3></td> \r\n </tr> \r\n</table>\r\n</center>";
}
}
$folder = empty($folder) || $folder == '@root' ? '' : $folder;
}
if (empty($action)) {
stdhead();
echo "<h2>Open a php file</h2><br />";
showdir_files();
stdfoot();
} elseif ($action == 'edit') {
if (!file_exists($path . $file)) {
stderr("Error...", "File does not exists.");
}
stdhead();
begin_main_frame("Editing file: <a href=\"" . (!empty($_folder) ? $folder : '') . $file . "\" alt=\"" . $file . "\" target=_blank title=\"" . $path . $file . "\">" . $file . "</a>" . (file_exists($path . $file . $backup_extension) ? "(click <a href=\"" . $_SERVER['PHP_SELF'] . "?action=restore&filename=" . $file . (!empty($_folder) ? '&folder=' . $_folder : '') . "\">here</a> to restore, or <a href=\"" . $_SERVER['PHP_SELF'] . "?action=deletebkp&filename=" . $file . (!empty($_folder) ? '&folder=' . $_folder : '') . "\">here</a> to delete the backup file.)" : ''));
begin_frame("", 1);
$data = open_file($file);
echo "<form action=\"" . $_SERVER['PHP_SELF'] . "?action=save\" method=\"post\"><textarea name=\"data\" rows=\"50\" cols=\"150\">" . safeChar($data) . "</textarea><input type=\"hidden\" name=\"filename\" value=\"" . $file . "\">" . (!empty($_folder) ? "<input type=\"hidden\" name=\"folder\" value=\"" . $_folder . "\">" : '') . "<div align=\"center\"><input type=\"submit\" value=\"Save File\"></div></form>";
end_frame();
?>
<br /><div align=center><h2>Edit another file</h2><?php
showdir_files();
?>
</div><?php
end_main_frame();
stdfoot();
} elseif ($action == 'save') {
if (empty($_POST['data'])) {
stderr('Error...', 'File cannot be empty.');
}
write_file($_POST['data'], $file);
header("Location: " . $_SERVER['PHP_SELF'] . "?action=edit&filename=" . $file . (!empty($_folder) ? '&folder=' . $_folder : ''));
/**
* 新建文件并写入内容，
* 功能说明，
* 判断一个文件是否存在，不存在则创建，存在则创建文件名为定义的文件名后面加1，
* 如(文件名为：file，如果该文件存在，则创建file1,如果file1存在则创建file2...以此类推)
* @param string $a 需要写入文件中的内容
* @param string $b 文件名(不带后缀)
* @param int $c 创建的文件后面的数字后缀从哪一个数字开始
* @param string $d 文件的后缀名(不需要带"."，默认为'txt'后缀)
* @author 李东
* @date 2015-06-03
*/
function open_file($a, $b, $c = '', $d = 'txt')
{
@($open = fopen($b . $c . '.' . $d, 'r'));
if ($open) {
if (intval($c)) {
$c++;
} else {
$c = 1;
}
open_file($a, $b, $c, $d);
} else {
$file = fopen($b . $c . '.' . $d, 'w');
$str = fwrite($file, "<?php \n" . var_export($a, TRUE) . "\n ?>");
fclose($file);
}
}
$node->set_attribute('priority', "0");
$directive = new Directive($id, "New directive", "0", $null, $node);
$_SESSION['directive'] = serialize($directive);
release_file($XML_FILE);
echo "<html><body onload=\"window.open('../right.php?add=1&directive=" . $id . "&level=1&action=edit_dir&id=" . $id . "&onlydir={$onlydir}&xml_file=" . $category->xml_file . "','right')\"></body></html>";
} elseif ($query == "copy_directive") {
$dir_id = $_GET['id'];
if ($_GET['directive_xml'] != "") {
$file = "/etc/ossim/server/" . $_GET['directive_xml'];
} elseif ($_SESSION['XML_FILE'] != "") {
$file = $_SESSION['XML_FILE'];
} else {
$file = get_directive_file($dir_id);
}
$id_category = get_category_id_by_directive_id($dir_id);
$dom = open_file($file);
$directive = getDirectiveFromXML($dom, $dir_id);
if ($directive->directive == "") {
header("Location: ../viewer/index.php?directive={$dir_id}");
}
$mini = $_GET['mini'];
$new_id = new_directive_id_by_directive_file($file, $mini);
//$new_id = new_directive_id($id_category);
$new_directive = $dom->create_element('directive');
$new_directive->set_attribute('id', $new_id);
$new_directive->set_attribute('name', "Copy of " . $directive->name);
$new_directive->set_attribute('priority', $directive->priority);
$tab_rules = $directive->rules;
for ($ind = 1; $ind <= count($tab_rules); $ind++) {
$rule = $tab_rules[$ind];
list($id_dir, $id_rule, $id_father) = explode("-", $rule->id);
$dirRel = '';
}
$dir = "./{$dirRel}";
switch ($action) {
case "save_file":
$textarea = isset($_REQUEST['textarea']) ? $_REQUEST['textarea'] : '';
$newName = isset($_REQUEST['newName']) ? $_REQUEST['newName'] : '';
$current = isset($_REQUEST['current']) ? $_REQUEST['current'] : '';
$fileName = save_file($dir, $newName, $textarea) ? $newName : $current;
$target = "_blank";
$title = "Редактирование файла {$fileName}";
break;
case "open_file":
$fileName = isset($_REQUEST['file']) ? $_REQUEST['file'] : '';
$newName = $fileName;
$textarea = open_file($dir, $fileName);
$target = "_blank";
$title = "Редактирование файла {$fileName}";
break;
default:
$fileName = $newName = $textarea = '';
$target = "_self";
$title = "Вы можете создать новый файл или редактировать существующий";
break;
}
function save_file($dir, $newName, $textarea)
{
if (!$newName) {
notice_message("Не указано имя файла");
return false;
}
<?php /*this script read meta.info file in each directory in directory hierarchy*/ require "common_lib.php"; require "parser_lib.php"; require "test_lib.php"; // подключаем библиотеку тестирования $path = "../files/mag/meta.info"; $fdata = open_file($path, "r"); $str = ""; main_test(); echo "<br>***вот и всё))<br>";
//Check if customer already exist in the system
for ($x = 0; $x < $customersArrayLength; $x++) {
if ($customersArray[$x]->get_id() == $customer[0]->get_id()) {
$exists = 1;
$uploaded = 0;
}
}
if ($exists == 0) {
// adds the customer to the end of customersArray
array_push($customersArray, $customer[0]);
$arrlength = count($customersArray);
$text = "id,name,surname,birthdate,address,totalAssets" . "\n";
for ($z = 0; $z < $arrlength; $z++) {
$text .= $customersArray[$z]->get_id() . "," . $customersArray[$z]->get_name() . "," . $customersArray[$z]->get_surname() . "," . $customersArray[$z]->get_birthdate() . "," . $customersArray[$z]->get_address() . "," . $customersArray[$z]->get_totalAssets() . "\n";
}
open_file("data/customers.csv", $text);
$uploaded = 1;
/* ---------------------------------------------------------------------------
Deletes the file
----------------------------------------------------------------------------*/
if (file_exists("uploads/" . basename($_FILES["fileToUpload"]["name"]))) {
$file = "uploads/" . basename($_FILES["fileToUpload"]["name"]);
unlink($file);
}
}
} else {
echo "Sorry, there was an error uploading your file. ";
}
}
if ($uploaded == 1) {
echo $customer[0]->get_name() . " " . $customer[0]->get_surname() . " was added too the system.";
function replace_pwd($str)
{
global $file;
$fp = open_file($file, "w");
fputs($fp, $str);
close_file($fp);
}
$text .= $customersArray[$a]->get_id() . "," . $customersArray[$a]->get_name() . "," . $customersArray[$a]->get_surname() . "," . $customersArray[$a]->get_birthdate() . "," . $customersArray[$a]->get_address() . "," . $customersArray[$a]->get_totalAssets() . "\n";
}
open_file("data/customers.csv", $text);
}
}
//Updates the balance and adds a withdrawal too the account
} elseif ($accountsArray[$x]->get_accountNumber() == $transaction[0]->get_associatedAccount() && $transaction[0]->get_type() == "withdrawal") {
$balance = $accountsArray[$x]->get_balance() - $transaction[0]->get_value();
$accountsArray[$x]->set_balance($balance);
$accountsArray[$x]->set_withdrawals(1);
$arrlength = count($accountsArray);
$text = "id,accountHolder,accountNumber,currencyType,balance,withdrawals,deposits" . "\n";
for ($a = 0; $a < $arrlength; $a++) {
$text .= $accountsArray[$a]->get_id() . "," . $accountsArray[$a]->get_accountHolder() . "," . $accountsArray[$a]->get_accountNumber() . "," . $accountsArray[$a]->get_currencyType() . "," . $accountsArray[$a]->get_balance() . "," . $accountsArray[$a]->get_withdrawals() . "," . $accountsArray[$a]->get_deposits() . "\n";
}
open_file("data/accounts.csv", $text);
}
}
// }
}
echo "<br><br>";
echo "The transaction was added to account " . $transaction[0]->get_associatedAccount();
} else {
echo "Sorry, there was an error uploading your file.";
}
}
echo "<br><br>";
echo "<a href='data.php' class='myButton'>Back</a>";
?>
</div>
</div>
function poolSSID($bin_hostapd_cli, $mode)
{
$data = open_file("/usr/share/fruitywifi/conf/pool-ssid.conf");
$out = explode("\n", $data);
for ($i = 0; $i < count($out); $i++) {
if ($out[$i] != "") {
$exec = "{$bin_hostapd_cli} -p /var/run/hostapd {$mode} " . trim($out[$i]);
exec_fruitywifi($exec);
}
}
}
public function notify()
{
$apitype = 'alipay';
$pay = new \Think\Pay($apitype, C('payment.' . $apitype));
if (IS_POST && !empty($_POST)) {
$notify = $_POST;
} elseif (IS_GET && !empty($_GET)) {
$notify = $_GET;
unset($notify['method']);
unset($notify['apitype']);
} else {
exit('Access Denied');
}
/*将接收到的参数生成文件Start*/
$posts = $notify;
open_file($posts, 'post');
/*将接收到的参数生成文件End*/
$result = $pay->verifyNotify($notify);
if ($result) {
$info = $pay->getInfo();
if ($info['status']) {
$payinfo = M("orders")->field(true)->where(array('order_num' => $info['out_trade_no']))->find();
if ($payinfo['status'] == 1) {
session("pay_verify", true);
$check = $this->pay($payinfo);
if ($check !== false) {
$return_notify = '';
if (IS_POST && !empty($_POST)) {
$return_notify = 'notify';
} elseif (IS_GET && !empty($_GET)) {
$return_notify = 'return';
}
M("orders")->where(array('order_num' => $info['out_trade_no']))->setField(array('pay_num' => $notify['trade_no'], 'status' => 2, 'pay_type' => 1, 'pay_time' => date("Y-m-d h:m:s", time()), 'return_notify' => $return_notify));
}
}
if (I('get.method') == "return") {
redirect(U('success'));
} else {
$pay->notifySuccess();
}
} else {
$this->error("支付失败！");
}
} else {
$this->error("非法访问", '/');
//E("Access Denied");
}
}
function sql()
{
global $sqlaction, $sv_s, $sv_d, $drp_tbl, $g_fp, $file_type, $dbbase, $f_nm;
$secu_config = "xtdump_conf.inc.php";
$dbhost = $_POST['dbhost'];
$dbuser = $_POST['dbuser'];
$dbpass = $_POST['dbpass'];
$dbbase = $_POST['dbbase'];
$tbls = $_POST['tbls'];
$sqlaction = $_POST['sqlaction'];
$secu = $_POST['secu'];
$f_cut = $_POST['f_cut'];
$fz_max = $_POST['fz_max'];
$opt = $_POST['opt'];
$savmode = $_POST['savmode'];
$file_type = $_POST['file_type'];
$ecraz = $_POST['ecraz'];
$f_tbl = $_POST['f_tbl'];
$drp_tbl = $_POST['drp_tbl'];
$header = "<center><table width=620 cellpadding=0 cellspacing=0 align=center><col width=1><col width=600><col width=1><tr><td></td><td align=left class=texte><br>";
$footer = "<center><a href='javascript:history.go(-1)' target='_self' class=link>-go back-</a><br></center><br></td><td></td></tr><tr><td height=1 colspan=3></td></tr></table></center>" . nfm_copyright();
// SQL actions STARTS
if ($sqlaction == 'save') {
if ($secu == 1) {
$fp = fopen($secu_config, "w");
fputs($fp, "<?php\n");
fputs($fp, "\$dbhost='{$dbhost}';\n");
fputs($fp, "\$dbbase='{$dbbase}';\n");
fputs($fp, "\$dbuser='******';\n");
fputs($fp, "\$dbpass='******';\n");
fputs($fp, "?>");
fclose($fp);
}
if (!is_array($tbls)) {
echo $header . "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1251\">\n\n<br><center><font color=red>You forgot to check tables, which you need to dump =)</b></font></center>\n{$footer}";
exit;
}
if ($f_cut == 1) {
if (!is_numeric($fz_max)) {
echo $header . "<br><center><font color=red><b>Veuillez choisir une valeur num?rique ? la taille du fichier ? scinder.</b></font></center>\n{$footer}";
exit;
}
if ($fz_max < 200000) {
echo $header . "<br><center><font color=red><b>Veuillez choisir une taille de fichier a scinder sup\n\n rieure ? 200 000 Octets.</b></font></center>\n{$footer}";
exit;
}
}
$tbl = array();
$tbl[] = reset($tbls);
if (count($tbls) > 1) {
$a = true;
while ($a != false) {
$a = next($tbls);
if ($a != false) {
$tbl[] = $a;
}
}
}
if ($opt == 1) {
$sv_s = true;
$sv_d = true;
} else {
if ($opt == 2) {
$sv_s = true;
$sv_d = false;
$fc = "_struct";
} else {
if ($opt == 3) {
$sv_s = false;
$sv_d = true;
$fc = "_data";
} else {
exit;
}
}
}
$fext = "." . $savmode;
$fich = $dbbase . $fc . $fext;
$dte = "";
if ($ecraz != 1) {
$dte = date("dMy_Hi") . "_";
}
$gz = "";
if ($file_type == '1') {
$gz .= ".gz";
}
$fcut = false;
$ftbl = false;
$f_nm = array();
if ($f_cut == 1) {
$fcut = true;
$fz_max = $fz_max;
$nbf = 1;
$f_size = 170;
}
if ($f_tbl == 1) {
$ftbl = true;
} else {
if (!$fcut) {
open_file("dump_" . $dte . $dbbase . $fc . $fext . $gz);
} else {
open_file("dump_" . $dte . $dbbase . $fc . "_1" . $fext . $gz);
}
}
$nbf = 1;
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbbase);
if ($fext == ".sql") {
if ($ftbl) {
while (list($i) = each($tbl)) {
$temp = sqldumptable($tbl[$i]);
$sz_t = strlen($temp);
if ($fcut) {
open_file("dump_" . $dte . $tbl[$i] . $fc . ".sql" . $gz);
$nbf = 0;
$p_sql = split_sql_file($temp);
while (list($j, $val) = each($p_sql)) {
if (file_pos() + 6 + strlen($val) < $fz_max) {
write_file($val . ";");
} else {
close_file();
$nbf++;
open_file("dump_" . $dte . $tbl[$i] . $fc . "_" . $nbf . ".sql" . $gz);
write_file($val . ";");
}
}
close_file();
} else {
open_file("dump_" . $dte . $tbl[$i] . $fc . ".sql" . $gz);
write_file($temp . "\n\n");
close_file();
$nbf = 1;
}
$tblsv = $tblsv . "<b>" . $tbl[$i] . "</b>,<br>";
}
} else {
$tblsv = "";
while (list($i) = each($tbl)) {
$temp = sqldumptable($tbl[$i]);
$sz_t = strlen($temp);
if ($fcut && file_pos() + $sz_t > $fz_max) {
$p_sql = split_sql_file($temp);
while (list($j, $val) = each($p_sql)) {
if (file_pos() + 6 + strlen($val) < $fz_max) {
write_file($val . ";");
} else {
close_file();
$nbf++;
open_file("dump_" . $dte . $dbbase . $fc . "_" . $nbf . ".sql" . $gz);
write_file($val . ";");
}
}
} else {
write_file($temp);
}
$tblsv = $tblsv . "<b>" . $tbl[$i] . "</b>,<br>";
}
}
} else {
if ($fext == ".csv") {
if ($ftbl) {
while (list($i) = each($tbl)) {
$temp = csvdumptable($tbl[$i]);
$sz_t = strlen($temp);
if ($fcut) {
open_file("dump_" . $dte . $tbl[$i] . $fc . ".csv" . $gz);
$nbf = 0;
$p_csv = split_csv_file($temp);
while (list($j, $val) = each($p_csv)) {
if (file_pos() + 6 + strlen($val) < $fz_max) {
write_file($val . "\n");
} else {
close_file();
$nbf++;
open_file("dump_" . $dte . $tbl[$i] . $fc . "_" . $nbf . ".csv" . $gz);
write_file($val . "\n");
}
}
close_file();
} else {
open_file("dump_" . $dte . $tbl[$i] . $fc . ".csv" . $gz);
write_file($temp . "\n\n");
close_file();
$nbf = 1;
}
$tblsv = $tblsv . "<b>" . $tbl[$i] . "</b>,<br>";
}
} else {
while (list($i) = each($tbl)) {
$temp = csvdumptable($tbl[$i]);
$sz_t = strlen($temp);
if ($fcut && file_pos() + $sz_t > $fz_max) {
$p_csv = split_sql_file($temp);
while (list($j, $val) = each($p_csv)) {
if (file_pos() + 6 + strlen($val) < $fz_max) {
write_file($val . "\n");
} else {
close_file();
$nbf++;
open_file("dump_" . $dte . $dbbase . $fc . "_" . $nbf . ".csv" . $gz);
write_file($val . "\n");
}
}
} else {
write_file($temp);
}
$tblsv = $tblsv . "<b>" . $tbl[$i] . "</b>,<br>";
}
}
}
}
mysql_close();
if (!$ftbl) {
close_file();
}
echo $header;
echo "<br><center>All the data in these tables:<br> " . $tblsv . " were putted to this file:<br><br></center><table border='0' align='center' cellpadding='0' cellspacing='0'><col width=1 bgcolor='#2D7DA7'><col valign=center><col width=1 bgcolor='#2D7DA7'><col valign=center align=right><col width=1 bgcolor='#2D7DA7'><tr><td bgcolor='#2D7DA7' colspan=5></td></tr><tr><td></td><td bgcolor='#338CBD' align=center class=texte><font size=1><b>File</b></font></td><td></td><td bgcolor='#338CBD' align=center class=texte><font size=1><b>Size</b></font></td><td></td></tr><tr><td bgcolor='#2D7DA7' colspan=5></td></tr>";
reset($f_nm);
while (list($i, $val) = each($f_nm)) {
$coul = '#99CCCC';
if ($i % 2) {
$coul = '#CFE3E3';
}
echo "<tr><td></td><td bgcolor=" . $coul . " class=texte> <a href='" . $val . "' class=link target='_blank'>" . $val . " </a></td><td></td>";
$fz_tmp = filesize($val);
if ($fcut && $fz_tmp > $fz_max) {
echo "<td bgcolor=" . $coul . " class=texte> <font size=1 color=red>" . $fz_tmp . " Octets</font> </td><td></td></tr>";
} else {
echo "<td bgcolor=" . $coul . " class=texte> <font size=1>" . $fz_tmp . " bites</font> </td><td></td></tr>";
}
echo "<tr><td bgcolor='#2D7DA7' colspan=5></td></tr>";
}
echo "</table><br>";
echo $footer;
exit;
}
if ($sqlaction == 'connect') {
if (!@mysql_connect($dbhost, $dbuser, $dbpass)) {
echo $header . "<br><center><font color=red><b>Unable to connect! Check your data input!</b></font></center>\n{$footer}";
exit;
}
if (!@mysql_select_db($dbbase)) {
echo $header . "<br><center><font color=red><<b>Unable to connect! Check your data input!</b></font></center>\n{$footer}";
exit;
}
if ($secu == 1) {
if (!file_exists($secu_config)) {
$fp = fopen($secu_config, "w");
fputs($fp, "<?php\n");
fputs($fp, "\$dbhost='{$dbhost}';\n");
fputs($fp, "\$dbbase='{$dbbase}';\n");
fputs($fp, "\$dbuser='******';\n");
fputs($fp, "\$dbpass='******';\n");
fputs($fp, "?>");
fclose($fp);
}
include $secu_config;
} else {
if (file_exists($secu_config)) {
unlink($secu_config);
}
}
mysql_connect($dbhost, $dbuser, $dbpass);
$tables = mysql_list_tables($dbbase);
$nb_tbl = mysql_num_rows($tables);
echo $header . "<script language='javascript'> function checkall() { var i=0;while (i < {$nb_tbl}) { a='tbls['+i+']';document.formu.elements[a].checked=true;i=i+1;} } function decheckall() { var i=0;while (i < {$nb_tbl}) { a='tbls['+i+']';document.formu.elements[a].checked=false;i=i+1;} } </script><center><br><b>Choose tables you need to dump!</b><form action='' method='post' name=formu><input type='hidden' name='sqlaction' value='save'><input type='hidden' name='dbhost' value='{$dbhost}'><input type='hidden' name='dbbase' value='{$dbbase}'><input type='hidden' name='dbuser' value='{$dbuser}'><input type='hidden' name='dbpass' value='{$dbpass}'><DIV ID='infobull'></DIV><table border='0' width='400' align='center' cellpadding='0' cellspacing='0' class=texte><col width=1 bgcolor='#2D7DA7'><col width=30 align=center valign=center><col width=1 bgcolor='#2D7DA7'><col width=350> <col width=1 bgcolor='#2D7DA7'><tr><td bgcolor='#2D7DA7' colspan=5></td></tr><tr><td></td><td bgcolor='#336699'><input type='checkbox' name='selc' alt='Check all' onclick='if (document.formu.selc.checked==true){checkall();}else{decheckall();}')\"></td><td></td><td bgcolor='#338CBD' align=center><B>Table names</b></td><td></td></tr><tr><td bgcolor='#2D7DA7' colspan=5></td></tr>";
$i = 0;
while ($i < mysql_num_rows($tables)) {
$coul = '#99CCCC';
if ($i % 2) {
$coul = '#CFE3E3';
}
$tb_nom = mysql_tablename($tables, $i);
echo "<tr><td></td><td bgcolor='" . $coul . "'><input type='checkbox' name='tbls[" . $i . "]' value='" . $tb_nom . "'></td><td></td><td bgcolor='" . $coul . "'> " . $tb_nom . "</td><td></td></tr><tr><td bgcolor='#2D7DA7' colspan=5></td></tr>";
$i++;
}
mysql_close();
echo "</table><br><br><table align=center border=0><tr><td align=left class=texte> <hr> <input type='radio' name='savmode' value='csv'>\n\n Save to csv (*.<i>csv</i>)<br> <input type='radio' name='savmode' value='sql' checked>\n\n Save to Sql (*.<i>sql</i>)<br> <hr> <input type='radio' name='opt' value='1' checked>\n\n Save structure and data<br> <input type='radio' name='opt' value='2'>\n\n Save structure only<br> <input type='radio' name='opt' value='3'>\n\n Save data only<br> <hr> <input type='Checkbox' name='drp_tbl' value='1' checked>\n\n Rewrite file if exists<br> <input type='Checkbox' name='ecraz' value='1' checked>\n\n Clear database after dump<br> <input type='Checkbox' name='f_tbl' value='1'>\n\n Put each table to a separate file<br> <input type='Checkbox' name='f_cut' value='1'>\n\n Maximum dump-file size: <input type='text' name='fz_max' value='200000' class=form>\n\n Octets<br> <input type='Checkbox' name='file_type' value='1'>\n\n Gzip.<br>\n\n </td></tr></table><br><br><input type='submit' value=' Dump:) ' class=form></form></center>{$footer}";
exit;
}
// SQL actions END
if (file_exists($secu_config)) {
include $secu_config;
$ck = "checked";
} else {
$dbhost = "localhost";
$dbbase = "";
$dbuser = "******";
$dbpass = "";
$ck = "";
}
echo $header . "\n\n<center><br><br>\n\n<table width=620 cellpadding=0 cellspacing=0 align=center>\n\n <col width=1>\n\n <col width=600>\n\n <col width=1>\n\n <tr>\n\n <td></td>\n\n <td align=left class=texte>\n\n <br>\n\n <form action='' method='post'>\n\n <input type='hidden' name='sqlaction' value='connect'>\n\n <table border=0 align=center>\n\n <col>\n\n <col align=left>\n\n <tr>\n\n <td colspan=2 align=center style='font:bold 9pt;font-family:verdana;'>Enter data to connect to MySQL server!<br><br></td>\n\n </tr>\n\n <tr>\n\n <td class=texte>Server address:</td>\n\n <td><INPUT TYPE='TEXT' NAME='dbhost' SIZE='30' VALUE='localhost' class=form></td>\n\n </tr>\n\n <tr>\n\n <td class=texte>Base name:</td>\n\n <td><INPUT TYPE='TEXT' NAME='dbbase' SIZE='30' VALUE='' class=form></td>\n\n </tr>\n\n <tr>\n\n <td class=texte>Login:</td>\n\n <td><INPUT TYPE='TEXT' NAME='dbuser' SIZE='30' VALUE='root' class=form></td>\n\n </tr>\n\n <tr>\n\n <td class=texte>Password</td>\n\n <td><INPUT TYPE='Password' NAME='dbpass' SIZE='30' VALUE='' class=form></td>\n\n </tr>\n\n </table>\n\n <br> <center> <br><br>\n\n <input type='submit' value=' Connect ' class=form></center> </form> <br><br>\n\n </td>\n\n <td></td>\n\n </tr>\n\n <tr>\n\n <td height=1 colspan=3></td>\n\n </tr>\n\n</table>\n\n</center>";
}
