Follow-up Comment #9, patch #3743 (project freeciv): The current implementation of delegations is case-sensitive with regard to usernames. That is, if user "A" delegates his nation to user "B", "b" wouldn't be able to take the delegation from "A".
In Greatturn, games last for months and usernames can be somewhat long and complicated; sometimes users log-in typing their nicks w/o paying attention to case, and then they wonder why delegations stop working. AFAIK, the whole structure of Freeciv is built to be case insensitive for usernames, so this patch, which comes from Longturn, is somewhat inconsistent. Moreover, Longturn solves this issue - for its sole benefit - by using the following custom code to internally handle delegations in interactions with DB: SELECT delegation FROM auth_user AS u JOIN game_joined j ON (u.id = j.user_id) JOIN player_player p ON p.id = j.user_id WHERE lower(username) = lower('$USER') AND game_id = '$GAMENAME'; I think this patch should be made consistent with the rest of Freeciv, by treating usernames case-insensitively. _______________________________________________________ Reply to this item at: <http://gna.org/patch/?3743> _______________________________________________ Message sent via/by Gna! http://gna.org/ _______________________________________________ Freeciv-dev mailing list Freecivemail@example.com https://mail.gna.org/listinfo/freeciv-dev