| IP Browser [message #36295] |
Wed, 14 March 2007 16:12  |
JanRei
Messages: 361
Registered: October 2005
Location: Germany
Karma: 0
|
Senior Member
Contributing Core Developer
Translator |
|
|
When I enter an IP that ends with a ., I get query error:
| Quote: |
(C:\xampp\htdocs\forum\index.php:80
C:\xampp\htdocs\forum\theme\default\ip.php:134
C:\xampp\htdocs\forum\index.php:1194
) 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query: SELECT reg_ip, alias FROM fud26_users WHERE reg_ip=
_GET: array ( 't' => 'ip', 'ip' => '0.', )
_POST: array ( 'S' => '8fe81c7e7e26b2b847fc6d646c53354e', 'SQ' => '1b139c83267556b8372aa0a6854fb4ef', 'ip' => '0.', )
Server Version: 5.0.33
[Referring Page] http://localhost/forum/index.php?t=ip
|
After a short look at the code I think this is because of the usage of $_GET['ip'] in line 97 of ip.php.t, on replacement with $ip it seems to work.
I think there is also another small strange behaviour which seems only to occur if I look up registration IPs. On the left of the page there is a list of users who have registered using this IP. The usernames are links which should probably point to the profile of the users, but the links don't work. I think this is because the URLs contain the IP instead of the user id:
http://localhost/forum/index.php?t=usrinfo&id=0.0.0.0&S=8fe81c7e7e2 6b2b847fc6d646c53354e
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]