{"id":8008,"date":"2010-02-15T15:52:44","date_gmt":"2010-02-15T15:52:44","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/myeasydb\/"},"modified":"2010-02-23T16:18:14","modified_gmt":"2010-02-23T16:18:14","slug":"myeasydb","status":"publish","type":"plugin","link":"https:\/\/hat.wordpress.org\/plugins\/myeasydb\/","author":5745102,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"0.0.6","stable_tag":"0.0.6","tested":"2.9.2","requires":"2.9.1","requires_php":"","requires_plugins":"","header_name":"myeasydb","header_author":"Ugo Grandolini aka \"camaleo\"","header_description":"","assets_banners_color":"8ab8d1","last_updated":"2010-02-23 16:18:14","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/www.paypal.com\/cgi-bin\/webscr?cmd=_s-xclick&hosted_button_id=9VCM6JTADXFY6","header_plugin_uri":"http:\/\/myeasydb.com","header_author_uri":"http:\/\/myeasydb.com","rating":5,"author_block_rating":0,"active_installs":10,"downloads":4268,"num_ratings":1,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"0.0.6":"<p>The plugin did not work on Windows and hosted servers.<\/p>","0.0.5":"<p>The Settings page was not showed on fresh installations... my fault not to having tested the plugin on a fresh installation :(<\/p>","0.0.4":"<p>If you need to edit multi-keys records you must update<\/p>","0.0.3":"<ul>\n<li>Sorry, I have messed up with SVN while uploading version 0.0.2, this one should be fine<\/li>\n<\/ul>","0.0.2":"<p>You are now able to edit tables data<\/p>","0.0.1":"<p>This is the first release thus it does not yet include all the features I am planning... however it would be nice to give it a try :)<\/p>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":"1"},"assets_icons":[],"assets_banners":{"banner-772x250.jpg":{"filename":"banner-772x250.jpg","revision":"541942","resolution":"772x250","location":"assets"}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["0.0.1","0.0.2","0.0.3","0.0.4","0.0.5","0.0.6"],"block_files":[],"assets_screenshots":{"screenshot-2.png":{"filename":"screenshot-2.png","revision":"1539452","resolution":"2","location":"plugin"},"screenshot-3.png":{"filename":"screenshot-3.png","revision":"1539452","resolution":"3","location":"plugin"},"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1539452","resolution":"1","location":"plugin"}},"screenshots":{"1":"Browsing a table","2":"Editing a record","3":"Setting up a relation"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[83,563,44978,1627],"plugin_category":[59],"plugin_contributors":[83427],"plugin_business_model":[],"class_list":["post-8008","plugin","type-plugin","status-publish","hentry","plugin_tags-admin","plugin_tags-administration","plugin_tags-data-management","plugin_tags-mysql","plugin_category-utilities-and-tools","plugin_contributors-camaleo","plugin_committers-camaleo"],"banners":{"banner":"https:\/\/ps.w.org\/myeasydb\/assets\/banner-772x250.jpg?rev=541942","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/myeasydb_8ab8d1.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/myeasydb\/trunk\/screenshot-1.png?rev=1539452","caption":"Browsing a table"},{"src":"https:\/\/ps.w.org\/myeasydb\/trunk\/screenshot-2.png?rev=1539452","caption":"Editing a record"},{"src":"https:\/\/ps.w.org\/myeasydb\/trunk\/screenshot-3.png?rev=1539452","caption":"Setting up a relation"}],"raw_content":"<!--section=description-->\n<p>myEASYdb is a WordPress plugin created to help managing your MySQL tables in the easiest and quickest way.<\/p>\n\n<p>This version of myEASYdb let's you browse and edit your exhisting tables by simply setting the name of the database you want to edit.\nYou can also define relations between fields. Relations can be defined when a field includes a value that is the key of another table.\nBy setting a relation you will be able to choose the field value by selecting the description of the related table in a drow down menu.<\/p>\n\n<p>Future releases will include a wide range of operations on your MySQL tables like, for example:\ntables design, fields validation setup, tables maintenance, print\/export to PDF and CSV (comma separated text files), etc.<\/p>\n\n<p>If you like to see myEASYdb in action <a href=\"http:\/\/myeasydb.com\/tutorials\/intro\/\" title=\"myEASYdb Plugin for WordPress Intro\">check the Intro video<\/a>.<\/p>\n\n<p>Related Links:<\/p>\n\n<ul>\n<li><a href=\"http:\/\/myeasydb.com\/\" title=\"myEASYdb Plugin for WordPress\">Plugin Homepage<\/a><\/li>\n<\/ul>\n\n<p><em>Please note that this is my first WordPress plugin thus the minimum WordPress required version is 2.9.1 &mdash; the latest available version when I started to code the plugin.\nIf you are successfully using this plugin with an older WordPress version, <a href=\"http:\/\/myeasydb.com\/#contact\">please let me know<\/a>!<\/em><\/p>\n\n<!--section=installation-->\n<p>This section describes how to install the plugin and get it working.<\/p>\n\n<ol>\n<li>Upload the full directory into your <code>wp-content\/plugins<\/code> directory<\/li>\n<li>Activate the plugin through the 'Plugins' menu in the WordPress Administration page<\/li>\n<li>Open the plugin configuration page, which is located under <code>Settings -&gt; myEASYdb<\/code> and fill up the options. If the myEasyDB Database you choose does not contains the myEASYdb own tables you will get the option to create them.<\/li>\n<li>You can access to all the tables included in the selected Database trough the myEASYdb menu<\/li>\n<li>To access the plugin tools open the <code>Tools -&gt; myEASYdb menu<\/code><\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt>On which browsers do you test myEASYdb?<\/dt>\n<dd><p>I develop and test the plugin on Mozilla Firefox and Google Chrome on Ubuntu Linux.\nI do regulary upgrade the browsers to the latest versions as soon as they became available.<\/p>\n\n<p>Everynow and then I do also test on IE8 in a VirtualBox environment.<\/p><\/dd>\n<dt>What languages are available?<\/dt>\n<dd><p>At the moment I am working on the English version, however I am following the WordPress guidelines to make it easily translable once it will become 'mature' enough.\nIf you like to help with the translation please <a href=\"http:\/\/myeasydb.com\/#contact\">fill the contact form<\/a> on the myEASYdb home page.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>0.0.6 (23 February 2010)<\/h4>\n\n<ul>\n<li>On Windows servers the main configuration was not loaded due to an issue when defining the installation path.<\/li>\n<li>Added an option to show debug info on screen.<\/li>\n<li>Added a check to be sure the MySQL user has sufficient privileges to create myEASYdb own tables.<\/li>\n<li>Fixed some issues when creating myEASYdb own tables.<\/li>\n<li>Tested (and working) on an <a href=\"http:\/\/secure.hostgator.com\/cgi-bin\/affiliates\/clickthru.cgi?id=maraja\">HostGator<\/a> hosted account.<\/li>\n<li>When a reference is deleted the screen is now properly refreshed.<\/li>\n<li>NEW! Define which fields you like to filter and filter the table contents list accordingly.<\/li>\n<\/ul>\n\n<h4>0.0.5 (17 February 2010)<\/h4>\n\n<ul>\n<li>Fixed an issue on a fresh installation preventing to load the Settings page.<\/li>\n<li>Minor changes in the Settings page layout to fit a 1024 pixels width screen.<\/li>\n<li>Contents list page:\n\n<ul>\n<li>corrected the fields alignment for referenced fields.<\/li>\n<li>when you change the value in the 'records per page' drop down menu the page is resetted to the top.<\/li>\n<\/ul><\/li>\n<li>Table data was not removed everytime it was necessary.<\/li>\n<li>Added lables descriptions to butons.<\/li>\n<\/ul>\n\n<h4>0.0.4 (16 February 2010)<\/h4>\n\n<ul>\n<li>Added support for tables that does not use a numeric\/autoincremented field for the key.\nIn this case the key used to get\/update the record is created using ALL the fields defined as keys.<\/li>\n<li>Added an indication on the screen about which fields are used as key.<\/li>\n<li>If it is not possible to determine the table key the code dies (for the moment) showing an info message.<\/li>\n<li>Headers\/data in the table list are now aligned on the right if the field is numeric.<\/li>\n<li>Every table field is now shown on the Edit Record page: reserved and yet-to-be-handled fields types are represented as readonly input fields.<\/li>\n<li>The 'records per page' drop down menu is now functional; its original value (defined in the Settings page) is restored when you reload the page.<\/li>\n<\/ul>\n\n<h4>0.0.3 (15 February 2010)<\/h4>\n\n<ul>\n<li>Sorry, I have messed up with SVN<\/li>\n<\/ul>\n\n<h4>0.0.2 (15 February 2010)<\/h4>\n\n<ul>\n<li>When updating a table, its ID field (the autoincremented one):\n\n<ul>\n<li>is now choosen as the first auto-increment field in the table<\/li>\n<li>is not overwritten anymore<\/li>\n<\/ul><\/li>\n<li>Backslashes added by <code>mysql_real_escape()<\/code> are now properly removed before presenting the data on the screen<\/li>\n<\/ul>\n\n<h4>0.0.1 (15 February 2010)<\/h4>\n\n<ul>\n<li>This is the first release!<\/li>\n<\/ul>","raw_excerpt":"Edit and manage your MySQL tables in the easiest and quickest way.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/8008","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=8008"}],"author":[{"embeddable":true,"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/camaleo"}],"wp:attachment":[{"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=8008"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=8008"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=8008"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=8008"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=8008"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/hat.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=8008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}