<?php
//denna fil = server_ab_sth1.php
function Mod_addslashes ( $string )
{
 if (get_magic_quotes_gpc()==1)
 {
  return ( $string );
 }
 else
 {
  return ( addslashes ( $string ) );
 }
}

function WriteRecord($alanx1,$akodx1,$aurvx1,$akatx1,$adokx1,$alfkx1,$aortx1,$asokx1,$arubx1,$alokx1,$ahrdx1,$alkpx1,$atolx1,$abeax1,$abebx1,$atxtx1,$apubx1,$anumx1,$aradx1,$alanx2,$akodx2,$aurvx2,$akatx2,$adokx2,$alfkx2,$aortx2,$asokx2,$arubx2,$alokx2,$ahrdx2,$alkpx2,$atolx2,$abeax2,$abebx2,$atxtx2,$apubx2,$anumx2,$aradx2)
{
set_time_limit(0);
$db = @mysql_connect("loopback", "soresigv", "Dox.rint") or die("Connection impossible at this time.");
@mysql_select_db("ortnamndb") or die("Selection impossible at this time.");
mysql_set_charset('utf8',$db);

$alanx1 = mysql_real_escape_string(trim($alanx1));
$akodx1 = mysql_real_escape_string(trim($akodx1));
$aurvx1 = mysql_real_escape_string(trim($aurvx1));
$akatx1 = mysql_real_escape_string(trim($akatx1));
$adokx1 = mysql_real_escape_string(trim($adokx1));
$alfkx1 = mysql_real_escape_string(trim($alfkx1));
$aortx1 = mysql_real_escape_string(trim($aortx1));
$asokx1 = mysql_real_escape_string(trim($asokx1));
$arubx1 = mysql_real_escape_string(trim($arubx1));
$alokx1 = mysql_real_escape_string(trim($alokx1));
$ahrdx1 = mysql_real_escape_string(trim($ahrdx1));
$alkpx1 = mysql_real_escape_string(trim($alkpx1));
$atolx1 = mysql_real_escape_string(trim($atolx1));
$abeax1 = mysql_real_escape_string(trim($abeax1));
$abebx1 = mysql_real_escape_string(trim($abebx1));
$atxtx1 = mysql_real_escape_string(trim($atxtx1));
$apubx1 = mysql_real_escape_string(trim($apubx1));
$anumx1 = mysql_real_escape_string(trim($anumx1));
$aradx1 = mysql_real_escape_string(trim($aradx1));

$alanx2 = mysql_real_escape_string(trim($alanx2));
$akodx2 = mysql_real_escape_string(trim($akodx2));
$aurvx2 = mysql_real_escape_string(trim($aurvx2));
$akatx2 = mysql_real_escape_string(trim($akatx2));
$adokx2 = mysql_real_escape_string(trim($adokx2));
$alfkx2 = mysql_real_escape_string(trim($alfkx2));
$aortx2 = mysql_real_escape_string(trim($aortx2));
$asokx2 = mysql_real_escape_string(trim($asokx2));
$arubx2 = mysql_real_escape_string(trim($arubx2));
$alokx2 = mysql_real_escape_string(trim($alokx2));
$ahrdx2 = mysql_real_escape_string(trim($ahrdx2));
$alkpx2 = mysql_real_escape_string(trim($alkpx2));
$atolx2 = mysql_real_escape_string(trim($atolx2));
$abeax2 = mysql_real_escape_string(trim($abeax2));
$abebx2 = mysql_real_escape_string(trim($abebx2));
$atxtx2 = mysql_real_escape_string(trim($atxtx2));
$apubx2 = mysql_real_escape_string(trim($apubx2));
$anumx2 = mysql_real_escape_string(trim($anumx2));
$aradx2 = mysql_real_escape_string(trim($aradx2));

echo "alan1=".$alanx1."\n";
echo "akod1=".$akodx1."\n";
echo "aurv1=".$aurvx1."\n";
echo "akat1=".$akatx1."\n";
echo "adok1=".$adokx1."\n";
echo "alfk1=".$alfkx1."\n";
echo "aort1=".$aortx1."\n";
echo "asok1=".$asokx1."\n";
echo "arub1=".$arubx1."\n";
echo "alok1=".$alokx1."\n";
echo "ahrd1=".$ahrdx1."\n";
echo "alkp1=".$alkpx1."\n";
echo "atol1=".$atolx1."\n";
echo "abea1=".$abeax1."\n";
echo "abeb1=".$abebx1."\n";
echo "atxt1=".$atxtx1."\n";
echo "apub1=".$apubx1."\n";
echo "anum1=".$anumx1."\n";
echo "arad1=".$aradx1."\n\n";

echo "alan2=".$alanx2."\n";
echo "akod2=".$akodx2."\n";
echo "aurv2=".$aurvx2."\n";
echo "akat2=".$akatx2."\n";
echo "adok2=".$adokx2."\n";
echo "alfk2=".$alfkx2."\n";
echo "aort2=".$aortx2."\n";
echo "asok2=".$asokx2."\n";
echo "arub2=".$arubx2."\n";
echo "alok2=".$alokx2."\n";
echo "ahrd2=".$ahrdx2."\n";
echo "alkp2=".$alkpx2."\n";
echo "atol2=".$atolx2."\n";
echo "abea2=".$abeax2."\n";
echo "abeb2=".$abebx2."\n";
echo "atxt2=".$atxtx2."\n";
echo "apub2=".$apubx2."\n";
echo "anum2=".$anumx2."\n";
echo "arad2=".$aradx2."\n\n";

/*
$alfkx2 = Mod_addslashes($alfkx2);
$aortx2 = addslashes($aortx2);
$asokx2 = addslashes($asokx2);
$arubx2 = addslashes($arubx2);
$alokx2 = addslashes($alokx2);
$ahrdx2 = addslashes($ahrdx2);
$alkpx2 = addslashes($alkpx2);
$atolx2 = addslashes($atolx2);
$abeax2 = addslashes($abeax2);
$abebx2 = addslashes($abebx2);
$atxtx2 = addslashes($atxtx2);
$apubx2 = addslashes($apubx2);
$anumx2 = addslashes($anumx2);
$aradx2 = addslashes($aradx2);
*/

$sqlx = "UPDATE `ab_sth_20120207` SET `alfk`='{$alfkx2}',`aort`='{$aortx2}',`asok`='{$asokx2}',`arub`='{$arubx2}',`alok`='{$alokx2}',`ahrd`='{$ahrdx2}',`alkp`='{$alkpx2}',`atol`='{$atolx2}',`abea`='{$abeax2}',`abeb`='{$abebx2}',`atxt`='{$atxtx2}',`apub`='{$apubx2}',`anum`='{$anumx2}',`arad`='{$aradx2}' WHERE (`alan`='{$alanx2}' AND `akod`='{$akodx2}' AND `aurv`='{$aurvx2}' AND `akat`='{$akatx2}' AND `adok`='{$adokx2}');";
//$sqlx = "UPDATE `ortnareg` SET `alfk`='{$alfkx2}',`aort`='{$aortx2}',`asok`='{$asokx2}',`arub`='{$arubx2}',`alok`='{$alokx2}',`ahrd`='{$ahrdx2}',`alkp`='{$alkpx2}',`atol`='{$atolx2}',`abea`='{$abeax2}',`abeb`='{$abebx2}',`atxt`='{$atxtx2}',`apub`='{$apubx2}',`anum`='{$anumx2}',`arad`='{$aradx2}' WHERE (`alan`='{$alanx2}' AND `akod`='{$akodx2}' AND `aurv`='{$aurvx2}' AND `akat`='{$akatx2}' AND `adok`='{$adokx2}');";

echo $sqlx;

$result = mysql_query($sqlx, $db);
if($result){
 echo "\n\nUppdatering gjord!";
}else{
 echo "\n\nUppdateringen misslyckades!";
}
mysql_close($db);
} //function WriteRecord ends

//######################################
$x1 = strip_tags($_POST['xx1']);
$x2 = strip_tags($_POST['xx2']);
echo "Nuvarande rad: ".$x1."\n\n";
echo "Uppdatera med: ".$x2."\n\n";

$arr1 = explode('|', $x1);
//print_r($arr1);
$arr2 = explode('|', $x2);
//print_r($arr2);

$alanx1 = $arr1[0];
$akodx1 = $arr1[1];
$aurvx1 = $arr1[2];
$akatx1 = $arr1[3];
$adokx1 = $arr1[4];
$alfkx1 = $arr1[5];
$aortx1 = $arr1[6];
$asokx1 = $arr1[7];
$arubx1 = $arr1[8];
$alokx1 = $arr1[9];
$ahrdx1 = $arr1[10];
$alkpx1 = $arr1[11];
$atolx1 = $arr1[12];
$abeax1 = $arr1[13];
$abebx1 = $arr1[14];
$atxtx1 = $arr1[15];
$apubx1 = $arr1[16];
$anumx1 = $arr1[17];
$aradx1 = $arr1[18];

$alanx2 = $arr2[0];
$akodx2 = $arr2[1];
$aurvx2 = $arr2[2];
$akatx2 = $arr2[3];
$adokx2 = $arr2[4];
$alfkx2 = $arr2[5];
$aortx2 = $arr2[6];
$asokx2 = $arr2[7];
$arubx2 = $arr2[8];
$alokx2 = $arr2[9];
$ahrdx2 = $arr2[10];
$alkpx2 = $arr2[11];
$atolx2 = $arr2[12];
$abeax2 = $arr2[13];
$abebx2 = $arr2[14];
$atxtx2 = $arr2[15];
$apubx2 = $arr2[16];
$anumx2 = $arr2[17];
$aradx2 = $arr2[18];

WriteRecord($alanx1,$akodx1,$aurvx1,$akatx1,$adokx1,$alfkx1,$aortx1,$asokx1,$arubx1,$alokx1,$ahrdx1,$alkpx1,$atolx1,$abeax1,$abebx1,$atxtx1,$apubx1,$anumx1,$aradx1,$alanx2,$akodx2,$aurvx2,$akatx2,$adokx2,$alfkx2,$aortx2,$asokx2,$arubx2,$alokx2,$ahrdx2,$alkpx2,$atolx2,$abeax2,$abebx2,$atxtx2,$apubx2,$anumx2,$aradx2);

echo "\n\n";
echo date("Y-m-d H:i:s");
?>