Virtual Box – Shared directory on global network (windows, mac, ubuntu)

  1. How to run ubuntu server on virtual box (Windows, Mac, Ubuntu)
  2. How to add local network with Ubuntu Virtual Box Instance.
  3. How to share directory with Ubuntu Virtual Box Instance.
Continue reading “Virtual Box – Shared directory on global network (windows, mac, ubuntu)”

Moodle – Mind Map Plugin RTL Support

 This Moodle plugin will allow to use Mind map service.

Test token to the service: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJkYXRhIjp7ImVtYWlsIjoiZGV2bGlvbkBnbWFpbC5jb20iLCJmaXJzdF9uYW1lIjoiZGV2bGlvbiIsImxhc3RfbmFtZSI6InRlc3QifSwiaWF0IjoxNTY1MjE3MDY5LCJleHAiOjE5MjUyMTcwNjl9.hFzXOMRVVhVtOTdpX1I7UZRwaoQljQSlnVCFSfkDiU8

Test Url: https://dev.mindmaap.com/

Set Mind Map token at plugin settings interface:

Moodle – Upgrade version with Git from 3.3-3.*

First Step: 

 git remote add upstream https://github.com/moodle/moodle.git

Second Step: 

vim update.sh 
#!/bin/bash
git fetch upstream
for BRANCH in MOODLE_{31..37}_STABLE master;
do
git push origin refs/remotes/upstream/$BRANCH:refs/heads/$BRANCH
done

Source: https://docs.moodle.org/dev/Git_for_developers

MOODLE – Backup and restore DB Orders

Export DB DUMP with ignore table mdl_logstore_standard_log

mysqldump moodle --ignore-table=mdl_logstore_standard_log | gzip > /backup/moodledb-date +\%Y-\%m-\%d-\%H-\%M-\%S.sql.gz 

Import DB DUMP

gunzip < moodledb_dump.sql.gz | mysql -u moodle -p moodle

import DB dump without log table

gzip -cd "./mydb.sql.gz" | sed -r '/INSERT INTO `(log_table_1|log_table_2|log_table_3|log_table_4)`/d' | gzip > "./mydb2.sql.gz"

Moodle -Query to change all users details

UPDATE mdl_user 
SET
username=CONCAT('username',mdl_user.id),
phone1=CONCAT('11111',mdl_user.id),
phone2=CONCAT('11111',mdl_user.id),
firstname=CONCAT('Name',mdl_user.id),
lastname=CONCAT('Last',mdl_user.id),
email=CONCAT('email',mdl_user.id,'@test.com'),
idnumber= CONCAT('1000',mdl_user.id,'2000')
WHERE id>=7