492 scouting program released under OS license

[Ethulin]

Team 492 has made the decision too release their scouting app talked about in this post (http://www.chiefdelphi.com/forums/showthread.php?t=36356).

Here is the URL.
http://trc.freedomdown.net/492_scouting_appv1.zip [14kb]

Please keep the discussion positive.

If you are having trouble installing please READ THE README first, then post.

Also, you NEED to review the license, it has some important things in it. If people do not abide by it we will not really have any incentive to release more versions.

If you see any problems please post them here. The version released ran fine, and I believe I got all the files when I packaged it, but there is always a possibility for error.

Go 492!

[Mike]

JW, what license are you using? I'm planning on releasing a few things as open source projects and am still looking at licenses. I like the Mozilla Public License myself.

[Ethulin]

JW, what license are you using? I'm planning on releasing a few things as open source projects and am still looking at licenses. I like the Mozilla Public License myself.

Well we kinda created our own. We based it off another, but here is the full text.

Attribution and Reciprocation Assurance License

The non-commercial redistribution and use of this software, with or without
modification, are permitted provided that the conditions below are met.

Attribution:
The first condition that shall be met is attribution to the original author
(.The Author.), and to any organization(s) related to the development of the
software that The Author wishes to recognize (.The Author.s Organizations.).
The Author and The Author.s Organizations hope that the promotional value of
this fair attribution may help justify the cost in otherwise billable time and
any other possible forfeited advantages of releasing this software publicly.
Attribution may be any mechanism that enables a user of the software to, from
any screen, identify The Author and The Author.s Organizations unambiguously.
Proper attribution shall also include a hyperlink to a location as directed by
The author.

Reciprocation:
Furthermore, any changes to the software shall be immediately communicated back
to The Author and The Author.s Organizations. The modified software shall be made
available, immediately upon request, to The Author and The Author.s Organizations.
Any questions that The Author or The Author.s Organizations have concerning any
aspect of the modification shall receive priority responses.


Disclaimer:
THIS FREE SOFTWARE IS PROVIDED BY THE AUTHOR "AS IS" AND ANY EXPRESS OR IMPLIED
WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO
EVENT SHALL THE AUTHOR OR ANY CONTRIBUTOR BE LIABLE FOR ANY DIRECT, INDIRECT,
INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
LIMITED TO, EFFECTS OF UNAUTHORIZED OR MALICIOUS NETWORK ACCESS; PROCUREMENT OF
SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING
IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY
OF SUCH DAMAGE.

You must receive express written permission from The Author to use this software
in any fashion not expressly permitted by this license agreement.

[PCole]

I tried to use phpMy Admin and it gave me the following error:

#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 'DEFAULT CHARSET=latin1' at line 8

I was wondering is there something I did wrong somewhere or am I not configured correctly?

[gobeavs]

I tried to use phpMy Admin and it gave me the following error:



I was wondering is there something I did wrong somewhere or am I not configured correctly?

I got that also. I just deleted that part :D. I did a google search, and a lot of people have had problems similar to that...one solution I saw was to dump some stuff and reimport it, but it sounded to complicated for me ;)

[RyanMcE]

I got that also. I just deleted that part :D. I did a google search, and a lot of people have had problems similar to that...one solution I saw was to dump some stuff and reimport it, but it sounded to complicated for me ;)

My guess would be that you have non-internationalized installations of MySQL, so that just deleting the 'DEFAULT CHARSET=latin1' part of the query and resubmitting it will work just fine.

Erik, probably best to take that part out of the instructions because it seems to be causing some issues.

[PCole]

I've run into some problems uploading it to our website.. I was wondering if there is any way to fix this?

On the match_info.php Page
Warning: array_keys(): Warning: array_keys(): The first argument should be an array in /home/sparky/public_html/scout05/mi_display.php on line 10

Warning: Invalid argument supplied for foreach() in /home/sparky/public_html/scout05/mi_display.php on line 10

Warning: Invalid argument supplied for foreach() in /home/sparky/public_html/scout05/mi_display.php on line 17


On the mi_add.php Page
Warning: mysql_query(): Access denied for user: 'sparky@localhost' (Using password: NO) in /home/sparky/public_html/scout05/mi_add.php on line 3

Warning: mysql_query(): A link to the server could not be established in /home/sparky/public_html/scout05/mi_add.php on line 3

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sparky/public_html/scout05/mi_add.php on line 4

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/sparky/public_html/scout05/mi_add.php on line 6


Those are just a few examples of problems I am encountering.. is there anyway to fix this?

[DarkJedi613]

Looks like your SQL username isn't properly configured. 'sparky@localhost' is being denied access to the SQL database - you're using no password ("(Using password: NO)"), so my guess would be is that you need one...and if you don't actually use a password I'd HIGHLY suggest you do. :)

That could be causing all the other errors, or possibly not - I don't know, I didn't write the code. ;)

[Ryan M.]

I got that also. I just deleted that part :D. I did a google search, and a lot of people have had problems similar to that...one solution I saw was to dump some stuff and reimport it, but it sounded to complicated for me ;)You came up with the correct solution to the problem. This error comes from older versions on MySQL which didn't specify character sets the same way. Since they default to latin1, it doesn't matter. :)

[Ethulin]

My guess would be that you have non-internationalized installations of MySQL, so that just deleting the 'DEFAULT CHARSET=latin1' part of the query and resubmitting it will work just fine.

Erik, probably best to take that part out of the instructions because it seems to be causing some issues.

Lol, I know this is late, but I somehow just read the second part of your post.

Which part are you suggesting I take out again?

[PCole]

I still have not figured it out.. I have checked my phpAdmin databases and users. I created the database titled scout05 and created a user sparky that uses the database scout05 and gave it a password.

I edited the connect.php to those instructions:

$user: sparky
$database: scout05
$password: entered the password
$data: scout05

is there anything i'm doing wrong here?

Please help, thanks.