The Arcive of Official vBulletin Modifications Site.

defi · #1 12-31-2004, 03:43 AM

It would be great if, when a user supplied their zip code in an extra profile field, the zip code could be translated into the actual city and state of that area which would be displayed in the user's profile page.

SFishy · #2 12-31-2004, 04:31 AM

Quote:

Originally Posted by defi

It would be great if, when a user supplied their zip code in an extra profile field, the zip code could be translated into the actual city and state of that area which would be displayed in the user's profile page.

I'm not expert on databases, but I think you'd need another database table for that... one that stores zip codes and it's corresponding city and state.

Or you'll need one of those longitude/latitude programs/databases that figures it out.

Someone might have either already, but I would imagine they are pretty expensive to buy.

tnguy3n · #3 12-31-2004, 02:24 PM

if someone could provide all zipcodes of cities in the US, that would make it easier.

amykhar · #4 12-31-2004, 03:21 PM

<a href="http://www.usps.com/webtools/address.htm" target="_blank">http://www.usps.com/webtools/address.htm</a>

SFishy · #5 12-31-2004, 03:23 PM

You do know there are like 44,000 zip codes in the US? :nervous:
It also changes A LOT monthly. I only know because we have a database like this at my job, and changes are CONSTANT (they have 4-person department that manages this).

amykhar · #6 12-31-2004, 03:41 PM

The link I posted is an API provided by the post office, which I must assume updates their database regularly

Depending on how many people register on your site daily, it wouldn't be a huge problem to hit some other database to get the info for the city and then store the city in the database.

But my question is this: Why not just have the user enter their city? They know what city they live in.

Amy

noppid · #7 12-31-2004, 07:09 PM

If I joined a site and found they used my info to provide more info about me I'd be annoyed.

I'm wondering the point of this and how it would affect privacy issues? I mean even if a savey person could find out on their own, would users appreciate this and shouldn't the use of such things be op in and clearly stated in policies?

Just curious.

T3MEDIA · #8 01-04-2005, 05:10 PM

this is forum software. I join sites that ask for my address.
you can ask for anything you want.
no law in asking questions

paul1972 · #9 08-17-2011, 12:56 AM

any luck finding this zip code program?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04063 seconds Memory Usage 2,231KB 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)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (9)post_thanks_box (9)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (9)post_thanks_postbit_info (9)postbit (9)postbit_onlinestatus (9)postbit_wrapper (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_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 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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!