function delivery_start_msg($pi, $user_id) { $ot_info_data = mysql_get_rows('messages', array('where' => "payment_id = '{$pi}' AND msg_type = 1"), 1); $insert_data = array('message' => '<div class="start-order-box"><div class="icon-order-start mb10"></div>Order is started. And it will deliver within ' . $ot_info_data['days'] . ' days.</div>', 'receiver_id' => $user_id, 'msg_type' => 0, 'payment_id' => $pi); insertDB($insert_data, 'messages'); $insert_data['sender_id'] = NULL; return $insert_data; }
function scrap($db, $y, $m, $d, $time) { $postFields = array('strYear' => $y, 'strMonth' => $m, 'strDay' => $d); try { $url = 'http://g1.taisugar.com.tw/Sugar/Sugar_show_His.asp'; $sugar = curl($url, $postFields); $packtSugarXpath = returnXPathObject($sugar); $td = $packtSugarXpath->query('//td'); // return DOMNodeList $td_title = $td->length; $td_first = 13; $td_second = 14; $td_third = 15; $td_diff = 7; if ($td_title > 13) { $pid = filter_var($td->item($td_first)->nodeValue, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $kg = filter_var($td->item($td_second)->nodeValue, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $bag = filter_var($td->item($td_third)->nodeValue, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $result['pid'] = clean($pid); $result['pricePerKg'] = $kg; $result['pricePerBag'] = $bag; $result['time'] = $time; while ($result['pid'] != '01021050') { $td_first = $td_first + $td_diff; $td_second = $td_second + $td_diff; $td_third = $td_third + $td_diff; $pid = filter_var($td->item($td_first)->nodeValue, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $kg = filter_var($td->item($td_second)->nodeValue, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $bag = filter_var($td->item($td_third)->nodeValue, FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $result['pid'] = clean($pid); $result['pricePerKg'] = $kg; $result['pricePerBag'] = $bag; $result['time'] = $time; } insertDB($db, $result['pid'], $result['pricePerKg'], $result['pricePerBag'], $result['time']); print_r($result); } else { // echo 'no data input'; } } catch (Exception $ex) { echo "failed </br>"; } }
//必須・入稿規定等のチェック $error .= errorCheckPostData($targetDbColumn, $columnItem, $mustItem[$userAuth], $textLimitItem[$userAuth], $isNumItem, $isMailItem); //エラーがなければ書き込み if (!$error) { //データ作成 foreach ($targetDbColumn as $key) { $data[$key] = isset($_REQUEST[$key]) ? $_REQUEST[$key] : ''; } if (is_array($forceInsertData)) { foreach ($forceInsertData as $key => $val) { $data[$key] = $val; } } //新規 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>";
curl_setopt_array($request, array(CURLOPT_URL => $url, CURLOPT_POST => TRUE, CURLOPT_POSTFIELDS => http_build_query(array('cmd' => '_notify-validate') + $ipn_post_data), CURLOPT_RETURNTRANSFER => TRUE, CURLOPT_HEADER => FALSE, CURLOPT_SSL_VERIFYPEER => FALSE, CURLOPT_SSL_VERIFYHOST => FALSE, CURLOPT_CAINFO => 'cacert.pem')); // Execute request and get response and status code $response = curl_exec($request); $status = curl_getinfo($request, CURLINFO_HTTP_CODE); // Close connection curl_close($request); if ($status == 200 && $response == 'VERIFIED') { // TODO : Check condition for unique txn_id $service_data = array(); $package_data = array(); $qry = "SELECT * FROM service_packages WHERE id = '{$ipn_post_data['option_selection1']}'"; $result = mysql_query($qry); if (mysql_num_rows($result) > 0) { $package_data = mysql_fetch_assoc($result); $service_data = mysql_get_rows('services', array('where' => "id = '{$package_data['service_id']}'"), 1); if (!is_array($service_data)) { $service_data = array(); } } $custom = explode('||', $ipn_post_data['custom']); $insert_data = array('user_id' => $custom[1], 'client_id' => $ipn_post_data['option_selection2'], 'item_name' => count($service_data) > 0 ? $service_data['name'] : '', 'quantity' => $ipn_post_data['quantity'], 'amount' => $ipn_post_data['mc_gross'], 'txn_id' => $ipn_post_data['txn_id'], 'date' => date('Y-m-d H:i:s', strtotime($ipn_post_data['payment_date'])), 'payment_status' => $ipn_post_data['payment_status'], 'info_updated' => 1, 'package' => $ipn_post_data['item_name'], 'test_ipn' => $ipn_post_data['test_ipn'], 'unique_key' => $custom[0], 'package_id' => $ipn_post_data['option_selection1'], 'post_data' => json_encode($ipn_post_data), 'job_status' => 1); $payment_id = insertDB($insert_data, 'payments'); // TODO : Insert in message if (count($package_data) > 0) { $message_data = array('receiver_id' => $custom[1], 'payment_id' => $payment_id, 'message' => secure_data($package_data['required_data']), 'deliverable' => secure_data($package_data['deliverable']), 'days' => secure_data($package_data['days_to_complete']), 'msg_type' => 1); insertDB($message_data, 'messages'); } // TODO : Send email + save proper data in db } exit; }
<?php session_start(); require 'connectDB.php'; require 'password.php'; $username = $_POST['username']; $password = $_POST['password']; $memberType = $_POST['position']; $hash = password_hash($password, PASSWORD_DEFAULT); $db = connectDB(); $query = "INSERT INTO member (member_type, password, user_name) VALUES ('{$memberType}', '{$hash}', '{$username}');"; insertDB($query); $_SESSION['username'] = $username; header("location:syndicateForm.php");
break; } $insert_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); } } $insert_data['image'] = $image; } $insert_data['created_at'] = date('Y-m-d H:i:s', time()); if ($error == 0) { insertDB($insert_data, 'courses'); $_SESSION['msg_selector'] = 'success'; $_SESSION['msg_message'] = 'Course added succesfully.'; $return_data['status'] = 1; $return_data['message'] = 'Course added successfully.'; } else { $return_data['message'] = $message; } echo json_encode($return_data); exit;
} // dmexpert id available if ($dmid) { $service_data = mysql_get_rows('services', array('where' => "id = '{$package_data['service_id']}'"), 1); if (!is_array($service_data)) { $service_data = array(); } $insert_data['item_name'] = count($service_data) > 0 ? $service_data['name'] : ''; $insert_data['package'] = $package_data['job']; $insert_data['package_id'] = $dmid; $msg_insert_data['message'] = secure_data($package_data['required_data']); $msg_insert_data['deliverable'] = secure_data($package_data['deliverable']); $msg_insert_data['days'] = secure_data($package_data['days_to_complete']); } else { if (is_array($def_data)) { $msg_insert_data['message'] = secure_data($def_data['required_data']); $msg_insert_data['deliverable'] = secure_data($def_data['deliverable']); $msg_insert_data['days'] = secure_data($def_data['days_to_complete']); } else { $msg_insert_data['days'] = secure_data($outsource_data['days_complete']); } } // Insert in payment table $payment_id = insertDB($insert_data, 'payments'); $msg_insert_data['payment_id'] = $payment_id; // Insert in message table insertDB($msg_insert_data, 'messages'); $return_data['status'] = 1; $return_data['payment_id'] = $payment_id; } echo json_encode($return_data);
function insertVote() { $db = connectDB(); $voteString = getVoteString(); $username = getUserName(); $recruit = getRecruit(); $pos = strpos($recruit, "name="); $name = substr($recruit, 0, $pos); $votes = 0; $found = false; //Get recruit ID foreach ($db->query("SELECT recruit_id FROM recruit WHERE name='" . $name . "'") as $row) { $recruitID = $row['recruit_id']; } //Get member ID foreach ($db->query("SELECT member_id, member_type FROM member WHERE user_name='" . $username . "'") as $row) { $memberID = $row['member_id']; $memberType = $row['member_type']; } //Check if the user has voted on this recruit already foreach ($db->query("SELECT member_id, recruit_id FROM votes") as $row) { //If found, alter original vote if ($row['member_id'] == $memberID && $row['recruit_id'] == $recruitID) { $query = "UPDATE votes SET vote='" . $voteString . "' WHERE member_id='" . $memberID . "' AND recruit_id='" . $recruitID . "';"; insertDB($query); $found = true; } } //If not, insert vote if (!$found) { $query = "INSERT INTO votes (member_id, vote, recruit_id, member_type) VALUES ({$memberID}, '{$voteString}', {$recruitID}, '{$memberType}');"; insertDB($query); } //Add up votes foreach ($db->query("SELECT vote, member_type FROM votes where recruit_id='" . $recruitID . "'") as $row) { if ($row['member_type']) { header("location:recruitResults.php"); } if ($row['vote'] == "Yes") { if ($row['member_type'] == "staff") { $votes += 3; } else { if ($row['member_type'] == "officer") { $votes += 2; } else { if ($row['member_type'] == "regular") { $votes++; } } } } else { if ($row['vote'] == "No") { if ($row['member_type'] == "staff") { $votes += -3; } else { if ($row['member_type'] == "officer") { $votes += -2; } else { if ($row['member_type'] == "regular") { $votes--; } } } } else { } } } //Update the count $query = "UPDATE recruit SET vote_count='" . $votes . "' WHERE recruit_id='" . $recruitID . "';"; insertDB($query); }
function crawlStatus($currElement) { $src = $hyperlink = $locn = $userURL = $followers = $rts = $rtu = null; //$currElement = $statusArray[$i]; $createdAt = return_between($currElement, "<created_at>", "</created_at>", EXCL); //format the date to Database datetime type (for date based comparisons) $dtFormat = dateFormat($createdAt); $tempsid = split_string($currElement, "</created_at>", AFTER, EXCL); $tempsid = split_string($tempsid, "</id>", BEFORE, EXCL); $sid = split_string($tempsid, "<id>", AFTER, EXCL); $text = return_between($currElement, "<text>", "</text>", EXCL); //this and next functions called to handle unicode characters or non english text $text = utf8_to_unicode($text); $text = unicode_to_entities_preserving_ascii($text); //preg match to extract URL from tweets, if present (currently for http), match string can be modified for better handling $do = preg_match('@(https?://([-\\w\\.]+)+(:\\d+)?(/([\\w/_\\.]*(\\?\\S+)?)?)?)@', $text, $matches); if ($do = true) { //if url present $hyperlink = expandTinyURL(htmlentities($matches['0'])); } //tweets usually contain tiny urls ->expansion needed $src = return_between($currElement, "<source>", "</source>", EXCL); $src = strip_tags($src); //gathering reply to information, if the tweet is a reply $rts = return_between($currElement, "<in_reply_to_status_id>", "</in_reply_to_status_id>", EXCL); $rtu = return_between($currElement, "<in_reply_to_user_id>", "</in_reply_to_user_id>", EXCL); //extracting user information as an array $userprofile = return_between($currElement, "<user>", "</user>", EXCL); $flag = 0; insertDB($sid, $text, $hyperlink, $dtFormat, $rts, $rtu, $src, $userprofile); }
<?php require_once '../config.php'; checkAjax(); $section_id = secure_data($_POST['section_id']); $name = secure_data($_POST['name']); $return_data = array('status' => 0); if ($section_id > 0) { // Edit $qry = "UPDATE course_sections SET `name` = '{$name}' WHERE id='{$section_id}' AND type=1"; mysql_query($qry); $return_data['id'] = $section_id; $return_data['type'] = 'edit'; } else { // Add $course_id = secure_data($_POST['course_id']); $insert_data = array('name' => $name, 'course_id' => $course_id, 'type' => 1, 'created_at' => date('Y-m-d H:i:s')); $return_data['id'] = insertDB($insert_data, 'course_sections'); $return_data['type'] = 'insert'; } $return_data['name'] = $name; $return_data['status'] = 1; echo json_encode($return_data); exit;
<?php require 'connectDB.php'; $recruit = "insert into recruit (member_id, name, vote_count, creation_date) values('4', 'John', '0', CURDATE());"; insertDB($recruit); $recruit = "insert into recruit (member_id, name, vote_count, creation_date) values('4', 'Shane', '0', CURDATE());"; insertDB($recruit); $recruit = "insert into recruit (member_id, name, vote_count, creation_date) values('4', 'Bill', '0', CURDATE());"; insertDB($recruit); $recruit = "insert into recruit (member_id, name, vote_count, creation_date) values('4', 'Charlie', '3', CURDATE());"; insertDB($recruit); echo "Inserted into DB!";
$z = 0; $source = file_get_html('http://www.uni-koeln.de/uni/gebaeude/liste.html'); $table = $source->find('table', 1); foreach ($table->find('tr') as $row) { if ($i == 0) { $i = 1; continue; } if ($z < 200) { //Werte manipulieren, maximal 100 gleichzeitig, performancebedingt $z++; continue; } else { if ($z >= 262) { //... insertDB($gebaeude); echo $j . "\n" . $k . "\n"; var_dump($gebaeude); exit; } } $nr = trim($row->find('td', 0)->plaintext); $name = $nr . " " . $row->find('td', 2)->plaintext; $strasse = $row->find('td', 3)->plaintext; $strasse_plus = preg_replace('/ /', '+', $strasse); $replace = array('ä' => 'ae', 'ö' => 'oe', 'ü' => 'ue', 'ß' => 'ss'); $strasse_plus = strtr($strasse_plus, $replace); //fetching geodata from google API $geodata = json_decode(file_get_contents(utf8_encode("http://maps.googleapis.com/maps/api/geocode/json?address={$strasse_plus},Koeln&sensor=false")), true); if ($geodata["status"] != "OK") { $k++;
/** * */ public function step4() { $time = date("Y-m-d H:m:s"); $db_host = $_POST["db_host"]; $db_port = $_POST["db_port"]; $db_user = $_POST["db_user"]; $db_password = $_POST["db_password"]; $db_name = $_POST["db_name"]; $db_prefix = $_POST["db_prefix"]; if ($_POST['admin_password'] != $_POST['admin_password2'] || trim($_POST['admin_password']) == '' || trim($_POST['admin_password2']) == '') { $this->error("两次输入的密码不一致,请重新设定!,或者密码为空"); } else { $admin_user = $_POST['admin_user']; $admin_password = encrypt($_POST['admin_password']); $admin_email = $_POST['admin_email']; $user_session = encrypt($admin_user . $admin_password . time()); } $title = $_POST['cfg_title']; $site_url = $_POST['cfg_basehost'] . $_POST['cfg_cmspath']; if (!test_db_connect($db_host . ":" . $db_port, $db_user, $db_password)) { $this->error("数据库服务器或登录密码无效,\n\n无法连接数据库,请重新设定!"); } $conn = mysql_connect($db_host . ":" . $db_port, $db_user, $db_password); mysql_query("CREATE DATABASE IF NOT EXISTS `" . $db_name . "`;", $conn); if (!mysql_select_db($db_name)) { $this->error("选择数据库失败,可能是你没权限,请预先创建一个数据库!"); } mysql_query("set character set 'utf8'"); mysql_query("set names 'utf8'"); $file = WEB_ROOT . 'Data/Install/db_config_sample.php'; if (!File::file_exists($file)) { $this->error('Data/Install/db_config_sample.php文件不存在,请检查'); } $content = File::readFile($file); $content = str_replace("~dbhost~", $db_host, $content); $content = str_replace("~dbport~", $db_port, $content); $content = str_replace("~dbname~", $db_name, $content); $content = str_replace("~dbuser~", $db_user, $content); $content = str_replace("~dbpwd~", $db_password, $content); $content = str_replace("~dbprefix~", $db_prefix, $content); if (!File::writeFile(WEB_ROOT . 'db_config.php', $content, 'w+')) { $this->error("数据库配置文件写入失败,请您手动根据Data/Install/db_config_sample.php文件在根目录创建文件"); } File::makeDir(WEB_ROOT . 'Data/Cache'); $sql_empty = File::readFile(WEB_ROOT . 'Data/Install/greencms_empty.sql'); $sql_query = str_replace('{$db_prefix}', $db_prefix, $sql_empty); $file = WEB_ROOT . 'Data/Cache/greencms_sample.sql'; File::writeFile($file, $sql_query, 'w+'); insertDB($file, $conn); File::delFile($file); $sql_empty = File::readFile(WEB_ROOT . 'Data/Install/greencms_init.sql'); $sql_query = str_replace('{$db_prefix}', $db_prefix, $sql_empty); $file2 = WEB_ROOT . 'Data/Cache/greencms_init_sample.sql'; File::writeFile($file2, $sql_query, 'w+'); insertDB($file2, $conn); File::delFile($file2); /** * 插入管理员数据&更新配置 */ $admin_query = "INSERT INTO `{$db_prefix}user` (`user_id`, `user_login`, `user_pass`, `user_nicename`, `user_email`,\n `user_url`, `user_registered`, `user_activation_key`, `user_status`, `user_intro`,\n `user_level`, `user_session`) VALUES(1, '{$admin_user}', '" . $admin_password . "', '管理员', '{$admin_email}',\n '', '{$time}', '', 1, '我是admin,欢迎使用', 2, '{$user_session}');"; if (!mysql_query($admin_query, $conn)) { $this->error(' 插入管理员数据出错'); } $cquery = "Update `{$db_prefix}options` set option_value='{$title}' where option_name='title';"; if (!mysql_query($cquery, $conn)) { $this->error(' 更新配置数据出错'); } $cquery = "Update `{$db_prefix}options` set option_value='{$site_url}' where option_name='site_url';"; if (!mysql_query($cquery, $conn)) { $this->error(' 更新配置数据出错'); } $software_version = GreenCMS_Version; $software_build = GreenCMS_Build; $cquery = "Update `{$db_prefix}options` set option_value='{$software_version}' where option_name='software_version';"; if (!mysql_query($cquery, $conn)) { $this->error(' 更新配置数据出错'); } $cquery = "Update `{$db_prefix}options` set option_value='{$software_build}' where option_name='software_build';"; if (!mysql_query($cquery, $conn)) { $this->error(' 更新配置数据出错'); } //TODO 写不下去了 $this->redirect('Install/Index/step5'); }
$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) { $messages .= $msg . "<br>"; } } $return_data['message'] = $messages; }
file_put_contents('log.txt',$lastmod."\r\n",FILE_APPEND); */ //If method = POST if ($_SERVER['REQUEST_METHOD'] == 'POST') { //Cases for action switch // switch ($_POST['action']){ // case ("insert"): if ($_POST["action"] == "insert") { $fname = $_POST['fname']; $sname = $_POST['sname']; $company = $_POST['company']; $phone = $_POST['phone']; $carpark = $_POST['carpark']; $carreg = $_POST['carreg']; $visit = $_POST['visit']; insertDB($fname, $sname, $company, $phone, $carpark, $carreg, $visit); } else { if ($_POST["action"] == "current") { currentPeople(); } else { if ($_POST["action"] == "signout") { $ID = $_POST['id']; mysqli_query($conn, "UPDATE details SET dleave=NOW() WHERE idDetails='{$ID}'"); } else { if ($_POST["action"] == "delete") { $ID = $_POST['id']; mysqli_query($conn, "DELETE FROM details WHERE idDetails = '{$ID}' "); //deleteRecord($ID); } else { if ($_POST["action"] == "search") { $fname = $_POST['fname'];
<?php include 'config.php'; checkAjax(); $return_data = array('status' => 0); $section_id = secure_data($_POST['sectionId']); $step_id = secure_data($_POST['stepId']); $enable = secure_data($_POST['changeEnable']); $user_id = $_SESSION['agent']; // Check if record exists or not $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;
} } $insert_data = array(); $insert_data[0] = array('message' => secure_data($bkodata['message']), 'sender_id' => $user_data['id'], 'msg_type' => $msg_type, 'payment_id' => $payment_data['id']); $attachment_update = isset($bkodata['attachment_update']) ? secure_data($bkodata['attachment_update']) : ''; if ($attachment_update == 1) { $attachment = secure_data($bkodata['attachment']); $insert_data[0]['attachment'] = $attachment; if ($attachment) { $src = $post_data['path'] . $attachment; $des = UPLOAD_ROOT . 'attachment/' . $attachment; // TODO : check condition image accesible copy($src, $des); } } 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'); } }
<?php include 'config.php'; $allowed_domains = array('localhost', 'basekit-staging.digibuzz24.net'); $settings = json_decode(file_get_contents('admin/data/settings.txt')); $email = secure_data($_GET['e']); //echo "<pre>"; print_r($_SERVER); exit; $ref_domain = ''; $referrer = @$_SERVER['HTTP_REFERER']; if ($referrer) { $parse = parse_url($referrer); $ref_domain = preg_replace('#^www\\.(.+\\.)#i', '$1', $parse['host']); } if ($email && filter_var($email, FILTER_VALIDATE_EMAIL) && $ref_domain && in_array($ref_domain, $allowed_domains)) { $user_data = mysql_get_rows('users', array('where' => 'email = "' . $email . '"'), 1); if (!$user_data) { $email_arr = explode('@', $email); $username = $email_arr[0]; $insert_data = array('email' => $email, 'username' => $username, 'password' => md5(rand(5, 6)), 'type' => 2, 'status' => 1, 'created_at' => date('Y-m-d H:i:s')); $id = insertDB($insert_data, 'users'); } else { $id = $user_data['id']; } $_SESSION['agent'] = $id; header("Location: dashboard.php"); exit; } else { header("Location: login.php"); exit; }
$insert_data = array('message' => $message, 'days' => $days); $attachment_update = secure_data($_POST['attachment_update']); 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 = 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; } $insert_data[$field] = $val; } if ($error == 0) { $parent = $insert_data['parent']; $course_id = selectDB(" WHERE id='{$parent}'", 'course_sections', 'course_id'); $insert_data['created_at'] = date('Y-m-d H:i:s', time()); $insert_data['type'] = 2; $insert_data['course_id'] = $course_id; insertDB($insert_data, 'course_sections'); $_SESSION['msg_selector'] = 'success'; $_SESSION['msg_message'] = 'step added succesfully.'; $return_data['cid'] = $course_id; $return_data['status'] = 1; $return_data['message'] = 'step added successfully.'; } else { $return_data['message'] = $message; } echo json_encode($return_data); exit;
function mailSend($Data, $tempData) { global $clientMailto, $clientSubject, $clientMailBody, $guestMailFrom, $guestMailFromName, $guestSubject, $guestMailBody, $cliantEnv, $guestMailBodyMobile, $mailcc; //DBからclientMailtoを取得・DBに内容を書き込み if ($this->extramode == "online") { //DB接続 global $dbHost, $dbId, $dbPassword, $dbName, $userTb, $qaTb; $db = new DB(); $db->connect($dbHost, $dbId, $dbPassword, $dbName); //個別データを取得 $sql = 'SELECT mailAddress FROM ' . $userTb; $dataArray = $db->getArray($sql, 'ASSOC'); if (is_array($dataArray)) { foreach ($dataArray as $line) { $mailtoArray[] = $line['mailAddress']; } $clientMailto = implode(",", $mailtoArray); } else { //DBから取れない時はエラー return false; } //書き込み $insertData['name'] = sqlite_escape_string($Data['name']); $insertData['pref'] = sqlite_escape_string($Data['pref']); $insertData['mail'] = sqlite_escape_string($Data['mail']); $insertData['categoryID'] = sqlite_escape_string($Data['categoryID']); $insertData['title'] = sqlite_escape_string($Data['title']); $insertData['question'] = sqlite_escape_string($Data['question']); $insertData['entryDay'] = date("Y/m/d"); $insertData['dbUpDay'] = date("Y/m/d"); if (!insertDB($dbName, $qaTb, $insertData)) { return false; } $db->disconnect(); } //送信内容作成 $clientText = $this->tempReplace($clientMailBody, $tempData); $Data['email'] = isset($Data['email']) && $Data['email'] ? $Data['email'] : $Data['mail']; if ($cliantEnv == 'PC' && $guestMailBodyMobile) { if (isset($Data['domain']) && $Data['domain']) { if ($this->mailAddressMobileCheck($Data['email'] . '@' . $Data['domain'])) { $guestText = $this->tempReplace($guestMailBodyMobile, $tempData); } else { $guestText = $this->tempReplace($guestMailBody, $tempData); } } else { if ($this->mailAddressMobileCheck($Data['email'])) { $guestText = $this->tempReplace($guestMailBodyMobile, $tempData); } else { $guestText = $this->tempReplace($guestMailBody, $tempData); } } } else { $guestText = $this->tempReplace($guestMailBody, $tempData); } //mailfrom $Data['name'] = isset($Data['nameA']) && $Data['nameA'] ? $Data['nameA'] . " " . $Data['nameB'] : $Data['name']; if (isset($Data['domain']) && $Data['domain']) { $clientMailFrom = 'From: ' . mb_encode_mimeheader($Data['name'] . '様') . '<' . ($Data['email'] . '@' . $Data['domain'] ? $Data['email'] . '@' . $Data['domain'] : $clientMailto) . '>'; } else { $clientMailFrom = 'From: ' . mb_encode_mimeheader($Data['name'] . '様') . '<' . ($Data['email'] ? $Data['email'] : $clientMailto) . '>'; } $guestMailTo = $Data['email']; $guestMailFrom = 'From: ' . mb_encode_mimeheader($guestMailFromName) . '<' . $guestMailFrom . '>'; //mailcc if ($mailcc != false) { mb_send_mail($mailcc, $clientSubject, mb_convert_kana($clientText, "KV"), $clientMailFrom); usleep(100000); } //メール送信 if (mb_send_mail($clientMailto, $clientSubject, mb_convert_kana($clientText, "KV"), $clientMailFrom)) { usleep(100000); if ($guestText) { if (mb_send_mail($guestMailTo, $guestSubject, mb_convert_kana($guestText, "KV"), $guestMailFrom)) { return true; } else { return false; } } else { return true; } } else { return false; } }
function savePrint() { global $conn, $fname, $sname, $company, $phone, $carpark, $carreg, $visit, $darrive, $dleave, $fullname; insertDB($conn, $fname, $sname, $company, $phone, $carpark, $carreg, $visit, $darrive, $dleave, $fullname); printLabel(); }
function readCSV($dir, $csvFile, $tableName) { // connect $m = new MongoClient(); // select a database $db = $m->trend; $collection = $db->{$tableName}; // Get yeat and month from csvFile list($year, $month, $rest) = explode("_", $csvFile, 3); $year = intval($year); $month = intval($month); assert($year != null && $month != null); $row = 0; if (($handle = fopen("{$dir}/{$csvFile}", "r")) == FALSE) { echo "{$dir} . {$csvFile} not found!"; return; } while (($data = fgetcsv($handle, 10000000, ",")) !== FALSE) { // table head field if ($row++ == 0) { $thdata = array_values($data); $fields = getFields($data); $types = getTypes($fields); // Num of Fields $numFields = count($fields); // Add meta fields $fields[] = "year"; $fields[] = "month"; $fields[] = "state"; $fields[] = "city"; $fields[] = "county"; $fields[] = "region"; //$fields[] = "xlsrow"; // types $types[] = "i"; $types[] = "i"; $types[] = "s"; $types[] = "s"; $types[] = "s"; $types[] = "s"; //$types[] = "i"; print_r($fields); //make a unique/index index //makeDBIndex($db, $collection, $fields); continue; } // Another table head? $diff = array_diff($thdata, $data); // all same? if (count($diff) == 0) { echo "Skip another table head"; continue; } $num = count($data); if ($num != $numFields) { echo "<!> {$num} fields in line {$row}!\n"; print_r($data); continue; } assert($fields); // add year and month $data[] = $year; $data[] = $month; list($state, $city, $county, $region) = explode(" ", trim($data[0]), 4); // data 0 should be the full loc $data[] = $state; $data[] = $city; $data[] = $county; $data[] = $region; $data[] = $row; // echo "$data[0] $data[1]"; // Let's insert insertDB($db, $collection, $types, $fields, $data); } fclose($handle); // mk grpo echo "<!> Inserted {$row} rows!\n"; echo "<!> making agg for {$year}/{$month}...\n"; mkgrp($db, $tableName, $year, $month); }