About 143 results: "mysql_query repo:chadsaun/ifrogz-panel"
Page 1 of 8
Filter Results
Sources
Languages
Filter Results
Try Search On
cart.php in ifrogz-panel https://bitbucket.org/chadsaun/ifrogz-panel.git | 5364 lines | PHP
  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"];



functions.php in ifrogz-panel https://bitbucket.org/chadsaun/ifrogz-panel.git | 2039 lines | PHP
  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());






minicart2.php in ifrogz-panel https://bitbucket.org/chadsaun/ifrogz-panel.git | 688 lines | PHP
  1. 	$sSQL = "SELECT * FROM cart WHERE cartCompleted=0 AND cartSessionID='" .  session_id() . "'";
  2. 	$result = mysql_query($sSQL) or print(mysql_error());
  3. 			$sSQL .= " OR (cartCompleted=0 AND cartDateAdded<'" . date("Y-m-d H:i:s", time()-($delAfter*60*60*24)) . "')";
  4. 		$result = mysql_query($sSQL) or print(mysql_error());
  5. 			}
  6. 			if($delAfter != 0) mysql_query("DELETE FROM orders WHERE ordID IN (" . $delcart . ")") or print(mysql_error());
  7. 			mysql_query("DELETE FROM cart WHERE cartID IN (" . $delstr . ")") or print(mysql_error());
  8. 			mysql_query("DELETE FROM cartoptions WHERE coCartID IN (" . $delstr . ")") or print(mysql_error());
  9. 		}
  10. 		$sSQL = "SELECT cartProdID,SUM(cartProdPrice*cartQuantity) AS thePrice,SUM(cartQuantity) AS sumQuant,pSection,COUNT(cartProdID),pExemptions,pTax FROM products INNER JOIN cart ON cart.cartProdID=products.pID WHERE cartCompleted=0 AND cartSessionID='" . $thesessionid . "' GROUP BY cartProdID,pSection,pExemptions,pTax";
  11. 		$cdresult = mysql_query($sSQL) or print(mysql_error());
  12. 			$sSQL = "SELECT SUM(coPriceDiff*cartQuantity) AS totOpts FROM cart LEFT OUTER JOIN cartoptions ON cart.cartID=cartoptions.coCartID WHERE cartCompleted=0 AND cartSessionID='" . $thesessionid . "' AND cartProdID='" . $cdrs["cartProdID"] . "'";
  13. 			$cdresult2 = mysql_query($sSQL) or print(mysql_error());
  14. 					$sSQL = "SELECT topSection FROM sections WHERE sectionID=" . $thetopts;
  15. 					$result2 = mysql_query($sSQL) or print(mysql_error());





cats2.php in ifrogz-panel https://bitbucket.org/chadsaun/ifrogz-panel.git | 915 lines | PHP
  1. 	$sSQL = "SELECT sectionID, sectionTag FROM sf_sections ORDER BY sectionOrder";
  2. 	$result = mysql_query($sSQL) or print(mysql_error());
  3. 		$sSQL="UPDATE sf_sections SET sectionOrder=" . $theorder . ",sectionTag='".$theTag."' WHERE sectionID=" . $rs["sectionID"];
  4. 		mysql_query($sSQL) or print(mysql_error());
  5. 		$sSQL = "DELETE FROM cpnassign WHERE cpaType=1 AND cpaAssignment='" . @$_POST["id"] . "'";
  6. 		mysql_query($sSQL) or print(mysql_error());
  7. 		$sSQL = "DELETE FROM sf_sections WHERE sectionID=" . @$_POST["id"];
  8. 		$sSQL = "SELECT sectionID, sectionWorkingName FROM sf_sections WHERE rootSection=0 ORDER BY sectionWorkingName";
  9. 		$result = mysql_query($sSQL) or print(mysql_error());
  10. 			$sSQL = "SELECT sectionID,sectionName,sectionName2,sectionDisplay,sectionName3,sectionDescription,sectionDescription2,sectionDescription3,sectionImage,sectionSideImage,sectionBannerImage,sectionWorkingName,topSection,sectionDisabled,rootSection,sectionurl,flash_movie,prod_body_format,prod_body_desc,sectionDetailURL, sectionImagesOther FROM sf_sections WHERE sectionID=" . @$_POST["id"];//custom code
  11. 			$result = mysql_query($sSQL) or print(mysql_error());
  12. 		$sSQL = "SELECT cpaID,cpaCpnID,cpnWorkingName,cpnSitewide,cpnEndDate,cpnType,cpnBeginDate FROM cpnassign LEFT JOIN coupons ON cpnassign.cpaCpnID=coupons.cpnID WHERE cpaType=1 AND cpaAssignment='" . @$_POST["id"] . "'";
  13. 		$result = mysql_query($sSQL) or print(mysql_error());
  14. 		$sSQL = "SELECT cpnID,cpnWorkingName,cpnSitewide FROM coupons WHERE (cpnSitewide=0 OR cpnSitewide=3) AND cpnEndDate >='" . date("Y-m-d H:i:s",time()) ."'";
  15. 		$result = mysql_query($sSQL) or print(mysql_error());

