Revision: 2145
http://astpp.svn.sourceforge.net/astpp/?rev=2145&view=rev
Author: darrenkw
Date: 2007-11-01 20:48:23 -0700 (Thu, 01 Nov 2007)
Log Message:
-----------
A tentative fix for the IP mapping problems.
Modified Paths:
--------------
trunk/astpp-ip-map.agi
Modified: trunk/astpp-ip-map.agi
===================================================================
--- trunk/astpp-ip-map.agi 2007-11-02 03:41:50 UTC (rev 2144)
+++ trunk/astpp-ip-map.agi 2007-11-02 03:48:23 UTC (rev 2145)
@@ -48,8 +48,13 @@
sub get_ip() {
my ($number,$extension) = @_;
my ($sql,$tmp);
- $tmp = "SELECT * FROM ip_map WHERE ip = " . $astpp_db->quote($number)
- . " AND prefix IS NULL OR $extension RLIKE prefix ORDER BY LENGTH(prefix) DESC LIMIT 1";
+ $tmp = "SELECT * FROM ip_map WHERE ip = " . $astpp_db->quote($number);
+
+##### I know I wrote it with the OR statement for some reason but I can't figure out why. I'm leaving it here for now.
+# $tmp = "SELECT * FROM ip_map WHERE ip = " . $astpp_db->quote($number)
+# . " AND prefix IS NULL OR $extension RLIKE prefix ORDER BY LENGTH(prefix) DESC LIMIT 1";
+###########
+
print STDERR $tmp if $config->{debug} == 1;
$AGI->verbose( "$tmp\n", $verbose ) if $config->{debug} == 1;
$sql =
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
