About 24,925 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"];





Back to Top