IFPA Mobile App, Available on Android and iOS - Community Discussion, bug reporting, etc

So I’m using Xamarin.Forms which uses iOS / Android native elements. So iOS I know has a built in font adjust feature for the whole phone. If you adjust that, it should adjust this app.

1 Like

Got some more work on this done last night and on my lunch break.

Loving this!! When is beta testing?

1 Like

Awesome stuff.

I had started working on a cross platform app myself (Xamarin, C#), but I fell at the first hurdle when I realised the IFPA API had a bunch of issues in it, such as trying to query tournaments that have an apostrophe in the name fail. (and incidentally, that probably means there are sql injection issues that would be worth fixing before someone goes all Bobby tables on the database… (https://xkcd.com/327/)

Are you using the rest api, or do you have an online cache?

I was planning to let the user select which regions they wanted to be notified of new or upcoming tournaments in. As Cayle said, that isn’t just your current location though. Could include regions you’re planning to travel to, or neighbouring states (or countries for those of us in Europe).

1 Like

I’m using the REST API. I wrote a wrapper for it in C# last year, .NET standard so it can be consumed via Xamarin, which is what I’m using (Xamarin Forms)

If I find flaws in the API I’ll let josh know, but my wrapper library should be resilient in the face of that; if its not I’ll patch it until it is.

I won’t be using any sort of SQL database at the moment so I’m not worried about injection attacks.

1 Like

No the issue is trying to query via the REST API on tournaments that use a ’ in the name. Such as this one for example:

https://www.ifpapinball.com/tournaments/view.php?t=27698#

The REST API returns errors that very much indicate that the IFPA API is susceptible to sql injection attacks.

https://api.ifpapinball.com/v1/calendar/27698?api_key={{key}}

Returns:
{“error”:{“text”:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Frenzy’ order by event_end_dt’ at line 1}}

Edit: Looks like API queries are sanitized for sql injection, so I guess as long as @PressStart doesn’t accept a tournament named like "My Tournament’); UPDATE Player SET Rank=9999 WHERE Name Like ‘%Sharpe’;-- … we should be ok :smile:

2 Likes

To add to Cayle’s point, one problem I personally have living in upstate New York is I am within ~170 miles of Toronto and Ottawa, but also Buffalo and Middletown. The miles feature on the IFPA map draws a straight line from Syracuse to these places, because it doesnt know about bodies or water or international borders, or highways that dont travel in a straight line. Changing my location to Ithaca or Penn Yan or Norwich usually does the trick. So if you cannot control the ifpa data flowing into the app, it would be useful for me to switch my location when using. This option would be useful for people going on vacations or traveling for work as well.
Thanks again for having the initiative to start this project, as well as the courtesy to ask for public input.

Looking great! Is this with the feature of using a different location? Cannot tell by the screengrab

Yeah, although its not based on city/address, i just mocked it up quick with zipcode. but if you punch in a different zipcode it moves the map and reloads the tournies.

1 Like

I just want to be able to see Bowen Kerins profile now that he unsuppressed himself, lol…

Zipcodes are easy to lookup/remember. Keep up the good work!

Ok, so this is very feature light right now, and I’ve got lots of good changes in the pipeline, but i wanted to put this on the store even in its skeletal state just to get it out there. It’s my first app, I’m very proud even though its bare bones. iOS only for now. It’s written cross platform but I wanted to really button up the iOS app first then push the android one out there after I’m comfortable w/ it

IFPA Companion by Ed Giardina https://itunes.apple.com/us/app/ifpa-companion/id1441736303?mt=8

If you are gonna submit feedback, please do so here:

Next features:
Clean up the calendar / future tournaments page
Player search
NOTIFICATIONS (this is a big one, I will likely need more than a week to hash that out)

Lots more. Thanks for checking it out!

2 Likes

Nifty!

App is now at 1.0.3 and contains player search by name

2 Likes

Version 1.0.4 is now available in the iOS App Store

Enhanced Calendar page design shows more map and results.
PVP Page has a new design and tapping through on a PVP item now brings up a PVP detail page.
Added a jumplist to PVP details page.
Use the Star to select your profile instead of manual IFPA lookup.
Added user refresh toolbar item to the Player Details page.

2 Likes

I checked events out using the calendar. When I click on some of the events for details, it shows nothing but a box. Others work fine. See screenshot.

Can you please tell me what tourney this was? Or screenshot the previous screen and circle the one that errored when you tapped through?

Just a few examples.


1 Like

All the tournies with apostrophes in the name.

1 Like

Yeah I am willing to bet that’s an apostrophe issue; probably a bug in the IFPA API. Will look more into it this evening.

Lol, that’s exactly the issue I spoke about a few posts ago. Have spoken to Brian recently about it and I think it’s resolved now.