Language Packs – Update 13 – July, 28th, 2011

This week I have developed functional API Endpoint. If you want to deploy it you should install this SQL script.

DROP TABLE IF EXISTS revisions;
CREATE TABLE revisions (
	id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	eid BIGINT(20) NOT NULL,
	version VARCHAR(20) NOT NULL,
	locale VARCHAR(10) NOT NULL,
	revision BIGINT(20) NOT NULL,
	percent INT NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
DROP TABLE IF EXISTS entities;
CREATE TABLE entities (
	id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	type VARCHAR(10) NOT NULL,
	slug TEXT NOT NULL,
	name TEXT NOT NULL,
	textdomain TEXT NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

INSERT INTO entities (type, slug, name, textdomain) VALUES
('plugin', 'blogger-importer/blogger-importer.php', 'Blogger Importer', 'blogger-importer'),
('plugin', 'blogware-importer/blogware-importer.php', 'Blogware Importer', 'blogware-importer'),
('plugin', 'dotclear-importer/dotclear-importer.php', 'DotClear Importer', 'dotclear-importer'),
('plugin', 'greymatter-importer/greymatter-importer.php', 'GreyMatter Importer', 'greymatter-importer'),
('plugin', 'livejournal-importer/livejournal-importer.php', 'LiveJournal Importer', 'livejournal-importer'),
('plugin', 'movabletype-importer/movabletype-importer.php', 'Movable Type and TypePad Importer', 'movabletype-importer'),
('plugin', 'opml-importer/opml-importer.php', 'OPML Importer', 'opml-importer'),
('plugin', 'rss-importer/rss-importer.php', 'RSS Importer', 'rss-importer'),
('plugin', 'stp-importer/stp-importer.php', 'Simple Tags Importer', 'stp-importer'),
('plugin', 'textpattern-importer/textpattern-importer.php', 'TextPattern Importer', 'textpattern-importer'),
('plugin', 'utw-importer/utw-importer.php', 'Ultimate Tag Warrior Importer', 'utw-importer'),
('plugin', 'wordpress-importer/wordpress-importer.php', 'WordPress Importer', 'wordpress-importer'),
('plugin', 'wpcat2tag-importer/wpcat2tag-importer.php', 'Categories to Tags Converter Importer', 'wpcat2tag-importer');

INSERT INTO revisions (eid, version, locale, revision, percent) VALUES
(1, '0.4', 'hr', 221, 100),
(1, '0.4', 'it', 214, 100),
(1, '0.4', 'ru', 222, 100),
(1, '0.4', 'sr', 279, 100),
(2, '0.2', 'hr', 213, 100),
(2, '0.2', 'it', 245, 100),
(2, '0.2', 'ru', 345, 100),
(2, '0.2', 'sr', 123, 100),
(3, '0.2', 'hr', 243, 100),
(3, '0.2', 'it', 278, 100),
(3, '0.2', 'ru', 214, 100),
(3, '0.2', 'sr', 310, 100),
(4, '0.2', 'hr', 213, 100),
(4, '0.2', 'it', 226, 100),
(4, '0.2', 'ru', 311, 100),
(4, '0.2', 'sr', 190, 100),
(5, '0.4', 'hr', 107, 100),
(5, '0.4', 'it', 356, 100),
(5, '0.4', 'ru', 274, 100),
(5, '0.4', 'sr', 222, 100),
(6, '0.4', 'hr', 422, 100),
(6, '0.4', 'it', 258, 100),
(6, '0.4', 'ru', 215, 100),
(6, '0.4', 'sr', 185, 100),
(7, '0.2', 'hr', 257, 100),
(7, '0.2', 'it', 220, 100),
(7, '0.2', 'ru', 275, 100),
(7, '0.2', 'sr', 300, 100),
(8, '0.2', 'hr', 264, 100),
(8, '0.2', 'it', 239, 100),
(8, '0.2', 'ru', 310, 100),
(8, '0.2', 'sr', 280, 100),
(9, '0.2', 'hr', 221, 100),
(9, '0.2', 'it', 180, 100),
(9, '0.2', 'ru', 296, 100),
(9, '0.2', 'sr', 268, 100),
(10, '0.2', 'hr', 257, 100),
(10, '0.2', 'it', 281, 100),
(10, '0.2', 'ru', 242, 100),
(10, '0.2', 'sr', 320, 100),
(11, '0.2', 'hr', 288, 100),
(11, '0.2', 'it', 272, 100),
(11, '0.2', 'ru', 296, 100),
(11, '0.2', 'sr', 311, 100),
(12, '0.5', 'hr', 218, 100),
(13, '0.5', 'hr', 204, 100),
(13, '0.5', 'it', 256, 100),
(13, '0.5', 'ru', 227, 100),
(13, '0.5', 'sr', 294, 100);

I have started to solve bugs in plugin functions such as language_packs_api, get_textdomain, etc. and add the new functionality for creating wp-content/languages plugins and themes directory by plugin installation (Ticket #240) and I plan to make one more enhancement for translations preview from GlotPress (Ticket #241).