All pastes #82904 Raw Edit

Anonymous

public text v1 · immutable
·published 2006-07-09 02:14 UTC
rendered paste body
if (isset($_GET['managelinks'])) {
	if ($_POST['newlink_name'] != "Link Display (Do not use plus signs (+))" && $_POST['newlink_name'] != "") {
		
		$joined_nlink = $_POST['newlink_name']."+".$_POST['newlink_link'];
		
		$cml_res = mysql_query("SELECT * FROM `prefs` WHERE `field` LIKE 'mainlink_top%'");
		
		
		mysql_query("INSERT INTO `prefs` (`field`,`value`) VALUES ('mainlink_top{$num}','{$joined_nlink}')");
	
	
	
	}
	
	$stor_array_keys = array();
	$stor_array_vals = array();																															
	
	

	$stor_array_dels = array("dels");
	
	foreach($_POST as $key => $value) {
		$basetype = substr($key,13);
		$base = substr($key,0,13);

		if($basetype == "del") {
			if ($value == "on") {
				mysql_query("DELETE FROM `prefs` WHERE `field`='{$base}'");
				array_push($stor_array_dels,$base);
			}
		
		}
		else {
			if($basetype == "link") { #VALS#
				if(array_search($base,$stor_array_dels) == FALSE) { 
					array_push($stor_array_vals,$value);
				}
			}
			elseif($basetype == "name") { #KEYS#
				if(array_search($base,$stor_array_dels) == FALSE) { // check of this base is already in the deleted links
					array_push($stor_array_keys,$value);
				}			
			}
			else {
			}
		}
	}
	
	
	$links = array_combine($stor_array_keys,$stor_array_vals); 
	
	mysql_query("DELETE FROM `prefs` WHERE `field` LIKE 'mainlink_top%'"); // We're replacing them all.
	$numlinks = 1;
	foreach ($links as $key => $value) {
		$combined = $key."+".$value;
	
	
		mysql_query("INSERT INTO `prefs` (`field`,`value`) VALUES ('mainlink_top{$numlinks}','{$combined}');") or die(mysql_error());
	
		$numlinks++;
	}
	
	echo "Homepage main links have been successfully updated<br /><br />";
	
}