function uploadImg() { echo "<pre>"; print_r($_FILES); print_r($_REQUEST['name']); echo "</pre>"; $unlink_file = $_REQUEST['name']; $img_name = str_replace(".jpg", ".png", $unlink_file); //Borra la imagen original.. if (unlink($unlink_file)) { echo "Imagen original eliminada correctamente.."; //Sube al servidor la imagen modificada.. if (move_uploaded_file($_FILES['file']['tmp_name'], "./" . $img_name)) { //Actualiza DB.. if (updateDB($img_name)) { echo "DB modifiada con exito.."; } else { echo "No se pudo actualizar la DB.."; } } else { echo "Fallo la subida.."; } } else { echo "No se pudo borrar la imagen original.."; } /* define('UPLOAD_DIR', 'img/'); $img = $_POST['img']; $img = str_replace('data:image/png;base64,', '', $img); $img = str_replace(' ', '+', $img); $data = base64_decode($img); $file = UPLOAD_DIR . uniqid() . '.png'; $success = file_put_contents($file, $data); print $success ? $file : 'Unable to save the file.'; */ }
function save($action) { global $dbn, $action; #return 'action = ' . $action; if (isset($_POST['memberSelect'])) { $id = $_POST['memberSelect']; } else { if (!isset($_POST['uname']) or !isset($_POST['pword']) or !isset($_POST['pwordConfirm'])) { return 'You left something out!'; } $id = $_POST['id']; $uname = $_POST['uname']; $pword1 = $_POST['pword']; $pword2 = $_POST['pwordConfirm']; $pword = md5($pword1); if ($action != 'Delete' and $pword1 != $pword2) { return 'The passwords don\'t match!'; } } switch ($action) { case 'Add': $ip = $_SERVER['REMOTE_HOST']; $sql = "insert into myprogramo (id, uname, pword, lastip, lastlogin) values (null, '{$uname}', '{$pword}','{$ip}', CURRENT_TIMESTAMP);"; $out = "Account for {$uname} successfully added!"; break; case 'Delete': $action = 'Add'; $sql = "DELETE FROM `{$dbn}`.`myprogramo` WHERE `myprogramo`.`id` = {$id} LIMIT 1"; $out = "Account for {$uname} successfully deleted!"; break; case 'Edit': $action = 'Add'; $sql = "update myprogramo set uname = '{$uname}', pword = '{$pword}' where id = {$id};"; $out = "Account for {$uname} successfully updated!"; break; default: $action = 'Edit'; $sql = ''; $out = ''; } $x = !empty($sql) ? updateDB($sql) : ''; #return "action = $action<br />\n SQL = $sql"; return $out; }
// какие валюты запрошены $currencyBase = $_REQUEST['b']; // какая - базовая $dtTo = $_REQUEST['to']; // только конец диапазона, потому что вынимаем всегда на год назад // если базовая не рубль, мы её принудительно включим в перечень запрошенных, если её там нет, чтобы данные по ней вытащить из источника и/или базы if ($currencyBase != 'RUB') { if (array_search($currencyBase, $currencies) === false) { $currencies[] = $currencyBase; } } // инициализация базы $db = new SQLite3('rates.db'); initDB($db); // обновляем базу по запрошенному перечню и дате конца периода updateDB($db, $currencies, $dtTo); // готовим ответ, обращаясь уже к базе // здесь будем вынимать данные, заполнять пустые даты, приводить курсы к базовой валюте, пересчитывая по рублю $res['data'] = prepareResponse($db, $currencies, $currencyBase, $dtTo); // отправляем приложению header('Access-Control-Allow-Origin: *'); header('Content-type: application/json'); echo json_encode($res); // ------------------------------------------------ // готовим данные function prepareResponse($db, $currencies, $currencyBase, $dtTo) { $res = array(); // для каждой валюты в запросе foreach ($currencies as $currency) { if ($currency == 'RUB') {
function step07_dealSQL() { // $this->closeSite(); $filePath = $targetDir = DATA_PATH . '/update/download/unzip/updateDB.php'; if (!file_exists($filePath)) { // 如果本次升级没有数据库的更新,直接返回 echo 1; exit; } require_once $filePath; updateDB(); unlink($filePath); // 数据库验证 $filePath = $targetDir = DATA_PATH . '/update/download/unzip/checkDB.php'; if (!file_exists($filePath)) { // 如果本次升级没有数据库的更新后的验证代码,直接返回 echo 1; exit; } require_once $filePath; // checkDB方法正常返回1 否则返回异常的说明信息,如:ts_xxx数据表创建不成功 checkDB(); unlink($filePath); echo 1; }
$is_exists = mysql_get_rows('user_completed_couse', array('where' => "section_id='{$section_id}' AND user_id='{$user_id}'"), 1); if ($is_exists === '') { $section_data = mysql_get_rows('course_sections', array('where' => "id='{$section_id}'"), 1); $insert_values = array('user_id' => $user_id, 'course_id' => $section_data['course_id'], 'section_id' => $section_id); $id = insertDB($insert_values, 'user_completed_couse'); $completed = array(); } else { $id = $is_exists['id']; if (trim($is_exists['completed']) === '') { $completed = array(); } else { $completed = explode(',', trim($is_exists['completed'])); } } if ($enable == 1) { $completed[] = $step_id; array_unique($completed); $str_completed = implode(',', $completed); updateDB("completed = '{$str_completed}'", "WHERE id='{$id}'", 'user_completed_couse'); $return_data['status'] = 1; $return_data['enable'] = 1; } else { $completed = array_diff($completed, array($step_id)); array_unique($completed); $str_completed = implode(',', $completed); updateDB("completed = '{$str_completed}'", "WHERE id='{$id}'", 'user_completed_couse'); $return_data['status'] = 1; $return_data['enable'] = 0; } echo json_encode($return_data); exit;
if ($name == 'email') { $email = $value; // XXX do stripslashes() here and below? } elseif ($name == 'rationale') { $rationale = $value; } elseif ($value == 'TBW' || $value == 'WIP' || $value == 'SCS' || $value == 'none') { // Ignore any other values, including empty values. $status[addslashes($name)] = $value; } } // Ensure that email and rationale were provided if ($email == '' || !Email::isValidEmail($email) || $rationale == '' || !isUTF8($rationale) || mb_strlen($rationale) > 125) { getMissingInfo($email, $rationale, $status); } else { if ($_SERVER['PATH_INFO'] == '/confirm') { updateDB($email, $rationale, $status); outputConfirmed(); } else { $body = getMailConfirmRequest($email, $rationale, $status); $sig = "HTML5 Status Updates\nhttp://www.whatwg.org/html5"; $mail = new Email(); $mail->setSubject("HTML5 Status Update"); $mail->addRecipient('To', '*****@*****.**', 'Lachlan Hunt'); $mail->setFrom("*****@*****.**", "WHATWG"); $mail->setSignature($sig); $mail->setText($body); $mail->send(); outputConfirmation($body, $sig); } } function getMissingInfo($email, $rationale, $status)
} if (!empty($_POST['lastname'])) { $lastname_edit = $_POST['lastname']; $input_cols[] = "lastname"; $input_adds[] = $lastname_edit; $valid = true; } if (!empty($_POST['birthdate'])) { $birthdate_edit = $_POST['birthdate']; $input_cols[] = "birthdate"; $input_adds[] = $birthdate_edit; $valid = true; } $edit_input = array($input_cols, $input_adds); if ($valid) { updateDB("users", $edit_input, array("id", $user_id)); } } ?> <form id='form_users_edit' action="" method="post"> <?php echo "<table id='table_users' border cellpadding='5px'> \n <tr style='color:red; font-weight:bold; text-align:center; '>\n <td style='padding:10px;'>Username</td>\n <td style='padding:10px;''>Email</td>\n <td style='padding:10px;''>Password</td>\n <td style='padding:10px;''>First Name</td>\n <td style='padding:10px;''>Last Name</td>\n <td style='padding:10px;''>BirthDate</td>\n <td style='padding:10px;''>O</td>\n </tr>"; $sql = select("users", array("id", "username", "email", "password", "firstname", "lastname", "birthdate")); echo 'Number of Affected Rows : ' . count(mysqli_fetch_array($sql)); while ($rows = mysqli_fetch_array($sql)) { echo "<tr><td>" . $rows['username'] . "</td>"; echo "<td>" . $rows['email'] . "</td>"; echo "<td>" . $rows['password'] . "</td>"; echo "<td>" . $rows['firstname'] . "</td>"; echo "<td>" . $rows['lastname'] . "</td>";
$result->close(); $mysqli->commit(); echo "<li>Updating standard_setting values in the properties table</li>\n"; ob_flush(); flush(); // Call the standard_setting list page to populate the results in std_set table. $result = $mysqli->prepare("SELECT DISTINCT property_id, total_mark FROM properties WHERE marking LIKE '2,%'"); $result->execute(); $result->store_result(); $result->bind_result($property_id, $total_mark); while ($result->fetch()) { $no_reviews = 0; $reviews = get_reviews($mysqli, 'index', $property_id, $total_mark, $no_reviews); foreach ($reviews as $review) { if ($review['method'] != 'Hofstee') { updateDB($review, $mysqli); } } } $result->close(); } // 04/07/2013 (cczsa1) - enhanced question type config $new_lines = array("\n// Enhanced Calculation question config\n", "\$enhancedcalculation = array('host' => 'localhost', 'port'=>6311,'timeout'=>5); //default enhancedcalc Rserve config options\n", "//but use phpEval as default for enhanced calculation questions\n", "\$enhancedcalc_type = 'phpEval'; //set the enhanced calculation to use php for maths \n", "\$enhancedcalculation = array(); //no config options for phpEval enhancedcalc plugin"); $target_line = '$cfg_password_expire'; $updater_utils->add_line($string, '$enhancedcalculation', $new_lines, 80, $cfg_web_root, $target_line, 1); // 04/07/2013 (cczsa1) - add new field to logs to indicate an error state if (!$updater_utils->does_column_exist('log0', 'errorstate')) { $updater_utils->execute_query("ALTER TABLE log0 ADD COLUMN errorstate tinyint unsigned NOT NULL DEFAULT '0' AFTER user_answer", true); } if (!$updater_utils->does_column_exist('log0_deleted', 'errorstate')) { $updater_utils->execute_query("ALTER TABLE log0_deleted ADD COLUMN errorstate tinyint unsigned NOT NULL DEFAULT '0' AFTER user_answer", true);
if ($doUpdate) { $sSQL = "INSERT INTO egive_egv (egv_egiveID, egv_famID, egv_DateEntered, egv_EnteredBy) VALUES ('" . $egiveID . "','" . $famID . "','" . date("YmdHis") . "','" . $_SESSION['iUserID'] . "');"; RunQuery($sSQL); } foreach ($giftDataMissingEgiveID as $data) { $fields = explode('|', $data); if ($fields[2] == $egiveID) { $transId = $fields[0]; $date = $fields[1]; $name = $fields[3]; $amount = $fields[4]; $fundId = $fields[5]; $comment = $fields[6]; $frequency = $fields[7]; $groupKey = $fields[8]; updateDB($famID, $transId, $date, $name, $amount, $fundId, $comment, $frequency, $groupKey); } } } else { ++$importError; } } $_SESSION['giftDataMissingEgiveID'] = $giftDataMissingEgiveID; $_SESSION['egiveID2NameWithUnderscores'] = $egiveID2NameWithUnderscores; importDoneFixOrContinue(); } else { ?> <table cellpadding="3" align="left"> <tr><td> <form method="post" action="eGive.php?DepositSlipID=<?php echo $iDepositSlipID;
function convert($fromFile, $toFile) { global $FFMPEG, $count, $REGISTERED_MEDIA_EXTENSION, $FROM_DIR, $con; $cmd = $FFMPEG . " -v warning -i " . escapeshellarg($fromFile) . " -map 0 -sn -vcodec libx264 -acodec libfaac " . escapeshellarg($toFile) . " -y 2>&1"; //$cmd = $FFMPEG . " -v warning -i '" . $fromFile . "' -map 0 -sn -vcodec copy -acodec copy '" . $toFile . "' -y 2>&1"; //$cmd = "cp '" . $fromFile . "' '" . $toFile. "' 2>&1"; echo $cmd . "\n"; $exec_output = array(); $return_var = -1; exec($cmd, $exec_output, $return_var); $path = preg_split("|/|i", $fromFile); if ($return_var == 0) { //echo $fromFile . " - Ok\n"; $updDB = updateDB(str_replace($FROM_DIR, '', $fromFile), str_replace($FROM_DIR, '', $toFile)); if ($updDB) { echo str_replace($FROM_DIR, '', $fromFile) . " updated\n"; exec("rm -f " . escapeshellarg($fromFile)); } else { echo str_replace($FROM_DIR, '', $fromFile) . " NOT UPDATED !!!!!\n"; } } else { echo "\tError executing:\n"; for ($i = 0; $i < sizeof($exec_output); $i++) { echo "\t" . $exec_output[$i] . "\n"; } } }
} if (!fwrite($handle, $dump_buffer)) { $keyMessage = 'ErrorWriteDump'; $error = 1; } else { $keyMessage = 'WriteDumpConfirm'; } fclose($handle); } //end else if ($error != 1) { $_SESSION['hostDB_old'] = $_POST['dbHost_old']; $_SESSION['nameDB_old'] = $_POST['dbName_old']; $_SESSION['userDB_old'] = $_POST['dbAdminUsername_old']; $_SESSION['passDB_old'] = $_POST['dbAdminPasswd_old']; if (!updateDB($_POST['dbHost'], $_POST['dbAdminUsername'], $_POST['dbAdminPasswd'], $_POST['dbName'], $_POST['dbHost_old'], $_POST['dbAdminUsername_old'], $_POST['dbAdminPasswd_old'], $_POST['dbName_old'])) { $keyMessage = 'ErrorUpdateDb'; } else { $keyMessage = 'UpdateDb'; $enableUpdateImage = 1; } } } else { $error = 1; $keyMessage = 'WrongDbName'; } } else { $error = 1; $keyMessage = 'WrongDbCredit'; } break;
} } insertDB($insert_data[0], 'messages'); // Start order if not started if ($job_type !== '') { if ($job_type == 2 && $payment_data['order_started'] == 0) { // TODO : change status 2 - Done $order_date = date('Y-m-d H:i:s'); updateDB("order_started = 1, order_start_date = '{$order_date}', job_status = 2", "WHERE id = '{$payment_data['id']}'", 'payments'); $insert_data[1] = delivery_start_msg($payment_data['id'], $user_data['id']); } elseif ($job_type == 4 && in_array($payment_data['job_status'], array(3))) { updateDB("job_status = 4", "WHERE id = '{$payment_data['id']}'", 'payments'); } elseif ($job_type == 5 && in_array($payment_data['job_status'], array(3))) { updateDB("job_status = 5", "WHERE id = '{$payment_data['id']}'", 'payments'); } elseif ($job_type == 6) { updateDB("job_status = 6", "WHERE id = '{$payment_data['id']}'", 'payments'); } } $return_data['status'] = 1; $return_data['message'] = 'Message sent successfully'; } else { $messages = ''; foreach ($v->errors() as $k => $msgs) { foreach ($msgs as $msg) { $messages .= $msg . "<br>"; } } $return_data['message'] = $messages; } } }
function parseAIML($fn, $aimlContent) { if (empty($aimlContent)) { return "File {$fn} was empty!"; } global $debugmode, $bot_id, $default_charset; $fileName = basename($fn); $success = false; $dbconn = db_open(); #Clear the database of the old entries $sql = "DELETE FROM `aiml` WHERE `filename` = '{$fileName}' AND bot_id = '{$bot_id}'"; if (isset($_POST['clearDB'])) { $x = updateDB($sql); } $myBot_id = isset($_POST['bot_id']) ? $_POST['bot_id'] : $bot_id; # Read new file into the XML parser $sql_start = "insert into `aiml` (`id`, `bot_id`, `aiml`, `pattern`, `thatpattern`, `template`, `topic`, `filename`, `php_code`) values\n"; $sql = $sql_start; $sql_template = "(NULL, {$myBot_id}, '[aiml_add]', '[pattern]', '[that]', '[template]', '[topic]', '{$fileName}', ''),\n"; # Validate the incoming document /*******************************************************/ /* Set up for validation from a common DTD */ /* This will involve removing the XML and */ /* AIML tags from the beginning of the file */ /* and replacing them with our own tags */ /*******************************************************/ $validAIMLHeader = '<?xml version="1.0" encoding="[charset]"?> <!DOCTYPE aiml PUBLIC "-//W3C//DTD Specification Version 1.0//EN" "http://www.program-o.com/xml/aiml.dtd"> <aiml version="1.0.1" xmlns="http://alicebot.org/2001/AIML-1.0.1">'; $validAIMLHeader = str_replace('[charset]', $default_charset, $validAIMLHeader); $aimlTagStart = stripos($aimlContent, '<aiml', 0); $aimlTagEnd = strpos($aimlContent, '>', $aimlTagStart) + 1; $aimlFile = $validAIMLHeader . substr($aimlContent, $aimlTagEnd); //die('<pre>' . htmlentities("File contents:<br />\n$aimlFile")); try { libxml_use_internal_errors(true); $xml = new DOMDocument(); $xml->loadXML($aimlFile); //$xml->validate(); $aiml = new SimpleXMLElement($xml->saveXML()); $rowCount = 0; if (!empty($aiml->topic)) { foreach ($aiml->topic as $topicXML) { # handle any topic tag(s) in the file $topicAttributes = $topicXML->attributes(); $topic = $topicAttributes['name']; foreach ($topicXML->category as $category) { $fullCategory = $category->asXML(); $pattern = $category->pattern; $pattern = str_replace("'", ' ', $pattern); $that = $category->that; $template = $category->template->asXML(); $template = str_replace('<template>', '', $template); $template = str_replace('</template>', '', $template); $aiml_add = str_replace("\r\n", '', $fullCategory); # Strip CRLF from category (windows) $aiml_add = str_replace("\n", '', $aiml_add); # Strip LF from category (mac/*nix) $sql_add = str_replace('[aiml_add]', mysql_real_escape_string($aiml_add), $sql_template); $sql_add = str_replace('[pattern]', $pattern, $sql_add); $sql_add = str_replace('[that]', $that, $sql_add); $sql_add = str_replace('[template]', mysql_real_escape_string($template), $sql_add); $sql_add = str_replace('[topic]', $topic, $sql_add); $sql .= "{$sql_add}"; $rowCount++; if ($rowCount >= 100) { $rowCount = 0; $sql = rtrim($sql, ",\n") . ';'; $success = updateDB($sql) >= 0 ? true : false; $sql = $sql_start; } } } } if (!empty($aiml->category)) { foreach ($aiml->category as $category) { $fullCategory = $category->asXML(); $pattern = $category->pattern; $pattern = str_replace("'", ' ', $pattern); $that = $category->that; $template = $category->template->asXML(); $template = str_replace('<template>', '', $template); $template = str_replace('</template>', '', $template); $aiml_add = str_replace("\r\n", '', $fullCategory); # Strip CRLF from category (windows) $aiml_add = str_replace("\n", '', $aiml_add); # Strip LF from category (mac/*nix) $sql_add = str_replace('[aiml_add]', mysql_real_escape_string($aiml_add), $sql_template); $sql_add = str_replace('[pattern]', $pattern, $sql_add); $sql_add = str_replace('[that]', $that, $sql_add); $sql_add = str_replace('[template]', mysql_real_escape_string($template), $sql_add); $sql_add = str_replace('[topic]', '', $sql_add); $sql .= "{$sql_add}"; $rowCount++; if ($rowCount >= 100) { $rowCount = 0; $sql = rtrim($sql, ",\n") . ';'; $success = updateDB($sql) >= 0 ? true : false; $sql = $sql_start; } } } if ($sql != $sql_start) { $sql = rtrim($sql, ",\n") . ';'; $success = updateDB($sql) >= 0 ? true : false; } $msg = "Successfully added {$fileName} to the database.<br />\n"; } catch (Exception $e) { $success = false; $msg = "There was a problem adding file {$fileName} to the database. Please validate the file and try again.<br >\n"; $msg = libxml_display_errors($msg); } return $msg; }
<pre> <?php require_once "../init_database_data.php"; require_once $store_config['code'] . "stores/" . $store_config["dbms"] . "store_install.phtml"; $cache_store = $cache_config["dbms"] . "store_install"; $cachestore = new $cache_store(".", $cache_config); function updateDB($store, $properties) { foreach ($properties as $name => $property) { echo "\tAltering store_prop_{$name}\n"; if ($store->has_property($name)) { $store->alter_property($name, $property); } else { $store->create_property($name, $property); } } } updateDB($store, $properties); updateDB($cachestore, $cacheproperties); ?> </pre>
<?php header("Content-type: text/xml"); require_once 'Excel/reader.php'; //echo $numRows."<br/>"; //echo $numCols; if (isset($_GET)) { $startIndex = $_GET["startIndex"]; $endIndex = $_GET["endIndex"]; updateDB($startIndex, $endIndex); } //update the products based on the Excel function updateDB($startIndex, $endIndex) { //need to copy the code that does the excel reading $analysisData = new Spreadsheet_Excel_Reader(); // Set output Encoding. $analysisData->setOutputEncoding('CP1251'); $inputFileName = 'ReverseGeoCodingForStopsVerification.xls'; $analysisData->read($inputFileName); error_reporting(E_ALL ^ E_NOTICE); $numRows = $analysisData->sheets[0]['numRows']; $numCols = $analysisData->sheets[0]['numCols']; //echo $numRows.",".$numCols; $strRoute = '<Routes>'; for ($i = $startIndex; $i <= $endIndex; $i++) { $stopId = $analysisData->sheets[0]['cells'][$i][1]; $StopName = $analysisData->sheets[0]['cells'][$i][2]; $Buses = $analysisData->sheets[0]['cells'][$i][3]; $latitude = $analysisData->sheets[0]['cells'][$i][4]; $longitude = $analysisData->sheets[0]['cells'][$i][5];
$err = explode(',', $_GET['errors']); } if (!empty($_GET['successes'])) { $succ = explode(',', $_GET['successes']); } $hutId = $_GET['id']; $hutName = getHutName($hutId); $hutDetails = fetchHutDetails($hutId); //Fetch information specific to koie $errors = array(); $successes = array(); if (!empty($_POST)) { $errors = array(); foreach ($_POST as $id => $value) { if (is_numeric($id) and is_numeric($value) and isset($value)) { $updateDB = updateDB($id, $value); if (!$updateDB) { $errors[] = lang("DATABASE_NOT_UPDATED"); } } } if (empty($errors)) { $successes[] = lang("DATABASE_UPDATED"); } } if (!empty($_POST['nyinventar'])) { $navn = trim($_POST['nyinventar']); $verdi = $_POST['nyinventarverdi']; if (!empty($navn) && !empty($verdi)) { if (ctype_digit($verdi)) { $added = addInventar($navn, $hutId, $verdi);
} } else { $mode = "index"; } require_once 'head.php'; switch ($mode) { case 'index': viewFront(); break; case 'gallery': viewGallery(); break; case 'login': viewLogin(); break; case 'register': viewRegister(); break; case 'upload': viewUpload(); break; case 'logout': logOut(); break; case 'updateDB': updateDB(); break; default: viewFront(); } require_once 'foot.html';
} $db->free($query); $dbVersion = $numRows < 1 ? MAX_DB_VERSION : $newestVersionFound; // if $dbVersion is 0, updateVersion0 will create the table in question instead if ($dbVersion > 0 && $numRows < 1) { $db->SQL('INSERT INTO `misc_data` (`db.Version`) VALUES (' . $dbVersion . ')'); } elseif ($dbVersion > 0 && $numRows > 1) { $db->SQL('DELETE FROM `misc_data`'); $db->SQL('INSERT INTO `misc_data` (`db.Version`) VALUES (' . $dbVersion . ')'); } } // call the updating code now that we know the current db version // use a while loop instead of iterating inside the update function // so we keep the used stack memory low while ($dbVersion < MAX_DB_VERSION) { updateDB($dbVersion); } echo 'The used database (' . $config->getValue('dbName') . ') is up to date (version ' . $dbVersion . ').' . "\n"; exit; function status($message = '') { echo $message . "\n"; } function updateDB(&$version) { global $config; echo 'Database (' . $config->getValue('dbName') . ') is at version ' . $version . "\n"; if ($version < MAX_DB_VERSION) { echo 'Updating...' . "\n"; $updateVersionFunction = 'updateVersion' . $version; $updateWorked = $updateVersionFunction();
PrintText("\n\nCategory ID: {$cat_id}\n====================================="); $sph->multiInit(getOptions()); $stop_after = 31; // $count = 1; // foreach($category as $one_title){ for ($cat = 0; $cat < sizeof($category); $cat++) { $one_title = $category[$cat]; PrintText("{$cat}: {$one_title}"); $sph->setOptions(getOptions()); $sph->setAttribute('what', 'jobs'); $sph->setAttribute('lposition', $one_title); $sph->addQuery(); if ($cat % $stop_after == 0 && $cat != 0) { getSPHresutls($sph, &$ids, $cat_id); // PrintText("\n-------\nafter function ids:\n"); // var_dump($ids); updateDB($ids, $cat_id); unset($ids); $ids = NULL; } // $count++; } getSPHresutls($sph, &$ids, $cat_id); updateDB($ids, $cat_id); unset($ids); $ids = NULL; // PrintText("\n-------\nafter function ids:\n"); // var_dump($ids); } PrintText("\nEND:\n"); var_dump($ids);
if ($attachment_update == 1) { $attachment = secure_data($_POST['attachment']); $insert_data['attachment'] = $attachment; if ($attachment) { $src = UPLOAD_ROOT . 'temp/' . $attachment; $des = UPLOAD_ROOT . 'attachment/' . $attachment; rename($src, $des); } } $insert_data['sender_id'] = $_SESSION['agent']; $insert_data['msg_type'] = 1; $insert_data['payment_id'] = secure_data($_POST['pi']); // Insert insertDB($insert_data, 'messages'); // Update updateDB("info_updated = '1'", 'WHERE id = ' . $insert_data['payment_id'], 'payments'); ob_start(); include "info_display.php"; $html = ob_get_contents(); ob_end_clean(); $return_data['html'] = $html; $return_data['status'] = 1; $return_data['message'] = 'Info updated successfully'; } else { $messages = ''; foreach ($v->errors() as $k => $msgs) { foreach ($msgs as $msg) { $messages .= $msg . "<br>"; } } $return_data['message'] = $messages;
} // save data if ($save) { // uncomment the following line to provide simple protection for your own public access videoDB //if (!preg_match('/[0-9]{2+}/', $id)) break; // implicit owner id if not set if (!$owner_id) { $owner_id = get_current_user_id(); } // generate diskid if (empty($diskid) && $config['autoid'] && $mediatype != MEDIA_WISHLIST) { $diskid = getDiskId(); } // write videodata table $SETS = prepareSQL($GLOBALS); $id = updateDB($SETS, $id, $oldmediatype == MEDIA_WISHLIST && $mediatype != MEDIA_WISHLIST); // save genres setItemGenres($id, $genres); // set seen for currently logged in user set_userseen($id, $seen); // uploaded cover? processUpload($id, $_FILES['coverupload']['tmp_name'], $_FILES['coverupload']['type'], $_FILES['coverupload']['name']); // make sure no artifacts $smarty->clearCache('list.tpl'); $smarty->clearCache('show.tpl', get_current_user_id() . '|' . $id); // add another? if ($add_flag) { // remove id to prevent edit mode instead of new $id = ''; $smarty->assign('add_flag', $add_flag); } else {
if (0 == errorCount()) { for ($x = 0; $x < count($folders); $x++) { buildFilesList($cache, $files_list, GIT, $exclude_files, $folders[$x]); } } if (0 == errorCount() && $cache[1] == GITNEW) { downloadFiles($files_list); } if (0 == errorCount()) { backupFiles($tmp_folder, $files_list); } if (0 == errorCount()) { copyFiles($files_list); } if (0 == errorCount()) { $dbupdate = updateDB($nuConfigDBHost, $nuConfigDBName, $nuConfigDBUser, $nuConfigDBPassword); } if (errorCount() > 0) { $finalResult['message'] = 'ERRORS'; } else { $finalResult['message'] = 'SUCCESS'; } $successCount = count($success); $finalResult['errors'] = $errors; $finalResult['success'] = array("{$successCount} File(s) updated"); $finalResult['cache'] = $cache; $finalResult['dbupdate'] = $dbupdate; $json = json_encode($finalResult); //flush(); header('Content-Type: application/json'); echo $json;
$fields_enc = array('required_data', 'deliverable'); $insert_data = array(); $update_data = ''; foreach ($fields as $field) { if (in_array($field, $fields_enc)) { $insert_data[$field] = secure_data(htmlspecialchars($_POST[$field])); } else { $insert_data[$field] = secure_data($_POST[$field]); } $update_data .= $update_data !== '' ? ", " : ""; $update_data .= "`{$field}` = '{$insert_data[$field]}'"; } if ($job_id) { // Update $where = " WHERE id = '{$job_id}' AND service_id = '{$service}'"; updateDB($update_data, $where, 'service_packages'); $return_data['type'] = 'update'; } else { // Insert $insert_data['service_id'] = $service; $job_id = insertDB($insert_data, 'service_packages'); $return_data['type'] = 'insert'; } $return_data['id'] = $job_id; $return_data['name'] = $insert_data['job']; $return_data['status'] = 1; $return_data['message'] = 'Job updated successfully'; } else { $messages = ''; foreach ($v->errors() as $k => $msgs) { foreach ($msgs as $msg) {
*/ // On test si le fichier existe déjà sur le serveur. $id_copie = $_POST["id_copie"]; $fileinfo = pathinfo($file); // On cherche une entrée libre sur la table "units" dans notre BDD et // on récupère son id // on ajoute i afin de differencier les differentes copies ! $idUnite = $id_copie * 10 + $i; // On fait en sorte que l'id soit le nom de l'unité sur le dossier /Images $uploadImageID = $dir . $idUnite . '.' . $fileinfo['extension']; if (!file_exists($uploadImageID)) { // si le fichier n'existe pas sur le serveur on procède à l'upload. if (move_uploaded_file($myFiles["tmp_name"][$i], $uploadImageID)) { // On met à jour la base de donnée en ajoutant l'unité à l'id récupéré // par find_unset_entry updateDB($idUnite); $msg = "le fichier " . $fileinfo["filename"] . " a été bien envoyé."; ?> <script> // notifier la secrétaire du succès de l'upload du fichier. $( document ).ready(function() { window.parent.$.notify("<?php echo $msg; ?> ", "success"); }); </script> <?php } else { $msg = "Désolé, le fichier " . $fileinfo["filename"] . " n'a pas pu être envoyé.\n Veuillez réessayer"; ?>
$update_data .= "`{$field}` = '{$val}'"; $post_data[$field] = $val; } $file_change = secure_data($_POST['file_change']); if ($file_change == 1) { $image = secure_data($_POST['image']); if ($image !== '') { $src = UPLOAD_ROOT . 'temp/' . $image; $destination = UPLOAD_ROOT . 'course/' . $image; $destination_thumb = UPLOAD_ROOT . 'course/thumb/' . $image; if (file_exists($src)) { copy($src, $destination); generatethumb($src, $destination_thumb, 580, 367); unlink($src); } } $post_data['image'] = $image; $update_data .= $update_data !== '' ? ", " : ""; $update_data .= "`image` = '" . $image . "'"; } if ($error == 0) { updateDB($update_data, " WHERE id='{$id}'", 'courses'); $_SESSION['msg_selector'] = 'success'; $_SESSION['msg_message'] = 'Course updated succesfully.'; $return_data['status'] = 1; $return_data['message'] = 'Course updated successfully.'; } else { $return_data['message'] = $message; } echo json_encode($return_data); exit;
if ($basemode != 'rewrite') { if (insertDB($targetDbName, $targetTableName, $data)) { $localMenu = str_replace('ID=newID', 'ID=' . $_REQUEST['ID'], $localMenu); $error = "{$localMenu}\n<p>正常に登録されました。</p>\n"; $uri = rtrim(dirname($_SERVER['PHP_SELF']), '/\\'); header("Location: http://" . $_SERVER['HTTP_HOST'] . "{$uri}/"); foreach ($_REQUEST as $key => $val) { $_REQUEST[$key] = ''; } $flugInputOK = "1"; } else { $error = "<p class=\"error\">登録できませんでした。</p>"; } } else { $where = 'WHERE userID = "' . $_REQUEST['userID'] . '"'; if (updateDB($targetDbName, $targetTableName, $data, $where)) { $error = "<p>ID:" . $_REQUEST['userID'] . "は正常に修正されました。</p>"; $error .= "<p><a href=\"./\">" . $h2Text . "一覧へ行く</a></p>"; //DB接続 $db = new DB(); $db->connect($dbHost, $dbId, $dbPassword, $targetDbName); //Clinicデータ取得 $sql = 'SELECT * FROM ' . $targetTableName . ' WHERE userID = "' . $_REQUEST['userID'] . '";'; $dataArray = $db->getRow($sql, 'ASSOC'); $db->disconnect(); } else { $error = "<p class=\"error\">運用ID:" . $_REQUEST['userID'] . "は修正できませんでした。</p>"; } } } }
function FetchSaveMovie($id, $lookup) { $debug = 0; $video = runSQL('SELECT * FROM ' . TBL_DATA . ' WHERE id = ' . $id); // get fields (according to list) from db to be saved later if ($debug) { echo "\n=================== Video DB Data ============================\n"; print_r($video[0]); echo "\n=================== Video DB Data ============================\n"; } $imdbID = $video[0]['imdbID']; echo "Movie/imdb -- " . $video[0]['title'] . "/" . $video[0]['imdbID'] . "\n"; if (empty($imdbID)) { echo "No imdbID\n"; return; } if (empty($engine)) { $engine = engineGetEngine($imdbID); } if ($debug) { echo "IMDBID = {$imdbID}, engine = {$engine}\n"; } $imdbdata = engineGetData($imdbID, $engine); # removed due to performance issues of is_utf8 // fix erroneous IMDB encoding issues if (!is_utf8($imdbdata)) { echo "Applying encoding fix\n"; $imdbdata = fix_utf8($imdbdata); } if (empty($imdbdata[title])) { echo "Fetch failed , try again...\n"; $imdbdata = engineGetData($imdbID, $engine); } if (empty($imdbdata[title])) { echo "Fetch failed again , next movie"; return; } if ($debug) { echo "\n=================== IMDB Data ============================\n"; print_r($imdbdata); echo "\n=================== IMDB Data ============================\n"; } if (!empty($imdbdata[title])) { // // NOTE: comment out any of the following lines if you do not want them updated // $video[0][title] = $imdbdata[title]; $video[0][subtitle] = $imdbdata[subtitle]; $video[0][year] = $imdbdata[year]; $video[0][imgurl] = $imdbdata[coverurl]; $video[0][runtime] = $imdbdata[runtime]; $video[0][director] = $imdbdata[director]; $video[0][rating] = $imdbdata[rating]; $video[0][country] = $imdbdata[country]; $video[0][language] = $imdbdata[language]; $video[0][actors] = $imdbdata[cast]; $video[0][plot] = $imdbdata[plot]; } if (count($genres) == 0 || $lookup > 1) { $genres = array(); $gnames = $imdbdata['genres']; if (isset($gnames)) { foreach ($gnames as $gname) { // check if genre is found- otherwise fail silently if (is_numeric($genre = getGenreId($gname))) { $genres[] = $genre; } else { echo "MISSING GENRE {$gname}\n"; } } } } // custom filds , not working for now for ($i = 1; $i <= 4; $i++) { $custom = 'custom' . $i; $type = $config[$custom . 'type']; if (!empty($type)) { // copy imdb data into corresponding custom field $video[0][$custom] = $imdbdata[$type]; echo "CUSTOM {$custom} {$type} = {$imdbdata[$type]}\n"; } } // -------- SAVE $SETS = prepareSQL($video[0]); if ($debug) { echo "\n=================== Final Data ============================\n"; echo "SETS = {$SETS} \n"; echo "\n=================== Final Data ============================\n"; } $id = updateDB($SETS, $id); // save genres setItemGenres($id, $genres); // set seen for currently logged in user set_userseen($id, $seen); }
$update_data = ''; $post_data = array(); $return_data = array('status' => 0); foreach ($fields as $field) { if ($field === 'content') { $val = addslashes(trim($_POST[$field])); } else { $val = secure_data($_POST[$field]); } if (in_array($field, $required_fields) && $val === '') { $error = 1; $message .= $message !== '' ? '<br>Please fill up all data' : 'Please fill up all data'; break; } $update_data .= $update_data !== '' ? ", " : ""; $update_data .= "`{$field}` = '{$val}'"; $post_data[$field] = $val; } if ($error == 0) { updateDB($update_data, " WHERE id='{$id}'", 'course_sections'); $course_id = selectDB(" WHERE id='{$id}'", 'course_sections', 'course_id'); $_SESSION['msg_selector'] = 'success'; $_SESSION['msg_message'] = 'step updated succesfully.'; $return_data['cid'] = $course_id; $return_data['status'] = 1; $return_data['message'] = 'step updated successfully.'; } else { $return_data['message'] = $message; } echo json_encode($return_data); exit;
if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $studentNumbersFromDB .= $row['studentnumber']." "; //the extra space string here creates a delimiter } } //if the user signed in with a student number existing in the DB, update rather than insert. //also, sometimes the user might have a cookie for their information; this accounts for that $snForDB = isset($_SESSION['studentNumber']) ? $_SESSION['studentNumber'] : $_COOKIE['studentNumber']; $nameForDB = (isset($_SESSION['firstName']) ? $_SESSION['firstName'] : $_COOKIE['firstName'])." ". (isset($_SESSION['lastName']) ? $_SESSION['lastName'] : $_COOKIE['lastName']); $progForDB = isset($_SESSION['programs']) ? $_SESSION['programs'] : $_COOKIE['programs']; $coursesforDB = isset($_SESSION['courses']) ? $_SESSION['courses'] : $_COOKIE['courses']; if (strpos($studentNumbersFromDB, $snForDB) !== false) { updateDB($snForDB, $nameForDB, $progForDB, $coursesforDB); } else { insertIntoDB($snForDB, $nameForDB, $progForDB, $coursesforDB); } ?> </body> </html> <?php } else { header("Location: index.php"); } function updateDB($studentnumber, $fullname, $program, $courses) { global $conn; $sql = "UPDATE `rosenich`.`students` SET fullname='$fullname', program='$program', courses='$courses' WHERE studentnumber='$studentnumber'";
if ($job_type == 2 && $payment_data['order_started'] == 0) { // TODO : change status 2 - Done $order_date = date('Y-m-d H:i:s', $time); updateDB("order_started = 1, order_start_date = '{$order_date}', job_status = 2", "WHERE id = '{$pi}'", 'payments'); $insert_data[1] = delivery_start_msg($pi, $user_id); $info_data = mysql_get_rows('messages', array('where' => "payment_id='{$payment_data['id']}' AND msg_type='1'"), 1); $return_data['od'] = $order_date; $return_data['dd'] = 'Before ' . date('Y-m-d H:i:s', strtotime($order_date) + $info_data['days'] * 86400); } elseif ($job_type == 4 && in_array($payment_data['job_status'], array(3))) { updateDB("job_status = 4", "WHERE id = '{$pi}'", 'payments'); $info_data = mysql_get_rows('messages', array('where' => "payment_id='{$payment_data['id']}' AND msg_type='1'"), 1); $return_data['dd'] = 'Before ' . date('Y-m-d H:i:s', strtotime($payment_data['order_start_date']) + $info_data['days'] * 86400); } elseif ($job_type == 5 && in_array($payment_data['job_status'], array(3))) { updateDB("job_status = 5", "WHERE id = '{$pi}'", 'payments'); } elseif ($job_type == 6) { updateDB("job_status = 6", "WHERE id = '{$pi}'", 'payments'); $return_data['dd'] = '-'; } if (in_array($job_type, array(2, 4, 5, 6)) && !is_null($payment_data['bkid']) && $payment_data['bkid'] !== '') { $user_data = mysql_get_rows('users', array('where' => "id='{$user_id}'"), 1); $curl_pay_data = $payment_data; unlink($curl_pay_data['post_data']); $curl_data = array('job_type' => $job_type, 'time' => $time, 'bkid' => $payment_data['bkid'], 'email' => $user_data['email'], 'payment_data' => $curl_pay_data, 'access' => md5('dmexpert-to-basekit-api')); $extra_data = array(CURLOPT_REFERER => 'http://www.dmexpert.net'); $url = BK_URL . 'agent/dashboard/updatemessage'; run_curl($url, $curl_data, $extra_data); } } ob_start(); include "msg_display.php"; $html = ob_get_contents();