Sanctioning Well of Woe for retail play [Archive] - Wizards Community

Sanctioning Well of Woe for retail play [Archive] - Wizards Community

Post/Author/DateTime Post
MadCity_Marauder
10-25-06, 07:33 PM I am trying to sanction the 3 rounds of Well of Woe for retail play on 11/18/06. While the adventure description for these scenarios say they open for retail play on 11/1/06, they are not appearing in the Xen'drik Expeditions filter when I try to order the event. I have sanctioned events before and this problem usually happens when I haven't selected the right event type (which I have) or legal date for the event type (which I also have). Has anybody else had this problem?
MadCity_Marauder
10-25-06, 08:22 PM I just saw that Shawn had replied to a similar post and asked for people to describe what they did in event registration, step by step, so here goes. I'm leaving out stuff like event name since I can't imagine how that would effect my ability to order these events.

1. For type of show, I chose Retail.

2. For location type, I chose Retail Outlet.

3. For Start - End dates, I chose 11/18/06 for both. I have also tried 11/18/2006 but it hasn't made a difference.

4. For number of sessions I chose 3.

The convention ordering then allowed me to go to step 2.

5. For filter, I chose Xen'drik Expeditions since this is the one Well of Woe adventures appear when one looks up their description off the RPGA home page.

At that point nothing showed up. I also couldn't find them under the filter ALL.

If anybody can help me on this, let me know if you need any more info.

Thanks!
MadCity_Marauder
10-25-06, 08:26 PM I'm leaving out stuff like event name since I can't imagine how that would effect my ability to order these events.

Uh, about that event name? :rolleyes:

I took out an apostrophe and it seemed to help. Don't ask me why.
smerwin29
10-26-06, 09:08 AM Yes. If you have problems like the MadCity Marauder, trying changing the name of your event. This is the third problem I have heard about where certain characters in the event name have caused problems.

Shawn
Crimson Codex Guy
KShaver
10-26-06, 12:10 PM Uh, about that event name? :rolleyes:

I took out an apostrophe and it seemed to help. Don't ask me why.

Had same problem registering a character name with an apostrophe, so system definetely doesn't like 'em. At least it was just a rat shifter who didn't care much. All those drow characters are likely seething over the inability to use an apostrophe in their name, not to mention the members of dragonmarked houses who insist on using their full name.
Rewth
10-26-06, 03:37 PM yeah... ' characters cause a problem in virtually any field in the RPGA website. my guess is the update/insert commands being passed to the database place the values in single quotes and adding one of your own causes the query to fail.

hate to say it but its poor coding on the programmers side. a quick function to escape those characters before passing along to the db should fix it (and allow for some additional security checks to be performed if desired).
pedr
10-27-06, 05:11 AM I think I managed to get an apostrophe in the name of one of my characters by putting two in. But I might be remembering things wrongly!
Kelvane
10-28-06, 10:46 PM Thats what I did for my Blackwheel character.
Rewth
10-29-06, 08:33 AM if that works, excellent.

but coming from a strictly programming side of things(which means we're really getting away from the topic here), it might not be the best idea to do it. if that value is ever re-inserted into another table, the chances are, that insert will fail because the single quote in your name, once inserted with an escape character into the original table no longer contains the escape character. so you could be further hindering the ability of the site to work properly. at least for your character.

Post/Author/DateTime	Post
MadCity_Marauder 10-25-06, 07:33 PM	I am trying to sanction the 3 rounds of Well of Woe for retail play on 11/18/06. While the adventure description for these scenarios say they open for retail play on 11/1/06, they are not appearing in the Xen'drik Expeditions filter when I try to order the event. I have sanctioned events before and this problem usually happens when I haven't selected the right event type (which I have) or legal date for the event type (which I also have). Has anybody else had this problem?
MadCity_Marauder 10-25-06, 08:22 PM	I just saw that Shawn had replied to a similar post and asked for people to describe what they did in event registration, step by step, so here goes. I'm leaving out stuff like event name since I can't imagine how that would effect my ability to order these events. 1. For type of show, I chose Retail. 2. For location type, I chose Retail Outlet. 3. For Start - End dates, I chose 11/18/06 for both. I have also tried 11/18/2006 but it hasn't made a difference. 4. For number of sessions I chose 3. The convention ordering then allowed me to go to step 2. 5. For filter, I chose Xen'drik Expeditions since this is the one Well of Woe adventures appear when one looks up their description off the RPGA home page. At that point nothing showed up. I also couldn't find them under the filter ALL. If anybody can help me on this, let me know if you need any more info. Thanks!
MadCity_Marauder 10-25-06, 08:26 PM	I'm leaving out stuff like event name since I can't imagine how that would effect my ability to order these events. Uh, about that event name? :rolleyes: I took out an apostrophe and it seemed to help. Don't ask me why.
smerwin29 10-26-06, 09:08 AM	Yes. If you have problems like the MadCity Marauder, trying changing the name of your event. This is the third problem I have heard about where certain characters in the event name have caused problems. Shawn Crimson Codex Guy
KShaver 10-26-06, 12:10 PM	Uh, about that event name? :rolleyes: I took out an apostrophe and it seemed to help. Don't ask me why. Had same problem registering a character name with an apostrophe, so system definetely doesn't like 'em. At least it was just a rat shifter who didn't care much. All those drow characters are likely seething over the inability to use an apostrophe in their name, not to mention the members of dragonmarked houses who insist on using their full name.
Rewth 10-26-06, 03:37 PM	yeah... ' characters cause a problem in virtually any field in the RPGA website. my guess is the update/insert commands being passed to the database place the values in single quotes and adding one of your own causes the query to fail. hate to say it but its poor coding on the programmers side. a quick function to escape those characters before passing along to the db should fix it (and allow for some additional security checks to be performed if desired).
pedr 10-27-06, 05:11 AM	I think I managed to get an apostrophe in the name of one of my characters by putting two in. But I might be remembering things wrongly!
Kelvane 10-28-06, 10:46 PM	Thats what I did for my Blackwheel character.
Rewth 10-29-06, 08:33 AM	if that works, excellent. but coming from a strictly programming side of things(which means we're really getting away from the topic here), it might not be the best idea to do it. if that value is ever re-inserted into another table, the chances are, that insert will fail because the single quote in your name, once inserted with an escape character into the original table no longer contains the escape character. so you could be further hindering the ability of the site to work properly. at least for your character.