function patch($importEntity, $existingEntity, $mapping) { $result = array(); $isModified = false; if (isset($existingEntity)) { $result["Id"] = $existingEntity["Id"]; if ($existingEntity["IsDeleted"] == 1) { $isModified = true; } //Log::info(" Patching existing id=".$result["Id"]); } else { $isModified = true; $result["Id"] = GUID(); Log::info(" Creating new id=" . $result["Id"]); } $result["IsDeleted"] = 0; foreach ($mapping as $iKey => $eKey) { if (isset($existingEntity) && isset($existingEntity[$eKey]) && $existingEntity[$eKey] == $importEntity[$iKey]) { continue; } $result[$eKey] = $importEntity[$iKey]; @Log::info(" Id=" . $result["Id"] . ", [" . $eKey . "] changed to: " . $result[$eKey]); $isModified = true; } if ($isModified) { $result["LastChangeDateTimeUtc"] = DB::sqleval("utc_timestamp()"); Log::info(" Touching LastChangeDateTimeUtc of Id=" . $result["Id"]); } else { Log::info(" No changes on Id=" . $result["Id"]); } if (!$isModified) { return null; } return $result; }
public function set_cookie($user_id) { $cookie_guid = GUID(50); setCookie("session", $cookie_guid, time() + self::$logintime, self::$path, self::$domain, self::$secure); // setCookie("expire",time()+1800, time()+self::$logintime, self::$path, self::$domain, self::$secure); DB::update("accounts", array("session" => $cookie_guid, "logintime" => strval(time())), "uid=%s", $user_id); return $cookie_guid; }
function generate_until_satisfied($check) { $guid = GUID(); while (!$check($guid)) { $guid = GUID(); } return $guid; }
function insertOrUpdateImageByTitle($database, $imageData, $title) { $imageInfo = getimagesizefromstring($imageData); $existingImageRow = $database->queryFirstRow("SELECT * FROM image WHERE Title=%s", $title); $imageId = $existingImageRow ? $existingImageRow["Id"] : GUID(); $row = array("Id" => $imageId, "LastChangeDateTimeUtc" => $database->sqleval("utc_timestamp()"), "IsDeleted" => "0", "Title" => $title, "Height" => $imageInfo[1], "Width" => $imageInfo[0], "MimeType" => $imageInfo['mime'], "FileSizeInBytes" => strlen($imageData), "Url" => sprintf("{Endpoint}/ImageData/%s", $imageId)); if (!$existingImageRow) { $database->insert("imagedata", array("Id" => $row["Id"], "Data" => $imageData)); $database->insert("image", $row); } else { $existingDataRow = $database->queryFirstRow("SELECT * FROM imagedata WHERE Id=%s", $imageId); if ($existingDataRow["Data"] != $imageData) { $database->update("imagedata", array("Id" => $row["Id"], "Data" => $imageData), "Id=%s", $imageId); $database->update("image", $row, "Id=%s", $imageId); } } return $imageId; }
/** * Resetoidaan käyttäjän salasana, joko käyttäjän toimesta, tai ylläpidollisista syistä. * Lähettää käyttäjälle linkin sähköpostilla pw_reset-sivulle, tai jos salasana vanhentunut: * ohjaa suoraan kyseiselle sivulle. * @param DByhteys $db * @param stdClass $user * @param string $reset_mode <p> onko kyseessä 'reset' vai 'expired'. Eka lähettää linkin, toka ohjaa suoraan. */ function password_reset(DByhteys $db, stdClass $user, $reset_mode) { $key = GUID(); $key_hashed = sha1($key); $sql_query = "\tINSERT INTO pw_reset (kayttaja_id, reset_key_hash)\n\t\t\t\t\tVALUES ( ?, ? )"; $db->query($sql_query, [$user->id, $key_hashed]); if ($reset_mode == "expired") { //Jos salasana vanhentunut, ohjataan suoraan salasananvaihtosivulle header("Location:pw_reset.php?id={$key}"); exit; } else { // jos salasanaa pyydetty sähköpostiin, lähetetään linkki laheta_salasana_linkki($user->sahkoposti, $key); header("Location:index.php?redir=6"); exit; // Palautuslinkki lähetetty } }
public function __add_to_cart($item_id, $sides) { $item = DB::queryOneRow("SELECT * FROM menu_items WHERE id=%s", $item_id); $existing_uid = DB::queryOneRow("SELECT uid FROM carts WHERE user_id=%s AND cart_type=%s AND active=%d", $this->data["uid"], $item["service_id"], 1); if (DB::count() != 0) { $uid = $existing_uid["uid"]; } else { $uid = GUID(); } DB::query("UPDATE carts SET quantity=quantity+1 WHERE item_id=%s AND user_id=%s AND cart_type=%s AND active=%d", $item_id, $this->data["uid"], $item["service_id"], 1); if (DB::affectedRows() == 0) { DB::insert("carts", array("uid" => $uid, "cart_type" => $item["service_id"], "item_id" => $item_id, "user_id" => $this->data["uid"])); } if (count($sides) > 0) { foreach ($sides as $sk => $sv) { DB::query("UPDATE cart_sides SET quantity=quantity+1 WHERE cart_entry_uid=%s AND side_id=%s", $uid, $sv); if (DB::affectedRows() == 0) { DB::insert("cart_sides", array("cart_entry_uid" => $uid, "side_id" => $sv)); } } } return $this->get_cart($item["category_id"]); // DB::sqleval("NOW()") }
if ($op == 'print') { disableWebCache(); load()->web('print'); $id = intval($_GPC['id']); $chips = biz_getChips($id, true); $printTitle = '定金交款'; $type = 3; $msg = ''; $enable = print_checkChipsEnable($chips, $type, $msg); if ($enable) { if ($_W['token'] == $_GPC['token']) { $bill = biz_getBill($chips['qrcode'], 2, null); if ($chips['ordermoney'] == 0) { //已足定,没有票据,生成票据0 if (empty($bill)) { $inputBill = array('BillGUID' => GUID(), 'Money' => 0, 'finance' => array(array('money' => 0, 'note' => '足定换票'))); if (!biz_addBill($chips, $inputBill, 2)) { message('生成票据,保存数据失败!', $url, 'error'); } $bill = biz_getBill($chips['qrcode'], 2, 0); } } //更新没有打印生成票据的数据 if (!empty($bill) && empty($bill['Printed'])) { if (!biz_updateBillOfInvoNo($bill)) { message('生成票据单号失败,请重新打印!', $this->createWebUrl($do), 'error'); } } //未改变状态 if (!biz_checkChipsStatus($chips, 7)) { load()->web('app');
// $validationMessage = "Please enter your zip code"; // $messages = "\nMissing zip code\n"; // } if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { $invalid = TRUE; $validationMessage = "Please enter a valid email address"; $messages = "\nInvalid email address: " . $email . "\n"; } } if ($invalid) { // email is invalid echo "<html><body>" . "<script language='javascript'>alert('" . $validationMessage . "'); window.history.back();</script>" . "</body></html>"; $submitToESM = FALSE; $redirect = FALSE; } $guid = GUID(); setcookie('leadid', $guid, 0, '/'); $timeStamp = date("Y-m-d H:i:s"); $errorMessage = ""; //New tracking: L1 - type, L2 - channel, L3 - vendor, L4 - campaign if (isset($_POST['type'])) { $type = $_POST['type']; } elseif (isset($_COOKIE['type'])) { $type = $_COOKIE['type']; } else { $type = 'Paid'; } if (isset($_POST['channel'])) { $channel = $_POST['channel']; } elseif (isset($_COOKIE['channel'])) { $channel = $_COOKIE['channel'];
function login($username, $password, $codestring = '', $captcha = '') { global $bdstoken; request('http://pan.baidu.com/'); if ($codestring == '') { $captcha = loginCheck($username); if ($captcha) { $ret['errno'] = 257; $ret['code_string'] = $captcha; $ret['captcha'] = 'https://passport.baidu.com/cgi-bin/genimage?' . $captcha; return $ret; } } $guid = GUID(); getToken($guid); //加密登录不太灵,不知道怎么回事,抽风似的,不用了 /*$_key = request('https://passport.baidu.com/v2/getpublickey?token='.$bdstoken); $key = json_decode(str_replace("'", '"', $_key['body']), true); if (!isset($key['pubkey']) || !isset($key['key'])) { echo '无法获取public key!请联系开发者!服务器返回:'.$_key['body']; die(); } $pubkey = openssl_pkey_get_public($key['pubkey']); openssl_public_encrypt($password, $crypted_password, $pubkey); $crypted_password = base64_encode($crypted_password); $result = request('https://passport.baidu.com/v2/api/?login', "charset=utf-8&tpl=netdisk&subpro=netdisk_web&apiver=v3&tt=".time()."&token=$bdstoken&loginmerge=true&safeflg=0&codestring=$codestring&detect=1&foreignusername=&gid=&idc=&isPhone=&loglogintype=pc_loginBasic&logintype=basicLogin&mem_pass=on&password=$crypted_password&rsakey={$key['key']}&crypttype=12&quick_user=0&safeflag=0&staticpage=http://pan.baidu.com/res/static/thirdparty/pass_v3_jump.html&u=http://pan.baidu.com/&username=$username&countrycode=&verifycode=$captcha&gid=$guid&ppui_logintime=".mt_rand(10000, 15000));*/ $result = request('https://passport.baidu.com/v2/api/?login', "charset=utf-8&tpl=netdisk&subpro=netdisk_web&apiver=v3&tt=" . time() . "&token={$bdstoken}&loginmerge=true&safeflg=0&codestring={$codestring}&detect=1&foreignusername=&gid=&idc=&isPhone=&loglogintype=pc_loginBasic&logintype=basicLogin&mem_pass=on&password={$password}&quick_user=0&safeflag=0&staticpage=http://pan.baidu.com/res/static/thirdparty/pass_v3_jump.html&u=http://pan.baidu.com/&username={$username}&countrycode=&verifycode={$captcha}&gid={$guid}&ppui_logintime=" . mt_rand(10000, 15000)); parse_str(findBetween($result['body'], 'href += "', '"'), $output); if (!isset($output['err_no'])) { echo '无法登录!请联系开发者!服务器返回:<xmp>' . $result['body']; die; } $ret['errno'] = $output['err_no']; if (strlen($output['codeString'])) { $ret['code_string'] = $output['codeString']; $ret['captcha'] = 'https://passport.baidu.com/cgi-bin/genimage?' . $output['codeString']; } return $ret; }
function pre_submission_handler($form) { $guid = GUID(); $_POST['input_3'] = $guid; $_POST['input_5'] = 'http://automationlab.com.au/checkin?q=http://app.automationlab.com.au/q/' . $guid . '/[Email]'; }
/** * $value: 付款明细,$room:房间信息,$chips: 认筹信息,$id :tradeGUID, * 获得供款明细的插入规则 * 返回 array() $fee, */ function get_s_feearray($value, $room, $chips) { $fee = array('FeeGUID' => GUID(), 'ProjGUID' => $chips['projguid'], 'TradeGUID' => $chips['qrcode'], 'ItemName' => $value['ItemName'], 'ItemType' => $value['FeeSort'], 'Sequence' => $value['Sequence'], 'Bz' => '人民币', 'ExRate' => 1.0, 'JmLateFee' => 0, 'IsChg' => 0, 'OutAmount' => 0, 'OutRmbAmount' => 0, 'DsAmount' => 0, 'RmbDsAmount' => 0, 'IsBcXyKx' => 0); if ($value['Action'] == "签署认购书") { $add = '+' . (empty($value['ActiDays']) ? '' : "{$value['ActiDays']} days") . (empty($value['ActiMonth']) ? '' : "{$value['ActiMonth']} months"); $fee['lastDate'] = date("Y-m-d", strtotime($add, TIMESTAMP)); $fee['lastDate'] = date("Y-m-d", strtotime('-1 days', strtotime($fee['lastDate']))); } else { $fee['lastDate'] = null; } //增加比例存储 $fee['Rate'] = $value['Rate']; // 是否扣除定金交款 if ($value['IsDeductEarnest'] == 1) { // 判断是打折,还是金额, if ($value['Rate'] > 0) { $fee['Amount'] = $room['RoomTotal'] * $value['Rate'] / 100.0 - $chips['ordermoney'] - $chips['premoney']; } else { $fee['Amount'] = $value['Amount'] - $chips['ordermoney'] - $chips['premoney']; } } else { if ($value['Rate'] > 0) { $fee['Amount'] = $room['RoomTotal'] * $value['Rate'] / 100.0; } else { $fee['Amount'] = $value['Amount']; } } $fee['RmbAmount'] = $fee['Amount']; if ($fee['ItemName'] == "银行按揭") { //取万元整数 $fee['Amount'] = intval($fee['RmbAmount'] / 10000) * 10000; } // 计算余额 if ($fee['ItemName'] == '定金') { $fee['Ye'] = $fee['Amount'] - $chips['ordermoney'] - $chips['premoney']; } else { $fee['Ye'] = $fee['Amount']; } // 计算RmbYe $fee['RmbYe'] = $fee['Ye']; // if ($fee['Ye'] == 0) { // $fee['Flag'] = '√'; // } else { // $fee['Flag'] = null; // } return $fee; }
/** * 添加商品 * */ public function create() { if (IS_POST) { $base_attr = $this->getBaseAttr(); $storeid = I('storeid', 0); if ($storeid == 0) { $this->error("缺少商铺ID参数"); } $attrext = array('isPostFree' => 1, 'isHasReceipt' => I('post.ishasreceipt', 0), 'isUnderGuaranty' => I('post.isunderguaranty', 0), 'isSupportReplace' => I('post.issupportreplace', 0), 'location' => array('country' => '中国', 'province' => '四川省', 'city' => '内江市', 'address' => '威远县')); $sku_list = $this->getSKUList(); $product = array('product_base' => $base_attr, 'attrext' => $attrext, 'sku_list' => $sku_list); $product_id = GUID(); $result = $this->addToProduct($storeid, $product_id, $product); if ($result['status']) { $this->success("操作成功!", U('Admin/WxshopProduct/index', array('storeid' => $storeid))); } else { $this->error($result['info']); } } else { $catename = I('catename', ''); $storeid = I('storeid', 0); $cates = I("get.cates", ''); $cates = explode("_", $cates); if (count($cates) <= 1) { $this->error("商品类目错误!"); } $this->assign("cate_id", $cates[count($cates) - 1]); $this->assign("storeid", $storeid); $this->assign("catename", $catename); $this->assign("cates", I('cates', '')); $this->display(); } }
$res = array('ok' => false, 'msg' => ''); //检查项目授权,是否允许项目传输 if ($func == 'get_token') { //检查是否存在token? $guid = trim($_GPC['guid']); $key = 'sync_' . $guid; $token = memcached_get($key); if ($token == '') { $project = db_getProject($guid, true); if (empty($project)) { $res['msg'] = '无效的参数'; returnJson($res); } if (memcached_addKey('Add' . $key)) { $data = array('guid' => $guid, 'ip' => CLIENT_IP); $token = GUID(); memcached_set($key, $token, 300); memcached_set('sync_t_' . $token, $data, 300); memcached_delete('Add' . $key); $res['ok'] = true; $res['token'] = $token; } else { $res['msg'] = '无法增加cache数据'; } } else { $res['msg'] = '此项目已有下载未完成,请等5分钟再试'; } returnJson($res); } if ($func == 'release_token') { $token = $_GPC['token'];
$project = $_W['project']; $banks = biz_getBanks($project['BUGUID']); $project = biz_getProject($project['projguid']); $bank = biz_unserializer($project, 'bank'); } //是否允许修改 if (checksubmit()) { if (empty($inputBill)) { message('认筹单无效数据,不能交款!', $url, 'error'); } //保存中 $updateMoney = biz_getInput2Bill($inputBill); if (empty($inputBill['BillGUID'])) { // 插入票据单相关信息 if ($inputBill['Money'] > 0) { $inputBill['BillGUID'] = GUID(); if (!biz_addBill($chips, $inputBill)) { $updateMoney = false; message('认筹单诚意金交款,保存数据失败!', $url, 'error'); } } } else { $update = array('Money' => $inputBill['Money'], 'Details' => iserializer($inputBill['finance'])); $updateMoney = pdo_update('bill', $update, array('BillGUID' => $inputBill['BillGUID'])); } if ($updateMoney !== false) { $premoney = $inputBill['Money']; foreach ($printed_Bills as $b) { $premoney += $b['Money']; } $data = array('status' => $status['付款'], 'changetime' => TIMESTAMP, 'pretype' => 1, 'premoney' => $premoney, 'preattach' => $inputBill['BillGUID']);
<meta charset="UTF-8"> <title></title> </head> <body> <?php include_once 'IwalletConnector.class.php'; $paylive = "https://i-walletlive.com/payLIVE/detailsnew.aspx?pay_token="; $ns = "http://www.i-walletlive.com/payLIVE"; $wsdl = "https://i-walletlive.com/paylive/paymentservice.asmx?wsdl"; $api_version = "1.4"; $merchant_email = "*****@*****.**"; $merchant_secret_key = "yourmerchantkey"; $service_type = "C2B"; $integration_mode = true; $iwl = new IwalletConnector($ns, $wsdl, $api_version, $merchant_email, $merchant_secret_key, $service_type, $integration_mode); $order_id = GUID(); $comment1 = ""; $comment2 = ""; $order_items = array(); $chromecast_unit_price = 150; $chromecast_quantity = 2; $chromecast_subtotal = $chromecast_unit_price * $chromecast_quantity; $organza_unit_price = 50; $organza_quantity = 2; $organza_subtotal = $organza_unit_price * $organza_quantity; $order_items[0] = $iwl->buildOrderItem("001", "chromecast", $chromecast_unit_price, $chromecast_quantity, $chromecast_subtotal); $order_items[1] = $iwl->buildOrderItem("002", "organza", $organza_unit_price, $organza_quantity, $organza_subtotal); $sub_total = $chromecast_subtotal + $organza_subtotal; $shipping_cost = 30; $tax_amount = 0; $total = $sub_total + $shipping_cost + $tax_amount;
function ugf_form($form_id) { global $wpdb; $sql = "select * from " . $wpdb->prefix . "ugf_forms where id = '%d'"; $psql = $wpdb->prepare($sql, $form_id); $row = $wpdb->get_row($psql); if (!$row->enable_form) { return; } $form_start_date = $row->form_start_date; $form_end_date = $row->form_end_date; $cdate = date('Y-m-d'); $show = false; if ($form_start_date == '0000-00-00' && $form_end_date == '0000-00-00') { $show = true; } else { if ($form_start_date != '0000-00-00' && $form_end_date != '0000-00-00') { if ($form_start_date <= $cdate && $form_end_date >= $cdate) { $show = true; } } else { if ($form_start_date != '0000-00-00') { if ($form_start_date <= $cdate) { $show = true; } } else { if ($form_end_date != '0000-00-00') { if ($form_end_date >= $cdate) { $show = true; } } } } } if ($show == false) { return; } $captcha_msg = $row->captcha_msg; if (!$captcha_msg) { $captcha_msg = 'Please Enter text shown in the image'; } $sql = "select * from " . $wpdb->prefix . "ugf_fields where form_id = '%d' order by ordering asc"; $psql = $wpdb->prepare($sql, $form_id); $fields_row = $wpdb->get_results($psql); /* $row['form_name']; $row['post_method']; $row['form_prefix_html']; $row['form_postfix_html']; $row['form_classes']; $row['form_start_date']; $row['form_end_date']; */ $html = ''; if ($row->form_prefix_html) { $html .= $row->form_prefix_html; } if (isset($_SESSION['form_success'])) { $html .= $_SESSION['form_success']; $_SESSION['form_success'] = ''; } $html .= '<form action="' . $_SERVER['REQUEST_URI'] . '" id="' . $row->form_name . '" method="' . $row->post_method . '" '; if ($row->form_classes) { $html .= ' class="' . $row->form_classes . '" '; } $form_token = GUID(); $_SESSION['form_token'] = $form_token; $html .= ' enctype="multipart/form-data">'; $html .= '<input type="hidden" name="ugfform_id" value="' . $row->id . '">'; $html .= '<input type="hidden" name="ugfform_token" value="' . $_SESSION['form_token'] . '">'; $html .= '<input type="hidden" name="ugfform_url" value="' . $_SERVER['REQUEST_URI'] . '">'; for ($i = 0; $i < count($fields_row); ++$i) { $field_type = $fields_row[$i]->field_type; $lbl_wrapper_class = $fields_row[$i]->lbl_wrapper_class; $field_wrapper_class = $fields_row[$i]->field_wrapper_class; $field_class = $fields_row[$i]->field_class; $field_id = $fields_row[$i]->id; $sql = "select * from " . $wpdb->prefix . "ugf_fields_attributes where field_id = '%d'"; $psql = $wpdb->prepare($sql, $field_id); $attr_row = $wpdb->get_results($psql); $attr_array = array(); for ($k = 0; $k < count($attr_row); ++$k) { $attr_array[$attr_row[$k]->attribute_name] = $attr_row[$k]->attribute_value; } $sql = "select * from " . $wpdb->prefix . "ugf_fields_validations where field_id = '%d'"; $psql = $wpdb->prepare($sql, $field_id); $validation_row = $wpdb->get_results($psql); if ($field_type == 'text') { $html .= '<div class="ufg-control">'; $html .= '<div class="ufg-control-label ugf-' . $fields_row[$i]->lbl_placement . ' ' . $lbl_wrapper_class . '">'; $html .= '<label for="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" >'; $html .= $fields_row[$i]->label_prefix; $html .= $fields_row[$i]->field_label; $html .= $fields_row[$i]->label_suffix; $html .= '</label>'; $html .= '</div>'; $html .= '<div class="ufg-control-input ' . $field_wrapper_class . '">'; $html .= $fields_row[$i]->field_prefix_html; $html .= '<input type="text" id="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" name="ugf' . $fields_row[$i]->field_machine_name . '"'; $html .= ' class="' . $field_class . ' fld-' . $fields_row[$i]->field_machine_name . '" '; if ($attr_array['size'] > 0) { $html .= ' size="' . $attr_array['size'] . 'px" '; } $html .= '>'; if (isset($_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name])) { $html .= '<div class="ugf-error">' . $_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name] . '</div>'; } $html .= $fields_row[$i]->field_postfix_html; $html .= '</div>'; $html .= '</div>'; } if ($field_type == 'select') { $html .= '<div class="ufg-control">'; $html .= '<div class="ufg-control-label ugf-' . $fields_row[$i]->lbl_placement . ' ' . $lbl_wrapper_class . '">'; $html .= '<label for="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" >'; $html .= $fields_row[$i]->label_prefix; $html .= $fields_row[$i]->field_label; $html .= $fields_row[$i]->label_suffix; $html .= '</label>'; $html .= '</div>'; $html .= '<div class="ufg-control-input ' . $field_wrapper_class . '">'; $html .= $fields_row[$i]->field_prefix_html; $html .= '<select id="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" name="ugf' . $fields_row[$i]->field_machine_name . '"'; $html .= ' class="' . $field_class . ' fld-' . $fields_row[$i]->field_machine_name . '" '; for ($k = 0; $k < count($attr_row); ++$k) { if ($attr_row[$k]->attribute_name == 'options') { $options = $attr_row[$k]->attribute_value; } } $html .= '>'; $options_arr = explode(chr(13), $options); if (isset($attr_array['first_row_blank']) && $attr_array['first_row_blank'] == 1) { $html .= '<option value="" ></option>'; } foreach ($options_arr as $item) { $kv = explode("|", $item); if (trim($kv[1]) != '') { if (trim($attr_array['default']) == trim($kv[0])) { $html .= '<option value="' . trim($kv[0]) . '" selected="selected">' . trim($kv[1]) . '</option>'; } else { $html .= '<option value="' . trim($kv[0]) . '">' . trim($kv[1]) . '</option>'; } } } $html .= '</select>'; if (isset($_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name])) { $html .= '<div class="ugf-error">' . $_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name] . '</div>'; } $html .= $fields_row[$i]->field_postfix_html; $html .= '</div>'; $html .= '</div>'; } if ($field_type == 'radio') { $html .= '<div class="ufg-control">'; $html .= '<div class="ufg-control-label ugf-' . $fields_row[$i]->lbl_placement . ' ' . $lbl_wrapper_class . '">'; $html .= '<label for="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" >'; $html .= $fields_row[$i]->label_prefix; $html .= $fields_row[$i]->field_label; $html .= $fields_row[$i]->label_suffix; $html .= '</label>'; $html .= '</div>'; $html .= '<div class="ufg-control-input ' . $field_wrapper_class . '">'; $html .= $fields_row[$i]->field_prefix_html; for ($k = 0; $k < count($attr_row); ++$k) { if ($attr_row[$k]->attribute_name == 'options') { $options = $attr_row[$k]->attribute_value; } } $options_arr = explode(chr(13), $options); $default = ''; if (isset($attr_array['default'])) { $default = $attr_array['default']; } foreach ($options_arr as $item) { $kv = explode("|", $item); $html .= ' <div class="' . $fields_row[$i]->field_machine_name . trim($kv[0]) . '">'; $html .= '<input type="radio" id="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . trim($kv[0]) . '" name="ugf' . $fields_row[$i]->field_machine_name . '"'; $html .= ' class="' . $field_class . ' fld-' . $fields_row[$i]->field_machine_name . trim($kv[0]) . '" '; if ($default == trim($kv[0])) { $html .= ' checked="checked" '; } $html .= ' value="' . trim($kv[0]) . '"> ' . trim($kv[1]) . '</div>'; } if (isset($_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name])) { $html .= '<div class="ugf-error">' . $_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name] . '</div>'; } $html .= $fields_row[$i]->field_postfix_html; $html .= '</div>'; $html .= '</div>'; } if ($field_type == 'checkbox') { $html .= '<div class="ufg-control">'; $html .= '<div class="ufg-control-label ugf-' . $fields_row[$i]->lbl_placement . ' ' . $lbl_wrapper_class . '">'; $html .= '<label for="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" >'; $html .= $fields_row[$i]->label_prefix; $html .= $fields_row[$i]->field_label; $html .= $fields_row[$i]->label_suffix; $html .= '</label>'; $html .= '</div>'; $html .= '<div class="ufg-control-input ' . $field_wrapper_class . '">'; $html .= $fields_row[$i]->field_prefix_html; for ($k = 0; $k < count($attr_row); ++$k) { if ($attr_row[$k]->attribute_name == 'options') { $options = $attr_row[$k]->attribute_value; } } $options_arr = explode(chr(13), $options); foreach ($options_arr as $item) { if ($item != '') { $kv = explode("|", $item); if (count($kv) > 0 && $kv[1] != '') { $html .= ' <div class="' . $fields_row[$i]->field_machine_name . trim($kv[0]) . '"> <input type="checkbox" id="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . trim($kv[0]) . '" name="ugf' . $fields_row[$i]->field_machine_name . '[]"'; $html .= ' class="' . $field_class . ' fld-' . $fields_row[$i]->field_machine_name . trim($kv[0]) . '" '; $html .= 'value="' . trim($kv[0]) . '"> ' . trim($kv[1]) . '</div>'; } } } if (isset($_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name])) { $html .= '<div class="ugf-error">' . $_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name] . '</div>'; } $html .= $fields_row[$i]->field_postfix_html; $html .= '</div>'; $html .= '</div>'; } if ($field_type == 'date') { $html .= '<div class="ufg-control">'; $html .= '<div class="ufg-control-label ugf-' . $fields_row[$i]->lbl_placement . ' ' . $lbl_wrapper_class . '">'; $html .= '<label for="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" >'; $html .= $fields_row[$i]->label_prefix; $html .= $fields_row[$i]->field_label; $html .= $fields_row[$i]->label_suffix; $html .= '</label>'; $html .= '</div>'; $html .= '<div class="ufg-control-input ' . $field_wrapper_class . '">'; $html .= $fields_row[$i]->field_prefix_html; $html .= '<input type="text" id="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" name="ugf' . $fields_row[$i]->field_machine_name . '"'; $html .= ' class="' . $field_class . ' fld-' . $fields_row[$i]->field_machine_name . '" '; $html .= '>'; if (isset($_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name])) { $html .= '<div class="ugf-error">' . $_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name] . '</div>'; } $html .= $fields_row[$i]->field_postfix_html; $html .= '</div>'; $html .= '</div>'; $date_format = 'mm/dd/yy'; if (isset($attr_array['date_format'])) { $date_format = $attr_array['date_format']; } $html .= '<script>'; $html .= 'jQuery(function() {'; $html .= 'jQuery( "#ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" ).datepicker({'; $html .= 'changeMonth: true,'; $html .= 'changeYear: true,'; $html .= 'dateFormat: "' . $date_format . '"'; $html .= '});'; $html .= '});'; $html .= '</script>'; } if ($field_type == 'file' || $field_type == 'image') { $html .= '<div class="ufg-control">'; $html .= '<div class="ufg-control-label ugf-' . $fields_row[$i]->lbl_placement . ' ' . $lbl_wrapper_class . '">'; $html .= '<label for="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" >'; $html .= $fields_row[$i]->label_prefix; $html .= $fields_row[$i]->field_label; $html .= $fields_row[$i]->label_suffix; $html .= '</label>'; $html .= '</div>'; $html .= '<div class="ufg-control-input ' . $field_wrapper_class . '">'; $html .= $fields_row[$i]->field_prefix_html; $html .= '<input type="file" id="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" name="ugf' . $fields_row[$i]->field_machine_name . '"'; $html .= ' class="' . $field_class . '" '; for ($k = 0; $k < count($attr_row); ++$k) { } $html .= '>'; if (isset($_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name])) { $html .= '<div class="ugf-error">' . $_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name] . '</div>'; } $html .= $fields_row[$i]->field_postfix_html; $html .= '</div>'; $html .= '</div>'; } if ($field_type == 'textarea') { $rows = $attr_array['rows']; $cols = $attr_array['cols']; if (!$rows) { $rows = 3; } if (!$cols) { $cols = 30; } $html .= '<div class="ufg-control">'; $html .= '<div class="ufg-control-label ugf-' . $fields_row[$i]->lbl_placement . ' ' . $lbl_wrapper_class . '">'; $html .= '<label for="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" >'; $html .= $fields_row[$i]->label_prefix; $html .= $fields_row[$i]->field_label; $html .= $fields_row[$i]->label_suffix; $html .= '</label>'; $html .= '</div>'; $html .= '<div class="ufg-control-input ' . $field_wrapper_class . '">'; $html .= $fields_row[$i]->field_prefix_html; $html .= '<textarea id="ugf-' . $form_id . '-' . $fields_row[$i]->field_machine_name . '" name="ugf' . $fields_row[$i]->field_machine_name . '"'; $html .= ' class="' . $field_class . ' ' . $fields_row[$i]->field_machine_name . '" '; $html .= ' rows="' . $rows . '" '; $html .= ' cols="' . $cols . '" '; for ($k = 0; $k < count($attr_row); ++$k) { } $html .= '>'; $html .= '</textarea>'; if (isset($_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name])) { $html .= '<div class="ugf-error">' . $_SESSION['ugform']['error'][$fields_row[$i]->field_machine_name] . '</div>'; } $html .= $fields_row[$i]->field_postfix_html; $html .= '</div>'; $html .= '</div>'; } } $url = plugins_url() . '/data-collection-form'; if ($row->captcha == 1) { $html .= '<div class="ufg-control">'; $html .= '<div class="captch-msg">' . $captcha_msg . '</div>'; $html .= '<div class="captch-input">'; $html .= '<input name="ugfcaptcha" type="text">'; if (isset($_SESSION['ugform']['error']['ugfcaptcha'])) { $html .= '<div class="ugf-error">' . $_SESSION['ugform']['error']['ugfcaptcha'] . '</div>'; } $html .= '</div>'; $html .= '<div class="captch-img">'; $html .= '<img src="' . $url . '/captcha.php" />'; $html .= '</div>'; $html .= '</div>'; } $html .= '<div class="ufg-control"><button type="submit" >Submit</button></div>'; $html .= '</form>'; if ($row->form_postfix_html) { $html .= $row->form_postfix_html; } $_SESSION['ugform']['error'] = ''; return $html; }
public function doWebTemplate() { global $_W, $_GPC; $op = !empty($_GPC['op']) ? $_GPC['op'] : 'list'; $printtype = biz_getDictionary('printtype'); if ($op == 'list') { $pindex = max(1, intval($_GPC['page'])); $psize = 20; $table = 'printtemplate'; $sql = "SELECT * FROM " . tablename($table) . " limit " . ($pindex - 1) * $psize . "," . $psize; $list = pdo_fetchall($sql); $total = pdo_fetchcolumn(" select count(*) from " . tablename($table)); $pager = pagination($total, $pindex, $psize); include $this->template('template_list'); exit; } if ($op == 'delete') { $this->CheckRight('deltemp'); $id = $_GPC['id']; $template = db_getPrintTemplate($id); if (!empty($template)) { pdo_delete('printtemplate', array('id' => $template['id'])); exit('success'); } else { exit('无效数据!'); } } if ($op == 'down') { $id = $_GPC['id']; $template = db_getPrintTemplate($id); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Content-Type:application/force-download"); header("Content-Type: application/vnd.ms-word;charset=UTF-8"); header("Content-Type:application/octet-stream"); header("Content-Type:application/download"); $ua = $_SERVER["HTTP_USER_AGENT"]; $filename = $template['title'] . ".docx"; if (preg_match("/MSIE/", $ua)) { $filename = urlencode($filename); header('Content-Disposition: attachment; filename=' . $filename); } else { header('Content-Disposition: attachment; filename=' . $filename); } header("Content-Transfer-Encoding:binary"); echo base64_decode($template['content']); exit; } load()->web('print'); if ($op == 'post') { $this->CheckRight('addtemp'); if (checksubmit()) { if (!empty($_FILES['wordfile']['name'])) { if ($_FILES['wordfile']['error'] != 0) { message('文件上传失败,请重试!', $this->createWebUrl('template', array('op' => 'post')), 'error'); } } else { message('请选择要上传的模板!', $this->createWebUrl('template', array('op' => 'post')), 'warning'); } $word = GetUploadFile('wordfile'); if (empty($word)) { message('上传文件失败,目录无写入权限!', $this->createWebUrl('template', array('op' => 'post')), 'error'); } $tags = GetTagsOfXml($word); if (empty($tags)) { message('无效的模板文件,无法读取标签!', $this->createWebUrl('template', array('op' => 'post')), 'error'); } $data = array('id' => GUID(), 'title' => trim($_GPC['title']), 'printtype' => $_GPC['printtype'], 'tags' => iserializer($tags), 'content' => base64_encode(file_get_contents($word)), 'tagsnum' => count($tags), 'status' => '0', 'createtime' => TIMESTAMP); @unlink($word); if (empty($data['title'])) { $data['title'] = $_FILES['wordfile']['name']; } if (!empty($_GPC['onlyCurr'])) { $data['project'] = $_W['project']['projguid']; } pdo_insert('printtemplate', $data); //$test=biz_Print_getTemplateById($data['id']); message('保存数据成功!', $this->CreateWebUrl('template')); } include $this->template('template_post'); exit; } if ($op == 'tags') { $id = $_GPC['id']; $template = db_getPrintTemplate($id, true); if (empty($template)) { if ($_W['isajax']) { echo '无效参数,无法获取模板信息'; exit; } } $disable = !empty($template['status']); $url = $this->createWebUrl('template', array('op' => $op, 'id' => $id)); $map = $template['datamap']; $fields = biz_Print_getDataField($template['printtype']); if (empty($map)) { $map = array(); foreach ($template['tags'] as $t) { $map[$t] = ''; } } $json = json_encode($map); if ($_W['isajax']) { include $this->template('tagEdit'); exit; } if ($_W['token'] == $_GPC['token']) { $map = json_decode(htmlspecialchars_decode($_GPC['json'])); $map = object_to_array($map); if (!$disable) { $update = array('datamap' => iserializer($map)); pdo_update('printtemplate', $update, array('id' => $id)); message('模板标签数据已配置', $this->createWebUrl('template')); } else { message('模板已启用,不允许修改', $this->createWebUrl('template')); } } } if ($op == 'set') { $this->CheckRight('tag'); $id = $_GPC['id']; $template = db_getPrintTemplate($id, true); if (empty($template)) { message('无效打印模板', $this->createWebUrl('template'), 'error'); } $disable = !empty($template['status']); $url = $this->createWebUrl('template', array('op' => 'set', 'id' => $id)); $map = $template['datamap']; $fields = biz_Print_getDataField($template['printtype']); if (empty($map)) { $map = array(); foreach ($template['tags'] as $t) { $map[$t] = ''; } } if ($_W['token'] == $_GPC['token']) { if (!$disable) { $update = array('datamap' => iserializer($_GPC['map'])); pdo_update('printtemplate', $update, array('id' => $id)); message('模板标签数据已配置', $this->createWebUrl('template')); } else { message('模板已启用,不允许修改', $this->createWebUrl('template')); } } include $this->template('tagSet2'); } }
} else { if ($step == 2) { $user_info = $_GPC['user']; $input_save = base64_encode(iserializer($user_info)); $step = 3; } else { if ($step == 3) { $data = $_GPC['chips']; //处理销售人员信息 $salesman = biz_getStationUser($_W['project']['projguid'], false); $data['salesmanGUID'] = $data['sales']; $data['salesman'] = $salesman[$data['sales']]['UserName']; $data['user'] = iunserializer(base64_decode($_GPC['user'])); $data['projguid'] = $_W['project']['projguid']; unset($data['sales']); $data['qrcode'] = GUID(); //$data['qrimage']=$this->geneQrcodeImg($data['qrcode']); $data['status'] = 1; $result = biz_saveChips($data); if ($result['result']) { message('数据增加成功!', $this->createWebUrl($do)); } else { message('数据保存出错:' . $result['msg'], $this->createWebUrl($do), 'error'); } } } } } if ($step == 2) { $cardTypes = biz_getDictionary('CardType'); $khTypes = biz_getDictionary('kehuType');
function uploadImage($file) { $name = $file['name']; $size = $file['size']; $tmp_l = $file['tmp_name']; $tn = explode(".", $name); $ext = end($tn); $allowed_extensions = explode(",", getSetting("imageexts")); $gid = GUID(50); $gname = sprintf("../../images/%s.%s", $gid, $ext); while (file_exists($gname)) { $gid = GUID(50); $gname = sprintf("../../images/%s.%s", $gid, $ext); } // valid name, proceed if (in_array($ext, $allowed_extensions)) { $result = move_uploaded_file($tmp_l, $gname); if ($result) { return sprintf("%s.%s", $gid, $ext); } } return -1; }
function erp_Write_Customer($chips) { $write = false; $project = biz_getProject($chips['projguid']); $fields = array('CstGUID', 'CstName', 'CstType', 'KhFl', 'CardID', 'OfficeTel', 'HomeTel', 'MobileTel', 'PostCode', 'Address', 'CstType', 'Gender', 'CardType', 'WorkAddr', 'Country', 'CompanyPhone', 'signguid'); //要检查客户是否已录入 $info = biz_getChipsCustomerInfo($chips); $list = explode(',', $info['guid']); foreach ($list as $cid) { $customer = biz_getCustomerInfo(array('CstGUID' => $cid)); if (empty($customer['erp'])) { //$customer['CreatedBy']=$chips['creator']; $customer['CstType'] = '个人'; //$customer['KhFl']='普通客户'; $customer['signguid'] = $chips['projguid']; $write = MsSql()->insertObject('p_Customer', array_elements($fields, $customer)); // 生成CstAttach(客户项目对应表) } $exist = MsSql()->fetch('select * from p_CstAttach where ' . " CstGUID='{$cid}' and ProjGUID='{$chips['projguid']}'"); if ($write && empty($exist)) { $attach = array('CstAttachGUID' => GUID(), 'CstGUID' => $cid, 'ProjGUID' => $chips['projguid'], 'BUGUID' => $project['BUGUID'], 'signguid' => $chips['projguid']); $write = MsSql()->insertObject('p_CstAttach', $attach); if ($write === false) { logging('写入p_CstAttach出错', $cid); } } } return $write; }
} # проверяем, не сущестует ли пользователя с таким именем $query = mysql_query("SELECT COUNT(id) FROM users WHERE email='" . mysql_real_escape_string($email) . "'"); //or die ("<br>Invalid query: " . mysql_error()); if (mysql_result($query, 0) > 0) { $err[] = "User with this email already exists in the system."; //Пользователь с таким логином уже существует в базе данных } # Если нет ошибок, то добавляем в БД нового пользователя if (count($err) == 0) { $pswd = mb_strtolower(trim($_POST['password'])); $salt = substr(md5($email), 10, 20) . ""; $password = md5(md5($pswd) . $salt); mysql_query("INSERT INTO users SET email='" . $email . "', pswrd='" . $password . "'"); $uid = (string) mysql_insert_id(); $newVerCode = GUID(); mysql_query("INSERT INTO verifi (idusr, vercode) VALUES ({$uid}, '{$newVerCode}');"); // Отправляем письмо с проверочным адресом sendEMail(EMAIL_BOT, $email, "Verification PaperboD*", "Verification KEY: " . $newVerCode . "<br/><a href='" . URL_SITE_FULL . "/verifi/?k=" . $newVerCode . "'>Go verification</a>"); header("Location: /login/"); exit; } } require_once '../h.php'; ?> <form class="form-signin" role="form" method="POST" action=""> <h2 class="form-signin-heading">Please sign up</h2> <input type="email" name="email" id="reg_inp" class="form-control" placeholder="Email address" required autofocus> <input type="password" name="password" id="reg_inp" class="form-control" placeholder="Password" required> By clicking "Sign up", you agree to our <a href="#" data-toggle="modal" data-target="#myModalTerms">terms</a> of service.
function GetUploadFile($fileTag) { global $_W; $filename = $_FILES[$fileTag]['tmp_name']; $dest = IA_ROOT . '/' . $_W['config']['upload']['attachdir'] . '/' . GUID() . '.tmp'; @move_uploaded_file($filename, $dest); return file_exists($dest) ? $dest : false; }
<?php function GUID() { if (function_exists('com_create_guid') === true) { return trim(com_create_guid(), '{}'); } return sprintf('%04X%04X-%04X-%04X-%04X-%04X%04X%04X', mt_rand(0, 65535), mt_rand(0, 65535), mt_rand(0, 65535), mt_rand(16384, 20479), mt_rand(32768, 49151), mt_rand(0, 65535), mt_rand(0, 65535), mt_rand(0, 65535)); } echo GUID() . PHP_EOL;
require_once './../class/NewsletterSubscriberManager.class.php'; require_once './../includes/functions.inc.php'; require_once './../includes/SSMTP.inc.php'; ?> <body> <?php if (isset($_POST['newsletterSubscriberEmail'])) { include_once './partials/main.php'; extract($_POST); if (!filter_var($newsletterSubscriberEmail, FILTER_VALIDATE_EMAIL)) { $emailError = Constants::BAD_FORMAT; include './partials/registerform.php'; } else { $NSManager = new NewsletterSubscriberManager(); $NewsletterSubscriber = new NewsletterSubscriber(GUID(), GUID(), $newsletterSubscriberEmail); if ($NSManager->Create($NewsletterSubscriber)) { $mail = SSMTP::getInstance(); $mail->sendConfirmation($NewsletterSubscriber->getEmail(), $NewsletterSubscriber->getToken(), $NewsletterSubscriber->getUnregisterToken()); include './partials/successRegistration.php'; } else { $emailError = Constants::EMAIL_ALREADY_EXIST; include './partials/registerform.php'; } } } else { header('Location: index.php'); } ?> </body> <?php
$allPostVars = $app->request->post(); $CustomerID = $allPostVars['CustomerID']; $LocationID = $allPostVars['LocationID']; $TotalPrice = $allPostVars['TotalPrice']; $TotalSeconds = $allPostVars['TotalSeconds']; $CouponCodeID = $allPostVars['CouponCodeID']; $TaxID = $allPostVars['TaxID']; $SubTotal = $allPostVars['SubTotal']; $IsPaid = $allPostVars['IsPaid']; $IsApproved = 0; //$allPostVars['IsApproved']; $PaymentMethodID = $allPostVars['PaymentMethodID']; $ContentType = $allPostVars['ContentType']; $UploadedContentURL = $allPostVars['UploadedContentURL']; $BookingCode = $allPostVars['BookingCode']; $PublicKey = md5(GUID()); $Comments = $allPostVars['Comments']; $TimeSlotID = $allPostVars['TimeSlotID']; $PriceID = $allPostVars['PriceID']; try { $db = getDB(); $sth = $db->prepare("INSERT INTO nkvbooking (CustomerID,SubTotal,TimeSlotID,PriceID,LocationID,TotalPrice,TotalSeconds,CouponCodeID,TaxID,IsPaid,\n\t\tIsApproved,PaymentMethodID,UploadedContentURL,BookingCode,Comments,ContentType,PublicKey)\n VALUES (:CustomerID,:SubTotal,:TimeSlotID,:PriceID,:LocationID,:TotalPrice,:TotalSeconds,:CouponCodeID,:TaxID,:IsPaid,\n\t\t:IsApproved,:PaymentMethodID,:UploadedContentURL,:BookingCode,:Comments,:ContentType,:PublicKey)"); $sth->bindParam(':CustomerID', $CustomerID); $sth->bindParam(':SubTotal', $SubTotal); $sth->bindParam(':TimeSlotID', $TimeSlotID); $sth->bindParam(':PriceID', $PriceID); $sth->bindParam(':LocationID', $LocationID); $sth->bindParam(':TotalPrice', $TotalPrice); $sth->bindParam(':TotalSeconds', $TotalSeconds); $sth->bindParam(':CouponCodeID', $CouponCodeID); $sth->bindParam(':TaxID', $TaxID);
// retrieve user information $user = app('db')->table('accounts')->where('facebook_id', $fbuser->id)->first(); // log this user in! if (!empty($user)) { $cookies->set_cookie($user->uid); return redirect('/profile.php?p=2&m=6'); } // check if this email already exists and ask for password $user = app('db')->table('accounts')->where('email', 'like', $fbuser->email)->first(); if (!empty($user)) { // TODO: for now, do nothing; ask user to reset password $query = http_build_query(['email' => $fbuser->email, 'facebook_id' => $fbuser->id]); return redirect('/index.php?' . $query . '#facebook-connect'); } // attempt to sign this user up $uid = GUID(50); $salt = uniqid(mt_rand(), true); $user_id = app('db')->table('accounts')->insertGetId(['name' => $fbuser->name, 'uid' => $uid, 'email' => $fbuser->email, 'phone' => '', 'logintime' => '0', 'password_hash' => hash('sha512', $salt), 'password_salt' => $salt, 'session' => '0', 'facebook_id' => $fbuser->id]); if ($user_id > 0) { // manually set session; DB::update doesn't work for some reason $cookie_id = $cookies->set_cookie($uid); app('db')->table('accounts')->where('id', $user_id)->update(['session' => $cookie_id, 'logintime' => strval(time())]); return redirect('/profile.php?p=2&m=6'); } } catch (Exception $e) { return 'An error occurred'; } return redirect('/index.php?m=2'); }); // Social Authentication (Facebook) connect $app->post('/accounts/facebook/connect', function () use($app) {
preg_match_all($regexLinks, $entryMatches[4][$entryId], $linkMatches); foreach ($linkMatches[1] as $linkId => $linkTarget) { $linkText = $linkMatches[2][$linkId]; if (strtolower($linkText) == "image") { $imageTag = "info:import[" . strtolower($linkTarget) . "]"; $existingImageRow = $database->queryFirstRow("SELECT * FROM image WHERE Title=%s", $imageTag); if ($existingImageRow) { Log::info(sprintf(" Skipping import %s (exists)", $imageTag)); $images[] = $existingImageRow["Id"]; } else { Log::info(sprintf(" Fetching %s (new)", $imageTag)); $imageData = file_get_contents($linkTarget); $newImageId = insertOrUpdateImageByTitle($database, $imageData, $imageTag); $images[] = $newImageId; } } else { $links[] = array("Target" => $linkTarget, "Text" => $linkText); } } } $database->insert("Info", array("Id" => GUID(), "InfoGroupId" => $groupId, "LastChangeDateTimeUtc" => $database->sqleval("utc_timestamp()"), "IsDeleted" => "0", "Title" => trim($entry), "Text" => trim($entryMatches[2][$entryId]), "Position" => $epos, "ImageIds" => json_encode($images), "Urls" => json_encode($links))); $epos++; } } Log::info("Commiting changes to database"); $database->commit(); } catch (Exception $e) { var_dump($e->getMessage()); Log::error("Rolling back changes to database"); $database->rollback(); }
private function randInt() { srand(GUID()); return rand(10000000, 99999999); }
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Forms</title> <link rel="stylesheet" href="style.css"> </head> <body> <div class="dropzone"> <div class="dropzone-message">Drop files there</div> </div> <div class="main-container"> <form action="/?action=properties-card?guid=<?php echo GUID(); ?> " method="POST" class="form-container"> <div> <label>Title</label> <input type="text" name="title"> <div class="error">error</div> </div> <div> <label>Type</label> <select name="type"> <option value="1">villa</option> <option value="2">apartment</option> <option value="3">land</option> <option value="4">hotel</option> <option value="5">commercial property</option> <option value="6">other</option> </select>