cats.php in ifrogz-panel https://bitbucket.org/chadsaun/ifrogz-panel.git | 952 lines | PHP
  1. 		$sSQL="UPDATE sections SET sectionOrder=" . $theorder . ",sectionTag='".$theTag."' WHERE sectionID=" . $rs["sectionID"];
  2. 		mysql_query($sSQL) or print(mysql_error());
  3. 		$sSQL = "DELETE FROM sections WHERE sectionID=" . @$_POST["id"];
  4. 		mysql_query($sSQL) or print(mysql_error());
  5. 		$sSQL = "DELETE FROM multisections WHERE pSection=" . @$_POST["id"];
  6. 		$sSQL = "SELECT sectionID, sectionWorkingName FROM sections WHERE rootSection=0 ORDER BY sectionWorkingName";
  7. 		$result = mysql_query($sSQL) or print(mysql_error());
  8. 			$sSQL = "SELECT sectionID,sectionName,sectionName2,sectionDisplay,sectionName3,sectionDescription,sectionDescription2,sectionDescription3,sectionImage,sectionSideImage,sectionBannerImage,sectionWorkingName,topSection,sectionDisabled,rootSection,sectionurl,flash_movie,prod_body_format,prod_body_desc,sectionDetailURL, sectionImagesOther, sectionTitleTag, sectionMetaDescription FROM sections WHERE sectionID=" . @$_POST["id"];//custom code
  9. 			$result = mysql_query($sSQL) or print(mysql_error());
  10. 		$sSQL = "SELECT sectionName FROM sections WHERE sectionID=" . @$_POST["id"];
  11. 		$result = mysql_query($sSQL) or print(mysql_error());
  12. 		$sSQL = "SELECT cpaID,cpaCpnID,cpnWorkingName,cpnSitewide,cpnEndDate,cpnType,cpnBeginDate FROM cpnassign LEFT JOIN coupons ON cpnassign.cpaCpnID=coupons.cpnID WHERE cpaType=1 AND cpaAssignment='" . @$_POST["id"] . "'";
  13. 		$result = mysql_query($sSQL) or print(mysql_error());
  14. 		$sSQL = "SELECT cpnID,cpnWorkingName,cpnSitewide FROM coupons WHERE (cpnSitewide=0 OR cpnSitewide=3) AND cpnEndDate >='" . date("Y-m-d H:i:s",time()) ."'";
  15. 		$result = mysql_query($sSQL) or print(mysql_error());



email.php in ifrogz-panel https://bitbucket.org/chadsaun/ifrogz-panel.git | 737 lines | PHP
  1. 		$strsql = "UPDATE certificates SET cert_amt = cert_amt - pend_order_amt WHERE pend_order_id =".$ordID;
  2. 		mysql_query($strsql);
  3. 		$strsql = "UPDATE certificates SET pend_order_amt = 0, pend_order_id = 0 WHERE pend_order_id =".$ordID;
  4. 		mysql_query($strsql);
  5. 	//	$strsql = "DELETE certificates WHERE cert_amt <= 0";
  6. 	//	mysql_query($strsql);
  7. 		$strsql = "UPDATE orders SET ord_cert_id=".$certid.", ord_cert_amt=".$pendingamt." WHERE ordID =".$ordID;
  8. 		mysql_query($strsql);
  9. 	$sSQL = "SELECT ordID,ordName,ordAddress,ordAddress2,ordCity,ordState,ordZip,ordCountry,ordEmail,ordPhone,ordShipName,ordShipAddress,ordShipAddress2,ordShipCity,ordShipState,ordShipZip,ordShipCountry,ordPayProvider,ordAuthNumber,ordTotal,ordDate,ordStateTax,ordCountryTax,ordHSTTax,ordHandling,ordShipping,ordAffiliate,ordDiscount,ordDiscountText,ordComLoc,ordExtra1,ordExtra2,ordSessionID,ordAddInfo,ordShipType,payProvID FROM orders LEFT JOIN payprovider ON payprovider.payProvID=orders.ordPayProvider WHERE ordAuthNumber<>'' AND ordID='" . mysql_real_escape_string($sorderid) . "'";
  10. 	$result = mysql_query($sSQL) or print(mysql_error());
  11. 	//echo $sSQL;
  12. 	$result = mysql_query($sSQL) or print(mysql_error());
  13. 				$sql_d="SELECT * FROM digitaldownloads WHERE orderID=".$rs["cartOrderID"]." AND type='".$rs["cartProdId"]."'";
  14. 					$result_d=mysql_query($sql_d);	
  15. 						$sql_download="SELECT * FROM digitaldownloads WHERE active=1 AND type='".$rs["cartProdId"]."'";
  16. 						$result_download=mysql_query($sql_download);


Back to Top