query( 'SELECT ppv_ticket_id, ppv_ticket_paid,ppv_ticket_status, user_id FROM ppv_ticket WHERE ppv_ticket_id = ' . $dbh->quote( $ticketId ) )->fetch( PDO::FETCH_ASSOC ); if (isset( $row['ppv_ticket_id'] )) { if ($row['ppv_ticket_paid'] == 'no') { if ($row['ppv_ticket_status'] == 'valid') { $ret = $dbh->query( 'UPDATE ppv_ticket SET ppv_ticket_status = "pending refund" WHERE ppv_ticket_id = ' . $dbh->quote( $row['ppv_ticket_id'] ) ); if ($ret->rowCount( )) { $dbh->query( 'INSERT INTO ppv_ticket_refund SET ppv_ticket_id = ' . $dbh->quote( $row['ppv_ticket_id'] ) . ', ppv_ticket_refund_user_id = ' . $dbh->quote( $row['user_id'] ) . ', ppv_ticket_refund_requested = "' . time( ) . '", ppv_ticket_refund_completed = 0' ); return null; } } else { return 'Ticket id: ' . $ticketId . ' [ Reason: already refunded ]'; } } return 'Ticket id: ' . $ticketId . ' [ Reason: already payed ]'; } } function gets($index, $default = null) { if (isset( $_SESSION[$index] )) { return $_SESSION[$index]; } return $default; } function sets($index, $value) { $_SESSION[$index] = $value; } ................................. ....................... ..............