{"id":44,"date":"2016-04-16T12:00:00","date_gmt":"2016-04-16T15:00:00","guid":{"rendered":"http:\/\/helbertt.16mb.com\/site\/index.php\/2016\/04\/16\/cadastrar-usuario-no-moodle-pelo-comando-sql\/"},"modified":"2016-04-16T12:00:00","modified_gmt":"2016-04-16T15:00:00","slug":"cadastrar-usuario-no-moodle-pelo-comando-sql","status":"publish","type":"post","link":"https:\/\/helbertt.xyz\/site\/cadastrar-usuario-no-moodle-pelo-comando-sql\/","title":{"rendered":"Cadastrar Usu\u00e1rio no Moodle pelo Comando SQL"},"content":{"rendered":"<p>Para cadastrar usu\u00e1rio no Moodle com comando SQL \u00e9 necess\u00e1rio evitar duplica\u00e7\u00e3o de registro no campos email,username. Esses campos devem ter valor \u00fanico para cada usu\u00e1rio inserido.<br \/>A outra recomenda\u00e7\u00e3o \u00e9 certificar que os campos confirmed e mnethostid estejam recebendo valar 1. Se tiver valor 0 ou NULL o usu\u00e1rio n\u00e3o consegue logar.<\/p>\n<p>A tabela mdl_user do Moodle tem v\u00e1rios campos. Os mais importantes para cadastrar um usu\u00e1rio s\u00e3o: firstname,lastname,email,username,password,confirmed como mostra o c\u00f3digo SQL abaixo.<\/p>\n<p><span style=\"color: red;\"><u><i><b>INSERT INTO mdl_user (firstname, lastname, email, username, password, confirmed, description, mnethostid) VALUES (&#8216;Joao&#8217;, &#8216;Silva&#8217;, &#8216;jsilva@gmail.com&#8217;, &#8216;joao&#8217;, MD5(&#8216;silva&#8217;), 1, &#8216;Cabra Bom&#8217;, 1);<\/b><\/i><\/u><\/span><\/p>\n<p>Execute esse comando no banco de dados e fa\u00e7a um teste. Para verificar se funcionou tudo certinho logue no Moodle:<br \/>Login: joao<br \/>Senha: silva<\/p>\n<p>Se funcionar \u00e9 porque deu tudo certo.<\/p>\n<p><b>Observa\u00e7\u00e3o:<\/b><br \/>O campo mnethostid s\u00f3 existe a partir da vers\u00e3o 1.8. Na vers\u00e3o inferior a 1.8 retire esse campo para evitar erro.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para cadastrar usu\u00e1rio no Moodle com comando SQL \u00e9 necess\u00e1rio evitar duplica\u00e7\u00e3o de registro no campos email,username. Esses campos devem<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout"},"categories":[49,48,31],"tags":[],"_links":{"self":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts\/44"}],"collection":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/comments?post=44"}],"version-history":[{"count":0,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts\/44\/revisions"}],"wp:attachment":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/media?parent=44"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/categories?post=44"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/tags?post=44"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}