|
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
|
