vb.org Archive
Page 18 of 46 « First 81617 18 192028 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Vbulletin World Map System (https://vborg.vbsupport.ru/showthread.php?t=109819)

ConqSoft 03-15-2006 12:18 PM
It could be changed to fall back to their Registration IP I suppose. Not sure how it would affect performance to do two searches though.

headrat 03-15-2006 12:23 PM
actually, I don't want it to do both, I only have one map showing
Just want to pull from the registration IPs, any idea as to how to code that and where?

headrat 03-15-2006 12:48 PM
Oops, and what php are you pulling from, I can't seem to find that one.

headrat 03-15-2006 01:07 PM
Quote:
Originally Posted by Trigunflame
PHP Code:
"SELECT post.ipaddress " .
"FROM " . TABLE_PREFIX . "post AS post, " . 
TABLE_PREFIX . "user AS user " .
"WHERE user.userid = post.userid " .
"AND user.lastpost = post.dateline" 
Its pulling up all of your members who have posted.
Is there a
Code:
"SELECT register.ipaddress"
I could use or something?

gavinzac 03-15-2006 01:07 PM
Quote:
Originally Posted by Trigunflame
People should already have a location field per vbulletin default.

While this system could be setup to automatically insert information into that profile field it probably wouldnt be a good idea; the GEOIP city lite database while being the best 'free' IP database is still not very accurate in terms of hitting your city direct on.

So you would most likely have profiles with many false positives; the map was created to be a 'general' observation of where your members/guest are scattered throughout the world.
yeah, i understand, i suppose what i'm looking for is a city - based version of the exisiting GEOIP Country Targeting. it would be extremely cool and allow for lots of new mods such as location determined forums, ads, language selection etc.

i know, i know, go ask in the other thread ;) its just that i've tried to do this myself by editing that code and it didnt quite work. im a jsp expert, not php :(

headrat 03-15-2006 03:25 PM
anyone got anything on this and getting ALL the REGISTERED IPs to by shown?

ConqSoft 03-15-2006 03:34 PM
To have it plot ALL registered members, and not just those that have posted, do this:

In class_wmp.php, change this:
Code:
                "SELECT post.ipaddress " .
                "FROM " . TABLE_PREFIX . "post AS post, " .
                TABLE_PREFIX . "user AS user " .
                "WHERE user.userid = post.userid " .
                "AND user.lastpost = post.dateline"
To this:
Code:
                "SELECT ipaddress " .
                "FROM " . TABLE_PREFIX . "user"
It would be better to have it use their latest post IP if available, then fall back to their registration IP if they have never posted, but I haven't gotten around to trying to do that yet... Maybe the hack author will. ;)

headrat 03-15-2006 04:04 PM
I think that did it, it at least put MORE on there.

ConqSoft 03-15-2006 04:13 PM
Yeah, I have 5200 members who haven't posted, so switching to the Registration IP filled the map in even more.

I guess it depends on if you want to show all members, or only those members who participate.

Also, their Registration IP never changes, so if they move to a new location, their location on the map will remain the same. If you get the IP from their last post, it will always get their latest location.

There should be a way to combine the two and use the Registration IP if they have 0 posts. I may play around with it, unless the hack author wants to.... :D

srpompon 03-15-2006 05:01 PM
Quote:
Originally Posted by Trigunflame
Maybe upload all the files first?

I put all the files, and show the error...

:confused:


Thanks,

Ivan


All times are GMT. The time now is 05:04 PM.
Page 18 of 46 « First 81617 18 192028 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01420 seconds
  • Memory Usage 1,745KB
  • 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
  • (3)bbcode_code_printable
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete