FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » IP Browser
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
IP Browser [message #36295] Wed, 14 March 2007 12:12 Go to next message
JanRei is currently offline  JanRei   Germany
Messages: 361
Registered: October 2005
Location: Germany
Karma: 0
Senior Member
Contributing Core Developer
Translator
add to buddy list
ignore all messages by this user
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
Re: IP Browser [message #36350 is a reply to message #36295] Sun, 18 March 2007 14:17 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Fixed in CVS, thanks.

FUDforum Core Developer
Re: IP Browser [message #36362 is a reply to message #36295] Mon, 19 March 2007 17:25 Go to previous messageGo to next message
JanRei is currently offline  JanRei   Germany
Messages: 361
Registered: October 2005
Location: Germany
Karma: 0
Senior Member
Contributing Core Developer
Translator
add to buddy list
ignore all messages by this user
Did you have a look at the second issue I described?
Re: IP Browser [message #36370 is a reply to message #36362] Mon, 19 March 2007 19:20 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
This is also fixed.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Potential security hole, Anon user allowed in by clicking a referal link
Next Topic: error when import chinese newsgroup
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 18 04:09:42 EST 2017

Total time taken to generate the page: 0.00690 seconds