Marathon Donation App - Call for testers

dballin

2011-12-14 07:54:41 pm

Balls jerky

and your system will make those unique by returning an error so this is not a problem?:

Attachment:

11111.jpg

UraniumAnchor

Edit history:

UraniumAnchor: 2011-12-14 08:01:50 pm

UraniumAnchor: 2011-12-14 08:00:20 pm

2011-12-14 07:59:37 pm

Not a walrus

Yeah, when connected to the MySQL DB it gives this error, so it's not a big deal. Same with duplicate aliases.

Edit: Also, Alt+PrntScrn will take a shot of just your current window so you don't have to crop things.

Attachment:

dupemail.png

dballin

Edit history:

dballin: 2011-12-14 08:23:15 pm

dballin: 2011-12-14 08:15:38 pm

dballin: 2011-12-14 08:08:44 pm

dballin: 2011-12-14 08:07:01 pm

2011-12-14 08:00:41 pm

Balls jerky

Alright. Moving along then.

Still moving along with the duplicate entries idea, I have created two master swords (which would be awesome if I could do that in real life) and I can do identical games as well. This probably isn't much of an issue, but I'll say it anyway.

Adding a donation without saving donor info still wipes it. I'm sure you're aware of that since it didn't sound like you knew how you were going to fix it.

When adding a bid, the search button returns challenges for all games instead of just the one you chose in the speedrun field. Search button returns an error "incompatible data type in operation" if you have the check mark on Speed Run so I'm not really sure what that check mark is for. You also can't attach a bid before you save the donation amount which probably just means you need to remember to save it first.

SMK

Edit history:

SMK: 2011-12-14 09:21:39 pm

SMK: 2011-12-14 09:07:30 pm

SMK: 2011-12-14 09:03:56 pm

2011-12-14 09:03:41 pm

Quote from dballin:

Still moving along with the duplicate entries idea, I have created two master swords (which would be awesome if I could do that in real life) and I can do identical games as well. This probably isn't much of an issue, but I'll say it anyway.

Are you using the HSQLDB file database? If so, then this is an issue with the schema generation that I'm using. Its been a bit flaky, but that issue doesn't come up using a properly configured MySQL database.

Quote from dballin:

Adding a donation without saving donor info still wipes it. I'm sure you're aware of that since it didn't sound like you knew how you were going to fix it.

That's kinda super low priority atm. Tongue

When in doubt, save (n.b. you can press ctrl-S to save on almost any tab).

Quote from dballin:

When adding a bid, the search button returns challenges for all games instead of just the one you chose in the speedrun field.

Quote from dballin:

Search button returns an error "incompatible data type in operation" if you have the check mark on Speed Run so I'm not really sure what that check mark is for.

Again, that's only coming up in the HSQLBD implementation. I'll be honest, I really haven't been testing anything on the HSQLDB side, just because its really not going to be used, at least for now. I'll try taking a look at those issues, but I can't make any guarantees, which sucks because its really helpful for testing on boxes that don't have MySQL installed.

*EDIT*AHAHA that was the funniest bug I've ever fixed. K, this will work once I push the next update. I'll see about getting the constraints to work properly in HSQLDB first though*/EDIT*

Note that it is working correctly when the box isn't checked: it ignores whatever's in the field when its not checked. I'm actually thinking of also visually disabling the associated field/button when its unchecked just to make it more clear, but that's also really low priority.

Quote from dballin:

You also can't attach a bid before you save the donation amount which probably just means you need to remember to save it first.

That's by design. In general, this won't be an issue since chipin donations' amount is pre-set and can't be changed, and the VAST majority of the donations will be chipin donations. Again, when in doubt, save.

[quote="dballin"]Still moving along with the duplicate entries idea, I have created two master swords (which would be awesome if I could do that in real life) and I can do identical games as well. This probably isn't much of an issue, but I'll say it anyway.[/quote]
Are you using the HSQLDB file database?  If so, then this is an issue with the schema generation that I'm using.  Its been a bit flaky, but that issue doesn't come up using a properly configured MySQL database.

[quote="dballin"]
Adding a donation without saving donor info still wipes it. I'm sure you're aware of that since it didn't sound like you knew how you were going to fix it.
[/quote]That's kinda super low priority atm. :P  When in doubt, save (n.b. you can press ctrl-S to save on almost any tab).

[quote="dballin"]
When adding a bid, the search button returns challenges for all games instead of just the one you chose in the speedrun field. 
[/quote]

