Skip to content

Instantly share code, notes, and snippets.

View AngelFQC's full-sized avatar
🗒️
Code!

Angel Fernando Quiroz Campos AngelFQC

🗒️
Code!
View GitHub Profile
@AngelFQC
AngelFQC / lesson_pages.sql
Last active March 17, 2020 21:39
[Moodle] MySQL Query to get lesson pages ordered (require MySQL 8 or MariaDB 10.2.2)
WITH RECURSIVE lesson_pages_ordered (id, title, qtype, prev, next, lesson, display_order) AS
(
SELECT id, title, qtype, prevpageid, nextpageid, lessonid, '01'
FROM mdl_lesson_pages
WHERE prevpageid = 0
UNION
SELECT lp.id, lp.title, lp.qtype, lp.prevpageid, lp.nextpageid, lp.lessonid, lpo.display_order + 1
FROM lesson_pages_ordered lpo
LEFT JOIN mdl_lesson_pages lp
ON (lpo.next = lp.id AND lpo.lesson = lp.lessonid)
@AngelFQC
AngelFQC / Project.xml
Created May 31, 2017 13:57
PHPStorm Code Style for Chamilo LMS
<code_scheme name="Project">
<PHPCodeStyleSettings>
<option name="CONCAT_SPACES" value="false" />
<option name="PHPDOC_BLANK_LINE_BEFORE_TAGS" value="true" />
<option name="PHPDOC_BLANK_LINES_AROUND_PARAMETERS" value="true" />
<option name="LOWER_CASE_BOOLEAN_CONST" value="true" />
<option name="LOWER_CASE_NULL_CONST" value="true" />
<option name="ELSE_IF_STYLE" value="COMBINE" />
<option name="VARIABLE_NAMING_STYLE" value="CAMEL_CASE" />
<option name="BLANK_LINE_BEFORE_RETURN_STATEMENT" value="true" />
@AngelFQC
AngelFQC / mount_liveusb_filesystem.txt
Created August 25, 2015 14:03
Mount filesystem from LiveUSB - Ubuntu 14.04
# Mount filesystem on /mnt directory
# Change pendrive for your pendrive name
sudo mount -o loop /media/pendrive/casper-rw /mnt
# Mounted filesystem on /mnt/upper/home/ubuntu
# Unmount
sudo umount /mnt