postgresql7.1 select order_id, ec_order_cost(order_id) as total_order_price from ec_orders where order_state = 'confirmed' and (current_timestamp - confirmed_date) > timespan_days(1/96::float) insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, current_timestamp, :problem_details, :order_id) select g.gift_certificate_id, t.transaction_id from ec_gift_certificates g, ec_financial_transactions t where g.gift_certificate_id=t.gift_certificate_id and g.gift_certificate_state = 'confirmed' and (current_timestamp - g.issue_date) > timespan_days(1/96::float) update ec_financial_transactions set authorized_date=current_timestamp, to_be_captured_p='t' where transaction_id = :transaction_id update ec_gift_certificates set authorized_date = current_timestamp, gift_certificate_state = :cc_result where gift_certificate_id = :gift_certificate_id update ec_orders set order_state='expired', expired_date=current_timestamp where order_state='in_basket' and current_timestamp-in_basket_date > timespan_days([util_memoize {ad_parameter -package_id [ec_id] CartDuration ecommerce} [ec_cache_refresh]]::float) update ec_items set item_state='expired', expired_date=current_timestamp where item_state='in_basket' and order_id in (select order_id from ec_orders where order_state='expired') select transaction_id, order_id from ec_financial_transactions where to_be_captured_p='t' and current_timestamp-to_be_captured_date > timespan_days(1/48::float) and authorized_date is null and failed_p='f' insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, current_timestamp, 'invalid input to ec_creditcard_authorization in ec_unauthorized_transactions', :order_id) insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, current_timestamp, :problem_details, :order_id) update ec_financial_transactions set authorized_date=current_timestamp where transaction_id=:transaction_id insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, current_timestamp, :problem_details, :order_id) update ec_financial_transactions set marked_date=current_timestamp where transaction_id=:transaction_id insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, current_timestamp, :problem_details, :order_id) update ec_financial_transactions set settled_date=current_timestamp where transaction_id=:transaction_id select case when marked_date + '2 days'::interval < now() then 1 else 0 end from ec_financial_transactions where transaction_id=:transaction_id insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, current_timestamp, :problem_details, :order_id) select transaction_id, order_id from ec_financial_transactions where transaction_type='refund' and current_timestamp - inserted_date > timespan_days(1/48::float) and refunded_date is null and failed_p='f' update ec_financial_transactions set refunded_date=current_timestamp where transaction_id=:transaction_id insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, current_timestamp, :problem_details, :order_id) update ec_financial_transactions set refunded_date=current_timestamp where transaction_id=:transaction_id update ec_financial_transactions set refund_settled_date=current_timestamp where transaction_id=:transaction_id select case when refunded_date + '2 days'::interval < now() then 1 else 0 end from ec_financial_transactions where transaction_id=:transaction_id insert into ec_problems_log (problem_id, problem_date, problem_details, order_id) values (ec_problem_id_sequence.nextval, current_timestamp, :problem_details, :order_id)