[quote="dballin"]
Search button returns an error "incompatible data type in operation" if you have the check mark on Speed Run so I'm not really sure what that check mark is for.[/quote]Again, that's only coming up in the HSQLBD implementation.  I'll be honest, I really haven't been testing anything on the HSQLDB side, just because its really not going to be used, at least for now.  I'll try taking a look at those issues, but I can't make any guarantees, which sucks because its really helpful for testing on boxes that don't have MySQL installed.

*EDIT*AHAHA that was the funniest bug I've ever fixed.  K, this will work once I push the next update.  I'll see about getting the constraints to work properly in HSQLDB first though*/EDIT*

Note that it is working correctly when the box isn't checked: it ignores whatever's in the field when its not checked.  I'm actually thinking of also visually disabling the associated field/button when its unchecked just to make it more clear, but that's also really low priority.

[quote="dballin"]
You also can't attach a bid before you save the donation amount which probably just means you need to remember to save it first.
[/quote]That's by design.  In general, this won't be an issue since chipin donations' amount is pre-set and can't be changed, and the VAST majority of the donations will be chipin donations.  Again, when in doubt, save.

dballin

2011-12-14 09:21:35 pm

Balls jerky

hsqldb Memory is the one I've been using. I haven't actually saved a db and loaded it. As far as saving, yeah. I just wanted to try things out to see what would happen if somebody (like me) had no idea what they were doing and skipped a step by accident. Saving often will need to be beaten into people's heads I suppose.

SMK

2011-12-14 09:26:56 pm

lol, I could try doing what most IDEs do and put an asterisk or some kind of a marker on the current tab every time you make a modification to the document, then remove it after you save or refresh. It helps me remember to save constantly. Smiley

Anyways, I'm still trying to the constraint generation to work: I think I know how to go about it, but there is some weirdness that's preventing me from implementing it properly. Worst-case, you'll get the very unfriendly error messages in the HSQL version since I won't be able to detect which constraint got violated.

UraniumAnchor

Edit history:

UraniumAnchor: 2011-12-14 09:29:42 pm

UraniumAnchor: 2011-12-14 09:28:50 pm

2011-12-14 09:28:40 pm

Not a walrus

Oh, I just remembered, did you ever fix the issue where a name such as "A D Kelf" on chipin would be interpreted as "D, A"? Actually, not sure HOW that should get interpreted now that I think about it...

SMK

Edit history:

SMK: 2011-12-14 09:41:47 pm

SMK: 2011-12-14 09:34:50 pm

SMK: 2011-12-14 09:34:49 pm

2011-12-14 09:34:26 pm

Quote from UraniumAnchor:

Oh, I just remembered, did you ever fix the issue where a name such as "A D Kelf" on chipin would be interpreted as "D, A"? Actually, not sure HOW that should get interpreted now that I think about it...

Nope. I'm almost considering just collapsing the first/last name into just 'name', but that's a lot of work...for you! You'd have to do updating the schema and your website. It'd be pretty straightforward for me.

Alternatively, I was thinking just using a consistent scheme for making the first token the first name, and then the rest last name.

Thoughts?

UraniumAnchor

Edit history:

UraniumAnchor: 2011-12-14 10:23:11 pm

UraniumAnchor: 2011-12-14 09:37:38 pm

2011-12-14 09:35:47 pm

Not a walrus

I think the other way around might be better, having the last token be the last name and everything else be first. I'm not sure which is more likely to be wrong.

Also, collapsing everything into one name would completely break the privacy filter and the page sorting, so don't do that. Tongue

Rakuen

2011-12-14 09:39:48 pm

Weegee Time

Either way, just make sure if there's only one token it only goes into one of the fields, not both.

SMK

Edit history:

SMK: 2011-12-15 10:54:39 am

SMK: 2011-12-15 10:47:48 am

SMK: 2011-12-15 10:00:34 am

SMK: 2011-12-14 10:29:15 pm

2011-12-14 10:00:51 pm

K, did that.

I give up on setting the HSQL db constraints, its just not working and I'm too tired to care. I'm just going to make do the thing with the search fields and call it a night

edit: pushed changes, but there's nothing majorly different.

edit2:
- Script running is working again.
- I at least got some of the constraints working again in HSQLDB, just no good error messages to go along with them

Edit 3:

Quote from Rakuen:

1) Might be good to support a reverse lookup for bids.

- Done, though not extensively tested yet.

Also, I'm running out of ideas to implement, any requests anyone?

puwexil

2011-12-16 07:02:27 am

Professional Second Banana

Loaded a couple of prizes last night - nice to see that they're now displaying on the tracker without having a winner assigned.

mike89

2011-12-16 01:45:24 pm

SEGA Junkie

Quote from SMK:

Also, I'm running out of ideas to implement, any requests anyone?

Cross-posting from prizes: this has been proposed as a different way of doing prize drawings for particularly awesome prizes of awesome (such as the master sword). Could you implement that?

SMK

Edit history:

SMK: 2011-12-16 02:51:47 pm

2011-12-16 02:49:30 pm

Certainly doable (I'm assuming you're referring to the raffle version), and it shouldn't be too hard. Just to be absolutely clear:

- There is a minimum entry cut-off of X dollars, where X is specified by the user
- If Y dollars is the sum contributions of a given donor D within a user specified time period (which can be infinite in either direction for things like grand prizes and such), then that donor is floor(Y / X) times more likely to win than a donor who contributed exactly X dollars.

EDIT: Do you want me to implement any other forms of prize drawing, like higest-single donation in a time period, highest sum donations in a time period, etc?

mike89

Edit history:

mike89: 2011-12-16 03:56:22 pm

2011-12-16 03:55:41 pm

SEGA Junkie

Well that's not how I'd have expressed it (guess that's why I'm not a programmer, heh...) but yes, that's the gist of it.

I don't think highest single donation would be necessary (even if we did do any incentives that way, one could simply manually check that without too much trouble) but the latter would definitely be useful for the Iji donation incentive. I can't think of any other methods that would differ from those we already have in any way off hand.

SMK

Edit history:

SMK: 2011-12-16 09:54:35 pm

2011-12-16 09:53:29 pm

Quote from mike89:

... one could simply manually check that without too much trouble ...

Famous last words. I'll add it anyways, just because the relative cost of adding one more after adding the other two is extremely low.

I have my last exam this coming monday, after which I will be all kinds of free to do this.

Quote from mike89:

Well that's not how I'd have expressed it (guess that's why I'm not a programmer, heh...) but yes, that's the gist of it.

And that's why they pay me the ..., well, nothing actually.

dballin

2011-12-17 12:39:05 am

Balls jerky

I don't have any good ideas for things to add and the local version seems broken so i feel like my usefulness is at its end Sad

mikwuyma

Edit history:

mikwuyma: 2011-12-18 09:13:11 am

2011-12-18 09:08:11 am

My feelings on The Demon Rush

Mike89: We'd want to have a bidding/auction prize setup just for the Iji prize, but it sounds like SMK has set that up already.

UraniumAnchor

2011-12-18 02:37:13 pm

Not a walrus

Had a thought while looking at the prize list: Maybe the minimum bid and start/end games could be actual database entries and not just put in the description. Kinda low priority, but might be useful.

puwexil

2011-12-18 02:44:34 pm

Professional Second Banana

Those attributes are true for every prize entry, so I say go for it if/when you have time. Having them in separate columns would make the tracker data a bit cleaner and easier to read too (I had to truncate a bunch of game names to keep the Description column from word wrapping too much).

UraniumAnchor

2011-12-18 02:46:07 pm

Not a walrus

The grand prize would just have the game entries blank, but other than that, yeah, they all have those attributes.

SMK

Edit history:

SMK: 2011-12-18 04:11:05 pm

2011-12-18 04:10:43 pm

I refuse to let this distract me from studying!

Edit: oh, wait, damn it!

puwexil

2011-12-18 08:54:37 pm

Professional Second Banana

Unless I'm doing something wrong, the prize search doesn't seem to be working (the below search should return the dungeon man perler, and I've tried other strings too with the same outcome).

Attachment:

prizesearch.png

SMK

Edit history:

SMK: 2011-12-18 09:09:26 pm

SMK: 2011-12-18 09:09:25 pm

SMK: 2011-12-18 09:08:34 pm

2011-12-18 09:07:40 pm

Fixed, sorry, that was just a typo when I was updating the prize search methods. It should be ready to download in 2 minutes.

Edit: go for it. N.b. paging on the prize dialog also wasn't working, it is now.

puwexil

2011-12-18 09:20:37 pm

Professional Second Banana

Awesome - glad it was a quick fix.