hat einer eine ahnung mit dem fehler
Versuchs mal so:
PHP
$array = array('template' => 'bill', 'oldbillid' => '', 'billid' => '', 'price_brutto' => '', 'price_netto' => '');
if(isset($stornoid) AND $stornoid != ''){
$storno = mysqli_fetch_array(mysqli_query($GLOBALS["sql"], "SELECT id, billid FROM ".$GLOBALS['prefix']."finance_bill WHERE billid = '".mysqli_real_escape_string($GLOBALS["sql"], $stornoid)."' LIMIT 1"));
$GLOBALS['CreatPDF'] = LoadCreatePDF($memberid, 'PDF', 'STORNO', $storno['billid'], $storno['id'], $array);
}else{
$GLOBALS['CreatPDF'] = LoadCreatePDF($memberid, 'PDF', 'BILL', $billid, $id, $array);
}
if(isset($GLOBALS['CreatPDF']) AND $GLOBALS['CreatPDF'] == true){
if (file_exists(''.$dir.'pdf/RE/'.$billid.'.pdf')) {
if(isset($stornoid) AND $stornoid != ''){
$array['template'] = 'invoicecancel';
$array['oldbillid'] = $stornoid;
}else{
$array['template'] = 'invoice';
$array['oldbillid'] = $billid;
}
$array['price_netto'] = $sumpricenetto;
$array['price_brutto'] = $sumpricebrutto;
$array['billid'] = $billid;
$cstatus = mysqli_query($GLOBALS["sql"], "INSERT ".$GLOBALS['prefix']."member_contact SET
user = '".mysqli_real_escape_string($GLOBALS["sql"], $member['memberid'])."',
admin = '".mysqli_real_escape_string($GLOBALS["sql"], 'System')."',
email = '".mysqli_real_escape_string($GLOBALS["sql"], $member['email'])."',
array = '".mysqli_real_escape_string($GLOBALS["sql"], json_encode($array))."',
title = '".mysqli_real_escape_string($GLOBALS["sql"], '')."',
text = '".mysqli_real_escape_string($GLOBALS["sql"], '')."',
date = '".mysqli_real_escape_string($GLOBALS["sql"], $paneltimestamp)."',
temp = '".mysqli_real_escape_string($GLOBALS["sql"], $array['template'])."',
status = '".mysqli_real_escape_string($GLOBALS["sql"], '0')."',
active = '".mysqli_real_escape_string($GLOBALS["sql"], '1')."'");
mysqli_query($GLOBALS["sql"], "UPDATE ".$GLOBALS['prefix']."finance_bill SET
cid = '".mysqli_real_escape_string($GLOBALS["sql"], mysqli_insert_id($GLOBALS["sql"]))."'
WHERE id= '".mysqli_real_escape_string($GLOBALS["sql"], $id)."'");
}else{ echo "RECHNUNG EXISTIERT NICHT."; }
}else{ echo "RECHNUNG KONNTE NICHT ERSTELLT WERDEN."; }
$ii++;}
Alles anzeigen