Concom registrations & Coupon Code

Norma Barrett-Lincoln

Norma Barrett-Lincoln's picture

ConCom

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

Can i get a coupon set up for concom regs (price $15)?

Submitted by Norma Barrett-Lin... on Sun, 07/12/2009 - 2:17pm

Tim Martin

Tim Martin's picture

The Quartermaster

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

I thought I had registered already... lol. Guess not.
I need two. I'll poke Stan and have him set up a code for us.



Tim 'somecallmeTim' Martin
- - - - - - - - - -
WesterCon 2012 Guest Liason Staff
Spokane in 2015 Worldcon bid commitee
INFilk chief bottle washer and newsletter guy

Submitted by Tim Martin on Mon, 07/13/2009 - 6:00am.

Stan

Stan's picture

Web Team Lead

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

No need to poke me this time Tim, Norma already did, I just didn't get the chance til now to configure it. Smiling

ConCom Reg coupon code is: SCCC090713



Submitted by Stan on Mon, 07/13/2009 - 7:58am.

Tim Martin

Tim Martin's picture

The Quartermaster

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

Stan wrote:

No need to poke me this time Tim, Norma already did,...

Awwwww.....

Well, I'm sure I could get Norma to mutter sweet null bits into my ear to make me feel better.



Tim 'somecallmeTim' Martin
- - - - - - - - - -
WesterCon 2012 Guest Liason Staff
Spokane in 2015 Worldcon bid commitee
INFilk chief bottle washer and newsletter guy

Submitted by Tim Martin on Mon, 07/13/2009 - 11:55am.

Tim Martin

Tim Martin's picture

The Quartermaster

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

so... where is my checkout button for the two regs I just added to the cart? I would like to pay.



Tim 'somecallmeTim' Martin
- - - - - - - - - -
WesterCon 2012 Guest Liason Staff
Spokane in 2015 Worldcon bid commitee
INFilk chief bottle washer and newsletter guy

Submitted by Tim Martin on Mon, 07/13/2009 - 12:20pm.

Norma Barrett-Lincoln

Norma Barrett-Lincoln's picture

ConCom

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

If you insist. Laughing out loud

SELECT r.id, e.badge_id, e.badge_name, r.last_name, r.first_name, et.name AS event_name, IFNULL(d.group_type_id, 0) AS group_type_id
FROM registrant r
INNER JOIN event e ON r.id = e.reg_id
INNER JOIN event_type et ON e.event_id = et.id
LEFT JOIN discount d ON d.last_name = r.last_name
WHERE r.last_name LIKE '%Martin%'

Returns 0 rows.

ETA: Darn, I swear I clicked Reply. Oh, well.

Submitted by Norma Barrett-Lin... on Mon, 07/13/2009 - 12:56pm.

Stan

Stan's picture

Web Team Lead

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

somecallmeTim wrote:

so... where is my checkout button for the two regs I just added to the cart? I would like to pay.

It's a problem with your permissions--you have too many. Sticking out tongue John and I would find ourselves incapable of registering with our accounts as well. You should be able to register by logging out of your account and going through the process anonymously.



Submitted by Stan on Mon, 07/13/2009 - 1:38pm.

Tim Martin

Tim Martin's picture

The Quartermaster

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

Stan wrote:
somecallmeTim wrote:

so... where is my checkout button for the two regs I just added to the cart? I would like to pay.

It's a problem with your permissions--you have too many. Sticking out tongue John and I would find ourselves incapable of registering with our accounts as well. You should be able to register by logging out of your account and going through the process anonymously.

LOL.. that makes sense in a strange way... been doing this long enough that I completely accept that answer.

Smiling



Tim 'somecallmeTim' Martin
- - - - - - - - - -
WesterCon 2012 Guest Liason Staff
Spokane in 2015 Worldcon bid commitee
INFilk chief bottle washer and newsletter guy

Submitted by Tim Martin on Mon, 07/13/2009 - 2:07pm.

Tim Martin

Tim Martin's picture

The Quartermaster

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

Ab_Normal wrote:

If you insist. Laughing out loud

SELECT r.id, e.badge_id, e.badge_name, r.last_name, r.first_name, et.name AS event_name, IFNULL(d.group_type_id, 0) AS group_type_id
FROM registrant r
INNER JOIN event e ON r.id = e.reg_id
INNER JOIN event_type et ON e.event_id = et.id
LEFT JOIN discount d ON d.last_name = r.last_name
WHERE r.last_name LIKE '%Martin%'

Returns 0 rows.

ETA: Darn, I swear I clicked Reply. Oh, well.

oh, be still my oscillating oxygen infused liquid transport organ.....



Tim 'somecallmeTim' Martin
- - - - - - - - - -
WesterCon 2012 Guest Liason Staff
Spokane in 2015 Worldcon bid commitee
INFilk chief bottle washer and newsletter guy

Submitted by Tim Martin on Mon, 07/13/2009 - 2:08pm.

Tim Martin

Tim Martin's picture

The Quartermaster

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

Okay.. coupon code only effects one item in cart.. Sad Cancelled my order and i'll take care of it late when I get home.

EDIT: All taken care of. Did it one at a time.



Tim 'somecallmeTim' Martin
- - - - - - - - - -
WesterCon 2012 Guest Liason Staff
Spokane in 2015 Worldcon bid commitee
INFilk chief bottle washer and newsletter guy

Submitted by Tim Martin on Mon, 07/13/2009 - 2:29pm.

Dana Casper

Dana Casper's picture

Writing Competition, Education Department

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

Question: Do the children under 12 who get in free need to register? My son would really like a badge but the only way to do that is to register - is that correct?



  • Dana Casper
  • Education Department
  • SpoCon 2011
Submitted by Dana Casper on Sat, 07/18/2009 - 9:57am.

Tim Martin

Tim Martin's picture

The Quartermaster

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

Yes, we take registration information for the under 12 set so they can have a badge. It also helps in knowing show's supposed to be there Smiling

jaycegrae wrote:

Question: Do the children under 12 who get in free need to register? My son would really like a badge but the only way to do that is to register - is that correct?



Tim 'somecallmeTim' Martin
- - - - - - - - - -
WesterCon 2012 Guest Liason Staff
Spokane in 2015 Worldcon bid commitee
INFilk chief bottle washer and newsletter guy

Submitted by Tim Martin on Sat, 07/18/2009 - 12:09pm.

Norma Barrett-Lincoln

Norma Barrett-Lincoln's picture

ConCom

  • Join Date: 31/12/1969
  • Post count:
  • User is offline

jaycegrae wrote:

Question: Do the children under 12 who get in free need to register? My son would really like a badge but the only way to do that is to register - is that correct?

Tim's got it right. Send me his name and I'll be sure to attach his membership to yours.

Norma

Submitted by Norma Barrett-Lin... on Sat, 07/18/2009 - 4:51pm.