First GEO TARGET FREE HOSTED GALLERIES from Legendary Lars

**webgurl** · 12-29-2004, 11:39 AM

GEO TARGET Hosted Galleries !
That's totally awesome

**LA Mike** · 12-29-2004, 11:40 AM

Originally posted by webgurl

GEO TARGET Hosted Galleries !
That's totally awesome

Good stuff Lars

**Varius** · 12-29-2004, 11:41 AM

Might just be me, but seems quite slowwwwwwwwwwww.....

You may want to look at your GeoIP database query / table structure

**Xenophage** · 12-29-2004, 11:41 AM

Originally posted by LAMike

Good stuff Lars

thanks mike see ya at the show

**TheFrog** · 12-29-2004, 11:42 AM

great news these should really convert for you

**Xenophage** · 12-29-2004, 11:42 AM

Originally posted by Varius

Might just be me, but seems quite slowwwwwwwwwwww.....

You may want to look at your GeoIP database query / table structure

actually I think its a not being hit and cached issue. I am loading all these galleries up into our tgps sop they should speed up a lot soon.

**Manowar** · 12-29-2004, 11:43 AM

lars is unstoppable!

**ERIC-GAMMA** · 12-29-2004, 11:46 AM

Always coming with new ideas Lars!

And to think that last year I remember you telling me you were thinking of retiring... LOL

looking forward to seeing you in Vegas bud!

**Paraskass** · 12-29-2004, 11:47 AM

Fix your geo tracker.

I am in Quebec province, about 150 miles from Montreal, and it says meet hot girls in Montreal. I am 2 minutes from Ottawa.

FIX IT.

**Xenophage** · 12-29-2004, 11:49 AM

Originally posted by Paraskass

Fix your geo tracker.

I am in Quebec province, about 150 miles from Montreal, and it says meet hot girls in Montreal. I am 2 minutes from Ottawa.

FIX IT.

I am making a fuckpile of money off of geo ads are you ?

**Crypt** · 12-29-2004, 11:50 AM

Originally posted by Paraskass

Fix your geo tracker.

I am in Quebec province, about 150 miles from Montreal, and it says meet hot girls in Montreal. I am 2 minutes from Ottawa.

FIX IT.

This database dont index a city when 90% of ppl are farmer

**Furious_Male** · 12-29-2004, 11:51 AM

Nice. Do you have a link to randomly generate these galleries?

**Varius** · 12-29-2004, 11:52 AM

Originally posted by LegendaryLars

actually I think its a not being hit and cached issue. I am loading all these galleries up into our tgps sop they should speed up a lot soon.

Ahh, gotcha.

Just incase though, if you are not already doing so, you can store the low-high range for the city as integer and use this formula to get the user's IP in that format for quick query speed :

$ip = $_SERVER[REMOTE_ADDR];
$ip = split("\.",$ip);
$ip = (16777216 * $ip[0]) + (65536 * $ip[1]) + (256 * $ip[2]) + $ip[3];

This (in PHP) would make $ip a nice int you can use like so:

$sql = "SELECT city_id FROM city_ip WHERE $ip > city_ip_low AND $ip < city_ip_high";

If you use a high enough version of MySQL or Oracle, you could also save the above as a stored function/procedure for maximum speed

**Corleone** · 12-29-2004, 11:54 AM

thats really cool . the area in the link is only 20 miles away

**Paraskass** · 12-29-2004, 11:56 AM

Originally posted by LegendaryLars

I am making a fuckpile of money off of geo ads are you ?

the question is, could you be making more.

We are talking Millions of people not beeing tracker right.

**Big E** · 12-29-2004, 11:59 AM

Originally posted by Varius

$ip = $_SERVER[REMOTE_ADDR];
$ip = split("\.",$ip);
$ip = (16777216 * $ip[0]) + (65536 * $ip[1]) + (256 * $ip[2]) + $ip[3];

Or you could just use:

$IP_INT = ip2long($_SERVER['REMOTE_ADDR']);

**Fred Quimby** · 12-29-2004, 12:05 PM

SNAP,,,ok I'm gonna sign up

**xclusive** · 12-29-2004, 12:07 PM

