Hi All,<\/p>\n
I realised that a lot of people are asking how to delete the tickets.
\nJust find and replace all instances of 886 with ur ticket id.<\/p>\n
For the developers, I already provided the code? haha. If you could do us all a favour and implement it into a simple “delete” link on each ticket in the attendees list or provide it as a function for the checkboxes, it would be uber duper awesome…<\/p>\n
Hope it helps everyone.<\/p>\n
So if you are a developer or a mini DBA, here is the MySQL code (For the the ugly):<\/p>\n
# Finds the product associated with the ticket
\n# Updates the total sales by reducing by 1
\nUPDATE events_postmeta
\nINNER JOIN (<\/p>\n
\tSELECT meta_value FROM events_postmeta
\nWHERE post_id = ‘886’
\nAND meta_key = ‘_tribe_wooticket_product’<\/p>\n
)
\nAS ticket_number
\nON ticket_number.meta_value = events_postmeta.post_id
\nSET events_postmeta.meta_value = events_postmeta.meta_value -1
\nWHERE events_postmeta.meta_key = ‘total_sales’;<\/p>\n
# Finds the product associated with the ticket
\n# Updates the _stock by increasing it by 1
\nUPDATE events_postmeta
\nINNER JOIN (<\/p>\n
\tSELECT meta_value FROM events_postmeta
\nWHERE post_id = ‘886’
\nAND meta_key = ‘_tribe_wooticket_product’<\/p>\n
)
\nAS ticket_number
\nON ticket_number.meta_value = events_postmeta.post_id
\nSET events_postmeta.meta_value = events_postmeta.meta_value + 1
\nWHERE events_postmeta.meta_key = ‘_stock’;<\/p>\n
# Delete the ticket details
\nDELETE events_postmeta FROM events_postmeta
\nWHERE post_id = ‘886’;<\/p>\n
# Delete the ticket
\nDELETE events_posts FROM events_posts
\nWHERE ID = ‘886’;<\/p>\n","protected":false},"template":"","class_list":["post-55888","topic","type-topic","status-closed","hentry"],"yoast_head":"\n