scrair
| September 11, 2012 at 7:58 pm Can I update all my events within a certain date range (going forward from today) to include the early bird discount? I saw in the DB that the events_details table has the 3 fields to be updated, but wasn’t sure if there were additional tables it is hitting so I didnt want to attempt without asking first. If you have an easy way for me to do this, I would appreciate it. Thanks. |
Dean
| September 12, 2012 at 5:41 am Hello The best I can advise currently is that it wont work by just simply updating those three fields. It is linked elsewhere to actually enforce the deduction. I will get back to you on this. |
scrair
| September 12, 2012 at 9:56 am Thanks for the reply. I look forward to hearing if you have any options for me. |
Dean
| September 13, 2012 at 11:43 pm Just to let you know, I havent forgotten you, I’m in discussion with the devs at the moment, will get back to you as soon as I get a response. |
Dean
| September 17, 2012 at 7:12 am Hi, I got a response from the devs on this. It is possible to update it the fields in the database. You will need
to modify the wp_events_detail table though. Here is a screenshot of
the fields and format in PHPMyAdmin:
http://www.screencast.com/t/rTdt3lgmm93 Here is some SQL code that will update the entire database with the
data in the screenshot. The data should be changed to reflect their
needs: UPDATE wp_events_detail SET early_disc = ’50’,
early_disc_date = ‘2012-09-28’, early_disc_percentage = ‘Y’ WHERE
early_disc_date = ” If they only want to update certain events, they use this for each
event. Just change the id field to the event id: UPDATE
wp_events_detail SET early_disc = ’50’, early_disc_date =
‘2012-09-28’, early_disc_percentage = ‘Y’ WHERE id = ‘2’
Hope that makes some sense and can help out a bit |