Wow great post man i'll be taking advantage of you like trump in a $2 whore house,...

**Varius** · 12-29-2004, 12:07 PM

Originally posted by Big E

Or you could just use:

$IP_INT = ip2long($_SERVER['REMOTE_ADDR']);

This will return a lot of IPs as negative values.....so you must specify your fields to be signed, and/or format your string....

**cosis** · 12-29-2004, 12:14 PM

Originally posted by Paraskass

Fix your geo tracker.

I am in Quebec province, about 150 miles from Montreal, and it says meet hot girls in Montreal. I am 2 minutes from Ottawa.

FIX IT.

advertising in Lincoln and I am in Kentucky - AFF does the same thing, adultlocals.com works for me however

**Xenophage** · 12-29-2004, 12:32 PM

Originally posted by Varius

Ahh, gotcha.

Just incase though, if you are not already doing so, you can store the low-high range for the city as integer and use this formula to get the user's IP in that format for quick query speed :

$ip = $_SERVER[REMOTE_ADDR];
$ip = split("\.",$ip);
$ip = (16777216 * $ip[0]) + (65536 * $ip[1]) + (256 * $ip[2]) + $ip[3];

This (in PHP) would make $ip a nice int you can use like so:

$sql = "SELECT city_id FROM city_ip WHERE $ip > city_ip_low AND $ip < city_ip_high";

If you use a high enough version of MySQL or Oracle, you could also save the above as a stored function/procedure for maximum speed

sweet I passed it to my programmer to see if it helps out.

**Xenophage** · 12-29-2004, 12:33 PM

Originally posted by Furious_Male

Nice. Do you have a link to randomly generate these galleries?

not yet But I will put it ont he to do list

**Toni_N** · 12-29-2004, 12:43 PM

excelent, way to go Lars

**Tala** · 12-29-2004, 12:55 PM

SWEET. I hit upon one of the banners not too long ago, (couple of days ago, tops), and it looked as though it was a gallery that was geo targeted, not just a banner.

People are using banners of yours in fun ways! Good stuff Lars!

**andrej_NDC** · 12-29-2004, 12:56 PM

Originally posted by Crypt

This database dont index a city when 90% of ppl are farmer

**emthree** · 12-29-2004, 01:17 PM

dude that's one messy announcement, hire taboo to organize your posts next time

**Fatalspeed** · 12-29-2004, 01:29 PM

Originally posted by emthree

dude that's one messy announcement, hire taboo to organize your posts next time

lol no shit!

but its excellent news!

**Jon2** · 12-29-2004, 01:41 PM

shit it worked...

Got my city correct....

Jon

**Xenophage** · 12-29-2004, 02:13 PM

Originally posted by emthree

dude that's one messy announcement, hire taboo to organize your posts next time

Yeah I need a lot of help way too much stuff for me and my staff to get done, we are soo buried, biz is so off the hook its nutty ! I have HUGE HUGE HUGE announcements coming in the very near future !

**Webcam Guru** · 12-29-2004, 02:17 PM

Lars does it again! Congrats for another great feature and for the cams.com acquisition.

**Kevsh** · 12-29-2004, 03:11 PM

Originally posted by Paraskass

the question is, could you be making more.

We are talking Millions of people not beeing tracker right.

Guy, GEO tracking is not perfect. When it is i'm sure Lars will be the first to have it ready for his affiliates.

To Lars:

Great tool!

**Xenophage** · 12-29-2004, 08:37 PM

Originally posted by Kevsh

Guy, GEO tracking is not perfect. When it is i'm sure Lars will be the first to have it ready for his affiliates.

To Lars:

Great tool!

Thanks

**Penthouse Tony** · 12-29-2004, 08:47 PM

Awesome gallaries Lars! See you in Vegas.

**BSleazy** · 12-29-2004, 09:20 PM

If you had real time stats or even updated them hourly I'd send you my valuable webcam search engine traffic.

**2HousePlague** · 12-29-2004, 09:21 PM

Yay, Lars!

How DO you do it, bra...?

Never have so few done so much with so little.

j-

First GEO TARGET FREE HOSTED GALLERIES from Legendary Lars

First GEO TARGET FREE HOSTED GALLERIES from Legendary Lars

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment