Skip to content

Instantly share code, notes, and snippets.

View nadavkav's full-sized avatar

Nadav Kavalerchik nadavkav

54 followers · 13 following
View GitHub Profile
@nadavkav
nadavkav / bbb_api_getmeetings.php
Created March 19, 2020 19:33
Bigbluebutton API getmeetings (PHP) Moodle
//https://docs.bigbluebutton.org/dev/api.html#getmeetings
// Adhoc task that keep updating the BBB load params every X minutes.
$bbb_api_getmeetings_xml = file_get_contents('https://bbb-service.edu/bigbluebutton/api/getMeetings?checksum=7fd047728b989f36bffdc3337a08f334a5');
$xml = simplexml_load_string($bbb_api_getmeetings_xml, "SimpleXMLElement", LIBXML_NOCDATA);
$json = json_encode($xml);
$meeting_array = json_decode($json,TRUE);
@nadavkav
nadavkav / log_user_pageload_js_perf_stats
Created November 2, 2019 13:29
Log Moodle user page load statistics
<?php
define('AJAX_SCRIPT', true);
require(__DIR__ . '/config.php');
$contextid = required_param('contextid', PARAM_INT);
$preftiming = optional_param('preftiming', '', PARAM_RAW);
// Security.
@nadavkav
nadavkav / PerformanceNavigationTiming
Created November 2, 2019 13:26
Moodle user page load PerformanceNavigationTiming
define(['jquery', 'core/config', 'core/notification'],
function($, config, notification) {
// https://developer.mozilla.org/en-US/docs/Web/API/PerformanceNavigationTiming
var preftiming = performance.timing;
var params = {
contextid: config.contextid,
preftiming: JSON.stringify(preftiming),
sesskey: config.sesskey
@nadavkav
nadavkav / Alef_Regular-normal.js
Created October 16, 2019 22:29
jsPDF Alef Hebrew font
(function (jsPDFAPI) {
var font = 'AAEAAAATAQAABAAwRkZUTWatrcwAAAE8AAAAHEdERUYJSQdnAAABWAAAAERHUE9TaxINtAAAAZwAAAVMR1NVQobuvs4AAAboAAADdE9TLzKAEc+oAAAKXAAAAGBjbWFwJxxliQAACrwAAAP2Y3Z0IGx0aJMAAA60AAAChmZwZ212vUTEAAARPAAABiNnYXNwAAAAEAAAF2AAAAAIZ2x5ZqCJZS0AABdoAAEy5GhlYWQC6ER3AAFKTAAAADZoaGVhDu4DlgABSoQAAAAkaG10eMh6vR8AAUqoAAAGoGxvY2H4f60MAAFRSAAAA1JtYXhwBLUCGAABVJwAAAAgbmFtZTAoU+YAAVS8AAACWnBvc3S3zoa3AAFXGAAACkZwcmVwcFDMKQABYWAAAAN4d2ViZsxqUUkAAWTYAAAABgAAAAEAAAAAzD2izwAAAADNAI4VAAAAAM1vfOcAAQAAAA4AAAA8AAAAAAACAAcAAAEqAAEBKwE3AAMBOAE5AAEBOgE7AAMBPAE8AAEBPQE9AAMBPgGnAAEABAAAAAIAAAABAAAACgBMAIIAAmhlYnIADmxhdG4ALAAKAAF6ejAxABIAAP//AAEAAAAA//8AAwABAAIAAwAAAAF6ejAxAAoAAP//AAMAAQACAAMABG1hcmsAGnp6MDEAJHp6MDIAKnp6MDMAMAAAAAMAAAABAAIAAAABAAAAAAABAAEAAAABAAIAAwAIABAAGAAEAAEAAQAYAAQAAQABAmIABAABAAECsAABAcwBtgABAeIADAA1AGwAcgB4AH4AhACKAJAAlgCcAKIAqACuALQAugDAAMYAzADSANgA3gDkAOoA8AD2APwBAgEIAQ4BFAEaASABJgEsATIBOAE+AUQBSgFQAVYBXAFiAWgBbgF0AXoBgAGGAYwBkgGYAZ4BpAABAH4AAAABAF0AAAAB//0AAAABAQ0AAAABAJgAAAAB/8oAAAABAG0AAAABAJEAA
@nadavkav
nadavkav / oer_catalog.sql
Created September 17, 2019 15:06
SELECT
lm.instanceid
,(SELECT DISTINCT m.data
FROM mdl_local_metadata as m
JOIN mdl_local_metadata_field AS mf ON m.fieldid = mf.id AND mf.contextlevel = 70
WHERE mf.shortname = 'ID' and m.instanceid = cm.id) as 'Unique resource ID'
,(SELECT DISTINCT m.data
FROM mdl_local_metadata as m
JOIN mdl_local_metadata_field AS mf ON m.fieldid = mf.id AND mf.contextlevel = 70
WHERE mf.shortname = 'teacherremarks' and m.instanceid = cm.id) as 'MD - Teacher intro'
@nadavkav
nadavkav / oer_catalog.sql
Created September 17, 2019 15:05
What modules are copied from what course? (PETEL)
SELECT
cm.course, cm.id, cm.module, m.name
,CASE m.name
WHEN 'quiz' THEN (SELECT m.name FROM mdl_quiz m WHERE m.id = cm.instance)
END AS 'Module name'
,t.courseid, c.fullname, u.firstname, u.lastname
FROM mdl_local_courseduplicate t
JOIN mdl_course_modules cm ON cm.id = t.sourceactivityid
JOIN mdl_modules m ON m.id = cm.module
JOIN mdl_course c ON c.id = t.courseid
@nadavkav
nadavkav / mysql_statements_monitoring.php
Created June 8, 2018 10:46
Use a PHP script to monitor SQL statements logged inside MySQL/MariaDB
<?php
// DataTable.net initialization options
// https://datatables.net/reference/option/
// Turn on MySQL/MariaDB global sql statement debugging
// https://stackoverflow.com/a/14403905/374316
// Setup db admin user.
if (!empty($_GET['dbrootuser'])) {
@nadavkav
nadavkav / send sms via moodle php
Created March 10, 2018 14:42
send sms via moodle php to ssl-vp.com smoove.io
<?php
require(__DIR__.'../../config.php');
require_once($CFG->libdir.'/filelib.php');
$endpoint = 'https://ssl-vp.com/rest/v1/Messages?sendNow=true';
$header = array('Content-type: application/json','Authorization: PUT-API-KEY');
$params = array('toMembersByCell' => array('+972 53 333333'),
'body' => 'Hello PeTeLs !!! what\'s going on??? ',
'fromNumber' => '+972 53 3333333');
@nadavkav
nadavkav / jsxgraph_avi.js
Created February 23, 2018 08:41
A JSXGraph JS file for a Moodle jsxgraph filter
(function() {
var dataLine= "נתון", sep = " : ";
var dbgGrid = false;
var dbgPoints = false;
var pA, pB, pC, pAA, pBB, pCC;
var color1='#0000ff', color2='#0000ff', color3='#0000ff';
if ( {showColor} ) {
color1='#ff0000'; color2='#00ff00'; color3='#0000ff';
@nadavkav
nadavkav / Moosh_Command_Moodle23_Config_ConfigGet.php
Created January 19, 2018 10:00
<?php
// Moosh/Command/Moodle23/Config/ConfigGet.php
/**
* moosh - Moodle Shell
*
* @copyright 2012 onwards Tomasz Muras
* @license http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
*/
namespace Moosh\Command\Moodle23\Config;