About 24,582 results: "mysql_query"
Page 8 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On



  1.     
  2.     mysql_query("DELETE FROM uts_pinfo WHERE id = $mplayer2") or die(mysql_error());
  3.     mysql_query("UPDATE uts_player SET pid = $mplayer1  WHERE pid = $mplayer2") or die(mysql_error());
  4.     mysql_query("UPDATE uts_weaponstats SET pid = $mplayer1  WHERE pid = $mplayer2") or die(mysql_error());
  5.     mysql_query("DELETE FROM uts_weaponstats WHERE pid = $mplayer2") or die(mysql_error());
  6.     mysql_query("DELETE FROM uts_weaponstats WHERE matchid='0' AND pid = '$mplayer1'") or die(mysql_error());
  7.     
  8.     $q_weaponstats = mysql_query("SELECT weapon, SUM(kills) AS kills, SUM(shots) AS shots, SUM(hits) as hits, SUM(damage) as damage, AVG(acc) AS acc FROM uts_weaponstats WHERE pid = '$mplayer1'  GROUP BY weapon") or die(mysql_error());
  9.     while ($r_weaponstats = mysql_fetch_array($q_weaponstats)) {
  10.         mysql_query("INSERT INTO uts_weaponstats SET matchid='0', pid='$mplayer1',  weapon='${r_weaponstats['weapon']}', kills='${r_weaponstats['kills']}', shots='${r_weaponstats['shots']}', hits='${r_weaponstats['hits']}', damage='${r_weaponstats['damage']}', acc='${r_weaponstats['acc']}'") or die(mysql_error());
  11.     }
  12.     mysql_query("UPDATE uts_match SET firstblood = $mplayer1  WHERE firstblood = $mplayer2") or die(mysql_error());
  13.     mysql_query("UPDATE uts_rank SET pid = $mplayer2 WHERE pid= $mplayer1") or die(mysql_error());
  14.     $sql_nrank = "SELECT SUM(time) AS time, pid, gid, AVG(rank) AS rank, AVG(prevrank) AS prevrank, SUM(matches) AS matches FROM uts_rank WHERE pid = $mplayer2 GROUP BY pid, gid";
  15.     $q_nrank = mysql_query($sql_nrank) or die(mysql_error());

  1. global $_REQUEST;
  2. if(!intval($exp)) $exp = mysql_result(mysql_query("SELECT pk_exp_id FROM md_exp WHERE exp_name = '".addslashes($exp)."'"),0);
  3. 	//create packrow in md_pack and generate pk_pack_id
  4. 	mysql_query($apa = "INSERT INTO md_pack(fk_draft_id, fk_exp_id, pack_number, fk_user_id, seat_number, pack_type) SELECT '$draft_id', pk_exp_id, '$pack_number', '$user_id', '$seat_number', '$pack_type' FROM md_exp WHERE pk_exp_id = '$exp'");
  5. 		//reg cards
  6. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) 
  7. 		
  8. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'B' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
  9. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
  10. 		$cq_values = mysql_fetch_array($cq_result);
  11. 		$c1 = $cq_values[fk_card_id];
  12. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'R' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
  13. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());
  14. 		$cq_values = mysql_fetch_array($cq_result);
  15. 		$c2 = $cq_values[fk_card_id];
  16. 		mysql_query("INSERT INTO md_packcard(fk_pack_id, fk_card_id) SELECT '$pk_pack_id', pk_card_id FROM md_cards WHERE fk_exp_id = '$exp' AND card_rarity = 'C' AND card_color = 'U' AND card_type NOT LIKE 'Basic Land%' ORDER BY rand() LIMIT 1");
  17. 		$cq_result = mysql_query("SELECT fk_card_id FROM md_packcard WHERE pk_packcard_id = ".mysql_insert_id());









  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());

  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());






Back to Top