vbAdvanced Bible Search

[tcs]

Been awhile since I posted anything so figured I would share this.

This is a mod of phpBible to work with vbAdvanced. I made many changes to the original but not the SQL files under GNU General Public License per original authors guidelines.

This hack will allow you to add a Searchable bible to your site. The AV KJV is the Bible SQL included.

In the config.php you need to be sure to leave the 'MySql:' comment in place.
Read the instructions included carefully.

As with all hacks the responsibly to your site is yours.

You can see it at http://www.maysvillekybbs.com/index.php?maysbbs=bible

Login as
user 'test'
password 'test'

I will support this add on since I made some changes to the php and how the Database connects.

FOR PEOPLE WITHOUT vbAdvanced down load both files and follow the instructions in Bible to add the tables and data. Then follow instruction in the NON_vbAdvanced file.

This hack will work without vbAdvanced installed.

[Bolas]

wooops... the sshot is too small! :(

[tcs]

lol, I can't be good at everything.

Try the new image I just uploaded.

[Holidazed]

Do you have a version of this for those of us not using vbadvanced?

[Remi]

Do you have a version of this for those of us not using vbadvanced?

Thanks

[rex_b]

Thanks


Yes they do. It's called phpbible which is awesome. I use it here:

http://www.religiousforums.com/bible/

[Holidazed]

Well, I want a hack that allows me to embed the phpBible into my vbb without having to have vbadvanced. How do I do that?

[tcs]

Added a quick update for people without vbAdvanced. Just for you bitg, lol

Hope you enjoy and get good use with it.

This is phpBible just modified to work with vBulletin and vbAdvanced.

[Holidazed]

Added a quick update for people without vbAdvanced. Just for you bitg, lol

Hope you enjoy and get good use with it.

This is phpBible just modified to work with vBulletin and vbAdvanced.
Thank you.

~clicks install

[The Markus]

subscribing so I can install after I finish this other hack....

[Holidazed]

tcs, I installed the original bible addon just as your instructions state and then followed the instructions in the non-vbadvanced addon. However, when I goto http://www.hidingplace.com/forums/bible.php the following error:

Fatal error: Cannot instantiate non-existent class: adodb_hidingplace_com in /path/to/my/bible/adodb/adodb.inc.php on line 424

That section of the adodb.inc.php file says:


423: $cls = 'ADODB_'.$ADODB_Database;
424: $obj = new $cls();
425: if ($errorfn) {
426: $obj->raiseErrorFn = $errorfn;
427: }
428: return $obj;
429: }


Ideas?

[tcs]

Posting to let you know I am looking into what it might be.

make sure you have all the database uploaded.

make sure that the config.php om the bible folder points to (mysql:"Your DB Here")

It is important that the 'mysql:' be inserted before the database name is typed.

[Holidazed]

That was exactly it. My line did not have the mysql:

Thank you

[tcs]

Your welcome bro.
It's amazing that I have no less than 30 different people ask me to send them this hack.

So rather than send it out I choose to post it here and no one is installing it. Strange.

[Holidazed]

I installed it.

[tcs]

Cool, and thanks

[boo.3]

nice!

[mikehawk]

I'm a hardcore noob.

Installation Instructions
=========================
1) Load the database tables. Use a tool like phpMyAdmin to load the sql scripts.
This will install the tables 'bible' and 'books' into your DB by default.
The configuration assumes a DB name of 'bible', but you can use a different
DB name and update the configuration accordingly below.
I put the table in my my main DB for my forums and it works fine.

phpMyAdmin? I made a folder "bible" in my forum directory and uploaded the files. Now how do I do this?

thx

[tcs]

You can do a search here on phpmyadmin and you will find instructions on how to do this. I have seen it here before.

[mikehawk]

You can do a search here on phpmyadmin and you will find instructions on how to do this. I have seen it here before.

Holy crap... I'm way too much of a noob... I downloaded phpmyadmin and have no clue how to set it up... I tried editing it and its jibberish to me. :disappointed:


Is there anyway I could make the database without PHPmyadmin?

[tcs]

Does this work with vb3.07 w/ vbadvanced?
Thanks a bunches!


This is what I have it set up on. Should work fine.

[smacklan]

Thanks...works great! You can see it in action at my site as well.

Clicked - Installed

[mcncyo]

