Search Results for 'state'

[Anonymous]

I don’t understand what is going on here… will not work on my end.

Tested several things:
Attempt 1
Placed only this code is my “Default Single Event Format”: [eme_if tag="#ESC_EVENTDETAILS"]<h2>Additional Information</h2>#_EVENTDETAILS[/eme_if]
Verified that text was truly in the event’s “Details” section.
Did not work

Attempt 2
Placed only this code is my “Default Single Event Format”: #_EVENTDETAILS
Worked

Attempt 3
Placed only this code is my “Default Single Event Format”: [eme_if tag="#ESC_TOWN"]<h2>Additional Information</h2>#_EVENTDETAILS[/eme_if]
Worked

Attempt 4
Switched “TOWN” back to “EVENTDETAILS”: [eme_if tag="#ESC_EVENTDETAILS"]<h2>Additional Information</h2>#_EVENTDETAILS[/eme_if]
*Refreshed browser* Worked – but then stopped working (Browser cache?)

As it stands, I can place other placeholders in the conditional statement and it will work, but if I use “#ESC_EVENTDETAILS”, none of the #_EVENTDETAILS will be shown.

I don’t know what else I could try here. Any thought?

[Franky]

The state of your event was “draft”, not “public”. That’s why you couldn’t see it when not logged in.

Franky

[Anonymous]

I’ve cleaned up the above code and I still cannot get the [eme_if2 tag="#_EVENTDETAILS" is_empty=0]<h2>Additional Information</h2>#_EVENTDETAILS[/eme_if2] line to work.

It there a bug?

I cannot be sure of this, but I know that I was using #_NOTES in a similar conditional statement under previous versions.

[Anonymous]

All my other conditional statements are working, but #_EVENTDETAILS ( / #_NOTES). Am I coding my sub-conditions wrong?

Here is my code for “Default single event format”:

[eme_if tag="#_EVENTCATEGORIES" notvalue=Work]
<section class=”column column-1 grid-left-0 grid-width-12″>
<div class=”single-event-text-wrapper”>
<h1>#_EVENTNAME</h1>
<h2 id=”date”>#_{F jS}
[eme_if2 tag="#_{F j Y}" notvalue="#@_{F j Y}"]
[eme_if3 tag="#Y" notvalue="#@Y"], #Y[/eme_if3] –
[eme_if4 tag="#F" notvalue="#@F"]#@_{F }[/eme_if4]
#@_{jS}[/eme_if2], #@_{Y}</h2>
#_{l}

[eme_if2 tag="#_{F j Y}" notvalue="#@_{F j Y}"] – #@_{l}[/eme_if2]
[eme_if3 tag="#_{F j Y}" value="#@_{F j Y}"] only[/eme_if3]
[eme_if2 tag="#ESC_ATT{Leader}" is_empty=0]<h2>Leader</h2>#_ATT{Leader}[/eme_if2]
[eme_if2 tag="#ESC_TOWN" is_empty=0]<h2>Location</h2>#_ADDRESS<br>#_TOWN[/eme_if2]
[eme_if2 tag="#_EVENTDETAILS" is_empty=0]<h2>Additional Information</h2>#_EVENTDETAILS[/eme_if2]
</div>
</section>

<section class=”column column-2 grid-left-0 grid-width-12″><div class=”single-event-map-wrapper”>#_MAP</div><div class=”event-return-button”>View Full Itinerary</div></section>
[/eme_if]

[eme_if tag="#_EVENTCATEGORIES" value=Work]
[eme_if2 tag="#_AVAILABLESPACES" ge=1]
<div class=”eventpage-work-day”>#l</div>
<div class=”eventpage-work-date”>#_{F jS}</div>
[eme_if3 tag="#_AVAILABLESPACES" ge=1]<div class=”eventpage-work-available”>Available</div>[/eme_if3]
[eme_if4 tag="#_AVAILABLESPACES" value=0]<div class=”eventpage-work-booked”>Booked</div>[/eme_if4]
<div class=”eventpage-work-text”>Please enter your information below to submit your reservation.</div>
<div class=”eventpage-work-form-wrapper”>#_ADDBOOKINGFORM</div>
[/eme_if2]
[/eme_if]

[Anonymous]

I know this may be a little far fetched and may require sponsoring or something. Howbeit, this feature could add many possibilities.

The idea here is the ability to make a conditional statement for one event and reference another event’s attributes.

One scenario that I have encountered where this would be useful is when I have two events on the same day. It would be great to be able to have the second event display a certain way if found on the same day as the other event(s).

Any thoughts?

(The only way that I have been able to get close to this is by using conditions based on an event’s categories. It works, but it sure is limited. Especially, when trying to run the events through an RSS based mailing.)

[Anonymous]

<table class='eme-rsvp-form'>
            <tr><th scope='row'>Parent or Guardian Name*:</th><td>#_NAME</td></tr>
            <tr><th scope='row'>E-Mail*:</th><td>#_EMAIL</td></tr>
            <tr><th scope='row'>Select Number One*:</th><td>#_SPACES</td></tr>
            <tr><th scope='row'>Student's First Name*:</th><td>#REQ_FIELD{1}</td></tr>
            <tr><th scope='row'>Student's Last Name*:</th><td>#REQ_FIELD{2}</td></tr>
            <tr><th scope='row'>Grade for 2014-2015*:</th><td>#REQ_FIELD{3}</td></tr>
            <tr><th scope='row'>Birth Date*:</th><td>#REQ_FIELD{4}</td></tr>
            <tr><th scope='row'>Gender*:</th><td>#REQ_FIELD{5}</td></tr>
            <tr><th scope='row'>Home Address*:</th><td>#REQ_FIELD{7}</td></tr>
            <tr><th scope=‘row'>City*:</th><td>#REQ_FIELD{8}</td></tr>
            <tr><th scope=‘row'>State*:</th><td>#REQ_FIELD{9}</td></tr>
            <tr><th scope='row'>Zip Code*:</th><td>#REQ_FIELD{10}</td></tr>
            <tr><th scope='row'>Mom's primary phone number*:</th><td>#REQ_PHONE</td></tr>
            <tr><th scope='row'>Dad's primary phone number*:</th><td>#REQ_FIELD{11}</td></tr>
            <tr><th scope='row'>Emergency contact number*:</th><td>#REQ_FIELD{13}</td></tr>
            <tr><th scope='row'>Name and relationship*:</th><td>#REQ_FIELD{14}</td></tr>
            <tr><th scope='row'>Home Church/Branch*:</th><td>#REQ_FIELD{15}</td></tr>
            <tr><th scope='row'>Allergies &/or medical conditions*:</th><td>#REQ_FIELD{16}</td></tr>
            <tr><th scope='row'>Agree to <a onclick="window.open('http://www.zionscompass.com/co-op-guideline-agreement/','name','width=980,height=400')">Guidelines</a>*</th><td>#REQ_FIELD{17}</td></tr>
            <tr><th scope='row'>Comment:</th><td>#_COMMENT</td></tr>
            #_CAPTCHAHTML{<tr><th scope='row'>Please fill in the code displayed here:</th><td>#_CAPTCHA</td></tr>}
            </table>
            #_SUBMIT

[Anonymous]

Actually it looks like this.

<table class=’eme-rsvp-form’>
<tr><th scope=’row’>Parent or Guardian Name*:</th><td>#_NAME</td></tr>
<tr><th scope=’row’>E-Mail*:</th><td>#_EMAIL</td></tr>
<tr><th scope=’row’>Select Number One*:</th><td>#_SPACES</td></tr>
<tr><th scope=’row’>Student’s First Name*:</th><td>#REQ_FIELD{1}</td></tr>
<tr><th scope=’row’>Student’s Last Name*:</th><td>#REQ_FIELD{2}</td></tr>
<tr><th scope=’row’>Grade for 2014-2015*:</th><td>#REQ_FIELD{3}</td></tr>
<tr><th scope=’row’>Birth Date*:</th><td>#REQ_FIELD{4}</td></tr>
<tr><th scope=’row’>Gender*:</th><td>#REQ_FIELD{5}</td></tr>
<tr><th scope=’row’>Home Address*:</th><td>#REQ_FIELD{7}</td></tr>
<tr><th scope=‘row’>City*:</th><td>#REQ_FIELD{8}</td></tr>
<tr><th scope=‘row’>State*:</th><td>#REQ_FIELD{9}</td></tr>
<tr><th scope=’row’>Zip Code*:</th><td>#REQ_FIELD{10}</td></tr>
<tr><th scope=’row’>Mom’s primary phone number*:</th><td>#REQ_PHONE</td></tr>
<tr><th scope=’row’>Dad’s primary phone number*:</th><td>#REQ_FIELD{11}</td></tr>
<tr><th scope=’row’>Emergency contact number*:</th><td>#REQ_FIELD{13}</td></tr>
<tr><th scope=’row’>Name and relationship*:</th><td>#REQ_FIELD{14}</td></tr>
<tr><th scope=’row’>Home Church/Branch*:</th><td>#REQ_FIELD{15}</td></tr>
<tr><th scope=’row’>Allergies &/or medical conditions*:</th><td>#REQ_FIELD{16}</td></tr>
<tr><th scope=’row’>Agree to Guidelines*</th><td>#REQ_FIELD{17}</td></tr>
<tr><th scope=’row’>Comment:</th><td>#_COMMENT</td></tr>
#_CAPTCHAHTML{<tr><th scope=’row’>Please fill in the code displayed here:</th><td>#_CAPTCHA</td></tr>}
</table>
#_SUBMIT

