Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2004, 05:26 PM
TouchingVirus's Avatar
TouchingVirus TouchingVirus is offline
 
Join Date: Nov 2001
Location: Bogland
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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...
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:51 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06962 seconds
  • Memory Usage 2,202KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete