Skip to content

Instantly share code, notes, and snippets.

View michaelmeneses's full-sized avatar

Michael Douglas Meneses de Souza michaelmeneses

8 followers · 10 following
View GitHub Profile
@michaelmeneses
michaelmeneses / gist:4d8ed03ce6de67f6dfc21bf90c2cb670
Last active March 7, 2024 01:00
[
{
"retorno":
{
"status_processamento":
"3",
"status":
"OK",
"registros":
[
@michaelmeneses
michaelmeneses / proxy-content.js
Last active October 25, 2023 21:38
const baseUrlProxy = "https://webhook.site/a0435441-b221-4c98-a91b-cc80657d35c6";
const urlParams = new URLSearchParams(window.location.search);
const contentSecret = urlParams.get('contentSecret');
const frmContent = document.getElementById("frmContent");
var API = getAPI();
var params = new URLSearchParams();
params.append("consumerKey", consumerKey);
params.append("contentSecret", contentSecret);
params.append("redirect", false);
@michaelmeneses
michaelmeneses / mobile_view_page.mustache
Last active October 24, 2023 18:45
MOODLE/mod/booking/templates/mobile_view_page.mustache
<div>
<ion-card>
<ion-card-header>
{{booking.booking.name}}
</ion-card-header>
<ion-card-content>
{{{booking.booking.intro}}}
</ion-card-content>
</ion-card>
@michaelmeneses
michaelmeneses / gist:107399513813f008ccdb675eb6d9f714
Last active October 23, 2023 13:07
SELECT c.id as courseid, cfield.id as fieldid, cdata.value
FROM mdl_user_enrolments ue
JOIN mdl_enrol e ON e.id = ue.enrolid
JOIN mdl_course c ON c.id = e.courseid
JOIN mdl_course_categories cat ON cat.id = c.category
JOIN mdl_competency_coursecomp ccomp ON ccomp.courseid = c.id
JOIN mdl_competency comp ON comp.id = ccomp.competencyid
JOIN mdl_context ctx ON ctx.instanceid = c.id AND ctx.contextlevel = 50
JOIN mdl_customfield_data cdata ON cdata.contextid = ctx.id
JOIN mdl_customfield_field cfield ON cfield.id = cdata.fieldid AND cfield.shortname = 'casa'
@michaelmeneses
michaelmeneses / gist:60fc740ad81e8150fe0d8aed49253ca4
Last active October 23, 2023 12:59
SELECT cfield.id as fieldid, cdata.value, count(cdata.value) as total
FROM mdl_user_enrolments ue
JOIN mdl_enrol e ON e.id = ue.enrolid
JOIN mdl_course c ON c.id = e.courseid
JOIN mdl_course_categories cat ON cat.id = c.category
JOIN mdl_competency_coursecomp ccomp ON ccomp.courseid = c.id
JOIN mdl_competency comp ON comp.id = ccomp.competencyid
JOIN mdl_context ctx ON ctx.instanceid = c.id AND ctx.contextlevel = 50
JOIN mdl_customfield_data cdata ON cdata.contextid = ctx.id
JOIN mdl_customfield_field cfield ON cfield.id = cdata.fieldid AND cfield.shortname = 'casa'
@michaelmeneses
michaelmeneses / gist:376ae1ec2615c4316dabce0d489a9479
Created June 27, 2023 12:50
mysqldump --single-transaction --create-options --disable-keys --add-drop-trigger --add-locks --lock-tables database | gzip > file.sql.gz
@michaelmeneses
michaelmeneses / gist:12307d332230015d9050ec6801b7642f
Created March 1, 2023 14:27
This file has been truncated, but you can view the full file.
iVBORw0KGgoAAAANSUhEUgAABS0AAAORCAYAAAAXrYdLAAAK2WlDQ1BJQ0MgUHJvZmlsZQAASImVlwdQU+kWgP970xstIQJSQm+CFIEAUkIPXTqISkgCCSXEhIAidhZXcC2oiKCyoIsiCq6ugKwFsWBhEWxgXZBFQFkXCzZQ9gKPsLtv3nvzzszJ/83J+U/55/53zgWAEsgRi9NgJQDSRZmSMF8PRkxsHAM3ACAAAzzQBjCHKxWzQkMDASIz69/l/X3EG5E7FpOx/v3//yoqPL6UCwAUj3AiT8pNR7gZ0VdcsSQTANQJxK6fnSme5LsI0yRIgQgPTnLyNI9PcuIUo5WmfCLCPBE2AABP5nAkyQCQrRA7I4ubjMQhhyJsJeIJRQivQ9iVK+DwEEbygnnp6RmTPIywCeIvBoBCQ5iZ+JeYyX+LnyiPz+Eky3m6rynBewml4jTOyv/zaP63pKfJZnIYIUoWSPzCkJWOnF93akaAnEWJwSEzLORN+U+xQOYXOcNcqWfcDPM4XgHyvWnBgTOcJPRhy+NksiNmmC/1Dp9hSUaYPFeSxJM1wxzJbF5ZaqTcLuCz5fFzBBHRM5wljAqeYWlqeMCsj6fcLpGFyevni3w9ZvP6yHtPl/6lXyFbvjdTEOEn750zWz9fxJqNKY2R18bje3nP+kTK/cWZHvJc4rRQuT8/zVdul2aFy/dmIg/n7N5Q+RmmcPxDZxgEAl/AAH7AC4QhazTwmWKQyV+ROdmMZ4Z4pUSYLMhksJAbx2ewRVzLeQwbKxtbACbv7/Qj8bZ76l5CdPysTYzEZ5Ygxt5Z27JuABq0AVDcOmszQu6Xkj8AF89zZZKsaRt68gcDiEAR0IA68m7QBybAAtgAe+AM3IE38AchIALEgqWACwQgHUhANsgF60E+KATbwW5QCsrBQXAEHAcnQQM4Cy6Cq+Am6AD3wCPQA/rBSzAC3oMxCIJwEAWiQuqQDmQImUM2EBNyhbyhQCgMioUSoGRIBMmgXGgjVAgVQaVQBVQN
@michaelmeneses
michaelmeneses / moodle.localhost
Last active February 27, 2023 21:47
server nginx
server {
listen 80;
server_name moodle.localhost;
root /var/www/moodle.localhost/moodle;
index index.php index.html index.htm;
location / {
try_files $uri $uri/ /index.php?$args =404;
}
@michaelmeneses
michaelmeneses / mdl-fcv.sql
Created July 22, 2022 17:56
SELECT u.id, u.username, u.deleted, c.id as courseids, m.situacao
FROM mdl_user u
JOIN mdl_user_enrolments ue ON ue.userid = u.id
JOIN mdl_enrol e ON e.id = ue.enrolid
JOIN mdl_course c ON c.id = e.courseid
LEFT JOIN mdl_unifcv_matriculas m ON m.userid = u.id
WHERE
ue.status = 0
AND e.roleid = 5
AND c.id NOT IN
@michaelmeneses
michaelmeneses / core_enrol_get_users_courses.json
Last active October 22, 2021 03:23
[{"id":15,"shortname":"Curso_de_Testes","fullname":"CUSTOM COURSENAME","displayname":"Curso de Testes","idnumber":"","visible":1,"summary":"<p dir=\"ltr\" style=\"text-align:left;\"><strong>A Motorola est\u00e1 sempre preocupada com inova\u00e7\u00e3o, experi\u00eancia do cliente e diferenciais de mercado. Por isso, disponibilizou v\u00e1rios v\u00eddeos com detalhes sobre os melhores smartphones da marca. Confira!<\/strong><\/p><p dir=\"ltr\" style=\"text-align:left;\"><strong><span style=\"font-size:.9375rem;\">Quando terminar de assistir, \u00e9 s\u00f3 clicar no quadrado ao lado direito do v\u00eddeo para confirmar o seu progresso na atividade.<\/span><br \/><\/strong><\/p><p dir=\"ltr\" style=\"text-align:left;\"><\/p><p><\/p><p dir=\"ltr\"><\/p><p dir=\"ltr\"><strong>Confira os v\u00eddeos dispon\u00edveis e se tiver alguma d\u00favida, \u00e9 s\u00f3 entrar em contato pelo e-mail: exclusividade@mixtelatacado.com.br<\/strong><\/p><br \/><p><\/p>","summaryformat":1,"format":"grid","showgrades":true,"lang