@thetoon suggested back on 28th March 2014 (on page 2 of this thread) that Python 2.7 works and they had no need to change colors.txt; and spillz suggested on 29th April 2014 that it "Should work with both python 2 and 3."
But since then things seem to have changed, or maybe this never got tested with SQL databases.
Anyway, I have Python 2.7. To get it to work, I had to make one small change. Find "
return BytesIO(r[0])" and change it to "
return BytesIO(bytes(r[0]))".
I also removed the back-quotes from the SQL queries (like "
SELECT `pos` FROM `blocks`") because I couldn't find anything online to explain why there should be back-quotes in an SQL query within Python. (EDIT: I searched again and
found this: using the back-quotes protects against problems if a future version of SQL defines "
pos" or "
blocks" as a built-in reserved keyword. However, they are
not ANSI-SQL compliant. I choose compliance and remove the back-quotes.)
Finally, I added about 80 or 90 lines to my colors.txt which still needs some tweaking (e.g. sandstone is still wrong but I made it better).
Example output (in a spoiler because it is big)
[center]
[/center]
Yes the terrain is old, because I'm stuck with 0.4.11 on a Mac that is stuck with MacOS 10.6.
- Robert Munafo