Created
April 3, 2012 17:01
-
-
Save oravecz/2293673 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <div> | |
| <ul> | |
| <li>I've installed stock Wordpress 3.3.1 and uploaded the WPML 2.4.3.</li> | |
| <li>The blog has the "Hello World!" post and the "Sample Page" page. </li> | |
| <li>I activate the WPML plugin and accept the defaults.</li> | |
| <li>I activate XML-RPC.</li> | |
| <li>Using XML-RPC, I perform a getPost() to obtain the first post details.<br /> | |
| { "dateCreated": "2012-04-03T19:52:44.000Z", | |
| <div> "userid": "1",</div> | |
| <div> "postid": 1,</div> | |
| <div> "description": "Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!",</div> | |
| <div> "title": "Hello world!",</div> | |
| <div> "link": "http://ruwad.info/?p=1",</div> | |
| <div> "permaLink": "http://ruwad.info/?p=1",</div> | |
| <div> "categories": [</div> | |
| <div> "Uncategorized"</div> | |
| <div> ],</div> | |
| <div> "mt_excerpt": "",</div> | |
| <div> "mt_text_more": "",</div> | |
| <div> "mt_allow_comments": 1,</div> | |
| <div> "mt_allow_pings": 1,</div> | |
| <div> "mt_keywords": "",</div> | |
| <div> "wp_slug": "hello-world",</div> | |
| <div> "wp_password": "",</div> | |
| <div> "wp_author_id": "1",</div> | |
| <div> "wp_author_display_name": "jcook",</div> | |
| <div> "date_created_gmt": "2012-04-03T19:52:44.000Z",</div> | |
| <div> "post_status": "publish",</div> | |
| <div> "custom_fields": [],</div> | |
| <div> "wp_post_format": "standard",</div> | |
| <div> "sticky": false</div> | |
| <div>}<br /> | |
| <strong>SQL query:</strong> SELECT * FROM `wp_icl_translations` LIMIT 0, 30 ; </div> | |
| <div> | |
| <div> | |
| <p><strong>Rows:</strong> 6</p> | |
| <div id="sqlqueryresults"> | |
| <table id="table_results"> | |
| <thead> | |
| <tr> | |
| <th>translation_id</th> | |
| <th>element_type</th> | |
| <th>element_id</th> | |
| <th>trid</th> | |
| <th>language_code</th> | |
| <th>source_language_code</th> | |
| </tr> | |
| </thead> | |
| <tbody> | |
| <tr> | |
| <td align="right">1</td> | |
| <td>post_page</td> | |
| <td align="right">2</td> | |
| <td align="right">2</td> | |
| <td>en</td> | |
| <td align="right"><em>NULL</em></td> | |
| </tr> | |
| <tr> | |
| <td align="right">2</td> | |
| <td>post_post</td> | |
| <td align="right">1</td> | |
| <td align="right">1</td> | |
| <td>en</td> | |
| <td align="right"><em>NULL</em></td> | |
| </tr> | |
| <tr> | |
| <td align="right">3</td> | |
| <td>tax_category</td> | |
| <td align="right">1</td> | |
| <td align="right">4</td> | |
| <td>en</td> | |
| <td align="right"><em>NULL</em></td> | |
| </tr> | |
| <tr> | |
| <td align="right">4</td> | |
| <td>tax_link_category</td> | |
| <td align="right">2</td> | |
| <td align="right">7</td> | |
| <td>en</td> | |
| <td align="right"><em>NULL</em></td> | |
| </tr> | |
| <tr> | |
| <td align="right">5</td> | |
| <td>comment</td> | |
| <td align="right">1</td> | |
| <td align="right">9</td> | |
| <td>en</td> | |
| <td align="right"><em>NULL</em></td> | |
| </tr> | |
| <tr> | |
| <td align="right">6</td> | |
| <td>tax_category</td> | |
| <td align="right">3</td> | |
| <td align="right">4</td> | |
| <td>ar</td> | |
| <td>en</td> | |
| </tr> | |
| </tbody> | |
| </table> | |
| <br /> | |
| </div> | |
| <div id="sqlqueryresults">Custom fields are empty and this may be as expected. After all, this is a post that existed prior to using the WPML plugin.<br /> | |
| <br /> | |
| </div> | |
| </div> | |
| </div> | |
| </li> | |
| <li>I manually add a new post and its accompanying arabic translation using wordpress.</li> | |
| <li>The result of getPost() looks no different than a post without the WPML plugin installed.<br /> | |
| <div>{</div> | |
| <div> "dateCreated": "2012-04-03T19:21:52.000Z",</div> | |
| <div> "userid": "1",</div> | |
| <div> "postid": 5,</div> | |
| <div> "description": "This is a post in English.",</div> | |
| <div> "title": "Example Post 1",</div> | |
| <div> "link": "http://ruwad.info/?p=5",</div> | |
| <div> "permaLink": "http://ruwad.info/?p=5",</div> | |
| <div> "categories": [</div> | |
| <div> "Uncategorized"</div> | |
| <div> ],</div> | |
| <div> "mt_excerpt": "",</div> | |
| <div> "mt_text_more": "",</div> | |
| <div> "mt_allow_comments": 1,</div> | |
| <div> "mt_allow_pings": 1,</div> | |
| <div> "mt_keywords": "",</div> | |
| <div> "wp_slug": "",</div> | |
| <div> "wp_password": "",</div> | |
| <div> "wp_author_id": "1",</div> | |
| <div> "wp_author_display_name": "jcook",</div> | |
| <div> "date_created_gmt": "2012-04-03T19:21:52.000Z",</div> | |
| <div> "post_status": "draft",</div> | |
| <div> "custom_fields": [],</div> | |
| <div> "wp_post_format": "standard",</div> | |
| <div> "sticky": false</div> | |
| <div>}</div> | |
| <div><br /> | |
| </div> | |
| <div>{</div> | |
| <div> "dateCreated": "2012-04-03T19:24:49.000Z",</div> | |
| <div> "userid": "1",</div> | |
| <div> "postid": 7,</div> | |
| <div> "description": "This is a post in Arabic.",</div> | |
| <div> "title": "Example Post 1 (Arabic)",</div> | |
| <div> "link": "http://ruwad.info/?p=7&amp;lang=ar",</div> | |
| <div> "permaLink": "http://ruwad.info/?p=7&amp;lang=ar",</div> | |
| <div> "categories": [</div> | |
| <div> "Uncategorized"</div> | |
| <div> ],</div> | |
| <div> "mt_excerpt": "",</div> | |
| <div> "mt_text_more": "",</div> | |
| <div> "mt_allow_comments": 1,</div> | |
| <div> "mt_allow_pings": 1,</div> | |
| <div> "mt_keywords": "",</div> | |
| <div> "wp_slug": "",</div> | |
| <div> "wp_password": "",</div> | |
| <div> "wp_author_id": "1",</div> | |
| <div> "wp_author_display_name": "jcook",</div> | |
| <div> "date_created_gmt": "2012-04-03T19:24:49.000Z",</div> | |
| <div> "post_status": "draft",</div> | |
| <div> "custom_fields": [],</div> | |
| <div> "wp_post_format": "standard",</div> | |
| <div> "sticky": false</div> | |
| <div>}</div> | |
| <div><br /> | |
| </div> | |
| <div> | |
| <p><strong>SQL query:</strong> SELECT * FROM `wp_icl_translations` LIMIT 0, 30 ; <br /> | |
| <strong>Rows:</strong> 8</p> | |
| <div id="sqlqueryresults"> | |
| <table id="table_results"> | |
| <thead> | |
| <tr> | |
| <th>translation_id</th> | |
| <th>element_type</th> | |
| <th>element_id</th> | |
| <th>trid</th> | |
| <th>language_code</th> | |
| <th>source_language_code</th> | |
| </tr> | |
| </thead> | |
| <tbody> | |
| <tr> | |
| <td>8</td> | |
| <td>post_post</td> | |
| <td>5</td> | |
| <td>10</td> | |
| <td>en</td> | |
| <td><em>NULL</em></td> | |
| </tr> | |
| <tr> | |
| <td>9</td> | |
| <td>post_post</td> | |
| <td>7</td> | |
| <td>10</td> | |
| <td>ar</td> | |
| <td>en</td> | |
| </tr> | |
| </tbody> | |
| </table> | |
| <br /> | |
| </div> | |
| </div> | |
| <div id="sqlqueryresults">So, we can see the database column trid is "tieing" post 5 and post 7 together as a single entity. However, there are no custom fields for _wpml_translation, _wpml_trid, or _wpml_translations. Perhaps these fields are only present when a post is created using XML-RPC?</div> | |
| <div id="sqlqueryresults"><br /> | |
| </div> | |
| </li> | |
| <li>This time, I insert a two new post into my blog using the WordPress XML-RPC api. One post is marked using a custom field as English (Using the _wpml_language = "en") and the other is Arabic (using _wpml_language = 'ar'). Each post has a custom field with _wpml_trid = '11'. Here is the request for the Arabic post.<br /> | |
| <div><methodCall></div> | |
| <div> <methodName>metaWeblog.newPost</methodName></div> | |
| <div> <params></div> | |
| <div> <param></div> | |
| <div> <int>1</int></div> | |
| <div> <string>admin</string></div> | |
| <div> <string>Ruw@d13</string></div> | |
| <div> <struct></div> | |
| <div> <member></div> | |
| <div> <name>wp_slug</name></div> | |
| <div> <value><string>wood-and-nickels-cashing-in-on-good-relationship_eng.html</string></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>wp_password</name></div> | |
| <div> <value><string/></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>wp_page_parent_id</name></div> | |
| <div> <value><int>0</int></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>wp_page_order</name></div> | |
| <div> <value><int>0</int></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>wp_author_id</name></div> | |
| <div> <value><string>1</string></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>title</name></div> | |
| <div> <value><string>?????? ?????? ????????? ??????</string></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>post_type</name></div> | |
| <div> <value><string>post</string></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>description</name></div> | |
| <div> <value><string>??????: ???? ???blah, blah...</string></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>mt_excerpt</name></div> | |
| <div> <value><string>This is an excerpt</string></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>mt_text_more</name></div> | |
| <div> <value><string/></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>mt_allow_comments</name></div> | |
| <div> <value><int>0</int></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>mt_allow_pings</name></div> | |
| <div> <value><int>0</int></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>dateCreated</name></div> | |
| <div> <value><dateTime.iso8601>2009-12-07T18:07:32.000Z</dateTime.iso8601></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>custom_fields</name></div> | |
| <div> <value><array><data></div> | |
| <div> <struct></div> | |
| <div> <member></div> | |
| <div> <name>key</name></div> | |
| <div> <value><string>key</string></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>value</name></div> | |
| <div> <value><string>article-key-70</string></value></div> | |
| <div> </member></div> | |
| <div> </struct></div> | |
| <div> <struct></div> | |
| <div> <member></div> | |
| <div> <name>key</name></div> | |
| <div> <value><string>locale</string></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>value</name></div> | |
| <div> <value><string>ar</string></value></div> | |
| <div> </member></div> | |
| <div> </struct></div> | |
| <div> <struct></div> | |
| <div> <member></div> | |
| <div> <name>key</name></div> | |
| <div> <value><string>_wpml_language</string></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>value</name></div> | |
| <div> <value><int>5</int></value></div> | |
| <div> </member></div> | |
| <div> </struct></div> | |
| <div> <struct></div> | |
| <div> <member></div> | |
| <div> <name>key</name></div> | |
| <div> <value><string>_wpml_trid</string></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>value</name></div> | |
| <div> <value><int>11</int></value></div> | |
| <div> </member></div> | |
| <div> </struct></div> | |
| <div> </data></array></value></div> | |
| <div> </member></div> | |
| <div> <member></div> | |
| <div> <name>publish</name></div> | |
| <div> <value><boolean>false</boolean></value></div> | |
| <div> </member></div> | |
| <div> </struct></div> | |
| <div> </param></div> | |
| <div> </params></div> | |
| <div></methodCall></div> | |
| <div><br /> | |
| </div> | |
| <div>The wp_icl_translations file shows that the use of the custom fields accomplished nothing. The English post is #10 and the Arabic post is #12. Neither the language_code or the trid was affected.<br /> | |
| <table id="table_results"> | |
| <thead> | |
| <tr> | |
| <th>translation_id</th> | |
| <th>element_type</th> | |
| <th>element_id</th> | |
| <th>trid</th> | |
| <th>language_code</th> | |
| <th>source_language_code</th> | |
| </tr> | |
| </thead> | |
| <tbody> | |
| <tr> | |
| <td>10</td> | |
| <td>post_post</td> | |
| <td>10</td> | |
| <td>11</td> | |
| <td>en</td> | |
| <td><em>NULL</em></td> | |
| </tr> | |
| <tr> | |
| <td>11</td> | |
| <td>post_post</td> | |
| <td>12</td> | |
| <td>12</td> | |
| <td>en</td> | |
| <td><em>NULL</em></td> | |
| </tr> | |
| </tbody> | |
| </table> | |
| </div> | |
| <div><br /> | |
| </div> | |
| </li> | |
| <li>The wp_postmeta table shows that my custom fields were added to the post, but no _wpml fields appear.<br /> | |
| <p><strong>SQL query:</strong> SELECT * FROM `wp_postmeta` LIMIT 0, 30 ; <br /> | |
| <strong>Rows:</strong> 9</p> | |
| <div id="sqlqueryresults"> | |
| <table id="table_results"> | |
| <thead> | |
| <tr> | |
| <th>meta_id</th> | |
| <th>post_id</th> | |
| <th>meta_key</th> | |
| <th>meta_value</th> | |
| </tr> | |
| </thead> | |
| <tbody> | |
| <tr> | |
| <td align="right">1</td> | |
| <td align="right">2</td> | |
| <td>_wp_page_template</td> | |
| <td align="left">default</td> | |
| </tr> | |
| <tr> | |
| <td align="right">5</td> | |
| <td align="right">5</td> | |
| <td>_edit_lock</td> | |
| <td align="left">1333467182:1</td> | |
| </tr> | |
| <tr> | |
| <td align="right">4</td> | |
| <td align="right">5</td> | |
| <td>_edit_last</td> | |
| <td align="left">1</td> | |
| </tr> | |
| <tr> | |
| <td align="right">6</td> | |
| <td align="right">7</td> | |
| <td>_edit_last</td> | |
| <td align="left">1</td> | |
| </tr> | |
| <tr> | |
| <td align="right">7</td> | |
| <td align="right">7</td> | |
| <td>_edit_lock</td> | |
| <td align="left">1333466587:1</td> | |
| </tr> | |
| <tr> | |
| <td align="right">8</td> | |
| <td align="right">10</td> | |
| <td>key</td> | |
| <td align="left">article-key-70</td> | |
| </tr> | |
| <tr> | |
| <td align="right">9</td> | |
| <td align="right">10</td> | |
| <td>locale</td> | |
| <td align="left">ar</td> | |
| </tr> | |
| <tr> | |
| <td align="right">10</td> | |
| <td align="right">12</td> | |
| <td>key</td> | |
| <td align="left">article-key-70</td> | |
| </tr> | |
| <tr> | |
| <td align="right">11</td> | |
| <td align="right">12</td> | |
| <td>locale</td> | |
| <td align="left">en</td> | |
| </tr> | |
| </tbody> | |
| </table> | |
| </div> | |
| </li> | |
| </ol> | |
| </div> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment