Petition Details and Chat
Petition ID 24: Kick Players list contains players in other Places
Submitted Wed, 19 Oct 11 22:10:45 +0000
What:
Owner is offered the option to kick out players who are actually in a different Place. This occurs in places with one- and two-digit place ids. Example - placeid 67 shows players who are in place 677.
Fix: (yes, I actually have one for this!)
The problem is with the LIKE clause in the SELECT statement. Underscore '_' is a metacharacter for SQL LIKE, meaning
any character. It needs to be escaped with a backslash '\'.
It's the second underscore that works the mischief, but you might as well escape both of them.
Back to the List of PetitionsYou have to be logged in to chat.