Home » Blogs » sugree's blog

ip2cc supports displaying flag in node's link area

Posted February 2nd, 2006 by sugree

According to the flag in comment’s link area, now ip2cc is able to display flag in node’s link area also. These 2 features was suggested by Larry. The use of these capabilities, pointed out by Larry, is to verify the location of the visitor in E-Commerce sites.

What to see a demonstration? See below. You should see I am currently in Thailand.

Technorati Tags: , , , , , , ,

works perfectly...awesome idea

On February 4th, 2006 larry says:

I think a module like this has many uses. Particularly these days, as location verification has become more important in ecommerce. Is it 100%? No, of course not. But it's a big step in the right direction and let's others know that you are serious about the integrity of the information submitted to your site.

Recently, I've also talked to another drupal user who wrote, from scratch, an IM client for his dating ite. The client is then used by members to chat with one another. He said he lans to release the code later. We'll see. In any case, I like this idea beause it turns Drupal into a more 'distributed platform'. An IM client that could use the funtionality of ip2cc is a interesting idea. What do you all think?

cheers,

larry

a bit off topic, but ...

On February 5th, 2006 Anonymous says:

How do I run fetchdb.sh on a windows machine, to set up the ip to country database? I looked at the file, and created the mysql tables, but I'm not sure how to insert the data from the excel file.

I had the same problem...

On February 5th, 2006 larry says:

My problem was solved by sugree, author of the module and headhocho of this site. He was kind enough to send me the populated mysql table that this script creates. If you like, I can send it to you. For obvious reasons, I don't want to post my email address here. I get enough penis enlargement offers and get rich quick schemes already. However, you can either join this site and mail me using the contact form or mail me from Drupal.org. My ID is also 'larry' over there.

cheers,

larry

ipdb.mysql now on this site

On February 5th, 2006 Anonymous says:

Hey, thanks very much for your reply.
I just read the updated install text (from cvs), and sugree has put the mysql database on this site at http://www.howforge.com/modules/ip2cc/ipdb.mysql ... although it's unzipped, so quite large.
I'll install it, and if I have any problems I'll message you here or at Drupal.
BTW, do .sh files run under linux or something?

Good question...

On February 5th, 2006 Anonymous says:

I believe .sh files run under linux and unix, judging from the commands in the script. I'm a windows(although that's slowly changing!) guy, so I'm not 100% certain. My guess is, you could run it under windows if you had 'cygwin' installed. This simulates a unix environment and allows you to run Unix commands, such those in this script, from the command line. Still, I'm just guessing. By the way, this IP module works very well. Good luck.

cheers,

larry

I downloaded cvs but ...

On February 5th, 2006 Anonymous says:

the module is producing a lot of errors (perhaps because I am using it on a localhost?) Also, ip2cc doesn't appear in the admin/settings menu. If I manually go the url, it loads up okay though.

update module

On February 7th, 2006 sugree says:

You have to disable and then enable module when the module has been added menu.

cygwin should run fetchdb.sh

On February 7th, 2006 sugree says:

It is possible to run fetchdb.sh under cygwin but you need to install wget.

That fixed it - thanks.

On February 7th, 2006 Anonymous says:

The menu is now displaying.

What might be causing this error?

On February 7th, 2006 Anonymous says:

user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' query: SELECT i.*,c.* FROM ip2cc i LEFT JOIN iso3166 c ON i.country_code = c.country_code2 WHERE ip_from <= 3401523799 AND ip_to >= 3401523799 in C:\folder2\web33\great_violinists\includes\database.mysql.inc on line 124.

different collations

On February 7th, 2006 sugree says:

Oops! It seems you are using drupal 4.6.x so the collation is still latin1 on MySQL 4.1.x. In this case, you have 3 choices.

1. upgrade to 4.7.0 beta 4 so everything will be converted to utf8
2. modify iso3166.mysql, (ipdb.mysql or ip2cc.mysql), and ip2cc_addon.mysql by replacing "/*!40100 DEFAULT CHARACTER SET utf8 */ ;" with ";" and rerun these scripts again
3. alter charset and collation of table ip2cc, iso3166, and ip2cc_node to latin1

Sorry for inconvenience.

No inconvenience!

On February 7th, 2006 Anonymous says:

Thank you for creating the module! I was using 4.7b4. I think the problem must have been a clash with some other module. I started again with a new database, and removed all the other modules, and now I am not getting the errors.

For every node or comment created, the database is correctly storing the IP. In the settings, I can choose which nodes or comments display flags, but they are not appearing. Do I need to configure settings, and also add some code to my theme? If so, what code?

missing flag

On February 7th, 2006 sugree says:

You don't need to modify theme. The flag should appear in link area. If you don't see the flag, probably you didn't install flags yet or your IP is totally unknown.

cool. I did'nt know that....

On February 7th, 2006 Anonymous says:

Is wget one of the packages available with the cygwin download. I mean, when deciding which parts of cygwin you want ( because a full install is huge!) is this another possible package to take as part of your download?

larry

wget

On February 7th, 2006 sugree says:

Yes, it is.

Back to getting the same errors ...

On February 10th, 2006 Anonymous says:

Strange. I'll try this module again when 4.7 is out of beta perhaps.

eu.png flag image...any idea where to get it?

On February 17th, 2006 larry says:

I've discovered that some IP addresses are under the eu heading, but the is no image vailable for this in the http://ip-to-country.webhosting.info/flag/awstatsflags downloads. So I just get a blank square attached to the node instead of a flag, but the hover information is still available. Any idea where I can get it?

cheers,

larry

eu and gb

On February 17th, 2006 sugree says:

eu and gb doesn't conform to the iso3166 so there is no flag for them provided by awstats. Anyway, gb is uk and eu actually has their flag. So you can copy uk.png to gb.png and choose an eu flag and resize it to 14x14.

I will do it tomorrow if you can wait...

I'm sending you the images

On February 17th, 2006 Anonymous says:

Hello Sugree,

Thanks for our reply. I've checked and in my download I've gotten the gb.png with it. However, I've found a nice eu flag and I've resized it and converted the format to .png. I'm sending it and the gb image to you now. You can't have all the fun!

thanks,

larry

ip2cc drupal module error

On July 19th, 2006 Anonymous says:

hi and thanks for your work! i'm getting:


user warning: Unknown column 'i.country_code' in 'on clause' query: SELECT i.*,c.* FROM ip2cc i LEFT JOIN iso3166 c ON i.country_code = c.country_code2 WHERE ip_from <= 1151208626 AND ip_to >= 1151208626 in c:\roadskater\includes\database.mysql.inc on line 120.

i believe i've applied everything correctly, but obviously perhaps not. i have 3 tables related to ip2cc it seems, with stucture as such:

ip2cc
IP_FROM double No 0
IP_TO double No 0
COUNTRY_CODE2 char(2) latin1_swedish_ci No
COUNTRY_CODE3 char(3) latin1_swedish_ci No
COUNTRY_NAME

ip2cc_node
nid int(10) UNSIGNED No 0
hostname varchar(128) latin1_swedish_ci Yes NULL

iso3166
country_code2 char(2) latin1_swedish_ci No
country_code3 char(3) latin1_swedish_ci No
country_name varchar(80) latin1_swedish_ci No
country_number int(3) No 0

any thoughts? thanks, rsn2.com

ipdb.mysql

On July 21st, 2006 sugree says:

Oops! It's all my fault. Please get ipdb.mysql from my latest post. ip2cc.mysql is now obsoleted.

Video Converter for Mac is

On November 7th, 2008 werwe (not verified) says:

Video Converter for Mac is the most powerful Video Converter for Mac OS software which allows you to convert videos between popular video formats and audio formats. The easy-to-use Video Converter for Mac lets you to enjoy your videos on iPod, PSP, Mobile Phone, Zune, iPhone, Apple TV and MP4/MP3 player. This Video Converter for Mac allows you to set the destination, the name of output files.iPod Converter for Mac is the best Video to iPod Converter for Mac OS X software for you. With the iPod Converter for Mac you can easily convert popular video formats including FLV, MPEG1, MPEG2, DivX, Xvid, WMV, 3GP, 3G2, MOV, AVI, MPEG TS/TP (for HD Video), etc to iPod compatible MPEG-4 videos. And also it is not only and iPod Converter for Mac, but it can convert all popular videos to iPhone, Apple TV, PSP, PS3, Youtube (web), Creative Zen, iRiver PMP, Archos, MP4, various mobile phones and many other digital video and audio players.MP4 Converter for Mac is an excellent Mac MP4 converter which can not only convert MP4 to MP3, WMA, AAC, WAV, etc but also convert avi, flv, wmv, mpeg, divx etc to MP4 on Mac os x to enjoy your favourite video with MP4 Converter for Mac os. Compared with other mp4 converter Mac software, the MP4 Converter for Mac provides powerful edit functions, such as setting the output settings, cropping and trimming files, merging several files into one, etc. With this MP4 Converter for Mac, you can easily convert mp4 videos to varoius format for Mac.

FLV Converter Mac is a

On November 11th, 2008 Anonymous (not verified) says:

FLV Converter Mac is a powerful FLV Converter for Mac software which can convert FLV video files to all popular video formats and convert FLV to popular audio formats for Mac OS X users. FLV Converter Mac OS X softwrare supports all video popular formats indcluding FLV, MPG, MPEG1, MPEG2, MP4, 3GP, 3G2, MOV, AVI, Mpeg TS/TP (for HD Video), etc. The Mac FLV Converter can also convert FLV to MP3, WAV, OGG, 3GP, AAC and M4A, AC3, APE, etc audio.
How to download YouTube videos for Mac and convert the .FLV files on Mac OS? Here are the easy-to-use and top-user-rating YouTube Video Grabber Mac and Mac FLV converter tools. It is safe to install and no spyware or adware guarenteed.
With the YouTube Video Grabber Mac application, you can easily download youtube for mac and convert YouTube videos on your Mac OS. It can automatically detect the YouTube video files from the YouTube web pages you have opened and download multiple files once a time. YouTube Video Grabber Mac is a totally free download youtube videos for mac, because if you don’t want to convert downloaded videos to your mobile players, you don’t have to pay for it. 6

Post new comment

The content of this field is kept private and will not be shown publicly.