TouchingVirus
04-07-2004, 05:26 PM
I have gotten the IP to country Database, and im writing a half-reversal of it. It is designed to take a users IP and output the country, i want to select the country from the dropdown list and output all ranges within the country...
I am using this php code below with some success..
<?
// ################ GET BACKEND #####################
require_once('./global.php');
// ################ GET PERMISSIONS #####################
if (!($permissions['forumpermissions'] & CANVIEW))
{
print_no_permission();
}
// ################## EVAL VARIABLES ##################
eval('$country_select = ("' . fetch_template('country_select') . '");');
eval('$navbar = "' . fetch_template('navbar') . '";');
// ############ Do FORM & Submit buttons ###############
$start_form = '<form action="ip.php" method="post" target="_blank">' . $country_select . '';
$submit_country = '<INPUT type="submit" name="submit" value="Search"><INPUT type="reset"></FORM>';
// Query...
if (isset($_POST[submit]))
{
$cc = $_POST['country'];
$query = $DB_site->query("SELECT * FROM ip_to_country WHERE COUNTRY_CODE2='$cc'");
$number_rows = mysql_num_rows($query);
for ($i=0; $i < $number_rows; $i++)
{
$row = mysql_fetch_array($query);
$ip_from = long2ip($row[IP_FROM]);
$ip_to = long2ip($row[IP_TO]);
$country = $row[COUNTRY_NAME];
echo "$ip_from - $ip_to\r\n";
}
eval('print_output("' . fetch_template('country_results') . '");');
}
// ############# HTML OUT... ##############
eval('print_output("' . fetch_template('country_pick') . '");');
?>
The problem is that it doesnt work completely as planned..
I left the echo statement to see the REAL ranges that the country has, which in the case of the US is like 5000 rows of results, the above code however only prints out the last range...
The echo statement prints all out, but the actual vbulletin output is only the last range or the last value for $ip_to and $ip_from..and idea how to make it work like i planned?
Of course i dont want 5000 rows on a single page, i would also hope to include the vbulletin pagesplit facility too..so that it splits per every x rows returned...
I am using this php code below with some success..
<?
// ################ GET BACKEND #####################
require_once('./global.php');
// ################ GET PERMISSIONS #####################
if (!($permissions['forumpermissions'] & CANVIEW))
{
print_no_permission();
}
// ################## EVAL VARIABLES ##################
eval('$country_select = ("' . fetch_template('country_select') . '");');
eval('$navbar = "' . fetch_template('navbar') . '";');
// ############ Do FORM & Submit buttons ###############
$start_form = '<form action="ip.php" method="post" target="_blank">' . $country_select . '';
$submit_country = '<INPUT type="submit" name="submit" value="Search"><INPUT type="reset"></FORM>';
// Query...
if (isset($_POST[submit]))
{
$cc = $_POST['country'];
$query = $DB_site->query("SELECT * FROM ip_to_country WHERE COUNTRY_CODE2='$cc'");
$number_rows = mysql_num_rows($query);
for ($i=0; $i < $number_rows; $i++)
{
$row = mysql_fetch_array($query);
$ip_from = long2ip($row[IP_FROM]);
$ip_to = long2ip($row[IP_TO]);
$country = $row[COUNTRY_NAME];
echo "$ip_from - $ip_to\r\n";
}
eval('print_output("' . fetch_template('country_results') . '");');
}
// ############# HTML OUT... ##############
eval('print_output("' . fetch_template('country_pick') . '");');
?>
The problem is that it doesnt work completely as planned..
I left the echo statement to see the REAL ranges that the country has, which in the case of the US is like 5000 rows of results, the above code however only prints out the last range...
The echo statement prints all out, but the actual vbulletin output is only the last range or the last value for $ip_to and $ip_from..and idea how to make it work like i planned?
Of course i dont want 5000 rows on a single page, i would also hope to include the vbulletin pagesplit facility too..so that it splits per every x rows returned...