Miscellaneous Hacks - Glorious Qur'an

As-Salamu 'Alaykum (peace be upon you)

What is Qur'an? Muslims believe that the Qur'an is words of God which He revealed to His last Prophet and Messenger, Muhammad (peace be upon him).

This mod will be further updated and supported in 3.8 section, here

I've decided to share this mod upon the request of few users. This mod should work on 3.7 and 3.6. I don't know about 3.5 or lower versions.

Mod Description: This mod lets the users on your board read the Glorious Qur'an in Arabic and interpretation of the meaning in 25 different languages.

You can find the readme file in the attached file and vbseo version can also be found in the attached file.

Install time: approx 2-3 mins.
Manual Template Edits: 2
Settings: 2[/b]

Demo Link: http://www.islamic-life.com/forums/quran/

FAQ

Question: Can you please translate this mod in language "A"?
Answer: This mod contains 25 different languages: Albanian, Azerbaijani, Bosnian, Brazilian, Dutch, 3 English, Finnish, French, German, Indonesian, Italian, Japanese, Latin, Malaysian, Mexican, Polish, Portugese, Russian, Spanish, Swahili, Thai, Transliteration, Turkish, 2 Urdu. So, please do not request for a language if it can be found in this list.

Mod History:

Version 1.0
-Display the Qur'an in Arabic and English interpretation of the meaning (by Imam Pickthall - May Allah have mercy on him).
-Longer Surahs are handled in multiple pages
-Jump to a Surah functionality

Version 1.05
-Display Arabic text in charset UTF-8 instead of windows-1256
-Fixed bug: WOL (Who's online) not showing Surah's name

Version 1.05a
-Fixed Bug: incorrect database table name

Version 1.25
-Fixed SQL Injection and XSS flaws
-Added meaning of the Qur'aan in 24 different languages and 28 in total
-Added 2 Setting options
- Set default language for your forum
- Set number of ayaat to display on one page
-Added Different Colours for some of the languages
-User's selection of different languages is handled using AJAX

-Known Bugs and Limitations
- The Qur'aan (Arabic text) is fixed as default.
- Weird character maybe displayed for some of the languages
- Multiple Page selection destroys the use of AJAX; so users have to reselect the languages
if they were viewing the meaning of the Qur'aan in non-default languages.

Standing Features:

1 - Search
[s]2 - More languages[/s]
[s]3 - More English interpretations[/s]
4 - MP3 Recitations for each Surah by known Qaris
5 - Display text between two ayaat upon users' selection
6 - Allow users to set number of ayaat to display on one page
7 - Add Bangla and Chinese languages

This is brought to you by islamic-life.com and please click on install if you install this mod. Jazak Allah khair (May Allah grant you goodness) and have a good Ramadan!

[Veer]

Query:

SELECT ayat_en3 FROM community_quran WHERE chpNo = 1

Result:

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1054 
error desc: Unknown column 'ayat_en3' in 'field list'

I'm also getting database errors:

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT * FROM community_quran WHERE chpNo = 1 ORDER BY ayatNo ASC LIMIT 0,;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number  : 1064

Request Date  : Friday, October 3rd 2008 @ 03:26:30 AM
Error Date    : Friday, October 3rd 2008 @ 03:26:30 AM
Script        : http://www.mydomain.com/quran.php?do=displaysura&sno=1

Referrer      : http://www.mydomain.com/quran/

and this one:

Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT * FROM community_quran WHERE chpNo = 3 ORDER BY ayatNo ASC LIMIT 0,;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number  : 1064

Request Date  : Thursday, October 2nd 2008 @ 08:04:49 PM
Error Date    : Thursday, October 2nd 2008 @ 08:04:49 PM
Script        : http://www.mydomain.com/quran.php?do=displaysura&sno=3

I think i have to uninstall the old version, may be the newer version will work.

[msalman]

^you need to change your character set to utf-8

[Megatr0n]

That causes problems for my forum if I set it to utf-8.

Anyway, around that?

[Nadeemjp]

JAzak Allah Brother for the Japanese Translation.
by the way the zip folder has vbseo folder as well. which one is the latest and which one do you recommend? i have vb3.7.3 version

[Veer]

Originally Posted by msalman

^you need to change your character set to utf-8

Not only Character Set my whole Database (including tables) is in UTF-8

[akulion]

nominated for mod of the month

[msalman]

Originally Posted by Megatr0n

That causes problems for my forum if I set it to utf-8. Anyway, around that?

hmm...if the text for other languages is appearing fine then I can get you the Arabic text in windows-156 format; you'll have to wait for few days though.

Originally Posted by Nadeemjp

JAzak Allah Brother for the Japanese Translation.
by the way the zip folder has vbseo folder as well. which one is the latest and which one do you recommend? i have vb3.7.3 version

Barak Allahu feeka brother. Yes, the vbseo folder has the vbseo version of this mod; the only difference is that it has minor changes (the name of the surah in the url and custom re-write rules).

Originally Posted by Pehchaan

Not only Character Set my whole Database (including tables) is in UTF-8

bro, that comment was for brother megatr0n and it seems his post was deleted. It seems your installation of database and product file wasn't correct; so, try removing it completely (product and files from the server) and re-install it.

Originally Posted by akulion

nominated for mod of the month

lol, Jazak Allah khair

[msalman]

Originally Posted by akulion

hey bro any chance of developing a "random verse" module for vbadvanced ? If not would it be possible to get the PHP code to generate random verses with english translation? That way I could try and see if I can get someone to make the mod over at vbadvanced.com

bro, I don't have vbadvanced on my forum so I can't really test it. To put it simple, I don't know what changes to make in vbadvanced. I can get you the php code but you'll have to ask someone how to include it on vbadvanced.

try this, let me know if this works:

[Megatr0n]

Originally Posted by msalman

hmm...if the text for other languages is appearing fine then I can get you the Arabic text in windows-156 format; you'll have to wait for few days though.

Barak Allahu feeka brother. Yes, the vbseo folder has the vbseo version of this mod; the only difference is that it has minor changes (the name of the surah in the url and custom re-write rules).

bro, that comment was for brother megatr0n and it seems his post was deleted. It seems your installation of database and product file wasn't correct; so, try removing it completely (product and files from the server) and re-install it.

lol, Jazak Allah khair

Jazakullah bro.

[akulion]

thanks for the vbadvanced file bro, the module is added easily using vbadvanced "add a php file as a module" option, it simply had to be uploaded to its modules directory..however the display of the ayah is a bit strange, could you shed some light on to why it may be doing so? It also displays the english verse 2 times for some reason and shows all the variable names in the output

Screen shot: