To change the collation execute this SQL query:
Code:
ALTER TABLE `tournaments` CHANGE `champion` `champion` TEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
Execute it from within vBulletin to make sure it goes correctly
I have just noticed that no highscores save either!? It just says: Could not retrieve scores.
Any ideas on this?
EDIT: I just added the whole vba cmps thing (i had it installed) so i modded my file. Now it works but i still get the error. Note: I am playing snake. I have not tested other games YET.