Skip to content

Instantly share code, notes, and snippets.

View smilingkylan's full-sized avatar
💭
Working Hard

Kylan Hurt smilingkylan

💭
Working Hard
34 followers · 35 following
View GitHub Profile
@smilingkylan
smilingkylan / useful-queries
Last active December 7, 2015 22:52
UPDATE corporate_member_info SET
course_access = NULL,
mng_group ="Zamil Group",
r_comp= NULL,
o_comp = NULL,
group_id = 442,
f_name = NULL,
l_name = NULL,
language_preference = "en",
Nname_f = NULL,
@smilingkylan
smilingkylan / ngrok
Created August 6, 2015 00:04
//use command line within windows
//go to the extracted ngrok folder
ngrok.exe http [your.ip.address]:[your-port-number]
@smilingkylan
smilingkylan / Hash Bang for Viewing Source
Created August 11, 2015 21:16
/?_escaped_fragment_=
@smilingkylan
smilingkylan / convert.sh
Last active October 20, 2015 17:32
//purpose of this file is to loop through a batch of MP4 files and convert to flac filetype in Ubuntu command line
for f in av-files/*.mp4;
do avconv -i "$f" "${f%.mp4}.wav";
done;
//another version
for f in *.mp4;
do avconv -i "$f" "${f%.mp4}.wav";
done;
@smilingkylan
smilingkylan / license-reset-queries
Last active February 8, 2016 22:28
UPDATE corporate_member_info
SET r_comp = NULL, o_comp = NULL,
f_name = NULL, l_name = NULL, Nname_f = NULL, Nname_l = NULL,
password = "****", login_name = licence_ID,
course_access = NULL, limited_acess = NULL,
email = NULL, employee_id = NULL, email = NULL, report_frequency = NULL,
language_preference = "ar",
report_send = NULL, report_frequency = NULL, report_recipients = NULL,
current_login = NULL, logins = NULL, total_time_spent = NULL,
activate_date = NULL,
@smilingkylan
smilingkylan / gist:0f98ae990975f025e2ee
Created December 17, 2015 22:28
I=0
for F in *; do
echo "$F" `printf CMP1092-%03d.json $I+1`
//mv "$F" `printf CMP1092-%03d.json $I+1` 2>/dev/null || true
I=$((I + 1))
done
@smilingkylan
smilingkylan / LMS Query
Last active December 22, 2015 16:35
SELECT member_course_table.*, courses.*, subcategories.* FROM member_course_table JOIN courses ON member_course_table.course_ID = courses.course_ID JOIN subcategories ON subcategories.id = courses.category_id WHERE member_course_table.member_ID = 805777
@smilingkylan
smilingkylan / VirtualBox Increase Disk Size
Created January 21, 2016 20:42
//from c://program files/oracle/virtualbox
VBoxManage.exe modifyhd ../../../"Kylan's Documents"/VirtualBox/DG/DG.vdi --resize 24000
@smilingkylan
smilingkylan / renaming-files
Created January 27, 2016 16:51
for file in *; do mv "${file}" "${file/ course preview/I}"; done
@smilingkylan
smilingkylan / keybase.md
Created December 28, 2018 02:23

Keybase proof

I hereby claim:

  • I am kylanhurt on github.
  • I am captaincrypto (https://keybase.io/captaincrypto) on keybase.
  • I have a public key ASDKGYiJa-kaIwOVAqvShuBs3l_p7_4yUFPoQt4x8WnZTAo

To claim this, I am signing this object: