er DB:
<code>
ALTER TABLE `oxvouchers` ADD `sent_to_customer` SMALLINT NOT NULL DEFAULT '0' COMMENT 'Is the vouche free or sent to customer'
</code>
Abfrage freie Codes, die noc... ATE > DATE_ADD(now(), INTERVAL 90 DAY) AND v.sent_to_customer = 0 LIMIT 1
</code>
Update des Codes als versendet:
<code>
UPDATE oxvouchers SET sent_to_customer = 1 WHERE OXVOUCHERNR = 'xxxx' LIMIT 1
<