And here is the website and form:
http://www.zionscompass.com/events/2014-08-04/

[Anonymous]

My form submitted even though there was a required field blank. The req ToC was not checked and it submitted as well. Here is the RSVP template code.

<table class=’eme-rsvp-form’>
<tr><th scope=’row’ width=”200″>Parent or Guardian Name*:</th><td>#_NAME</td></tr>
<tr><th scope=’row’>E-Mail*:</th><td>#_EMAIL</td></tr>
<tr><th scope=’row’>Select Number One*:</th><td>#_SPACES</td></tr>
<tr><th scope=’row’>Student’s First Name*:</th><td>#REQ_FIELD{1}</td></tr>
<tr><th scope=’row’>Student’s Last Name*:</th><td>#REQ_FIELD{2}</td></tr>
<tr><th scope=’row’>Grade for 2014-2015*:</th><td>#REQ_FIELD{3}</td></tr>
<tr><th scope=’row’>Birth Date*:</th><td>#REQ_FIELD{4}</td></tr>
<tr><th scope=’row’>Gender*:</th><td>#REQ_FIELD{5}</td></tr>
<tr><th scope=’row’>Home Address*:</th><td>#REQ_FIELD{7}</td></tr>
<tr><th scope=‘row’>City*:</th><td>#REQ_FIELD{8}</td></tr>
<tr><th scope=‘row’>State*:</th><td>#REQ_FIELD{9}</td></tr>
<tr><th scope=’row’>Zip Code*:</th><td>#REQ_FIELD{10}</td></tr>
<tr><th scope=’row’>Mom’s primary phone number*:</th><td>#REQ_PHONE</td></tr>
<tr><th scope=’row’>Dad’s primary phone number*:</th><td>#REQ_FIELD{11}</td></tr>
<tr><th scope=’row’>Emergency contact number*:</th><td>#REQ_FIELD{13}</td></tr>
<tr><th scope=’row’>Name and relationship*:</th><td>#REQ_FIELD{14}</td></tr>
<tr><th scope=’row’>Home Church/Branch*:</th><td>#REQ_FIELD{15}</td></tr>
<tr><th scope=’row’>Allergies &/or medical conditions*:</th><td>#REQ_FIELD{16}</td></tr>
<tr><th scope=’row’>Agree to Guidelines*</th><td>#REQ_FIELD{17}</td></tr>
<tr><th scope=’row’>Comment:</th><td>#_COMMENT</td></tr>
#_CAPTCHAHTML{<tr><th scope=’row’>Please fill in the code displayed here:</th><td>#_CAPTCHA</td></tr>}
</table>
#_SUBMIT

[Anonymous]

Hello, I am experiencing the same issue as stated above. Further, when I create a new event and assign RSVP credentials and pricing, the new event shows up as Free:(price) in the events dashboard. I’ve also received 500 errors when creating an event and enabling the RSVP/event price feature.

[Anonymous]

Hi there,

I was having issues with v1.34 and the eme_get_events_list function. The function would return events outside of the scope. For instance, I would set a scope of “this_week” and the plugin would return items from the beginning of the month. I check a few different areas of the function and found that I got the expected functionality if at line 1376 of eme_events.php I removed

OR (event_start_date <= '$limit_start' AND event_end_date >= '$limit_end')

I believe this makes the SQL statement too loose and allows false positives. Removing that line gets me the correct dates for the week, and nothing further. I see that you have added that logic throughout the plugin, perhaps it only needs to be there in certain spots? Let me know if there is some other troubleshooting I should try.

Thanks!
Aris

[Anonymous]

I am trying to write some code for an if statement about a custom field I created in my booking form. I was able to find this code sample to use as a starting point:

add_action('eme_insert_rsvp_action', 'my_eme_discount_function',20,1);
function my_eme_discount_function($booking) {
   global $wpdb;
   $bookings_table = $wpdb->prefix.BOOKINGS_TBNAME;
   $where = array();
   $fields = array();

   $event_id = $booking['event_id'];
   //$discount_code = $booking['event_id'];

      //print 'EVENT ID='.$event_id .' Booking_id = '.$booking['booking_id'];
 	//print_r ($booking);

   if ($event_id == 12) {        /* put in the event_id that needs processing */

      $seats=$booking['booking_seats'];
      $price=$booking['booking_price'];

      // more than 2 seats, then the price is 25 per seat
      if ($seats> 1)
          $price = 25;

      $fields['booking_price'] = $price;
      $where['booking_id'] = $booking['booking_id'];
      $wpdb->update($bookings_table, $fields, $where);
   }
   return;
}

But instead of calling

if ($event_id == 12)

I want to say

if ($my_new_field) == "valueOfField"

How would I reference the value of my new field?

Hopefully that make sense. Thanks!!

[Anonymous]

I’ve tested your changes.

Cleanup works fine now, thanks.

For the recurrences: I tested your changes and got an error saving the settings (Error: Settings-Page not found).

Also I could not add a new event: The datepicker didn’t work (in fact the field was empty. The default value is tody, but in the trunk-version it was empty.)

And the layout at my website was broken (it seems the styles didn’t work any more. The calendar was in a very “basic” form. I’m not sure I made it correct: I clicked the links and downloaded the trunk-files. Then I changed the php-files (saved the old files of course). Then I disabled/re-enambeld EME). The new option for recurrences was at the settings-page, but as stated above I could not save the settings, even if I didn’t change any setting. After the test I reverted back to the saved version and everything works as it should.

Strange…

[Anonymous]

I don’t think so, but maybe. What I want to do is to display the usernames of all the attendees , along with which of the “prices” of events they have booked.

Ideally, what I really want is a list by price, like this:

Price 1: Name 1 (Field 1), Name 2 (Field 1), Name 3 (Field 1), Name 4 (Field 1)

Price 2: Name 5 (Field 1)

Price 3: Name 6 (Field 1), Name 7 (Field 1)

…

When I had each price listed as a separate event, I just used #_ATTENDEES in the event page.

Maybe I can accompish this in the Bookings with a series of if-statements? In pseudocode:

Price 1:

if(#_SPACES1 !== 0){#_RESPNAME, #_FIELD1}

Price 2:

if(#_SPACES2 !== 0){#_RESPNAME, #_FIELD1}

…

Can I use the [events_if] tags in the Bookings format? I’m going to go try that out and see what happens.

…or maybe there’s an easier way that I’m just not seeing.

UPDATE

I managed to accomplish generally what I want with this (line-breaks added for readability):

`#_RESPNAME (

[events_if tag="#_SPACES1" notvalue="0"]Table 1[/events_if]

[events_if tag="#_SPACES2" notvalue="0"]Table 2[/events_if]

[events_if tag="#_SPACES3" notvalue="0"]Table 3[/events_if]

[events_if tag="#_FIELD02" notvalue=""] -- #_FIELD02[/events_if])`

I’m seeing an upcoming problem if my event has a different number than 3 tables, since this booking form is not customizable by event, as far as I can tell.

Simple wishlist:

“Bookings list format” as a textarea rather than a text input.

More complicated wishlist: Order entries by table? I have no idea if this is possible.

[Franky]

Ok, let’s take it slowly:

– when reading the usage page at http://www.e-dynamics.be/wordpress/?cat=8 , it states you need to use shortcodes on regular pages to get anything done from EME. And it says to look further down in the doc for the possible shortcodes.

– So, going to http://www.e-dynamics.be/wordpress/?cat=17 , you get a list of possible shortcodes for events lists, locations, or anything else mentioned there.

– In your case, let’s go to the shortcode doc for events: http://www.e-dynamics.be/wordpress/?cat=18 . There you have a whole lot of reading to do, but at the bottom there are some very useful examples.

– In this case, wanting to limit the events to one category for a specific wordpress page, use this example: [events_list category=1,3] (for showing events in category 1 or 3) , or [events_list category=1+3] (for showing events in both category 1 and 3)

[Franky]

Yeah, that filter is applied when retrieving the event, not when inserting it.

So you might want to apply this change, that is applied just before the event is inserted in the DB:

http://plugins.trac.wordpress.org/changeset/811618

But, concerning filters; read this: http://codex.wordpress.org/Function_Reference/add_filter

In short: you need a “return” statement in your function. In your case, just this might already help:

function pstv_unpub_event($event) {

// Check if we can publish or not

$event[event_status] = 3;

return $event;

}

[Anonymous]

Franky,

Several months ago, under an older version of the plugin, I had successfully created a select menu of states which would recenter the map to a particular lat/long for viewing ‘event locations in my state’. It seems that this no longer works, perhaps because the map object is now no longer available globally. On change of the select menu, I get a JS error “map.setCenter is not a function”. Do you have any insight on this or is there a different method now that might re-enable my map recentering?

Thanks Franky!

[Anonymous]

Hello

ANother issue that has cropped up in our early days of our site being live.

It has been pointed out that when you go to the paypal payment pages (this is on the paypal site) sometimes the button reads “payment on delivery” or words to that effect and makes a statement about money being taken in around two weeks. Rather than the usual Pay now button.

Why is this? Is it a setting? or is it something Pay Pay are messing about with and as such beyond our control?

Incidentally payment is taken pretty much straight away.

[Franky]

WPML should be working (although I don’t really support it because of the bizarre state of their webserver), so I can’t imagine why you would need different categories per language.

However, if you see events using

[events_calendar full=1 category=2]

then they should also show using

[events_list scope=all limit=3 category=2]

Also submit=Filter should change the value of the submit button. What version of EME are you using?

[Anonymous]

I’m still a devoted MailPress user, despite its peculiar development status (or more accurately, the state of its web site). We regularly use it to send links to an EME registration page.

[Anonymous]

I’ve got a pretty large form, but if I have any required fields it won’t submit the form at all stating that I need to fill out all the required feilds

Here’s the code for my form

<table class='eme-rsvp-form'>



<tr><th scope='row'>Number of Players*:</th><td>#_SEATS</td></tr>

<tr><th scope='row'><h3>Agreement:</h3></td></tr>

<tr><th scope="row"><p>Please read any waiver carefully. It includes a release of liability and waiver of legal rights and deprives you of the ability to sue certain parties. Do not agree to this document unless you have read and understood it in its entirety. By agreeing electronically, you acknowledge that you have both read and understood the text presented to you as part of the registration process. You also understand and agree that events carry certain inherent dangers and risks which may or may not be readily foreseeable, including without limitation personal injury, property damage or death. Your ability to participate in the event(s) is/are subject to your agreement to the waiver and by agreeing herein, you accept and agree to the terms of the waiver and release agreement.</p>

<tr><th scope='row'>Agreement*:</th><td>#REQ_FIELD01</td></tr>



<tr><th scope='row'>Name*:</th><td>#_NAME</td></tr>

<tr><th scope='row'>Team name*:</th><td>#REQ_FIELD02</td></tr>

<tr><th scope='row'>Division*:</th><td>#REQ_FIELD16</td></tr>



<tr><th scope='row'><h2>Player Information:</h2></td></tr>



<tr><th scope='row'><h3>Captain Information:</h3></td></tr>

<tr><th scope='row'>Team Captain name*:</th><td>#REQ_FIELD03</td></tr>

<tr><th scope='row'>Gender*:</th><td>#REQ_FIELD04</td></tr>

<tr><th scope='row'>Height*:</th><td>#REQ_FIELD15</td></tr>

<tr><th scope='row'>T-shirt Size*:</th><td>#REQ_FIELD06</td></tr>

<tr><th scope='row'>Date of Birth*:</th><td>#REQ_FIELD05</td></tr>

<tr><th scope='row'>E-mail:</th><td>#_EMAIL</td></tr>

<tr><th scope='row'>Phone number:</th><td>#REQ_PHONE</td></tr>

<tr><th scope='row'>Address*:</th><td>#REQ_FIELD11</td></tr>

<tr><th scope='row'>City*:</th><td>#REQ_FIELD12</td></tr>

<tr><th scope='row'>State*:</th><td>#REQ_FIELD13</td></tr>

<tr><th scope='row'>Zip*:</th><td>#REQ_FIELD14</td></tr>



<tr><th scope='row'><h3>Player 1 Information:</h3></td></tr>

<tr><th scope='row'>Player 1  name*:</th><td>#REQ_FIELD52</td></tr>

<tr><th scope='row'>Gender*:</th><td>#REQ_FIELD53</td></tr>

<tr><th scope='row'>Height*:</th><td>#REQ_FIELD54</td></tr>

<tr><th scope='row'>T-shirt Size*:</th><td>#REQ_FIELD55</td></tr>

<tr><th scope='row'>Date of Birth*:</th><td>#REQ_FIELD56</td></tr>

<tr><th scope='row'>E-mail:</th><td>#REQ_FIELD57</td></tr>

<tr><th scope='row'>Phone number:</th><td>#REQ_FIELD58</td></tr>

<tr><th scope='row'>Address*:</th><td>#REQ_FIELD59</td></tr>

<tr><th scope='row'>City*:</th><td>#REQ_FIELD60</td></tr>

<tr><th scope='row'>State*:</th><td>#REQ_FIELD61</td></tr>

<tr><th scope='row'>Zip*:</th><td>#REQ_FIELD62</td></tr>



<tr><th scope='row'><h3>Player 2 Information:</h3></td></tr>

<tr><th scope='row'>Player 2  name*:</th><td>#REQ_FIELD40</td></tr>

<tr><th scope='row'>Gender*:</th><td>#REQ_FIELD41</td></tr>

<tr><th scope='row'>Height*:</th><td>#REQ_FIELD42</td></tr>

<tr><th scope='row'>T-shirt Size*:</th><td>#REQ_FIELD43</td></tr>

<tr><th scope='row'>Date of Birth*:</th><td>#REQ_FIELD44</td></tr>

<tr><th scope='row'>E-mail:</th><td>#REQ_FIELD45</td></tr>

<tr><th scope='row'>Phone number:</th><td>#REQ_FIELD46</td></tr>

<tr><th scope='row'>Address*:</th><td>#REQ_FIELD47</td></tr>

<tr><th scope='row'>City*:</th><td>#REQ_FIELD48</td></tr>

<tr><th scope='row'>State*:</th><td>#REQ_FIELD49</td></tr>

<tr><th scope='row'>Zip*:</th><td>#REQ_FIELD50</td></tr>



<tr><th scope='row'><h3>Player 3 Information:</h3></td></tr>

<tr><th scope='row'>Player 3  name*:</th><td>#_FIELD29</td></tr>

<tr><th scope='row'>Gender*:</th><td>#_FIELD30</td></tr>

<tr><th scope='row'>Height*:</th><td>#_FIELD31</td></tr>

<tr><th scope='row'>T-shirt Size*:</th><td>#_FIELD32</td></tr>

<tr><th scope='row'>Date of Birth*:</th><td>#_FIELD33</td></tr>

<tr><th scope='row'>E-mail:</th><td>#_FIELD34</td></tr>

<tr><th scope='row'>Phone number:</th><td>#_FIELD35</td></tr>

<tr><th scope='row'>Address*:</th><td>#_FIELD36</td></tr>

<tr><th scope='row'>City*:</th><td>#_FIELD37</td></tr>

<tr><th scope='row'>State*:</th><td>#_FIELD38</td></tr>

<tr><th scope='row'>Zip*:</th><td>#_FIELD39</td></tr>



<tr><th scope='row'><h2>Policies:</h2></th><td></td></tr>



<tr><th scope='row'><h3>Team Roster Policy</h3></th><td></td></tr>



<tr><th scope='row'><a href="http://www.hoopsforheroes3on3.com/wp-content/uploads/2013/03/The-Official-Team-Roster.docx">Click here to download policy</a>



<tr><th scope='row'>Please Agree</th><td>#_FIELD08</td></tr>



<tr><th scope='row'><h3>6 Foot and Under Policy</h3></th><td></td></tr>



<tr><th scope='row'><a href="http://www.hoopsforheroes3on3.com/wp-content/uploads/2013/03/6-Foot-and-Under-Policy.docx">Click here to download policy</a>



<tr><th scope='row'>Please Agree</th><td>#_FIELD09</td></tr>



<tr><th scope='row'><h3>Refund Policy</h3></th><td></td></tr>



<tr><th scope='row'><a href="http://www.hoopsforheroes3on3.com/wp-content/uploads/2013/03/Refund-Policy.docx">Click here to download policy</a>



<tr><th scope='row'>Please Agree</th><td>#_FIELD10</td></tr>

</th><td></td></tr>

#_CAPTCHAHTML[<tr><th scope='row'>Please fill in the code displayed here:</th><td>#_CAPTCHA</td></tr>]

</table>

#_SUBMIT

[Franky]

Yes! Found and fixed (due in fact to me trying to use the correct $wpdb->prepare syntax and a incorrect backtick use in that prepare statement for columns):

http://plugins.trac.wordpress.org/changeset/695524

[Anonymous]

Hi Franky,

Thanks for answering.

I will try to figure that out, but as you may expect since updating is just mouse-clicks: I have no idea.

I did totally deinstall and subsequently reinstalled Events-Made-Easy, but that didn’t solve the problem, there was no change.

I will have a look at the databases since multisiting sometimes is hit by name confusion by the plugins. Whether that is on the plugin or WP itself I have no idea.

But I always keep everything updated to the latest state.

Sincerely,

Karsten

[Anonymous]

Hi – I just tried to add the #REQ to a field that changes the form to state that it is a required field. However I have a drop down field, and if I don’t select an option it still takes the rsvp. Thoughts?

<table class=’eme-rsvp-form’>

<tr><th scope=’row’>Name*:</th><td>#REQ_NAME</td></tr>

<tr><th scope=’row’>E-Mail*:</th><td>#REQ_EMAIL</td></tr>

<tr><th scope=’row’>Phone number:</th><td>#REQ_PHONE</td></tr>

<tr><th scope=’row’>Seats*:</th><td>#REQ_SEATS</td></tr>

<tr><th scope=’row’>Entree Choice 1*:</th>

<td>#REQ_FIELD1</td></tr>

<tr><th scope=’row’>Entree Choice 2*:</th>

<td>#REQ_FIELD5</td></tr>

<tr><th scope=’row’>Comment:</th><td>#_COMMENT</td></tr>

#_CAPTCHAHTML[<tr><th scope=’row’>Please fill in the code displayed here:</th><td>#_CAPTCHA</td></tr>]

</table>

#_SUBMIT

[Anonymous]

Hi – I just tried to add the #REQ to a field that changes the form to state that it is a required field. However I have a drop down field, and if I don’t select an option it still takes the rsvp. Thoughts?

<table class=’eme-rsvp-form’>

<tr><th scope=’row’>Name*:</th><td>#REQ_NAME</td></tr>

<tr><th scope=’row’>E-Mail*:</th><td>#REQ_EMAIL</td></tr>

<tr><th scope=’row’>Phone number:</th><td>#REQ_PHONE</td></tr>

<tr><th scope=’row’>Seats*:</th><td>#REQ_SEATS</td></tr>

<tr><th scope=’row’>Entree Choice 1*:</th>

<td>#REQ_FIELD1</td></tr>

<tr><th scope=’row’>Entree Choice 2*:</th>

<td>#REQ_FIELD5</td></tr>

<tr><th scope=’row’>Comment:</th><td>#_COMMENT</td></tr>

#_CAPTCHAHTML[<tr><th scope=’row’>Please fill in the code displayed here:</th><td>#_CAPTCHA</td></tr>]

</table>

#_SUBMIT

[Franky]

Ok, I found the issue 🙂

It was indeed a prepare statement with the wrong number of arguments, but I misread the linenumbers in the original bug report (I read 990, while I should’ve been looking for line 1300).

Anyway, fixed here:

http://plugins.trac.wordpress.org/changeset/645920

and then (to correct my stupid typo):

http://plugins.trac.wordpress.org/changeset/645925

[Franky]

Or maybe the issue is because “%s” is used for the prepare statement, while the value is an integer … it should be “%d”

Try this on line 506:

$sql = $wpdb->prepare("UPDATE $bookings_table set booking_payed=$value WHERE booking_id = %d",$booking_id);

[Franky]

This is weird: according to the reported line number in eme_rsvp.php, this happens in the call to eme_update_booking_payed() inside the function eme_paypal_ipn(). The prepare statement has the booking id as argument, thus the code is correct. But according to your warning, the argument is not there …

Now the function call has 2 arguments:

eme_update_booking_payed($booking_id,1)

and in the function eme_update_booking_payed(), you can see the prepare statement:

function eme_update_booking_payed($booking_id,$value) {

global $wpdb;

$bookings_table = $wpdb->prefix.BOOKINGS_TBNAME;

$sql = $wpdb->prepare("UPDATE $bookings_table set booking_payed=$value WHERE booking_id = %s",$booking_id);

return $wpdb->query($sql);

}

Now if the $booking_id is not defined, of course the prepare statement is not going to be happy …

This value *should* be returned by paypal, so if it is not there: check the html of the actual paypal form (the one from paypal, where you actually pay) and see if the html has “item_number” as a form value somewhere. If it does not, then there’s an issue with the paypall class.

[Anonymous]

If you’re going to muck with EME code and you make backups of the older files, and one of them is the main events-manager.php, do yourself a favor and not only rename the old one but CHANGE its contents so that the “Plugin Name:” field has a different name.

I just wasted about 2 hours of my life trying to figure out why my event images suddenly stopped appearing in my EME widgets. After circling around back a few times I finally found an old post, one of the first times Franky patched something for me, at http://www.e-dynamics.be/bbpress/topic.php?id=106

Sure enough, all this time I’ve had TWO instances of the EME plugin in my WordPress Plugins panel, and recently, accidentally, deactivated the new one and activated the old one. (I had simply intended to restart the same one.)

Upon patching it back in March, I had renamed the FILE NAME of the original to “old-events-manager.php” but purposely had left the contents in their original state, which unfortunately included the Plugin Name field.

So if you just change the “Plugin Name:” in the php file contents, you can avoid making the same stupid mistake I did. Now the older plugin, while still appearing in my Plugins list, is obviously marked with OLD in its name….

Of course, I would also have avoided this mess if I had left off the PHP extension. 🙂

[I’m not so sure that there were always two copies in my Plugins list. This may have happened because I had briefly swapped the old and new files during testing recently, so WP may have picked up and cached both of them as the plugin definition of record.]

[Anonymous]

Franky,
Do you think it might be possible to allow additional fields for the address data in the eme_locations DB to work with the hcard format?

I came across it while looking at foursquare integration which requires seperate tags to match a location. I think the same could apply for facebook opengraph API which I’ll be looking into next.

Maybe user: geoffreysf found a workaround as he mentioned using hcard in the following post: http://www.e-dynamics.be/bbpress/topic.php?id=180#post-861

Anyway – in simplest form, it would be great to have fields for each of the following:

fn – The name of the business = #NAME
adr – This class name should wrap all address information
street-address – The street address (not including city, state, etc.)
locality – The city or town = #TOWN
region – The state, provence, etc.
postal-code – The postal code

The fn and locality can already be used with existing placeholders NAME & TOWN.

Some reference info in case you don’t know what I’m talking about is here:

https://foursquare.com/business/brands/offerings/savetofoursquare/tester
http://microformats.org/wiki/hcard#Property_List

Thanks

[Franky]

I believe it to be your double quotes inside your double quotes to be the problem, try this (untested):

<table width="100%">

<tr>

<td>

<h3>Date</h3>

</td>

<td>

<h3>Organization</h3>

</td>

<td>

<h3>City/State</h3>

</td>

</tr>[events_list limit=200 scope=2012-00-00--2012-12-31 format='<tr><td>#_{M j}[events_if tag="#ESC_{j M Y}" notvalue="#ESC@_{j M Y}"]-[events_if2 tag="#ESC_{M}" notvalue="#ESC@_{M}"]#@_{M }[/events_if2]#@_{j}[/events_if], #o</td><td>#_EVENTNAME</td><td>#_TOWN</td></tr>']

</table>

[Anonymous]

Sorry to rehash this, but I think this workaround is limited. I’m having issues getting it to work. The following code is not working in this way, and I think it’s because I’m using conditional tags.

<table width="100%">

<tr>

<td>

<h3>Date</h3>

</td>

<td>

<h3>Organization</h3>

</td>

<td>

<h3>City/State</h3>

</td>

</tr>[events_list limit=200 scope=2012-00-00--2012-12-31 format="<tr><td>#_{M j}[events_if tag="#ESC_{j M Y}" notvalue="#ESC@_{j M Y}"]-[events_if2 tag="#ESC_{M}" notvalue="#ESC@_{M}"]#@_{M }[/events_if2]#@_{j}[/events_if], #o</td><td>#_EVENTNAME</td><td>#_TOWN</td></tr>"]

</table>

[Anonymous]

You can do that with a conditional statement and the booking form, as I do:

[events_if tag='#_IS_RSVP_ENABLED' value='1'] #_ADDBOOKINGFORM [/events_if]

The form just appears when it’s appropriate, and disappears when it’s not.

[Anonymous]

I still don’t see what your seeing. What I see is a list of the events, and then the calendar marked April 2012. And yes, if you see my first post I am not using the “lists” feature in the settings as it is stated in the docs to not too. It is automatically putting that list there and my settings say it is turned off. That is the problem I just want the calendar layout on there and all the sudden it started to put a list on there too.

[Anonymous]

Beautiful — that bugfix solves my problem. Thank you!

The only thing I can’t figure out now is how to get my event title to start wrapping to the right of and aligned with the TOP of the image, rather than at the bottom.

I also had to get fancy and use a conditional statement to suppress the image space for events without images… This software is so powerful.

My new List Item code in my Event List widget:

<li><h3>[events_if tag='#_EVENTIMAGEURL' value='']

<a href=#_EVENTPAGEURL><img src="#_EVENTIMAGEURL" height="40" "width="40">  [/events_if]<b> #_LINKEDNAME</b> #M. #j</li></h3></a>&nbsp;

[Anonymous]

We ask for people to pay 50% of the cost at the time of booking providing that this is more than 28 days in advance. The remainder becomes payable 28 days before the event.

However, when booking <28 days before an event the full amount is payable.

So I would like the registration email to state what needs to be paid and when based on the value of [events_countdown id=#_EVENTID] . All our events have different prices so the total price shortcode will be useful but how can I do simple maths on this Eg divide by 2?

[Franky]

each event is an php-array, so the php-function print_r prints out the contents of that array for you, and then you can choose the elements which are interesting for you to do an if-statement on.

[Anonymous]

Hello,

having updated a WP multisite blog to 3.3 the dashboard wasn’t shown any longer.

I tried out to delete single plugins and then checked out if the dashboard could be seen again.

Having deleted eme I succeeded.

So I have to state that eme doesn’t work with multisite wp. That’s a pity.

Looking forward

Chris

[Franky]

implemented in trunk:

Feature: initial state for a new event can now be set in the settings page

[Anonymous]

I want to check for where logged in user == “guest” and if so only look at public events for the widget on the side menu

I’ve even hard-coded the SQL statement. But it doesn’t make any difference?

Is there anything I should look for?

Two Ways I’ve tried this

if ($this_event == STATUS_PRIVATE && !is_user_logged_in()) {

continue;

}

if ($this_event == STATUS_PRIVATE && $current_userid != “guest” ){//TJB

continue;

}

OR IN SQL ITSELF

if ($where != “”)

$where = ” WHERE ” . $where . ” AND event_status = 1″ ; //TJB

$sql = “SELECT *,

DATE_FORMAT(event_start_date, ‘%e’) AS ‘event_start_day’,

DATE_FORMAT(event_start_date, ‘%m’) AS ‘event_start_month’,

DATE_FORMAT(event_start_date, ‘%Y’) AS ‘event_start_year’,

DATE_FORMAT(event_start_time, ‘%k’) AS ‘event_start_hh’,

DATE_FORMAT(event_start_time, ‘%i’) AS ‘event_start_mm’,

DATE_FORMAT(event_start_time, ‘%h:%i%p’) AS ‘event_start_12h_time’,

DATE_FORMAT(event_start_time, ‘%H:%i’) AS ‘event_start_24h_time’,

DATE_FORMAT(event_end_date, ‘%e’) AS ‘event_end_day’,

DATE_FORMAT(event_end_date, ‘%m’) AS ‘event_end_month’,

DATE_FORMAT(event_end_date, ‘%Y’) AS ‘event_end_year’,

DATE_FORMAT(event_end_time, ‘%k’) AS ‘event_end_hh’,

DATE_FORMAT(event_end_time, ‘%i’) AS ‘event_end_mm’,

DATE_FORMAT(event_end_time, ‘%h:%i%p’) AS ‘event_end_12h_time’,

DATE_FORMAT(event_end_time, ‘%H:%i’) AS ‘event_end_24h_time’

FROM $events_table

$where” ;

Note: hardcoding this to see if it had any effect.Not the way I want to it to be in real life

Does seem to affect the listing at all?

What am I doing wrong?

[Anonymous]

Sorry forgot to state the version. Its v 1.0.1. Yes only the link-option.

[Anonymous]

I’m using it on a not-for-profit site and it works extraordinarily well. Franky is doing an outstanding job! I’m also not using the paid option. I’ve formatted it using CSS to look similar to a popular search engine’s calendar. If you want to take a look, email me at info@ncwsa.org and state that you’d like your message forwarded to the new Website Coordinator. I will then email the test site URL to you. The site is not yet public, but probably will be by the end of December. Please respect our private test site by not passing the URL around to friends (or enemies, for that matter).

I’m not quite sure what 3dperuna means by writing that he can’t display events sorted by date. It’s easy to do so. Obviously, by definition, any of the calendars sort by date. But I also have the events displayed in a list ordered by date, allowing filtering by scope (month) and event categories. The filters are not yet completely implemented.

[Anonymous]

I do the sorting by State.

This way the user can view all of the events by State.

I’ve used Categories to create all 50 States. Each State has it’s own Category entry.

[Anonymous]

Thank you again for your tip. However, after numerous trial and error struggles over night I am still nowhere with this and I’ll just have to accept that it’s beyond me 🙂 My current code for the single event is below, if you feel that it’s something you can help me with, I’ll appreciate it greatly. All I need is to be able to replace the time with “ALL DAY” if, let’s say I set the time to 12:00am (by the way, there is no way to input 00:00 into the time field). All other times I need it to show the regular time, as it’s doing right now. If this is too much to ask for I understand and I am grateful for your help and a great plugin anyway!

DATE & TIME:

#M. #j, #Y #@_{ – M. j, Y}, at

#_12HSTARTTIME</br>

DETAILS:

#_EVENTIMAGE

#_NOTES

LOCATION:

#_LOCATIONLINK
#_LOCATIONADDRESS
#_LOCATIONTOWN, #_LOCATIONSTATE #_LOCATIONPOSTCODE

<p>

#_MAP</br>

<p>

EVENT CATEGORY:

#_CATEGORIES

</p>

{has_bookings}

<h3>Bookings</h3>

#_BOOKINGFORM

{/has_bookings}

[Anonymous]

Thanks Franky,

That got me part of the way there using this:

[events_list paging=1 limit=0 scope=this_week]

BUT, I have one issue. I am categorizing my events by STATE. So I have 51 Category options for all of the States (including DC).

So, I sort all events by CATEGORY = California. It then shows me all of those events for the week with a PREVIOUS and NEXT.

When you click NEXT or PREVIOUS it disregards the category selection of California and shows all of the events again.

How to keep it on the one category?

[Franky]

Try your statements first manually until you find the right yntax for what you want to accomplish.

[Anonymous]

Thanks but I don’t want it to say “No events” if there aren’t any, I want the template to show something different without editing the core functions + the theme breaking when any updates to the plugin are released.

What do I need to check against in an IF ELSE statement to see if events are being returned or not and then echo my message?

[Anonymous]

I am having trouble figuring out how to do the following:

I categorize my events by STATE and by TYPE.

I would like to allow my users the ability to choose by 1, both, or neither in order to query the events. So, they would be able to see all events in California that are Type B.

It would be easy if I could use the #_FILTER_CATS (value = 1,2,3) for one of the options and then #_FILTER_CATS (value = 4,5,6,7,etc…for all the States) as the second option.

I was thinking of trying to use Location, but the Locations are fixed and every time I add California to a new Event it enters it as a new Location in the list.

Any suggestions here?

Thanks!

[Anonymous]

I would like to see an additional status added to events.

Status PLANNING ( PUBLIC and PRIVATE ) so two states really

In this state events would be visible ( as per the additional id ) but would not necessarily have a date set.

This would allow and organisers to use the planner to gather pre registrations for an event and then to organise a date for the event once sufficient interest or registration was guaranteed.

My particular application if for simple club activities. ie: some ( idiot 🙂 ) says lets have a BBQ, until we know how many attendees we will get and when they can all make the date we can’t estimate costs or the best location for the BBQ.

[Anonymous]

I have a client wanting to filter events on the list by state. I think it would allow more flexibility if the location data were separated: street address, state/province, postal code. Thanks Franky!

[Franky]

Future is any *day* in the future, not hour. Since wordpress doesn’t know timezones, I can’t take the hour into account. In the code I have sql statements that take into account the hour as well, but maybe I should make an option for it …

[Franky]

And what about using the location notes field?

Also, in the 2 fields for the location address, you can put in zipcode, state, etc …

[Franky]

sorry, not possible for now unless you code this yourself using the available filter for [events_list] mentioned here: http://www.e-dynamics.be/wordpress/?cat=41

[Anonymous]

Hey everyone. I was wondering if anyone knew the best way to have events grouped and sorted by STATE on the events listing page. I know State isn’t a field, so it would be ok if it was a custom attribute, ie #_ATT{event-state}. Or perhaps there already is a simple way to do this and I don’t know how.

So say there is 60 upcoming events, all on the same day across the country. I would like to be able to list them out by state (alphabetically is fine), and then within each state the list of events in that state.

I you know how to sort by other parameters, please let me know and I could probably figure it out based on that.

THANKS FOR YOUR HELP EVERYONE!

-Luke

[Franky]

URL has been added, but google maps doesn’t work with more fields than the ones provided, and some countries don’t have states. You can use attributes for these if you want though.

[Anonymous]

All the locations in the locations list have data in all three fields, and I checked each individual entry. All three fields have data. Obviously, TBA and Internet don’t have number data in the address field or state in the town field, but I couldn’t figure out another way to handle that. Is there some formatting requirement that I missed?

This is a wonderful plugin. It’s easy to use and does almost everything we want it to do. We’d also like the reminder-email function, but that’s a minor thing compared to all the features that you’ve included. And thanks for the quick response.

[Anonymous]

Been digging around on php.net and found this but can’t figure out if that would apply:

atomkirk at hotmail dot com 23-Oct-2008 01:19

careful that when you put a strpos in an if statement that you take note that if the string is in the 0 position it will return false, causing your control structure to think its not in the string.

It’s about half way down the page at: http://php.net/strpos

I know you’ve changed it to strstr() now but just thought I’d see if it sheds any light

[Anonymous]

Boleo,

I edited the em_event.php file in the ‘classes’ folder to get the RATINGS running. Here’s what I did ( a bit sloppy I admit, but it works on xampp )

41.		'event_date_modified' => array( 'name'=>'date_modified', 'type'=>'%s' ),

42.		'blog_id' => array( 'name'=>'blog_id', 'type'=>'%d' ),

43.		'group_id' => array( 'name'=>'group_id', 'type'=>'%d' )

44.	);

First add a variable called ‘ratings’ below line 43. I should look like this:

‘ratings’ => array( ‘name’=>’ratings’, ‘type’=>’%d’ ). Make sure to add a ‘,’ after line 43 as well.

next, go to line 71 ,and add ‘var ratings;’ (minus the quotes).

70.var $group_id;

71.

72.	var $image_url = '';

73.	/**

Then go down to line 236, and below it, add ‘$this->ratings = ( !empty($_POST) ) ? $_POST : ”;’ ( again minus the quotes on the ends)

235.	$this->end_date = ( !empty($_POST['event_end_date']) ) ? $_POST['event_end_date'] : $this->start_date;

236.		$this->rsvp = ( !empty($_POST['event_rsvp']) ) ? 1:0;

237.		//$this->spaces = ( !empty($_POST['event_spaces']) && is_numeric($_POST['event_spaces']) ) ? $_POST['event_spaces']:0;

ADD CODE HERE

Now create the database fields to interact with your ratings system in ‘wp_em_events’, and go to line 709. Below this line you will need to define your code for the ratings system ( I’ll call it $test for this example ) and…

call = '#_RATINGS';

$eventid = $this->id



$ratings = <-SOME CODE->;

$replace = $ratings;

break;

I post the ratings that users enter to a seperate php file, and pass the $event id along in a hidden form field ‘<input name=”eventid” type=”hidden” value=”$eventid” />’

I have the form defined as follows, ABOVE line 703. It’s setup like this

$rateform =

<<< END

<strong>Rate This Location</strong>

<form action="http://localhost/test/ratepost.php" method="post">

<select name="votes">

<option value="1">1</option>

<option value="2">2</option>

<option value="3">3</option>

<option value="4">4</option>

<option value="5">5</option>

</select>

<input type="hidden" value="$this->id" name="eventid"/>

<input type="hidden" value="total +1" name="total"/>

<input value="submit" name="submit" type="submit" style="background: #333;"/>

</form>

END;

*** Make sure that <<< END and END; appear on their own line with no white space ***

On the external page ( that it’s posting to) define your $_POST variables ( we’ll say

$vote=$_POST , $event_id = $_POST, etc.

Now you just take the variables and do a mysql update for the ratings field WHERE event_id = $event_id …

Then to prevent users who are not logged in just encase the whole thing in an IF statement:

if (is_user_logged_in)

{

case: ‘#_RATINGS’

< YADDA YADDA YADDA >

replace=$ratings;

break;

}

else $replace='<p>You must login to rate events</p>’;

Like I said a bit sloppy, and a bit long-winded in the explanation, but if you get the idea I’m sure you can do something with it. Hell, you’ll probably find a quicker easier way than I did.

[Franky]

You miss signle quotes around the “$oldcomment” in the update statement.

But best (and I need to change the code in general accordingly) is to use $wpdb->prepare.

I already have one example on the usage in the trunk code.

[Franky]

Not going to be done: bulk import can be done via mysql statements (using openoffice can help you there to go from csv to mysql). Email is not something I’m going to implement: there’s a seperate plugin that let you insert EME events via a regular page, I believe the email part should go there as well.

[Anonymous]

Franky

I have Events Manager Extended 3.3.5 so yes its newer

here are the errors I see on our Events page:

WordPress database error: [Unknown column ‘event_status’ in ‘where clause’]

SELECT *, DATE_FORMAT(event_start_date, ‘%e’) AS ‘event_day’, DATE_FORMAT(event_start_date, ‘%Y’) AS ‘event_year’, DATE_FORMAT(event_start_time, ‘%k’) AS ‘event_hh’, DATE_FORMAT(event_start_time, ‘%i’) AS ‘event_mm’, DATE_FORMAT(event_end_date, ‘%e’) AS ‘event_end_day’, DATE_FORMAT(event_end_date, ‘%Y’) AS ‘event_end_year’, DATE_FORMAT(event_end_time, ‘%k’) AS ‘event_end_hh’, DATE_FORMAT(event_end_time, ‘%i’) AS ‘event_end_mm’ FROM wp_dbem_events WHERE event_status IN (1,2) AND (event_start_date >= ‘2011-07-03’ OR (event_end_date >= ‘2011-07-03’ AND event_end_date != ‘0000-00-00’ AND event_end_date IS NOT NULL)) ORDER BY event_start_date ASC , event_start_time ASC LIMIT 51

then when I tried to add an event, I see these errors:

WordPress database error: [Unknown column ‘event_status’ in ‘field list’]

INSERT INTO wp_dbem_events (event_name,event_status,event_start_date,event_end_date,event_start_time,event_end_time,event_rsvp,rsvp_number_days,registration_requires_approval,registration_wp_users_only,event_seats,event_contactperson_id,event_notes,event_page_title_format,event_single_event_format,event_contactperson_email_body,event_respondent_email_body,event_url,event_category_ids,event_attributes,location_id,event_author,creation_date,modif_date,creation_date_gmt,modif_date_gmt) VALUES (‘East West Bookshop Lecture’,’5′,’2011-07-16′,’2011-07-16′,’19:00:00′,’20:30:00′,’0′,’0′,’0′,’0′,’0′,’-1′,’An intro talk by Joshua Shapiro’,’Introduction to the Crystal Skulls’,”,’crystalskullexplorers@gmail.com’,”,”,”,’a:0:{}’,’8′,’1′,’2011-07-03 10:14:06′,’2011-07-03 10:14:06′,’2011-07-03 15:14:06′,’2011-07-03 15:14:06′)

WordPress database error: [Unknown column ‘event_status’ in ‘field list’]

INSERT INTO wp_dbem_events (event_name,event_status,event_start_date,event_end_date,event_start_time,event_end_time,event_rsvp,rsvp_number_days,registration_requires_approval,registration_wp_users_only,event_seats,event_contactperson_id,event_notes,event_page_title_format,event_single_event_format,event_contactperson_email_body,event_respondent_email_body,event_url,event_category_ids,event_attributes,location_id,event_author,creation_date,modif_date,creation_date_gmt,modif_date_gmt) VALUES (‘East West Bookshop Lecture’,’5′,’2011-07-16′,’2011-07-16′,’19:00:00′,’20:30:00′,’0′,’0′,’0′,’0′,’0′,’-1′,’An intro talk by Joshua Shapiro’,’Introduction to the Crystal Skulls’,”,’crystalskullexplorers@gmail.com’,”,”,”,’a:0:{}’,’8′,’1′,’2011-07-03 10:14:06′,’2011-07-03 10:14:06′,’2011-07-03 15:14:06′,’2011-07-03 15:14:06′)

Future events

Database insert failed!

You have installed the new version of Events Manager Extended. This version has among other things switched from ‘dbem’ to ’eme’ for API calls (used in templates) and for CSS. So if you use these, please replace the string ‘dbem’ by ’eme’ in your custom templates and/or CSS. After that, please deacticate/reactivate the plugin to adjust for the new version.

from the error it appears the switch from dbem to eme for the API calls is the challenge – so I don’t know how to replace the string – the designer who did our website isn’t available – perhaps as is stated above if I can find where are the custom templates or CSS I can make this change myself but where do I look?

your plug-in looks great – just would like it to work

thanks for any help you can give Franky

or is it possible I could speak to you by Skype and you can tell me

where to look – it sounds like I just need to make a small change

thank you – Joshua – good weekend

[Franky]

It is in the pipeline to configure this, but for now: change events-manager.php, around line 126 to the level you want/need:

define(‘MIN_CAPABILITY’, ‘edit_posts’); // Minimum user level to edit own events

define(‘AUTHOR_CAPABILITY’, ‘publish_posts’); // Minimum user level to put an event in public/private state

define(‘EDIT_CAPABILITY’, ‘edit_others_posts’); // Minimum user level to edit any event

define(‘SETTING_CAPABILITY’, ‘activate_plugins’); // Minimum user level to edit settings

in your case, the “EDIT_CAPABILITY” would need to change (probably to ‘publish_posts’).

[Franky]

Like others: see my example and place the “if (!$found_event)” statement correctly.

[Anonymous]

I have a line in Single Event Format that is the following:

Current # of Attendees: #_RESERVEDSPACES

Problem is, If there are no RSVPs yet, it doesn’t return “0” it returns a blank space. Anyway to fix this quickly? I tried a few events_if statements but never got them to work… Is there any way to use these like the custom attributes with the second set of {}.

Thanks,

Mike

[Anonymous]

Hello

Is it possible to add new fields to event locations? something like

Region/State

and to be able to select events lists and maps on those fields

Regards

Gilles Simond

[Franky]

There’s an action hook available after an event has been created, see:

http://www.e-dynamics.be/wordpress/?cat=41

Just do something when the state is draft then …

[Franky]

Probably your location can’t be resolved in a unique way, try to be more specific (use street, town, state, country, etc …)

[Franky]

Change the lines:

define(‘MIN_CAPABILITY’, ‘edit_posts’); // Minimum user level to edit own events

define(‘AUTHOR_CAPABILITY’, ‘publish_posts’); // Minimum user level to put an event in public/private state

define(‘EDIT_CAPABILITY’, ‘edit_others_posts’); // Minimum user level to edit any event

define(‘SETTING_CAPABILITY’, ‘activate_plugins’); // Minimum user level to edit settings

to be:

define(‘MIN_CAPABILITY’, ‘edit_others_posts’); // Minimum user level to edit own events

define(‘AUTHOR_CAPABILITY’, ‘edit_others_posts’); // Minimum user level to put an event in public/private state

define(‘EDIT_CAPABILITY’, ‘edit_others_posts’); // Minimum user level to edit any event

define(‘SETTING_CAPABILITY’, ‘activate_plugins’); // Minimum user level to edit settings

[Franky]

Look at the lines below that one:

define(‘MIN_CAPABILITY’, ‘edit_posts’); // Minimum user level to edit own events

define(‘AUTHOR_CAPABILITY’, ‘publish_posts’); // Minimum user level to put an event in public/private state

define(‘EDIT_CAPABILITY’, ‘edit_others_posts’); // Minimum user level to edit any event

define(‘SETTING_CAPABILITY’, ‘activate_plugins’); // Minimum user level to edit settings

[Anonymous]

Hi,

I would loke to make a suggestion for additional optional fields in the location table, and coresponding placeholders.

The fields are:

++ZIP/Postal code

++Region/State

++URL

Best!

Andy

[Anonymous]

If I now understand correctly, EME would terminate URL’s with slashes if a user specifies that WordPress permalinks have a form something like this:

/%post_id%/%postname%/

But not if they specify something like this:

/%post_id%/%postname%

It seems reasonable to follow the slash convention specified for WordPress links. However, as stated before, trailing slashes should be specified.

[Anonymous]

Thanks for the emails. I have looked at a few of the options, but the calendar was working fine as the home/front page until Friday last week. hoping to get it back to that state….

Shall let you know if I succeed…

[Anonymous]

I wanted to add that after reading ShareThis Terms of Service and Privacy statement, and especially after looking at what their code does I will not be using it at any of my websites. Because of what I learned from that I didn’t want my post above to seem like an endorsement.

[Franky]

The code was a bit rough on the edges … try again with latest trunk.

About the conditional statements: make sure the “[” is present. And a empty tag won’t help you as well …

[Anonymous]

Two items. This does filter out for the events list, which is great, but it doesn’t for the “events_calendar” also it prints out my list of events along with the text from some conditional statements.

here’s an example of some events list output.

events_if tag=” notvalue=’5′] some meeting [/events_if]

[Franky]

This has been implemented in trunk

[Anonymous]

Hey! Thanks for this amazing plugin.

A question that has been raised among the end users: is it possible to remember the calendar state for the user during the session?

Say a user browses the calendar to May 2011 and clicks on an event date there. When the page for the event loads, would it be possible to then keep the calendar on May 2011 instead of reverting back to the current month?

Thanks!

[Anonymous]

Unfortunately, plugin developer use of the new WP 3.1 admin system column sorting feature described above was disabled in WP 3.1RC3 due to a large number of bugs discovered during testing and the capability won’t be included in the final release. This is the text of the official notice about that:

====================

The biggest change is the removal of AJAX list tables, which had been an effort to move all of our list-style screens to full AJAX for pagination, searches, and column sorts, and to consolidate the list-style screens into a single API that plugins could leverage. Unfortunately, with more testing came realizations that there were too many major bugs and usability issues with how the functionality was implemented, so we’ve spent the last week rolling back the most important portions of the feature.

■For users: AJAX has been entirely disabled for the list tables. We hope to bring this back again, in a form that is properly and fully implemented, in a future release. Column sorting remains, but everything else has returned to its 3.0 state.

■For developers: The entire list table API is now marked private. If you attempt to leverage new components of the API, you are pretty much guaranteeing that your plugins will break in a future release, so please don’t do that. We hope to enable all the fun new goodies for public use in a future release.

====================

[Franky]

For reference, this was a bug that was triggered “hide RSVP full events” was activated and no RSVP was made yet. It triggered a mysql statement that returned NULL where it should’ve been 0. I corrected

this in trunk. The change:

http://plugins.trac.wordpress.org/changeset/335949

[Anonymous]

This is what I have come up with so far:

[events_if tag='#ESC_CATEGORIES' value='Login to see address' && tag='#_IS_LOGGED_IN' value='0'] #_CATEGORIES [/events_if]

[events_if tag='#_IS_LOGGED_IN' value='0' && (!(tag='#ESC_CATEGORIES' value='Login to see address'))]

#_LOCATION

#_ADDRESS

#_TOWN

[/events_if]

[events_if tag='#_IS_LOGGED_IN' value='1' && (!(tag='#ESC_CATEGORIES' value='Login to see address'))]

#_LOCATION

#_ADDRESS

#_TOWN

[/events_if]

No matter what I have the #ESC_CATEGORIES value equal, the conditional statements will always display the address if the user is logged in. Also, if the user is logged out, only the “Login to see address” categories will display the address. This is pretty much the opposite of what I am looking for. I must have my ! (NOT) operator wrong, or I have something wrong with the #ESC_CATEGORIES’ value=”to the wrong thing’

[Anonymous]

“minimal luck” was certainly an understatement. We have some less technical people that will be adding events. Trying to make it simple for them and complicated for me. Is there a was I can write a “NOT EQUAL” if condition.

…tag=’#ESC_CATEGORIES’ value != ‘Login to see address’ …

OR

…tag=’#ESC_CATEGORIES’ value <> ‘Login to see address’ …

Thanks for your hard work.

[Anonymous]

Is it possible to HIDE if they are empty?

Example:

<h4 class=”widgettitle”>Event Website:</h4>

#_ATT{eventsite}

If there is no {eventsite} I’d like to hide the entire <H4 class> to save

vertical real estate.

Possible?

[Franky]

First: you need to make the change in the code as suggested if you want to use excerpts and have it formatted correctly (is in the next version).

Second: as the doc states: “#_EXCERPT shows an excerpt of the event (this is the content of #_NOTES until you place a <!--more--> marker”, which means that if you don’t specify the more-marker in your event, it will show everything.

[Anonymous]

The “Default location balloon format” instructions on the “Event Manager Options” page state:

“You can also use #_DIRECTIONS to insert a direction form in the balloon, but then you should add extra 6 <br/> tags after it, otherwise the balloon will not be of the correct height.”

4 <br/> tags seem to be adequate since the addition of “#saddr {margin-bottom:0;}” to “events_manager.css”.

[Anonymous]

Hi,

I installed your plugin, made the Events page, and put the Calendar widget on my sidebar. I entered a few events, including address/town/state, and all went well, except….when I click on any of the events on the Events page or click an event date on the calendar the only information that shows up is is the Event name, date/time, and town.

Ex:

Board Meeting

12 Jan 2011 – 17:30

MyTown

When entering the events the Google map shows up fine, and I do have the settings click to show the map, and after clicking on Submit Event I got a “New event successfully inserted!”.

So what am I doing wrong and what can I do to fix it please?

Thank you.

[Anonymous]

It is ambiguous whether these lines are parts of the same statements, but my recommendation above to add backslash characters is wrong, because I found they are not supported in this application by JavaScript. I avoid this problem in my own code by putting full statements on same lines and letting the code editor wrap them. However, though the solution I recommended above works in certain other languages it is not supported by JavaScript, so please disregard this post.

[Anonymous]

It is ambiguous whether these lines are parts of the same statements, but my recommendation above to add backslash characters is wrong, because I found they are not supported in this application by JavaScript. I avoid this problem in my own code by putting full statements on same lines and letting the code editor wrap them. However, though the solution I recommended above works in certain other languages it is not supported by JavaScript, so please disregard this post.

[Anonymous]

It is ambiguous whether these lines are parts of the same statements, but my recommendation above to add backslash characters is wrong, because I found they are not supported in this application by JavaScript. I avoid this problem in my own code by putting full statements on same lines and letting the code editor wrap them. However, though the solution I recommended above works in certain other languages it is not supported by JavaScript, so please disregard this post.

[Anonymous]

The end-of-line characters on “eme_location_map.js_with_infobox” Lines 712 and 713 should be “escaped” the backslash characters, because it otherwise is ambiguous whether those lines are parts of the same statements. See the explanation at http://www.e-dynamics.be/bbpress/topic.php?id=325

[Anonymous]

The end-of-line characters on “eme_location_map.js_with_infobox” Lines 644 through 647 should be “escaped” the backslash characters, because it otherwise is ambiguous whether those lines are parts of the same statements. See the explanation at http://www.e-dynamics.be/bbpress/topic.php?id=325

[Anonymous]

“eme_location_map.js” Line 72, 73, 75, 76 and 77 end-of-line characters should be “escaped” with backlashes, because otherwise it is ambiguous whether following lines are parts of the same statements. Some JavaScript implementations assume that sequential lines without terminating semicolons should be concatenated, but others process code on separate lines as separate statements with or without semicolons. Backslash end-of-line “escape” characters insure correct interpretation in either case.

This:

var li_element = "<li id='location-"+item.location_id

+ "' style='list-style-type: upper-alpha'><a >"

+ item.location_name+"</a></li>";

var location_info = "<div class="eme-location-balloon"><strong>"+ item.location_name

+ "</strong><br/>" + item.location_address + ", "

+ item.location_town + "<br/><small><a href='" + events_page_link

+ joiner + "location_id=" + item.location_id + "'>Details<a></div>";

Should be:

var li_element = "<li id='location-"+item.location_id 

+ "' style='list-style-type: upper-alpha'><a >" 

+ item.location_name+"</a></li>";

var location_info = "<div class="eme-location-balloon"><strong>"+ item.location_name 

+ "</strong><br/>" + item.location_address + ", " 

+ item.location_town + "<br/><small><a href='" + events_page_link 

+ joiner + "location_id=" + item.location_id + "'>Details<a></div>";

[Anonymous]

Dearest Franky,

first of all let me deeply thank you for making our lives so so much easier! This is arguably one of the most useful plugins I have ever seen on wordpress.

I have recognized a little glitch, maybe I am mistaking, but you state on your homepage that EME is not outputting

<ul> tags to the list, only <li> elements – which is a brilliant thought. Now my problem is, that I discovered that EME somehow includes <ul class="eme_events_list">, which screws basically my whole setup, and I could not figure out a workaround.

Could you let us know, why EME is doing that now? Have you changed you mind on that point?

And crucially for my personal case: How can I make EME stop adding the <ul> tag?

Best

Matt

ps: sorry for posting in the wrong section.

[Franky]

Unfortunately, admintiger is correct here: since events aren’t regular posts, this is a bit difficult.

You can import them as events using mysql statements, but not as events.

[Franky]

Well, normally the “display_name” is taken for wordpress users, see

http://codex.wordpress.org/Function_Reference/get_currentuserinfo.

For the phone: correct, I forgot to delete part of an if-statement. I updated this in trunk for eme_rsvp.php. You can get this version here: http://plugins.trac.wordpress.org/browser/events-manager-extended/trunk/eme_rsvp.php

[Anonymous]

Oh thank you, I feel so embarrassed now, as this was stated so clearly in the documentation…

[Franky]

Ok, I added the code to have “Public”, “Private” and “Draft” states to the trunk version.

[Anonymous]

I had to trouble shoot a problem today when updating to the latest revision. I was getting the following jscript error. “; Missing before statement”

I identified the line in the code 1776 of dbem_events.php. The cause of the error was i was storing html values which had single quotes in the single event format. This was easily fixed on my end by switching those to double quotes.

Now this could possibly happen in other areas from what i seen in the code, but this was the area and how i fixed my issue. This could be avoided at the code level, to either replace the single quotes with double quotes or properly escape it in the javascript output.

Hope this helps keep up the good work.

[Anonymous]

Would it be possible to add some shortcode parameters to allow site visitors to view events by country, state, etc., and also to search for events by the individual event contact name?

[Anonymous]

Hi Guys,

I’m running a website that runs in Cyrillic using a UTF-8 charset.

The plugin works fantastic in every aspect with Cyrillic except for the details (tinyMCE) editor.

Basically what happens is that I input text like this

Филиптур

and display on the front is иÐ�Ñ�Ñ�изÑ�изthe outputted HTML being along the lines of иÐ

The database tables (set to utf_general_ci) are currently displaying the content in correct Cyrillic.

Basically I assume that it is encoding it using the numeric function stated here

http://wiki.moxiecode.com/index.php/TinyMCE:Configuration/entity_encoding

I’ve read elsewhere on a few forums that if I change this to “raw” the text will not be encoded and will be displayed properly. However… can’t seem to find where to change that.

If anybody has any ideas that would be fantastic! Because I am at a loss to see how I can make this work.

Thanks in advance,

B

[Anonymous]

I just installed EME, but I needed to return the value of the dbem_get_events_list tag, not display it. In the documentation it says to use “display=false” however this did not work. I looked into the code and the code uses “echo” so I tried playing with the template tag using “echo=false” however this did not work either. Looking at the dbem_events.php file I found that the if statement at the end of the dbem_get_events_list function was not working, I was able to replace it with:

if ($echo)

{echo $output;}

else

{return $output;}

and now it seems to work. If you use echo=1, it will display – this is the default, if you use echo=0 it will return the values.

[Franky]

If it is for specific dates, you can always use the [events_list] shortcode. Use multiple statements of this format on the same page:

[events_list YYYY-MM-DD]

eg.

On 2010/09/05

[events_list 2010-09-05]



On 2010/09/07

[events_list 2010-09-07]

But if you want it automatically for all events: not possible for now

[Franky]

Hi Sebastian,

I got your mail with username/password, so I’ll check it out

Also:

– did you do the “ALTER TABLE” mysql statements?

– for uploading: the directory wp-content/uploads/locations-pics must exist and be writable by the user the webserver runs as (or 777). Mostly the folder wp-content/uploads/ exists already and Events Manager Extended tries to create the subfolder “locations-pics”, but you might want to check if it exists. Also: check if php allows file uploads as well, and the limits of it.

[Anonymous]

Update: after installing a different plugin, Easy Comment Uploads, the same error from EME’s capthca-check consistently filled the “upload” dialogue in ECU. It actually did not affect the functionality if the warning is ignored and the user selects a file to upload, it does upload.

But it’s too disconcerting for the average user.

My solution was to edit capthca_check.php so that it only contains the return(”) statement.

Seems to have solved the problem.

[Anonymous]

The text in the map bubble is displayed incorrectly. For example, it shows up as:

g>Michiga

U

io

g>

530 South State

A



Arbor, MI

Looking at the HTML, it is clear that tags got interrupted somehow:

<stro<br>g>Michiga<br> U<br>io<br></stro<br>

However, my formatting seems to be correct:

<strong>#_NAME</strong><br/>#_ADDRESS<br/>#_TOWN

Furthermore, the bubble displays perfectly fine if I deactivate the Extended plugin and reactivate the original modified Events Manager plugin.

You can see the issues I am having here: http://wmlwl.com/events

[Anonymous]

I have the latest version of 3.0.1 of Event Manager Extended but do not see the category option in the widget. Was it added as stated above?