Hikari Enhanced Comments

Ìgbéwọlẹ̀

Hikari Enhanced Comments requires at least WordPress 2.8 and PHP5 to work.

You can use the built in installer and upgrader, or you can install the plugin manually.

1. Download the zip file, upload it to your server and extract all its content to your /wp-content/plugins folder. Make sure the plugin has its own folder (for exemple /wp-content/plugins/hikari-enhanced-comments/).
2. Activate the plugin through the ‘Plugins’ menu in WordPress admin page.
3. Now you can go to widgets admin page and youÌtumọ̀ Yorùbá: ’ll find 2 new widgets available: “Hikari Enhanced Recent Comments” and “Hikari Most Commented Posts”

Installing and configuring ip2nation

ip2nation is a website that provides a MySQL database table, listing all worldÌtumọ̀ Yorùbá: ’s IPs and relating them to their respective country, together with each country name and code.

This table is provided in a downloadable .sql file. I donÌtumọ̀ Yorùbá: ’t add this table together with the plugin because itÌtumọ̀ Yorùbá: ’s updated from time to time, so itÌtumọ̀ Yorùbá: ’s better to just get it from the source and install it.

You are not required to have ip2nation installed to use Hikari Enhanced Comments. The plugin uses it just to get country flags. If ip2nation is not available, or if you are not able to install it, all other features from the plugin will still work, only flags wonÌtumọ̀ Yorùbá: ’t be shown (the place where theyÌtumọ̀ Yorùbá: ’d go will be blank, donÌtumọ̀ Yorùbá: ’t worry with broken code 🙂

First of course you must download the file. You can go to their home page and follow the ‘Download’ menu, or just download it directly: http://ip2nation.com/ip2nation.zip.

Once you have the file, you must upload it to your database. But hereÌtumọ̀ Yorùbá: ’s a cool feature: since its tables so big (somewhat 3MB the uncompressed .sql file, and 1MB after importing to MySQL) and rarely updated, I provided a way to add it to a different database, separated from your WordPress one. Doing so, youÌtumọ̀ Yorùbá: ’re not forced to back it up together with your website content (after all, itÌtumọ̀ Yorùbá: ’s not a relevant data worthy backing up, if you lose it you can just download it back from their site), and also if you have multiple sites you can have it stored only once.

If you wanna have ip2nation in the same database as your WordPress install, just use it to import the .sql file. If you wanna use a different database, I suggest creating a new one only for it. The trick is to assign over this new database, full access from your WordPress databaseÌtumọ̀ Yorùbá: ’s user (you can find its name in WordPress config.php. If the same user can access more than 1 database, itÌtumọ̀ Yorùbá: ’s easy for MySQL to provide simultaneous access to all of them. And if your WordPress database user only has access to these 2 databases, and ip2nation table only has this data, you shouldnÌtumọ̀ Yorùbá: ’t have security issues. To know how to assing user permissions to databases, please call your webhost provider. DonÌtumọ̀ Yorùbá: ’t install each table in separated database, ip2nation tables can be separated from WordPress but both tables must be in the same database!

As IÌtumọ̀ Yorùbá: ’ve said, ip2nation database is big, I had trouble uploading it with phpMySQL. I just split the file in 3 and imported them separately, itÌtumọ̀ Yorùbá: ’s just 2 CREATE TABLE in the begining and then a bunch of endless INSERT INTO. If you have timeout trouble, try splitting it in more files, or again request your webhost assistance.

Once you have your ip2nation database created, configured and populated with its data, and database user has privilege to it, go take a look if data was imported correctly. It creates 2 tables, ‘ip2nation’ with more than 40.000 records, and ‘ip2nationcountries’ with somewhat 250 records.

Now, to finish ip2nation installation, you must go to Hikari Enhanced Comments admin page, and under ‘ip2nation Database‘ option, set ip2nation database name. If you just installed it in WordPress database, leave this option blank. If it has its own database, the full database name must be added here. Pay attention because many shared hostings only let you define part of databases names and hide the part you canÌtumọ̀ Yorùbá: ’t change, make sure youÌtumọ̀ Yorùbá: ’re using the full name here.

To help you diagnose ip2nation and see if flags and countries are working, in this same page there is a section just below options where you can see it working. This section uses a testing IP from Brasil to query ip2nation tables, and if it was configured correctly youÌtumọ̀ Yorùbá: ’ll see its country code as ‘br‘ and country name as ‘Brazil‘, and just below youÌtumọ̀ Yorùbá: ’ll see BrasilÌtumọ̀ Yorùbá: ’s flag.

If you see all these info, you are good to go, gratz! If you see Brasil name and code but doesnÌtumọ̀ Yorùbá: ’t see its flag, assure you have properly extracted the plugin. If it was installed in /wp-content/plugins/hikari-enhanced-comments/, you should have a folder /wp-content/plugins/hikari-enhanced-comments/flags/ and inside it a bunch of files with those flags.

And if you donÌtumọ̀ Yorùbá: ’t even see BrasilÌtumọ̀ Yorùbá: ’s name and code in diagnose, then ip2nation is not properly configured. Verify its database again, and then assure WordPress database user can access it. If you have any trouble setting up your tables, or flags are in their place but are not accessible, please again go to your hosting provider ask for assistance.

Adding flags to your theme

You donÌtumọ̀ Yorùbá: ’t need to tweak your theme to have flags shown in it, Hikari Enhanced Comments adds them automatically to your comments authors. In the plugin admin page you can choose if flag should be added before or after authorÌtumọ̀ Yorùbá: ’s name, where it better fits your theme layout.

But you can also add it manually, if you want a more customized layout. For that, just use the function HkEC_flag($ip), where $ip is the IP whose flag you want. Flag image will be echoed automatically.

If that IP is from a comment author, you just use kEC_flag($comment->comment_author_IP) and you are done.

Upgrading

If you have to upgrade manually, simply delete hikari-enhanced-comments folder and follow installation steps again.

You donÌtumọ̀ Yorùbá: ’t need to touch ip2nation tables once they are installed, but since they are updated from time to time, you may want to update them to have info about all IPs. In this case, just import the lastest .sql file to your database.

Uninstalling

If you go to plugins list page and deactivate the plugin, itÌtumọ̀ Yorùbá: ’s config stored in database will remain stored and wonÌtumọ̀ Yorùbá: ’t be deleted.

If you want to fully uninstall the plugin and clean up database, go to its options page and use its uninstall feature. This feature deletes all stored options, restoring them to default (which can also be used if you want defaults restored back), and then gives you direct link to securely deactive the plugin so that no database data remains stored.

Plugin uninstall feature doesnÌtumọ̀ Yorùbá: ’t delete ip2nation tables, regarding if they are in same database as WordPress or in a separated one. If they are not used anymore, currently you must delete them manually if you donÌtumọ̀ Yorùbá: ’t need them anymore.

Also, make sure to delete pluginÌtumọ̀ Yorùbá: ’s widgets before uninstalling the plugin. ATM itÌtumọ̀ Yorùbá: ’s not deleted upon uninstalling, IÌtumọ̀ Yorùbá: ’ll fix it in a future version 🙁