Frets on Fire Score Chart - Personal Frets on Fire Score Chart

[Yoshi]

Delete "import MySQLdb as sql" and then use:

buildDatabase.py -f fofdatabase.sql

[m0nkiii]

Now I get this, hehe

Code: Select all

Traceback (most recent call last):
  File "F:\Spel\FretsOnFire-1.1.324-win32\FretsOnFire\buildDatabase.py", line 17
0, in <module>
    main()
  File "F:\Spel\FretsOnFire-1.1.324-win32\FretsOnFire\buildDatabase.py", line 16
5, in main
    importSongs(os.path.abspath("."))
  File "F:\Spel\FretsOnFire-1.1.324-win32\FretsOnFire\buildDatabase.py", line 50
, in importSongs
    if not hash == "":
UnboundLocalError: local variable 'hash' referenced before assignment

[Yoshi]

I've got no problems.

[ernasty10050]

Definitely have to go with Divra's seeing as he's got the GH2 songs.

[Divra]

Now I get this, hehe

Code: Select all

Traceback (most recent call last):
  File "F:\Spel\FretsOnFire-1.1.324-win32\FretsOnFire\buildDatabase.py", line 17
0, in <module>
    main()
  File "F:\Spel\FretsOnFire-1.1.324-win32\FretsOnFire\buildDatabase.py", line 16
5, in main
    importSongs(os.path.abspath("."))
  File "F:\Spel\FretsOnFire-1.1.324-win32\FretsOnFire\buildDatabase.py", line 50
, in importSongs
    if not hash == "":
UnboundLocalError: local variable 'hash' referenced before assignment

I seem to remember something like that, but I can't find any change I made that would have fixed it... This is my (pretty ugly) version of it, it scans folders too, but only if they start with a '='

[sneftrup]

Hmm okay, not sure what is causing that, but I'll try looking at it.

[sneftrup]

Line 17 is in the initial comment... did you put in a character by a mistake ? not sure if python would like that... but that probably isn't it

[m0nkiii]

I got it to work with Divras script. I had some folders with no song.ini in. It might have been because of that if failed.

And it was not 17 it was 170

[sneftrup]

Um, I just looked at the again, and it's pretty bad. I'm sure I've done something wrong that is making it die, I'm gonna work on it right now. I'll let you know when I have something done.

[m0nkiii]

Hmm, shouldnt the script generate the table to put the songs in too ?

[Divra]

I believe it does, if run with the -init parameter...

[m0nkiii]

I couldnt run the script with the line:
"import MySQLdb as sql"

I thought -f generate that code too

[sneftrup]

Ok, I added a bit of error handling to the script, probably should have done that from the start, but it was just meant as a project for myself Anyway, www.sneftrup.net/buildDatabase.py if you want it, maybe that can solve your problem. I'm not going to post anything to sourceforge until it reads scores and subfolders.

[m0nkiii]

Woohoo!!!
I've made it

Spanks for the help

http://m0nkiii.apakossa.org/index.php?action=frets
Don't you also like pink

[sneftrup]

Ok, I've added support for sub folders and added a score uploading script. Get it at sourceforge