vb.org Archive - Reversed IP -> Country

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..

PHP Code:


		
			
<?

// ################  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...

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00954 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: