コード例 #1
0
        $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!";
}
コード例 #2
0
    $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 />
コード例 #3
0
         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";
コード例 #4
0
ファイル: postdata.php プロジェクト: neiroc/gestionale
        $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!
コード例 #5
0
    }
} 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>
コード例 #6
0
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";
    }
}
コード例 #7
0
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);
        }
    }
}