About 12,255 results: "mysql_query"
Page 5 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On
  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());







  1. $peerlist_update = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'refresh_realtime_peerlist' LIMIT 1"),0,"field_data");
  2. $queue_update = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'refresh_realtime_queue' LIMIT 1"),0,"field_data");
  3. $server_hash_code = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_hash_code' LIMIT 1"),0,"field_data");
  4. 
                        
  5. {
  6. $max = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'max_active_peers' LIMIT 1"),0,"field_data");
  7. $new = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'max_new_peers' LIMIT 1"),0,"field_data");
  8. $domain = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_domain' LIMIT 1"),0,"field_data");
  9. $subfolder = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_subfolder' LIMIT 1"),0,"field_data");
  10. $port = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_port_number' LIMIT 1"),0,"field_data");
  11. $trans_queue_hash = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'transaction_queue_hash' LIMIT 1"),0,"field_data");
  12. $block_check_start = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'block_check_start' LIMIT 1"),0,"field_data");
  13. $uptime = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'timekoin_start_time' LIMIT 1"),0,"field_data");
  14. $request_max = mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'server_request_max' LIMIT 1"),0,"field_data");
  15. $allow_lan_peers = intval(mysql_result(mysql_query("SELECT * FROM `options` WHERE `field_name` = 'allow_LAN_peers' LIMIT 1"),0,"field_data"));








  1. 	if ( $old_path != '/' ) { // Used to be a subdomain so we can more safely replace.
  2. 		mysql_query( "UPDATE `" . $destination_db_prefix . "blogs` SET path=REPLACE( path, '" . mysql_real_escape_string( $old_path ) . "', '" . mysql_real_escape_string( $destination_path ) . "') WHERE domain='" . mysql_real_escape_string( $old_domain ) . "' AND path LIKE '" . mysql_real_escape_string( $old_path ) . "%'" );
  3. 	} else { // Used to be in root so much prepend new path.
  4. 		mysql_query( "UPDATE `" . $destination_db_prefix . "blogs` SET path=concat( '" . mysql_real_escape_string( rtrim( $destination_path, '/\\' ) ) . "', path ) WHERE domain='" . mysql_real_escape_string( $old_domain ) . "'" );
  5. 	// Update blog domain for all matching sites.
  6. 	mysql_query( "UPDATE `" . $destination_db_prefix . "blogs` SET domain='" . mysql_real_escape_string( $destination_domain ) . "' WHERE domain='" . mysql_real_escape_string( $old_domain ) . "'" );
  7. 	// Update fileupload_url in options table.
  8. 	mysql_query( "UPDATE `" . $destination_db_prefix . "options` SET option_value='" . mysql_real_escape_string( $wp_upload_url ) . "' WHERE option_name='fileupload_url' LIMIT 1" );
  9. 	// TODO: moved to bottom of this file.
  10. 	//mysql_query( "UPDATE `" . $destination_db_prefix . "options` SET option_name='" . $destination_db_prefix . "user_roles' WHERE option_name LIKE '%_user_roles' LIMIT 1" );
  11. 	// Update upload_path in options table.
  12. 	mysql_query( "UPDATE `" . $destination_db_prefix . "options` SET option_value='" . mysql_real_escape_string( str_replace( $new_url . '/', '', $wp_upload_url_real ) ) . "' WHERE option_name='upload_path' LIMIT 1" );
  13. 	// Update fileupload_url in options table.
  14. 	mysql_query( "UPDATE `" . $destination_db_prefix . "options` SET option_value='" . mysql_real_escape_string( $wp_upload_url ) . "' WHERE option_name='fileupload_url' LIMIT 1" );
  15. 	// TODO: moved to bottom of this file.
  16. 	//mysql_query( "UPDATE `" . $destination_db_prefix . "options` SET option_name='" . $destination_db_prefix . "user_roles' WHERE option_name LIKE '%_user_roles' LIMIT 1" );




Back to Top