I am getting an error in my page

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 '-1' at line 1

[Marco van Herwaarden]

Please Copy&Paste the full error message.

[suryoyena]

Cool mod!

Where can I find the avkjv.sql in other translations? I need a german one.

[boo.3]

you from Maysville KY?

i'm from Lex going to ride ATV's at Big Rock maybe this Sat

[tcs]

Maysville Ky. Proud. Nice to see a fellow ky'ian.

I will see if I can find a different translation Suryoyena

[Holidazed]

Is this mod going to be re-written for vBB v3.5? I love this addition and would hate to lose it.

[tcs]

It doen't reqiure any VB Autthentication so should work fine. I will update it for vbAdvance CPMS.

Thanks for reminding me.

[davidw]

I am getting an error in my page

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 '-1' at line 1
Same here.

You can see it in action here:

http://www.christianboards.org/index.php?page=bible

[tcs]

I will be upgrading to 3.5 this weekend and will check it out.

[Mastar]

I did what the instructions said as I understand it (it wasn't that clear) I entered the avkjv.sql manually because its too big to upload in phpadmin, I created the templateand I ran the link http://www.*****.com/bible.php and came back with a blank page.

Any suggestions?? vb3.09

This is what the edited portion of the config.php looks like -->>

$MM_bible_HOSTNAME = "localhost"; //Replace with mySQL host name
$MM_bible_USERNAME = "my mysql is here"; //Replace with your mySQL user
$MM_bible_PASSWORD = "my pass here"; //Replace with your mySQL password
$MM_bible_DATABASE = "mysql:bible"; //Name of bible db - Be Sure to LEAVE 'mysql: IN PLACE'
$MM_bible_tab_pre = ""; //Prefix for tables (optional e.g. 'bib_')
$MM_bible_DBTYPE = preg_replace("/:.*$/", "", $MM_bible_DATABASE);
$MM_bible_DATABASE = preg_replace("/^.*?:/", "", $MM_bible_DATABASE);

I upload all files in a folder that I created named 'bible' Then I used the non vbadvance instructions....

[tcs]

I installed vb 3.5 and could not find any errors with the bible system. I will be updating some issues to make it easier to install in the next few weeks,

[Holidazed]

Is this mod going to be re-written for vBB v3.5? I love this addition and would hate to lose it.

Any idea on my earlier comment?

[tcs]

It works great as is for vb 3.5.1 which is what I am on. It does not really integrate with VB so should change a thing. It is an add on to VB.

[davidw]

I am still having issues with it - I uninstalled it and in regards to the last post I decided to reinstall it - yet I think its issue is related to the $MM_bible_DATABASE = "mysql:"; part. I can't think for the life of me why nothing I've put in there works (I've tried several variants of what it could be) - still same error message.
I'll play around with it a bit to see if I can get it to work. :)

[tcs]

I am still having issues with it - I uninstalled it and in regards to the last post I decided to reinstall it - yet I think its issue is related to the $MM_bible_DATABASE = "mysql:"; part. I can't think for the life of me why nothing I've put in there works (I've tried several variants of what it could be) - still same error message.
I'll play around with it a bit to see if I can get it to work. :)

It is, You need to add you database login information in there. The same that is in your /includes/config.php

I can help you if you want to pm me an email address.

[davidw]

You have a pm with my email - I won't be on but maybe a half-hour later (as I usually do my site work during the day).

[imported_pmay68]

Works perfectly on Gatheringchristians.com THANKYOU!!!!!

[PGAmerica]

Is there a 3.7.0 version of this?

[tcs]

This version still works great even on 3.7.0

[PGAmerica]

Maybe you should post it in those forums as it is misleading to only have it here.

[PGAmerica]

I installed the module exactly as your instructions said and when I activate the module on my vba home page, I get the following error.
_____________________________
on line Fatal error: Cannot instantiate non-existent class: adodb_hidingplace in /pathtomyforums/bible/adodb/adodb.inc.php424
_____________________________
Ideas?

In addition, when I do the non-vba mod addition, the bible.php file displays a blank page.

[PGAmerica]

Well, it is a moot point now. I went to www.biblesupersearch.com and downloaded their free bible search program. A little bit of modification and it works perfectly in my forum.

See for yourself.
http://www.hidingplace.com/forums/Bible_SuperSearch_vb.php