m1gin 52


Audio Qur'an English Translation



Ayet ayet Kur'an:

http://www.quranflash.com/data/translation/en_sahih/2/275

http://www.quranflash.com/assets/audio/verses/EnIbrahimWalk/

http://www.everyayah.com/data/English/Sahih_Intnl_Ibrahim_Walk_192kbps/
http://www.quranflash.com/books/MedinaOld/?en


Browsable:
https://download.quranicaudio.com/verses/Minshawi/Mujawwad/
https://www.quranflash.com/assets/audio/verses/

Verse audio example:

English:
192kbps: https://everyayah.com/data/English/Sahih_Intnl_Ibrahim_Walk_192kbps/008022.mp3
64kbps: http://www.quranflash.com/assets/audio/verses/EnIbrahimWalk/002041.mp3


Arabic:
https://download.quranicaudio.com/verses/Alafasy/mp3/002014.mp3
https://download.quranicaudio.com/verses/Alafasy/ogg/002026.ogg
https://download.quranicaudio.com/verses/Minshawi/Mujawwad/mp3/002061.mp3

MORE RECITERS:

https://www.tvquran.com/en/quran/recitations/reciters-list


LIKED RECITERS:

Hani Rifai
192kbps, verse: https://everyayah.com/data/Hani_Rifai_192kbps/008022.mp3
128kbps, surah: https://download.quranicaudio.com/qdc/hani_ar_rifai/murattal/8.mp3

Mohammad Rashad Alshareef
96kbps, verse: https://www.quranflash.com/assets/audio/verses/MohammadRashadAlshareef/017053.mp3
128kbps, surah: https://download.tvquran.com/download/recitations/317/233/019.mp3

Mishari al Afasy
128kbps, surah: https://download.quranicaudio.com/qdc/mishari_al_afasy/murattal/17.mp3
128kbps, surah: https://download.tvquran.com/download/recitations/85/226/014.mp3


From Android App: Quran Vocabulary Memorization

insert arabic and english words into vav db.

ATTACH '/var/www/ovz/quran-vocabulary/vocabulary.db' AS dbx;
INSERT INTO tblword (word, mean, username, flag, langword, langmean)
SELECT ArabicWord, EnglishMeaning, "m1gin", 0, "ar", "en" FROM dbx.tbl_commonwords WHERE id<500;
DETACH dbx;

---

prepare list to rename pronunciation files to id.mp3

ATTACH '/var/www/ovz/quran-vocabulary/vocabulary.db' AS dbx;

SELECT "mv " || audio || " /var/www/staticdata/vav.mbirgin.com/word/ar/" || tblword.id ||".mp3" FROM tblword, dbx.tbl_commonwords WHERE tblword.word=dbx.tbl_commonwords.ArabicWord AND tblword.mean=dbx.tbl_commonwords.EnglishMeaning LIMIT 1111;
DETACH dbx;

---

update flag for words .. mark there is an audio pronunciation

ATTACH '/var/www/ovz/quran-vocabulary/vocabulary.db' AS dbx;

UPDATE tblword SET flag=(flag|4)
WHERE langword="ar" AND langmean="en" AND id IN (SELECT tblword.id FROM tblword, dbx.tbl_commonwords WHERE tblword.word=dbx.tbl_commonwords.ArabicWord AND tblword.mean=dbx.tbl_commonwords.EnglishMeaning LIMIT 1111);

DETACH dbx;



FELData.db FunEasyLearn Sqlite DB:

select * from words where languageID IN(16,3,59) order by mediaid limit 111;



kranirab2 SQLite DB:

select * from kelimeler t1, irabtable t2 WHERE t1.arapca=t2.arapca GROUP BY t1.harekesiz ORDER BY tekrarsayisi DESC LIMIT 22;

Verileri INSERT için hazırlamak.

$ sqlite3 db.sqlite
sqlite> .output out.txt;
sqlite> select '("'||harekesiz ||'","'|| anlam ||""",'misti',0,'ar','tr')," from kelimeler t1, irabtable t2 WHERE t1.arapca=t2.arapca AND tekrarsayisi>9 GROUP BY t1.harekesiz ORDER BY tekrarsayisi DESC LIMIT 2222;

---

Elde edilen dosya içeriği kullanılarak şu şekilde INSERT yapılabilir:

insert into tblword (word, mean, username, flag, langword, langmean) VALUES ....

Eklenen bu kelimeler daha sonra bir listeye eklenebilir.

insert or ignore into tblvirtualword (idword, idwordset, username)
select id, 499, "m1gin" from tblword where langword="ar" AND username="misti";



http://www.houseofquran.com/qsys/quranteacher1.html

recitors[0].audiodir
//"http://1c.houseofquran.com/01/"

WINFO[84163]
(5) [73, 13, "73S_13_2.mp3", "84162", "84164"]

Load WINFO

http://www.houseofquran.com/qsys/include/073.js

Quran Arabic Text and word id

http://www.houseofquran.com/qsys/text/qtext29.js



WINFO[84163][2]
"73S_13_2.mp3"

Audio: http://1c.houseofquran.com/01/73S_13_2.mp3


QTEXT[5242]="تَبَـٰرَكَ ٱلَّذِى بِيَدِهِ "


---------------------


Verse audio example:
https://everyayah.com/data/English/Sahih_Intnl_Ibrahim_Walk_192kbps/031033.mp3

Add to: