-(`gender`, `surname`, `family`, `street_nr`,%s, `zip`, `city`, `email`, `birth_day`, `birth_month`, `birth_year`, `password`, `max_mails`, `receive_mails`, `refid`, `status`, `user_hash`, `REMOTE_ADDR`, `joined`, `last_update`".$GLOBALS['register_sql_columns'].")
- VALUES
-('%s','%s','%s','%s','%s',%s,'%s','%s',%s, %s,%s,'%s',%s, %s,'%s','UNCONFIRMED','%s','%s', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()".$GLOBALS['register_sql_data'].")",
+(
+ `gender`,
+ `surname`,
+ `family`,
+ `street_nr`,
+ %s,
+ `zip`,
+ `city`,
+ `email`,
+ `birth_day`,
+ `birth_month`,
+ `birth_year`,
+ `password`,
+ `max_mails`,
+ `receive_mails`,
+ `refid`,
+ `status`,
+ `user_hash`,
+ `REMOTE_ADDR`,
+ `joined`,
+ `last_update`,
+ `ref_payout`
+ ".$GLOBALS['register_sql_columns']."
+) VALUES (
+ '%s'
+ '%s'
+ '%s'
+ '%s'
+ '%s',
+ %s,
+ '%s',
+ '%s',
+ %s,
+ %s,
+ %s,
+ '%s',
+ %s,
+ %s,
+ %s,
+ 'UNCONFIRMED',
+ '%s',
+ '{%%pipe,detectRemoteAddr%%}',
+ UNIX_TIMESTAMP(),
+ UNIX_TIMESTAMP(),
+ {?ref_payout?}
+ ".$GLOBALS['register_sql_data'].")",