Advertisement
Guest User

Untitled

a guest
Dec 15th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.78 KB | None | 0 0
  1. $bKopplat3 = $_POST[bKopplat3];
  2.  
  3. $cust=mysql_fetch_object(mysql_query("SELECT id, bKopplat3 FROM tabKundRegister WHERE lKundNr='".mysql_real_escape_string($_POST['lKundNr'])."' "));
  4.  
  5.  
  6.  
  7. // ----------------Uppdatera kund-registret-----------------
  8. $logCustomer = Log::logCustomer('Updatering av kund',$main,$_POST['lKundNr']);
  9. if (!$result = @mysql_query("UPDATE `tabKundRegister` SET
  10. bKopplat3='$bKopplat3'
  11. ".($kundnummer_bokningssidan=='1000'? ", bKopplat4='$bKopplat3'":"")."
  12. WHERE lKundNr='$_POST[lKundNr]'")){
  13. print_error(mysql_error());
  14. }
  15. $logCustomer->log();
  16.  
  17. //--------------------------------------------------------------------
  18.  
  19. if($kundnummer_bokningssidan=='1000') Itrim_hdb::addToUpdateQueue($cust->id, 'customer');
  20.  
  21. if($flergymplus == 'ja'){
  22. $agareOld = mysql_fetch_object(mysql_query("SELECT `agare` FROM `flergym` WHERE id='".mysql_real_escape_String($cust->bKopplat3)."'"))->agare;
  23. $agareCurr = mysql_fetch_object(mysql_query("SELECT `agare` FROM `flergym` WHERE id='".mysql_real_escape_String($bKopplat3)."'"))->agare;
  24. if($agareOld != $agareCurr) $alsoUpdate = ", bMedgivandeFinns = 0,
  25. bMedgivandeSkickat = 0,
  26. bMakuleraKunden = 0,
  27. bMakuleringSkickad = 0,
  28. bMakPaEgenBegaran = 0 ";
  29. else $alsoUpdate = '';
  30. }
  31.  
  32.  
  33. // ----------------Uppdatera ag-registret-----------------
  34. if (!$result = @mysql_query("UPDATE `tabAGKundRegisterSverige` SET
  35. anlaggning='$bKopplat3'
  36. ".$alsoUpdate."
  37. WHERE lKundNr='$_POST[lKundNr]'")){
  38. print_error(mysql_error());
  39. }
  40.  
  41. //--------------------------------------------------------------------
  42.  
  43.  
  44. echo '<META HTTP-EQUIV="refresh" content="0;URL=./kunder.php?action=edit&lKundNr='.$_POST['lKundNr'].'">';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement