thanks for your reply. i updated my database with your ipdb.mysql one and the error messages stopped. that was a big step.

the flags weren't displaying, so i looked at the links and then at the module code. i ended up hacking the module code, as it was treating the flag as a node (i believe) when constructing the address. (this is probably due to some quirk of my settings.) regardless, i hardwired it to suit me, making the url work, and changing the .png to .gif and changing width and height to suit other flag set, somewhat like this...

the original...


$src = url(drupal_get_path('module','ip2cc') . "/flags/$cc.png");
$attribs = array('width' => 14, height => 14, 'alt' => "$cc", 'title' => "$title");
return "";


became this...


$src = url("http://example.com/modules/ip2cc/flags/$cc.gif");
$attribs = array('width' => 18, height => 12, 'alt' => "$cc", 'title' => "$title");
return "";


i think many people would use the api if we could get some good examples together of ways to use it in blocks, by user names, etc. i know there are some basic hints but i'm too dumb to hook it all into useful drupal variables since i'm still learning it all and don't know them. (and yes i'm willing to go read more on drupal.org too.)

i'll throw out some things...my site is rsn2.com, a community building site for skating, cycling and charity exercise...and of course more. the ideas:

i use userpoints but call them skateylove points. beside the user's name, perhaps all over the site but in userpoints especially, i'd like to place a flag (or two) to the left of the user name in the userpoints block and full listing. in some cases i'd like to use the flag of the country they most recently posted from, perhaps, and others, i'd like to allow them the option of entering country of birth or citizenship as a code in their profile, and having that be their user flag (as opposed to an ip based posting flag).

there is an example with a snip of code in one node on howforge, but the code that produced the example is not fully included i don't believe. specifically i don't think it addresses how to pull the flag. that block is for showing the user where they're posting from.

http://drupal.org/node/65939 presents some mods made on watchdog module, and that may help some of us figure it out.

also, a search of all modules i have on my system pointed out that ip2cc is referenced in the search_keywords module around line 81 and 82 of my version. it goes something like this...


$sql = 'SELECT a.* FROM {search_keywords_log} a' . tablesort_sql($header);

$output = theme('table', $header, $rows);
$output .= theme('pager', NULL, 30, 0);
return $output;
}


so that's all i know or have found on the subject. this is a cool thing to have and i hope we can share ways of using it. none of this is meant by way of complaint or expecation that anyone owes me or anyone else anything. i appreciate your hard work, all of you, and am happy to struggle along, but always glad to have the light shined on my path when it isn't too much trouble. i'll share the light when i have some.

thanks!

Hello
i am trying to install ip2cc module and this is what install file reads am not able to get it am not techie please guide me

I have completed first three steps

now at 4 am confused , what does it mean

in the 4th step are those * two separate sub steps or we have to choose either of two?

how to run that Run fetchdb.sh ? am on linux hosting i have ssh access what command i have to run?

Apply ip2cc.mysql , it means to just run sql command right?

Download ipdb.mysql from http://www.howforge.com/modules/ip2cc/ipdb.mysql

i cannot find the above file , does it exits? can you try

i need help in installing the module

thanks for your help

With Regards
jamie

Installation
------------

1. Copy the ip2cc.module to the Drupal modules/ip2cc directory.

2. Download flag provided by AWStats http://ip-to-country.webhosting.info/flag/awstatsflags.zip and extract in modules/ip2cc/flags

3. Apply iso3166.mysql

4. Choose a database

* IP-to-Country
1. Run fetchdb.sh to obtain ip2cc.mysql
2. Apply ip2cc.mysql

* My Database
1. Download ipdb.mysql from http://www.howforge.com/modules/ip2cc/ipdb.mysql
2. Apply ipdb.mysql

5. Apply ip2cc_addon.mysql

6. Enable the module by visiting admin/modules

i am running 4.7 version

thanks for your help , all the steps which are mentioned in that version i have tried to follow

i have written th problem which am facing in earlier message

thanks once again for your help

regards
jamie

Hello Sugree thanks for your help ,

* My Database
1. Download ipdb.mysql from http://www.howforge.com/modules/ip2cc/ipdb.mysql
2. Apply ipdb.mysql

what about this step , am getting 404 not found error when i try to get the ipdb.mysql file

do i require it?

thanks for your help once again

With Regards

i can see that you have attached the ipdb.mysql file in the above post , but just a query i was checking version 5 of the module and there was same file present but the size of both are different

the file you attached is of about 5.18mb and file available with version 5 is 5.88mb

should i use the latest file of 5.88 size?

thanks lot one again

lianyk
Welcome to wow gold our wow Gold and wow power leveling store. We wow gold are specilized, wow power leveling professional and reliable wow power leveling website for wow power leveling selling and wow gold service. By the World of Warcraft gold same token,we offer wow power leveling the best WoW service wow power leveling for our long-term and wow powerleveling loyal customers. wow powerleveling You will find wow powerleveling the benefits and value powerleveling we created powerleveling different from other sites. As to most people, power leveling they are unwilling to power leveling spend most of wow power leveling the time wow gold grinding money Rolex for mounts or rolex replica repair when replica rolex they can purchase Watches Rolex what they Rolex Watches are badly need. The Watch Rolex only way is to look Rolex Watch for the best place rs gold to buy cheap WOW gold. Yes! You find it here! Our WoW Gold supplying service has already accumulated a high reputation and credibility. We have plenty of Gold suppliers, which will guarantee our delivery instant. Actually, we have been getting Runescape Gold tons of postive feedbacks from our loyal RuneScape Money customers who really appreciate our service. Thanks!

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.

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.
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.