Open Script Solution

Today, my posts in this website reached more than 10 articles. Therefore, there was an “Older entries” link showed-up in the bottom of my front page. Well, I want this link text become pagination link that automatically detects the number of the page. So I searched, found, and used WP-PageNavi plugin for this purpose, and everything seemed okay so far until I found a little bit problem. This plugin has not fully supported multi-language, especially my own language; bahasa Indonesia, yet. When the pagination link showed-up, it bothered me that the Page and of words have not been translated to my language when I choose my language as the selected language. So I decided to modify this plugin’s script. Edited: This following modification being applied for 2.73 (the last version when I edited this article). I have sent the .mo and .po files to the author in order to be included into the next release. Read more…

I have hundreds of records that need to be imported from one table and database (let’s say that this is the first database) to another table in different database (and the last one is the second database). Unfortunately, one of the columns in the table in first database has the Date value in 10 digits numeral format. For example: 1206980969. Actually, this value equals with March 31, 2008 16:29:29 on UTC. Then, how do I convert that 10 digits numeral to the Data value since the column in the second database is a Date field type? And how do I convert again that date according to my local time? Read more…