Prosper202 Tracking202 Export202 WorldProxy202 Meetup202 | Blog Forum Newsletter Twitter | Advertise
Login · Register
Home About Docs Scripts Blog Forums Hosting Donate Download

geolocation stats

Post new topic Reply to topic Prosper202 Forum Index » Prosper202 Self-Hosted-Apps
New Posts Search Forum
Author Message
popa202


Joined: Jul 7th, 2008
Posts: 45

Post Posted: Aug 10th, 2008 at 9:35pm Post subject: geolocation stats Reply with quote

Hi,

Didn't find geolocation stats inside prosper... Was really surprised (I was kinda excited when started using prosper and it seemed to be able to do anything I need - I kinda assumed geolocation would totally be there).

Are you gonna put it back in?

If not, is there any bypass (hook/plugin/customization) - REALLY NEEDED!!!

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 2237

Post Posted: Aug 11th, 2008 at 11:18am Post subject: Re: geolocation stats Reply with quote

We can try to fit it in, but it may be difficult, how familiar are you with PHPMYADMIN, and uploading large .csv imports, the file is massive which is why it was taken, out, if at the bare min. would the country's work.

Back to top
itjgray


Joined: May 23rd, 2008
Posts: 11

Post Posted: Aug 11th, 2008 at 11:38am Post subject: Re: geolocation stats Reply with quote

I'll second this request - please post it as a SQL or CSV file. We can then upload using PHPMyAdmin or SQLYog.

Back to top
popa202


Joined: Jul 7th, 2008
Posts: 45

Post Posted: Aug 11th, 2008 at 11:54am Post subject: Re: geolocation stats Reply with quote

T202Wes wrote:
We can try to fit it in, but it may be difficult, how familiar are you with PHPMYADMIN, and uploading large .csv imports, the file is massive which is why it was taken, out, if at the bare min. would the country's work.

Hi Wes,

I didn't really understand which file you mean...

But I can manage PHPMYADMIN, and I'd love to learn a way to get geo stats manually.

Thanks!

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 2237

Post Posted: Aug 12th, 2008 at 4:06am Post subject: Re: geolocation stats Reply with quote

just marked it in my notes, I'm going to see if you guys can upload a .csv to your MYSQL, will send it tommorow.

Back to top
popa202


Joined: Jul 7th, 2008
Posts: 45

Post Posted: Aug 12th, 2008 at 4:33am Post subject: Re: geolocation stats Reply with quote

thanks!

ps enjoy ASE :)

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 2237

Post Posted: Aug 14th, 2008 at 5:49pm Post subject: Re: geolocation stats Reply with quote

working on getting it over to you guys right now.

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 2237

Post Posted: Aug 14th, 2008 at 7:51pm Post subject: Re: geolocation stats Reply with quote

Ok guys,

This is a large MYSQL Table(s) of all the GEO location Ips, I'm just going to see if you guys can even upload it. Manually yourselfs, the reason its not in their, because I can't upload this large of a file from the web-based installer. but see if you can manually install it.

http://www.wesmahler.com/downloads/tracking202.sql.bz2

Back to top
popa202


Joined: Jul 7th, 2008
Posts: 45

Post Posted: Aug 17th, 2008 at 6:27am Post subject: Re: geolocation stats Reply with quote

thanks wes

u mean just upload these tables to the db?

what will happen then? will i need to manually change some code/settings/other?

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 2237

Post Posted: Aug 17th, 2008 at 3:37pm Post subject: Re: geolocation stats Reply with quote

popa202 wrote:
thanks wes

u mean just upload these tables to the db?

what will happen then? will i need to manually change some code/settings/other?

I just want to see if your able to upload the tables at all, because its not really easy to do. If you can we can configure an install to work with the geoip location.

Back to top
icomunik
Website MSN


Joined: Feb 7th, 2008
Posts: 27

Post Posted: Aug 24th, 2008 at 11:14am Post subject: Re: geolocation stats Reply with quote

Hey Wes,

It is possible to upload the file, however some myPHPadmin tweaks are necessary, like increase the maximum .zip file. For those that own a dedicated server, it is a simple task. Not sure for people on shared boxes.

Maybe you could add the geo targeting option on a "special" version for users that can upload the file to the database.

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 2237

Post Posted: Aug 24th, 2008 at 3:49pm Post subject: Re: geolocation stats Reply with quote

icomunik wrote:
Hey Wes,

It is possible to upload the file, however some myPHPadmin tweaks are necessary, like increase the maximum .zip file. For those that own a dedicated server, it is a simple task. Not sure for people on shared boxes.

Maybe you could add the geo targeting option on a "special" version for users that can upload the file to the database.

Yeah it is difficult, well you are the first person to successfully install the database, so next update I'l put it in. As an additional package, go head and change the TABLES to have the 202_ prefix at the beginning of them, like the rest of the MYSLQ tables.

Back to top
stack


Joined: Jun 27th, 2008
Posts: 3

Post Posted: Oct 5th, 2008 at 9:13pm Post subject: Re: geolocation stats Reply with quote

has this feature been included now? Do I just install the DB and it functions? (just asking since it seems like it will be pretty big DB to import)

Back to top
T202Wes
Website Email Twitter Facebook AIM


Joined: Oct 20th, 2007
Posts: 2237

Post Posted: Oct 6th, 2008 at 10:05pm Post subject: Re: geolocation stats Reply with quote

stack wrote:
has this feature been included now? Do I just install the DB and it functions? (just asking since it seems like it will be pretty big DB to import)

You would have to be able to upload the database, as it is pretty big your right, so that is why its not included in the regular version.

No its not included yet, on next release plan on introducing it.

Back to top
Post new topic Reply to topic Page 1 of 1