real_escape_string($_POST['ppc_network_id']);
foreach ($_POST['vars'] as $var) {
$var_empty = count($var) != count(array_filter($var));
if ($var_empty) die("VALIDATION FAILD!");
$mysql['id'] = $db->real_escape_string($var['id']);
$mysql['name'] = $db->real_escape_string($var['name']);
$mysql['parameter'] = $db->real_escape_string($var['parameter']);
$mysql['placeholder'] = $db->real_escape_string($var['placeholder']);
if ($var['id'] != 'false') {
$sql = "UPDATE 202_ppc_network_variables ";
} else {
$sql = "INSERT INTO 202_ppc_network_variables ";
}
$sql .= "SET
ppc_network_id = '".$mysql['ppc_network_id']."',
name = '".$mysql['name']."',
parameter = '".$mysql['parameter']."',
placeholder = '".$mysql['placeholder']."'";
if ($var['id'] != 'false') {
$sql .= " WHERE ppc_variable_id = '".$mysql['id']."'";
}
$result = $db->query($sql);
if ($var['id'] != 'false') {
$vars[] = $var['id'];
} else if ($var['id'] == 'false') {
$vars[] = $db->insert_id;
}
}
$var_ids = implode(', ', $vars);
$sql = "UPDATE 202_ppc_network_variables SET deleted = '1' WHERE ppc_variable_id NOT IN (".$var_ids.") AND ppc_network_id = '".$mysql['ppc_network_id']."'";
$result = $db->query($sql);
echo 'DONE!';
}
if ($_POST['get_vars'] == true && isset($_POST['ppc_network_id'])) {
$mysql['ppc_network_id'] = $db->real_escape_string($_POST['ppc_network_id']);
$sql = "SELECT * FROM 202_ppc_network_variables WHERE ppc_network_id = '".$mysql['ppc_network_id']."' AND deleted = '0'";
$result = $db->query($sql);
if ($result->num_rows > 0) {
$count = 0;
while ($row = $result->fetch_assoc()) { ?>
real_escape_string($_POST['ppc_network_id']);
$sql = "DELETE FROM 202_ppc_network_variables WHERE ppc_network_id = '".$mysql['ppc_network_id']."' AND deleted = '0'";
$result = $db->query($sql);
}
}
?>