function append_rows($service, $tableID, $taxon) { $rows = prepare_data($taxon['concept_id']); //append batches of 10k $i = 0; $partial = array(); //initialize foreach ($rows as $row) { if (number_of_cols($row) != 11) { continue; } //exclude row if total no. of cols is not 11, if not it will cause Fatal error "(400) Content has a different number of columns than the table". $row = str_replace('"', "'", $row); //need to do this to avoid "Parsing failure. Quotation mark found in unquoted value" $partial[] = $row; $i++; if ($i % 10000 == 0) { echo "\n[{$i}]\n"; insert_rows($partial, $tableID, $service); echo "...sleep 20 secs...\n"; sleep(20); $i = 0; $partial = array(); //initialize again... } } if ($partial) { insert_rows($partial, $tableID, $service); } //insert last batch }
PrintMenu(); ?> <P> </P> <P> </P> <P> </P> <?php $dbconnection = cohortdb_connect($cohort_db_server, $cohort_db_username, $cohort_db_password); $db_selected = mysql_select_db($cohort_db_name, $dbconnection); if (!$db_selected) { die('Can\'t use ' . $cohort_db_name . ' : ' . mysql_error()); } //validate_data("atomiko_anamnistiko", $_GET); check_patient($_GET['code']); $data_array2 = prepare_data("atomiko_anamnistiko", $_GET); if ($_GET['NeoplasmaID0'] == "Z99") { $data_array2['NeoplasmaID0'] = $_GET['NeoplasmaICD0']; $_GET['NeoplasmaID0'] = $_GET['NeoplasmaICD0']; } $names = array_keys($data_array2); $has_entry_query = "SELECT * FROM atomiko_anamnistiko WHERE PatientCode=" . $_GET['code']; $result = execute_query($has_entry_query); $has_entry = mysql_num_rows($result); mysql_free_result($result); if ($has_entry) { $atomic_sql = "UPDATE `atomiko_anamnistiko` SET "; for ($i = 1; $i < count($data_array2) - 1; $i++) { $atomic_sql .= "`" . $names[$i] . "`='" . $data_array2[$names[$i]] . "' , "; } $atomic_sql .= "`" . $names[$i] . "`='" . $data_array2[$names[$i]] . "' ";
?> <HTML><HEAD> <TITLE>Καταχώρηση Νέου Ασθενή</TITLE> <META http-equiv=Content-Type content="text/html; charset=windows-1253"> <link href="./include/cohort.css" rel="stylesheet" type="text/css"></HEAD> <?php PrintTopMenu(); ?> <P> </P> <P> </P> <?php validate_data('patients', $_GET); $data_array = prepare_data('patients', $_GET); if ($_GET['PatientCode'] == "" && $_GET['MELCode'] == "1111111") { $codetype = "NOMELNOKEELCODE"; $data_array['PatientCode'] = $_GET['next_nonmelkeelcode']; } elseif ($_GET['PatientCode'] == "" && $_GET['MELCode'] != "") { $codetype = "NOKEELCODE"; $data_array['PatientCode'] = $_GET['clinic'] * 100000 + $data_array['MELCode']; } else { $codetype = "FROMKEEL"; } $sql = "INSERT INTO `patients` (`PatientCode`, `MELCode`, `Name`, `Surname`, `BirthDate`, `CodeType`) "; $sql .= "VALUES ( '" . $data_array['PatientCode'] . "' , '" . $data_array['MELCode'] . "' , '" . $data_array['Name'] . "' , '" . $data_array['Surname'] . "' , '" . $data_array['BirthDate'] . "', '" . $codetype . "') "; //echo $sql; $what_happened = execute_query($sql); if ($what_happened == 1) { echo "<script>alert('Τα δεδομένα καταχωρήθηκαν με επιτυχία!')</script>\n";
function store_slide() { global $url_tail, $wp_session, $wpdb; if (!empty($_POST) && check_admin_referer('store_slide', '_alfw_nonce')) { $file = new alfw_manage_files(); $wpdb->show_errors(); $user_data = prepare_data($_POST); $create_slide = false; if (empty($_POST['slide_id'])) { /** * Insert */ if ($wpdb->insert($wpdb->prefix . SLIDES_TABLE, $user_data['data'], $user_data['format'])) { $error_statuses[] = __('Information saved'); } else { $error_statuses[] = __('Information not saved'); } $slide_id = $wpdb->insert_id; $create_slide = true; } else { /** * Update */ if ($wpdb->update($wpdb->prefix . SLIDES_TABLE, $user_data['data'], array('id' => $_POST['slide_id']), $user_data['format'], array('%d'))) { $error_statuses[] = __('Information saved'); } else { $error_statuses[] = __('Information not saved'); } $slide_id = $_POST['slide_id']; } if ($_POST['tmp_picture']) { /** * Get slider options */ $slider_options = $wpdb->get_results($wpdb->prepare("SELECT\n id, deny_resize_img, width, height, thumb_width, thumb_height\n FROM\n `" . $wpdb->prefix . SLIDER_TABLE . "`\n WHERE\n id = %d\n ", $user_data['data']['slider_id']), ARRAY_A); $upload_dir_info = wp_upload_dir(); $upload_dir_info = $upload_dir_info['basedir']; /** * Store original image */ $file->create_folder_recursive(FULL_UPLOAD_PATH_ORIG . "/" . $slider_options[0]['id'], 0755); //$picture_name = $file->modif_file_name(FULL_UPLOAD_PATH_ORIG . "/" . $slider_options[0]['id'] . "/", $_POST['tmp_picture_name']); $picture_name = $file->copy_file($upload_dir_info . "/" . $_POST['tmp_picture'], FULL_UPLOAD_PATH_ORIG . "/" . $slider_options[0]['id'] . "/", $_POST['tmp_picture_name']); /* if (!copy($upload_dir_info . "/" . $_POST['tmp_picture'], FULL_UPLOAD_PATH_ORIG . "/" . $slider_options[0]['id'] . "/" . $_POST['tmp_picture_name'])){ throw new Exception('File can\'t copyed to destination folder!'); } */ /** * Work with thumb */ $thumb_width = $slider_options[0]['thumb_width']; $thumb_height = $slider_options[0]['thumb_height']; /** * Check orientation */ $thumb_check_result = $file->check_orientation($thumb_width, $thumb_height, $upload_dir_info . "/" . $_POST['tmp_picture']); $force_resize_flag = true; /** * Different orientation */ $need_places_thmb = false; if (!$thumb_check_result['check']) { $force_resize_flag = false; $thumb_height = $thumb_check_result['resize_height']; $thumb_width = $thumb_check_result['resize_width']; $need_places_thmb = true; } $file->resize_upload_img($upload_dir_info . "/" . $_POST['tmp_picture'], $picture_name, $thumb_height, $thumb_width, FULL_UPLOAD_PATH_THUMB . "/" . $slider_options[0]['id'] . "/", $force_resize_flag); /** * Centered image on canvas */ if ($need_places_thmb) { $file->center_place_img_to_canvas($slider_options[0]['thumb_width'], $slider_options[0]['thumb_height'], $thumb_check_result['frame_orient'], FULL_UPLOAD_PATH_THUMB . "/" . $slider_options[0]['id'] . "/" . $picture_name); } /** * Work with main picture */ /** * Check orientation */ $check_result = $file->check_orientation($slider_options[0]['width'], $slider_options[0]['height'], $upload_dir_info . "/" . $_POST['tmp_picture']); if ($slider_options[0]['deny_resize_img']) { /** * No resize image */ if ($check_result['check']) { $file->copy_file($upload_dir_info . "/" . $_POST['tmp_picture'], FULL_UPLOAD_PATH . "/" . $slider_options[0]['id'] . "/", $picture_name); } else { /** * however needs correction */ $file->resize_upload_img($upload_dir_info . "/" . $_POST['tmp_picture'], $picture_name, $check_result['resize_height'], $check_result['resize_width'], FULL_UPLOAD_PATH . "/" . $slider_options[0]['id'] . "/", false); $file->center_place_img_to_canvas($slider_options[0]['width'], $slider_options[0]['height'], $check_result['frame_orient'], FULL_UPLOAD_PATH . "/" . $slider_options[0]['id'] . "/" . $picture_name); } } else { /** * Needs resize */ if ($check_result['check']) { $file->resize_upload_img($upload_dir_info . "/" . $_POST['tmp_picture'], $picture_name, $slider_options[0]['height'], $slider_options[0]['width'], FULL_UPLOAD_PATH . "/" . $slider_options[0]['id'] . "/", true); } else { $file->resize_upload_img($upload_dir_info . "/" . $_POST['tmp_picture'], $picture_name, $check_result['resize_height'], $check_result['resize_width'], FULL_UPLOAD_PATH . "/" . $slider_options[0]['id'] . "/", false); $file->center_place_img_to_canvas($slider_options[0]['width'], $slider_options[0]['height'], $check_result['frame_orient'], FULL_UPLOAD_PATH . "/" . $slider_options[0]['id'] . "/" . $picture_name); } } /** * Update picture field */ $wpdb->update($wpdb->prefix . SLIDES_TABLE, array('picture' => $picture_name), array('id' => $slide_id), array('%s'), array('%d')); /** * Delete old picture */ if (!empty($_POST['old_picture']) && $picture_name) { $file->delete_file(FULL_UPLOAD_PATH . "/" . $slider_options[0]['id'] . "/" . $_POST['old_picture']); $file->delete_file(FULL_UPLOAD_PATH_THUMB . "/" . $slider_options[0]['id'] . "/" . $_POST['old_picture']); $file->delete_file(FULL_UPLOAD_PATH_ORIG . "/" . $slider_options[0]['id'] . "/" . $_POST['old_picture']); } /** * Delete tmp picture */ $file->delete_file($upload_dir_info . "/" . $_POST['tmp_picture']); $file->delete_file($upload_dir_info . "/preview_" . $_POST['tmp_picture']); } $wp_session->s_set('errors', $error_statuses); } }
<? PrintMenu(); ?> <P> </P> <P> </P> <P> </P> <?php */ //form_data2table($_GET); $dbconnection = mysql_connect($cohort_db_server, $cohort_db_username, $cohort_db_password); $db_selected = mysql_select_db($cohort_db_name, $dbconnection); if (!$db_selected) { die('Can\'t use ' . $cohort_db_name . ' : ' . mysql_error()); } validate_data('demographic_data', $_GET); $data_array2 = prepare_data('demographic_data', $_GET); if ($_GET['country'] > 0) { $result = execute_query("SELECT Category FROM countries_list WHERE ID='" . $_GET['country'] . "'"); $row = mysql_fetch_array($result); $data_array2['Origin'] = $row[0]; } if ($_GET['has_entry'] == 0) { $query = "SELECT UPPER(LEFT(Name, " . $preferences['num_initials'] . ")), UPPER(LEFT(Surname, " . $preferences['num_initials'] . ")), BirthDate FROM patients WHERE PatientCode = " . $data_array2['PatientCode']; $result = execute_query($query); $row = mysql_fetch_array($result); $data_array2['Name'] = $row[0]; $data_array2['Surname'] = $row[1]; $data_array2['BirthDate'] = $row[2]; mysql_free_result($result); $names = array_keys($data_array2); $sql = "INSERT INTO `demographic_data` ( ";
echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>"; } else { echo "<P>{$what_happened}</P>"; } } } } if ($what_to_store['HasAIDS']) { $what_happened = insert_data("patient_has_aids", $_GET); if ($what_happened == 1) { echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>"; } else { echo "<P>{$what_happened}</P>"; } if ($_GET['HasReappearance'] == 1) { $data_array2 = prepare_data("patient_has_aids_reapperances", $_GET); for ($i = 0; $i < $_GET['num_nosoi_reappear']; $i++) { $sql = ""; $sql .= " INSERT INTO `patient_has_aids_reapperances` ( `PatientCode` , `MELCode` , `NososSymptID`, `NososSymptDiagnosis`, `NososSymptDate` )"; $sql .= " VALUES ( '" . $data_array2['PatientCode'] . "' , '" . $data_array2['MELCode'] . "' , '" . $data_array2['NososSymptID' . $i] . "', '" . $data_array2['NososSymptDiagnosis' . $i] . "', '" . $data_array2['NososSymptDate' . $i] . "' );"; echo "<BR>" . $sql . "<BR><BR>"; $what_happened = execute_query($sql); if ($what_happened == 1) { echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>"; } else { echo "<P>{$what_happened}</P>"; } } } } ?>
<? PrintMenu(); ?> <P> </P> <P> </P> <P> </P> <?php */ $dbconnection = cohortdb_connect($cohort_db_server, $cohort_db_username, $cohort_db_password); $db_selected = mysql_select_db($cohort_db_name, $dbconnection); if (!$db_selected) { die('Can\'t use ' . $cohort_db_name . ' : ' . mysql_error()); } //validate_data("exams_anosologikes", $_GET); check_patient($_GET['PatientCode']); $data_array2 = prepare_data("exams_anosologikes", $_GET); $names = array_keys($data_array2); $sql = ""; for ($k = 0; $k < $_GET['exams']; $k++) { $sql = "INSERT INTO `exams_anosologikes` ( `PatientCode` , `ExamDate` , `AbsoluteLemf` , `AbsoluteCD4` , `PercentCD4` , `AbsoluteCD8` , `PercentCD8`)"; $sql .= " VALUES ('" . $data_array2['PatientCode'] . "', '" . $data_array2['ExamDate' . $k] . "', "; $sql .= "'" . replacecomma($data_array2['AbsoluteLemf' . $k]) . "', '" . replacecomma($data_array2['AbsoluteCD4' . $k]) . "', '" . replacecomma($data_array2['PercentCD4' . $k]); $sql .= "', '" . replacecomma($data_array2['AbsoluteCD8' . $k]) . "', '" . replacecomma($data_array2['PercentCD8' . $k]) . "');"; //echo $sql; $sql = replace2null($sql); $what_happened = execute_query($sql); echo mysql_error(); /* if ($what_happened == 1) { echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>";
{ $dns = dns_get_record($host, DNS_ANY); return $dns; } $i = 0; function prepare_data($array) { if (!is_array($array)) { return "<error>"; } else { $str = array(); foreach ($array as $item) { if (isset($item['ip'])) { $str[] = $item['ip']; } if (isset($item['target'])) { $str[] = $item['target']; } } return join("\t", $str); } } foreach ($zones[1] as $zone) { if (strlen($zone) > 3) { $info = check_dns($zone); $str = $zone . " " . prepare_data($info) . "\n"; file_put_contents("/php/includes/dns.log", $str, FILE_APPEND); echo $i . " " . $str; $i++; } }
function insert_data($table, $data_array) { validate_data($table, $data_array); $data_array2 = prepare_data($table, $data_array); $names = array_keys($data_array2); $sql = "INSERT INTO `" . $table . "` ( "; for ($i = 0; $i < count($data_array2) - 1; $i++) { $sql .= "`" . $names[$i] . "` , "; } $sql .= "`" . $names[$i] . "` ) VALUES ( "; for ($i = 0; $i < count($data_array2) - 1; $i++) { $sql .= "'" . $data_array2[$names[$i]] . "' , "; } $sql .= "'" . $data_array2[$names[$i]] . "' );"; echo $sql; return execute_query($sql); }
} } $place = isset($_GET['place']) ? $_GET['place'] : null; if (is_null($place) || $place == '') { $response['messages'] = get_docs(); echo json_encode($response); die; } if (!array_key_exists($place, $places)) { $response['messages'] = get_docs(); echo json_encode($response); die; } $latlong = $places[$place]; list($method, $year, $latitude, $longitude, $timeZone) = array(5, $today['year'], $latlong[0], $latlong[1], 8); $prayTime = new PrayTime($method); if (isset($_GET['monthly']) && $_GET['monthly'] != "" && $_GET['monthly'] == 1) { $date = strtotime($year . '-' . $today['mon'] . '-1'); $endDate = strtotime($year . '-' . ($today['mon'] + 1) . '-1'); prepare_data($date, $endDate, $latitude, $longitude, $timeZone, $prayTime, $arr); } elseif (isset($_GET['anually']) && $_GET['anually'] != "" && $_GET['anually'] == 1) { $date = strtotime($year . '-1-1'); $endDate = strtotime($year + 1 . '-1-1'); prepare_data($date, $endDate, $latitude, $longitude, $timeZone, $prayTime, $arr); } else { $date = strtotime($year . '-' . $today['mon'] . '-' . $today['mday']); $endDate = strtotime($year . '-' . $today['mon'] . '-' . ($today['mday'] + 1)); prepare_data($date, $endDate, $latitude, $longitude, $timeZone, $prayTime, $arr); } $response['data'] = $arr; echo json_encode($response);
<?php PrintMenu(); ?> <P> </P> <P> </P> <P> </P> <?php $dbconnection = cohortdb_connect($cohort_db_server, $cohort_db_username, $cohort_db_password); $db_selected = mysql_select_db($cohort_db_name, $dbconnection); if (!$db_selected) { die('Can\'t use ' . $cohort_db_name . ' : ' . mysql_error()); } check_patient($_GET['PatientCode']); $data_array2 = prepare_data("exams_ourwn", $_GET); $names = array_keys($data_array2); //print_r($_GET); //print_r($data_array2); $sql = ""; for ($k = 0; $k < $_GET['exams']; $k++) { $sql = "INSERT INTO `exams_ourwn` ( `PatientCode` , `ExamDate` , `EB` , `Leukwma` , `Leukwma_extra` , `Puosfairia`, `Eruthra`, `Kulindroi`)"; $sql .= " VALUES ('" . $data_array2['PatientCode'] . "', '" . $data_array2['ExamDate' . $k]; $sql .= "', '" . $data_array2['EB' . $k] . "', '" . $data_array2['Leukwma' . $k] . "', '" . $data_array2['Leukwma_extra' . $k] . "', '" . $data_array2['Puosfairia' . $k]; $sql .= "', '" . $data_array2['Eruthra' . $k] . "', '" . $data_array2['Kulindroi' . $k] . "');"; echo $sql; $sql = replace2null($sql); echo $sql; $what_happened = execute_query($sql); if ($what_happened == 1) { echo "<P>Τα δεδομένα καταχωρήθηκαν με επιτυχία!</P>";