vb.org Archive - Miscellaneous Hacks

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Miscellaneous Hacks - Glorious Qur'an (https://vborg.vbsupport.ru/showthread.php?t=190497)

Query:

Code:

SELECT ayat_en3 FROM community_quran WHERE chpNo = 1

Result:

Code:

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:

Code:

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:

Code:

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.

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

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

Anyway, around that?

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

Quote:

Originally Posted by msalman (Post 1636057)

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

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

nominated for mod of the month :D

Quote:

Originally Posted by Megatr0n (Post 1636082)

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.

Quote:

Originally Posted by Nadeemjp (Post 1636132)

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).

Quote:

Originally Posted by Pehchaan (Post 1636174)

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.

Quote:

Originally Posted by akulion (Post 1636382)

nominated for mod of the month :D

lol, Jazak Allah khair

Quote:

Originally Posted by akulion (Post 1635857)

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:

Quote:

Originally Posted by msalman (Post 1636414)

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. :D

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:

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01122 seconds Memory Usage 1,750KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: