$fromip = $_SERVER['REMOTE_ADDR']; if(isset($_SERVER['HTTP_X_FORWARDED_FOR'])) { $fromip .= $_SERVER['HTTP_X_FORWARDED_FOR']; } if(isset($_SERVER['REMOTE_HOST'])) { $fromip .= '--'.$_SERVER['REMOTE_HOST']; } $fields = "ip='".$fromip."', login='".$login."' ,redirecturl='', transid='' , status='0', sellingamount='".$sellingCurrencyAmount."' , accountingamount='0', gateway='".trim($request['fill'])."' , amount='0', result='', trans_date='".date('Y-m-j H:i:s')."'"; $result = $db['prim']->query("INSERT INTO ".DB_PREFIX."transactions SET ".$fields);