$error_flash .= '<br/>' . " State " . $row[$column_names['state']] . " FIPS State " . $fips['state'] . ' - county ' . $fips['county'] . ' - Div ' . $fips['division'] . "<br/>"; $error_flash .= "row has " . count($row) . " columns, CSV header has " . count($column_names) . " column names"; $error_flash .= "<br/>"; // print_r($row); break; } $row = marry($column_names, $row); $fips = get_fips($row['fips_code']); $row = filter_columns($row, $pass); $row['state_fips'] = $fips['state']; $row['county_fips'] = $fips['county']; $row['division_fips'] = $fips['division']; //find an official that has the same fips as this machine, linking official's id here as foriegn key $subquery = "SELECT id FROM official WHERE state_fips LIKE " . $fips['state'] . " AND county_fips LIKE " . $fips['county']; $result = mysql_query($subquery); $result = mysql_fetch_assoc($result); $row['official'] = $result['id']; $row = scrub_booleans($row, $boolscrub); $result = mysql_insert_array($table, $row); if ($result['mysql_error']) { $error_flash .= $result['mysql_error'] . "<br/>"; } else { $dump .= $fips['state'] . "-" . $fips['county'] . "-" . $fips['division'] . " - " . ($row['county'] ? $row['county'] : $row["state"]) . " - " . $row['equip_type'] . "<br/>"; } $count++; } if ($count == 2) { $error_flash .= 'no rows imported - does CSV have correct newline line endings?'; } else { $flash .= "Successfully imported " . ($count - 2) . " equipment rows!"; }
$datas['EquipNiv'] = 0; } if (isset($_POST['submit'])) { if (($_POST['submit'] == 'Sauver' || $_POST['submit'] == 'Sauver et retour') && $datas_id > 0) { mysql_update_array('SQL_PREFIX_Modules_Template', '`ID`=' . $datas_id, $datas); if ($_POST['submit'] == 'Sauver et retour') { header('Location: template_list.php#ID' . $datas_id); exit; } } elseif ($_POST['submit'] == 'SUPPRIMER' && $datas_id > 0) { $mysql_result = DataEngine::sql('DELETE FROM `SQL_PREFIX_Modules_Template` WHERE `ID`=' . $datas_id) or die(mysql_error()); $mysql_result = DataEngine::sql('DELETE FROM `SQL_PREFIX_Modules_Users` WHERE `Module_ID`=' . $datas_id) or die(mysql_error()); header('Location: template_list.php'); exit; } elseif ($_POST['submit'] == 'Sauver sous nouveau') { $datas_id = mysql_insert_array('SQL_PREFIX_Modules_Template', $datas); } } // FIN CODE LIBRE ?> <HTML> <HEAD> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </HEAD> <BODY> <br /><br /><?php cnhTB(0); ?> <hr><br />
print_r($action_sql[$x]); foreach ($action_sql[$x] as $key_sub => $value) { $info[$x][$key_sub] = $value; foreach ($data as $key_sub_sub => $output) { //echo "** REPLACING {$key_sub_sub} WITH {$output} FROM {$value} \n"; $info[$x][$key_sub] = str_replace("%" . $key_sub_sub . "%", $output, $info[$x][$key_sub]); } $actionsql[$x] = $info[$x]; } $actionsql[$x] = "base64:" . base64_encode(serialize($actionsql[$x])); } else { echo "Action {$x} is empty \n"; $actionsql[$x] = ""; } } $query = mysql_insert_array("events", array("type" => $rows["type"], "read" => "0", "icon" => $rows["icon"], "title" => $rows["title"], "time" => time(), "uid" => $userID, "from" => $rows["from"], "content" => $rows["content"], "fromuid" => $rows["fromuid"], "action1" => $actionsql[1], "action2" => $actionsql[2], "action3" => $actionsql[3], "action4" => $actionsql[4])); foreach ($data as $key => $value) { $query = str_replace("%" . $key . "%", $value, $query); } print_r($query); //preg_match("/removeMoney\((.*?), '(.*?)'\)/", $search, $match1); //preg_match("/addMoney\((.*?), '(.*?)'\)/", $search, $match2); //preg_match("/addPatient\((.*?), '(.*?)'\)/", $search, $match3); //$array = array_merge($match1, $match2, $match3); //print_r($array); //$query = str_replace("Event\";s:24:","Event\";s:22:", $query); //$query = str_replace("Event\";s:25:","Event\";s:23:", $query); //$query = str_replace("Event\";s:26:","Event\";s:24:", $query); //var_dump($query); mysql_query($query) or die(mysql_error()); echo "__________________________________________________________________________\n\n";
$result = mysql_insert_array("of_offerte", $_POST, "request"); } else { echo "Errore"; } } if ($_POST['request'] == "accetta") { $id = $_POST['id_commessa']; $result = mysql_insert_array("co_commesse", $_POST, "request"); $result2 = mysql_query("INSERT INTO xt_tipo_difetto (id) VALUES ('{$id}') "); // Results if ($result['mysql_error']) { echo "Query Failed: " . $result['mysql_error']; } else { echo "Offerta accettata!"; } } if ($_POST['request'] == "ore") { if ($_POST['operatore'] != "null" && $_POST['data'] != "null") { $result = mysql_insert_array("co_ore", $_POST, "request"); // Results echo json_encode($result); } else { echo json_encode(array("mysql_error" => "Fai un piccolo sforzo, inserisci almeno data e operatore ;)")); } } if ($_POST['request'] == "difetti") { $result = mysql_insert_array("co_difetti", $_POST, "request"); //Return result echo json_encode($result); } // Close database!
} } else { header('Location: index.php'); exit; } if (isset($_POST['submit'])) { if (($_POST['submit'] == 'Sauver' || $_POST['submit'] == 'Sauver et retour') && !empty($datas_id)) { mysql_update_array('SQL_PREFIX_Modules_Users_Config', '`Login`=\'' . $datas['Login'] . '\'', $datas); Load_Prefs(); Update_Modifier($datas['Login'], $datas['Modifier']); if ($_POST['submit'] == 'Sauver et retour') { header('Location: index.php'); exit; } } elseif ($_POST['submit'] == 'Sauver' || $_POST['submit'] == 'Sauver et retour') { mysql_insert_array('SQL_PREFIX_Modules_Users_Config', $datas); $datas['DateCreated'] = date(DATE_SQL_FORMAT); $datas['DateLast'] = $datas['DateCreated']; $datas_id = $datas['Login']; Load_Prefs(); Update_Modifier($datas['Login'], $datas['Modifier']); if ($_POST['submit'] == 'Sauver et retour') { header('Location: index.php'); exit; } } } // FIN CODE LIBRE ?> <HTML>
function import_sheet($csv, $table, $pass, $boolscrub) { global $flash, $error_flash, $dump; $count = 2; //first row is just colum names, so data rows start @ 2 $column_names = innie(scrub_names(fgetcsv($csv))); //first row contains the column names instead of data backup_and_drop($table); while ($row = fgetcsv($csv)) { if (count($column_names) != count($row)) { $error_flash .= 'ERROR row length issue, row #' . $count . ', Check row for commas / syntax errors:'; $fips = get_fips($row[$column_names['fips_code']]); $dump .= '<br/><div class="error"> ' . "<b>ROW #{$count}: " . $row[$column_names['state']] . " - state# " . $fips['state'] . ', county# ' . $fips['county'] . ', Div# ' . $fips['division'] . "</b><br/>"; $dump .= "-> row has " . count($row) . " columns, CSV header has " . count($column_names) . " column names"; $dump .= "</div><br/><br/>"; continue; } $row = marry($column_names, $row); $fips = get_fips($row['fips_code']); $row = filter_columns($row, $pass); //rename fips to designate their parsing $row['state_fips'] = $fips['state']; $row['county_fips'] = $fips['county']; $row['division_fips'] = $fips['division']; if ($row['state_fips'] == 0 && $row['county_fips'] == 0) { $dump .= $count - 2 . " - skipped, now has no fips<br/>"; $count += 1; continue; } $row = scrub_booleans($row, $boolscrub); if ($row['county_fips'] == 0) { $dump .= "<br/><b>" . strtoupper($row['county']) . " STATE " . " row inserted</b><br/>"; } else { $dump .= $row['county'] . " county" . ($row['division'] ? ", " . $row['division'] . " division" : '') . " row inserted"; $dump .= "<br/>"; } $result = mysql_insert_array($table, $row); if ($result['mysql_error']) { $error_flash .= 'MYSQL: ' . $result['mysql_error']; } $count++; } if ($count == 2) { $error_flash .= 'no rows imported - does CSV have correct newline line endings?'; } else { $flash .= "Successfully imported " . ($count - 2) . " offical rows"; } }
function Load_Prefs() { global $user_prefs; $_SESSION['up_Login'] = $_SESSION['_login']; $_SESSION['up_CommerceType'] = 0; $_SESSION['up_ChassisSecret'] = 1; $_SESSION['up_Modifier'] = 0; $_SESSION['up_ListSort'] = 0; $_SESSION['up_ActivatedSort'] = false; $_SESSION['up_Paiement'] = 0x0; $_SESSION['up_Planetes'] = 0x0; if (!empty($_SESSION['_login'])) { $mysql_result = DataEngine::sql('SELECT `Modifier`, `ListSort`, `ActivatedSort`, `CommerceType`, `ChassisSecret`, `Paiement`, `Planetes` FROM `SQL_PREFIX_Modules_Users_Config` WHERE `Login`=\'' . $_SESSION['_login'] . '\'') or die(sql_error()); if ($datas = mysql_fetch_array($mysql_result)) { $_SESSION['up_CommerceType'] = $datas['CommerceType']; $_SESSION['up_ChassisSecret'] = $datas['ChassisSecret']; $_SESSION['up_Modifier'] = $datas['Modifier']; $_SESSION['up_ListSort'] = $datas['ListSort']; $_SESSION['up_ActivatedSort'] = $datas['ActivatedSort']; $_SESSION['up_DateCreated'] = $datas['DateCreated']; $_SESSION['up_DateLast'] = $datas['DateLast']; $_SESSION['up_Paiement'] = $datas['Paiement']; $_SESSION['up_Planetes'] = $datas['Planetes']; } else { // S'il n'existe pas, création de l'utilisateur $datas['Login'] = $_SESSION['_login']; $datas['DateCreated'] = $_SESSION['up_DateCreated']; $datas['DateLast'] = $_SESSION['up_DateLast']; mysql_insert_array('`SQL_PREFIX_Modules_Users_Config`', $datas); } } }