About 23,780 results: "mysql_query"
Page 1 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On





  1. {
  2.     mysql_query("DROP TABLE IF EXISTS `fcms_config`")                   or die("fcms_config<br/>" . mysql_error());
  3.     mysql_query("DROP TABLE IF EXISTS `fcms_notification`")             or die("fcms_notification<br/>" . mysql_error());
  4.     mysql_query("DROP TABLE IF EXISTS `fcms_video_comment`")            or die("fcms_video_comment<br/>" . mysql_error());
  5.     mysql_query("DROP TABLE IF EXISTS `fcms_video`")                    or die("fcms_video<br/>" . mysql_error());
  6.     mysql_query("DROP TABLE IF EXISTS `fcms_changelog`")                or die("fcms_changelog<br/>" . mysql_error());
  7.     mysql_query("DROP TABLE IF EXISTS `fcms_schedule`")                 or die("fcms_schedule<br/>" . mysql_error());
  8.     mysql_query("DROP TABLE IF EXISTS `fcms_status`")                   or die("fcms_status<br/>" . mysql_error());
  9.     mysql_query("DROP TABLE IF EXISTS `fcms_navigation`")               or die("fcms_navigation<br/>" . mysql_error());
  10.     mysql_query("DROP TABLE IF EXISTS `fcms_chat_online`")              or die("fcms_chat_oneline<br/>" . mysql_error());
  11.     mysql_query("DROP TABLE IF EXISTS `fcms_chat_messages`")            or die("fcms_chat_messages<br/>" . mysql_error());
  12.     mysql_query("DROP TABLE IF EXISTS `fcms_address`")                  or die("fcms_address<br/>" . mysql_error());
  13.     mysql_query("DROP TABLE IF EXISTS `fcms_alerts`")                   or die("fcms_alerts<br/>" . mysql_error());
  14.     mysql_query("DROP TABLE IF EXISTS `fcms_privatemsg`")               or die("fcms_privatemsg<br/>" . mysql_error());
  15.     mysql_query("DROP TABLE IF EXISTS `fcms_documents`")                or die("fcms_documents<br/>" . mysql_error());



  1. 		if(@$blockmultipurchase != ""){
  2. 			mysql_query("DELETE FROM multibuyblock WHERE lastaccess<'" . date("Y-m-d H:i:s", time()-(60*60*24)) . "'") or print(mysql_error());
  3. 			$sSQL = "SELECT ssdenyid,sstimesaccess FROM multibuyblock WHERE ssdenyip = '" . trim(mysql_real_escape_string($theip)) . "'";
  4. 			$result = mysql_query($sSQL) or print(mysql_error());
  5. 			if($rs = mysql_fetch_array($result)){
  6. 				mysql_query("UPDATE multibuyblock SET sstimesaccess=sstimesaccess+1,lastaccess='" . date("Y-m-d H:i:s", time()) . "' WHERE ssdenyid=" . $rs["ssdenyid"]) or print(mysql_error());
  7. 			}else{
  8. 				mysql_query("INSERT INTO multibuyblock (ssdenyip,lastaccess) VALUES ('" . trim(mysql_real_escape_string($theip)) . "','" . date("Y-m-d H:i:s", time()) . "')") or print(mysql_error());
  9. 			$sSQL = "SELECT dcid FROM ipblocking WHERE (dcip1=" . ip2long($theip) . " AND dcip2=0) OR (dcip1 <= " . ip2long($theip) . " AND " . ip2long($theip) . " <= dcip2 AND dcip2 <> 0)";
  10. 		$result = mysql_query($sSQL) or print(mysql_error());
  11. 	$sSQL = "SELECT SUM(cartQuantity) AS totquant FROM cart WHERE cartCompleted=0 AND cartSessionID='" . session_id() . "' AND cartProdID='".mysql_real_escape_string($cpbpid)."'";
  12. 	$result = mysql_query($sSQL) or print(mysql_error());
  13. 	//echo $sql_dd;
  14. 	$result_dd=mysql_query($sql_dd);
  15. 		if($subcpns){
  16. 			$theres = mysql_query("SELECT cpnID FROM coupons WHERE cpnNumAvail>0 AND cpnNumAvail<30000000 AND cpnID=" . $resset["cpnID"]) or print(mysql_error());
  17. 			if($theresset = mysql_fetch_assoc($theres)) @$_SESSION["couponapply"] .= "," . $resset["cpnID"];










  1. 		$sSQL = "SELECT adminEmail,adminEmailConfirm,adminTweaks,adminProdsPerPage,adminStoreURL,adminHandling,adminPacking,adminDelUncompleted,adminDelCC,adminUSZones,adminStockManage,adminShipping,adminCanPostUser,adminZipCode,adminUnits,adminUSPSUser,adminUSPSpw,adminUPSUser,adminUPSpw,adminUPSAccess,adminlanguages,adminlangsettings,currRate1,currSymbol1,currRate2,currSymbol2,currRate3,currSymbol3,currConvUser,currConvPw,currLastUpdate,countryLCID,countryCurrency,countryName,countryCode,countryTax FROM admin LEFT JOIN countries ON admin.adminCountry=countries.countryID WHERE adminID=1";
  2. 		$result = mysql_query($sSQL) or print(mysql_error());
  3. 				$sSQL = "UPDATE products SET pInStock=pInStock-" . $rs1["cartQuantity"] . " WHERE pID='" . $rs1["cartProdID"] . "'";
  4. 				mysql_query($sSQL) or print(mysql_error());
  5. 				//mail("chadsaun@gmail.com", "iFrogz Inv Test: Stock Manage", $sql);
  6. 				mysql_query($sql) or mail("chadsaun@gmail.com", "iFrogz Inv Test Error: Stock Manage", $sql);
  7. 		$sSQL="SELECT cartID,cartProdID,cartQuantity,pSell,pDownload,p_iscert, pInStock FROM cart INNER JOIN products ON cart.cartProdID=products.pID WHERE products.pDropship=0 AND cartCompleted=1 AND cartOrderID=" . $smOrdId;
  8. 		$result = mysql_query($sSQL) or print(mysql_error());
  9. 				$sSQL = "SELECT coOptID, coCartOption, optStyleID, optStock, coOptGroup FROM cartoptions INNER JOIN options ON cartoptions.coOptID=options.optID INNER JOIN optiongroup ON options.optGroup=optiongroup.optGrpID  WHERE (optType=2 OR optType=-2) AND coCartID=" . $rs["cartID"];
  10. 				$result2 = mysql_query($sSQL) or print(mysql_error());
  11. 					$sSQL = "UPDATE options SET optStock=optStock+" . $newQty . " WHERE optID=" . $rs2["coOptID"];
  12. 					mysql_query($sSQL) or print(mysql_error().$sSQL);	
  13. 					//mail("chadsaun@gmail.com", "iFrogz Inv Test: Release Stock", $sql);
  14. 					mysql_query($sql) or mail("chadsaun@gmail.com", "iFrogz Inv Test Error: Release Stock", $sql);
  15. 	$sSQL = "SELECT poOptionGroup,optType,optFlags FROM prodoptions LEFT JOIN optiongroup ON optiongroup.optGrpID=prodoptions.poOptionGroup WHERE poProdID='" . $rs["pId"] . "' ORDER BY poID";
  16. 	$result = mysql_query($sSQL) or print(mysql_error());


Back to Top